Overview
-
Learn how to set up and work with PostgreSQL, one of the world’s most popular open-source database platforms. Learn how to build a database, retrieve data with queries, and more.
Syllabus
-
Introduction
- Manage relational data with PostgreSQL
- Using the exercise files
- What is PostgreSQL?
- Download and install PostgreSQL
- Connect to the server with psql
- Browse the server with a graphical interface
- Create objects with pgAdmin
- Challenge: Create a table
- Solution: Create a table
- The structure of a database table
- PostgreSQL native data types
- Join tables together with relationships
- 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
- 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
- Add indexes to a table
- Automatically fill in default values
- Constrain acceptable input values
- Challenge: Add data constraints
- Solution: Add data constraints
- User accounts and roles
- Grant privileges to a role
- Back up and restore a database
- Start and stop the server
- Additional resources
