SQL - Complete Course in 3 Hours | SQL One Shot using MySQL

You can join the NEW Web Development batch using the below link.
🔥Delta 3.0(Full Stack Web Development) : https://www.apnacollege.in/course/del...

Early bird offer for first 5000 students only!

International Student (payment link) - https://buy.stripe.com/7sI00cdru0tg10...
---------------------------------------------------

📌 Details about the Delta 3.0 Batch :
Start Date : 7th November, 2023
Alternate day lectures (at 8PM)
Duration - 4.5 months
Each Class duration : 1.5 hour-2hour (alternate days)
Access to the course is for 2 years
Complete Frontend Development with HTML, CSS, Javascript & ReactJs
Complete Backend Development (NodeJs, ExpressJs)
Complete Database -( SQL & MongoDB)
Complete MERN Stack (MongoDB, Express, React, Node)
Real Life and Industry Grade Projects
Live Mentorship Sessions
500+Topic Videos
Certificate will be given on Completion.

Link for SQL Notes : https://drive.google.com/drive/folder...

SQL Timestamps:
Start - 00:00
Introduction to SQL - 01:43
01:48 What is database?
03:45 Types of databases
08:03 Installation of MySQL
13:03 Database Structure
14:21 What is table?
16:29 Creating our first database
22:41 Creating our first table
29:49 SQL Datatypes
37:11 Types of SQL Commands
40:09 Database related queries
43:43 Table related queries
46:11 SELECT Command
47:22 INSERT Command
51:19 Practice Questions
56:25 Keys
01:01:26 Constraints
01:13:04 SELECT Command in Detail
01:15:10 Where Clause
01:21:19 Operators
01:25:21 Limit Clause
01:26:48 Order By Clause
01:29:12 Aggregate Functions
01:32:33 Group By Clause
01:37:51 Practice Questions
01:43:35 Having Clause
01:47:18 General Order of Commands
01:50:31 UPDATE Command
01:56:40 DELETE Command
01:58:41 Revisiting Foreign Keys
02:06:35 Cascading Foreign Keys
02:12:30 ALTER Command
02:15:06 CHANGE and MODIFY Commands
02:20:33 TRUNCATE Command
02:24:00 JOINS in SQL
02:51:23 UNION in SQL
02:53:54 SQL Sub Queries
03:11:26 MySQL Views