SQL - Complete Course in 3 Hours | SQL One Shot using MySQL
5,642,818
Published 2023-08-18
🔥Delta 3.0(Full Stack Web Development) : www.apnacollege.in/course/delta-batch-3
Early bird offer for first 5000 students only!
International Student (payment link) - buy.stripe.com/7sI00cdru0tg10saEQ
---------------------------------------------------
📌 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/folders/1wfNTKinBAV6CCxaI5l…
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 Vie
All Comments (21)
-
Great Lecture & thank you Shradha Ma'am : ) Some student please share timestamps so that other students can also benefit.
-
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
-
1 hour into the video ! fantastic clear explanation. Probably the best SQL video i've stumbled upon!
-
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
-
Didi we want a full course on Javascript 😊
-
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....
-
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.
-
Like if u r from class 11th IP😅😅😅
-
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.
-
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.
-
@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;
-
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👍
-
SQL matlab structured query language but in my view SQL matlab : --- SHRADHA the QUEEN of all LANGUAGES
-
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
-
आप बहुत अच्छा समझते हो जो शब्दों में बया नहीं हो सकता मैं काफी समय से Sql or MySql में Confuse tha .पर अब मेरे सारे dubt पूरे हो गए हैं
-
Constraints in SQL: १)not null २) unique ३) primary key ४) foreign key ५) default ६) check
-
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.
-
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
-
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.
-
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.
