Introduction to PostgreSQL

Price
$2,000.00 USD

Duration
2 Days

Delivery Methods
Virtual Instructor Led
Private Group

Request More Information

Download Course Details

Course Details Only
Course Details & Schedule

Skip to Class Dates

Course Overview

What good is a terabyte of data if no one knows how to query it? Over 60% of hiring managers ranked SQL as one of the top three most in-demand skills, with PostgreSQL leading among open-source relational database systems. Knowing how to work with relational data, write queries, and manage databases is essential for teams building modern data solutions.

This hands-on PostgreSQL tutorial teaches you how to use PostgreSQL to query, create, and manage databases using SQL. You’ll work directly with a relational database, gain experience with real-world database management techniques, and learn how to integrate PostgreSQL with Python for automation and reporting.

Private classes on this topic are available. We can address your organization’s issues, time constraints, and save you money, too. Contact us to find out how.

Course Objectives

This course is designed to give learners a practical introduction to PostgreSQL. You’ll also gain context around how PostgreSQL compares to other RDBMS tools like MySQL, Oracle, and MongoDB, and understand what makes Postgres uniquely flexible with features like JSON support and robust constraint handling.

Set up and connect to a PostgreSQL database using standard tools
Write SQL queries to extract, filter, and aggregate relational data
Create and manage structured databases and tables with constraints
Integrate PostgreSQL with Python to automate and extend your workflow

Top-rated instructors: Our crew of subject matter experts have an average instructor rating of 4.8 out of 5 across thousands of reviews.
Authorized content: We maintain more than 35 Authorized Training Partnerships with the top players in tech, ensuring your course materials contain the most relevant and up-to date information.
Interactive classroom participation: Our virtual training includes live lectures, demonstrations and virtual labs that allow you to participate in discussions with your instructor and fellow classmates to get real-time feedback.
Post Class Resources: Review your class content, catch up on any material you may have missed or perfect your new skills with access to resources after your course is complete.
Private Group Training: Let our world-class instructors deliver exclusive training courses just for your employees. Our private group training is designed to promote your team’s shared growth and skill development.
Tailored Training Solutions: Our subject matter experts can customize the class to specifically address the unique goals of your team.

Learning Credits: Learning Credits can be purchased well in advance of your training date to avoid having to commit to specific courses or dates. Learning Credits allow you to secure your training budget for an entire year while eliminating the administrative headache of paying for individual classes. They can also be redeemed for a full year from the date of purchase. If you have previously purchased a Learning Credit agreement with New Horizons, you may use a portion of your agreement to pay for this class.

If you have questions about Learning Credits, please contact your Account Manager.

Agenda

Setup of PostgreSQL

Install and configure PostgreSQL on your local machine
Create a database and connect to it using psql
Explore Postgres user roles and permissions
Use PostgreSQL to manage schemas in an RDBMS context

Use SQL to Query Data

Learn SQL syntax to retrieve and filter relational data
Analyze results using aggregate functions and GROUP BY
Merge data across tables using JOINs
Use string operations, logical operators, and conditional expressions
Compare PostgreSQL’s query syntax to MySQL, Oracle, and MongoDB alternatives

Creation of Databases and Tables

Create and manage new databases and structured tables
Apply data types and constraints like primary/foreign keys
Insert, update, and delete records with SQL
Ensure relational integrity across multiple tables

Combination of PostgreSQL and Python

Connect a PostgreSQL database to Python scripts
Use libraries to query, retrieve, and process data
Automate reporting tasks and lightweight ETL
Demonstrate how PostgreSQL supports integration for real-world automation

Get in touch to schedule training for your team
We can enroll multiple students in an upcoming class or schedule a dedicated private training event designed to meet your organization’s needs.