SQL - Complete Course in 9 Hours | SQL One Shot | SQL Full Course by Sumit Sir
HTML-код
- Опубликовано: 8 фев 2025
- 𝐖𝐚𝐧𝐭 𝐭𝐨 𝐌𝐚𝐬𝐭𝐞𝐫 𝐒𝐐𝐋? 𝐋𝐞𝐚𝐫𝐧 𝐒𝐐𝐋 𝐭𝐡𝐞 𝐫𝐢𝐠𝐡𝐭 𝐰𝐚𝐲 𝐭𝐡𝐫𝐨𝐮𝐠𝐡 𝐭𝐡𝐞 𝐦𝐨𝐬𝐭 𝐬𝐨𝐮𝐠𝐡𝐭 𝐚𝐟𝐭𝐞𝐫 𝐜𝐨𝐮𝐫𝐬𝐞 - 𝐒𝐐𝐋 𝐂𝐡𝐚𝐦𝐩𝐢𝐨𝐧𝐬 𝐏𝐫𝐨𝐠𝐫𝐚𝐦 𝐛𝐲 𝐒𝐮𝐦𝐢𝐭 𝐒𝐢𝐫!
"𝐀 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
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)
DID THEY TAUGHT TRIGGERS, WINDOWS FUNCTIONS, STORED PROCEDURES TOO??
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)
how can i get the word document, sir is creating here. thanks
Thanks, it will be helpful
Thank you 😊
God bless you brother !!!
@asparshraj9016
Thanks for the timestamps. If you having a running notes on this. Could you please share it. It will be helpful.
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.
Kitna package hain approx bata dijiye
@@ujjwaltitarmare214 jarra comment thik se padhiyo
@@krishnakumarkumar5710 Phir bi aapne dusro se pata kiya ho..kitna mil jana chayein
@@krishnakumarkumar5710 bro after learning sql then what more should be learn to become data engineer for good package?
Yes i also want to know this things
I have completed your 9 hours SQL training. I have learnt a lot. Thanks for the initiative.
Great
Great video, very informative! Thanks for sharing. Watched it at 2x and finished it in less than 5 hours.
1st of all thanks sir ji, zero se heero ki tayyari mai lag chuka hu lets see aage kahatak jayenge
SQL course is everywhere but not the best explanation... Thanks Sumith Ji.
Ankit bansal SQL is also good
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 :)
thanks for review I hope its genuine
@@LavGarg-s6q yes its a genuine review
Start Date=4-12-2024
0:34 : Database: The Basics
19:54 : SQL Basics
This one is best.. Start to End.. Thank u sir... 😊🙏🏻
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 '.
Thank you Sir for this wonderful tutorial. But would have suggest add individual sessions to previous SQL playlist.
Almost 3 hours into this goldmine, just have one thing to say - FABULOUS way of teaching! 👏
Great to hear!
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 😊
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!
Great video, very informative! Thank you so much for teaching sir.
learned a lot, thank you for the series!
can you make more of these one shot videos on different topics please?
Good job Sumit !! I really got a new insight into learning sql
Starting this course from today 31st jan.
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?
Can you explain better your question?
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
I'm watching and learning, thanks
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
thanks for providing entire course in one video
Really Enjoying Thanks sirji
Thank you Sir
Thank you sir for your hard work regarding student support.
Oh my god thankyou soooo much sir ❤🎉
🎉🎉🎉 this is good for now and this is enough for job role on Sql
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 😊
what is secondary key? is it unique key ?
Thanks a lot Sir 🙏🙏🙏
This video is very helpful sir thank you so much to upload this video
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 ?
Sir, I can't copy and paste inside the page. What is the setting for that ? It is showing
Can't access the clipboard.
In CRUD operations is Update and Delete queries are also included?
in my ssms """ Could not find stored procedure 'show'.""" this error is coming.... and 51:50 also showed error ...
If you could add the Time stamps it would be great
Hi Sir,
Have you covered all concepts in SQL? Is this video sufficient to prepare for interviews? please advise.
great explanation
Order by and distinct will work together if you add order by column name with select.
Sir timestamp given in description are not working can you please fix that.
In session 2 is there update and delete query in the video?
Sir superb explanation
nice thank you so much 👍
Great 👍
Best course on SQL
one completed, today ,excellent
Sir i have completed this video.. But for in my resume what should i mention sql or mysql...? I know sql cames from mysql but not sure...!
SQL
Thanks,
Very useful
sir explanation is good enough but it would be better for learners if you give some pratice sesssion
sir video is awesome but sir please provide next time data also .
I need the software name which sir use for last two sessions please urgently
Sir , Kindly share the practice data set so that we can practice parallely
Waiting for your python course like SQL sir🎉🎉🎉
A very useful sharing ! 😊😊😊
why do we store various data item in multiple table? and then rejoin them to get data in single table?
Good question
are these tables in 3rd normal form. Thank You.
could you please upload advanced concepts as well sir
Sir I want to learn sql in detail.
Do you offer it online. What is the time reqd. to learn it online.
I have zero knowledge of SQL can i start this course and gain expert level knowledge??
can someone provide topics with timestamps please??
Access blocked: This app’s request is invalid
i cannot creéte an account
Please change your logo location. When you write something sometimes below it's not showing
Kindly Correct the Time Stamp Sir???
Do we have videos for Stored proc and Triggers by Sumit??
the way sir is wrting all the notes down is there a way to get this text file ??
Sql notes can be found here -github.com/bigdatabysumitm/NotesOfRUclipsSQLSeries.git
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?
Could you please share sql notes it will be very helpful
Thanks, but will this course be for MySql?
Timestamps please!
📌First Like, first view First Comment
Thank you so much Sir 🪄
i am already enjoying this,does anyone has handwritten pdf
Sql notes can be found here -github.com/bigdatabysumitm/NotesOfRUclipsSQLSeries.git
thank you sir,i want certificate aswell
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
Even im facing pls help
Sir, I can't copy and paste inside the page. What is the setting for that ? It is showing
Can't access the clipboard.
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.
Sql notes can be found here -github.com/bigdatabysumitm/NotesOfRUclipsSQLSeries.git
4:00
'Show' command is not working in MySQL. Why?
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
Please share Full python course aswell sir
planning for it very soon
case when at 4:59:00 enjoy..
Hi Sir, can you share the course notes.
Is this enough for placement ?
Indeed A Awesome 👍 learning
Thanks a lot n lot's 🤝🤝🤝
sir will u provide pl/sql ??
Sir example me "rajes'h" s ke baad single inverted commas kyu lagaya
goormide does not given premission to new container sir
are you doing on command prompt or what
is der any notes providing
Please share the notebook link sir, it's an amazing video
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);
Try this-
INSERT INTO employee (Firstname, middle name, lastname, age, salary, location) VALUES ("Kapil", "Kumar", "Sharma", 28, 10000, "Bangalore");
Triggers, Stored procedures, User defined functions, Cursors, Views missed
Im stuck at loading the container .. It takes ages to load
Hats off to you sir, covered almost all topics, and provide these resources for free, you are an amzing person sir❤❤❤
sir can you make sql in hindi also
Anyone tell me this 9 hrs course is enough for azure data engineer?
Yes
all the codes in the goorm editor i write and execute go away if i dont use the laptop for some time.
Hi sir I need this document to learn your sql code. It's very much important to me.
@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!
same problem here please tell me any alternate method
Where do i get that notes
@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 ??
MySQL workbench
Sir please release python for data engineers
ERROR 1215 (HY000): Cannot add foreign key constraint
also comment here how ur error has been gone so that others will learn and dont waste time searching 😡