SQL - Complete Course in 3 Hours | SQL One Shot using MySQL

  Рет қаралды 9,030,478

Apna College

Apna College

Күн бұрын

Пікірлер: 5 400
@AmanDhattarwal
@AmanDhattarwal Жыл бұрын
Great Lecture & thank you Shradha Ma'am : ) Some student please share timestamps so that other students can also benefit.
@factzfactory4956
@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
@desichhoraazamgarh Жыл бұрын
Wow ❤❤
@desichhoraazamgarh
@desichhoraazamgarh Жыл бұрын
Please Java Script par ek lecture ❤
@HSKhan-lc5pk
@HSKhan-lc5pk Жыл бұрын
Please Bhaiya JavaScript par bhi video banao
@factzfactory4956
@factzfactory4956 Жыл бұрын
@@HSKhan-lc5pk Javascript ka bahut courses hai TypeScript ka course chahiya Jo javascript ka superset hai
@SAAAAAAAAAAAAAAAAAAAAAAA-ez6hg
@SAAAAAAAAAAAAAAAAAAAAAAA-ez6hg 9 ай бұрын
1 hour into the video ! fantastic clear explanation. Probably the best SQL video i've stumbled upon!
@gopalvishvakarma2617
@gopalvishvakarma2617 4 ай бұрын
Only for beginners
@Premsingh1778-e5g
@Premsingh1778-e5g 2 ай бұрын
Advanced ka kuch alag hota h ??​@@gopalvishvakarma2617
@adeshgaurav1053
@adeshgaurav1053 8 ай бұрын
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;
@snehasamuel7426
@snehasamuel7426 8 ай бұрын
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-l5o
@VrutThumar-l5o 6 ай бұрын
@@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.
@dhruvaldalwadi5985
@dhruvaldalwadi5985 5 ай бұрын
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_ueen
@safiaq_ueen 5 ай бұрын
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
@Shoaibistan
@Shoaibistan 5 ай бұрын
@@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
@its26sakshi
@its26sakshi 2 ай бұрын
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.Maxxedd
@retro.Maxxedd 2 ай бұрын
thankss
@SurjoJio
@SurjoJio 18 күн бұрын
Thanks
@Shb-u2c
@Shb-u2c 7 ай бұрын
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
@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
@prashantkohli7557 Жыл бұрын
exactly but she wanted to show usage of the subquery as an example else i came up with same idea as yours😅
@sanjanahalli1174
@sanjanahalli1174 Жыл бұрын
Does sql requires logic?
@hrishibari9044
@hrishibari9044 Жыл бұрын
@@sanjanahalli1174 obviously.. SQL is a language used for getting solutions to some problems.. and solving any problem requires logic.
@tariqshahnawaz
@tariqshahnawaz Ай бұрын
ok
@PRO-TUBER.
@PRO-TUBER. 21 күн бұрын
​@@sanjanahalli1174 yaa but not too much it's just need for handle the data in database👍
@rem8572
@rem8572 Ай бұрын
3 hours video >>>>>>>>>>3 month course
@Ady...9440
@Ady...9440 Ай бұрын
Matlab 1 hours 1 month😂😂😂
@its_mr_shayer
@its_mr_shayer Ай бұрын
Bhai itna sach 😂😂
@epl5031
@epl5031 29 күн бұрын
Bhai practice name ki to koi ciz hi nahi hoti😂😂
@Ady...9440
@Ady...9440 29 күн бұрын
@@its_mr_shayer 😁😁haa
@PRO-TUBER.
@PRO-TUBER. 22 күн бұрын
​@@epl5031mai bhi yahi kehne aaya tha👍
@noinfo8258
@noinfo8258 3 ай бұрын
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
@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
@adityascoding Жыл бұрын
1:47
@nupurnishant4197
@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
@khushalkalra8040 Жыл бұрын
Relatable
@bhavyachampaneri
@bhavyachampaneri Жыл бұрын
Wow senior consultants also watching
@shreeshree4270
@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
@Gatefighter886 Жыл бұрын
Hlo sir
@mrsmurf911
@mrsmurf911 Жыл бұрын
@@Gatefighter886 hlo
@brsstatusworldofficial8754
@brsstatusworldofficial8754 Жыл бұрын
Didi we want a full course on Javascript 😊
@purabgehlot2114
@purabgehlot2114 Жыл бұрын
Please do it
@Recker1818
@Recker1818 Жыл бұрын
Yes
@saptarshisinha1744
@saptarshisinha1744 Жыл бұрын
Yes we want
@oloraclasses9930
@oloraclasses9930 Жыл бұрын
Yes ✋
@Toon_craze27
@Toon_craze27 Жыл бұрын
Yes
@truthvsfake
@truthvsfake 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.
@codelearninpashto1919
@codelearninpashto1919 5 ай бұрын
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.
@jeelkatua
@jeelkatua 3 ай бұрын
thanks bro for this knowledge
@abhinavpatel1619
@abhinavpatel1619 3 ай бұрын
thank
@RanaAfaq-pe9oi
@RanaAfaq-pe9oi 2 ай бұрын
already know
@Gurupyx
@Gurupyx 2 ай бұрын
thanks buddy, was searching for it since hours
@EternalHidayah
@EternalHidayah Ай бұрын
thanks
@sushilgbp
@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.gangwani8
@ayush.gangwani8 8 ай бұрын
Good 👍👍
@THIRTEENPLAYS
@THIRTEENPLAYS 8 ай бұрын
Also also where D is null use hoga
@anshulkumar8846
@anshulkumar8846 7 ай бұрын
literally after 3 hours i have a preentaion on SQL and i got this masterpiece. Thanks Sharaddha Didi for this masterpiece ....
@apnadesirecords8538
@apnadesirecords8538 7 ай бұрын
Bilkul sahi...
@hammadraza7064
@hammadraza7064 7 ай бұрын
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
@gopalvishvakarma2617
@gopalvishvakarma2617 4 ай бұрын
😂😂
@ManOfVines
@ManOfVines 3 ай бұрын
Fr
@MuhammadAfzaal-lv5zs
@MuhammadAfzaal-lv5zs 2 ай бұрын
I HAVE THE SAME PROBLEM, AND ALHAMDULILLAH SOLVED
@EternalHidayah
@EternalHidayah Ай бұрын
fr bruh😂
@hasleyaara6797
@hasleyaara6797 Ай бұрын
completed in 3 hr
@ratikantmuduli9025
@ratikantmuduli9025 4 ай бұрын
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;
@phanitejakv
@phanitejakv 4 ай бұрын
@@-ck8sd Only SQL, DBMS is not covered
@AnandKumar-ji6wb
@AnandKumar-ji6wb 10 ай бұрын
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👍
@abbhushan
@abbhushan 9 ай бұрын
Age dekha na Bhai, ki khush hokar chala gya
@raazsrivastav1035
@raazsrivastav1035 8 ай бұрын
​@@abbhushan🤣🤣🤣🤣🤣
@zohaibmanzoor3173
@zohaibmanzoor3173 6 ай бұрын
Aur main jo 2X pe video chala rha tha, achanak laga ke Space button corrupt hogaya!!
@naturethings5
@naturethings5 8 ай бұрын
Constraints in SQL: १)not null २) unique ३) primary key ४) foreign key ५) default ६) check
@sugandhasethi6885
@sugandhasethi6885 Жыл бұрын
After watching this video I can add SQL in my resume as technical skills 😁🤪
@shaifali1130
@shaifali1130 7 ай бұрын
😂
@alparslanaslamcoding856
@alparslanaslamcoding856 7 ай бұрын
GOOD IDEA
@Helloworld0809
@Helloworld0809 5 ай бұрын
I am here after added 😅
@Bdmadiq
@Bdmadiq 5 ай бұрын
😂
@Abhishek-rx1cj
@Abhishek-rx1cj 5 ай бұрын
​@@Helloworld0809 now I know SQL language only . next what should be learned in database related ?....which help further iny projects for backend
@Rider12374
@Rider12374 Сағат бұрын
2:51:17 Its correct , no need to change
@muhammadarhamshahbaz4805
@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
@laughAndLiveLong Жыл бұрын
SQL matlab structured query language but in my view SQL matlab : --- SHRADHA the QUEEN of all LANGUAGES
@galaxygaming5289
@galaxygaming5289 Жыл бұрын
Nice try
@shrikant301991
@shrikant301991 Жыл бұрын
​@@galaxygaming5289😅😅😅
@India_Asks
@India_Asks 8 ай бұрын
अति उत्तम ✋
@ChandanKumar-ku7wf
@ChandanKumar-ku7wf 8 ай бұрын
Nahi aega reply bhai
@Priyanka-hp5do
@Priyanka-hp5do 8 ай бұрын
Nahi degi💀
@nandishbt2405
@nandishbt2405 10 ай бұрын
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
@deeyaagrawal4818
@deeyaagrawal4818 16 күн бұрын
does it cover squlite 3?
@sathyasai1995
@sathyasai1995 3 ай бұрын
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
@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....
@ravichauhan3933
@ravichauhan3933 8 ай бұрын
आप बहुत अच्छा समझते हो जो शब्दों में बया नहीं हो सकता मैं काफी समय से Sql or MySql में Confuse tha .पर अब मेरे सारे dubt पूरे हो गए हैं
@mayanksaini7767
@mayanksaini7767 5 ай бұрын
Bhai SQL or my sql m antar h kya
@krishxstocks
@krishxstocks 3 ай бұрын
@@mayanksaini7767 sql chalane ka ek platform hai jiska naam my sql hai. sql ek hi hai !
@krishxstocks
@krishxstocks 3 ай бұрын
@@mayanksaini7767 sql language hai mysql bas ek platform hai jispe hum kaam kar rhe. there are many platforms like mysql, oracle etc
@he3247
@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
@mohammedarbazkhan9293 Жыл бұрын
hi have you got placed in any organization??
@mystudy8802
@mystudy8802 Жыл бұрын
same question, have you?
@he3247
@he3247 Жыл бұрын
Not yet but hopefully I will get placed, looking for opportunities.
@life_iitism
@life_iitism 11 ай бұрын
Is this course complete, like if I finish it.. will I be prepared for an entry level role at SQL?
@asgzz3996
@asgzz3996 9 ай бұрын
what languages we have to study for becoming a data anaylst
@souravchakraborty1590
@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
@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
@siddharthasanyal4214 Жыл бұрын
same here :)
@fit_tubes_365
@fit_tubes_365 8 ай бұрын
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!
@ezioafaqyt8442
@ezioafaqyt8442 3 ай бұрын
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
@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
@gourabbiswas1885 Ай бұрын
3 day complete...
@srikrishna1981
@srikrishna1981 11 ай бұрын
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...
@Insect... 6 ай бұрын
Bruh u R slow as hell This takes hardly 2-2.5 hours to fully understand and learn
@nits_sanatan_beats
@nits_sanatan_beats 15 күн бұрын
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-u6m
@NisthaMishra-u6m 11 ай бұрын
Very good lecture. Covered all the basics. Very good for someone who is beginning to learn SQL. Thankyou
@aryanoakshorts
@aryanoakshorts Жыл бұрын
This Chanel is A blessing to all the Cs/It Engineers💯
@mkarvj
@mkarvj Жыл бұрын
Excellent class Shradha, I seriously learned SQL from this video. You made it very crisp and clear. Thanks a lot, Shradha 🙏🙏🙏🙏🙏🙏
@deeyaagrawal4818
@deeyaagrawal4818 16 күн бұрын
does it cover sqlite?
@SatyamTrimale-p3m
@SatyamTrimale-p3m 25 күн бұрын
Got a package of 8LPA just because of shraddha di 😊❤
@_Atmika_
@_Atmika_ 17 күн бұрын
congratulations
@SatyamTrimale-p3m
@SatyamTrimale-p3m 11 күн бұрын
@@_Atmika_ Thanks😇
@Chintu0098
@Chintu0098 10 күн бұрын
What you have learned bro? Can you please guide us to what to learn to get package like you
@Shishir-d2t
@Shishir-d2t 7 күн бұрын
Congratulations 🎉 👏. What is the role bro? How did you search the job? And are you experienced or a fresher?
@SatyamTrimale-p3m
@SatyamTrimale-p3m 7 күн бұрын
@@Shishir-d2t Got it through college campus & I'm a fresher. Job role is Product Development & Analysis
@riazmalik7556
@riazmalik7556 8 ай бұрын
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-ph7in
@Himanshu-ph7in 3 ай бұрын
contact ho sakta hai
@electronicsprayogshala3889
@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-jainamshah3
@419-jainamshah3 8 ай бұрын
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.
@Shoaibistan
@Shoaibistan 5 ай бұрын
what roadmap are you following?
@Soul2356-z9o
@Soul2356-z9o 5 ай бұрын
in which way u are going to complete the sql iam also from commerce background
@mrrabbani5224
@mrrabbani5224 Ай бұрын
Didi Please Start Advance SQL .Its humble request from all student.....
@vedanshgarg7938
@vedanshgarg7938 11 ай бұрын
02:24:00 JOINS in SQL 02:51:23 UNION in SQL 02:53:54 SQL Sub Queries 03:11:26 MySQL Views
@ykofficial786
@ykofficial786 10 ай бұрын
t q bro
@OJ1299
@OJ1299 10 ай бұрын
Thankyou Vedansh
@syedadnan662
@syedadnan662 Жыл бұрын
For 2:44:00 ans write the where condition for left and right join and then union them
@UmarKhan-fb3kn
@UmarKhan-fb3kn 5 ай бұрын
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
@shrutiricha6524
@shrutiricha6524 2 ай бұрын
Bhai baki Kab karega
@from_heart20
@from_heart20 Ай бұрын
Bhai khtm hua kya
@your_.tauheed
@your_.tauheed Ай бұрын
Hy​@@shrutiricha6524
@HarshChawla-dn4dp
@HarshChawla-dn4dp 20 күн бұрын
Bhai pdhai krle end krde pdhai kr phone kam chla
@CosmicPhilosophies
@CosmicPhilosophies 5 күн бұрын
Bhai Khatam karle yarr 😐
@Motivational_videos306.
@Motivational_videos306. 2 ай бұрын
Learning SQL for my board exam!!!Pure saal mein jitnaa nhi padha , 3 hours mein usse bhi jiyada padh liyaaa.thanks mam from assam❤
@Holistash
@Holistash 2 ай бұрын
same
@arpitaingermany
@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-st6di
@Manju-st6di 8 ай бұрын
Chala easy way lo teach chestunnaru superb sir...inka SQL classes continue cheyandi
@Surbhi_Srivastav
@Surbhi_Srivastav 8 ай бұрын
Watching this for my 12th boards sql revision❤
@kartikeygoyal7477
@kartikeygoyal7477 8 ай бұрын
hey surbhi! was it helpful? coz i am also studying from here for my boards
@Surbhi_Srivastav
@Surbhi_Srivastav 8 ай бұрын
@@kartikeygoyal7477 yess....
@nitishbhandari4829
@nitishbhandari4829 2 ай бұрын
Any class 12 computer science student here ?🗿
@AshokKumar-do2ix
@AshokKumar-do2ix Ай бұрын
Me toh 11 ke half yearly ke liye padh rhi hu😢
@thakurvaishnavi99z
@thakurvaishnavi99z Ай бұрын
@@AshokKumar-do2ixyayayyyyyy!!! Sammmeeeee
@LalaYadav-b1b
@LalaYadav-b1b Ай бұрын
Tu jaan ke kya ukhadega
@nitishbhandari4829
@nitishbhandari4829 Ай бұрын
@@LalaYadav-b1b Tere jese don logo se pachan laga lunga💪 Dikhat koi terko....bhai
@sujalpant-pr8br
@sujalpant-pr8br Ай бұрын
Yess
@saptarshisinha1744
@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
@shilpasahu5634 Жыл бұрын
go n check CHAI AUR CODE ..full javascript playlist
@simran_63_43
@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
@shreyajoshi4215 Жыл бұрын
Best lecture on SQL. Mam, you make concepts easy to understand with good and easy examples.
@pradeepkumar20011
@pradeepkumar20011 Жыл бұрын
Can u tell me how to install this in windows11 Pc... I m unable to download complete process
@justdrishu4880
@justdrishu4880 Жыл бұрын
​@@pradeepkumar20011me too ,
@peculiar9600
@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
@namangautam8799
@namangautam8799 9 ай бұрын
@@peculiar9600 just download the pdf file of sql notes in the description given
@biplabswain2342
@biplabswain2342 3 ай бұрын
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 .
@pawankandu914
@pawankandu914 7 ай бұрын
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
@someone-4k Жыл бұрын
You teach very good mam....i am in class 7th and i had learned 4 languages from this channel Thanku did😊
@vineetkarmakar2305
@vineetkarmakar2305 11 ай бұрын
Bhai zindagi ke maze lele yr tu 7th class mei kyu krra hai
@RajPatel-pd9gi
@RajPatel-pd9gi 24 күн бұрын
@@vineetkarmakar2305 sahi baat ha
@Redbrax_FF
@Redbrax_FF 9 күн бұрын
​@@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
@vineetkarmakar2305
@vineetkarmakar2305 9 күн бұрын
@@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
@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
@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
@mirirfan19 Жыл бұрын
​@@HindSena-seems you are more Intrested to pay for courses rather than learning
@peculiar9600
@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
@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
@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
@uojaia Ай бұрын
A big shoutout to me on completing this course!🎉... let's keep going bud!
@TruthG0D
@TruthG0D 10 ай бұрын
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;
@abhishekvashistha4017
@abhishekvashistha4017 7 ай бұрын
yes thanks bro!!!!
@diteesingh_11
@diteesingh_11 2 ай бұрын
i was looking for this comment
@swatilenka4750
@swatilenka4750 Ай бұрын
Thanks bro!! I was looking for this comment
@Saumyagrow
@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
@deepakn7961 Жыл бұрын
Shraddha is your friend
@Newindia78610
@Newindia78610 Жыл бұрын
@@deepakn7961 Yes she is her friend
@kira-re4ud
@kira-re4ud 9 ай бұрын
maam bolo
@JyotiSingh-sp3ny
@JyotiSingh-sp3ny 5 ай бұрын
Hii
@harshsaxena05
@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
@Luxurylife1012 Жыл бұрын
Sir , how much salary are you earning now , please share sir, this can motivate us.
@harshsaxena05
@harshsaxena05 Жыл бұрын
@@Luxurylife1012 bro its a six digit for a month.
@saikirankandula2153
@saikirankandula2153 Жыл бұрын
Sir , could help me in giving reference...
@harshsaxena05
@harshsaxena05 Жыл бұрын
@@saikirankandula2153 how much experience and what technology you are looking for?
@abiyafatima8271
@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
@zahidsadiq1251 Ай бұрын
East and West Indians are best.❤❤ from Pakistan 🇵🇰 ♥️
@UmarAli-ck1qp
@UmarAli-ck1qp 8 ай бұрын
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
@_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!
@40princerathod9-a2
@40princerathod9-a2 Жыл бұрын
Didi make full playlist on python please
@xrishna777
@xrishna777 Жыл бұрын
​@@40princerathod9-a2already cwh made it
@zakria344
@zakria344 Жыл бұрын
kzbin.info/www/bejne/pWm2hq1meKyAZ80si=dT5VmEJfVFkYceIqv
@aryanram02
@aryanram02 11 ай бұрын
bot comment lmaoo
@SaurabhKumar-gh3vo
@SaurabhKumar-gh3vo Жыл бұрын
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
@dotnetsqlmaster
@dotnetsqlmaster 11 ай бұрын
For SQL dotnet MVC api pratical www.youtube.com/@dotnetsqlmaster?sub_confirmation=1
@NiteshMaurya1111
@NiteshMaurya1111 15 күн бұрын
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
@arshadaslam7976 Жыл бұрын
We want full javascript tutorial with notes❤❤❤ Please shraddha ma'am ❤❤❤
@shaikshahed413
@shaikshahed413 11 ай бұрын
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
@abhityagi9807 Жыл бұрын
maturity is when you watch the complete lecture on 2x after watching installation of software on 2x 😉
@rajsingh2575
@rajsingh2575 4 ай бұрын
Never felt confidence in SQL but after watching this definitely feel good and confident about SQL!
@priyankapawar8749
@priyankapawar8749 Жыл бұрын
Thank you for the awesome SQL lecture! Your explanations are super clear and beneficial for us. Your clear explanations are a true gem.
@riteshMusk
@riteshMusk 11 ай бұрын
wellcome
@faizulmohammad8680
@faizulmohammad8680 Жыл бұрын
Your short lecture covered all the relevant topics which is necessary for mysql. Thank you very much mam..
@Aham_Shukla
@Aham_Shukla 9 ай бұрын
Like if u r from class 11th IP😅😅😅
@MeetPRAJAPATI-rh9jz
@MeetPRAJAPATI-rh9jz 4 ай бұрын
Hii
@TricksWala
@TricksWala 8 күн бұрын
Best SQL Course👌!! Plz upload python notes in drive as they are deleted..
@nishithshah8109
@nishithshah8109 Жыл бұрын
Shraddha Ma'am, Pleaseconsider my Humble Request to provide Chapters for Videos and Timestamps for the Videos. Further action will be appreciated 😊❤
@tejaswirupa537
@tejaswirupa537 Жыл бұрын
This would be really helpful while preparing for exams
@manibhushankumar8669
@manibhushankumar8669 Жыл бұрын
TimsStamp To khud dal do wo bhi Sharda Didi hi Karengi
@gourav1343
@gourav1343 Жыл бұрын
@@manibhushankumar8669 🤣
@gourav1343
@gourav1343 Жыл бұрын
@@manibhushankumar8669 Inka Bas chale to Exam bhi oonhi se dilwade dedengi 🤣
@ishansrivastava4911
@ishansrivastava4911 8 ай бұрын
Class 12 th student Cbse please attend here 😂!
@rishabhkapoor0444
@rishabhkapoor0444 8 ай бұрын
Bhai ajj se hi start kiya padhna😂😂
@Fayroll5
@Fayroll5 8 ай бұрын
@@rishabhkapoor0444 skib
@sp-wo7sl
@sp-wo7sl 8 ай бұрын
@@rishabhkapoor0444 main to aj kr rhi hu
@5hubham_editxx
@5hubham_editxx 8 ай бұрын
Wahi kar raha hu bhai😅😅
@itsgreat1475
@itsgreat1475 8 ай бұрын
Class 12 ip here
@nayanchavd645
@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 🙏
@rutujashintre3925
@rutujashintre3925 3 ай бұрын
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
@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-mf5cs
@AnkitaSingh-mf5cs 11 ай бұрын
from where did you got the practice set and notes? TIA
@miss_naaz53
@miss_naaz53 11 ай бұрын
@@AnkitaSingh-mf5csduring the video
@ioni-thedaddysgirl5743
@ioni-thedaddysgirl5743 Жыл бұрын
The explanation is straightforward, and it aided me greatly in revising SQL.
@jayeshmalviya3463
@jayeshmalviya3463 3 ай бұрын
This 3 hours of video actually helped alot to learn SQL for the very first time. Thank you, Shraddha!
@pratikshajondhalekar86
@pratikshajondhalekar86 3 ай бұрын
yes indeed
@mohammadhasib5817
@mohammadhasib5817 Жыл бұрын
We need DSA course with C++ with your lecture.
@gaganbhattacharya9890
@gaganbhattacharya9890 Жыл бұрын
I guess, it's already there search the apna college playlist!
@coderprakash
@coderprakash Жыл бұрын
​@@gaganbhattacharya9890no he's asking c++ DSA lectures by her
@mohammadhasib5817
@mohammadhasib5817 Жыл бұрын
@@gaganbhattacharya9890 different tutor
@Call_Me_Mortis
@Call_Me_Mortis Жыл бұрын
you can learn from code help
@peculiar9600
@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
@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
@shreyakolekar4059 Жыл бұрын
More power to you Shradha Ma'am! ♥ You teach so well! Thank you this amazing lecture.
@akshatabhalke7945
@akshatabhalke7945 3 ай бұрын
Explaining SQL's order of execution makes queries easier to understand and work with.
@know1374
@know1374 4 ай бұрын
How did you manage to learn so many things.? Its amazing how you know everything even though you are so young. Respect✌
@vaibhavkottari4177
@vaibhavkottari4177 2 ай бұрын
Anyone pursuing BE in CSE must know this all . She completed and knows . The quality is the difference which makes her unique
@know1374
@know1374 2 ай бұрын
@@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
@Parth-gx1nw Ай бұрын
it is about determination and interest. Majority of current students take CSE for high packages.
@tuhinsuryachakraborty
@tuhinsuryachakraborty 2 ай бұрын
Target: to complete this within a week.
@tuhinsuryachakraborty
@tuhinsuryachakraborty 2 ай бұрын
Started yesterday, completed today. Thanks didi.
@The_Rolex_25
@The_Rolex_25 2 ай бұрын
​​@@tuhinsuryachakrabortyme starting today
@anshumanchowdhury8817
@anshumanchowdhury8817 2 ай бұрын
How to complete within 6 hours ​@@tuhinsuryachakraborty
@ahasanulmustafa1241
@ahasanulmustafa1241 Ай бұрын
😂 I completed it in one sitting 😂
@shreyanshchaubey4399
@shreyanshchaubey4399 Ай бұрын
​@@ahasanulmustafa1241sabki apni apni pace hoti hai na bhai ..we should respect
@RajEditing9119
@RajEditing9119 3 ай бұрын
Day1 :- 37:28 Day2 :- 50:03 Day3 :- 1:10:35 Day4:-1:20:36
@shambha_shiva
@shambha_shiva 3 ай бұрын
Day 5 dead?
@RajPatel-pd9gi
@RajPatel-pd9gi 24 күн бұрын
@@shambha_shiva 🤣🤣 lol
@vladimirputin134
@vladimirputin134 3 күн бұрын
Bassssss hawa nikal gyi 😂
@datacherisher3368
@datacherisher3368 10 күн бұрын
An amazing video if you want to brush up your SQL basics. Thankyou so much for such a wonderful and easy explanation!
@rishirajkumar4624
@rishirajkumar4624 3 ай бұрын
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.
@tusharchunbuk8332
@tusharchunbuk8332 29 күн бұрын
I was just gonna comment this, but I found your comment regarding the same.
@narendrababugotla7373
@narendrababugotla7373 Жыл бұрын
The best video I have come across. Beginners also can understand easily by the way she is explaining.
@hemaexperience
@hemaexperience Жыл бұрын
Didi, we want a lecture on how to navigate career growth in corporate MNCs 😊😊
@DaanyalKhan-x8b
@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
@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
@PoojaMewada-o8f Жыл бұрын
Notes download ho rahe kya
@ashukundra5906
@ashukundra5906 4 ай бұрын
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.
@jahangiralikhan2410
@jahangiralikhan2410 10 ай бұрын
Easy to understand and grasp knowledge, wonderful video and explanation; kudos to your efforts and easy explanation. 💯💯
@AayushDhimantbhaiPatel
@AayushDhimantbhaiPatel 2 ай бұрын
You guys are increasing the knowledge wealth of Indian students at the mass level! Kudos to Shradhha Mam and Aman Dhatarwal!
@sankhadipkarmakar799
@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
@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
@AbhishekMogavira
@AbhishekMogavira 2 ай бұрын
My thoughts before learning SQL = Coding 😒 But Actually. SQL = Excel ki behenponi 😊😊😊
@gammax5446
@gammax5446 Жыл бұрын
Shraddha didi thanks for your great Explanation.. This 3hrs was a lot more than what college teaches us.. Thank you didi❤😊😊
@vansh1197
@vansh1197 2 ай бұрын
Damn, This course is Best SQL one short Course , Must recommend to watch this.
@Vikas.Verma06
@Vikas.Verma06 4 ай бұрын
1:40:35 SELECT mode, sum(payment) FROM table_name GROUP BY mode;
What is Docker? Simply Explained by Shradha Ma'am
19:32
Apna College
Рет қаралды 512 М.
Вся база SQL для начинающих за 1 час
1:19:48
Vlad Mishustin
Рет қаралды 335 М.
Из какого города смотришь? 😃
00:34
МЯТНАЯ ФАНТА
Рет қаралды 2,6 МЛН
快乐总是短暂的!😂 #搞笑夫妻 #爱美食爱生活 #搞笑达人
00:14
朱大帅and依美姐
Рет қаралды 13 МЛН
Players vs Pitch 🤯
00:26
LE FOOT EN VIDÉO
Рет қаралды 138 МЛН
Мама у нас строгая
00:20
VAVAN
Рет қаралды 11 МЛН
Complete Git and GitHub Tutorial for Beginners
1:15:22
Apna College
Рет қаралды 3,2 МЛН
I'm 24. If you're 14-23 please watch this...
6:37
Tharun Speaks
Рет қаралды 495 М.
Which one to Choose - Web Development vs App Development ?
12:21
Apna College
Рет қаралды 845 М.
Learn English quickly with podcast | English learning Conversation | Episode 1
18:01
I Tried 50 Data Analyst Courses. Here Are Top 5
8:41
Stefanovic
Рет қаралды 109 М.
Из какого города смотришь? 😃
00:34
МЯТНАЯ ФАНТА
Рет қаралды 2,6 МЛН