Back to courses

Complete SQL + Databases Bootcamp: Zero to Mastery [2023]

This SQL Bootcamp will take you from complete beginner to a master of SQL, database management, and database design. You'll learn by using fun exercises and working with all database types to give you real-world experience. No prior experience needed.

Last updated: March 2023

Course overview

Updated with all modern SQL and Database (PostgreSQL, MySQL) features for 2023, you'll learn SQL from not one, but two industry experts. Learning SQL and database best practices from this bootcamp will help you level-up your skillset to earn a higher salary and even get you hired.

What you'll learn

  • Become an expert in SQL and Database concepts
  • Add SQL, PostgreSQL, MySQL, Redis, Database Management, and Database Design to your resume
  • Learn how Machine Learning, Data Science and Data Engineers use Big Data and databases
  • Use the right SQL features to work with data efficiently and solve database problems
  • Learn to make business and market decisions based on user data
  • Create your own databases while using SQL to interact with the data
  • Tons of exercises to practice what you learn and test your knowledge
  • Advanced SQL topics like indexes, aggregates, and caching to make your database queries efficient
  • Learn how to handle user passwords and keep data safe
  • Learn to use Redis for fast memory storage
  • Understand SQL vs NoSQL and MongoDB vs MySQL vs PostgreSQL
  • Learn to perform efficient and performant SQL queries using best practices
  • Apply for SQL Developer, Database Administrator, Business Analyst, Backend Developer and Business Intelligence roles
  • Database best practices to design and manage your company data
  • Learn how to scale databases by using things like Sharding, Replication, etc.
  • Use real-world data to generate insights and reports using SQL
  • Help Sales, Marketing, and Product Managers make better decisions based on data analysis
  • Learn how databases are used in Web & Mobile Applications, Machine Learning and other fields
  • Work with SQL across multiple tables and multiple databases
  • Master SQL joins

SQL is one of the most in-demand tech skills in the world. It's not the "sexiest" skill but there's a reason it's still growing even though it's been around since the 1970s. Very few technologies can say that.

Using the latest best practices in SQL, Database Management and Database Design, this course is focused on efficiency.

That means you never have to waste time on confusing, out of date, incomplete tutorials anymore.

We guarantee you this is the most comprehensive online resource on Databases like PostgreSQL and MySQL.

This exercise based course will introduce you to all of the modern toolchain of a SQL Developer or anyone using a database in the workplace. Roles like:

  • Product Managers
  • Business Analysts
  • Data Analysts
  • Data Scientists
  • Machine Learning Engineers
  • Web Developers and Mobile Developers

And every other role that requires insights from data. Along the way, you'll learn practical and real world skills that will get you hired.

Just like thousands of other ZTM graduates who are now working at Google, Tesla, Amazon, Apple, IBM, Uber, Facebook, Shopify + other top tech companies.

They are also working as top freelancers getting paid while working remotely around the world.

This can be you.

By enrolling today, you’ll also get to join our exclusive live online community classroom to learn alongside thousands of students, alumni, mentors, TAs and Instructors.

Most importantly, you will learn from two industry experts that have real-world experiencing having built and managed databases for large companies in Toronto and Silicon Valley.

The curriculum is very hands on. We take you from start to finish of working with databases and SQL, all the way into learning how to scale databases and how to manage them.

There's even bonus material on working with Big Data, Caching using Redis, and connecting PostgreSQL to a Node.js server. You will even learn about the pros and cons of choosing a SQL database vs. NoSQL database (like MongoDB).

You will start from the very beginning by learning SQL and Database fundamentals, but we won't stop there. You will then learn advanced topics so that you can make good decisions and work with any data that your company has, no matter how complex!

