Master MySQL in ONE VIDEO: Beginner to Advanced Course For Beginners in Hindi | MPrashant

@MPrashant #mysql #sql #database

🚀 My MySQL PDF notes! 📚

MYSQL FULL COURSE
MYSQL COURSE IN HINDI
MYSQL FOR BEGINNERS
MYSQL Tutorial in Hindi
SQL in Hindi

Want to learn MySQL but don't know where to start? Then this is the video for you! In this beginner to advanced MySQL course, you'll learn everything you need to know to start using MySQL from the ground up.

From beginner basics to more advanced features, this video will teach you everything you need to get started with MySQL. By the end of this course, you'll be able to use MySQL to create, manage, and query databases with ease. So whether you're a beginner or an expert, this video is a great way to get started with MySQL!

Topics and Timeline

00:00 Introduction to MySQL Course
01:06 What is database?
02:23 Database vs DBMS
03:52 What is RDBMS?
05:04 Types of Database in the market
05:29 Why you should learn MySQL?
06:20 SQL vs MySQL
08:00 MySQL Documentation
08:44 MySQL Installation on Windows
14:05 Overview of Workbench
16:17 Listing and Creating a Database
21:00 USE Database
22:24 DROP Database
23:28 How to CREATE a TABLE?
28:44 Describe a Table
29:52 How to Insert Data in MySQL
35:38 Reading Data using SELECT Query
37:40 WHERE Clause with SELECT Query
39:11 Modify data using UPDATE Query
44:25 Delete data using DELETE Query
46:41 DROP Table
47:42 NOT NULL in Column
54:21 Set DEFAULT Values
58:41 What is PRIMARY KEY
01:08:00 AUTO_INCREMENT Values in Column
01:12:23 What is ALIAS
01:13:23 EXERCISE - 1
01:17:38 EXERCISE 1 Solution
01:23:23 Exercise -2
01:25:32 Exercise 2 Solution
01:30:12 String Functions in MySQL
01:32:07 CONCAT Function
01:36:24 CONCAT_WS Function
01:39:32 SUBSTR Function
01:43:55 REPLACE Function
01:48:02 REVERSE Function
01:49:04 UPPER & LOWER Functions
01:51:01 CHAR_LENGTH Function
01:53:31 LEFT RIGHT TRIM
01:58:20 Exercise - 3
02:01:44 Exercise 3 - Solution
02:09:12 Remove Duplicates using DISTINCT
02:11:50 Sorting Data using ORDER BY
02:15:14 LIKE Keyword
02:18:14 LIMIT Keyword
02:21:59 COUNT Function
02:26:49 Exercise - 4
02:29:46 Exercise 4 - Solution
02:34:58 GROUP BY
02:41:25 MAX and MIN Function
02:43:32 How to use SUB QUERIES
02:46:16 SUM and AVG Function
02:50:10 Exercise - 5
02:53:38 Exercise 5 - Solution
02:59:58 DECIMAL Datatype
03:06:21 DOUBLE FLOAT Datatype
03:11:33 DATE TIME and DATETIME Datatype
03:15:40 CURDATE CURTIME and NOW Functions
03:24:48 DATE_FORMAT Function
03:31:53 DATE Maths
03:39:30 DEFAULT and ON UPDATE TIMESTAMP
03:45:25 Exercise - 6
03:47:29 Ex 6 Solution
03:52:51 Relational Operators
03:58:09 Logical Operators
04:04:13 IN and NOT IN Keywords
04:07:30 BETWEEN Keyword
04:10:42 CASE to apply conditions
04:19:19 Exercise - 7
04:21:39 EX 7 Solution
04:29:10 UNIQUE Constraint
04:32:48 CHECK Constraint
04:39:22 ALTER Query to Add or Drop a Column
04:44:16 ALTER Query to Rename a Column
04:47:27 ALTER Query to modify Column Property
04:50:52 Relationship in MySQL
04:52:44 Types of Relationship
05:00:18 FOREIGN KEY in SQL
05:10:21 What are JOINS
05:13:28 CROSS JOIN
05:15:53 INNER JOIN
05:23:56 LEFT & RIGHT JOIN
05:30:32 ON DELETE CASCADE
05:35:51 Exercise - 8
05:39:27 Ex 8 Solution
05:46:14 Many To Many Relationship
05:57:03 VIEW to Create Virtual Tables
06:01:18 HAVING and ROLLUP Clause
06:07:34 What is Stored Routine?
06:09:08 Stored Procedure in MySQL
06:17:56 Argument Passing in Stored Procedure
06:23:54 Return Output in variable in Stored Procedure
06:30:52 USER DEFINED Function
06:40:46 WINDOW Function

