Great Lecture & thank you Shradha Ma'am : ) Some student please share timestamps so that other students can also benefit.
@factzfactory4956 Жыл бұрын
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
@desichhoraazamgarh Жыл бұрын
Wow ❤❤
@desichhoraazamgarh Жыл бұрын
Please Java Script par ek lecture ❤
@HSKhan-lc5pk Жыл бұрын
Please Bhaiya JavaScript par bhi video banao
@factzfactory4956 Жыл бұрын
@@HSKhan-lc5pk Javascript ka bahut courses hai TypeScript ka course chahiya Jo javascript ka superset hai
@SAAAAAAAAAAAAAAAAAAAAAAA-ez6hg9 ай бұрын
1 hour into the video ! fantastic clear explanation. Probably the best SQL video i've stumbled upon!
@gopalvishvakarma26174 ай бұрын
Only for beginners
@Premsingh1778-e5g2 ай бұрын
Advanced ka kuch alag hota h ??@@gopalvishvakarma2617
@adeshgaurav10538 ай бұрын
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;
@snehasamuel74268 ай бұрын
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.
@VrutThumar-l5o6 ай бұрын
@@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.
@dhruvaldalwadi59855 ай бұрын
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 ?
@safiaq_ueen5 ай бұрын
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
@Shoaibistan5 ай бұрын
@@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
@its26sakshi2 ай бұрын
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
@retro.Maxxedd2 ай бұрын
thankss
@SurjoJio18 күн бұрын
Thanks
@Shb-u2c7 ай бұрын
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.
@hrishibari9044 Жыл бұрын
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.
@prashantkohli7557 Жыл бұрын
exactly but she wanted to show usage of the subquery as an example else i came up with same idea as yours😅
@sanjanahalli1174 Жыл бұрын
Does sql requires logic?
@hrishibari9044 Жыл бұрын
@@sanjanahalli1174 obviously.. SQL is a language used for getting solutions to some problems.. and solving any problem requires logic.
@tariqshahnawazАй бұрын
ok
@PRO-TUBER.21 күн бұрын
@@sanjanahalli1174 yaa but not too much it's just need for handle the data in database👍
@rem8572Ай бұрын
3 hours video >>>>>>>>>>3 month course
@Ady...9440Ай бұрын
Matlab 1 hours 1 month😂😂😂
@its_mr_shayerАй бұрын
Bhai itna sach 😂😂
@epl503129 күн бұрын
Bhai practice name ki to koi ciz hi nahi hoti😂😂
@Ady...944029 күн бұрын
@@its_mr_shayer 😁😁haa
@PRO-TUBER.22 күн бұрын
@@epl5031mai bhi yahi kehne aaya tha👍
@noinfo82583 ай бұрын
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;
@aniketkumar9215 Жыл бұрын
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.
@adityascoding Жыл бұрын
1:47
@nupurnishant4197 Жыл бұрын
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.
@khushalkalra8040 Жыл бұрын
Relatable
@bhavyachampaneri Жыл бұрын
Wow senior consultants also watching
@shreeshree4270 Жыл бұрын
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.
@Gatefighter886 Жыл бұрын
Hlo sir
@mrsmurf911 Жыл бұрын
@@Gatefighter886 hlo
@brsstatusworldofficial8754 Жыл бұрын
Didi we want a full course on Javascript 😊
@purabgehlot2114 Жыл бұрын
Please do it
@Recker1818 Жыл бұрын
Yes
@saptarshisinha1744 Жыл бұрын
Yes we want
@oloraclasses9930 Жыл бұрын
Yes ✋
@Toon_craze27 Жыл бұрын
Yes
@truthvsfake3 ай бұрын
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.
@codelearninpashto19195 ай бұрын
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.
@jeelkatua3 ай бұрын
thanks bro for this knowledge
@abhinavpatel16193 ай бұрын
thank
@RanaAfaq-pe9oi2 ай бұрын
already know
@Gurupyx2 ай бұрын
thanks buddy, was searching for it since hours
@EternalHidayahАй бұрын
thanks
@sushilgbp Жыл бұрын
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
@ayush.gangwani88 ай бұрын
Good 👍👍
@THIRTEENPLAYS8 ай бұрын
Also also where D is null use hoga
@anshulkumar88467 ай бұрын
literally after 3 hours i have a preentaion on SQL and i got this masterpiece. Thanks Sharaddha Didi for this masterpiece ....
@apnadesirecords85387 ай бұрын
Bilkul sahi...
@hammadraza70647 ай бұрын
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
@gopalvishvakarma26174 ай бұрын
😂😂
@ManOfVines3 ай бұрын
Fr
@MuhammadAfzaal-lv5zs2 ай бұрын
I HAVE THE SAME PROBLEM, AND ALHAMDULILLAH SOLVED
@EternalHidayahАй бұрын
fr bruh😂
@hasleyaara6797Ай бұрын
completed in 3 hr
@ratikantmuduli90254 ай бұрын
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;
@phanitejakv4 ай бұрын
@@-ck8sd Only SQL, DBMS is not covered
@AnandKumar-ji6wb10 ай бұрын
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👍
@abbhushan9 ай бұрын
Age dekha na Bhai, ki khush hokar chala gya
@raazsrivastav10358 ай бұрын
@@abbhushan🤣🤣🤣🤣🤣
@zohaibmanzoor31736 ай бұрын
Aur main jo 2X pe video chala rha tha, achanak laga ke Space button corrupt hogaya!!
After watching this video I can add SQL in my resume as technical skills 😁🤪
@shaifali11307 ай бұрын
😂
@alparslanaslamcoding8567 ай бұрын
GOOD IDEA
@Helloworld08095 ай бұрын
I am here after added 😅
@Bdmadiq5 ай бұрын
😂
@Abhishek-rx1cj5 ай бұрын
@@Helloworld0809 now I know SQL language only . next what should be learned in database related ?....which help further iny projects for backend
@Rider12374Сағат бұрын
2:51:17 Its correct , no need to change
@muhammadarhamshahbaz4805 Жыл бұрын
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❤❤❤.
@laughAndLiveLong Жыл бұрын
SQL matlab structured query language but in my view SQL matlab : --- SHRADHA the QUEEN of all LANGUAGES
@galaxygaming5289 Жыл бұрын
Nice try
@shrikant301991 Жыл бұрын
@@galaxygaming5289😅😅😅
@India_Asks8 ай бұрын
अति उत्तम ✋
@ChandanKumar-ku7wf8 ай бұрын
Nahi aega reply bhai
@Priyanka-hp5do8 ай бұрын
Nahi degi💀
@nandishbt240510 ай бұрын
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
@deeyaagrawal481816 күн бұрын
does it cover squlite 3?
@sathyasai19953 ай бұрын
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)
@pskroyallife636 Жыл бұрын
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....
@ravichauhan39338 ай бұрын
आप बहुत अच्छा समझते हो जो शब्दों में बया नहीं हो सकता मैं काफी समय से Sql or MySql में Confuse tha .पर अब मेरे सारे dubt पूरे हो गए हैं
@mayanksaini77675 ай бұрын
Bhai SQL or my sql m antar h kya
@krishxstocks3 ай бұрын
@@mayanksaini7767 sql chalane ka ek platform hai jiska naam my sql hai. sql ek hi hai !
@krishxstocks3 ай бұрын
@@mayanksaini7767 sql language hai mysql bas ek platform hai jispe hum kaam kar rhe. there are many platforms like mysql, oracle etc
@he3247 Жыл бұрын
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.👍
@mohammedarbazkhan9293 Жыл бұрын
hi have you got placed in any organization??
@mystudy8802 Жыл бұрын
same question, have you?
@he3247 Жыл бұрын
Not yet but hopefully I will get placed, looking for opportunities.
@life_iitism11 ай бұрын
Is this course complete, like if I finish it.. will I be prepared for an entry level role at SQL?
@asgzz39969 ай бұрын
what languages we have to study for becoming a data anaylst
@souravchakraborty1590Ай бұрын
Day 1 :- 1:17:53 Day 2 :- 1:43:36 Day 3 :- 2:01:50 Day 4 :- 2:20:04 Day 5 :- 2:30:30
@Shiva_Gheji Жыл бұрын
I was thinking that I wish Shraddha mam would have made a SQL tutorial and today it became true.💝💗😍🤝 Thankyou so much mam...
@siddharthasanyal4214 Жыл бұрын
same here :)
@fit_tubes_3658 ай бұрын
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!
@ezioafaqyt84423 ай бұрын
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
@Parth-gx1nwАй бұрын
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
@gourabbiswas1885Ай бұрын
3 day complete...
@srikrishna198111 ай бұрын
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
@Insect...6 ай бұрын
Bruh u R slow as hell This takes hardly 2-2.5 hours to fully understand and learn
@nits_sanatan_beats15 күн бұрын
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;
@NisthaMishra-u6m11 ай бұрын
Very good lecture. Covered all the basics. Very good for someone who is beginning to learn SQL. Thankyou
@aryanoakshorts Жыл бұрын
This Chanel is A blessing to all the Cs/It Engineers💯
@mkarvj Жыл бұрын
Excellent class Shradha, I seriously learned SQL from this video. You made it very crisp and clear. Thanks a lot, Shradha 🙏🙏🙏🙏🙏🙏
@deeyaagrawal481816 күн бұрын
does it cover sqlite?
@SatyamTrimale-p3m25 күн бұрын
Got a package of 8LPA just because of shraddha di 😊❤
@_Atmika_17 күн бұрын
congratulations
@SatyamTrimale-p3m11 күн бұрын
@@_Atmika_ Thanks😇
@Chintu009810 күн бұрын
What you have learned bro? Can you please guide us to what to learn to get package like you
@Shishir-d2t7 күн бұрын
Congratulations 🎉 👏. What is the role bro? How did you search the job? And are you experienced or a fresher?
@SatyamTrimale-p3m7 күн бұрын
@@Shishir-d2t Got it through college campus & I'm a fresher. Job role is Product Development & Analysis
@riazmalik75568 ай бұрын
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.
@Himanshu-ph7in3 ай бұрын
contact ho sakta hai
@electronicsprayogshala3889 Жыл бұрын
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. 😀👌👍
@419-jainamshah38 ай бұрын
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.
@Shoaibistan5 ай бұрын
what roadmap are you following?
@Soul2356-z9o5 ай бұрын
in which way u are going to complete the sql iam also from commerce background
@mrrabbani5224Ай бұрын
Didi Please Start Advance SQL .Its humble request from all student.....
@vedanshgarg793811 ай бұрын
02:24:00 JOINS in SQL 02:51:23 UNION in SQL 02:53:54 SQL Sub Queries 03:11:26 MySQL Views
@ykofficial78610 ай бұрын
t q bro
@OJ129910 ай бұрын
Thankyou Vedansh
@syedadnan662 Жыл бұрын
For 2:44:00 ans write the where condition for left and right join and then union them
Learning SQL for my board exam!!!Pure saal mein jitnaa nhi padha , 3 hours mein usse bhi jiyada padh liyaaa.thanks mam from assam❤
@Holistash2 ай бұрын
same
@arpitaingermany Жыл бұрын
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.
@Manju-st6di8 ай бұрын
Chala easy way lo teach chestunnaru superb sir...inka SQL classes continue cheyandi
@Surbhi_Srivastav8 ай бұрын
Watching this for my 12th boards sql revision❤
@kartikeygoyal74778 ай бұрын
hey surbhi! was it helpful? coz i am also studying from here for my boards
@Surbhi_Srivastav8 ай бұрын
@@kartikeygoyal7477 yess....
@nitishbhandari48292 ай бұрын
Any class 12 computer science student here ?🗿
@AshokKumar-do2ixАй бұрын
Me toh 11 ke half yearly ke liye padh rhi hu😢
@thakurvaishnavi99zАй бұрын
@@AshokKumar-do2ixyayayyyyyy!!! Sammmeeeee
@LalaYadav-b1bАй бұрын
Tu jaan ke kya ukhadega
@nitishbhandari4829Ай бұрын
@@LalaYadav-b1b Tere jese don logo se pachan laga lunga💪 Dikhat koi terko....bhai
@sujalpant-pr8brАй бұрын
Yess
@saptarshisinha1744 Жыл бұрын
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 😊
@shilpasahu5634 Жыл бұрын
go n check CHAI AUR CODE ..full javascript playlist
@simran_63_43 Жыл бұрын
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....
@shreyajoshi4215 Жыл бұрын
Best lecture on SQL. Mam, you make concepts easy to understand with good and easy examples.
@pradeepkumar20011 Жыл бұрын
Can u tell me how to install this in windows11 Pc... I m unable to download complete process
@justdrishu4880 Жыл бұрын
@@pradeepkumar20011me too ,
@peculiar9600 Жыл бұрын
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
@namangautam87999 ай бұрын
@@peculiar9600 just download the pdf file of sql notes in the description given
@biplabswain23423 ай бұрын
Dear Madam , Although I am a Arts Student, I have a passion to learn sql .And for you my desire get fulfilled. Hats up to you. Keep it up .
@pawankandu9147 ай бұрын
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
@someone-4k Жыл бұрын
You teach very good mam....i am in class 7th and i had learned 4 languages from this channel Thanku did😊
@vineetkarmakar230511 ай бұрын
Bhai zindagi ke maze lele yr tu 7th class mei kyu krra hai
@RajPatel-pd9gi24 күн бұрын
@@vineetkarmakar2305 sahi baat ha
@Redbrax_FF9 күн бұрын
@@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
@vineetkarmakar23059 күн бұрын
@@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
@priyakashyap3025 Жыл бұрын
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 ❤
@darshanwankhade9134 Жыл бұрын
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.
@mirirfan19 Жыл бұрын
@@HindSena-seems you are more Intrested to pay for courses rather than learning
@peculiar9600 Жыл бұрын
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
@oracle_professor Жыл бұрын
@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 KZbin, people are easily fooled. In the university, we have not seen any lecturer who teaches all the subjects like this lady (Shradha Didi).
@souvikdey6843 Жыл бұрын
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.
@uojaiaАй бұрын
A big shoutout to me on completing this course!🎉... let's keep going bud!
@TruthG0D10 ай бұрын
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;
@abhishekvashistha40177 ай бұрын
yes thanks bro!!!!
@diteesingh_112 ай бұрын
i was looking for this comment
@swatilenka4750Ай бұрын
Thanks bro!! I was looking for this comment
@Saumyagrow Жыл бұрын
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!
@deepakn7961 Жыл бұрын
Shraddha is your friend
@Newindia78610 Жыл бұрын
@@deepakn7961 Yes she is her friend
@kira-re4ud9 ай бұрын
maam bolo
@JyotiSingh-sp3ny5 ай бұрын
Hii
@harshsaxena05 Жыл бұрын
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.
@Luxurylife1012 Жыл бұрын
Sir , how much salary are you earning now , please share sir, this can motivate us.
@harshsaxena05 Жыл бұрын
@@Luxurylife1012 bro its a six digit for a month.
@saikirankandula2153 Жыл бұрын
Sir , could help me in giving reference...
@harshsaxena05 Жыл бұрын
@@saikirankandula2153 how much experience and what technology you are looking for?
@abiyafatima8271 Жыл бұрын
@@harshsaxena05Respected bro could help me to guid how i can take a start? And where..plzz reply..i'll be really venerable to uu
@zahidsadiq1251Ай бұрын
East and West Indians are best.❤❤ from Pakistan 🇵🇰 ♥️
@UmarAli-ck1qp8 ай бұрын
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.
@_bisyibadal._1782 Жыл бұрын
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!
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
@dotnetsqlmaster11 ай бұрын
For SQL dotnet MVC api pratical www.youtube.com/@dotnetsqlmaster?sub_confirmation=1
@NiteshMaurya111115 күн бұрын
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;
@arshadaslam7976 Жыл бұрын
We want full javascript tutorial with notes❤❤❤ Please shraddha ma'am ❤❤❤
@shaikshahed41311 ай бұрын
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
@abhityagi9807 Жыл бұрын
maturity is when you watch the complete lecture on 2x after watching installation of software on 2x 😉
@rajsingh25754 ай бұрын
Never felt confidence in SQL but after watching this definitely feel good and confident about SQL!
@priyankapawar8749 Жыл бұрын
Thank you for the awesome SQL lecture! Your explanations are super clear and beneficial for us. Your clear explanations are a true gem.
@riteshMusk11 ай бұрын
wellcome
@faizulmohammad8680 Жыл бұрын
Your short lecture covered all the relevant topics which is necessary for mysql. Thank you very much mam..
@Aham_Shukla9 ай бұрын
Like if u r from class 11th IP😅😅😅
@MeetPRAJAPATI-rh9jz4 ай бұрын
Hii
@TricksWala8 күн бұрын
Best SQL Course👌!! Plz upload python notes in drive as they are deleted..
@nishithshah8109 Жыл бұрын
Shraddha Ma'am, Pleaseconsider my Humble Request to provide Chapters for Videos and Timestamps for the Videos. Further action will be appreciated 😊❤
@tejaswirupa537 Жыл бұрын
This would be really helpful while preparing for exams
@manibhushankumar8669 Жыл бұрын
TimsStamp To khud dal do wo bhi Sharda Didi hi Karengi
@gourav1343 Жыл бұрын
@@manibhushankumar8669 🤣
@gourav1343 Жыл бұрын
@@manibhushankumar8669 Inka Bas chale to Exam bhi oonhi se dilwade dedengi 🤣
@ishansrivastava49118 ай бұрын
Class 12 th student Cbse please attend here 😂!
@rishabhkapoor04448 ай бұрын
Bhai ajj se hi start kiya padhna😂😂
@Fayroll58 ай бұрын
@@rishabhkapoor0444 skib
@sp-wo7sl8 ай бұрын
@@rishabhkapoor0444 main to aj kr rhi hu
@5hubham_editxx8 ай бұрын
Wahi kar raha hu bhai😅😅
@itsgreat14758 ай бұрын
Class 12 ip here
@nayanchavd645 Жыл бұрын
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 🙏
@rutujashintre39253 ай бұрын
2:44:24 HOMEWORK SOLUTION SELECT * FROM student_info as a LEFT JOIN course as b ON a.id = b.id WHERE b.id is NULL UNION SELECT * FROM student_info as a RIGHT JOIN course as b ON a.id = b.id WHERE a.id is NULL;
@miss_naaz53 Жыл бұрын
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.
@AnkitaSingh-mf5cs11 ай бұрын
from where did you got the practice set and notes? TIA
@miss_naaz5311 ай бұрын
@@AnkitaSingh-mf5csduring the video
@ioni-thedaddysgirl5743 Жыл бұрын
The explanation is straightforward, and it aided me greatly in revising SQL.
@jayeshmalviya34633 ай бұрын
This 3 hours of video actually helped alot to learn SQL for the very first time. Thank you, Shraddha!
@pratikshajondhalekar863 ай бұрын
yes indeed
@mohammadhasib5817 Жыл бұрын
We need DSA course with C++ with your lecture.
@gaganbhattacharya9890 Жыл бұрын
I guess, it's already there search the apna college playlist!
@coderprakash Жыл бұрын
@@gaganbhattacharya9890no he's asking c++ DSA lectures by her
@mohammadhasib5817 Жыл бұрын
@@gaganbhattacharya9890 different tutor
@Call_Me_Mortis Жыл бұрын
you can learn from code help
@peculiar9600 Жыл бұрын
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
@gauravsrivastava4438 Жыл бұрын
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...
@shreyakolekar4059 Жыл бұрын
More power to you Shradha Ma'am! ♥ You teach so well! Thank you this amazing lecture.
@akshatabhalke79453 ай бұрын
Explaining SQL's order of execution makes queries easier to understand and work with.
@know13744 ай бұрын
How did you manage to learn so many things.? Its amazing how you know everything even though you are so young. Respect✌
@vaibhavkottari41772 ай бұрын
Anyone pursuing BE in CSE must know this all . She completed and knows . The quality is the difference which makes her unique
@know13742 ай бұрын
@@vaibhavkottari4177 well if its unique then its something that rarely anyone does. It's impressive and I am striving to be like her
@Parth-gx1nwАй бұрын
it is about determination and interest. Majority of current students take CSE for high packages.
@tuhinsuryachakraborty2 ай бұрын
Target: to complete this within a week.
@tuhinsuryachakraborty2 ай бұрын
Started yesterday, completed today. Thanks didi.
@The_Rolex_252 ай бұрын
@@tuhinsuryachakrabortyme starting today
@anshumanchowdhury88172 ай бұрын
How to complete within 6 hours @@tuhinsuryachakraborty
@ahasanulmustafa1241Ай бұрын
😂 I completed it in one sitting 😂
@shreyanshchaubey4399Ай бұрын
@@ahasanulmustafa1241sabki apni apni pace hoti hai na bhai ..we should respect
An amazing video if you want to brush up your SQL basics. Thankyou so much for such a wonderful and easy explanation!
@rishirajkumar46243 ай бұрын
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.
@tusharchunbuk833229 күн бұрын
I was just gonna comment this, but I found your comment regarding the same.
@narendrababugotla7373 Жыл бұрын
The best video I have come across. Beginners also can understand easily by the way she is explaining.
@hemaexperience Жыл бұрын
Didi, we want a lecture on how to navigate career growth in corporate MNCs 😊😊
@DaanyalKhan-x8bАй бұрын
FOR 2:44:23 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;
@AliHamza-ne3hp Жыл бұрын
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!
@PoojaMewada-o8f Жыл бұрын
Notes download ho rahe kya
@ashukundra59064 ай бұрын
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.
@jahangiralikhan241010 ай бұрын
Easy to understand and grasp knowledge, wonderful video and explanation; kudos to your efforts and easy explanation. 💯💯
@AayushDhimantbhaiPatel2 ай бұрын
You guys are increasing the knowledge wealth of Indian students at the mass level! Kudos to Shradhha Mam and Aman Dhatarwal!
@sankhadipkarmakar799 Жыл бұрын
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
@peculiar9600 Жыл бұрын
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
@AbhishekMogavira2 ай бұрын
My thoughts before learning SQL = Coding 😒 But Actually. SQL = Excel ki behenponi 😊😊😊
@gammax5446 Жыл бұрын
Shraddha didi thanks for your great Explanation.. This 3hrs was a lot more than what college teaches us.. Thank you didi❤😊😊
@vansh11972 ай бұрын
Damn, This course is Best SQL one short Course , Must recommend to watch this.
@Vikas.Verma064 ай бұрын
1:40:35 SELECT mode, sum(payment) FROM table_name GROUP BY mode;