The topics you'll learn in this SQL + Databases Bootcamp course:

  • NoSQL (MongoDB) vs PostgreSQL, MySQL vs NewSQL
  • SQL Theory And Concepts
  • The Relational Model
  • SQL Basics
  • SQL Functions
  • Data Modification Language / DML
  • Data Query Language / DQL
  • Subqueries
  • Indexes
  • SQL Filtering / WHERE Statement
  • 3 Valued Logic
  • SQL JOINS
  • Window Functions
  • Date Filtering and Timestamps
  • SQL Aggregate Functions
  • SQL Operator Precedense
  • SQL ORDER BY
  • SQL GROUP BY
  • SQL Top Down Design
  • SQL Bottom Up Design
  • SQL Entity Relationship Diagram
  • SQL Normalization
  • Database Types
  • The role of a DBMS
  • Multi Table SELECT
  • The Software Development Lifecycle / SDLC
  • POSTGRES Role Management
  • POSTGRES Permission Management
  • POSTGRES Backup Strategies
  • POSTGRES Transaction Management/ SQL Transactions
  • POSTGRES/SQL Data Types
  • SQL Views
  • Redis Database
  • Elasticsearch
  • Connecting A Database To A Server/Web App (Node.js)
  • Data Engineering (Kafka, Hadoop, etc...)
  • Sharding
  • Replication
  • Backups
  • Vertical + Horizontal Scaling
  • Distributed vs Centralized Databases
  • Big Data + Analytics
  • Database Security (SQL Injections, Access Control, etc...)
  • And more!

You will be able to work with all of the most popular databases like: PostgreSQL, MySQL, Oracle SQL, Microsoft SQL Server, IBM DB2, SQLite, MariaDB, Amazon Redshift, Presto, Apache Hive with Hadoop, and many more!

You see, data is everywhere and it is the most valuable asset in the world. All the top companies need people that can work with data.

That's where this course comes in.

The truth is though... there are many SQL courses and even free tutorials online.

So here are 5 reasons why this bootcamp is different (and better) from any other SQL / PostgreSQL / MySQL / Database tutorial online:

1. You will learn to work with not just one, but many databases like MySQL, PostgreSQL, Microsoft Server, Redis, and more.

We take you from absolutely zero knowledge and no technical/programming experience, all the way to mastery. You will go beyond basic SQL commands and learn advanced techniques, database best practices, database design and how to optimize for performance, security, and scalability.

2. Learn SQL & Databases from the best.

This course is taught by Mo and Andrei, two Senior Developers who have actually worked on massive projects for some of the top tech companies in the world.

Mo is a SQL & Database expert and works as a Solutions Architect. He has built software for the European Union, launched products for five Fortune 500 companies, and has consulted at Google.

Andrei has worked on enterprise-level applications for large tech firms in Silicon Valley as well as Toronto. Thousands of students from around the world have now taken his courses and many are now working at places like Google, Amazon and Tesla. You could too.

By having both Andrei and Mo teach, you get to see different perspectives and learn from two engineers as if you are working on projects at a company together with them.

3. You will learn by doing and actually have fun along the way.

Most tutorials are boring or out of date. The course is very different. You will start the course by getting hired at Keiko Corp and be tasked with investigating their recent Database breach 🕵️‍♀️.

You will be working on real-world assignments and exercises, analyzing databases and hidden information and learning the skills you need so that you can help Keiko Corp solve their data breach mystery!

4. You will go beyond the basics.

This course is not about making you just code along without understanding the principles so that when you are done with the course you don’t know what to do other than watch another tutorial... No!

This course will push you and challenge you to go from an absolute beginner in SQL and Databases to someone that is in the top 10% of SQL and Database experts 💪.

5. You won't be learning alone. You'll be learning alongside hundreds of other students from around the world in our private online community 👋.

You will have a chance to communicate with fellow students, work on group projects together, and contribute to open source projects. And anytime you have a question, you can ask and get help right away (including directly from Mo and Andrei).

Active. Thriving. Supportive. Helpful. Friendly. Motivating. Essential.

These are just a few of the words students use to describe the ZTM Developer Community Discord which also happens to be one of the biggest and most active developer communities on Discord.

