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 ? “


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

Connect with me here:

Telegram Group Link: Love Babbar CODE HELP

Connect with Lakshay:

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

[nischalraghuramp]

Bhaiya, aapka video raat bhar dekh ke agle din interview crack karliya Maine! Thankyou for making this video it really made my life! Literally made my life. I wish you all the happiness in the world bhaiya you deserve everything that comes your way! Keep helping people like this and never stop!

[SohelDarwajkar]

3:15:05
Why Intersect is used when we already had inner join?
*Inner Join will return the records which are common in both tables but what if there are duplicated records in both tables? Inner join will return those duplicated records as well but intersect strictly records distinct records shared between two tables hence using distinct keyword with inner join query can give us the result of intersection.

[pranav]

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

[saurabhchavan]

18:52 - 1 Tier Architecture because of user can easily interact with Database or architecture without any Restriction.

[fukedup]

Finally our wait is over
After so many days
I thought that you won't continue this series
Thank you so much

[jauliadhikari]

18:52 one tier architecture you sir for your efforts.

[yashgodbole]

eVERYTHING YOU EXPLAIN IS GOOD ONLY ONE SMALL FEEDBACK IS PLEASE USE GOOD MIC ACTUALLY YOUR VOICE WAS NOT PROPERLY AUDIBLE EVEN AFTER MY DEVICE VOLUME WAS FULL ...

[anuragtiwari]

3:51:20 chahiye toh Devmanus less than farishtey to the students🥺🙇🙇

[AbhishekKumar-ypsn]

Perfectly explained sir 👍👍I started to show this video at 9:40pm(08/08/2022) and just finished(1:05am). Saw it once, now there need to be revised and practice more & more...!!! Please upload the video of 50 practice questions.

[ankurdahiya]

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

[AdritoDey]

Great Video Lakshya bhaiya! We want the next video on 50 interview level questions. Thanks a lot for giving so much to the community for free

[JamesHalpert]

Definitely hyped up for the SQL interview questions lecture...ready for some hands on now🔥🔥

[heetshah]

EPIC VIDEO!!!! Thank you so much for this. Your teaching style is so great. Everything is TO THE POINT. Most crisp video I have seen on SQL EVER! This would be so helpful.

[sudarshan]

SQL taught like never before... Simple and crisp explanation of concepts...Thank you so much Love Bhaiyya and Lakshay Bhaiyya for this amazing video 🙏🏻🙏🏻

[yashparalikar]

Huge thanks to Laksh Bhaiya for teaching us SQL! Your guidance has been invaluable, and we're now confident in querying databases. Grateful for your support!
And yes, we need 50 Interview Questions on SQL!!!

[akshatsharma]

A grand comeback with a bang.The video we needed the most.

[EpicShorts]

finally i got the required video which made me understand SQL in a better way. After watching so many videos on You made the whole SQL easier to understand along with most important concepts . Literally TOP NOTCH LECTURE. THANKYOU
for the PRECISE NOTES BIG THANKYOU.

[jeejivisha]

Literally your hard work pays off..Amazinggg series ever

[UEI_HimadriShekharChakraborty]

Definitely looking forward to 50 ques on SQL, it will be of great help for us.

[vipinroy]

Bhai apka tutorial such bahut informative hai, mei non-technical student hu, lekin phir bhi mujhe samajh aaraha hai MySQL. Good Job Bro...