Teach on Udemy

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

Learn More

Your cart is empty.

Keep shopping

Mastering SQL and PostgreSQL

Name: Mastering SQL and PostgreSQL
Rating: 4.8 (146 reviews)

Beginner friendly SQL course: Learn SQL with Hands-on lab,Coding Exercises,Quiz,Interview Prep + Lifetime Query Support

Created byAakriti E-Learning Academy

Last updated 9/2025

English

English [Auto],

What you'll learn

Writing SQL queries - basic to advanced ones
Setting up a database
Understand real world scenarios, how to do data analysis, and generate reports
Learn about Joins and other advanced concepts, in a very simple way
Tons of practical hands-on, coding exercises and quizzes

Course content

17 sections • 72 lectures • 10h 0m total length

Course Overview & Content9:46
This section walks through course content, how to reach out for any query and next steps
Quick points about this learning journey0:46

What is Database and SQL7:23
Introduction to PostgreSQL1:49
Discover PostgreSQL as a relational database that uses SQL queries, applicable to any platform, with tables and rows, and learn why history since 1996 keeps it popular in big organizations.
Installing PostgreSQL on Windows9:47
Install PostgreSQL on Windows by downloading the latest installer from postgresql.org, running as administrator, selecting default paths, configuring the superuser password and port 5432, and verifying the installation with psql.
Installing PostgreSQL on Mac0:01
Common Installation challenges and how to fix them0:01
Downloading the Rental Movie Database0:27
Introduction to pgAdmin10:38
Learn to use pgAdmin with Postgres to access the database, create and restore the rental_movie database, and run queries to view results across tables.

SELECT12:22
WHERE10:21
Learn to filter data with the where clause in sql and postgresql, using operators and multiple conditions to return exact matches, with practical examples on employee details and film tables.
AS (ALIAS)4:37
DISTINCT5:01
Learn how the distinct keyword returns only unique records in SQL select queries, eliminating duplicates in salaries, rental rates, and rating values.
CODING EXERCISE 18:10
Frame business requirements into SQL queries by examining the payment table to identify customer IDs with payments of 7.99 or more, using distinct to ensure unique results.
CODING EXERCISE 27:49

ORDER BY8:47
LIMIT7:50
Master the limit clause to cap results and inspect table structure, then fetch the top five rows by salary in descending order to identify the highest earners.
BETWEEN4:31
IN Keyword5:20
Learn how to use the in operator in PostgreSQL to return results that match multiple values, with examples using district values and not in alternatives.
LIKE12:50
Master the like operator to perform pattern matching with % and _ wildcards. Learn to handle case sensitivity and use ILIKE for case-insensitive searches in pgadmin.
CODING EXERCISE 17:51
CODING EXERCISE 26:06

AGGREGATION FUNCTIONS - AVG, MIN, MAX, SUM10:05
COUNT5:30
Explore the count function in SQL and PostgreSQL, an aggregate that returns the number of rows, with optional where clauses and variations using star, a column, or distinct values.
GROUP BY18:59
HAVING6:22
SUB-QUERY13:56
Master subqueries by embedding a query inside another, using inner and outer queries to filter rows by an aggregated value like the average salary or rental rate. Experience building single-step queries with IN and where clauses that auto-adjust to updated data for scalable, automated results.
CODING EXERCISE 19:38
CODING EXERCISE 26:33

Introduction to JOINS5:15
Learn how to join data across tables using inner, left outer, right outer, and full outer joins, plus unions, with practical problems and a three step checklist.
INNER JOIN20:51
Learn how inner join combines two tables to return only matching records, using a common join field, with a practical three-step checklist to build and refine queries.
LEFT JOIN17:09
Master the left outer join: the left table dominates, returning all its rows plus matching right-table rows; nulls appear for non-matches, as shown with film ID joined to inventory.
RIGHT JOIN15:23
FULL JOIN10:06
UNION6:06
Explore how the union operator stacks results from multiple select statements into one set, ensuring equal columns, data types, and the same order, and how union differs from union all.
MUST WATCH: Lets Recap Joins one more time5:50
CODING EXERCISE 110:27
Explore SQL and PostgreSQL basics by following a three-step checklist to join the film and language tables, reporting each movie title, rental rate, and language name with aliases.
CODING EXERCISE 212:26
CODING EXERCISE 313:09

Data Types & how to choose the correct one14:30
Date/Time Functions12:47
Master PostgreSQL date and time functions, including current date, current time, current timestamp, now, age, and to_date, to analyze intervals and convert strings to date values.
EXTRACT8:16
Master the extract function in PostgreSQL to pull year, quarter, month, and other date parts from date time values, simplifying financial reporting.
Mathematical Functions15:31
Master core sql mathematical operators and functions in Postgres, including abs, mod, power, round, and truncate, with practical examples in PgAdmin and numeric data handling.
String Functions18:54
CODING EXERCISE 19:07
Join rental and customer; compute rent duration with age(return_date, rental_date); select rental_date, return_date, rent_duration, first_name, last_name, email; filter return_date not null and rent_duration > seven days; order by rent_duration desc.
CODING EXERCISE 28:36
Practice the substring function in SQL to extract parts of film titles, using its three arguments with the last optional, and verify results with the length function.