You have nothing to lose. You can start learning right now and if this course isn't everything you expected, we'll refund you 100% within 30 days. No hassles and no questions asked.

When's the best time to get started? Today!

There's never a bad time to learn in-demand skills. But the sooner, the better. So start learning today by joining the ZTM Academy. You'll have a clear roadmap to developing the skills to build your own projects, get hired, and advance your career.

Start learning now
Expand Overview

Don't just take our word for it

Our courses and community have helped 1,000s of Zero To Mastery students go from zero to getting hired to levelling up their skills and advancing their careers to new heights.

Aswin Barath

I would say that this course is the most unique SQL course that can ever exist. From the basics of Databases to the professional knowledge needed for a Database Developer, this course is truly an exceptional one, and I recommend you to check it out!

Aswin Barath

Teodor Cazangiu

I loved their teaching styles, the way how JOINS were explained, and the fact that after every important topic there were exercises to test your knowledge. The information was structured in a way that it just kept you wanting to go and see the next video.

Teodor Cazangiu

The database design part was excellent and it is taught by a teacher who thoroughly knows the subject. Mo is amazing, very clear and articulate. Overall, the quality of this course is very high and it's made by professionals with real background in tech.

Pierrick Le Roy

Phenomenal! The best thing about ZTM courses is they inspire you to dive deeper into that specific domain by providing an in-depth overview of the topic. I found databases intimidating but I've now started working on projects involving databases!

Arindam Dawn

Course curriculum

To make sure this course is a good fit for you, you can start learning SQL for free right now by clicking any of the PREVIEW links below.

Introduction

5 lectures

Complete SQL + Databases Bootcamp: Zero to Mastery3:26

PREVIEW

Course Outline7:51

PREVIEW

Exercise: Meet Your Classmates and Instructor

START

The Big Data Breach At Keiko Corp2:23

PREVIEW

How-to's: Speed up videos, Downloading videos, Subtitles

START

History And Story Of Data

9 lectures

What Is a Database?5:57

PREVIEW

I Didn't Learn Anything, Try Again...6:35

PREVIEW

Database Management System (DBMS)7:44

PREVIEW

Exercise: Building Amazon5:34

PREVIEW

Exercise: Building Amazon 25:28

PREVIEW

5 Types Of Databases5:37

PREVIEW

Exercise: What Is A Database?1:11

PREVIEW

Section Review1:29

PREVIEW

Unlimited Updates

START

Databases + SQL Fundamentals

25 lectures

SQL Playground1:54

PREVIEW

What Is SQL?2:17

PREVIEW

What Is A Query?6:27

START

Exercise: Setting Up Your First Database

START

Imperative vs Declarative3:24

START

History of SQL2:21

START

Exercises: The Select Statement

START

Optional: History of SQL Deep Dive

START

SQL Standards4:25

START

What Is A Database? Revisited5:36

START

Database Oriented Approach6:51

START

Exercise: SQL Starter Quiz

START

Database Models1:21

START

Hierarchical And Networking Model8:03

START

Relational Model7:17

START

DBMS Revisited13:56

START

Relational Model Revisited1:06

START

Tables3:45

START

Columns4:07

START

Rows2:27

START

Primary And Foreign Keys5:03

START

OLTP vs OLAP3:16

START

Exercise: OLTP vs OLAP3:20

START

Exercise: Relational Model Quiz

START

Endorsements On LinkedIn

START

Environment Setup

12 lectures

Why PostgreSQL1:52

START

Environment Tooling3:10

START

Having Trouble Registering A Serial Key For ValentinaDB?

START

SQL Tooling Alternatives

START

Command Line 1015:21

START

Getting Help With The Setup

START

WINDOWS Setup4:52

START

Optional: Setting Up Windows For Command Line4:27

START

MAC Setup6:30

START

MAC Commandline Tools

START

LINUX Setup5:36

START

Importing The Databases6:03

START

SQL Deep Dive

56 lectures

Query Along

START

Starting With Query5:14

START

