Introduction to PostgreSQL

Course Overview

Modern companies are generating more data every day, and key competitive advantages will stem from being able to query and understand this data. Data is often stored in relational databases, which are queried using a specific language: SQL. SQL, which stands for Structured Query Language, allows communication with relational databases and is one of the most demanded tech skills of the 21st century.

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.

This course includes 6-months access to the full course content in on-demand format to support post-class reference and review.

Course Objectives

Get started with PostgreSQL and PgAdmin
two of the world's most popular SQL tools
Learn the basics of SQL syntax
Analyze data using aggregate functions with GROUP BY commands
Run advanced queries with string operations and comparison operations
Learn to use logical operators to add logic flow to your SQL queries
Learn common SQL JOIN commandsv
Learn to create tables and databases with constraints on data entries

Course Outline

SQL Syntax

Setup of PostgreSQL

Setup of PgAdmin – a powerful administration tool

Use SQL to query data:

Data Extraction from databases
GroupBy for data aggregation
Merging data via Joins
Advanced queries, such as comparisons
Using logical operators to add logical flow
Conditional expressions

Creation of databases and tables

Data Types
Primary and Foreign Keys
Data Insertion
Data Alteration
Data Deletion
Administration

Combination of PostgreSQL and Python

< Back to Course Search

Class Dates & Times

Class times are listed Eastern time

This is a 2-day class

Class dates not listed.
Please click here to contact us for available dates and times.

The classes listed are available to all United Training customers and does not reflect, in any way,
the availability or support of technology within the University of Maine System.