SQL - Complete Course in 9 Hours | SQL One Shot | SQL Full Course by Sumit Sir

𝐖𝐚𝐧𝐭 𝐭𝐨 𝐌𝐚𝐬𝐭𝐞𝐫 𝐒𝐐𝐋? 𝐋𝐞𝐚𝐫𝐧 𝐒𝐐𝐋 𝐭𝐡𝐞 𝐫𝐢𝐠𝐡𝐭 𝐰𝐚𝐲 𝐭𝐡𝐫𝐨𝐮𝐠𝐡 𝐭𝐡𝐞 𝐦𝐨𝐬𝐭 𝐬𝐨𝐮𝐠𝐡𝐭 𝐚𝐟𝐭𝐞𝐫 𝐜𝐨𝐮𝐫𝐬𝐞 - 𝐒𝐐𝐋 𝐂𝐡𝐚𝐦𝐩𝐢𝐨𝐧𝐬 𝐏𝐫𝐨𝐠𝐫𝐚𝐦 𝐛𝐲 𝐒𝐮𝐦𝐢𝐭 𝐒𝐢𝐫!

"𝐀 8 𝐰𝐞𝐞𝐤 𝐏𝐫𝐨𝐠𝐫𝐚𝐦 𝐝𝐞𝐬𝐢𝐠𝐧𝐞𝐝 𝐭𝐨 𝐡𝐞𝐥𝐩 𝐲𝐨𝐮 𝐜𝐫𝐚𝐜𝐤 𝐭𝐡𝐞 𝐢𝐧𝐭𝐞𝐫𝐯𝐢𝐞𝐰𝐬 𝐨𝐟 𝐭𝐨𝐩 𝐩𝐫𝐨𝐝𝐮𝐜𝐭 𝐛𝐚𝐬𝐞𝐝 𝐜𝐨𝐦𝐩𝐚𝐧𝐢𝐞𝐬 𝐛𝐲 𝐝𝐞𝐯𝐞𝐥𝐨𝐩𝐢𝐧𝐠 𝐚 𝐭𝐡𝐨𝐮𝐠𝐡𝐭 𝐩𝐫𝐨𝐜𝐞𝐬𝐬 𝐚𝐧𝐝 𝐚𝐧 𝐚𝐩𝐩𝐫𝐨𝐚𝐜𝐡 𝐭𝐨 𝐬𝐨𝐥𝐯𝐞 𝐚𝐧 𝐮𝐧𝐬𝐞𝐞𝐧 𝐏𝐫𝐨𝐛𝐥𝐞𝐦."

𝐇𝐞𝐫𝐞 𝐢𝐬 𝐡𝐨𝐰 𝐲𝐨𝐮 𝐜𝐚𝐧 𝐫𝐞𝐠𝐢𝐬𝐭𝐞𝐫 𝐟𝐨𝐫 𝐭𝐡𝐞 𝐏𝐫𝐨𝐠𝐫𝐚𝐦 -

𝐖𝐚𝐧𝐭 𝐭𝐨 𝐥𝐞𝐚𝐫𝐧 𝐁𝐢𝐠 𝐃𝐚𝐭𝐚 𝐛𝐲 𝐒𝐮𝐦𝐢𝐭 𝐒𝐢𝐫?
𝐜𝐡𝐞𝐜𝐤𝐨𝐮𝐭 𝐭𝐡𝐞 𝐛𝐢𝐠 𝐝𝐚𝐭𝐚 𝐜𝐨𝐮𝐫𝐬𝐞 𝐝𝐞𝐭𝐚𝐢𝐥𝐬

I have trained over 20,000+ professionals in the field of Data Engineering in the last 5 years.

J𝗼𝗶𝗻 𝗺𝗲 𝗼𝗻 𝗦𝗼𝗰𝗶𝗮𝗹 𝗠𝗲𝗱𝗶𝗮:🔥

If you haven't subscribed to the channel then please do subscribe for more insightful content

#SQLinternals #AdvancedSQL #OrderOfExecution #bigdata #dataengineering

[asparshraj]

