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

  Рет қаралды 5,785,550

Apna College

Apna College

Күн бұрын

You can join the NEW Web Development batch using the below link.
🔥Delta 3.0(Full Stack Web Development) : www.apnacollege.in/course/del...
Early bird offer for first 5000 students only!
International Student (payment link) - buy.stripe.com/7sI00cdru0tg10...
---------------------------------------------------
📌 Details about the Delta 3.0 Batch :
- Start Date : 7th November, 2023
- Alternate day lectures (at 8PM)
- Duration - 4.5 months
- Each Class duration : 1.5 hour-2hour (alternate days)
- Access to the course is for 2 years
- Complete Frontend Development with HTML, CSS, Javascript & ReactJs
- Complete Backend Development (NodeJs, ExpressJs)
- Complete Database -( SQL & MongoDB)
- Complete MERN Stack (MongoDB, Express, React, Node)
- Real Life and Industry Grade Projects
- Live Mentorship Sessions
- 500+Topic Videos
- Certificate will be given on Completion.
Link for SQL Notes : drive.google.com/drive/folder...
SQL Timestamps:
Start - 00:00
Introduction to SQL - 01:43
01:48 What is database?
03:45 Types of databases
08:03 Installation of MySQL
13:03 Database Structure
14:21 What is table?
16:29 Creating our first database
22:41 Creating our first table
29:49 SQL Datatypes
37:11 Types of SQL Commands
40:09 Database related queries
43:43 Table related queries
46:11 SELECT Command
47:22 INSERT Command
51:19 Practice Questions
56:25 Keys
01:01:26 Constraints
01:13:04 SELECT Command in Detail
01:15:10 Where Clause
01:21:19 Operators
01:25:21 Limit Clause
01:26:48 Order By Clause
01:29:12 Aggregate Functions
01:32:33 Group By Clause
01:37:51 Practice Questions
01:43:35 Having Clause
01:47:18 General Order of Commands
01:50:31 UPDATE Command
01:56:40 DELETE Command
01:58:41 Revisiting Foreign Keys
02:06:35 Cascading Foreign Keys
02:12:30 ALTER Command
02:15:06 CHANGE and MODIFY Commands
02:20:33 TRUNCATE Command
02:24:00 JOINS in SQL
02:51:23 UNION in SQL
02:53:54 SQL Sub Queries
03:11:26 MySQL Views

