← All modules
SQL

SQL: Full Database Course for Beginners

Tables, keys, joins, nested queries and ER diagrams - the SQL a backend interview actually asks about.

23 lessons4 hr 21 minQuiz + certificate

Module 1: Module 1: Introduction

  • ▶Introduction
  • ▶What is a Database?
  • ▶Tables & Keys
  • ▶SQL Basics

Module 2: Module 2: Installing MySQL Windows

  • ▶Installing MySQL Windows
  • ▶Installing MySQL Mac
  • ▶Creating Tables
  • ▶Inserting Data
  • ▶Constraints
  • ▶Update & Delete

Module 3: Module 3: Basic Queries

  • ▶Basic Queries
  • ▶Company Database Intro
  • ▶Creating Company Database
  • ▶More Basic Queries

Module 4: Module 4: Functions

  • ▶Functions
  • ▶Wildcards
  • ▶Union

Module 5: Module 5: Nested Queries

  • ▶Nested Queries
  • ▶On Delete
  • ▶Triggers
  • ▶ER Diagrams Intro

Module 6: Module 6: Designing an ER Diagram

  • ▶Designing an ER Diagram
  • ▶Converting ER Diagrams to Schemas