Requirements

No pre-requisite, just a computer and a desire to learn :)

Description

[Course name updated to "SQL & PostgreSQL for Beginners"]

Learn SQL and Database and become a master in Data Science, Development or QA. Take up this journey from being a SQL beginner to intermediate to advanced user. Engage in practical, hands-on sessions, sharpen your skills with coding exercises, and test your knowledge with quizzes at every step of your journey. Enroll Today and begin your data learning!!

In today's data-driven world, the ability to harness the power of databases is an indispensable skill for a wide range of professionals, from aspiring data scientists and Developers to QA specialists. Welcome to " Mastering SQL and PostgreSQL: Go from SQL Beginner to Expert", a comprehensive course designed to empower you with the knowledge and practical experience needed to excel in the exciting world of database management.

Enroll now, and let's embark on this exciting journey together. By the end of this course, you'll be armed with the expertise to manage, query, and analyze data like a pro. Don't miss out on this opportunity to level up your career and stay at the forefront of the data revolution!

Why SQL and PostgreSQL?

SQL (Structured Query Language) is the universal language of databases, and PostgreSQL is one of the most powerful, open-source relational database management systems available. Learning SQL and PostgreSQL not only opens the doors to numerous career opportunities but also provides you with the fundamental skills needed to manage and analyze data effectively. This learning can be applied to other databases also like MS-SQL, MySQL, Redshift, Cloudera etc.

What Will You Learn?

Foundations of SQL: Start your SQL journey by mastering the basics. Learn how to write queries to retrieve data, and apply conditions, ordering, grouping etc.

Master JOIN: JOIN is a tricky concept in SQL. We make sure to explain it very simply, with clear explanations, practical tips and hands-on practice exercises for a solid understanding.

Advanced SQL Techniques: Dive deeper into SQL with advanced topics such as sub-queries, aggregation, case, views etc.

Understanding Data Types: Explore the various data types used in SQL and how you can perform different operations on them.

Database Management & Analysis: Learn about creating databases, designing efficient tables, and inserting or updating data with step-by-step guidance.

PostgreSQL Essentials: Explore the unique features and capabilities of PostgreSQL and pgAdmin.

Hands-on Practical Learning: Apply your knowledge through a series of hands-on, query simulations, coding exercises and quizzes that simulate the challenges you'll encounter in your career.

And much, much more….

Why Take This Course?

1. Highly Practical Approach: This course is all about hands-on, practical learning. You'll write SQL queries and work with PostgreSQL databases from day one.

2. Coding Exercises: Sharpen your skills with coding exercises that reinforce your understanding of SQL and PostgreSQL concepts.

3. Quizzes and Assessments: Test your knowledge and track your progress with quizzes and assessments at the end of each section.

4. Career Opportunities: Data is in high demand across industries. By mastering SQL and PostgreSQL, you'll be well-equipped to pursue roles in data analysis, database administration, software development and more.

5. Interview Preparation Guide: 50 interview questions to help you land your dream job.

6. Life Time Support: You won't be alone on this learning journey. Get lifetime query support to answer your questions, provide guidance, and ensure your success.

Who Is This Course For?

- Aspiring Data Scientists: Data is the lifeblood of data science. Learn how to retrieve and manipulate data using SQL, a critical skill for data scientists.

- Developers: Enhance your software development skills by learning SQL and how to interact with databases programmatically.

- Quality Assurance Specialists: Learn how to write SQL queries for testing and pulling test data.

- Anyone Seeking Data Skills: Whether you're a beginner or have some experience, this course will help you build a strong foundation in SQL and PostgreSQL.

Who this course is for:

Aspiring Data Scientists
Developers
QA/Testers
Anyone else seeking to upskill in the data field

Mastering SQL and PostgreSQL

What you'll learn

Explore related topics

Course content

DAY 0: INTRODUCTION TO THE COURSE2 lectures • 11min

DAY 1: GETTING STARTED - DATABASE, SQL & INSTALLING POSTGRES7 lectures • 30min

DAY 2: QUERYING DATA - PART 16 lectures • 48min

DAY 3: QUERYING DATA - PART 27 lectures • 53min

Quiz0

DAY 4: GROUPING & AGGREGATING DATA7 lectures • 1hr 11min

Quiz 20

DAY 5: JOINS10 lectures • 1hr 57min

Quiz 30

DAY 6: DATA TYPES & OPERATIONS7 lectures • 1hr 28min

Requirements

Description

Who this course is for: