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

𝐖𝐚𝐧𝐭 𝐭𝐨 𝐌𝐚𝐬𝐭𝐞𝐫 𝐒𝐐𝐋? 𝐋𝐞𝐚𝐫𝐧 𝐒𝐐𝐋 𝐭𝐡𝐞 𝐫𝐢𝐠𝐡𝐭 𝐰𝐚𝐲 𝐭𝐡𝐫𝐨𝐮𝐠𝐡 𝐭𝐡𝐞 𝐦𝐨𝐬𝐭 𝐬𝐨𝐮𝐠𝐡𝐭 𝐚𝐟𝐭𝐞𝐫 𝐜𝐨𝐮𝐫𝐬𝐞 - 𝐒𝐐𝐋 𝐂𝐡𝐚𝐦𝐩𝐢𝐨𝐧𝐬 𝐏𝐫𝐨𝐠𝐫𝐚𝐦 𝐛𝐲 𝐒𝐮𝐦𝐢𝐭 𝐒𝐢𝐫!
"𝐀 8 𝐰𝐞𝐞𝐤 𝐏𝐫𝐨𝐠𝐫𝐚𝐦 𝐝𝐞𝐬𝐢𝐠𝐧𝐞𝐝 𝐭𝐨 𝐡𝐞𝐥𝐩 𝐲𝐨𝐮 𝐜𝐫𝐚𝐜𝐤 𝐭𝐡𝐞 𝐢𝐧𝐭𝐞𝐫𝐯𝐢𝐞𝐰𝐬 𝐨𝐟 𝐭𝐨𝐩 𝐩𝐫𝐨𝐝𝐮𝐜𝐭 𝐛𝐚𝐬𝐞𝐝 𝐜𝐨𝐦𝐩𝐚𝐧𝐢𝐞𝐬 𝐛𝐲 𝐝𝐞𝐯𝐞𝐥𝐨𝐩𝐢𝐧𝐠 𝐚 𝐭𝐡𝐨𝐮𝐠𝐡𝐭 𝐩𝐫𝐨𝐜𝐞𝐬𝐬 𝐚𝐧𝐝 𝐚𝐧 𝐚𝐩𝐩𝐫𝐨𝐚𝐜𝐡 𝐭𝐨 𝐬𝐨𝐥𝐯𝐞 𝐚𝐧 𝐮𝐧𝐬𝐞𝐞𝐧 𝐏𝐫𝐨𝐛𝐥𝐞𝐦."
𝐇𝐞𝐫𝐞 𝐢𝐬 𝐡𝐨𝐰 𝐲𝐨𝐮 𝐜𝐚𝐧 𝐫𝐞𝐠𝐢𝐬𝐭𝐞𝐫 𝐟𝐨𝐫 𝐭𝐡𝐞 𝐏𝐫𝐨𝐠𝐫𝐚𝐦 -
𝐑𝐞𝐠𝐢𝐬𝐭𝐫𝐚𝐭𝐢𝐨𝐧 𝐋𝐢𝐧𝐤 (𝐂𝐨𝐮𝐫𝐬𝐞 𝐀𝐜𝐜𝐞𝐬𝐬 𝐟𝐫𝐨𝐦 𝐈𝐧𝐝𝐢𝐚) : rzp.io/l/SQLINR
𝐑𝐞𝐠𝐢𝐬𝐭𝐫𝐚𝐭𝐢𝐨𝐧 𝐋𝐢𝐧𝐤 (𝐂𝐨𝐮𝐫𝐬𝐞 𝐀𝐜𝐜𝐞𝐬𝐬 𝐟𝐫𝐨𝐦 𝐨𝐮𝐭𝐬𝐢𝐝𝐞 𝐈𝐧𝐝𝐢𝐚) : rzp.io/l/SQLUSD
𝐖𝐚𝐧𝐭 𝐭𝐨 𝐥𝐞𝐚𝐫𝐧 𝐁𝐢𝐠 𝐃𝐚𝐭𝐚 𝐛𝐲 𝐒𝐮𝐦𝐢𝐭 𝐒𝐢𝐫?
𝐜𝐡𝐞𝐜𝐤𝐨𝐮𝐭 𝐭𝐡𝐞 𝐛𝐢𝐠 𝐝𝐚𝐭𝐚 𝐜𝐨𝐮𝐫𝐬𝐞 𝐝𝐞𝐭𝐚𝐢𝐥𝐬
𝐖𝐞𝐛𝐬𝐢𝐭𝐞 : trendytech.in/...
I have trained over 20,000+ professionals in the field of Data Engineering in the last 5 years.
J𝗼𝗶𝗻 𝗺𝗲 𝗼𝗻 𝗦𝗼𝗰𝗶𝗮𝗹 𝗠𝗲𝗱𝗶𝗮:🔥
🔅Sumit LinkedIn - / bigdatabysumit
🔅Sumit Instagram - / bigdatabysumit
If you haven't subscribed to the channel then please do subscribe for more insightful content
#SQLinternals #AdvancedSQL #OrderOfExecution #bigdata #dataengineering

