Day 4: SQL In DBMS | Learn DBMS in 8 Days | Boost Your Job & Placement Prospects

Описание к видео Day 4: SQL In DBMS | Learn DBMS in 8 Days | Boost Your Job & Placement Prospects

In this video, we will delve into SQL in DBMS

Join the journey into data!

Timestamps :
1. SQL from basic to advance- 00:00:00
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
2. Top SQL Interview Question(part-1)- 05:09:16
3. Top SQL Interview Questions(part-2)-05:45:20

Notes for the lecture : https://drive.google.com/file/d/1Ta1K...

Repo for the series : https://github.com/riti2409/Learn-DBM...

Drive link for notes : https://drive.google.com/drive/folder...

Series link :    • Learn DBMS in 8 Days | Boost Your Job...  

You can connect with me here 👇

Linkedin :   / riti2409  
Telegram : https://telegram.me/ritikumari
Instagram :   / 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 #1NF #2NF #3NF #BCNF #databaseanomalies #dataredundancy #dataintegrity #databaseperformance #SQLtutorial #databaserforbeginners #datastructures #algorithms #softwaredevelopment #functionaldependency #attributeclosure #closureset #attributes

Комментарии

Информация по комментариям в разработке