Complete SQL in One Video

Dive into a comprehensive 3-hour 52-minute video tutorial on SQL, covering everything from basic concepts to advanced techniques. Learn about CRUD operations, SQL vs MySQL, data types, and various SQL commands. Master essential skills like querying with SELECT, using WHERE clauses, sorting with ORDER BY, and grouping data. Explore key constraints, ALTER operations, and data modification language. Delve into complex topics such as JOINs, SET operations, subqueries, and views. Follow along with practical examples using MySQL Workbench and CLI, and benefit from detailed explanations of each concept. Perfect for beginners and intermediate learners looking to solidify their SQL knowledge.

Syllabus

- Introduction
- Promo
- What is SQL?
- What are CRUD Operations?
- SQL vs MySQL
- Setup MySQL
- MySQL Workbench walk-through
- Accessing MySQL using CLI
- SQL Datatypes Variable Datatpes vs Fixed Datatypes
- Types of SQL Commands
- Data Definition Language DDL
- Data Read Language/Data Query Language DRL/DQL
- Dual Tables in SQL
- SELECT, WHERE, BETWEEN, IN, AND, OR, NOT, IS NULL
- Wildcard charaters in SQL
- Sorting in SQL using ORDER BY
- Grouping the Data using GROUP BY
- HAVING keyword
- DLL Key Constraints PRIMARY KEY, FOREIGN KEY etc
- ALTER operations in SQL
- Data Modification Language DML
- ON DELETE CASCADE / ON DELETE SET NULL Referential Constraint overcome methods
- REPLACE vs INSERT
- JOINS INNER JOIN/OUTER JOINS/SELF JOIN etc
- JOIN without using JOIN keywords
- SET operations in SQL UNION/INTERSECT/MINUS
- Sub-queries in SQL
- Views in SQL
- Summary Notes