SQL - Complete Course in 3 Hours | SQL One Shot using MySQL
HTML-код
- Опубликовано: 31 июл 2024
- You can join the NEW Web Development batch using the below link.
🔥Delta 3.0(Full Stack Web Development) : www.apnacollege.in/course/del...
Early bird offer for first 5000 students only!
International Student (payment link) - buy.stripe.com/7sI00cdru0tg10...
---------------------------------------------------
📌 Details about the Delta 3.0 Batch :
- Start Date : 7th November, 2023
- Alternate day lectures (at 8PM)
- Duration - 4.5 months
- Each Class duration : 1.5 hour-2hour (alternate days)
- Access to the course is for 2 years
- Complete Frontend Development with HTML, CSS, Javascript & ReactJs
- Complete Backend Development (NodeJs, ExpressJs)
- Complete Database -( SQL & MongoDB)
- Complete MERN Stack (MongoDB, Express, React, Node)
- Real Life and Industry Grade Projects
- Live Mentorship Sessions
- 500+Topic Videos
- Certificate will be given on Completion.
Link for SQL Notes : drive.google.com/drive/folder...
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
01:37:51 Practice Questions
01:43:35 Having Clause
01:47:18 General Order of Commands
01:50:31 UPDATE Command
01:56:40 DELETE Command
01:58:41 Revisiting Foreign Keys
02:06:35 Cascading Foreign Keys
02:12:30 ALTER Command
02:15:06 CHANGE and MODIFY Commands
02:20:33 TRUNCATE Command
02:24:00 JOINS in SQL
02:51:23 UNION in SQL
02:53:54 SQL Sub Queries
03:11:26 MySQL Views
Great Lecture & thank you Shradha Ma'am : )
Some student please share timestamps so that other students can also benefit.
Aman Bhaiya , please launch NODE JS free course
I am facing problem in Middleware and JWT authentication
Im sure that Shraddha didi can make my concepts crystal clear
Please get NODE JS course
Wow ❤❤
Please Java Script par ek lecture ❤
Please Bhaiya JavaScript par bhi video banao
@@HSKhan-lc5pk Javascript ka bahut courses hai
TypeScript ka course chahiya Jo javascript ka superset hai
1 hour into the video ! fantastic clear explanation. Probably the best SQL video i've stumbled upon!
Only for beginners
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.
2:44:24 Homework problem solution:
select *
from student as a
left join course as b
on a.id = b.id
where b.id is null
union
select *
from student as a
right join course as b
on a.id = b.id
where a.id is null;
This is correct. Even the code of Full outer join where we do left join union right join should also give us the output for full exclusive join right?
Please correct me if I am wrong.
@@snehasamuel7426 No that's not correct.
It gives output for the common in both table too which is not suitable for output for full exclusive join.
same logic i applied and then i started reading comments , so it's giving common output as madam said , they want overlapping output how is this possible ?
Great!!
Kisi ne to try Kiya answer Dene ka
To mujhe v pehle union lga tha
But jb overlapping wala part ni lena h to union ki jagah intersection hona chahiye according to me baki ap sb btao
@@safiaq_ueen try this , this query will join both table but it wll return where a.id is same as b.id
select * from student as a
full join cousre as b
on a.id=b.id
where a.id=b.id
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....
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:47
MAST samjh aye apki video ki,
University ki bhi teacher axhi parhati hai but jab dil nhi krta parhnay ka,
jab k wahan paisay detay hai ,yahan muft parhtay hai,
thanks a lot.
Constraints in SQL: १)not null
२) unique
३) primary key
४) foreign key
५) default
६) check
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.
Relatable
Wow senior consultants also watching
A Lucidic Learnings, Mam.
It Is Not Only Wonderful But Gr8 Too.
Thank You For Keeping It Understandable For Lay Man.
Could It Be Possible To Complete Entire Power BI With These Essentials, Under Your Mentorship.
Please Guide.
Regards.
Hlo sir
@@Gatefighter886 hlo
Excellent class Shradha, I seriously learned SQL from this video. You made it very crisp and clear. Thanks a lot, Shradha 🙏🙏🙏🙏🙏🙏
Chala easy way lo teach chestunnaru superb sir...inka SQL classes continue cheyandi
I'VE A DATABASE SUBJECT IN MY COURSES .IT'S MY HALF OF THE SEMESTER .WITHIN 3 HRS YOU JUST TAUGHT WHAT OUR TEACHER COULD'NT
😂😂
A very good explanation of SQL. Your articulation and ability to break thru concepts is brilliant. I am on the first 20 mins and hope to complete this course this week. Thank you
Bruh u R slow as hell
This takes hardly 2-2.5 hours to fully understand and learn
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.
Simplest explanation can be "Great"
its not the first course i have been following Apna College but this SQL hits different.
Please try to make a course on MongoDB as well and Hadoop/Spark.
Thank you!! One of the best classes about mySQL, really enjoyed it!!
This is the best MySQL video on internet so far .. covering all the topics without consuming much time thank you so much Shraddha ma'am
Didi we want a full course on Javascript 😊
Please do it
Yes
Yes we want
Yes ✋
Yes
A heartful thanks to you mam , in 3 hours u gave a fantastic overview of SQL and its queries .Hats off to you !!
आप बहुत अच्छा समझते हो जो शब्दों में बया नहीं हो सकता मैं काफी समय से Sql or MySql में Confuse tha .पर अब मेरे सारे dubt पूरे हो गए हैं
Bhai SQL or my sql m antar h kya
Very good lecture. Covered all the basics. Very good for someone who is beginning to learn SQL. Thankyou
I hope this message finds you in good state of life and health.
I watched and completed SQL with practice.
You are a very good teacher and your way of explain is very very easy. I want you add triggers with this shot. Because I think it's important but you better knows then me.
In the last one time again thanks for your kindness.
My totally prayers for you.
I wish you will be always happy❤❤❤.
Superb excellent Shradha,... This is my first class on SQL, you made so easier than learning ABCs
I am watching apna college content for the first time and I am obsessed! Clean to-the-point explanation. Loved it!
Great Lecture , very simple and easy way of teaching with clear examples which are highly appreciated. once again thanks
Your short lecture covered all the relevant topics which is necessary for mysql. Thank you very much mam..
this was an Amazing course Shardha. Crisp, clear, to the point and very easy to understand. Thank you!
Hi Shraddha
Fantastic explanation which helps viewers to get thorough understanding.
Looking forward to have you more vedios on New Technologies.
Great Dedication
🙂
The explanation is straightforward, and it aided me greatly in revising SQL.
Thank you for making this course it helped me alot to revise all the topics from the scratch!! Please continue to making this type of Full course video again thank you 🙏
I request you to make series on data science. Your teaching is so much good that many of us are benefiting 🎉
How did you manage to learn so many things.? Its amazing how you know everything even though you are so young. Respect✌
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.
exactly but she wanted to show usage of the subquery as an example else i came up with same idea as yours😅
Does sql requires logic?
@@sanjanahalli1174 obviously.. SQL is a language used for getting solutions to some problems.. and solving any problem requires logic.
I’m grateful for the video sources you've shared with us. They've enriched our learning experience with dynamic visuals and engaging content. Your contribution is greatly appreciated!
Didi make full playlist on python please
@@40princerathod9-a2already cwh made it
ruclips.net/video/o8SUz0CGM1k/видео.htmlsi=dT5VmEJfVFkYceIqv
bot comment lmaoo
It's really helpful for beginners who are interested in learning MySQL. The best video! Must Watch 👍
This course is fantastic✨✨✨! I kindly request that you arrange additional content on Data Science and Machine Learning. I am very happy with the excellent graphics and the strategic management of the video arrangements.
i din't take full lecture yet ...still in between i must say the way you are explaining which is extremely phenomenal...keep shining...all the best...
Thanks for providing this wonderful lecture about SQL . I always wanted to learn SQl from Shradha Didi , but I didn't get opportunity before , Now I am able to get this opportunity to learn SQl from Shradha Didi and I pray Please make more lectures like this
For SQL dotnet MVC api pratical
www.youtube.com/@dotnetsqlmaster?sub_confirmation=1
Easy to understand and grasp knowledge
Nonderful video and explanation; kudos to
your efforts and easy explanation.
Thank you Didi I have brushed up my mySQL skill for my interview. Thank you for making such a sort and detailed video it covered almost every topic of MySQL.
Thank you for giving a great lecture on SQL .....This is so beneficial for every person who has cse department.....God always bless uh mam....you tells everything with best way....
The best video I have come across. Beginners also can understand easily by the way she is explaining.
I am here bcz tomorrow is my UT in which SQL is coming.
I'm in 11th class.
Very informative lecture...portrayed SQL in a very easy and interesting manner, thank you!
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.👍
hi have you got placed in any organization??
same question, have you?
Not yet but hopefully I will get placed, looking for opportunities.
Is this course complete, like if I finish it.. will I be prepared for an entry level role at SQL?
what languages we have to study for becoming a data anaylst
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!
Shraddha is your friend
@@deepakn7961 Yes she is her friend
maam bolo
Hii
Thank you so much Shradha mam. This really helps me a lot. I want to be a Marketing Research Analyst and for that SQL, python are the basic requirements. The way you teach is really awesome. I am from commerce background but still i learnt everything so smoothly. You are a great teacher. Thank you Guru ji.
Did you got a job?
Ma'am I am from commerce background, and I want to switch my career to data analytics, I was nervous because I thought it would be hard but really it was so easy to understand because of you I learned so well, I really appreciate the efforts you have taken to teach the SQL from scratch.
what roadmap are you following?
in which way u are going to complete the sql iam also from commerce background
Shraddha didi thanks for your great Explanation.. This 3hrs was a lot more than what college teaches us..
Thank you didi❤😊😊
Thanks mam for the wonderful knowledge you have shared with us ...also a kind request to you to create video exclusively on real time scenario questions on SQL and advanced SQL concepts
09:03 Learn SQL in 3 hours with MySQL
26:21 Understanding Join Operations in SQL
52:41 Subqueries in SQL
1:03:59 MySQL commands for creating databases and tables
1:31:44 Advanced SQL operations and functions
1:45:34 Using joins to connect data from multiple tables
2:20:01 Complete SQL course covering all aspects in 3 hours
3:05:02 Basic SQL queries and concept
Yash bhai...Kal paper Hai kya cs ka?
Thanks for the lecture, help a lot for 12th CBSE sql, very nice explanation
After watching this video I can add SQL in my resume as technical skills 😁🤪
😂
GOOD IDEA
I am here after added 😅
😂
@@Helloworld0809 now I know SQL language only . next what should be learned in database related ?....which help further iny projects for backend
SQL matlab structured query language but in my view SQL matlab : --- SHRADHA the QUEEN of all LANGUAGES
Nice try
@@galaxygaming5289😅😅😅
अति उत्तम ✋
Nahi aega reply bhai
Nahi degi💀
I haven't felt this much confident in SQL before watching this video...Absolute Carnage Ma'am!! Thank You!
A big Thank you from all the learners. 🙏🙏
One of the best lecture in the whole youtube regarding database😊 thankyou so much mam
Simply Amazing for Both Learning and Revision.
Amazing course mam !!
You taught it soo well and made it easy for the beginners like me , thankyou so much ..
Never felt confidence in SQL but after watching this definitely feel good and confident about SQL!
I was thinking that I wish Shraddha mam would have made a SQL tutorial and today it became true.💝💗😍🤝
Thankyou so much mam...
same here :)
Thank you so much Shraddha di..for making this amazing SQL video. It's very helpful for our interview❤❤
such a sorted explanation, you explain things without making it complicated. Very good explanation.
Thankyou so much for providing such an amazing course, kudos to you and all the best for the future :)
Thank you for the awesome SQL lecture! Your explanations are super clear and beneficial for us. Your clear explanations are a true gem.
wellcome
wow kitna achi youtuber hai , hum logo ki time ki value ko samjhti hai , installation ko 2x pe chala ke video edit hai jo ki required tha👍
Age dekha na Bhai, ki khush hokar chala gya
@@abbhushan🤣🤣🤣🤣🤣
Aur main jo 2X pe video chala rha tha, achanak laga ke Space button corrupt hogaya!!
Thank you so much madam.With this explanation, i have understood what to learn and understand the concepts in SQL.I have a clear idea on this.
The way you are explaining each and every point is very smooth, I have learnt so many thing with this video....thanku so much mam
This Chanel is A blessing to all the Cs/It Engineers💯
i'm not a computer student not a 1 line of code knowledge i have but randomly i clicked on this video and feel that any one who have knowledge can learn SQL by watching shradha mam's video.
thank you mam for your this kind of experience sharing with us.
😀👌👍
Excellent explanation, the concepts are explained so easily that all my doubts got clarified. Thank you for the content mam.
Thank you so much Shradha Ma'am for teaching me a valuable lesson through your wonderful course. I deeply appreciate your effort and dedication. This has been an incredible experience, and I thank you from the bottom of my heart. Keep up the great work!
More power to you Shradha Ma'am! ♥ You teach so well! Thank you this amazing lecture.
2:44:24
select*
from students as D
right join course as C
on D.id = C.id
where D.id is null
union
select*
from students as D
left join course as C
on D.id = C.id
where C.id is null
Good 👍👍
Also also where D is null use hoga
literally after 3 hours i have a preentaion on SQL and i got this masterpiece. Thanks Sharaddha Didi for this masterpiece ....
Bilkul sahi...
Superb Teaching..simple & very in depth lecture.... Initially as a non programmer I was struggling to learn MySQL, after learning from the video my concepts got rooted and I am now really confident about writing and solving queries.. Thank you Ma'am !!
It was a great class. Never thought I could learn SQL in such a short period of time. Great explanation and great class. Thanks a lot 🎉
Ma'am you are the best! But one request: Please upload JavaScript videos specifically designed for web development. Thank you 😊
Class 12 th student Cbse please attend here 😂!
Bhai ajj se hi start kiya padhna😂😂
@@rishabhkapoor0444 skib
@@rishabhkapoor0444 main to aj kr rhi hu
Wahi kar raha hu bhai😅😅
Class 12 ip here
The best SQL course I've seen so far. Thank You for creating this course.
Best lecture on SQL. Mam, you make concepts easy to understand with good and easy examples.
Can u tell me how to install this in windows11 Pc... I m unable to download complete process
@@pradeepkumar20011me too ,
Hey , i'm a newbie in coding can you guide me please how to make notes of coding.... i've watched 1 hours in this sql lecture but didn't find how to make notes. nd how to study
@@peculiar9600 just download the pdf file of sql notes in the description given
Hey, I just loved how you explained everything, thank you so much! Would you be able to tell me as to where can I practice it further as I want to get hands-on experience on SQL before moving on to the next course.
Thank You So Much for this wonderful video......🙏🏻🙏🏻🙏🏻🙏🏻🙏🏻🙏🏻
Make the videos on class 12th computer science it will help the students so much
I'm watching this video one day before my exam and there are many topics which are not in class 12 but still the concept are covered so properly ❤❤
I have started with my placement preparation and this video has helped me lot.
Thanks to Shradha Didi and Apna college team to bring this amazing course of SQL. Thanks a lot
Hey , i'm a newbie in coding can you guide me please how to make notes of coding.... i've watched 1 hours in this sql lecture but didn't find how to make notes. nd how to study
Thank you super sooooo much ☺️ I m super happy that you made course on SQL. I like your teaching style. Thank you ☺️🤗🤗🤗🤗🤗♥️♥️♥️
I learned a lot and benefited from your course! Thank you shradha Ma'am ! Thank you so much for facilitating such a positive learning environment. ❤
i am from south telugu ,this class was so useful and kudos to your work to enlighten us,keep doing a lot
@2:44:08
-- find the full exclusive join (A U B - A instersection B )
-- it is nothing but the union of left exclusive join and right exclusive join
select *
from student as lef
left join course as rig
on lef.id=rig.id
where rig.id is NULL
UNION
select *
from student as lef
right join course as rig
on lef.id=rig.id
where lef.id is null;
great to watch the lecture and thanks to Shradha ma`am for teaching it so clearly🙂
perfect video, cleared all basic knowledge, teaching queries with perfect examples😊
Hi Di, please also do a full course for data analyst, R language, Panda & Numpy, Tableau tool etc. pls pls do this you explain very well so it will be great learning from you on this topics please ❤
Mam, I completely agree with you that your explanation is simply amazing and straightforward. It would be greatly appreciated if you could make a playlist about data analyst power bi.
@@HindSena-seems you are more Intrested to pay for courses rather than learning
Hey , i'm a newbie in coding can you guide me please how to make notes of coding.... i've watched 1 hours in this sql lecture but didn't find how to make notes. nd how to study
@ApnaCollegeOfficial I am unable to understand how one person can lecture on every topic of computer science. It means no specialization in any subject, just collect data from the internet and make a lecture, and upload it on RUclips, people are easily fooled.
In the university, we have not seen any lecturer who teaches all the subjects like this lady (Shradha Didi).
mausi naaki chachi ki beti hai aise hi di bol rahi ho
Easy to understand and grasp knowledge, wonderful video and explanation; kudos to your efforts and easy explanation. 💯💯
Thank you so much Ma'am, Muje SQL ke baare me kuch nahi pataa tha fir aapka ye video dekh kar bohat kuch sikh liya. Thank you onces again. 😊
Valuable content, Thank you so much!!
More power to you!!
.People like you two are gem and every hadrwork you do to teach us that's really so inspiring ❤❤
Hey , i'm a newbie in coding can you guide me please how to make notes of coding.... i've watched 1 hours in this sql lecture but didn't find how to make notes. nd how to study
@@peculiar9600 dude u are commenting under a bot comment lmao.
Thank you for this informative tutorial on SQL databases! I've learned a lot and it's been a great help in my learning journey. Keep up the good work!
Notes download ho rahe kya
This video is really very helpful! I'm literally clearing my basics for placement point of view.
For one time revision or last moment preps. Best resource. Covers both theory and practical.
I productive lecture, seems like a picture that stick with the users emotion. Thank you Apna College and Shradha.
You teach very good mam....i am in class 7th and i had learned 4 languages from this channel Thanku did😊
Bhai zindagi ke maze lele yr tu 7th class mei kyu krra hai