Пікірлер: 4 000
@AmanDhattarwal
@AmanDhattarwal 9 ай бұрын
Great Lecture & thank you Shradha Ma'am : ) Some student please share timestamps so that other students can also benefit.
@factzfactory4956
@factzfactory4956 9 ай бұрын
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 9 ай бұрын
Wow ❤❤
@desichhoraazamgarh
@desichhoraazamgarh 9 ай бұрын
Please Java Script par ek lecture ❤
@HSKhan-lc5pk
@HSKhan-lc5pk 9 ай бұрын
Please Bhaiya JavaScript par bhi video banao
@factzfactory4956
@factzfactory4956 9 ай бұрын
@@HSKhan-lc5pk Javascript ka bahut courses hai TypeScript ka course chahiya Jo javascript ka superset hai
@sugandhasethi6885
@sugandhasethi6885 8 ай бұрын
After watching this video I can add SQL in my resume as technical skills 😁🤪
@shaifali1130
@shaifali1130 2 ай бұрын
😂
@alparslanaslamcoding856
@alparslanaslamcoding856 Ай бұрын
GOOD IDEA
@hammadraza7064
@hammadraza7064 2 ай бұрын
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
@SAAAAAAAAAAAAAAAAAAAAAAA-ez6hg
@SAAAAAAAAAAAAAAAAAAAAAAA-ez6hg 3 ай бұрын
1 hour into the video ! fantastic clear explanation. Probably the best SQL video i've stumbled upon!
@brsstatusworldofficial8754
@brsstatusworldofficial8754 9 ай бұрын
Didi we want a full course on Javascript 😊
@purabgehlot2114
@purabgehlot2114 9 ай бұрын
Please do it
@Recker1818
@Recker1818 9 ай бұрын
Yes
@saptarshisinha1744
@saptarshisinha1744 9 ай бұрын
Yes we want
@oloraclasses9930
@oloraclasses9930 9 ай бұрын
Yes ✋
@strs_singh
@strs_singh 9 ай бұрын
Yes
@aniketkumar9215
@aniketkumar9215 9 ай бұрын
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 6 ай бұрын
1:47
@riazmalik7556
@riazmalik7556 2 ай бұрын
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.
@VinayKumarDubey-wd1cy
@VinayKumarDubey-wd1cy 3 ай бұрын
@2:44:08 -- find the full exclusive join (A U B - A instersection B ) -- it is nothing but the union of left exclusive join and right exclusive join select * from student as lef left join course as rig on lef.id=rig.id where rig.id is NULL UNION select * from student as lef right join course as rig on lef.id=rig.id where lef.id is null;
@nupurnishant4197
@nupurnishant4197 9 ай бұрын
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 9 ай бұрын
Relatable
@bhavyachampaneri
@bhavyachampaneri 8 ай бұрын
Wow senior consultants also watching
@shreeshree4270
@shreeshree4270 7 ай бұрын
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 7 ай бұрын
Hlo sir
@mrsmurf911
@mrsmurf911 7 ай бұрын
@@Gatefighter886 hlo
@pskroyallife636
@pskroyallife636 9 ай бұрын
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....
@ishansrivastava4911
@ishansrivastava4911 3 ай бұрын
Class 12 th student Cbse please attend here 😂!
@rishabhkapoor0444
@rishabhkapoor0444 2 ай бұрын
Bhai ajj se hi start kiya padhna😂😂
@Fayroll5
@Fayroll5 2 ай бұрын
@@rishabhkapoor0444 skib
@sp-wo7sl
@sp-wo7sl 2 ай бұрын
@@rishabhkapoor0444 main to aj kr rhi hu
@5hubham_editxx
@5hubham_editxx 2 ай бұрын
Wahi kar raha hu bhai😅😅
@itsgreat1475
@itsgreat1475 2 ай бұрын
Class 12 ip here
@AnandKumar-ji6wb
@AnandKumar-ji6wb 4 ай бұрын
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 3 ай бұрын
Age dekha na Bhai, ki khush hokar chala gya
@raazsrivastav1035
@raazsrivastav1035 2 ай бұрын
​@@abbhushan🤣🤣🤣🤣🤣
@zohaibmanzoor3173
@zohaibmanzoor3173 19 күн бұрын
Aur main jo 2X pe video chala rha tha, achanak laga ke Space button corrupt hogaya!!
@srikrishna1981
@srikrishna1981 5 ай бұрын
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... 24 күн бұрын
Bruh u R slow as hell This takes hardly 2-2.5 hours to fully understand and learn
@sushilgbp
@sushilgbp 7 ай бұрын
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 2 ай бұрын
Good 👍👍
@FAYiSYT
@FAYiSYT 2 ай бұрын
Also also where D is null use hoga
@anshulkumar8846
@anshulkumar8846 Ай бұрын
literally after 3 hours i have a preentaion on SQL and i got this masterpiece. Thanks Sharaddha Didi for this masterpiece ....
@apnadesirecords8538
@apnadesirecords8538 Ай бұрын
Bilkul sahi...
@naturethings5
@naturethings5 2 ай бұрын
Constraints in SQL: १)not null २) unique ३) primary key ४) foreign key ५) default ६) check
@419-jainamshah3
@419-jainamshah3 3 ай бұрын
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.
@mkarvj
@mkarvj 8 ай бұрын
Excellent class Shradha, I seriously learned SQL from this video. You made it very crisp and clear. Thanks a lot, Shradha 🙏🙏🙏🙏🙏🙏
@nandishbt2405
@nandishbt2405 5 ай бұрын
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
@adeshgaurav1053
@adeshgaurav1053 2 ай бұрын
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 2 ай бұрын
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.
@user-nb6ts9yo6c
@user-nb6ts9yo6c 21 күн бұрын
@@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.
@Aham_Shukla
@Aham_Shukla 3 ай бұрын
Like if u r from class 11th IP😅😅😅
@arpita0608
@arpita0608 9 ай бұрын
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.
@user-qf4zk8nz2w
@user-qf4zk8nz2w 6 ай бұрын
Very good lecture. Covered all the basics. Very good for someone who is beginning to learn SQL. Thankyou
@user-tl9gi6yw4q
@user-tl9gi6yw4q 2 ай бұрын
hey have you completed this course ? i am just facing some issues thats why i asked you !!
@ravichauhan3933
@ravichauhan3933 2 ай бұрын
आप बहुत अच्छा समझते हो जो शब्दों में बया नहीं हो सकता मैं काफी समय से Sql or MySql में Confuse tha .पर अब मेरे सारे dubt पूरे हो गए हैं
@shoaibasghar9046
@shoaibasghar9046 2 ай бұрын
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.
@djpraveenrockzmbnr
@djpraveenrockzmbnr 9 ай бұрын
SQL matlab structured query language but in my view SQL matlab : --- SHRADHA the QUEEN of all LANGUAGES
@galaxygaming5289
@galaxygaming5289 7 ай бұрын
Nice try
@shrikant301991
@shrikant301991 7 ай бұрын
​@@galaxygaming5289😅😅😅
@India_Asks
@India_Asks 3 ай бұрын
अति उत्तम ✋
@ChandanKumar-ku7wf
@ChandanKumar-ku7wf 3 ай бұрын
Nahi aega reply bhai
@Priyanka-hp5do
@Priyanka-hp5do 2 ай бұрын
Nahi degi💀
@muhammadquraishi7014
@muhammadquraishi7014 8 ай бұрын
Great Lecture , very simple and easy way of teaching with clear examples which are highly appreciated. once again thanks
@UmarAli-ck1qp
@UmarAli-ck1qp 3 ай бұрын
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.
@D_J40
@D_J40 Ай бұрын
Are you speaking at 3x speed???
@madhujabora7684
@madhujabora7684 4 күн бұрын
Yah, before 3 hours of final
@he3247
@he3247 8 ай бұрын
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 8 ай бұрын
hi have you got placed in any organization??
@mystudy8802
@mystudy8802 7 ай бұрын
same question, have you?
@he3247
@he3247 7 ай бұрын
Not yet but hopefully I will get placed, looking for opportunities.
@life_iitism
@life_iitism 5 ай бұрын
Is this course complete, like if I finish it.. will I be prepared for an entry level role at SQL?
@asgzz3996
@asgzz3996 4 ай бұрын
what languages we have to study for becoming a data anaylst
@faizulmohammad8680
@faizulmohammad8680 9 ай бұрын
Your short lecture covered all the relevant topics which is necessary for mysql. Thank you very much mam..
@harshedabdulla1269
@harshedabdulla1269 2 ай бұрын
Thank you!! One of the best classes about mySQL, really enjoyed it!!
@Surbhi_Srivastav
@Surbhi_Srivastav 2 ай бұрын
Watching this for my 12th boards sql revision❤
@kartikeygoyal7477
@kartikeygoyal7477 2 ай бұрын
hey surbhi! was it helpful? coz i am also studying from here for my boards
@Surbhi_Srivastav
@Surbhi_Srivastav 2 ай бұрын
@@kartikeygoyal7477 yess....
@_bisyibadal._1782
@_bisyibadal._1782 9 ай бұрын
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 9 ай бұрын
Didi make full playlist on python please
@xrishna777
@xrishna777 9 ай бұрын
​@@40princerathod9-a2already cwh made it
@zakria344
@zakria344 9 ай бұрын
kzfaq.info/get/bejne/pZ6DiN1hqK2xYZ8.htmlsi=dT5VmEJfVFkYceIqv
@aryanram02
@aryanram02 6 ай бұрын
bot comment lmaoo
@ioni-thedaddysgirl5743
@ioni-thedaddysgirl5743 9 ай бұрын
The explanation is straightforward, and it aided me greatly in revising SQL.
@Dhananjaykumar-ro6zg
@Dhananjaykumar-ro6zg 4 ай бұрын
I productive lecture, seems like a picture that stick with the users emotion. Thank you Apna College and Shradha.
@batsy941
@batsy941 Ай бұрын
great video better than many coursera theory courses which dont teach such practical knowledge which is required in workplaces not only in textbooks
@Saumyagrow
@Saumyagrow 9 ай бұрын
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 9 ай бұрын
Shraddha is your friend
@nishitprajapat786
@nishitprajapat786 7 ай бұрын
@@deepakn7961 Yes she is her friend
@kira-re4ud
@kira-re4ud 3 ай бұрын
maam bolo
@JyotiSingh-sp3ny
@JyotiSingh-sp3ny 10 күн бұрын
Hii
@muhammadarhamshahbaz4805
@muhammadarhamshahbaz4805 9 ай бұрын
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❤❤❤.
@bansheeeeesh
@bansheeeeesh 4 ай бұрын
Amazing lecture, I wanted a really good guide for SQL and you were the perfect tutor. Thank you!
@Manju-st6di
@Manju-st6di 3 ай бұрын
Chala easy way lo teach chestunnaru superb sir...inka SQL classes continue cheyandi
@priyankapawar8749
@priyankapawar8749 6 ай бұрын
Thank you for the awesome SQL lecture! Your explanations are super clear and beneficial for us. Your clear explanations are a true gem.
@riteshko123
@riteshko123 5 ай бұрын
wellcome
@nayanchavd645
@nayanchavd645 7 ай бұрын
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 🙏
@bharatdugar48
@bharatdugar48 3 ай бұрын
A heartful thanks to you mam , in 3 hours u gave a fantastic overview of SQL and its queries .Hats off to you !!
@shubhamsingrajput1707
@shubhamsingrajput1707 4 ай бұрын
A very good explanation of SQL. Your articulation and ability to break thru concepts is brilliant and I am completed this course in this week. Thank you
@simran_63_43
@simran_63_43 7 ай бұрын
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....
@harshsaxena05
@harshsaxena05 9 ай бұрын
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.
@Mohammadfairaz1814
@Mohammadfairaz1814 9 ай бұрын
Sir , how much salary are you earning now , please share sir, this can motivate us.
@harshsaxena05
@harshsaxena05 9 ай бұрын
@@Mohammadfairaz1814 bro its a six digit for a month.
@saikirankandula2153
@saikirankandula2153 9 ай бұрын
Sir , could help me in giving reference...
@harshsaxena05
@harshsaxena05 9 ай бұрын
@@saikirankandula2153 how much experience and what technology you are looking for?
@abiyafatima8271
@abiyafatima8271 9 ай бұрын
​@@harshsaxena05Respected bro could help me to guid how i can take a start? And where..plzz reply..i'll be really venerable to uu
@jigyashajain1367
@jigyashajain1367 4 ай бұрын
Amazing content! Thanks for explaining the concepts and at the same time helping to implement it through practice questions.
@parulsharma330
@parulsharma330 Ай бұрын
this was an Amazing course Shardha. Crisp, clear, to the point and very easy to understand. Thank you!
@SaurabhKumar-gh3vo
@SaurabhKumar-gh3vo 9 ай бұрын
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 5 ай бұрын
For SQL dotnet MVC api pratical www.youtube.com/@dotnetsqlmaster?sub_confirmation=1
@hrishibari9044
@hrishibari9044 8 ай бұрын
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 8 ай бұрын
exactly but she wanted to show usage of the subquery as an example else i came up with same idea as yours😅
@sanjanahalli1174
@sanjanahalli1174 7 ай бұрын
Does sql requires logic?
@hrishibari9044
@hrishibari9044 7 ай бұрын
@@sanjanahalli1174 obviously.. SQL is a language used for getting solutions to some problems.. and solving any problem requires logic.
@po3442
@po3442 Ай бұрын
brilliant lecture! benefitted a lot for my dbms lab end semester exam!
@vasudev6412
@vasudev6412 28 күн бұрын
Superb excellent Shradha,... This is my first class on SQL, you made so easier than learning ABCs
@gammax5446
@gammax5446 9 ай бұрын
Shraddha didi thanks for your great Explanation.. This 3hrs was a lot more than what college teaches us.. Thank you didi❤😊😊
@Shiva_Gheji
@Shiva_Gheji 9 ай бұрын
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 9 ай бұрын
same here :)
@saqiburdu
@saqiburdu 2 ай бұрын
behtreen video big thanks from pakistan .aj roza aftar mai ap k liye dua k ap hamesha khush rahen ameen.
@maheshbk1633
@maheshbk1633 10 минут бұрын
Very informative lecture...portrayed SQL in a very easy and interesting manner, thank you!
@gauravsrivastava4438
@gauravsrivastava4438 9 ай бұрын
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...
@narendrababugotla7373
@narendrababugotla7373 9 ай бұрын
The best video I have come across. Beginners also can understand easily by the way she is explaining.
@wonderweebwoman
@wonderweebwoman Ай бұрын
I am watching apna college content for the first time and I am obsessed! Clean to-the-point explanation. Loved it!
@VDhanush
@VDhanush 4 ай бұрын
I loved this course. I watched for an hour for 3 to 4 days. Loved it. Understood it. You made it seem so simple and easy to understand. Thank you !!!
@shreyajoshi4215
@shreyajoshi4215 9 ай бұрын
Best lecture on SQL. Mam, you make concepts easy to understand with good and easy examples.
@pradeepkumar20011
@pradeepkumar20011 9 ай бұрын
Can u tell me how to install this in windows11 Pc... I m unable to download complete process
@justdrishu4880
@justdrishu4880 9 ай бұрын
​@@pradeepkumar20011me too ,
@peculiar9600
@peculiar9600 8 ай бұрын
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 3 ай бұрын
@@peculiar9600 just download the pdf file of sql notes in the description given
@gourav1343
@gourav1343 9 ай бұрын
Simply Amazing for Both Learning and Revision.
@user-vx4wj2iq6u
@user-vx4wj2iq6u 29 күн бұрын
Thank you Didi I have brushed up my mySQL skill for my interview. Thank you for making such a sort and detailed video it covered almost every topic of MySQL.
@Aditya-rw2ly
@Aditya-rw2ly 16 күн бұрын
A big Thank you from all the learners. 🙏🙏
@MAH-ls1if
@MAH-ls1if 7 ай бұрын
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
@suryakantpanday8860
@suryakantpanday8860 9 ай бұрын
One of the best lecture in the whole youtube regarding database😊 thankyou so much mam
@avengersstudios8190
@avengersstudios8190 16 күн бұрын
I haven't felt this much confident in SQL before watching this video...Absolute Carnage Ma'am!! Thank You!
@AnkitPal-hi8yb
@AnkitPal-hi8yb Ай бұрын
thank you didi your course helped me a lot
@priyakashyap3025
@priyakashyap3025 9 ай бұрын
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 9 ай бұрын
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 9 ай бұрын
​@@HindSena-seems you are more Intrested to pay for courses rather than learning
@peculiar9600
@peculiar9600 8 ай бұрын
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 8 ай бұрын
@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 KZfaq, people are easily fooled. In the university, we have not seen any lecturer who teaches all the subjects like this lady (Shradha Didi).
@LowkeyCoder
@LowkeyCoder 8 ай бұрын
mausi naaki chachi ki beti hai aise hi di bol rahi ho
@kajalchauhan2488
@kajalchauhan2488 4 ай бұрын
I did the course of Sql but you explained in such a simple way was mind blowing 🤯. For a revision and study your video is best on youtube.❤❤❤
@jaanujanaki1605
@jaanujanaki1605 2 ай бұрын
Thanks for the lecture, help a lot for 12th CBSE sql, very nice explanation
@aryanoakshorts
@aryanoakshorts 9 ай бұрын
This Chanel is A blessing to all the Cs/It Engineers💯
@AliHamza-ne3hp
@AliHamza-ne3hp 7 ай бұрын
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!
@user-rh7uq2bp4c
@user-rh7uq2bp4c 7 ай бұрын
Notes download ho rahe kya
@stith_pragya
@stith_pragya Күн бұрын
Thank You So Much for this wonderful video......🙏🏻🙏🏻🙏🏻🙏🏻🙏🏻🙏🏻
@harsha8631
@harsha8631 4 ай бұрын
Thankyou for this amazing "to the point" course on MySQL....it was interesting and engaging, it was so helpful....
@miss_naaz53
@miss_naaz53 9 ай бұрын
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 6 ай бұрын
from where did you got the practice set and notes? TIA
@miss_naaz53
@miss_naaz53 6 ай бұрын
@@AnkitaSingh-mf5csduring the video
@ashmeetsehgal5113
@ashmeetsehgal5113 8 ай бұрын
Hey, I just loved how you explained everything, thank you so much! Would you be able to tell me as to where can I practice it further as I want to get hands-on experience on SQL before moving on to the next course.
@rohankoli6356
@rohankoli6356 4 ай бұрын
Really nice Shraddha, I would request you please add one brief lecture of stored procedure..
@pawankandu914
@pawankandu914 Ай бұрын
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
@aasthashah1234
@aasthashah1234 9 ай бұрын
Thank you so much Shraddha di..for making this amazing SQL video. It's very helpful for our interview❤❤
@saptarshisinha1744
@saptarshisinha1744 9 ай бұрын
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 9 ай бұрын
go n check CHAI AUR CODE ..full javascript playlist
@RishiSharma-ti4bt
@RishiSharma-ti4bt 4 күн бұрын
Amazing lecture! It really gave me a good hands on.
@anmolsoni5934
@anmolsoni5934 25 күн бұрын
Thank you so much ma’am! yesterday was my paper and your video helped me a lot , i was literally not prepared anything but after watching your video all the doubts were gone and loved your teaching !😌
@shortgyan845
@shortgyan845 8 ай бұрын
You teach very good mam....i am in class 7th and i had learned 4 languages from this channel Thanku did😊
@vineetkarmakar2305
@vineetkarmakar2305 5 ай бұрын
Bhai zindagi ke maze lele yr tu 7th class mei kyu krra hai
@electronicsprayogshala3889
@electronicsprayogshala3889 6 ай бұрын
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. 😀👌👍
@vinaypatil9658
@vinaypatil9658 16 сағат бұрын
Amazing session mam ! It was really a helpful session. But is there any thing more to learn in sql apart from the concepts in this session?
@kishanpatel7334
@kishanpatel7334 23 күн бұрын
Hi Shraddha Fantastic explanation which helps viewers to get thorough understanding. Looking forward to have you more vedios on New Technologies. Great Dedication 🙂
@shreyakolekar4059
@shreyakolekar4059 7 ай бұрын
More power to you Shradha Ma'am! ♥ You teach so well! Thank you this amazing lecture.
@Sketch452
@Sketch452 9 ай бұрын
Ma'am you are the best! But one request: Please upload JavaScript videos specifically designed for web development. Thank you 😊
@akashoffical7933
@akashoffical7933 2 ай бұрын
Easy to understand and grasp knowledge Nonderful video and explanation; kudos to your efforts and easy explanation.
@preetnegi9112
@preetnegi9112 3 ай бұрын
Amazing course mam !! You taught it soo well and made it easy for the beginners like me , thankyou so much ..
@vedanshgarg7938
@vedanshgarg7938 5 ай бұрын
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 5 ай бұрын
t q bro
@OJ1299
@OJ1299 5 ай бұрын
Thankyou Vedansh
@itssaad2038
@itssaad2038 2 ай бұрын
For one time revision or last moment preps. Best resource. Covers both theory and practical.
@TruthG0D
@TruthG0D 4 ай бұрын
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 2 ай бұрын
yes thanks bro!!!!
@vanshitagandhare6561
@vanshitagandhare6561 9 ай бұрын
.People like you two are gem and every hadrwork you do to teach us that's really so inspiring ❤❤
@peculiar9600
@peculiar9600 8 ай бұрын
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
@aryanram02
@aryanram02 6 ай бұрын
@@peculiar9600 dude u are commenting under a bot comment lmao.
@arshadaslam7976
@arshadaslam7976 9 ай бұрын
We want full javascript tutorial with notes❤❤❤ Please shraddha ma'am ❤❤❤
@nehabaghel3523
@nehabaghel3523 9 күн бұрын
The way you are explaining each and every point is very smooth, I have learnt so many thing with this video....thanku so much mam
@ritagaur7480
@ritagaur7480 2 ай бұрын
Make the videos on class 12th computer science it will help the students so much I'm watching this video one day before my exam and there are many topics which are not in class 12 but still the concept are covered so properly ❤❤
@AbhishekMadankar
@AbhishekMadankar 9 ай бұрын
Can't thank enough for this, you explained it in a very easy language!
@ayushisahu6735
@ayushisahu6735 8 ай бұрын
Can you explain me please installation process please??!
@AbhishekMadankar
@AbhishekMadankar 8 ай бұрын
@@ayushisahu6735 just follow her steps
@harshapawar2660
@harshapawar2660 9 ай бұрын
Hey Shradha, thank you for efforts.. Can we get certificate after completing this cource or can you assign some project, so after completing that project will get that certificate for SQL?
Complete Git and GitHub Tutorial for Beginners
1:15:22
Apna College
Рет қаралды 2,1 МЛН
MySQL Tutorial for Beginners [Full Course]
3:10:19
Programming with Mosh
Рет қаралды 11 МЛН
ВЫКИНУЛА МОЙ АЙФОН?? #shorts
00:33
Паша Осадчий
Рет қаралды 1 МЛН
Is it Cake or Fake ? 🍰
00:53
A4
Рет қаралды 16 МЛН
2000000❤️⚽️#shorts #thankyou
00:20
あしざるFC
Рет қаралды 13 МЛН
Кәріс өшін алды...| Synyptas 3 | 10 серия
24:51
kak budto
Рет қаралды 1,2 МЛН
DSA & ₹1.2 Crore Per Annum Jobs - The Truth? (No Offence)
12:22
CodeWithHarry
Рет қаралды 499 М.
3 Signs of an Inexperienced Programmer | Avoid these in Tech
9:02
Apna College
Рет қаралды 375 М.
Create DATABASE and TABLE in MYSQL || MYSQL ||DBMS
7:52
info bytes
Рет қаралды 6 М.
How to OVER Engineer a Website // What is a Tech Stack?
11:20
Fireship
Рет қаралды 2,3 МЛН
I Played the Euros 2024 With Every Nation...
24:24
S2G
Рет қаралды 271 М.
Is Data Science a Good Career?
7:15
codebasics
Рет қаралды 65 М.
Which one to Choose - Web Development vs App Development ?
12:21
Apna College
Рет қаралды 531 М.
100+ Web Development Things you Should Know
13:18
Fireship
Рет қаралды 1,4 МЛН
ВЫКИНУЛА МОЙ АЙФОН?? #shorts
00:33
Паша Осадчий
Рет қаралды 1 МЛН