AI Instructor Live Labs Included

Introduction to Relational Databases with PostgreSQL

Learn relational database fundamentals with PostgreSQL — from creating tables to writing complex queries. Hands-on practice in a live database environment with zero setup required.

Beginner

1d 6h 10m

26 Lessons

PG-100

View badge details

About This Course

Master the fundamentals of relational databases using PostgreSQL the world's most advanced open-source database. Starting from zero, you'll learn to design tables, write SQL queries, build relationships between data, and optimize performance. Every concept is practiced hands-on in a browser-based VS Code environment with a live PostgreSQL database no installation required.

This beginner-friendly course is the ideal foundation for anyone planning to work with Entity Framework Core, build web APIs, or develop SaaS applications with C# and .NET.

Course Curriculum

26 Lessons

AI Lesson

What is a Relational Database?

45m

Learn what relational databases are, why they matter, and how PostgreSQL fits into the picture. Understand tables, rows, columns, and the SQL language.

Lab Exercise

What is a Relational Database? - Lab Exercises

1h 30m 2 Exercises

Connect to PostgreSQL, explore the database with SQLTools, and run your first SQL queries.

Connecting and Exploring Your Database ~20 min

Your First SQL Queries ~25 min

AI Lesson

Creating Tables and Data Types

45m

Learn to create tables with appropriate data types and constraints. Understand how to modify and drop tables.

Lab Exercise

Creating Tables and Data Types - Lab Exercises

1h 30m 2 Exercises

Design and create tables for a client management database with proper data types and constraints.

Designing Tables with Data Types ~25 min

Modifying Tables with ALTER TABLE ~20 min

AI Lesson

Inserting and Retrieving Data

45m

Learn INSERT and basic SELECT statements. Understand how to add data to tables and retrieve it with simple queries.

Lab Exercise

Inserting and Retrieving Data - Lab Exercises

1h 35m 2 Exercises

Populate tables with data and write SELECT queries to retrieve information from the database.

Populating the Client Database ~25 min

Retrieving Client Information ~25 min

AI Lesson

Filtering, Sorting, and Pagination

45m

Master WHERE clause operators, pattern matching with LIKE, NULL handling, ORDER BY, LIMIT, OFFSET, and DISTINCT.

Lab Exercise

Filtering, Sorting, and Pagination - Lab Exercises

1h 25m 2 Exercises

Write advanced queries using comparison operators, pattern matching, sorting, and pagination against the client database.

Filter Queries Practice WHERE clauses with comparison operators, AND/OR/NOT, LIKE/ILIKE patterns, IN, BETWEEN, and NULL checks on the DataBridge Analytics database. ~20 min

Sorting and Pagination Practice ORDER BY with ASC/DESC, multiple column sorting, LIMIT/OFFSET pagination, DISTINCT, and column aliases. ~20 min

AI Lesson

Modifying and Deleting Data

45m

Learn UPDATE, DELETE, and TRUNCATE statements. Understand transactions and how to safely modify data.

Lab Exercise

Modifying and Deleting Data - Lab Exercises

1h 25m 2 Exercises

Practice updating and deleting records safely using transactions and conditional logic.

Updating Records Practice UPDATE with SET and WHERE, multi-column updates, UPDATE with subqueries, and conditional updates on the DataBridge Analytics database. ~20 min

Safe Deletes and Transactions Practice DELETE with WHERE, understand TRUNCATE vs DELETE, use BEGIN/COMMIT/ROLLBACK for transaction safety. ~20 min

AI Lesson

Table Relationships and Foreign Keys

45m

Understand primary keys, foreign keys, one-to-many and many-to-many relationships, and referential integrity.

Lab Exercise

Table Relationships and Foreign Keys - Lab Exercises

1h 25m 2 Exercises

Build related tables with foreign keys and junction tables for the client management database.

Building Related Tables Create tables with primary and foreign keys, establish one-to-many relationships, test referential integrity constraints. ~20 min

Many-to-Many Relationships Create junction tables for many-to-many relationships, configure CASCADE options, explore referential integrity. ~20 min

AI Lesson

Joining Tables

45m

Master INNER JOIN, LEFT JOIN, RIGHT JOIN, FULL JOIN, and self-joins to combine data from multiple tables.

Lab Exercise

Joining Tables - Lab Exercises

1h 30m 2 Exercises

Write multi-table JOIN queries to generate reports combining client, project, and employee data.

Basic Joins Practice INNER JOIN and LEFT JOIN on DataBridge tables, join clients with projects, employees with tasks. ~20 min

Multi-Table Reports Join 3+ tables to build business reports, use self-joins for employee hierarchy, compare JOIN vs subquery approaches. ~25 min