[@asparshraj9016]

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)

[@ektalamba8497]

how can i get the word document, sir is creating here. thanks

[@maulikshah9078]

Thanks, it will be helpful

[@Mangesh115]

Thank you 😊

[@makarand1985]

God bless you brother !!!

[@sreekanthreddy8360]

@asparshraj9016 Thanks for the timestamps. If you having a running notes on this. Could you please share it. It will be helpful.

[@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)

[@user-rc2uc1kv6w]

DID THEY TAUGHT TRIGGERS, WINDOWS FUNCTIONS, STORED PROCEDURES TOO??

[@krishnakumarkumar5710]

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.

[@ujjwaltitarmare214]

Kitna package hain approx bata dijiye

[@krishnakumarkumar5710]

@@ujjwaltitarmare214 jarra comment thik se padhiyo

[@ujjwaltitarmare214]

@@krishnakumarkumar5710 Phir bi aapne dusro se pata kiya ho..kitna mil jana chayein

[@bullseye9723]

@@krishnakumarkumar5710 bro after learning sql then what more should be learn to become data engineer for good package?

[@darshandave9145]

Yes i also want to know this things

[@TarabShaikh-ij2dt]

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

[@sumitmittal07]

Great to hear!

[@Anubhavkumar2103]

Hii bhai Could you please tell me.. 1. Is this lecture worth it for campus placement. 2. Is the content of this lecture complete or not ? Thank you in advance 😊

[@sunilotari7481]

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

[@sutapakar7522]

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

[@rajashekar4171]

Great

[@BigData-fu6jd]

I have completed the 9-hour video, and it is highly beneficial for beginners to those with intermediate-level experience. It does an excellent job of delving into the internals of SQL, making it very insightful and informative thank you Sumit :)

[@LavGarg-s6q]

thanks for review I hope its genuine

[@BigData-fu6jd]

@@LavGarg-s6q yes its a genuine review

[@sgn1989]

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

[@TradingShriGanesha]

Start Date=4-12-2024 0:34 : Database: The Basics 19:54 : SQL Basics

[@Prasad1487]

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

[@myselfrithish]

Ankit bansal SQL is also good

[@samadhanghutugade9962]

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

[@Sandeepkumar-jj3no]

Order by column is not required to be selected. \ is a skip character which tell the system that not to consider the next character as a wild card Ex: %rohi\%t limit alone does not make scense we use it along with order by . _ is a wild character which tells it is just one character renmember courses in (python, data science) Revise CASE WHEN THEN ELSE END from table name create student_table_new as select * from student = here we have new table but we dont have the constraints of foreign key in student_table_new. in sql we dont have keyword like full outer join so we use union of left join and right join to get hte same. cross join = select * from student join courses

[@mkarvj]

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

[@aamirimran9373]

Oh my god thankyou soooo much sir ❤🎉

[@mtad-health]

I'm watching and learning, thanks

[@sanatlamichhane2949]

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!

[@RahulChougule-w6p]

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

[@shaileshtiwari6700]

Thank you sir for your hard work regarding student support.

[@hitaljain]

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

[@Razakhan-jl3sw]

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

[@sharathkumarvydyam9017]

thanks for providing entire course in one video

[@prasadaraochaduvula4262]

🎉🎉🎉 this is good for now and this is enough for job role on Sql

[@Anubhavkumar2103]

Hii bhai Could you please tell me.. 1. Is this lecture worth it for campus placement. 2. Is the content of this lecture complete or not ? Thank you in advance 😊

[@riddhishah790]

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

[@AnmolSharma-wz3px]

in the example at 7:40:54 we can see that it went for clustered index scan. Is it because customer_id is not a primary key on orders table ?