Exercise: Simple Queries10:10

START

Changing Column Names in a SELECT Query3:19

START

Concat Function4:51

START

What Is A Function In SQL?6:46

START

Aggregate Functions5:19

START

Exercise: Aggregate Functions

START

Commenting Your Queries9:32

START

Common SELECT Mistakes8:27

START

Filtering Data5:44

PREVIEW

AND and OR14:15

START

Exercise: Filtering Data7:56

START

The NOT Keyword7:18

START

Exercise: The Where Clause

START

Comparison Operators6:01

START

Exercise: Comparison Operators

START

Logical Operators7:31

START

Operator Precedence9:38

START

Operator Precedence 211:31

START

Operator Precedence Extra

START

Exercise: Operator Precedence

START

Checking For NULL Values12:01

START

IS Keyword13:42

START

NULL Coalescing7:12

START

Exercise: Null Value Coalescing

START

3 Valued Logic12:24

START

Exercise: 3 Valued Logic

START

BETWEEN + AND2:06

START

Exercise: BETWEEN + AND

START

IN Keyword3:24

START

Exercise: IN Keyword

START

LIKE13:17

START

Exercise: Like Keyword

START

Dates And Timezones12:53

START

Setting Up Timezones3:37

START

How Do We Format Date And Time?6:15

START

Timestamps10:27

START

Date Functions4:52

START

Date Difference And Casting1:47

START

Age Calculation2:09

START

Extracting Information2:51

START

Intervals3:13

START

Exercise: Date and Timestamp

START

DISTINCT4:11

START

Exercise: Distinct Keyword

START

Sorting Data6:17

START

Exercise Sorting Data

START

Multi Table SELECT10:47

START

Inner Join19:42

PREVIEW

Self Join4:54

START

Outer Join11:30

START

Less Common Joins6:36

START

Exercise: Inner-Join

START

USING Keyword4:29

START

Exercise: Imposter Syndrome2:55

START

Advanced SQL

39 lectures

GROUP BY14:43

START

Group By Exercises

START

HAVING Keyword7:38

START

Having Exercises

START

Ordering Grouped Data1:44

START

Group By Mental Model12:10

START

Grouping Sets9:29

START

Rollup7:17

START

Window What?3:30

START

Looking Through The Window8:52

START

PARTITION BY5:50

START

Order By Acting Strange5:34

START

Using Framing In Window Function14:12

START

Solving For Current Salary10:49

START

FIRST_VALUE5:48

START

LAST_VALUE4:03

START

SUM5:32

START

ROW_NUMBER3:03

START

Window Function Exercises

START

Conditional Statements6:14

START

Conditional Statement Exercise

START

NULLIF2:25

START

NULLIF Exercise

START

Views...What Are They Good For?3:41

START

View Syntax5:36

START

Using Views12:24

START

Views Exercises

START

Indexes11:09

START

Index Types10:28

START

Index Algorithms10:28

START

Quick Note: Index Algorithms

START

What Are Subqueries?8:18

START

Subqueries vs Joins8:47

START

Subquery Guidelines As Types11:17

START

Using Subqueries11:26

START

Quick Note: Titles For Employees

START

Getting The Latest Salaries14:19

START

Subquery Operators9:00

START

Subquery Exercises

START

Database Management

37 lectures

Before We Get Started

START

Time To Create Some Stuff!9:56

START

Types Of Databases In A RDBMS4:17

START

Default PostgreSQL Database7:38

START

Template Databases6:41

START

Creating A Database4:41

START

Database Organization7:08

START

Roles In Postgres3:45

START

Role Attributes And Creation4:52

START

Creating Users And Configuring Login13:44

START

Privileges3:51

START

Granting Privileges and Role Management6:23

START

Best Practices For Role Management4:22

START

Data Types & Boolean Type7:36

START

Storing Text5:19

START

Storing Numbers7:16

START

Storing Arrays4:20

START

Data Models And Naming Conventions10:54

PREVIEW

