SQL

Name: SQL Nanodegree Program
Rating: 4.6 (309 reviews)

Master SQL, the essential language for data analysis and insight-driven decision-making. This program covers SQL fundamentals, advanced querying, and database management. Learn to work with multiple tables, perform data aggregation and cleaning, use window functions, and optimize queries for large datasets. Apply your skills to real-world projects, analyzing deforestation data and redesigning databases. Gain proficiency in SQL for data analysis, database design, and management, preparing for roles requiring strong data manipulation and insight generation. Ideal for aspiring data analysts, business intelligence professionals, and those seeking to enhance their data querying and management skills.

Nanodegree Program

Beginner
41 hours
4.6 (309)
Updated: Jun 29, 2026

Subscription · Monthly

Cancel Anytime
Unlimited access to hundreds of top-rated courses
Hands-on projects with expert feedback
Personalized career coaching and interview prep
Program Certificates

Skills you'll learn

19 skills

SQL subqueries
SQL joins
Mongodb
SQL CRUD commands
Database normalization

Prerequisites

1 prerequisite

Prior to enrolling, you should have the following knowledge:

Basic SQL

You will also need to be able to communicate fluently and professionally in written and spoken English.

Program Outline

3 courses
54 lessons
2 projects

Course 1: Welcome to the SQL Nanodegree Program

Course 2: Introduction to SQL

Get a beginner-friendly introduction to SQL that covers querying, joins, aggregations, and data cleaning, with clear guidance on choosing the right commands and using query results to answer business questions.

18 hours

SQL Operators Introduction
An Introduction to the course and using the Parch & Posey sales database to solve real-world business questions.
Introduction to SQL
Explore SQL basics, its importance for data analysis, business use cases, database structure, and an overview of popular SQL databases with hands-on practice.
Entity Relationship Diagrams
Learn how to interpret Entity Relationship Diagrams (ERDs) to visualize tables, columns, and relationships in a relational database.
An Introduction to Statements in SQL
Learn SQL basics by understanding key statements like SELECT and FROM, practicing queries, and following best practices for formatting and execution in a SQL workspace environment.
The LIMIT Clause in SQL
Learn how to use the LIMIT clause in SQL to restrict the number of rows returned in query results, making data exploration faster and more manageable.
ORDER BY Clause in SQL
Learn to use the SQL ORDER BY clause to sort query results by one or multiple columns, in ascending or descending order, with practical query exercises and solutions.
WHERE Clause in SQL
Learn to use the SQL WHERE clause to filter table data based on numeric or text conditions, using operators like =, !=, >, <, and practice with real-world queries.
Arithmetic Operators in SQL
Learn how to use arithmetic operators in SQL to create derived columns, perform calculations in queries, and apply order of operations for accurate results.
LIKE and IN Operators in SQL
Learn how to use SQL's LIKE and IN operators to filter text and numeric data efficiently, enabling flexible database queries with wildcards and value lists.
AND and BETWEEN Operators in SQL
Learn to use AND and BETWEEN operators in SQL to filter data with multiple conditions and ranges, practicing queries on real tables and understanding inclusivity of endpoints.
NOT and OR Operators in SQL
Learn how to use SQL's NOT and OR operators to filter data, combine conditions, and query for records that do not or do match given criteria, with practical examples and exercises.
SQL Operators Recap
Review key SQL commands, syntax, and concepts such as SELECT, FROM, WHERE, ORDER BY, LIKE, and data structure. Reinforce skills to write and understand basic SQL queries.
JOIN Introduction
Gain an understanding of the definition of JOINS and database normalization and learn why they are needed.
Introduction to Inner JOINs in SQL
Learn how to use INNER JOINs in SQL to combine data from multiple tables, write JOIN queries, and specify columns from different tables using the ON clause.
JOINs in SQL
Learn how to use INNER, LEFT, and RIGHT JOINs in SQL to combine data from multiple tables, including filtering joins and understanding NULLs in join results.
Advanced JOIN Concepts
Explore advanced SQL JOINs, primary and foreign keys, multi-table joins, and aliases to efficiently combine and analyze relational database tables.
JOIN Recap
Recap key concepts learned in this lesson.
SQL Aggregation Introduction
An overview of the content that will be learned in Lesson 3.
NULLs and Aggregation
Learn how NULLs represent missing data in SQL, how they differ from zeros, and how to identify or exclude them using IS NULL or IS NOT NULL in queries and aggregations.
COUNT in SQL
Learn how to use SQL's COUNT function to count rows, understand the difference between COUNT(*) and COUNT(column), and see how NULL values affect results.
SUM in SQL
Learn how to use the SQL SUM function to total numeric columns, handle NULL values, and perform aggregations across data for inventory analysis and sales calculations.
MIN, MAX, and AVG in SQL
Learn to use SQL's MIN, MAX, and AVG aggregate functions to find minimums, maximums, and averages, while understanding their handling of NULLs and practical business applications.
GROUP BY in SQL
Learn how to use GROUP BY in SQL to aggregate data within subsets, group by multiple columns, and combine GROUP BY with ORDER BY for insightful data analysis.
DISTINCT in SQL
Learn how to use DISTINCT in SQL SELECT statements to retrieve unique rows across specified columns, with practical examples and exercises for real-world query scenarios.
HAVING Clause in SQL
Learn how to use the SQL HAVING clause to filter aggregated group results, enabling analysis of grouped data with aggregate functions beyond the WHERE clause.
DATE in SQL
Explore how to use SQL date functions like DATE_TRUNC and DATE_PART to analyze, aggregate, and group data by various date parts for effective reporting.
CASE Statements in SQL
Learn to use SQL CASE statements for conditional logic in SELECT queries, including multi-case logic, handling NULLs, and combining CASE with aggregations.
Introduction to Subqueries
Learn the basics of SQL subqueries, focusing on scalar subqueries, to simplify complex logic and compare values efficiently within a single query.
Subqueries in the WHERE Clause
Learn how to use subqueries in the WHERE clause to filter SQL results dynamically, making queries more flexible and readable. Practice building both scalar and filtering subqueries.
Subqueries in the FROM Clause
Learn how to use subqueries in the FROM clause to create derived tables, transform data, and build complex SQL queries efficiently with practical examples.
Common Table Expressions (CTEs)
Learn how Common Table Expressions (CTEs) make complex SQL queries cleaner, more readable, and efficient by organizing logic into reusable, easily-managed parts with the WITH clause.
Temporary Tables in SQL
Discover how temporary tables in SQL simplify complex queries by storing intermediate results, boosting performance, organizing logic, and supporting efficient data analysis.
Tips for Clean and Efficient SQL
Learn key tips for writing clean, efficient SQL using subqueries, CTEs, and temp tables, plus best practices for clarity, performance, and maintainability.
SQL Window Functions
Discover SQL window functions to perform calculations like totals, averages, and ranking across rows while retaining individual data for advanced analysis.
Working with SQL PARTITION BY
Discover how SQL's PARTITION BY enables advanced analytics—like running totals, rankings, and trend analysis—across groups without losing row-level detail.
Order in Window Functions
Understand the role of ORDER BY in SQL window functions for ordering, ranking, and framing data, including ROWS vs RANGE and practical uses like running totals and moving averages.
Building a Window Function
Learn how to build SQL window functions for detailed analysis, cumulative totals, and efficient queries using PARTITION BY, ORDER BY, and smart optimization strategies.
SQL Data Cleaning Introduction
Learn why data cleaning is crucial, how to identify issues like duplicates, nulls, and outliers, and practical SQL techniques to ensure analysis is accurate and reliable.
Advanced SQL Data Cleaning
Learn advanced SQL data cleaning using staging tables and workflows for scalable, reliable data prep, with best practices for consistency, deduplication, and quality control.
FULL OUTER JOIN
Learn how FULL OUTER JOIN in SQL returns all matched and unmatched rows from both tables, useful for comprehensive data comparison and analysis, with syntax, use cases, and practice.
JOINs with Comparison Operators
Explore SQL JOINs using comparison operators like < and > to connect tables on inequalities, including practical queries and key differences from standard equality joins.
Self JOINs
Learn how to use self JOINs in SQL to compare rows within the same table, often with inequalities, for analyzing event sequences within specific time intervals.
UNION
Learn to use the SQL UNION operator to combine result sets from multiple tables, remove duplicates, and perform further analysis on appended data, including using UNION ALL for all rows.
Performance Tuning
Learn to identify slow SQL queries and improve performance by filtering data, simplifying joins, aggregating before joins, and using EXPLAIN to analyze and optimize query plans.
Congratulations

