PostgreSQL Essential Training

PostgreSQL Essential Training
PostgreSQL Essential Training
English | MP4 | AVC 1280×720 | AAC 44KHz 2ch | 2h 43m | 371 MB

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.

Table of Contents

1 Manage relational data with PostgreSQL
2 Using the exercise files
3 What is PostgreSQL
4 Download and install PostgreSQL
5 Connect to the server with psql
6 Browse the server with a graphical interface
7 Create objects with pgAdmin
8 Challenge Create a table
9 Solution Create a table
10 The structure of a database table
11 PostgreSQL native data types
12 Join tables together with relationships
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
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
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
31 User accounts and roles
32 Grant privileges to a role
33 Back up and restore a database
34 Start and stop the server
35 Additional resources