SQL Bootcamp - From Zero to Job-Ready
Ends soon! Keep adding new skills with 10,000+ programs for $239 (usually $399). Save now.
SQL Bootcamp - From Zero to Job-Ready
Included with
Ask Coursera
Recommended experience
Recommended experience
What you'll learn
Master the basics of SQL, including query writing and data manipulation.
Understand relational database structures and how to organize data.
Learn how to aggregate data and perform advanced operations using SQL.
Develop the skills to apply SQL to real-world business problems through projects and capstone.
Skills you'll gain
Tools you'll learn
Details to know
April 2026
17 assignments
See how employees at top companies are mastering in-demand skills
There are 16 modules in this course
This course features Coursera Coach! A smarter way to learn with interactive, real-time conversations that help you test your knowledge, challenge assumptions, and deepen your understanding as you progress through the course.
In this SQL Bootcamp, you will embark on a comprehensive journey, starting from the basics and advancing to real-world job-ready skills. You'll learn to write SQL queries, understand database concepts, and master key techniques such as CRUD operations, joins, and subqueries. By the end, you will be well-equipped to manage and manipulate data using SQL, preparing you for a career in database management or data analysis. The course begins with foundational concepts such as the structure and syntax of SQL, followed by an introduction to databases and their types. You will quickly get hands-on experience writing your first SQL queries, progressively building your skills. As you move through the course, you will tackle real-world projects and apply what you’ve learned by working with different data types, creating schemas, and implementing keys and relationships in SQL. As you progress, you will dive deeper into advanced topics such as aggregation, window functions, and complex queries using joins and subqueries. These skills will culminate in the capstone project, where you will apply your knowledge to real datasets, solving problems ranging from inventory management to customer analysis. This course is ideal for beginners with no prior SQL experience. It will also benefit individuals looking to sharpen their SQL skills for job readiness. No prior knowledge of databases is required, but basic computer literacy is helpful. The difficulty level is beginner to intermediate. By the end of the course, you will be able to write complex SQL queries, understand relational database design, perform data aggregation, and work with real-world datasets to solve business problems.
In this section, we will introduce the SQL language, its structure, and its significance in database management. You will learn how SQL queries are constructed, and you'll get hands-on experience by writing your first SQL query to retrieve data from a database.
What's included
3 videos1 reading
3 videos•Total 9 minutes
- Introduction to SQL Language•3 minutes
- Understanding the SQL Language•4 minutes
- Writing our First SQL Query•3 minutes
1 reading•Total 10 minutes
- Full Course Resource•10 minutes
In this section, we will dive deeper into the fundamentals of databases, exploring their structure, types, and uses. We will also distinguish between SQL and MySQL, and understand when and how each is applied in database management.
What's included
5 videos1 assignment
5 videos•Total 25 minutes
- Introduction to Databases•3 minutes
- Types of Databases•5 minutes
- SQL vs MySQL Updated•5 minutes
- Spreadsheets vs Database•5 minutes
- Understanding Relational Database•6 minutes
1 assignment•Total 15 minutes
- SQL Foundations - Assessment•15 minutes
In this section, we will explore various SQL data types and their application in database design. You'll learn how to choose the right data type for each field in your database and practice creating tables using a variety of data types, from integers to complex JSON objects.
What's included
17 videos1 assignment
17 videos•Total 38 minutes
- Project Introduction•2 minutes
- Data Types and INT•5 minutes
- BIG INT•3 minutes
- TINYINT•3 minutes
- DECIMAL•3 minutes
- FLOAT and DOUBLE•2 minutes
- BIT and BOOLEAN•2 minutes
- CHAR•3 minutes
- VARCHAR•2 minutes
- TEXT•1 minute
- ENUM•2 minutes
- DATE and TIME•2 minutes
- DATETIME•1 minute
- TIMESTAMP•1 minute
- YEAR•1 minute
- BLOB•3 minutes
- JSON•2 minutes
1 assignment•Total 15 minutes
- Data Types in SQL - Assessment•15 minutes
In this section, we will discuss the significance of database schema in organizing and maintaining data integrity. You will learn how to create different types of schemas, including the STAR and Snowflake schemas, which are key in data warehousing.
What's included
7 videos1 assignment
7 videos•Total 24 minutes
- Why we need Database Schema•5 minutes
- Types of Schema•1 minute
- STAR Schema•4 minutes
- Installing Server and Workbench Installation for Mac•4 minutes
- Creating our First Database Schema•4 minutes
- Introduction to Snowflake Schema•2 minutes
- Creating a Snowflake Schema Database•4 minutes
1 assignment•Total 15 minutes
- Understanding Schema and Creating Schema - Assessment•15 minutes
In this section, we will explore the importance of keys in relational database management. You will learn how to create primary, foreign, and composite keys and understand their role in defining relationships between tables.
What's included
6 videos1 assignment
6 videos•Total 19 minutes
- Primary Key•3 minutes
- Foreign Key•2 minutes
- Unique Composite and Candidate Key•5 minutes
- One to One Relationships•3 minutes
- One to Many Relationships•2 minutes
- Many to Many Relationships•3 minutes
1 assignment•Total 15 minutes
- Keys and Relationships - Assessment•15 minutes
In this section, we will guide you through the essential CRUD operations, teaching you how to create tables, insert data, and retrieve information using SQL. You will also learn how to update and delete records to maintain accurate and up-to-date data.
What's included
6 videos1 assignment
6 videos•Total 28 minutes
- Creating a Sample Database•5 minutes
- Create a Sample Table•6 minutes
- Creating Data for our Table•7 minutes
- Selecting Data CRUD Operations•1 minute
- Altering and Updating the Table and Table Information•5 minutes
- Deleting in SQL•4 minutes
1 assignment•Total 15 minutes
- CRUD Operations - Assessment•15 minutes
In this section, we will focus on SELECT statements, helping you retrieve and filter data from databases. You will learn to apply filtering criteria using the WHERE clause and practice selecting specific columns from a table or multiple tables.
What's included
12 videos1 assignment
12 videos•Total 59 minutes
- Importing Data to our MySQL Workbench•4 minutes
- SELECT Everything•3 minutes
- Selecting Multiple Columns•5 minutes
- Select Distinct Values from a Column or Columns•5 minutes
- Selecting Info with WHERE Clause•4 minutes
- Shortcomings and Operators of WHERE Clause•2 minutes
- Using Less Than or Equal to with WHERE Clause•5 minutes
- WHERE with AND Criteria and Multiple Criterion•7 minutes
- WHERE and OR•5 minutes
- WHERE and IN•7 minutes
- Understanding Wild Cards in MySQL•7 minutes
- Wild Cards Situation Practice in MySQL Workbench•7 minutes
1 assignment•Total 15 minutes
- Project and Select Statements - Assessment•15 minutes
In this section, we will teach you how to apply aggregation functions to summarize and analyze large sets of data. You will explore various aggregation techniques and learn how to use them in complex data analysis tasks.
What's included
7 videos1 assignment
7 videos•Total 38 minutes
- Aggregation Section Introduction•1 minute
- Basic SUM•7 minutes
- Aggregations with Previous Learnings and Complex Situations•5 minutes
- Basic Count•7 minutes
- Complex Counting•4 minutes
- Average•7 minutes
- MAX and MIN•8 minutes
1 assignment•Total 15 minutes
- Aggregations in MySQL - Assessment•15 minutes
In this section, we will outline the expectations for your first assignment and guide you through a solution walkthrough. You will apply the SQL skills you've learned to complete real-world tasks and gain practical experience.
What's included
2 videos1 assignment
2 videos•Total 5 minutes
- What is Expected in This Assignment•1 minute
- Assignment Solution Walkthrough•4 minutes
1 assignment•Total 15 minutes
- Level 1 - Assignment - Assessment•15 minutes
In this section, we will teach you how to group and sort data using GROUP BY and ORDER BY. You will also learn to filter grouped data using the HAVING clause to perform more advanced queries.
What's included
4 videos1 assignment
4 videos•Total 33 minutes
- Group By Statement•9 minutes
- GROUP BY in MySQL Workbench•7 minutes
- ORDER BY Statement•6 minutes
- HAVING•11 minutes
1 assignment•Total 15 minutes
- GroupBy, OrderBy, and Having in MySQL - Assessment•15 minutes
In this section, we will introduce you to SQL joins and their importance in relational database management. You'll learn how to combine data from different tables and practice using various types of joins to retrieve and analyze related data.
What's included
11 videos1 assignment
11 videos•Total 59 minutes
- What are Joins and Why We Need Them•4 minutes
- Exploring the Dataset and CROSS Joins•7 minutes
- Understanding Left Join•6 minutes
- Practicing Left Join with Aggregations•7 minutes
- RIGHT Join•4 minutes
- RIGHT Join Example•5 minutes
- Practicing Right Join - Multi Join and Aggregations•12 minutes
- Inner Join•4 minutes
- Practicing INNER JOIN•3 minutes
- Union•6 minutes
- Union All•2 minutes
1 assignment•Total 15 minutes
- Joins - Assessment•15 minutes
In this section, we will explore advanced SQL operators for filtering data, including BETWEEN, AND, and NOT BETWEEN. You'll also learn how to manage NULL values and limit query results to improve your data retrieval efficiency.
What's included
5 videos1 assignment
5 videos•Total 13 minutes
- Between and AND•2 minutes
- NOT BETWEEN•2 minutes
- IS NOT NULL•3 minutes
- IS NULL•3 minutes
- LIMIT•3 minutes
1 assignment•Total 15 minutes
- More Operators and NULL Management - Assessment•15 minutes
In this section, we will explore the CASE statement, a powerful tool for implementing conditional logic in SQL queries. You will practice using CASE statements to handle different conditions and apply them in practical data analysis scenarios.
What's included
4 videos1 assignment
4 videos•Total 25 minutes
- Understanding CASE Statements Updated•4 minutes
- Practicing Case Statement 1•14 minutes
- Case Statement 2•3 minutes
- Case Statement 3•3 minutes
1 assignment•Total 15 minutes
- CASE Statements - Assessment•15 minutes
In this section, we will cover the use of subqueries to perform more complex queries in SQL. You will learn how to use scalar subqueries and integrate them with other queries, including joins and multiple tables.
What's included
5 videos1 assignment
5 videos•Total 25 minutes
- Introduction to Subquery MySQL•2 minutes
- Scalar Subquery - MySQL•3 minutes
- Practicing Scalar Subquery - Q1 - MySQL•4 minutes
- Scalar Subquery Q2 - MySQL•2 minutes
- Complex Sub-Query Using Joins and Multiple Tables - MySQL•13 minutes
1 assignment•Total 15 minutes
- Subqueries - Assessment•15 minutes
In this section, we will introduce window functions, explaining how they enable you to perform calculations across a set of table rows related to the current row. This module will enhance your ability to analyze data in more advanced ways.
What's included
1 video1 assignment
1 video•Total 6 minutes
- Introduction to Window Functions - Updated•6 minutes
1 assignment•Total 15 minutes
- SQL Window Function - Assessment•15 minutes
In this section, we will walk you through a series of practical SQL tasks, including retrieving product details, analyzing sales performance, and calculating revenue. This hands-on project will help solidify your SQL skills in real-world contexts.
What's included
21 videos3 assignments
21 videos•Total 84 minutes
- Find the Active Branches List•2 minutes
- Fetching the Basic Product Details from the Table•2 minutes
- Recent Customer Signups•3 minutes
- Orders Overview•1 minute
- Unresolved Customer Support Tickets•3 minutes
- Fetching Customers Orders Info Using Joins•4 minutes
- Total Revenue Made•3 minutes
- Average Response Time to Customers•3 minutes
- Active Employee Count for Departments•3 minutes
- Expired Products from Inventory•4 minutes
- Campaigns by Channel•1 minute
- Active Assets Deployed in Branches•4 minutes
- Top 5 Products by Their Revenue•6 minutes
- Asset Depreciation Calculation•7 minutes
- High-Cost Employees by Department•5 minutes
- Return on Investment on Branches•10 minutes
- Delivery Type Performance•7 minutes
- Customer Order Frequency•4 minutes
- Top 3 Products per Category•3 minutes
- Inventory Expiry Tracker•4 minutes
- Campaign Spend Efficiency•5 minutes
3 assignments•Total 90 minutes
- Capstone Project - Assessment•15 minutes
- Full Course Assessment•60 minutes
- Full Course Practice Assessment•15 minutes
Instructor
Why people choose Coursera for their career
Frequently asked questions
SQL (Structured Query Language) is a powerful programming language designed for managing and manipulating relational databases. It allows users to retrieve, insert, update, and delete data within databases. SQL is relevant because it is the standard language used by major database management systems like MySQL, PostgreSQL, and Oracle, making it essential for anyone working with data, whether you're analyzing business metrics, building applications, or managing large data sets.
This SQL Bootcamp provides a comprehensive, hands-on approach to learning SQL, starting from the basics and progressing to more advanced concepts. Throughout the bootcamp, you'll learn how to write SQL queries, understand database structure, manage data types, perform CRUD operations, and use advanced SQL techniques such as joins, window functions, and subqueries. The bootcamp also includes a capstone project, where you'll apply your SQL skills to solve real-world problems using a database.
After completing this bootcamp, you will have a solid understanding of SQL and be able to confidently use it to manage databases, retrieve and manipulate data, and perform complex queries. You will be able to design relational databases, work with different data types, implement keys and relationships, and write optimized queries for tasks like data aggregation, analysis, and reporting. This will equip you with the necessary skills for roles such as data analyst, database administrator, or software developer.
More questions
Financial aid available,