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)
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)
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.
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 '.
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!
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 :)
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
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 😊
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?
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
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 😊
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
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
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);
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?
@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!
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.
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??
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
Start Date=4-12-2024
0:34 : Database: The Basics
19:54 : SQL Basics
Great video, very informative! Thanks for sharing. Watched it at 2x and finished it in less than 5 hours.
I have completed your 9 hours SQL training. I have learnt a lot. Thanks for the initiative.
Great
SQL course is everywhere but not the best explanation... Thanks Sumith Ji.
Ankit bansal SQL is also good
1st of all thanks sir ji, zero se heero ki tayyari mai lag chuka hu lets see aage kahatak jayenge
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.
Great video, very informative! Thank you so much for teaching sir.
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 '.
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!
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
in my ssms """ Could not find stored procedure 'show'.""" this error is coming.... and 51:50 also showed error ...
Thank you Sir for this wonderful tutorial. But would have suggest add individual sessions to previous SQL playlist.
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
This video is very helpful sir thank you so much to upload this video
Good job Sumit !! I really got a new insight into learning sql
I'm watching and learning, thanks
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 😊
Oh my god thankyou soooo much sir ❤🎉
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 sir for your hard work regarding student support.
what is secondary key? is it unique key ?
learned a lot, thank you for the series!
can you make more of these one shot videos on different topics please?
Really Enjoying Thanks sirji
Thank you! This is very helpful
Order by and distinct will work together if you add order by column name with select.
thanks for providing entire course in one video
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
Sir timestamp given in description are not working can you please fix that.
Thanks a lot 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 😊
Hi Sir,
Have you covered all concepts in SQL? Is this video sufficient to prepare for interviews? please advise.
If you could add the Time stamps it would be great
great explanation
nice thank you so much 👍
Sir superb explanation
case when at 4:59:00 enjoy..
In session 2 is there update and delete query in the video?
Thanks,
Very useful
sir explanation is good enough but it would be better for learners if you give some pratice sesssion
Great 👍
one completed, today ,excellent
A very useful sharing ! 😊😊😊
Access blocked: This app’s request is invalid
i cannot creéte an account
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
are these tables in 3rd normal form. Thank You.
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
Waiting for your python course like SQL sir🎉🎉🎉
sir video is awesome but sir please provide next time data also .
Sir I want to learn sql in detail.
Do you offer it online. What is the time reqd. to learn it online.
why do we store various data item in multiple table? and then rejoin them to get data in single table?
Good question
can someone provide topics with timestamps please??
Sir, I can't copy and paste inside the page. What is the setting for that ? It is showing
Can't access the clipboard.
Sir , Kindly share the practice data set so that we can practice parallely
'Show' command is not working in MySQL. Why?
4:00
Best course on SQL
Do we have videos for Stored proc and Triggers by Sumit??
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");
Sir example me "rajes'h" s ke baad single inverted commas kyu lagaya
📌First Like, first view First Comment
Thank you so much Sir 🪄
Please change your logo location. When you write something sometimes below it's not showing
all the codes in the goorm editor i write and execute go away if i dont use the laptop for some time.
Indeed A Awesome 👍 learning
Thanks a lot n lot's 🤝🤝🤝
could you please upload advanced concepts as well sir
goormide does not given premission to new container sir
Kindly Correct the Time Stamp Sir???
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?
Timestamps please!
@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
I have zero knowledge of SQL can i start this course and gain expert level knowledge??
Im stuck at loading the container .. It takes ages to load
sir will u provide pl/sql ??
Could you please share sql notes it will be very helpful
Thanks, but will this course be for MySql?
Assalamualikum,
sir may i know total how many session for this mysql covered here?and is it enough for a data analyst ?
thanks.
does MYSQL and groomide have same features?? anyone please reply
@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
Hi Sir, can you share the course notes.
Is Auto-increment only goes with primary key ?
there can only be one auto_increment. you can have it with primary or unique key
Hi sir I need this document to learn your sql code. It's very much important to me.
are you doing on command prompt or what
i am not able to execute all these operations in my SSMS "SQL SERVER MANAGEMENT STUDIO"
Ssms is very complicated
sir can you make sql in hindi also
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/NotesOfTH-camSQLSeries.git
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/NotesOfTH-camSQLSeries.git
i am already enjoying this,does anyone has handwritten pdf
Sql notes can be found here -github.com/bigdatabysumitm/NotesOfTH-camSQLSeries.git
thank you sir,i want certificate aswell
Hi Sir, Can I get the source code for this course ?
Please share the notebook link sir, it's an amazing video
is der any notes providing
Is this enough for placement ?
Anyone please let me know how to download that word document?
Timestamps please
Where do i get that notes
Please share Full python course aswell sir
planning for it very soon
Triggers, Stored procedures, User defined functions, Cursors, Views missed
Hats off to you sir, covered almost all topics, and provide these resources for free, you are an amzing person sir❤❤❤