← 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
