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/folder...

Discord Server Link:   / discord  

Do provide you feedback in the comments, we are going to make it best collectively.

Connect with me here:

Instagram:   / lovebabbar1  
Twitter:   / lovebabbar3  
Telegram Group Link: Love Babbar CODE HELP
https://telegram.me/lovebabbercodehelp

Connect with Lakshay:

Instagram: https://www.instagram.com/lakshayk12/...
LinkedIn:   / lakshay-kumar-368a06146  

My Editor: https://www.instagram.com/rishu.rsing...

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