MySQL tutorial in Hindi
Learn MySQL in Hindi
MySQL for beginners Hindi
Advanced MySQL Hindi
MySQL database course Hindi
MySQL programming in Hindi
MySQL training videos Hindi
Hindi MySQL lessons
MySQL full course in Hindi
MySQL in Hindi for beginners
MySQL database tutorial Hindi
Hindi MySQL database guide
SQL in Hindi
MySQL query tutorial Hindi
MySQL video series Hindi
MySQL basics in Hindi
MySQL advanced concepts Hindi
MySQL Hindi lectures
MySQL practical tutorial Hindi
MySQL Hindi tutorial for beginners
MySQL step by step tutorial Hindi
Complete MySQL guide in Hindi
SQL database course in Hindi
MySQL hands-on training Hindi
MySQL Hindi explanation

sql for beginners,SQL Full Course in Hindi,sql basics for beginners,sql tutorial for beginners,learn sql for beginners,free sql course,sql crash course,sql full course,sql tutorial for beginners in hindi,sql in hindi,sql server full course,sql learning for beginners,how to learn sql for beginners,sql beginners,sql programming for beginners,sql queries,learn sql in 1 hour,how to learn sql,learn sql,what is sql,sql course in hindi,sql interview

[MPrashantTech]

🚀 My MySQL PDF notes! 📚


This notes will be useful to quickly revise all the MySQL concepts, you can also use it for learning purpose so you can save your time for making notes. (no interview qna, no usecase)

[krunaldhavle]

00:00 Introduction to MySQL Course
01:06 What is database?
02:23 Database vs DBMS
03:52 What is RDBMS?
05:04 Types of Database in the market
05:29 Why you should learn MySQL?
06:20 SQL vs MySQL
08:00 MySQL Documentation
08:44 MySQL Installation on Windows
14:05 Overview of Workbench
16:17 Listing and Creating a Database
21:00 USE Database
22:24 DROP Database
23:28 How to CREATE a TABLE?
28:44 Describe a Table
29:52 How to Insert Data in MySQL
35:38 Reading Data using SELECT Query
37:40 WHERE Clause with SELECT Query
39:11 Modify data using UPDATE Query
44:25 Delete data using DELETE Query
46:41 DROP Table
47:42 NOT NULL in Column
54:21 Set DEFAULT Values
58:41 What is PRIMARY KEY
01:08:00 AUTO_INCREMENT Values in Column
01:12:23 What is ALIAS
01:13:23 EXERCISE - 1
01:17:38 EXERCISE 1 Solution
01:23:23 Exercise -2
01:25:32 Exercise 2 Solution
01:30:12 String Functions in MySQL
01:32:07 CONCAT Function
01:36:24 CONCAT_WS Function
01:39:32 SUBSTR Function
01:43:55 REPLACE Function
01:48:02 REVERSE Function
01:49:04 UPPER & LOWER Functions
01:51:01 CHAR_LENGTH Function
01:53:31 LEFT RIGHT TRIM
01:58:20 Exercise - 3
02:01:44 Exercise 3 - Solution
02:09:12 Remove Duplicates using DISTINCT
02:11:50 Sorting Data using ORDER BY
02:15:14 LIKE Keyword
02:18:14 LIMIT Keyword
02:21:59 COUNT Function
02:26:49 Exercise - 4
02:29:46 Exercise 4 - Solution
02:34:58 GROUP BY
02:41:25 MAX and MIN Function
02:43:32 How to use SUB QUERIES
02:46:16 SUM and AVG Function
02:50:10 Exercise - 5
02:53:38 Exercise 5 - Solution
02:59:58 DECIMAL Datatype
03:06:21 DOUBLE FLOAT Datatype
03:11:33 DATE TIME and DATETIME Datatype
03:15:40 CURDATE CURTIME and NOW Functions
03:24:48 DATE_FORMAT Function
03:31:53 DATE Maths
03:39:30 DEFAULT and ON UPDATE TIMESTAMP
03:45:25 Exercise - 6
03:47:29 Ex 6 Solution
03:52:51 Relational Operators
03:58:09 Logical Operators
04:04:13 IN and NOT IN Keywords
04:07:30 BETWEEN Keyword
04:10:42 CASE to apply conditions
04:19:19 Exercise - 7
04:21:39 EX 7 Solution
04:29:10 UNIQUE Constraint
04:32:48 CHECK Constraint
04:39:22 ALTER Query to Add or Drop a Column
04:44:16 ALTER Query to Rename a Column
04:47:27 ALTER Query to modify Column Property
04:50:52 Relationship in MySQL
04:52:44 Types of Relationship
05:00:18 FOREIGN KEY in SQL
05:10:21 What are JOINS
05:13:28 CROSS JOIN
05:15:53 INNER JOIN
05:23:56 LEFT & RIGHT JOIN
05:30:32 ON DELETE CASCADE
05:35:51 Exercise - 8
05:39:27 Ex 8 Solution
05:46:14 Many To Many Relationship
05:57:03 VIEW to Create Virtual Tables
06:01:18 HAVING and ROLLUP Clause
06:07:34 What is Stored Routine?
06:09:08 Stored Procedure in MySQL
06:17:56 Argument Passing in Stored Procedure
06:23:54 Return Output in variable in Stored Procedure
06:30:52 USER DEFINED Function
06:40:46 WINDOW Function