[@kiranmg4831]

Sir, I can't copy and paste inside the page. What is the setting for that ? It is showing Can't access the clipboard.

[@optionkingrobot]

Really Enjoying Thanks sirji

[@makarand1985]

Thanks a lot Sir 🙏🙏🙏

[@Tiyasha-n1l]

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 '.

[@akshatakarekar5437]

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?

[@SeneXeL]

Can you explain better your question?

[@avgspacelover]

learned a lot, thank you for the series! can you make more of these one shot videos on different topics please?

[@kmthailu2262]

Thank you! This is very helpful

[@Prashanthmutike]

great explanation

[@mahavirsinghrajpurohit8004]

Order by and distinct will work together if you add order by column name with select.

[@chandrasekhar7995]

one completed, today ,excellent

[@mahendranath2504]

nice thank you so much 👍

[@greenshadowooo]

A very useful sharing ! 😊😊😊

[@allurianusha6111]

Sir superb explanation

[@Lets_growww]

Great 👍

[@rajatrj5714]

in my ssms """ Could not find stored procedure 'show'.""" this error is coming.... and 51:50 also showed error ...

[@mdshaquibalam3806]

Best course on SQL

[@sulaimanhasan6272]

Thanks, Very useful

[@BOSS-AI-20]

If you could add the Time stamps it would be great

[@mohammadfurquan241]

📌First Like, first view First Comment Thank you so much Sir 🪄

[@yoursbhansali]

what is secondary key? is it unique key ?

[@kvshalini14]

i could never make goormide container run .I'm getting error that server is unable to retrieve the file .Could someone help me? i tried using in incognito window as well

[@parthasarathy5222]

Even im facing pls help

[@tejasvaidya8464]

Sir timestamp given in description are not working can you please fix that.

[@navjotsingh-hl1jg]

sir video is awesome but sir please provide next time data also .

[@Techwithgk369]

Waiting for your python course like SQL sir🎉🎉🎉

[@koushikchoudhury2179]

Sir , Kindly share the practice data set so that we can practice parallely

[@santoshkiran5858]

Indeed A Awesome 👍 learning Thanks a lot n lot's 🤝🤝🤝

[@VinodKopuri-r4k]

could you please upload advanced concepts as well sir

[@manikumar9015]

sir explanation is good enough but it would be better for learners if you give some pratice sesssion

[@SunilSonawane-j1k]

why do we store various data item in multiple table? and then rejoin them to get data in single table?

[@RahulKumar-me3eb]

Good question

[@gopichand5717]

Please share Full python course aswell sir

[@sumitmittal07]

planning for it very soon

[@TasmiyaZaheer-k5j]

sir please help , in the insert values command i keep getting this error ERROR 1054 (42S22): Unknown column 'kapil' in 'field list', the insert command i typed is exactly as told by you; INSERT INTO employee (Firstname, middlename, lastname, age, salary, location) VALUES (kapil,kuma r, sharma, 28, 10000, banglore);

[@asparshraj9016]

Try this- INSERT INTO employee (Firstname, middle name, lastname, age, salary, location) VALUES ("Kapil", "Kumar", "Sharma", 28, 10000, "Bangalore");

[@AyushSingh-m5o]

i am already enjoying this,does anyone has handwritten pdf

[@sumitmittal07]

Sql notes can be found here -github.com/bigdatabysumitm/NotesOfKZbinSQLSeries.git

[@AyushSingh-m5o]

thank you sir,i want certificate aswell

[@ramdicharlie5811]

sir can you make sql in hindi also

[@Prasad1487]

case when at 4:59:00 enjoy..

[@nagarjunmopuru7003]

Could you please share sql notes it will be very helpful

[@iffathunnisa6905]

can we get the link or anything of the notes file you are maintaining everything in,so its easy for us to back and revise the concepts.

[@sumitmittal07]

Sql notes can be found here -github.com/bigdatabysumitm/NotesOfKZbinSQLSeries.git

[@syedroshan8449]

Hats off to you sir, covered almost all topics, and provide these resources for free, you are an amzing person sir❤❤❤

[@abhishekbandil1737]

the way sir is wrting all the notes down is there a way to get this text file ??

[@sumitmittal07]

Sql notes can be found here -github.com/bigdatabysumitm/NotesOfKZbinSQLSeries.git

[@pandiripavankumar3333]

