In this video, we delve into Complete SQL Course for Beginners
Join the journey into data!
Announcement video(with syllabus) :
https://youtu.be/eylFMNSJCQo
Notes for the lecture : https://drive.google.com/drive/folders/1jM3nZuSjJHkX2E-X3ov8qF77wFm21fvr?usp=sharing
Repo for the series : https://github.com/riti2409/Dbms_Series
Drive link for notes : https://drive.google.com/drive/folders/1mTp-XiRQ3i31PfBi7sEWmzV0oIgzuHJK?usp=sharing
Series link : https://youtube.com/playlist?list=PLrL_PSQ6q062cD0vPMGYW_AIpNg6T0_Fq
Timestamps: (hour : minutes : seconds)
L1 : Lets Start with SQL-
00:00:17
L2 : What is SQL-
00:05:24
L3 : MySQL Installation -
00:08:58
L4 : Types of SQL Commands-
00:13:11
L5 : Databases and related SQL commands-
00:18:26
L6 : Tables and related SQL command-
00:37:08
L7 : Building a Database- From Tables to data insertion-
00:45:33
L8 : Datatypes in SQL-
00:53:24
L9 : Keys in SQL-
01:03:36
L10 : Constraints in SQL-
01:09:23
L11 : Foreign Key in SQL-
01:24:32
L12 : Update Command in SQL-
01:37:35
L13 : Delete Command in SQL-
01:49:55
L14 : Select Command in SQL-
01:53:24
L15 : Where Clause in SQL -
01:55:29
L16 : ALTER Command in SQL-
01:58:59
L17 : RENAME Command in SQL-
02:09:09
L18 : TRUNCATE Command-
02:13:13
L19 : Difference between TRUNCATE, DELETE & DROP in SQL -
02:16:29
L20 : Distinct Keyword in SQL-
02:18:31
L21 : Operators in SQL-
02:23:20
L22 : Clauses in SQL-
02:39:03
L23 : Aggregate Functions in SQL-
02:47:50
L24 : GROUP BY and HAVING clause in SQL -
02:57:35
L25 : Difference between HAVING and WHERE clause in SQL-
03:08:45
L26 : Practice Question on clause and Aggregate Function in SQL-
03:11:26
L27 : General Order of SQL command-
03:23:44
L28 : Joins in SQL-
03:25:31
L29 : Inner Join in SQL-
03:31:28
L30 : Left Outer Join in SQL -
03:37:56
L31 : Right Outer Join in SQL-
03:41:43
L32 : Full Outer Join in SQL-
03:44:34
L33 : Cross Join in SQL-
03:51:46
L34 : Self Join in SQL-
03:56:54
L35 : Exclusive Joins in SQL- 04:!
0:48
L36 : UNION and UNION ALL in SQL-
04:21:16
L37 : Subqueries in SQL-
04:30:16
L38 : Nth Highest Salary in SQL-
04:45:21
L39 : Stored Procedure in SQL-
04:52:05
L40 : Views in SQL-
04:56:36
You can connect with me here 👇
Linkedin : https://www.linkedin.com/in/riti2409
Telegram : https://telegram.me/ritikumari
Instagram : https://instagram.com/ritikumariupadhyay24
Twitter : https://x.com/riti2409
#ritikumari #dbmsseries #placementsprep #semesterexams #databasemanagement #techeducation #careerboost #examsuccess #techskills #interviewprep #academicexcellence #databaseconcepts #learningjourney #data #databases #dbms #databasenormalization #databasedesign #SQL #relationaldatabases #datamodeling #datamanagement #databaseoptimization #databasetheory #computerscience #SQL #MySQL #SQLTutorial #LearnSQL #SQLCourse #Database #Programming #Coding #TechEducation #SQLForBeginners #SQLTraining #WebDevelopment #DataScience #TechTutorial #FullCourse