OpenTube

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

Apna College

21,896,535 views

Want to study for Tech Placements/Internships from us :
Our Latest Placement Batches : https://linktr.ee/apnacollege.in

Share your progress on Twitter : https://x.com/ShradhaKhapra_
DSA Series full playlist : Complete C++ DSA Course | Data Structures ...

Link for SQL Notes : https://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

20 Comments

@AmanDhattarwal 3 years ago

Great Lecture & thank you Shradha Ma'am : )
Some student please share timestamps so that other students can also benefit.

@brsstatusworldofficial8754 3 years ago

Didi we want a full course on Javascript 😊

@sugandhasethi6885 3 years ago

After watching this video I can add SQL in my resume as technical skills 😁🤪

@abhishekkumar-lu9jd 6 months ago

I bought an online class but didn't understand a single thing.
But your free class clear my all doubts.
Also in Python.

@SAAAAAAAAAAAAAAAAAAAAAAA-ez6hg 2 years ago

1 hour into the video ! fantastic clear explanation. Probably the best SQL video i've stumbled upon!

@Karthik17305 1 year ago

We all the students are very blessed to have the APNA COLEGE like learning platform in YOUTUBE which is free for access to LEARN...

@nupurnishant4197 3 years ago

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.

@DeeUnscripted 5 months ago

IT'S BEEN MY 15 days to 1 month since i enroll in one classes to learn SQL but it all was waste , and then watched you 3 hour class which took me two days but it's was worth it.

@JohnCena-bb7cg 11 months ago

Watching a night before my DBMS VIVA... worth it so much❤❤❤

@aniketkumar9215 3 years ago

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.

@pskroyallife636 3 years ago

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....

@RK_Creations_vlog_reels 2 weeks ago

The most important quality of mam is that a student who has zero knowledge can learn and of course for advanced students can become an expert

@aryanoakshorts 3 years ago

This Chanel is A blessing to all the Cs/It Engineers💯

@srikrishna1981 2 years ago

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

@apka_dost1 1 year ago

College: 3 months 😂
Apna college: 3 hours 🔥

@sayandeb9614 1 month ago (edited)

It's was so easy like water to learn and so informative.. i didn't feel bored at all. Thank you ..

@muhammadarhamshahbaz4805 3 years ago

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❤❤❤.

@kloud-44 3 years ago

Excellent class Shradha, I seriously learned SQL from this video. You made it very crisp and clear. Thanks a lot, Shradha 🙏🙏🙏🙏🙏🙏

@arpitaingermany 3 years ago

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.