Completed
Creating a New Database
Class Central Classrooms beta
YouTube videos curated by Class Central.
Classroom Contents
SQL Crash Course for Beginners - MySQL & PostgreSQL
Automatically move to the next video in the Classroom when playback concludes
- 1 Intro
- 2 What is SQL
- 3 A Closer Look at Databases
- 4 The Core SQL Syntax
- 5 Course Setup
- 6 The Example Project
- 7 Data Normalization
- 8 Planning Tables & Relationships
- 9 Creating a New Database
- 10 Choosing Identifier Names
- 11 Defining Columns
- 12 Exploring Key Value Types
- 13 Storing Files & Adding More Data Types
- 14 Introducing Constraints
- 15 Introducing Functions
- 16 Primary Keys & Unique IDs
- 17 Inserting Data
- 18 Querying Data
- 19 Updating & Deleting Data
- 20 Filtering & Ordering
- 21 Adding More Tables
- 22 Relations & Foreign Keys
- 23 ON DELETE & ON UPDATE
- 24 Adding More Tables & Relationships
- 25 Many-to-Many Relationships & Linking Tables
- 26 Inserting Related Data
- 27 Introducing Inner Join
- 28 Multiple Joins Combined
- 29 Introducing Left Join
- 30 Joins & Filtering
- 31 LIKE Text Filtering
- 32 Introducing Aggregate Functions
- 33 Grouping Aggregate Results
- 34 The HAVING Clause
- 35 Summary