[Abhaykumar-lwnr]

there are many videos on youtube related to sql but not good explaination. prashant sir, , this videos is amazing for all category student like beginner, partial etc. even you cover all the topic related sql ..thats amazing effort .thankyou sir, for providing such videos free of cost. its really helpful for poor student .even sbko hi benefit h easy to uunderstand h ...

[kkahandal]

Best SQL video with excellent and simple examples.

[varinderpalsingh]

Tusi great o Sir ji, Apne bash, Python aur ab MySQL bhi sikha you so much

[whitehillclassical]

Superb sir, expecting videos on SQL server and how actually a problem queried to get solution in industry .

[rajesh-devops]

Prashant bhai, you are doing awesome job by posting so many videos to the community, i pray to god to give you more energy so that you can keep delivering such lovely content

[hansaltamrakar]

I have completed complete Video At last, Thank You so much Sir Easy to Understand and beginner's level to advance

[abhishekchaudhary]

"Wow, this MySQL course has been a game-changer for me! The instructor breaks down complex database concepts into easy-to-understand lessons, making it perfect for beginners like me. I've learned how to create databases, write efficient queries, and optimize database performance. The hands-on examples really helped solidify my understanding. Highly recommend this course to anyone looking to master MySQL and enhance their database management skills!"❤❤❤❤❤❤❤❤❤❤

[chanchalgupta]

Alias(1:12:28) - we can change the column name but temporary not permanent, that's why we use alter command.

[gautamraj]

Big thanks for your fantastic SQL tutorials! Your teaching style is top-notch. could you provide notes to complement the learning experience.

[yash]

Great video bro keep posting these long format videos on this channel too. U are the best especially the ease of how u explain these complex topics.

[collegematerial]

2:09:09 jaise ki question diya tha aap ne ush pure table ko display kar ne ke liye to bahut kam bhi query likh ne pade ge.
Ye chal nahi rahe
Select *concat(left(dept, 1), emp_id) from employees.
Aur ye chal rahe hai par ish me name aur id aaye ga jo aap ne bata ye agar aur display kar na hai to likh na pade ga?

[AnkitKumarShah-kc]

That's call the Depth Knowladge sir.

[lakshayvinayak]

one stop solution to learn mysql you got a new subscriber

[shashankau]

best course to crack sql interview, thanks brother

[thesoftwareguy]

Hats off To You have provided this MySQL course in such easy to understandable way.
Thankyou So Much !!
Keep Growing!!😄😄

[ashishtrivedi]

One of the best course of sql on the youtube.
Thanks a lot, your lectures help me to understand sql.
Please also provide us the slides it help us a lot.
Keep it up👍👍

[mahimathakur]

Aap bahut hi honestly or ache se padhate h please be regular....keep it up!

[yuktapatil]

I COMPLETED THIS ENTIRE VIDEO IN ONE SITTING AND THIS IS ONLY BECAUSE OF THE WAY YOU HAVE TAUGHT EVERY TOPIC ! SUCH A GREAT HELP!!!!