L38 : Complete SQL Course for Beginners | Full Tutorial in One Video

L38 : Complete SQL Course for Beginners | Full Tutorial in One Video

237.826 Lượt nghe
L38 : Complete SQL Course for Beginners | Full Tutorial in One Video
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