Teach on Udemy

Turn what you know into an opportunity and reach millions around the world.

Learn More

Your cart is empty.

Keep shopping

SQL and PostgreSQL: A Practical Course

Name: SQL and PostgreSQL: A Practical Course
Rating: 4.5 (44 reviews)

Master SQL and database skills from beginner to advanced levels: theory and hands-on practice with exercises.

Created byDenis Suchkov

Last updated 5/2025

English

ArabicEnglish

What you'll learn

Learn the fundamentals of relational databases using one of the most popular DBMSs - PostgreSQL
Master writing fast and efficient SQL queries, from basic to advanced, using JOIN, GROUP BY, and window functions
Apply your knowledge through hands-on practice with various quizzes and exercises
Explore advanced topics, including transaction management and index building

Coding Exercises

This course includes our updated coding exercises so you can practice your skills as you learn.

Course content

11 sections • 56 lectures • 2h 38m total length

Course Overview and Tips for Success2:17
Database Fundamentals2:16
Installing PostgreSQL on Windows2:26
In this lesson, we will cover how to install PostgreSQL on a Windows computer.
For connecting to a database using pgAdmin 4, see the lesson "Installing and Brief Overview of pgAdmin".
Installing PostgreSQL on Mac1:38
In this lesson, we will cover how to install PostgreSQL on a Mac OS computer.
For connecting to a database using pgAdmin 4, see the lesson "Installing and Brief Overview of pgAdmin".
Installation and Brief Overview of pgAdmin3:59

What is SQL?0:49
Overview of SQL Syntax and Database Creation3:55
CREATE TABLE2:59
INSERT3:57
Adding data from Excel via pgAdmin5:25
Test: Creating and Inserting Data into a Table
SELECT4:15
SQL: Retrieving Data from a Table
SQL: Retrieving Data from a Table – Sorting and Uniqueness
JOIN5:44
SQL: Table Joins – JOIN
SQL: Table Joins – LEFT JOIN
GROUP BY3:46
SQL: GROUP BY
UPDATE1:07
DELETE0:53
Test: Modifying and Deleting Data

Creating and Deleting Tables2:23
Default Values1:59
Check Constraints2:17
NOT NULL Constraint0:19
Apply the not null constraint to ensure columns never hold null values and must be initialized, such as product names or other constrained columns, in sql and PostgreSQL.
UNIQUE Constraint1:04
Discover how unique constraints enforce column or group uniqueness in PostgreSQL, with automatic unique indexes, table constraints, and nullable behavior adjustable via NULLS not distinct.
Test: Constraints
Primary Key1:33
Learn how to define a primary key in PostgreSQL, converting unique not null constraints to a primary key, and understanding how primary keys enforce uniqueness and non-nullness.
Foreign Key5:54
Modifying Existing Tables – ALTER TABLE7:07
Test: Creating, Deleting, and Modifying Tables

Retrieving Data – SELECT3:11
Test: Using Aliases
SQL: Retrieving Data – SELECT
FROM Clause3:36
Joining Tables – JOIN7:25
SQL: Joining Tables – JOIN I
SQL: Joining Tables – JOIN II
Filtering Data – WHERE1:54
SQL: Filtering Data – WHERE
Grouping and Post-Filtering – GROUP BY and HAVING4:48
SQL: Grouping and Post-Filtering – GROUP BY and HAVING
Window Functions4:32
Explore window functions that compute across related rows without grouping, using partition by department and the over clause; rank and average salary examples.
Test: Window Functions
Combining Queries – UNION, INTERSECT, EXCEPT3:15
Sorting – ORDER BY2:15
SQL: Sorting – ORDER BY
LIMIT and OFFSET1:07
Learn to retrieve a subset of rows with limit and offset, implement pagination, and return data in manageable chunks for performance.
Test: LIMIT and OFFSET
VALUES Lists1:05
Common Table Expressions – WITH5:43
Test: Common Table Expressions – WITH

