Completed
- Introduction
Class Central Classrooms beta
YouTube playlists curated by Class Central.
Classroom Contents
Complete SQL in One Video
Automatically move to the next video in the Classroom when playback concludes
- 1 - Introduction
- 2 - Promo
- 3 - What is SQL?
- 4 - What are CRUD Operations?
- 5 - SQL vs MySQL
- 6 - Setup MySQL
- 7 - MySQL Workbench walk-through
- 8 - Accessing MySQL using CLI
- 9 - SQL Datatypes Variable Datatpes vs Fixed Datatypes
- 10 - Types of SQL Commands
- 11 - Data Definition Language DDL
- 12 - Data Read Language/Data Query Language DRL/DQL
- 13 - Dual Tables in SQL
- 14 - SELECT, WHERE, BETWEEN, IN, AND, OR, NOT, IS NULL
- 15 - Wildcard charaters in SQL
- 16 - Sorting in SQL using ORDER BY
- 17 - Grouping the Data using GROUP BY
- 18 - HAVING keyword
- 19 - DLL Key Constraints PRIMARY KEY, FOREIGN KEY etc
- 20 - ALTER operations in SQL
- 21 - Data Modification Language DML
- 22 - ON DELETE CASCADE / ON DELETE SET NULL Referential Constraint overcome methods
- 23 - REPLACE vs INSERT
- 24 - JOINS INNER JOIN/OUTER JOINS/SELF JOIN etc
- 25 - JOIN without using JOIN keywords
- 26 - SET operations in SQL UNION/INTERSECT/MINUS
- 27 - Sub-queries in SQL
- 28 - Views in SQL
- 29 - Summary Notes