Sir I want to learn sql in detail. Do you offer it online. What is the time reqd. to learn it online.

[@NishantGautam-ju9sr]

@sumit Hi I am starting to learn SQL, groomide is giving a lot of issues in creating queries Is there any substitute available that I can use ??

[@akhilchintu6938]

Hi Sir, can you share the course notes.

[@chiranjibguragain3076]

can someone provide topics with timestamps please??

[@saumyakumari3441]

Is Auto-increment only goes with primary key ?

[@DeepakTiwari-et3bd]

there can only be one auto_increment. you can have it with primary or unique key

[@pranavganesh1855]

Do we have videos for Stored proc and Triggers by Sumit??

[@sowmiyasri173]

Timestamps please!

[@shwethamahendrakar4384]

is der any notes providing

[@knight2000-NC]

are these tables in 3rd normal form. Thank You.

[@tejasviadepu4359]

@Trendytech Insights: Are there any free tools we can use for the SQL? Goorm errors out while creating a container, it say unable to create the container. Please @Sumit Sir advise!

[@krishnamohan-tn6br]

same problem here please tell me any alternate method

[@atulanand4824]

Please share the notebook link sir, it's an amazing video

[@Rohitkumar-ms8pt]

whatever command I give always getting this error- "command not found" any idea? Thanks in advance

[@sumitmittal07]

Can you share the commands that you are trying to execute and in which environment are you executing the commands

[@Rohitkumar-ms8pt]

Hi @@sumitmittal07 I am following the video exactly step by step -created account of goorm -created a container - gave command- msql-ctl-cli; (ps- this is my first intro to SQL, I am extremly new. Probably I am missing something) Thanks in advance!

[@whyme_141]

Lot of people are facing this issue. M also facing this issue. Any solution?

[@akkys97]

Kindly Correct the Time Stamp Sir???

[@paxipulpax745]

Access blocked: This app’s request is invalid i cannot creéte an account

[@ronitson_lima]

Please change your logo location. When you write something sometimes below it's not showing

[@figh761]

I have question : does the sql syntax is different for sql server, mysql and oracle. How you prepare for a sql developer test. Should I learn all these flavours

[@princeyadav-fz9kh]

sir will u provide pl/sql ??

[@Njooo5]

Thanks, but will this course be for MySql?

[@kiranmg4831]

Sir, I can't copy and paste inside the page. What is the setting for that ? It is showing Can't access the clipboard.

[@Sheebakhanam-y4e]

'Show' command is not working in MySQL. Why?

[@rajatrj5714]

i am not able to execute all these operations in my SSMS "SQL SERVER MANAGEMENT STUDIO"

[@whyme_141]

Ssms is very complicated

[@FLASHTUBE1552]

Sir example me "rajes'h" s ke baad single inverted commas kyu lagaya

[@anithakarunajyothiainala2935]

Please give me handwritten notes sir

[@SonPham-yn9nc]

Indian IT > teacher > course in college

[@EquipteHarry]

Wilson Brian Lee Matthew Lopez Cynthia

[@nysankofficial]

at what time does he show how to download the MySQL??

[@jackymarcel4108]

Martinez Nancy Gonzalez Angela Miller Gary

[@maddyy1024]

does MYSQL and groomide have same features?? anyone please reply

[@JAVEDKHAN-nh2tw]

Sir please release python for data engineers

[@Tony_stark551]

I have zero knowledge of SQL can i start this course and gain expert level knowledge??

[@ShyamSundar-bw9yv]

Can someone tell me is this the complete tutorial of SQL or is there any other topics to be learnt? Is this enough If I watch this full video to learn SQL completely?

[@krishnamohan-tn6br]

goormide does not given premission to new container sir

[@amulyaneupane8216]

Can I get your favorite notepad file, please.

[@ranjithraghunathan1267]

all the codes in the goorm editor i write and execute go away if i dont use the laptop for some time.

[@beticohernandez9536]

Buen video

[@SHAKEB1000]

Sir ne hair transplant krwaya hai kya?BTW handsom lag rahai hai

[@sivakumarreddythathireddy2539]

Anyone tell me this 9 hrs course is enough for azure data engineer?

[@myselfrithish]

Yes

[@pritomswarnakar4343]

Hi sir I need this document to learn your sql code. It's very much important to me.

[@rabeeahmohammedyaqeen3956]

are you doing on command prompt or what