Introduction0:44
Numeric types2:19
Test: Numeric Types
Character types1:21
Explore PostgreSQL character types: CHAR fixed-length with space padding, errors when a string exceeds the defined length N; VARCHAR variable-length without padding, up to N; TEXT offers unlimited, flexible storage.
Test: Character Types
Date and time2:46
Test: Date and time
Boolean type0:39
Understand PostgreSQL's boolean data type, which stores true, false, and null, with true and false preferred. String literals like 'true' or '1' map to true, and '0' maps to false.
Test: Boolean type

Introduction0:49
Explore the core functions and operators in PostgreSQL, beyond the SQL standard, and learn how they perform calculations, transform data, and evaluate conditions with both table and non-table values.
Logical operators2:33
Comparison Operators3:16
Test: Comparison Operators
Mathematical Functions and Operators4:12
Master PostgreSQL's mathematical operators and bitwise functions across numeric types such as SMALLINT, INTEGER, BIGINT, REAL, and DOUBLE PRECISION, and use ABS, CEIL, FLOOR, ROUND, RANDOM, RANDOM_NORMAL, and SETSEED.
String Functions and Operators5:48
Explore string functions and operators in PostgreSQL, including the concatenation operator, trimming with btrim, case conversion with lower and upper, padding with lpad and rpad, and substring and position operations.
Test: String Functions and Operators
Date and Time Functions and Operators4:53
Test: Date and Time Operators and Functions

Requirements

No programming experience is required. The course covers everything you need for successful learning.

Description

Learn SQL Quickly and Effectively

This course is the English version of my original top-rated Russian course.

All lessons include full subtitles in: English, Español, Português, Français, العربية, हिन्दी, Bahasa Indonesia, Türkçe, ภาษาไทย, and Tiếng Việt — making it ideal for learners from around the world who prefer to follow along in their native language.

This version was created to make the content accessible for non-native English speakers, especially those who benefit from clear and accurate subtitles.

Whether you're just starting out or want to strengthen your SQL fundamentals, this course will help you master one of the most in-demand database systems — PostgreSQL.

What you'll learn in this course:

Database fundamentals: Understand the structure of relational databases and learn the basics of database organization and management.
Database creation and management with SQL and PostgreSQL: Master creating databases, tables, and managing them using the powerful tools and features of SQL and PostgreSQL.
Efficient SQL queries for data manipulation: Learn how to write SQL queries to retrieve, sort, filter, and perform complex data operations.
Transactions and indexing: Master the use of transactions to ensure data integrity and indexes to speed up query execution.

Why choose this course:

The course features practical demonstrations and numerous real-world examples to help you better understand the material. You’ll engage in hands-on exercises and quizzes to reinforce your knowledge and assess your understanding independently. The course provides market-relevant knowledge, making you a competitive professional in the field of databases. These skills will help you enhance your current professional opportunities and unlock new career paths.

Who this course is for:

Beginners who want to learn SQL and PostgreSQL from scratch
Developers and analysts seeking to deepen their knowledge
Anyone interested in effectively managing and analyzing data

Join the course and start your journey to mastering SQL and PostgreSQL today!

Who this course is for:

This course is designed for a broad audience seeking to learn the fundamentals of working with relational databases.

SQL and PostgreSQL: A Practical Course

What you'll learn

Explore related topics

Coding Exercises

Course content

Introduction5 lectures • 13min

Quick Start with SQL: Part I10 lectures • 33min

Quick Start with SQL: Part II3 lectures • 13min

Intermediate Assessment1 lecture • 1min

Data Definition Language (DDL)8 lectures • 23min

Data Manipulation Language (DML)4 lectures • 7min

Data Query Language (DQL)11 lectures • 39min

Downloads & Resources1 lecture • 1min

Data Types5 lectures • 8min

Functions and Operators6 lectures • 22min

Requirements

Description

Who this course is for: