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 Course 2026: SQL for Data Analysis and Data Science.

Name: SQL Course 2026: SQL for Data Analysis and Data Science.
Rating: 3.6 (1104 reviews)

Master the Art of SQL Querying and PostgreSQL for Data Analysis and Data Science An using Real World SQL Database.

Role Play

Created byTemotec Learning Academy

Last updated 5/2026

English

English [Auto],

What you'll learn

Using Real World PostgreSQL Database Airlines Database.
Use Python Pandas to Analyze and visualize Postgres Data Output.
SQL Test Your Self, SQL Challenges, SQL Final Exam and more
Use Python to visualize Postgres Data Output and get your Conclusion about Data.
Use SQL to create databases.
Use Python bs4 & Pandas to Scrape a webpage, Analyze and visualize The Scraped Data.
Use SQL to insert data into a table.
Use SQL to Query & retrieve data from databases.
Use SQL to Sort records after retrieving from databases.
Use SQL to Group data by specific conditions.
Use SQL to Filter data by using where clause.
How & when to use Joins types in SQL.
How to create and deal with Sub-queries in SQL.
How to create and deal with common table expression in SQL.
Use SQL to perform data analysis of real world databases
Use SQL to perform advanced techniques to retrieve data from databases.
Use Python with SQL Postgres database.
Use Python to load Postgres Data Output file.
Apply what you will learn in Python & SQL through exercises.

Course content

33 sections • 114 lectures • 5h 43m total length

Course Introduction4:48
Explore SQL basics for data analysis with Postgres SQL, covering databases, creating tables, queries, aggregation, time data management, joins, subqueries, common table expressions, and views.

PostgreSQL Downloading & Installing3:02
Download and install PostgreSQL on Windows using the graphical installer, set a superuser password, configure port 54322, and skip Stack Builder.
Create Database1:09
Create a database using pgAdmin 4 for PostgreSQL, rename it to Airlines with template zero, and save to activate the database; then open schemas, public, and tables (no tables yet).
Restore Database1:13
Restore the airlines database in PostgreSQL using the PostgreSQL user interface by right-clicking Airlines database, selecting restore, and choosing the SQL file from resources. Then verify it contains eight tables.

Database Overview Part 12:12
Model the airlines data using a main booking table linked to multiple passengers and their tickets. Represent multi-segment and round-trip itineraries with unique boarding passes, seat numbers, and flight numbers.
Database Overview Part 24:00
Explore a multi-table airline database design, including passengers, tickets, bookings, flights, airports, boarding passes, and aircraft, with flight status states and seat classifications.
SQL Data Types1:18
Explore common data types in SQL, including character types such as char and varchar, numeric types like integers and float, date and time types, arrays, and JSON for querying tables.

Select Statement5:00
Master the select statement to query data from tables by listing specific columns in the select clause and the table name in the from clause, avoiding asterisks for performance.
Select Challenge Solution3:00
Demonstrates solving a select challenge by querying all data from all tables and columns in the airlines database, then retrieving specific columns like aircraft_code, model, and range from aircraft.
Select Statement For all Airlines Database Tables3:36
Learn to query data from all columns and tables in the database, executing select statements across airlines, aircraft, airports, boarding passes, and bookings to retrieve columns and row counts.
Distinct1:58
Learn to remove duplicates in a select statement by using distinct, illustrated with timezone data from the airports table to show how the query returns unique time zones.

Where Clause7:21
Learn to use the where clause with select statements to filter rows, apply operators =, >, <, >=, <=, not equal, and combine conditions with and, or, and like.
Operators used with Where Clause4:49
Explore how to use comparison operators with where clauses to filter data, including equal, not equal, greater than, less than, and their inclusive forms.
Where Clause + AND & Where Clause + OR3:20
Learn how to use the where clause with and and or operators to filter a select statement, using aircraft code and fair condition as examples in SQL.
Where Clause + LIKE5:02
Learn to filter data with the where clause and like operator, using wildcards and not like with underscores to match starts, ends, or contains in the model column.
(Where Clause + BETWEEN & IN) & AS6:01
Learn to use the between operator and the in clause in where statements to query ranges and specific value sets, compare with >= and <=, and alias results with as.
Employee Data Request: Using SQL Filters.