CREATE TABLE8:55

START

Extra information on CREATE TABLE

START

Column Constraints5:49

START

Table Constraints11:42

START

Regexes!

START

UUID Explained5:47

START

Custom Data Types And Domains6:07

START

Creating The Tables For ZTM11:52

START

Extra information on ALTER TABLE

START

Adding Students And Teachers8:07

START

Creating A Course12:31

START

Adding Feedback To A Course6:49

START

A Tale Of 2 Feedbacks9:03

START

SQL Exercises

START

SQL Quiz

START

Backups And Why They Are Important23:19

START

Backing Up In Postgres7:42

START

Restoring A Database6:15

START

Transactions18:15

START

Solving The Mystery

12 lectures

Clue #1 and #21:45

START

Getting ready to solve the mystery!

START

Clue #30:47

START

Exercise: Solving The First Clues

START

Solution: Solving The First Clues5:25

START

Clue #40:27

START

Exercise: Clue #4

START

Solution: Clue #41:02

START

Clue #5 and #61:13

START

Exercise: Clue #5 and #6

START

Solution: Clue #5 and #65:46

START

Solving The Mystery2:52

START

Database Design

36 lectures

System Design And SDLC9:49

START

SDLC Phases6:00

START

System Design Deep Dive5:57

START

Top-Down vs Bottom-Up6:28

START

DRIVEME Academy6:41

START

Top Down Design4:41

START

ER Model5:10

START

Step 1: Determining Entities3:34

START

Tooling For Diagramming3:28

START

DRIVEME Academy Entities13:54

START

Step 2: Attributes3:04

START

Relational Model Extended1:09

START

Relational Schema And Instance2:37

START

Super Key and Candidate Key6:22

START

Primary Key and Foreign Key7:33

START

Compound Composite And Surrogate Key4:07

START

DRIVEME Attributes11:56

START

Step 3: Relationships12:05

START

DRIVEME Relationships12:29

START

Step 4: Solving Many To Many9:27

START

Step 5: Subject Areas2:44

START

DRIVEME Subject Areas2:55

START

Exercise: Painting Reservations9:17

START

Exercise: Movie Theatre5:06

START

Bottom Up Design5:17

START

Anomalies10:29

START

Normalization7:14

START

Functional Dependencies6:35

START

Functional Dependencies 26:11

START

The Normal Forms4:32

START

Going from 0NF to 1NF8:09

START

Going from 1NF to 2NF5:47

START

Going from 2NF to 3NF8:30

START

Boyce-Codd Normal Form9:01

START

Why 4NF And 5NF Are Not Useful5:57

START

Exercise: Database Design Quiz

START

Database Landscape, Performance and Security

16 lectures

Bruno's Request1:36

START

Scalability4:19

START

Sharding3:04

START

Replication4:56

START

Backups2:15

START

Distributed vs Centralized Databases3:41

START

Database Security4:02

START

Exercise: SQL Injection

START

Optional: All About Injections Attacks19:42

START

Optional: Storing Passwords10:54

START

Optional: How To Store Passwords

START

Relational vs NoSQL, PostgreSQL vs MongoDB Databases10:35

START

Future Of Relational Databases1:47

START

Elasticsearch3:48

START

S3 Object Storage1:48

START

Top Databases To Use4:42

START

Where To Go From Here?

7 lectures

Thank You1:14

START

Review This Course!

START

Learning Guideline

START

LinkedIn Endorsements

START

Become An Alumni

START

Coding Challenges

START

Become a ZTM Ambassador ➡ Refer new students. Earn cash.

START

Bonus: Data Engineering (And the role of Machine Learning)

13 lectures

Big Data + Analytics2:31

START

Quick Note: Upcoming Videos

START

Reviewing How We Got Here6:03

START

Data Engineering Introduction3:23

START

What Is Data?6:42

START

What Is A Data Engineer?4:20

START

What Is A Data Engineer 2?5:35

START

What Is A Data Engineer 3?5:03

