Class Central is learner-supported. When you buy through links on our site, we may earn an affiliate commission.

Zero To Mastery

Complete SQL + Databases Bootcamp

via Zero To Mastery

Overview

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.
  • 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

Syllabus

  •   Introduction
    • Complete SQL + Databases Bootcamp: Zero to Mastery
    • Course Outline
    • Exercise: Meet Your Classmates and Instructor
    • The Big Data Breach At Keiko Corp
    • How-to's: Speed up videos, Downloading videos, Subtitles
  •   History And Story Of Data
    • What Is a Database?
    • I Didn't Learn Anything, Try Again...
    • Database Management System (DBMS)
    • Exercise: Building Amazon
    • Exercise: Building Amazon 2
    • 5 Types Of Databases
    • Exercise: What Is A Database?
    • Section Review
    • Unlimited Updates
  •   Databases + SQL Fundamentals
    • SQL Playground
    • What Is SQL?
    • What Is A Query?
    • Exercise: Setting Up Your First Database
    • Imperative vs Declarative
    • History of SQL
    • Exercises: The Select Statement
    • Optional: History of SQL Deep Dive
    • SQL Standards
    • What Is A Database? Revisited
    • Database Oriented Approach
    • Exercise: SQL Starter Quiz
    • Database Models
    • Hierarchical And Networking Model
    • Relational Model
    • DBMS Revisited
    • Relational Model Revisited
    • Tables
    • Columns
    • Rows
    • Primary And Foreign Keys
    • OLTP vs OLAP
    • Exercise: OLTP vs OLAP
    • Exercise: Relational Model Quiz
    • Endorsements On LinkedIn
  •   Environment Setup
    • Why PostgreSQL
    • Environment Tooling
    • Having Trouble Registering A Serial Key For ValentinaDB?
    • SQL Tooling Alternatives
    • Command Line 101
    • Getting Help With The Setup
    • WINDOWS Setup
    • Optional: Setting Up Windows For Command Line
    • MAC Setup
    • MAC Commandline Tools
    • LINUX Setup
    • Importing The Databases
  •   SQL Deep Dive
    • Query Along
    • Starting With Query
    • Exercise: Simple Queries
    • Changing Column Names in a SELECT Query
    • Concat Function
    • What Is A Function In SQL?
    • Aggregate Functions
    • Exercise: Aggregate Functions
    • Commenting Your Queries
    • Common SELECT Mistakes
    • Filtering Data
    • AND and OR
    • Exercise: Filtering Data
    • The NOT Keyword
    • Exercise: The Where Clause
    • Comparison Operators
    • Exercise: Comparison Operators
    • Logical Operators
    • Operator Precedence
    • Operator Precedence 2
    • Operator Precedence Extra
    • Exercise: Operator Precedence
    • Checking For NULL Values
    • IS Keyword
    • NULL Coalescing
    • Exercise: Null Value Coalescing
    • 3 Valued Logic
    • Exercise: 3 Valued Logic
    • BETWEEN + AND
    • Exercise: BETWEEN + AND
    • IN Keyword
    • Exercise: IN Keyword
    • LIKE
    • Exercise: Like Keyword
    • Dates And Timezones
    • Setting Up Timezones
    • How Do We Format Date And Time?
    • Timestamps
    • Date Functions
    • Date Difference And Casting
    • Age Calculation
    • Extracting Information
    • Intervals
    • Exercise: Date and Timestamp
    • DISTINCT
    • Exercise: Distinct Keyword
    • Sorting Data
    • Exercise Sorting Data
    • Multi Table SELECT
    • Inner Join
    • Self Join
    • Outer Join
    • Less Common Joins
    • Exercise: Inner-Join
    • USING Keyword
    • Exercise: Imposter Syndrome
  •   Advanced SQL
    • GROUP BY
    • Group By Exercises
    • HAVING Keyword
    • Having Exercises
    • Ordering Grouped Data
    • Group By Mental Model
    • Grouping Sets
    • Rollup
    • Window What?
    • Looking Through The Window
    • PARTITION BY
    • Order By Acting Strange
    • Using Framing In Window Function
    • Solving For Current Salary
    • FIRST_VALUE
    • LAST_VALUE
    • SUM
    • ROW_NUMBER
    • Window Function Exercises
    • Conditional Statements
    • Conditional Statement Exercise
    • NULLIF
    • NULLIF Exercise
    • Views...What Are They Good For?
    • View Syntax
    • Using Views
    • Views Exercises
    • Indexes
    • Index Types
    • Index Algorithms
    • Quick Note: Index Algorithms
    • What Are Subqueries?
    • Subqueries vs Joins
    • Subquery Guidelines As Types
    • Using Subqueries
    • Quick Note: Titles For Employees
    • Getting The Latest Salaries
    • Subquery Operators
    • Subquery Exercises
  •   Database Management
    • Before We Get Started
    • Time To Create Some Stuff!
    • Types Of Databases In A RDBMS
    • Default PostgreSQL Database
    • Template Databases
    • Creating A Database
    • Database Organization
    • Roles In Postgres
    • Role Attributes And Creation
    • Creating Users And Configuring Login
    • Privileges
    • Granting Privileges and Role Management
    • Best Practices For Role Management
    • Data Types & Boolean Type
    • Storing Text
    • Storing Numbers
    • Storing Arrays
    • Data Models And Naming Conventions
    • CREATE TABLE
    • Extra information on CREATE TABLE
    • Column Constraints
    • Table Constraints
    • Regexes!
    • UUID Explained
    • Custom Data Types And Domains
    • Creating The Tables For ZTM
    • Extra information on ALTER TABLE
    • Adding Students And Teachers
    • Creating A Course
    • Adding Feedback To A Course
    • A Tale Of 2 Feedbacks
    • SQL Exercises
    • SQL Quiz
    • Backups And Why They Are Important
    • Backing Up In Postgres
    • Restoring A Database
    • Transactions
  •   Solving The Mystery
    • Clue #1 and #2
    • Getting ready to solve the mystery!
    • Clue #3
    • Exercise: Solving The First Clues
    • Solution: Solving The First Clues
    • Clue #4
    • Exercise: Clue #4
    • Solution: Clue #4
    • Clue #5 and #6
    • Exercise: Clue #5 and #6
    • Solution: Clue #5 and #6
    • Solving The Mystery
  •   Database Design
    • System Design And SDLC
    • SDLC Phases
    • System Design Deep Dive
    • Top-Down vs Bottom-Up
    • DRIVEME Academy
    • Top Down Design
    • ER Model
    • Step 1: Determining Entities
    • Tooling For Diagramming
    • DRIVEME Academy Entities
    • Step 2: Attributes
    • Relational Model Extended
    • Relational Schema And Instance
    • Super Key and Candidate Key
    • Primary Key and Foreign Key
    • Compound Composite And Surrogate Key
    • DRIVEME Attributes
    • Step 3: Relationships
    • DRIVEME Relationships
    • Step 4: Solving Many To Many
    • Step 5: Subject Areas
    • DRIVEME Subject Areas
    • Exercise: Painting Reservations
    • Exercise: Movie Theatre
    • Bottom Up Design
    • Anomalies
    • Normalization
    • Functional Dependencies
    • Functional Dependencies 2
    • The Normal Forms
    • Going from 0NF to 1NF
    • Going from 1NF to 2NF
    • Going from 2NF to 3NF
    • Boyce-Codd Normal Form
    • Why 4NF And 5NF Are Not Useful
    • Exercise: Database Design Quiz
  •   Database Landscape, Performance and Security
    • Bruno's Request
    • Scalability
    • Sharding
    • Replication
    • Backups
    • Distributed vs Centralized Databases
    • Database Security
    • Exercise: SQL Injection
    • Optional: All About Injections Attacks
    • Optional: Storing Passwords
    • Optional: How To Store Passwords
    • Relational vs NoSQL, PostgreSQL vs MongoDB Databases
    • Future Of Relational Databases
    • Elasticsearch
    • S3 Object Storage
    • Top Databases To Use
  •   Where To Go From Here?
    • Thank You
    • Review This Course!
    • Learning Guideline
    • LinkedIn Endorsements
    • Become An Alumni
    • Coding Challenges
    • Become a ZTM Ambassador âž¡ Refer new students. Earn cash.
  •   Bonus: Data Engineering (And the role of Machine Learning)
    • Big Data + Analytics
    • Quick Note: Upcoming Videos
    • Reviewing How We Got Here
    • Data Engineering Introduction
    • What Is Data?
    • What Is A Data Engineer?
    • What Is A Data Engineer 2?
    • What Is A Data Engineer 3?
    • What Is A Data Engineer 4?
    • Types Of Databases
    • Hadoop, HDFS and MapReduce
    • Apache Spark and Apache Flink
    • Kafka and Stream Processing
  •   Bonus: Redis
    • Quick Note: Upcoming Videos
    • What Is Caching?
    • Introducing Redis
    • Redis Version Updates and Playground
    • Installing Redis
    • Resources: Installing Redis
    • Redis Commands
    • Redis Data Types
    • Redis Hashes
    • Redis Lists
    • Redis Sets and Sorted Sets
    • Section Summary
  •   Extra Bits: Databases In A Web App (with Node.js)
    • Quick Note: Upcoming Videos
    • Setting Up Your Database
    • Connecting To The Database
    • Registering A User Part 1

Taught by

Mo Binni and Andrei Neagoie

Reviews

Start your review of Complete SQL + Databases Bootcamp

Never Stop Learning.

Get personalized course recommendations, track subjects and courses with reminders, and more.

Someone learning on their laptop while sitting on the floor.