Lecture 9: Complete SQL in 1 VIDEO

This Video gives a complete understanding of SQL in one Video. There is a lot to learn, Keep in mind “ Mnn bhot karega k chor yrr apne se nahi hoga ya maza nahi aara, Just ask 1 question “ Why I started ? “ Visit Crio: https://www.crio.do/redeem/e3cfafb/ Notes & Slides Link: https://drive.google.com/drive/folders/1Sp8-UgBaUiaFfnFJBDk_o5iL9gu5IjT0?usp=sharing Discord Server Link: https://discord.gg/feSQvVXMrd Do provide you feedback in the comments, we are going to make it best collectively. Connect with me here: Instagram: https://www.instagram.com/lovebabbar1/ Twitter: https://twitter.com/lovebabbar3 Telegram Group Link: Love Babbar CODE HELP https://telegram.me/lovebabbercodehelp Connect with Lakshay: Instagram: https://www.instagram.com/lakshayk12/?hl=en LinkedIn: https://in.linkedin.com/in/lakshay-kumar-368a06146 My Editor: https://www.instagram.com/rishu.rsingh/?hl=en Intro Sequence: We have bought all the required Licenses of the Audio, Video & Animation used. TimeStamps: 00:00 - Introduction 02:12 - Promo 03:04 - What is SQL? 04:15 - What are CRUD Operations? 05:30 - SQL vs MySQL 08:55 - Setup MySQL 09:45 - MySQL Workbench walk-through 15:25 - Accessing MySQL using CLI 18:55 - SQL Datatypes (Variable Datatpes vs Fixed Datatypes) 29:40 - Types of SQL Commands 34:15 - Data Definition Language (DDL) 36:15 - Data Read Language/Data Query Language (DRL/DQL) 44:07 - Dual Tables in SQL 44:30 - SELECT, WHERE, BETWEEN, IN, AND, OR, NOT, IS NULL 58:45 - Wildcard charaters in SQL 01:02:40 - Sorting in SQL using ORDER BY 01:08:00 - Grouping the Data using GROUP BY 01:20:00 - HAVING keyword 01:26:48 - DLL Key Constraints (PRIMARY KEY, FOREIGN KEY etc) 01:40:50 - ALTER operations in SQL 01:50:25 - Data Modification Language (DML) 02:00:00 - ON DELETE CASCADE / ON DELETE SET NULL (Referential Constraint overcome methods) 02:11:25 - REPLACE vs INSERT 02:20:25 - JOINS (INNER JOIN/OUTER JOINS/SELF JOIN etc) 03:00:47 - JOIN without using JOIN keywords 03:02:40 - SET operations in SQL (UNION/INTERSECT/MINUS) 03:24:50 - Sub-queries in SQL 03:43:35 - Views in SQL 03:50:00 - Summary Notes #DBMSBusted #LoveBabbar #Lakshay