Deforestation Exploration
In this project, students will be putting their SQL skills to the test to help determine where to concentrate efforts to combat deforestation.

Course 3: Management of Relational and Non-relational Databases

Program Instructors

4 instructors

Unlike typical professors, our instructors come from Fortune 500 and Global 2000 companies and have demonstrated leadership and expertise in their professions:

Ziad Saab

Software Developer and Co-Founder DecodeMTL

David Elliott

Data Scientist, Data Engineer

Derek Steer

CEO, Superframe

Malavica Sridhar

Senior Product Manager at CircleUp

Ziad Saab

Software Developer and Co-Founder DecodeMTL

David Elliott

Data Scientist, Data Engineer

Derek Steer

CEO, Superframe

Malavica Sridhar

Senior Product Manager at CircleUp

Reviews

Average Rating: 4.6 (309 Reviews)

A complete and comprehensive intro to ML

Iraklis K

Mar 8, 2026

The course is "ML with Pytorch" implying there would be algorithms implementing in supervised and unsupervised ML models as well a neural network using Pytorch, which could be interesting.. But it just rehashes material using scikit-learn from other nanodegrees. And even the course on neural networks is material all cribbed from the "AI programming with Python" nanodegree. Just a way to recombine existing material to sell another product.
The course is "ML with Pytorch" implying there would be algorithms implementing in supervised and unsupervised ML models as well a neural network using Pytorch, which could be interesting.. But it just rehashes material using scikit-learn from other nanodegrees. And even the course on neural networks is material all cribbed from the "AI programming with Python" nanodegree. Just a way to recombine existing material to sell another product.

Karen F

Jan 12, 2026

everything were explained very well

abdulrahman a.

Jul 19, 2022

Decent.

Omer A.

Apr 27, 2022

Good , yes Definitely but would need more time to understand the concepts in details. Because we are learning a lot of concepts

Narendhra Kumar M.

Mar 11, 2022