L38 : Complete SQL Course for Beginners | Full Tutorial in One Video

Поделиться
HTML-код
  • Опубликовано: 16 янв 2025

Комментарии • 304

  • @RitiKumari
    @RitiKumari  3 месяца назад +18

    Disclaimer : If you feel video is bit fast, you can consider watching it at 0.5x.
    Timestamps :
    L1 : Lets Start with SQL- 00:00:17
    L2 : What is SQL- 00:05:24
    L3 : MySQL Installation - 00:08:58
    L4 : Types of SQL Commands- 00:13:11
    L5 : Databases and related SQL commands- 00:18:26
    L6 : Tables and related SQL command- 00:37:08
    L7 : Building a Database- From Tables to data insertion- 00:45:33
    L8 : Datatypes in SQL- 00:53:24
    L9 : Keys in SQL- 01:03:36
    L10 : Constraints in SQL- 01:09:23
    L11 : Foreign Key in SQL- 01:24:32
    L12 : Update Command in SQL- 01:37:35
    L13 : Delete Command in SQL- 01:49:55
    L14 : Select Command in SQL- 01:53:24
    L15 : Where Clause in SQL - 01:55:29
    L16 : ALTER Command in SQL- 01:58:59
    L17 : RENAME Command in SQL- 02:09:09
    L18 : TRUNCATE Command- 02:13:13
    L19 : Difference between TRUNCATE, DELETE & DROP in SQL - 02:16:29
    L20 : Distinct Keyword in SQL- 02:18:31
    L21 : Operators in SQL- 02:23:20
    L22 : Clauses in SQL- 02:39:03
    L23 : Aggregate Functions in SQL- 02:47:50
    L24 : GROUP BY and HAVING clause in SQL - 02:57:35
    L25 : Difference between HAVING and WHERE clause in SQL- 03:08:45
    L26 : Practice Question on clause and Aggregate Function in SQL- 03:11:26
    L27 : General Order of SQL command- 03:23:44
    L28 : Joins in SQL- 03:25:31
    L29 : Inner Join in SQL- 03:31:28
    L30 : Left Outer Join in SQL - 03:37:56
    L31 : Right Outer Join in SQL- 03:41:43
    L32 : Full Outer Join in SQL- 03:44:34
    L33 : Cross Join in SQL- 03:51:46
    L34 : Self Join in SQL- 03:56:54
    L35 : Exclusive Joins in SQL- 04:!0:48
    L36 : UNION and UNION ALL in SQL- 04:21:16
    L37 : Subqueries in SQL- 04:30:16
    L38 : Nth Highest Salary in SQL- 04:45:21
    L39 : Stored Procedure in SQL- 04:52:05
    L40 : Views in SQL- 04:56:36

    • @OfficialTheHotSeat
      @OfficialTheHotSeat 2 месяца назад

      Just a quick question, why so much RAJ? 🤣

    • @Ayush37262
      @Ayush37262 22 дня назад

      ​@@OfficialTheHotSeat Raj Vikramaditya 👀

  • @RitiKumari
    @RitiKumari  7 месяцев назад +81

    Disclaimer : If you feel video is bit fast, you can consider watching it at 0.5x.

  • @harishkanuka
    @harishkanuka 7 месяцев назад +23

    Absolutely loved the video! I'd like to thank you for your detailed explanations. Please include a timelapse. It would be awesome to see a quick overview of the process from start to finish. Keep up the amazing work! 🙌😊

  • @srabanibanerjee1148
    @srabanibanerjee1148 6 месяцев назад +7

    I watched so many videos but ur explaining skill is just awesome.

  • @ArpitKumar-fg4qy
    @ArpitKumar-fg4qy 20 дней назад

    Edkum bdhyia content khi v aisa content nii milega. Har ek topic ko ache sei describe kiya h aapne. Thank u mam ...

  • @aishwaryakashelkar9339
    @aishwaryakashelkar9339 6 месяцев назад +6

    Truly the best content with an amazing mentor. Enjoyed learning from you. Please keep making such videos

  • @xyz-hg3jx
    @xyz-hg3jx 6 месяцев назад +16

    Didi ur this course is awesome literally, mujhe sql aati thi but fir v bore ho rha tha to socha complete dekhu and i have finished it in a single sitting of 5 hours. Amazing hai literally. Hame compiler design ka course chaiye jaldiii se banao plzz.

  • @J_Joel_0549_sdng
    @J_Joel_0549_sdng 3 дня назад

    Finally found a Awesome video for learning SQL ✨. I am from non-technical background, It was very tough for me to find the best videos for learning SQL. I were tried many videos, but no one uploaded the complete course 😞. But now, I landed on a correct place 😊. Thanks for your amazing work 🙏. Keep on doing ❤.

  • @abhishekaggarwal3176
    @abhishekaggarwal3176 3 месяца назад +3

    I am facing many issues in learning SQL as I am from a nontech background. Her teaching skills are so well that every concept is completely clear after watching her video. Thanks for such great content and wish to see more good work from your end in further videos.

  • @mukundumashankar3979
    @mukundumashankar3979 4 месяца назад +1

    These lectures are truly fantastic! The explanations are clear, concise, and well-structured, making even complex concepts easy to understand. I really appreciate how you manage to keep everything short and to the point without sacrificing depth. It’s evident that a lot of thought has gone into presenting the material in a way that’s easy to comprehend, even for beginners. Thanks a lot for putting in the effort to make such high-quality content!

  • @SimpleProgrammer0
    @SimpleProgrammer0 6 месяцев назад +30

    Introduction to the video and course overview 00:00:00
    What is a database 00:01:23
    What is a DBMS 00:03:04
    Why do we need SQL 00:04:00
    Difference between MySQL and SQL 00:04:56
    DUAO me yaad rkhna ❤️❤️
    Types of SQL commands 00:07:31
    Recap: what is SQL 00:10:40
    Types of databases: relational vs non-rel relational 00:12:11
    Creating a database 01:22:22
    Data types in SQL 01:40:44
    Inserting data into a table 02:20:13
    Viewing data in a table 02:53:22
    Creating a view 03:12:44
    Dropping a view 03:50:44

  • @g112pushkarpaul5
    @g112pushkarpaul5 6 месяцев назад +5

    Best SQL tutorial video on internet...

  • @HiteshBaghell
    @HiteshBaghell 6 месяцев назад +3

    Quality content !!
    Thank you for this course ❤

  • @vj270-o6v
    @vj270-o6v 5 месяцев назад +6

    Amazing explanation.
    I recently had an interview for a data analyst intern role and each and every question asked from SQL is mentioned here.

    • @digitalninja12345
      @digitalninja12345 4 месяца назад

      What other stuffs besides SQL were asked sir

    • @Srushti_Mane
      @Srushti_Mane 19 дней назад

      In which company you have given interview?

  • @CoderSineNomine
    @CoderSineNomine 3 месяца назад +1

    Great course, she is a fast talker just suits my taste with amazing content.. loved it.. thx

  • @_SUBHAROOPKABI
    @_SUBHAROOPKABI 23 дня назад

    Very Nice explanation and you covered all the cases in a most systematic manner.......Thank you so much......☺☺

  • @vivekthaakur7711
    @vivekthaakur7711 3 месяца назад

    Hi Riti, You are doing great!! 👍

  • @rupalisrivastava4421
    @rupalisrivastava4421 2 месяца назад

    perfect explanation. Easy to understand the concept . Thanks a lot Riti.

  • @RitiKumari
    @RitiKumari  7 месяцев назад +39

    How was the video?
    Re-uploaded the video again as last video had some quality issues.

    • @Tjr00011
      @Tjr00011 7 месяцев назад +2

      Very useful ma'am.
      Please share your plan for other core concepts ma'am 😢😢... placements are nearing

    • @GopalKumar-xu3iw
      @GopalKumar-xu3iw 7 месяцев назад +2

      But timestamp plz

    • @RitiKumari
      @RitiKumari  7 месяцев назад +1

      @@GopalKumar-xu3iw adding it

    • @Xp-Sam
      @Xp-Sam 6 месяцев назад

      ​@@RitiKumariYeah, waiting

    • @syedowais1906
      @syedowais1906 5 месяцев назад

      useful mam

  • @siddharthasuman4707
    @siddharthasuman4707 3 месяца назад +1

    Completed the video, very helpful. Thank you.

  • @charlestoneoyoo
    @charlestoneoyoo Месяц назад

    Wooow what an impeccable course Riti, hats off🙌...Very clear and detailed course content, explanations and examples. It was an amazing journey learning this from an expert..Keep making the content for data enthusiasts like me! Appreciated!

  • @l.nokesh
    @l.nokesh 6 месяцев назад +2

    Your teaching style is really amazing❤.
    The way you repeat things makes memorize well.
    Please also make a playlist on computer networks.

  • @SachinJadhav-pg4fp
    @SachinJadhav-pg4fp 7 месяцев назад +2

    Amazing teaching style riti 🎉

  • @vishalshrivastava2970
    @vishalshrivastava2970 3 месяца назад +1

    Thank You Riti for this SQL Database video, it's very good deep understanding video which helps alot to me, great explanation in entire video in each topic by you. Thanks for great content, and keep going forward.

  • @gauravsrivastava17
    @gauravsrivastava17 25 дней назад

    Please correct timestamps format in the video description so it will appear as video chapters
    it will be like this
    Timestamp - Chapter Name
    00:00:17 Lets Start with SQL
    00:05:24 What is SQL
    00:08:58 MySQL Installation
    00:13:11 Types of SQL Commands
    00:18:26 Databases and related SQL commands
    00:37:08 Tables and related SQL command
    00:45:33 Building a Database- From Tables to data insertion
    00:53:24 Datatypes in SQL
    01:03:36 Keys in SQL
    01:09:23 Constraints in SQL
    01:24:32 Foreign Key in SQL
    01:37:35 Update Command in SQL
    01:49:55 Delete Command in SQL
    01:53:24 Select Command in SQL
    01:55:29 Where Clause in SQL
    01:58:59 ALTER Command in SQL
    02:09:09 RENAME Command in SQL
    02:13:13 TRUNCATE Command
    02:16:29 Difference between TRUNCATE, DELETE & DROP in SQL
    02:18:31 Distinct Keyword in SQL
    02:23:20 Operators in SQL
    02:39:03 Clauses in SQL
    02:47:50 Aggregate Functions in SQL
    02:57:35 GROUP BY and HAVING clause in SQL
    03:08:45 Difference between HAVING and WHERE clause in SQL
    03:11:26 Practice Question on clause and Aggregate Function in SQL
    03:23:44 General Order of SQL command
    03:25:31 Joins in SQL
    03:31:28 Inner Join in SQL
    03:37:56 Left Outer Join in SQL
    03:41:43 Right Outer Join in SQL
    03:44:34 Full Outer Join in SQL
    03:51:46 Cross Join in SQL
    03:56:54 Self Join in SQL
    04:10:48 Exclusive Joins in SQL
    04:21:16 UNION and UNION ALL in SQL
    04:30:16 Subqueries in SQL
    04:45:21 Nth Highest Salary in SQL
    04:52:05 Stored Procedure in SQL
    04:56:36 Views in SQL
    I have corrected it using gemini you can do the same
    Anyway Thanks for the wonderful video.

  • @taruinfo
    @taruinfo 2 месяца назад

    THANKS RITI, IT WAS REALLY A WONDERFULL EXPERIENCE

  • @ThomasShelby-f1s
    @ThomasShelby-f1s 6 месяцев назад +5

    from following your notes from Linkedin to learning from you itself !! absolutely incredible journey !!! 😀😀

  • @LightYearAway-861
    @LightYearAway-861 3 месяца назад

    Wonderful content, explains everything from basics to advanced.

  • @aayushimj
    @aayushimj 7 месяцев назад +2

    thank you for this video 🚀

  • @12_ankitaarya86
    @12_ankitaarya86 3 месяца назад

    watching your video is really worth it!!

  • @divyanshvashist6970
    @divyanshvashist6970 6 месяцев назад +2

    was going to revise sql for placements,covered almost everything thanks to you

    • @vijaysharan17
      @vijaysharan17 6 месяцев назад +2

      hey im gonna learn sql for the very first time, is this a good vid to start with?

    • @divyanshvashist6970
      @divyanshvashist6970 6 месяцев назад

      ​@@vijaysharan17 Yes

  • @naseersyed6877
    @naseersyed6877 6 месяцев назад

    best explanation on youtube till now👍

  • @Sharuthi727
    @Sharuthi727 3 месяца назад

    Thank you riti , this video is really helpful

  • @deepn7_340
    @deepn7_340 4 месяца назад

    This Very Good Video I see on youtube. You explain every concept well with practice question. You explain join concept very well.

  • @harmeetsingh3310
    @harmeetsingh3310 Месяц назад

    Well explained ... Thanks for the lecture.

  • @sangramsmall
    @sangramsmall 4 месяца назад +1

    dii, mai special aapka video apke fluent english ki wajha se pura ye 5 hours dekha hu , knowledge kahi se bhi mujhe miljata lekin aapne jaise ye itna faraatedar english koi nahi dega mujhe bhaot kuch sikhne ko mila mujhe apse dii thanks dii , or aap kya batasakte hai ki itna fluent english mai kaise bol sakta hu , waise mujhe lagta hai ki aap american ho :)

  • @-NAVEEN_Nani5655
    @-NAVEEN_Nani5655 6 месяцев назад

    Excellent teaching ❤

  • @Namo12_
    @Namo12_ 3 месяца назад

    what a teaching skill you have!! wahhhh.

  • @cricketwithmanas3481
    @cricketwithmanas3481 Месяц назад

    this is one of the best video about SQL Thank you mam.

  • @divoee5623
    @divoee5623 5 месяцев назад +1

    i love your content please continue

  • @DevanshuChauhan-b3o
    @DevanshuChauhan-b3o 6 месяцев назад

    Its an Incredible video I learned a lot from this. thanks!!

  • @chandudhulam3442
    @chandudhulam3442 3 месяца назад

    Just LOVED 💞🥰

  • @surajgoraicse
    @surajgoraicse 2 месяца назад

    Really excited to learn...

  • @bimalchalise1188
    @bimalchalise1188 4 месяца назад +1

    2:20:34 Distinct Command

  • @adarshbhardwaz
    @adarshbhardwaz 3 месяца назад

    very very thanks I have complete this course and good knowledge for practise questions very good knowledge for this complete

  • @BiswajitDas-lk7pp
    @BiswajitDas-lk7pp 6 месяцев назад

    Amazing Explanation 💐

  • @Minni_06
    @Minni_06 6 месяцев назад

    The best video ever
    Started learning and expecting more videos like these❤

    • @RitiKumari
      @RitiKumari  6 месяцев назад +2

      thanks :)

    • @birendramalik5347
      @birendramalik5347 3 месяца назад

      @@RitiKumari didi please give timestamp 🫥🥰🥰

  • @harshkumarvlog456
    @harshkumarvlog456 7 месяцев назад +2

    Thanks for this viedo Very Helpful 😊😊

  • @Pratham_jaiswal
    @Pratham_jaiswal 6 месяцев назад

    Quality on top 🔝 , very good explanation.
    Thanks ❤(subscribed).

  • @POPATCHAVAN-l4x
    @POPATCHAVAN-l4x 5 месяцев назад

    Hi Riti the video does a great job of breaking down complex SQL concepts into easy-to-understand language.

  • @pratik6089
    @pratik6089 Месяц назад

    great explanation. complated in 2 days.

  • @saurabhrathi8519
    @saurabhrathi8519 2 месяца назад

    wonderful explanation thanks.

  • @pshycocoder
    @pshycocoder 6 месяцев назад +10

    please add timestamps mam

  • @shrutithakarey5147
    @shrutithakarey5147 3 месяца назад

    thank you ritu kumari for making this very informational video in very simple language

  • @SivaSiva-p2p4o
    @SivaSiva-p2p4o 7 месяцев назад +8

    please upload Operating System and Computer Network lectures..

  • @CSSowmiyaR
    @CSSowmiyaR 3 месяца назад

    Thank you for sharing this tutorial its very helpful God bless you

  • @mbhupal18
    @mbhupal18 5 месяцев назад

    Very well explained !

  • @amal_ajayakumar
    @amal_ajayakumar 6 месяцев назад

    Great Knowledge.... Keep Sharing Your Knowledge

  • @AmishaMehta-ip1km
    @AmishaMehta-ip1km 6 месяцев назад +1

    your linkedin follower this side..great video

  • @SuryaPrakash-pv7yp
    @SuryaPrakash-pv7yp 6 месяцев назад

    Quality content
    Amazing teaching!!

  • @gogilarasans8655
    @gogilarasans8655 4 месяца назад

    thank you
    thank you so much for this awesome one shot
    really helpful for my pp

  • @mokkshabk2684
    @mokkshabk2684 5 месяцев назад

    Thank you for this video!!!

  • @dharampalkumar6547
    @dharampalkumar6547 5 месяцев назад

    Amazing video ❤❤❤

  • @Omkrishna0131
    @Omkrishna0131 Месяц назад

    Best One shot video for SQL;

  • @sanchay_khatwani
    @sanchay_khatwani 2 месяца назад

    Amazing Lecture mam

  • @preethampoojary4412
    @preethampoojary4412 6 месяцев назад +1

    Thank you mam❤

  • @theg7k
    @theg7k 6 месяцев назад

    Thanks for your efforts @Ritikumari 🤟

  • @prabhatjha8387
    @prabhatjha8387 6 месяцев назад

    In-depth content💥
    I'm really going to share this with my friends ☺️

  • @khempaneru9824
    @khempaneru9824 3 месяца назад

    Thanks for this amazing video

  • @archcreations153
    @archcreations153 2 месяца назад

    much better than some paid courses 😍♥

  • @KunalKapure-v7c
    @KunalKapure-v7c 5 месяцев назад

    Best Comphrehensive video on SQL

  • @priyanshukumarsaw8121
    @priyanshukumarsaw8121 6 месяцев назад

    Awesome Video, well explained!

  • @toancdu
    @toancdu 6 месяцев назад

    Thank you so much for your share from Hanoi, Vietnam

  • @vikashKumar-km2yu
    @vikashKumar-km2yu 6 месяцев назад

    Interesting and unique teaching style 😊😊

    • @RitiKumari
      @RitiKumari  6 месяцев назад +1

      Thanks a lot 😊

  • @creativemind9323
    @creativemind9323 5 месяцев назад

    amazing for beginners.and nice explain

  • @MR-Artist.77777
    @MR-Artist.77777 6 месяцев назад

    This is really helpful for me to prepare for placements...
    Thanks a lot😊😊

  • @syedowais1906
    @syedowais1906 5 месяцев назад

    i saw lots of videos about sql on youtube but i didt get well but your teaching way is good thanks for sharing this video mam

  • @ikitayadav3272
    @ikitayadav3272 5 месяцев назад

    amazing sister....thank you

  • @ALONEEATER
    @ALONEEATER 6 месяцев назад

    Just now came to yt after viewing your post reg small yt channel happiness content you provided is ultimate not only techinal also for interview purpose TQ for your ultimate course ❤

  • @sahillgupta-w2v
    @sahillgupta-w2v Месяц назад

    awesome explanation

  • @codewithved
    @codewithved 6 месяцев назад

    Really great Course , content is explained very well

  • @VishalSingh-mf2zq
    @VishalSingh-mf2zq 5 месяцев назад

    Thanks, ma'am, for this valuable content.

  • @sravanballu513
    @sravanballu513 5 месяцев назад

    very nice explanation and very nice course for SQL

  • @bhattanveer470
    @bhattanveer470 14 дней назад

    I like your videos Riti maam

  • @deepakveluvolu7741
    @deepakveluvolu7741 3 месяца назад

    Thankyou so much Akka!!

  • @YaaOkDone
    @YaaOkDone 6 месяцев назад

    Really the video is amazing , good detailed explanation with workbench .🤗 Thank You!!
    Also make a video on Windows Functions in SQL which is very useful for everyone.😊
    👏👏❣

  • @manasisingh294
    @manasisingh294 6 месяцев назад

    Thank you so much!

  • @pawannishad_929
    @pawannishad_929 6 месяцев назад

    Very Useful ❤

  • @Reality_of_Indian
    @Reality_of_Indian 6 месяцев назад +1

    i got video link in whats'app channel in the early morning and i just open the link to check how this one shot is, i didn't realize when i completed one hrs lecture 😁, now i writing the comment after completed one shot 😁, thank you riti, what a teaching skill u have ..

  • @SaumyaMittal-p4j
    @SaumyaMittal-p4j 7 месяцев назад

    Very useful well done 👍

  • @Me-nh3pt
    @Me-nh3pt 5 месяцев назад +2

    Someone dropped Gold.

    • @RitiKumari
      @RitiKumari  5 месяцев назад +4

      And you acknowledged it, thanks means a lot :)))

  • @chiragkumarchavda8546
    @chiragkumarchavda8546 5 месяцев назад

    Amzning 🤩🥰💖🎉🎉

  • @PrantoBala-d2y
    @PrantoBala-d2y 2 месяца назад

    Make this type of video about System Design ! Love from Bangladesh ❤ !

  • @SONU_RAJ518
    @SONU_RAJ518 5 месяцев назад

    Greatly taught. I loved your explanation, maam, but the timeline in the video helps a lot to watch please use timeline in video

  • @govindraut9737
    @govindraut9737 6 месяцев назад

    Thank you so much

  • @vinamrasangal8436
    @vinamrasangal8436 6 месяцев назад

    it takes much efforts to make such videos

  • @bimalchalise1188
    @bimalchalise1188 4 месяца назад

    4:00:00 Joins

  • @ProgrammingWithRabbani
    @ProgrammingWithRabbani 5 месяцев назад

    thank you didi.

  • @ShourovRoy-pk5zm
    @ShourovRoy-pk5zm 6 месяцев назад

    Thank you dede ❤

  • @buddypranay5394
    @buddypranay5394 6 месяцев назад

    Thank you didi :)