I have started from the aggregate functions, as I continue, I will add all the timestamps.
0:34 : Database: The Basics
19:54 : SQL Basics
36:05 : CRUD operations in SQL
1:12:22 : Primary Key vs Unique Key
1:39:17 : DDL vs DML commands
2:18:27 : Foreign Key constraint
3:01:14 : Distinct, Order By, Limit, Like clause in SQL
3:47:48 : Aggregate Functions
4:20:11 : More Data Types
4:40:02 : Logical Operators
4:57:14 : CASE WHEN statements
5:07:34 : Joins
5:40:24 : Important SQL Interview Questions
5:58:35 : Over() and Partition by clauses
6:16:12 : Windows function (row_num())
6:31:20 : Windows function (rank(), dense_rank())
6:49:37 : Indexes and Order of Execution in SQL
7:53:07 : SQL WITH clause (common table expression)

[shrutisamal]

0:34 : Database: The Basics
19:54 : SQL Basics
36:05 : CRUD operations in SQL
1:12:22 : Primary Key vs Unique Key
1:39:17 : DDL vs DML commands
2:18:27 : Foreign Key constraint
3:01:14 : Distinct, Order By, Limit, Like clause in SQL
3:33:13 : Order of execution
3:47:48 : Aggregate Functions
4:20:10 : Other data types(decimal, timestamp)
4:40:02 : Logical operators(not, not like, or, between, not between, in, not in, case statements)
5:07:34 : Joins
5:40:24 : Where vs Having (Important for SQL Interview)
5:58:35 : Over() and Partition by clauses
6:16:12 : Windows function (row_num())
6:31:20 : Windows function (rank(), dense_rank())
6:49:37 : Indexes and Order of Execution in SQL (seek, scan, clustered index, non-cluster index)

[krishnakumarkumar]

The way you teach is the reason behind people becoming Data engineer and getting good packages after taking your training. I will be one of them soon. Thanks LORD Sumit Mittal.

[sutapakar]

I have completed your 9 hours SQL training. I have learnt a lot. Thanks for the initiative.

[sgn]

Great video, very informative! Thanks for sharing. Watched it at 2x and finished it in less than 5 hours.

[sunilotari]

1st of all thanks sir ji, zero se heero ki tayyari mai lag chuka hu lets see aage kahatak jayenge

[Prasad]

SQL course is everywhere but not the best explanation... Thanks Sumith Ji.

[sanatlamichhane]

Great video! I've been wanting to grasp this SQL concept for a while, and your explanation really helped me finally nail it. However, when it comes to Common Table Expressions (CTE), I felt a bit lost. I might need to delve deeper into CTE, but thank you for creating such an informative video!

[TarabShaikh-ijdt]

Almost 3 hours into this goldmine, just have one thing to say - FABULOUS way of teaching! 👏

[samadhanghutugade]

This one is best.. Start to End.. Thank u sir... 😊🙏🏻

[mkarvj]

Great video, very informative! Thank you so much for teaching sir.

[Tiyasha-nl]

hi sir, for enrollment date by using only timestamp is throwing error, it needs to be updated to 'enrollment_date TIMESTAMP DEFAULT current_timestamp NOT null '.

[riddhishah]

Thank you very informative and simple to understand the way you are explaining.

I have completed first session I have a query when to use uppercase and when lowercase while typing query
Thank you

[RahulChougule-wp]

Thank you Sir for this wonderful tutorial. But would have suggest add individual sessions to previous SQL playlist.

[akshatakarekar]

Hello Sumit, just into an hour of this course and loving it so far. A follow up question- For the part where you showed how when middle name is not given while inserting it sets a null value to it but how does the compiler know that it is null for middle name and not for other string values such as firstname or last name?

[Razakhan-jlsw]

Good job Sumit !! I really got a new insight into learning sql

[hitaljain]

This video is very helpful sir thank you so much to upload this video

[shaileshtiwari]

Thank you sir for your hard work regarding student support.

[yoursbhansali]

what is secondary key? is it unique key ?

[mtad-health]

I'm watching and learning, thanks