About course

SQL is a must-have skill for any data professional. In this course, you’ll discover how SQL empowers you to work with databases efficiently and unlock insights from structured data. With hands-on lessons, you'll learn how to navigate and manipulate data like a pro using SQL’s powerful functions.

What you will learn

From SQL fundamentals to advanced topics like Common Table Expressions (CTEs), window functions, and subqueries, this course covers all the essentials. You'll gain the ability to perform complex queries, optimize database operations, and manage data with ease, preparing you for real-world data challenges.

Syllabus

Introduction to SQL & Databases

5 mins

Types of Databases & SQL Database

5 mins

Database Management System

7 mins

Create your first SQL Database

Your first tables in a SQL Database

Data Types in SQL

Constraints in SQL

Edit tables in SQL

Import large Datasets

SQL queries

Operators in SQL

Aggregate functions & Group by

Joinning tables in SQL

Conditional Expressions

Subqueries in SQL

Window functions