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