Class Central is learner-supported. When you buy through links on our site, we may earn an affiliate commission.

LinkedIn Learning

PostgreSQL Essential Training

via LinkedIn Learning

Overview

Prepare for a new career with $100 off Coursera Plus
Gear up for jobs in high-demand fields: data analytics, digital marketing, and more.
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
1. Getting Started with PostgreSQL
  • 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
2. An Introduction to Relational Databases
  • The structure of a database table
  • PostgreSQL native data types
  • Join tables together with relationships
3. 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
4. Retrieve 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
5. Managing Data
  • Add indexes to a table
  • Automatically fill in default values
  • Constrain acceptable input values
  • Challenge: Add data constraints
  • Solution: Add data constraints
6. Database Administration in PostgreSQL
  • User accounts and roles
  • Grant privileges to a role
  • Back up and restore a database
  • Start and stop the server
Conclusion
  • Additional resources

Taught by

Adam Wilbert

Reviews

4.8 rating at LinkedIn Learning based on 594 ratings

Start your review of PostgreSQL Essential Training

Never Stop Learning.

Get personalized course recommendations, track subjects and courses with reminders, and more.

Someone learning on their laptop while sitting on the floor.