AI Lesson

Aggregation and Grouping

45m

Learn COUNT, SUM, AVG, MIN, MAX aggregate functions with GROUP BY and HAVING clauses.

Lab Exercise

Aggregation and Grouping - Lab Exercises

1h 35m 2 Exercises

Build summary reports and analytics queries using aggregate functions and grouping.

Aggregate Queries Practice using COUNT, SUM, AVG, MIN, and MAX aggregate functions on the DataBridge client management database. ~25 min

Grouping and Business Reports Build real analytics reports using GROUP BY with HAVING clauses to filter grouped results. ~25 min

AI Lesson

Subqueries and Common Table Expressions

45m

Write subqueries, correlated subqueries, and CTEs (WITH clause) for complex data retrieval.

Lab Exercise

Subqueries and Common Table Expressions - Lab Exercises

1h 35m 2 Exercises

Solve complex business questions using subqueries and CTEs against the client management database.

Subqueries in Action Practice scalar subqueries, WHERE subqueries with IN and EXISTS, and correlated subqueries. ~25 min

Common Table Expressions Build readable complex queries using the WITH clause, chain multiple CTEs, and create real-world reports. ~25 min

AI Lesson

Indexes and Query Performance

45m

Understand how indexes work, when to create them, and how to use EXPLAIN ANALYZE to optimize queries.

Lab Exercise

Indexes and Query Performance - Lab Exercises

1h 35m 2 Exercises

Create indexes, analyze query plans with EXPLAIN, and measure performance improvements.

Creating and Using Indexes Create single-column, multi-column, and UNIQUE indexes, then measure their impact on query performance. ~25 min

Reading Query Plans with EXPLAIN Use EXPLAIN ANALYZE to read query plans, identify slow queries, and optimize them with indexes. ~25 min

AI Lesson

Views and Functions

45m

Create reusable views and PostgreSQL functions to simplify complex queries and encapsulate business logic.

Lab Exercise

Views and Functions - Lab Exercises

1h 35m 2 Exercises

Build views for reporting dashboards and functions for business logic in the client management database.

Creating and Using Views Create regular views for reporting, updatable views, and materialized views with REFRESH. ~25 min

Writing PostgreSQL Functions Write SQL functions, PL/pgSQL functions with control flow, and stored procedures for the DataBridge database. ~25 min

AI Lesson

Database Design and Normalization

45m

Learn database design principles, entity-relationship modeling, and normalization from 1NF through 3NF.

Lab Exercise

Database Design and Normalization - Lab Exercises

1h 45m 2 Exercises

Analyze poorly designed tables, identify normalization violations, and restructure them into proper 3NF design.

Identifying and Fixing Normalization Violations ~30 min

Designing a Database from Requirements ~30 min

AI Lesson

Capstone Briefing - Build a Complete Database

30m

Review all concepts and receive the requirements for designing and building a complete database from scratch.

Lab Exercise

Capstone: Build a Complete Database

2h 15m 1 Exercises

Design and implement a complete PostgreSQL database for a real-world scenario, demonstrating mastery of all course concepts.

SoundWave Music Streaming Database ~90 min

This course includes:

24/7 AI Instructor Support
Live Lab Environments
13 Hands-on Lessons
Completion Badge

Earn Your Badge

Complete all lessons to unlock the Introduction to Relational Databases with PostgreSQL achievement badge.

Skill Level Beginner

Total Duration 1d 6h 10m

Introduction to Relational Databases with PostgreSQL

About This Course

Course Curriculum

What is a Relational Database?

What is a Relational Database? - Lab Exercises

Creating Tables and Data Types

Creating Tables and Data Types - Lab Exercises

Inserting and Retrieving Data

Inserting and Retrieving Data - Lab Exercises

Filtering, Sorting, and Pagination

Filtering, Sorting, and Pagination - Lab Exercises

Modifying and Deleting Data

Modifying and Deleting Data - Lab Exercises

Table Relationships and Foreign Keys

Table Relationships and Foreign Keys - Lab Exercises

Joining Tables

Joining Tables - Lab Exercises

Aggregation and Grouping

Aggregation and Grouping - Lab Exercises

Subqueries and Common Table Expressions

Subqueries and Common Table Expressions - Lab Exercises

Indexes and Query Performance

Indexes and Query Performance - Lab Exercises

Views and Functions

Views and Functions - Lab Exercises

Database Design and Normalization

Database Design and Normalization - Lab Exercises

Capstone Briefing - Build a Complete Database

Capstone: Build a Complete Database

This course includes:

Earn Your Badge

Introduction to Relational Databases with PostgreSQL

Skills You'll Earn