PostgreSQL Essential Training

Course details

PostgreSQL is trusted with mission critical information by some of the biggest companies in the world. It’s also highly flexible, which makes it a great choice for data science researchers, educators, nonprofit organizations, and businesses of all sizes. In this course, Adam Wilbert, who has spent the last decade helping people take their first steps in the world of relational databases, introduces you to PostgreSQL. Adam demonstrates how to set up your own server and create a customized relational database. He shows you the features of PostgreSQL that protect your data from unauthorized access, ensure that it’s accurate, and simplify the process of querying information so that you can make actionable decisions. PostgreSQL is a powerful, robust platform. Get started learning how it works!

Concepts

0. Introduction

01 - Manage relational data with PostgreSQL

1. Getting Started with PostgreSQL

02 - What is PostgreSQL
03 - Download and install PostgreSQL
04 - Install PostgreSQL with Docker
05 - Connect to the server with psql
06 - Browse the server with a graphical interface
07 - Connect pgAdmin to Docker
08 - Tour the pgAdmin interface
09 - Use pgAdmin s toolset
10 - Create objects with pgAdmin's dialog workflows

2. An Introduction to Relational Databases

11 - The structure of a database table
12 - PostgreSQL native data types
13 - Join tables together with relationships
14 - Create a table and insert rows of data
15 - Challenge - Create a table
16 - Solution - Create a table

3. Building a Database

17 - Organize tables with schemas
18 - Create a table with pgAdmin
19 - Link primary and foreign keys
20 - Enforce referential integrity on related records
21 - Challenge - Execute a command on the Postgres server
22 - Solution - Execute a command on the Postgres server

4. Retrieving Information with Queries

23 - Import data from a CSV
24 - Retrieve information with a SELECT query
25 - Helpful pgAdmin Query Tool interface elements
26 - Join tables for additional information
27 - Save a query as a database view
28 - Challenge - Import data and write queries
29 - Solution - Import data and write queries

5. Managing Data

30 - Add indexes to a table
31 - Automatically fill in default values
32 - Constrain acceptable input values
33 - Challenge - Add data constraints
34 - Solution - Add data constraints

6. Database Administration in PostgreSQL

35 - User accounts and roles
36 - Grant privileges to a role
37 - Backup and restore a database
38 - Start and stop the server

Conclusion

39 - Next steps

PostgreSQL Essential Training

Authors

Adam Wilbert