PostgreSQL Essential Training (2020)

Course details

PostgreSQL is one of the world’s most popular open-source database platforms. This highly flexible and scalable relational database management system (RDBMS) supports everything from general purpose databases to machine learning applications and geospatial map servers. In this course, instructor Adam Wilbert helps you get up and running with PostgreSQL. Adam covers the essential first steps of setting up a PostgreSQL server and working with the graphical interface, pgAdmin. He then shows how to work with pgAdmin to create new database objects, populate them with data, and retrieve records from the database. If you're new to the platform (or relational databases in general), this course serves as an entry point and provides a solid foundation for further exploration in database administration.

Concepts

0. Introduction

01 - Manage relational data with PostgreSQL
02 - Using the exercise files

1. Getting Started with PostgreSQL

03 - What is PostgreSQL
04 - Download and install PostgreSQL
05 - Connect to the server with psql
06 - Browse the server with a graphical interface
07 - Create objects with pgAdmin
08 - Challenge - Create a table
09 - Solution - Create a table

2. An Introduction to Relational Databases

10 - The structure of a database table
11 - PostgreSQL native data types
12 - Join tables together with relationships

3. Building a Database

13 - Organize tables with schemas
14 - Create a table with pgAdmin
15 - Link primary and foreign keys
16 - Enforce referential integrity on related records
17 - Challenge - Execute a command on the Postgres server
18 - Solution - Execute a command on the Postgres server

4. Retrieve Information with Queries

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

5. Managing Data

26 - Add indexes to a table
27 - Automatically fill in default values
28 - Constrain acceptable input values
29 - Challenge - Add data constraints
30 - Solution - Add data constraints

6. Database Administration in PostgreSQL

31 - User accounts and roles
32 - Grant privileges to a role
33 - Back up and restore a database
34 - Start and stop the server

Conclusion

35 - Additional resources

PostgreSQL Essential Training (2020)

Authors

Adam Wilbert