LIMIT & ORDER BY7:54
Explore filtering with like patterns (three underscores and percent) in PostgreSQL and control result size with limit and order by, including ascending and descending orders, to retrieve specific ticket records.
FETCH vs LIMIT3:00
Learn how fetch and limit control SQL result sets, using limit for the first rows and offset with fetch to retrieve the next ten from the boarding passes table.
NOT IN4:00
Discover how to apply the not in operator in SQL to filter out specific values, with examples from aircraft and flights data.
ISNULL & IS NOT NULL3:01
Learn to handle null values using is null and is not null in SQL queries, retrieve records from the flights table with or without nulls.
CAST4:00
Master casting in PostgreSQL to convert values between data types. Explore practical examples converting integers, dates, booleans, and time intervals to support data analysis and data science workflows.

COUNT( ) Function, CREATE TABLE & INSERT INTO TABLE4:15
Explore the count() function in SQL, compare count(*), count(column), and understand how null values affect counts; learn to create tables with create table and insert into statements.
SUM( ) Function1:08
Use the sum function to compute the total amount from bookings, by running select sum(total_amount) from bookings, yielding a single line with the total value.
MIN( ) , MAX( ) & AVG( ) Functions2:00
Learn how to use PostgreSQL min, max, and average functions on the bookings table to compute the minimum, maximum, and mean total amount.
GROUP BY & HAVING2:14
Learn to group data with group by and filter aggregated results using having in SQL. Identify cities with more than one airport by counting airports per city.

Requirements

Computer and internet.
No prior knowledge required for this course.

Description

SQL is a powerful language used to retrieve insightful data from databases. Whether you're new to SQL or an experienced data analyst, this complete SQL bootcamp will teach you everything you need to know to become a SQL query expert.

In this comprehensive course, we'll cover everything from the basics of SQL to more advanced topics in PostgreSQL. With real-world examples and hands-on exercises, you'll learn the skills you need to retrieve and analyze data, and practice with quizzes and challenges distributed throughout the course.

By the end of this course, you'll be comfortable using SQL and PostgreSQL for data analysis and data science, and be able to tackle real-world problems with ease.

What you will learn in this course:

- Understand the basics of SQL and PostgreSQL, including installation and table creation.

- Master SQL queries, including SELECT statements, WHERE clauses, operators, and filtering.

- Explore advanced SQL querying techniques, including ORDER BY, LIMIT, DISTINCT, and GROUP BY.

- Learn how to use subqueries and correlated subqueries for advanced data analysis.

- Discover window functions for analytics in SQL, and master table joins and aggregation queries.

- Practice with quizzes and challenges distributed throughout the course.

- Use Python with SQL and PostgreSQL, including loading Postgres data output files and analyzing data with Pandas.

This comprehensive bootcamp is taught by an experienced data science instructor with years of industry experience. He breaks down complex SQL concepts into clear, easy-to-understand lessons using real-world examples and visualization aids.

The course curriculum was designed to take you from absolute beginner to job-ready SQL expert. Each module builds on the last, introducing new SQL clauses and techniques and allowing you to practice them hands-on.

By the end of the course, you will have queried complex datasets and built full SQL queries using subqueries, aggregations, analytical functions, and more. These are the exact skills top employers are looking for in data professionals.

Learning a new skill requires hands-on practice. This bootcamp provides you with downloadable SQL code exercises, mini-projects, and quizzes to test your understanding along the way. Mastering SQL has never been easier!

If you want to become a data analysis pro, this is the most comprehensive SQL course available online. Enroll now and start querying data like an expert today!

Who this course is for:

Are you want to learn more about SQL, PostgreSQL, or data analysis using SQL?
Are you want to learn SQL for data science?
Are you welling to learn Python Pandas & Data Visualization?
Are you ready for upcoming SQL interview questions?
Use Python bs4 & Pandas to Scrape a webpage, Analyze and visualize The Scraped Data.

SQL Course 2026: SQL for Data Analysis and Data Science.

What you'll learn

Explore related topics

Course content

Introduction1 lecture • 5min

Beginner: PostgreSQL Downloading & Installing + Preparing Airlines Database3 lectures • 5min

Test You Self (1)2 lectures • 1min

Beginner: Database Airlines Overview3 lectures • 8min

Beginner: SQL Basics Part14 lectures • 14min

Beginner: SQL Basics Part 26 lectures • 27min

Beginner: SQL Basics Part 35 lectures • 22min

Test You Self (2)2 lectures • 1min

SQL Basics Challenge!2 lectures • 1min

Intermediate: SQL Aggregations.4 lectures • 10min

Requirements

Description

Who this course is for: