PostgreSQL native data types
Course Content
0 / 39 completedDownload and install PostgreSQL
What is 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
Manage relational data with PostgreSQL
The structure of a database table
PostgreSQL native data types
Join tables together with relationships
Create a table and insert rows of data
Solution Create a table
Challenge Create a table
Organize tables with schemas
Create a table with pgAdmin
Enforce referential integrity on related records
Link primary and foreign keys
Challenge Execute a command on the Postgres server
Solution Execute a command on the Postgres server
Retrieve information with a SELECT query
Import data from a CSV
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
Start and stop the server
Backup and restore a database
Next steps