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

Introduction

Manage relational data with PostgreSQL

Getting Started with PostgreSQL

What is PostgreSQL
Download and install PostgreSQL
Install PostgreSQL with Docker
Connect to the server with psql
Browse the server with a graphical interface
Connect pgAdmin to Docker
Tour the pgAdmin interface
Use pgAdmin s toolset
Create objects with pgAdmin's dialog workflows

An Introduction to Relational Databases

The structure of a database table
PostgreSQL native data types
Join tables together with relationships
Create a table and insert rows of data
Challenge - Create a table
Solution - Create a table

Building a Database

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

Retrieving Information with Queries

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

Managing Data

Add indexes to a table
Automatically fill in default values
Constrain acceptable input values
Challenge - Add data constraints
Solution - Add data constraints

Database Administration in PostgreSQL

User accounts and roles
Grant privileges to a role
Backup and restore a database
Start and stop the server

Conclusion

Next steps