START

What Is A Data Engineer 4?3:22

START

Types Of Databases6:50

START

Hadoop, HDFS and MapReduce4:22

START

Apache Spark and Apache Flink2:07

START

Kafka and Stream Processing4:33

START

Bonus: Redis

12 lectures

Quick Note: Upcoming Videos

START

What Is Caching?6:57

START

Introducing Redis6:30

START

Redis Version Updates and Playground

START

Installing Redis9:18

START

Resources: Installing Redis

START

Redis Commands5:57

START

Redis Data Types1:59

START

Redis Hashes2:00

START

Redis Lists3:55

START

Redis Sets and Sorted Sets6:11

START

Section Summary3:00

START

Extra Bits: Databases In A Web App (with Node.js)

4 lectures

Quick Note: Upcoming Videos

START

Setting Up Your Database8:51

START

Connecting To The Database7:06

START

Registering A User Part 14:50

START

Meet your instructors

Your instructors aren’t just experts with years of real-world professional experience. They have been in your shoes. They make learning fun. They make complex topics feel simple. They will motivate you. They will push you. And they go above and beyond to help you succeed.

Mo Binni

Hi, I'm Mo Binni!

Mo is a Solutions Architect with over 7 years of experience in Software Architecture and Development. Having worked as a consultant for the majority of his career, he has seen it all.

SEE MY BIO & COURSES

Mo Binni

Full Stack Engineer

Andrei Neagoie

Hi, I'm Andrei Neagoie!

Andrei, lead instructor of Zero To Mastery Academy, has taught 1,000,000+ students worldwide how to code and get hired. ZTM grads work for world-class companies like Apple, Google, Amazon, Tesla, IBM, Facebook, Shopify and many more.

SEE MY BIO & COURSES

Andrei Neagoie

Senior Software Developer

Frequently asked questions

Are there any prerequisites for this course?

  • No prior tech experience is required. We will start from absolute zero
  • You can use ANY operating system with this course: Windows, macOS, Linux
  • Be ready to do tons of exercises and learn to love Databases and SQL

Who is this course for?

  • Both beginner and advanced professionals looking to learn modern SQL and Database principles
  • Professionals who are working with or will be working with databases and want to learn to work smart and efficiently using best practices
  • Anyone who is interested in one of the most in-demand tech skills that will be around for many years to come: SQL
  • Developers, Data Scientists, Machine Learning Engineers, Business Analysts, Product Managers, Sales/Marketers, and anyone who uses data to make business decisions
  • Anyone interested in learning more about SQL, PostgreSQL, or basic data analysis to boost your resume

Do you provide a certificate of completion?

We definitely do and they are quite nice. You will also be able to add Zero To Mastery Academy to the education section of your LinkedIn profile as well.

Can I download the videos?

Definitely. You can download any and all lessons for personal use. We do everything we can to make learning easy, fun and accessible. Whether that’s on your commute, on a flight or just when you have limited access to good WiFi.

Still have more questions about the Academy?

Still have more questions specific to the Academy membership? No problem, we answer some more here.

Take the next step and invest in a better you

Choose your currency:
$ USD US Dollar
Monthly
100% OFF$39 / month
$39 / month
You're ready to upskill and advance your career
Start Learning Now
Save 40% vs. monthly (that's $189 a year)
Annual
100% OFF$279 / year
$279 / year
$23 / month
You're committed to getting hired and starting a career in tech
Start Learning Now
Lifetime
100% OFF$999
$999
Only pay once, ever
You're serious about advancing your career and never getting left behind
Start Learning Now

Every ZTM membership includes:

Unlimited access to all courses, workshops, and career paths
Invite to private Discord with 400,000+ members
Access to private Linkedin networking group
Custom ZTM course completion certificates
Download all lessons for offline learning
Unlimited, priority access to all future courses, content, and features
100% RISK FREE

We know you'll love ZTM. That's why we provide a no hassle, 30-day money back guarantee.