Instructor-led training

Introduction to SQL Using PostgreSQL Training in Guttenberg, New Jersey

The Introduction to SQL with PostgreSQL course provides an in-depth introduction to SQL and relational databases, focusing on PostgreSQL as the database management system.

Request a Training Proposal View Course Outline

What you'll learn

The Introduction to SQL with PostgreSQL course provides an in-depth introduction to SQL and relational databases, focusing on PostgreSQL as the database management system. The course covers essential topics such as querying and sorting data, filtering records with WHERE, advanced SELECT statements, subqueries, joins, unions, and conditional processing using CASE. Students will also learn to insert, update, and delete records, and create tables in PostgreSQL. Through hands-on exercises and real-world examples, learners will gain the skills necessary to perform effective data analysis using SQL and PostgreSQL.

Prerequisites

None

Course Outline

Relational Database Basics
1. Brief History of SQL
2. Relational Databases
3. PostgreSQL
Simple SELECTs
1. Introduction to the Jokes Database
2. Some Basics
3. SELECTing All Columns in All Rows
4. Running Queries in pgAdmin
5. Exploring the Tables (Exercise)
6. SELECTing Specific Columns
7. SELECTing Specific Columns (Exercise)
8. Sorting Records
9. Sorting Results (Exercise)
10. The WHERE Clause and Logical Operator Symbols
11. Using the WHERE Clause to Check for Equality or Inequality (Exercise)
12. Checking for Greater or Less Than
13. Using WHERE to Check for Greater or Less Than (Exercise)
14. Checking for NULL
15. Checking for NULL (Exercise)
16. WHERE and ORDER BY
17. Using WHERE and ORDER BY Together (Exercise)
18. Checking Multiple Conditions with Boolean Operators
19. Writing SELECTs with Multiple Conditions (Exercise)
20. The WHERE Clause and Logical Operator Keywords
21. More SELECTs with WHERE (Exercise)
Advanced SELECTs
1. LIMIT and OFFSET
2. Calculated Fields
3. Calculating Fields (Exercise)
4. Aggregate Functions and Grouping
5. Working with Aggregate Functions (Exercise)
6. Selecting Distinct Records
7. Built-in Data Manipulation Functions for Math and Strings
8. Data Manipulation Functions for Math and Strings (Exercise)
9. Date/Time Types, Operators, and Functions
10. Date/Time Manipulation (Exercise)
Subqueries, Joins and Unions
1. Subqueries
2. Subqueries (Exercise)
3. Joins
4. Using Joins (Exercise)
5. Outer Joins
6. Using Outer Joins (Exercise)
7. Unions
8. Working with Unions (Exercise)
Conditional Processing with CASE
1. Using CASE
2. Working with CASE (Exercise)
Inserting, Updating and Deleting Records
1. INSERT
2. Inserting Records (Exercise)
3. UPDATE
4. DELETE
5. Updating and Deleting Records (Exercise)
Creating Tables
1. Creating a Database with pgAdmin
2. How to Create Tables
3. Creating Tables (Exercise)
4. CASCADE and RESTRICT
5. Using CASCADE (Exercise)

Training locations

Introduction to SQL Using PostgreSQL training across the U.S. and beyond.

We provide Introduction to SQL Using PostgreSQL training onsite and live online for organizations throughout the United States and internationally.

View all Introduction to SQL Using PostgreSQL training locations

Ready to train your team?

Let's customize this training for your organization.

Tell us about your employees, your goals, and your preferred schedule. We'll prepare a training proposal covering scope, delivery format, and pricing.

Request a Training Proposal

or call 303.377.6176