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
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.
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.
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.
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.
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
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
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.
Homework 2:44:30 Select * From table A as a Left join table B as b On a.id = b.id Where b.id is Null Union Select * From table A as a Right join table B as b On a.id = b.id Where a.id is Null;
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
simple tip of using shortcut keys from keyboard instead of clicking the button! CTRL+ENTER: To run a selection CTRL+SHIFT+ENTER: To run all lines of code in sql.
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.
Give the attendance the legends, who are watching in 2024, Because it makes sure that you are consistent or not in this free course. Don't take it as a serious! But you have need to be consistent and be focus on your Goals and Achievements.
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❤❤❤.
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....
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.👍
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
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.
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.
Didi we want one single shot for JavaScript 😊 Please didi make it as soon as possible...I can't buy paid course...It would help me a lot if you make this video 😊
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. 😀👌👍
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.
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 UA-cam, people are easily fooled. In the university, we have not seen any lecturer who teaches all the subjects like this lady (Shradha Didi).
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....
In the having clause section 1:43:35 , there appears to be an error. After applying the "having" clause, it displays the maximum number of students from the cities, whereas your intention was to select only those with scores above 90. To achieve the desired outcome, the correct SQL query should be as follows: SELECT city, COUNT(rollno) FROM student WHERE marks > 90 GROUP BY city;
I just wanted to say a big thank you for your excellent SQL tutorials! Your clear explanations and practical examples have made learning SQL so much easier and enjoyable for me. I appreciate all the effort you put into your video.. thank thank you so much
@@vineetkarmakar2305bhai abhi naukri bhi toh kam ho rhi hai so the most cream students or performer will get jobs .....ye 7th se agar kr rha hai toh baad me jake uss time me kuch aur skill develop krega yani kam time me jyada skill and definitely will get a high lpa job at entry level
@@Redbrax_FF He is preparing a skill he would use a decade late and there would be different skill required at that time and who knows what comes up 10 years down the line
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
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!
This was such a detailed yet easy-to-understand video on SQL. I'd been wondering how will I grasp such a technical concept but I completed this within 4 days. A big thanks to Shradha Mam and Apna College for this video!
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 🙏
COURSE STARTED ✅---------------------------------> DAY - 01(08/03/2024) - 00:00:00 to 00:30:00 DAY - 02(09/03/2024) - 00:30:00 to 01:00:00 DAY - 03(10/03/2024) - 01:00:00 to 01:30:00 DAY - 04(11/03/2024) - 01:30:00 to 02:00:00 DAY - 05(12/03/2024) - 02:00:00 to 02:30:00 DAY - 06(13/03/2024) - 02:30:00 to 03:16:13 DONE ✅ ------------------------->Thank You Mam!
first 1 hour is pretty easy so it goes by within a day. Other takes time depending on the lvl. For majority with coding knowledge another half hour is posible the same day
Madam, I am very grateful to you for this video. The way you teach in detail and in a simple way, I liked your system very much and this video will help me a lot in my career and job.❤❤
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
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!
2:44:26 sql query right exclusive join select * from student as a right join course as b on a.id = b.id where a.id is null; full exclusive join 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;
2:44:21 homework done!! SELECT * FROM a LEFT JOIN b ON a.id = b.id WHERE b.id IS NULL UNION SELECT * FROM a RIGHT JOIN b ON a.id = b.id WHERE a.id IS NULL
I watched various SQL courses on youtube and finally got the best content here by the Apna college. I don't think anyone who invest their time on this course would regret as Shradha di explained the important topics in mysql in an efficient way which no other tutor does
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
At 3:05:02 we can write a normal query as well to get the desired answer: select name from student_info where rollno % 2 = 0; I know you are teaching about subqueries, but this a possibilty as well.
I have watched this one shot video for around 1 hr and i have encountered 16 ads. APNA COLLEGE team please review this.The content is decent but the frequency of ads is shadowing the quality of content.
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
Thank You so much mam.Every time when i started watching long lectures on You Tube i used to quit or stop watching after sometime ,but for the first time i have watched the full video.The credit goes to you mam.
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!
2:44:23 ans 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;
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
Advanced ka kuch alag hota h ??@@gopalvishvakarma2617
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.
3 hours video >>>>>>>>>>3 month course
Matlab 1 hours 1 month😂😂😂
Bhai itna sach 😂😂
Bhai practice name ki to koi ciz hi nahi hoti😂😂
@@its_mr_shayer 😁😁haa
@@epl5031mai bhi yahi kehne aaya tha👍
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
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
Didi we want a full course on Javascript 😊
Please do it
Yes
Yes we want
Yes ✋
Yes
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
thankss
Thanks
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.
ok
@@sanjanahalli1174 yaa but not too much it's just need for handle the data in database👍
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
😂😂
Fr
I HAVE THE SAME PROBLEM, AND ALHAMDULILLAH SOLVED
fr bruh😂
completed in 3 hr
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
Homework 2:44:30
Select *
From table A as a
Left join table B as b
On a.id = b.id
Where b.id is Null
Union
Select *
From table A as a
Right join table B as b
On a.id = b.id
Where a.id is Null;
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...
simple tip of using shortcut keys from keyboard instead of clicking the button!
CTRL+ENTER: To run a selection
CTRL+SHIFT+ENTER: To run all lines of code in sql.
thanks bro for this knowledge
thank
already know
thanks buddy, was searching for it since hours
thanks
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!!
An amazing video if you want to brush up your SQL basics. Thankyou so much for such a wonderful and easy explanation!
Constraints in SQL: १)not null
२) unique
३) primary key
४) foreign key
५) default
६) check
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.
contact ho sakta hai
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
does it cover squlite 3?
Give the attendance the legends, who are watching in 2024, Because it makes sure that you are consistent or not in this free course. Don't take it as a serious! But you have need to be consistent and be focus on your Goals and Achievements.
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 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❤❤❤.
2:44:20 Home Work Problem Solution for SQL Sever (SELECT* FROM student as a FULL JOIN course as b ON a.id = b.id WHERE a.id IS NULL OR b.id IS NULL)
Very good lecture. Covered all the basics. Very good for someone who is beginning to learn SQL. Thankyou
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....
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
2:44:24 homework problem solution
SELECT*
FROM student as a
FULL JOIN course as b
ON a.id = b.id
WHERE a.id IS NULL
OR b.id IS NULL;
@@-ck8sd Only SQL, DBMS is not covered
For 2:44:00 ans write the where condition for left and right join and then union them
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
This Chanel is A blessing to all the Cs/It Engineers💯
Nice explanation! All the topics are explained with examples which is really helpful. I feel confident that I can solve any SQL query.
Excellent class Shradha, I seriously learned SQL from this video. You made it very crisp and clear. Thanks a lot, Shradha 🙏🙏🙏🙏🙏🙏
does it cover sqlite?
आप बहुत अच्छा समझते हो जो शब्दों में बया नहीं हो सकता मैं काफी समय से Sql or MySql में Confuse tha .पर अब मेरे सारे dubt पूरे हो गए हैं
Bhai SQL or my sql m antar h kya
@@mayanksaini7767 sql chalane ka ek platform hai jiska naam my sql hai. sql ek hi hai !
@@mayanksaini7767 sql language hai mysql bas ek platform hai jispe hum kaam kar rhe. there are many platforms like mysql, oracle etc
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.
Got a package of 8LPA just because of shraddha di 😊❤
congratulations
@@_Atmika_ Thanks😇
What you have learned bro?
Can you please guide us to what to learn to get package like you
Congratulations 🎉 👏. What is the role bro? How did you search the job? And are you experienced or a fresher?
@@Shishir-d2t Got it through college campus & I'm a fresher. Job role is Product Development & Analysis
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.
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
Didi we want one single shot for JavaScript 😊 Please didi make it as soon as possible...I can't buy paid course...It would help me a lot if you make this video 😊
go n check CHAI AUR CODE ..full javascript playlist
How did you manage to learn so many things.? Its amazing how you know everything even though you are so young. Respect✌
Anyone pursuing BE in CSE must know this all . She completed and knows . The quality is the difference which makes her unique
@@vaibhavkottari4177 well if its unique then its something that rarely anyone does. It's impressive and I am striving to be like her
it is about determination and interest. Majority of current students take CSE for high packages.
Chala easy way lo teach chestunnaru superb sir...inka SQL classes continue cheyandi
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 :)
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.
😀👌👍
Learning SQL for my board exam!!!Pure saal mein jitnaa nhi padha , 3 hours mein usse bhi jiyada padh liyaaa.thanks mam from assam❤
same
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 UA-cam, people are easily fooled.
In the university, we have not seen any lecturer who teaches all the subjects like this lady (Shradha Didi).
Yes it will be very helpful for those student who are want to shift there career in Big Data Analyst.
please DIDI make the course for us.
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....
In the having clause section 1:43:35 , there appears to be an error. After applying the "having" clause, it displays the maximum number of students from the cities, whereas your intention was to select only those with scores above 90.
To achieve the desired outcome, the correct SQL query should be as follows:
SELECT city, COUNT(rollno)
FROM student
WHERE marks > 90
GROUP BY city;
yes thanks bro!!!!
i was looking for this comment
Thanks bro!! I was looking for this comment
I just wanted to say a big thank you for your excellent SQL tutorials! Your clear explanations and practical examples have made learning SQL so much easier and enjoyable for me. I appreciate all the effort you put into your video.. thank thank you so much
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
@@vineetkarmakar2305 sahi baat ha
@@vineetkarmakar2305bhai abhi naukri bhi toh kam ho rhi hai so the most cream students or performer will get jobs .....ye 7th se agar kr rha hai toh baad me jake uss time me kuch aur skill develop krega yani kam time me jyada skill and definitely will get a high lpa job at entry level
@@Redbrax_FF He is preparing a skill he would use a decade late and there would be different skill required at that time and who knows what comes up 10 years down the line
i am 8 years experiences senior software engineer and still i am watching even i know these concepts, liked those efforts you made in this video.
Sir , how much salary are you earning now , please share sir, this can motivate us.
@@Luxurylife1012 bro its a six digit for a month.
Sir , could help me in giving reference...
@@saikirankandula2153 how much experience and what technology you are looking for?
@@harshsaxena05Respected bro could help me to guid how i can take a start? And where..plzz reply..i'll be really venerable to uu
Watching this for my 12th boards sql revision❤
hey surbhi! was it helpful? coz i am also studying from here for my boards
@@kartikeygoyal7477 yess....
Best SQL Course👌!! Plz upload python notes in drive as they are deleted..
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
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 for the awesome SQL lecture! Your explanations are super clear and beneficial for us. Your clear explanations are a true gem.
wellcome
This was such a detailed yet easy-to-understand video on SQL. I'd been wondering how will I grasp such a technical concept but I completed this within 4 days. A big thanks to Shradha Mam and Apna College for this video!
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 🙏
COURSE STARTED ✅--------------------------------->
DAY - 01(08/03/2024) - 00:00:00 to 00:30:00
DAY - 02(09/03/2024) - 00:30:00 to 01:00:00
DAY - 03(10/03/2024) - 01:00:00 to 01:30:00
DAY - 04(11/03/2024) - 01:30:00 to 02:00:00
DAY - 05(12/03/2024) - 02:00:00 to 02:30:00
DAY - 06(13/03/2024) - 02:30:00 to 03:16:13
DONE ✅ ------------------------->Thank You Mam!
woow, great method to not get tired , appreciated... u just used the thing called don't to big things at once, rather do small things consistently
first 1 hour is pretty easy so it goes by within a day. Other takes time depending on the lvl. For majority with coding knowledge another half hour is posible the same day
3 day complete...
Your short lecture covered all the relevant topics which is necessary for mysql. Thank you very much mam..
Madam, I am very grateful to you for this video. The way you teach in detail and in a simple way, I liked your system very much and this video will help me a lot in my career and job.❤❤
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
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
ua-cam.com/video/o8SUz0CGM1k/v-deo.htmlsi=dT5VmEJfVFkYceIqv
bot comment lmaoo
The explanation is straightforward, and it aided me greatly in revising SQL.
2:44:26 sql query
right exclusive join
select *
from student as a
right join course as b
on a.id = b.id
where a.id is null;
full exclusive join
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;
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.
from where did you got the practice set and notes? TIA
@@AnkitaSingh-mf5csduring the video
We want full javascript tutorial with notes❤❤❤
Please shraddha ma'am ❤❤❤
2:44:21 homework done!!
SELECT * FROM a
LEFT JOIN b
ON a.id = b.id
WHERE b.id IS NULL
UNION
SELECT * FROM a
RIGHT JOIN b
ON a.id = b.id
WHERE a.id IS NULL
Explaining SQL's order of execution makes queries easier to understand and work with.
Easy to understand and grasp knowledge, wonderful video and explanation; kudos to your efforts and easy explanation. 💯💯
I watched various SQL courses on youtube and finally got the best content here by the Apna college. I don't think anyone who invest their time on this course would regret as Shradha di explained the important topics in mysql in an efficient way which no other tutor does
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...
Your teaching method is really amazing. Thank you Shradha Mam. it is really easy to understand for beginner like us.
We need DSA course with C++ with your lecture.
I guess, it's already there search the apna college playlist!
@@gaganbhattacharya9890no he's asking c++ DSA lectures by her
@@gaganbhattacharya9890 different tutor
you can learn from code help
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
More power to you Shradha Ma'am! ♥ You teach so well! Thank you this amazing lecture.
02:24:00 JOINS in SQL
02:51:23 UNION in SQL
02:53:54 SQL Sub Queries
03:11:26 MySQL Views
t q bro
Thankyou Vedansh
Excellent video , you covered lot of topics mam. Thank You very much!!!!
The best video I have come across. Beginners also can understand easily by the way she is explaining.
Start : 0:00:00 : 26-Jun-2024
End : 1:32:33 : 26-Jun-2024
Start : 1:32:33 : 26-Jun-2024
End : 1:58:41 : 26-Jun-2024
Start : 1:58:41 : 28-Jun-2024
Bhai baki Kab karega
Bhai khtm hua kya
Hy@@shrutiricha6524
Bhai pdhai krle end krde pdhai kr phone kam chla
Bhai Khatam karle yarr 😐
Shraddha Ma'am, Pleaseconsider my Humble Request to provide Chapters for Videos and Timestamps for the Videos.
Further action will be appreciated 😊❤
This would be really helpful while preparing for exams
TimsStamp To khud dal do wo bhi Sharda Didi hi Karengi
@@manibhushankumar8669 🤣
@@manibhushankumar8669 Inka Bas chale to Exam bhi oonhi se dilwade dedengi 🤣
Hello Shradha Mam, Glad to learn MySql with you , you are such the Great teacher to me!...Regards From Mohseen khan
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
maturity is when you watch the complete lecture on 2x after watching installation of software on 2x 😉
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
all queries and their explaination are uderstandable for a beginner ... and this video is also useful for exams of cs dept student
At 3:05:02 we can write a normal query as well to get the desired answer: select name from student_info where rollno % 2 = 0;
I know you are teaching about subqueries, but this a possibilty as well.
I was just gonna comment this, but I found your comment regarding the same.
I have watched this one shot video for around 1 hr and i have encountered 16 ads. APNA COLLEGE team please review this.The content is decent but the frequency of ads is shadowing the quality of content.
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 🎉
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
This 3 hours of video actually helped alot to learn SQL for the very first time. Thank you, Shraddha!
yes indeed
Didi, we want a lecture on how to navigate career growth in corporate MNCs 😊😊
Thank You so much mam.Every time when i started watching long lectures on You Tube i used to quit or stop watching after sometime ,but for the first time i have watched the full video.The credit goes to you mam.
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!
Nicee Junaid bhai, same here your Tayyab bhai, also learning from them 😅
One of the best lecture in the whole youtube regarding database😊 thankyou so much mam
Shraddha didi thanks for your great Explanation.. This 3hrs was a lot more than what college teaches us..
Thank you didi❤😊😊
2:44:23 ans
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;
Great lecture for class 12 computer science as well 😀
Simply Amazing for Both Learning and Revision.
Great Lecture , very simple and easy way of teaching with clear examples which are highly appreciated. once again thanks
1:42:43
Select grade,count(rollno) from student group by grade order by grade;
i am in 12th and tommarow is my cs exam, after watching this full video, I am sure not gonna loose single marks in SQL.... thank you didi....
shi me bhai