SQL Timestamps: Start - 00:00 Introduction to SQL - 01:43 01:48 What is database? 03:45 Types of databases 08:03 Installation of MySQL 13:03 Database Structure 14:21 What is table? 16:29 Creating our first database 22:41 Creating our first table 29:49 SQL Datatypes 37:11 Types of SQL Commands 40:09 Database related queries 43:43 Table related queries 46:11 SELECT Command 47:22 INSERT Command 51:19 Practice Questions 56:25 Keys 01:01:26 Constraints 01:13:04 SELECT Command in Detail 01:15:10 Where Clause 01:21:19 Operators 01:25:21 Limit Clause 01:26:48 Order By Clause 01:29:12 Aggregate Functions 01:32:33 Group By Clause
First of all thank you for the lecture, it would be great if you also teach Devops or Machine Learning or Deep Learning subjects from an industrial perspective, big data management is also great, or may be launch a course on that because your way of teaching is more understandable than others. Thanks again.
Hi Shradha Didi, you've explained the concepts from basics so nicely. It's awesome! Mujhe lagta hai ki aap coding sikhane ke liye hi is dharthi par aaye hain. I'm so impressed by your lecture.
Such an informative video I am an aspiring data analyst and from past 8-9 months I have been learning different concepts, I wanted something that can have a kind of short and comprehensive information to polish my knowledge, this is exactly what I was looking for. Thank you.👍
This Chanel is A blessing to all the Cs/It Engineers💯
Excellent class Shradha, I seriously learned SQL from this video. You made it very crisp and clear. Thanks a lot, Shradha 🙏🙏🙏🙏🙏🙏
That's an amazing explanation! Would you be able to create a course on NoSQL as well? Just a suggestion—adding extra clips on CTEs, Window Functions, Stored Procedures, and Query Optimization would make this an even more comprehensive SQL course. You're doing an incredible job! Keep it up!
This is the one which we are in need of Shraddha ma'am. Hat's off for your valuable content. Keep doing this for needy students.
1:08:19 Set Default Value 1:10:36 Check Constraint 1:14:44 Distinct 1:15:11 Where Clause 1:25:19 Limit Clause 1:32:35 Group Clause 1:43:37 Having Clause
Shraddha, I am not a college student preparing for placements but a senior consultant at an MNC. I needed to learn SQL but you teach so well, so much better than our corporate trainers, I am extremely grateful to you and your team for creating such content. I request you to create it also for young professionals in mind. Like data scientists.
Very much helpful for class 12th CS Students.....Thank you 😊
3:05:15 The question can also be solved using a simple SQL query - SELECT rollno, name FROM student WHERE rollno%2 = 0; I am able to come up with such solutions bcoz of your crystal clear explanations and coverage of all the topics really well.
Bravo Shradha, enjoyed this course very much and learned a lot, I am new to data analytics and was looking for some easy course online and now happy that I found your videos.
1 hour into the video ! fantastic clear explanation. Probably the best SQL video i've stumbled upon!
2:44:30 -- Full exclusive JOIN SELECT * from student as s LEFT JOIN course as c on s.student_id=c.student_id where c.student_id is null UNION SELECT * from student as s RIGHT JOIN course as c on s.student_id=c.student_id where s.student_id is null;
I really benefited your previous lecture html and css❤ now SQL. Your are not a tutor, ur a shooter😊 well presentation & able to remember the CONCEPTS. {Wating for the JAVASCRIPT Lecture.} Thanks a lot for your valueable time. Jaihind....
Shraddha, thank you so much! You have made my life and work much easier. I have been struggling to understand SQL for some time, but you made it seem like a breeze!
I have completed thus whole lecture with practice set and notes. Thank you for this amazing tutorial. Please create one shot for C++ as well.
mindblowing lecture! pura samjh agya. Excellent for beginerrs who want to learn each and every concept thoroughly
@AmanDhattarwal