Completed
- JOINS INNER JOIN/OUTER JOINS/SELF JOIN etc
Class Central Classrooms beta
YouTube videos 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
