🚀 My MySQL PDF notes! 📚 Get yours at a special price of 39/- only! 🔥 👉 rzp.io/l/CDuN4OC 💡 After payment, notes will be automatically downloaded, I will also send notes via email, in case of any query you can send us email on mprashant.ofcl@gmail.com 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)
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
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 ...
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
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
"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!"❤❤❤❤❤❤❤❤❤❤
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?
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👍👍
Sir, You deserves atleast million of subscriber because of your teaching style, you will go very far. Advice, Represent your content like this everytime simple, detailed and also upload your video in 2 different languages hindi for Indians and in English for the Globe. Thanks for quality content.
Randomly i found this video & For the past 10 days, I have been watching a video on SQL that has helped me understand the concepts clearly. . Thanks a lot, Prashant Bhai keep doing good work. The way you explain things from the basics is very impressive. Also, I have a request. Could you please upload basic to advanced Python courses in Hindi? If possible, that would be great.
"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!"❤❤❤❤❤❤❤❤❤❤ you best teacher for the mysql 9 Reply
Amazing 🤩 This SQL tutorial is fantastic! It's clear and easy to follow. Can you share the notes or PowerPoint slides? It would really help us learn better. Thanks a lot!
Sir pls Python, Excel, and PowerBI/Tableu course pe bhi aisa hi amazing lecture provide kar dijiye. Apka padaya hua bohot acche se samjh aarha hai. Thanks a lot sir ji. 😁👍🏻
Prashant Bhai bahut accha video tha ,abh ek or request h please notes bhi de digiye oonsare commands ke jika jo iss video main cover hue h taki baad me quick revision kar saken
After long search, finally i found best tutor and the main thg is i can see the screen absolutely dam clear ❤ very happy for this course lesson. Love u sir 💓
Prashant Bro, You have made a very well explained video from beginner to advance level of my sql, U have Covered each & every concept in a very systematic manner. Great job bro💯🤘
hi prashant bhaiya , i'll be happy if you are reading this . i am viresh currently doing my BTECH IN AI from pune. i am following you since my first year second semester , I learned everything from you including linux CLI , shell scripting , PYTHON , GITHUB , currently learning this . i watched your video first time on the linux ssh , after that I got curious in linux , I changed my os to ubuntu 22.04 , i watch your videos on regular basis in it was very fun for me , doing simple task via commands , it looks cool , i watched majority of videos on linux by you . yesterday i got a internship in a company named datasmith based in pune , according to me you are the reason behind it , thank you so much bhaiya .
Hi Viresh! It’s wonderful to hear from you, and I'm thrilled to know that my videos have been a part of your journey in tech. Congratulations on your internship at Datasmith! That’s a fantastic achievement. Keep exploring and pushing the boundaries!! Keep watching and keep learning! 😊👍
1. full join,natural join,self join nhi padaya 2. subquery is very important wo bhi halke mei padake nikal diya 3. set operator(many more operator) not though 4. normalization 5. DCL,TCL 6. SQL injection and some more important topic missed agar ye sab topic hota toh ek number video hota😔 but by the way nice video
In the example of right join, why shyam's entry is there? Because according to right join, we take all the row from order table and from customer table, we only take matching row. But there is no any match or connectivity between both of the table(I am talking about shyam's entry). Please clear the doubt.
Right join means, all entries from right table right I have used Select * from Orders RIGHT JOIN Customers; Here right table is customers that's why Shyam entry was there..
1:06:46 deafult value to set kar skate hai hai name me id nahi set hoge kyo ki ye primary key hai meri to set ho gye maine execute bhi kare query. Create table student ( Id int primary key, Name varchar(89) not null default "abc") ; anyone please clear this doubt
thank you so much sir , really appreciate it you lecture is easy to understand easy explanation with example you are really underrated gem . i hope you will keep upload further more lecture on another topics that are currently using in tech industries.
Thank you, sir, great video. Everything is crystal clear about SQL. Sir one request kya aap Excel, Payton jaise our bhi courses le sakte hai utube pe like SQL issase kafi help hogi. Thank you so much sir
🚀 My MySQL PDF notes! 📚
Get yours at a special price of 39/- only! 🔥 👉 rzp.io/l/CDuN4OC 💡
After payment, notes will be automatically downloaded, I will also send notes via email, in case of any query you can send us email on mprashant.ofcl@gmail.com
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)
I paid for notes how can I get this?
Hi i bought this course, how do i get this
Have you got this notes @@nk-mh7lp
@@pritigarg3315 have you got any notes on this
I paid how to get notes
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
Tusi great o Sir ji , Apne bash, Python aur ab MySQL bhi sikha di............Thank you so much
Awesome! Keep Learning Keep Growing!
Python scripting he kya Sir ke channel me
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 ...
Thanks for the detailed feedback and glad it helped :)
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
Thanks a ton! I will keep trying to bring more valuable content
I have completed complete Video At last ,Thank You so much Sir Easy to Understand and beginner's level to advance
Thanks for the feedback!!
Superb sir, expecting videos on SQL server and how actually a problem queried to get solution in industry .
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
👏
Thanks buddy 🤝
Kitne din me video khatam kiye the?
Best SQL video with excellent and simple examples.
Glad it was helpful!
"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!"❤❤❤❤❤❤❤❤❤❤
Glad it was helpful! and Appreciate your detailed feedback about this course.
4:29:00
select fname, salary, (salary / 80) as 'Salary in Dollars' from EMP;
Big thanks for your fantastic SQL tutorials! Your teaching style is top-notch. could you provide notes to complement the learning experience.
Thanks for sharing the feedback!!
Regarding the notes, I just had PPT which I have shared.
Best practice is to maintain your own notes in your own way.. All the best
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.
Appreciate your feedback and thanks😀
Aap bahut hi honestly or ache se padhate h please be regular....keep it up!
Thanks for the feedback! I will try :)
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?
best course to crack sql interview, thanks brother
Glad you think so!
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👍👍
Thanks for sharing the feedback!!
Link for slides, you can find in pinned comment.
Sir, You deserves atleast million of subscriber because of your teaching style,
you will go very far.
Advice, Represent your content like this everytime simple, detailed and also upload your video in 2 different languages hindi for Indians and in English for the Globe.
Thanks for quality content.
Thanks for your kind words and wishes.
Appreciate your feedback :)
BEST TEACHER FOR THE SQL AND MYSQL IN RUclips
Glad you think so!!
be regular ...
@@arupde6320 😭
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!!!!
Thanks for the detailed feedback!!
Slow and study and win the race...........slow and clean explanation ...wonderful sir....loved it
Glad you liked it!! Keep Growing
Best MySql video i ever seen on youtube.
All the best!
Saandaar course ❤❤🎉🎉 bs itna aur bta do ki placement ke liye ho jayegi enough ye video please btao 🎉🎉
Thanks! more than enough for placement preparation.
But for the more exp role, you may add a project based on sql.
Great. One of the best tutorial ever I luckily got chance to see & learn my SQL so easily. Thank you very much.
You're very welcome!
Hats off To You Sir!!!.....You have provided this MySQL course in such easy to understandable way.
Thankyou So Much !!
Keep Growing!!😄😄
Thanks a ton!
1:41:15 select substring("hey buddy",5,5) ;
answer is buddy
Randomly i found this video & For the past 10 days, I have been watching a video on SQL that has helped me understand the concepts clearly. . Thanks a lot, Prashant Bhai keep doing good work. The way you explain things from the basics is very impressive. Also, I have a request. Could you please upload basic to advanced Python courses in Hindi? If possible, that would be great.
Appreciate your detailed feedback and glad it helped.
I have a python detailed video of 5 hours on another channel @mprashant
Video link - ruclips.net/video/-hh6raHUUvk/видео.html
@@MPrashantTech Thanks will check out this video 👍
"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!"❤❤❤❤❤❤❤❤❤❤
you best teacher for the mysql
9
Reply
Appreciate your detailed feedback!!
Happy Learning!
COMPLETED TODAY😍😍
Bhai kitna din laga 😅
Good Job!
Take your own time but understand the topics deeply :)
What is there in paid notes?
@@MPrashantTech this is complete course ????
Uff! Finally, I have completed this amazing course
Great job!
One of the best SQL tutorial clear explanation 🎉 easy to understand ❤ Not boring our vidio 😅 I am just 13hours sql learning our vidio 🥳
Appreciate your feedback!
Best sql video sir.. bhot maza aa rha exercise bhut acche hai
Watched 3 hr
Keep going, All the best
Amazing 🤩 This SQL tutorial is fantastic! It's clear and easy to follow. Can you share the notes or PowerPoint slides? It would really help us learn better. Thanks a lot!
You can find in pinned comments and thanks for the feedback
Sir pls Python, Excel, and PowerBI/Tableu course pe bhi aisa hi amazing lecture provide kar dijiye. Apka padaya hua bohot acche se samjh aarha hai. Thanks a lot sir ji. 😁👍🏻
Thanks for the feedback!!
Full Python course - Python - ruclips.net/video/-hh6raHUUvk/видео.html
31/01/2025 today is my third day and finally
Completed 🎉thanks you soo much sir 😊
Good job!! All the best
This course deserves millions of views 🎉
Glad you think so :))
0:00 Introduction to MySql Course
thank you for this course
this is the best and easiest course...
Glad to hear that.
best mysql cours in youtube...
greatest contribution in regional language,very highly apprciated
Thanks for the feedback!!!
Prashant Bhai bahut accha video tha ,abh ek or request h please notes bhi de digiye oonsare commands ke jika jo iss video main cover hue h taki baad me quick revision kar saken
Thanks!
I have just created PPT with all the examples and queries used.
you can find ppt link in pinned comment. :)
@@MPrashantTech bhai pinned comment nahi show hora aapke video main
Day -3 , exercise 3 was seens hard at one glance but you explained it so easily i dammm you are awesome brother 🔥🤯
Keep it UP!!
After long search, finally i found best tutor and the main thg is i can see the screen absolutely dam clear ❤ very happy for this course lesson. Love u sir 💓
Glad to hear that!!!
Prashant Bro, You have made a very well explained video from beginner to advance level of my sql, U have Covered each & every concept in a very systematic manner. Great job bro💯🤘
Thanks for the feedback!!
Great ho sir aap . 20 din lge complete krne me but sab samjh me aagya . Thank you sir
Awesome!!
thanks for your one shot much helpful foe my practical paper ,hats off to u bhaiya thanks onve again
Welcome :)
Great sir your videos is strongly knowledgeable and understandable ,plz sir making videos on data science
I will try my best
I have gone through the course and came here to Thank you sir
All the best
Sir, this lecture is on a completely next level. Could you make a video on MongoDB?🙏
Great suggestion, I will try one soon.
Nice lecture ,clears every concept with ease and simplicity
Thanks for liking
hi prashant bhaiya , i'll be happy if you are reading this .
i am viresh currently doing my BTECH IN AI from pune. i am following you since my first year second semester , I learned everything from you including
linux CLI , shell scripting , PYTHON , GITHUB , currently learning this .
i watched your video first time on the linux ssh , after that I got curious in linux , I changed my os to ubuntu 22.04 , i watch your videos on regular basis
in it was very fun for me , doing simple task via commands , it looks cool , i watched majority of videos on linux by you .
yesterday i got a internship in a company named datasmith based in pune , according to me you are the reason behind it , thank you so much bhaiya .
Hi Viresh! It’s wonderful to hear from you, and I'm thrilled to know that my videos have been a part of your journey in tech.
Congratulations on your internship at Datasmith! That’s a fantastic achievement.
Keep exploring and pushing the boundaries!! Keep watching and keep learning! 😊👍
It's good for beginners🎉🎉🎉🎉🎉🎉
Thanks for the feedback!!
1. full join,natural join,self join nhi padaya
2. subquery is very important wo bhi halke mei padake nikal diya
3. set operator(many more operator) not though
4. normalization
5. DCL,TCL
6. SQL injection
and some more important topic missed
agar ye sab topic hota toh ek number video hota😔 but by the way nice video
Appreciate your feedback!
In the example of right join, why shyam's entry is there?
Because according to right join, we take all the row from order table and from customer table, we only take matching row.
But there is no any match or connectivity between both of the table(I am talking about shyam's entry).
Please clear the doubt.
Right join means, all entries from right table right
I have used
Select * from Orders RIGHT JOIN Customers;
Here right table is customers that's why Shyam entry was there..
it's a great video for freshers
One request to you sir please can we get notes of this videos
That will very handy and very helpful for us
Thanks for sharing feedback!!
For notes, I only have PPT Slides :) Link attached in description.
@a.b.x.543 Link for the Notes/Slides of this Video - drive.google.com/file/d/1HO1fxqH4VTBruhc2Scc18OPoo0ERv0q0/view?usp=sharing
Nice explanation sir
Upload more course , Like python ,java and more
thank a lotttttttttttttttttttttttttt brother apke ke wajah se ye itna assan lag raha hai❤♥
Glad to hear that, keep sharing!
thankyou sir maza aa lecture dekh k 🤩🤩
Thanks for the feedback!
You've explained it a whole lot better than any other RUclipsr out there.❤
Glad you think so!!
Marked for Revision 05:10:22
Great learning 👍
Please also upload oracle database
Will try
pranshant bhai,you are so doing awesome job please post so many videos any more technology java,spring,angular
I will try my best
1:06:46 deafult value to set kar skate hai hai name me id nahi set hoge kyo ki ye primary key hai meri to set ho gye maine execute bhi kare query.
Create table student (
Id int primary key,
Name varchar(89) not null default "abc") ; anyone please clear this doubt
Link for the Notes/Slides of this Video - drive.google.com/file/d/1HO1fxqH4VTBruhc2Scc18OPoo0ERv0q0/view?usp=sharing
Thanks Sir 😇
You should Pin This
thank you so much sir ..its a great content i have ever seen
Thank you Prashant Da.... !!!
Welcome bro!!
Thanks for the effort and quality content. Just wanted to know more
about interval keyword.
Glad you liked the video.
Can't thankyou enough...This the perfect one shot one can ask for that is not only ddealing with basic but with advance concepts!!Thankyou Sir
Glad to hear that!
Watching now this course. Best of best course......
Great to hear!
Sir your teaching style is very easy to understand
Thanks and welcome!!
BEST SQL tutorial with so much efforts! Hats off
Thanks a lot!
@@MPrashantTech can you guide as well for management related placement queries?
Completed the whole lecture, best video on SQL. Great Work Prashant Bhaiya❤😍
Glad you liked it!
thankyou it starts from begginer level it is easy to learn
Thanks for the feedback!!
Sir, I want to learn SQL full course. Will this video will fulfill my learning of SQL Full course? Please guide 🙏🏻
Yes, definitely
Hi Prashant i am really good to see your video very informative.
Glad to hear that!!
Brother thanks a lot for this video. Brother one request please adds ko 30-30 minutes ke gap par kar do. Please. Thanks again ❤❤
Appreciate your feedback!!
I recommend ever fresher to go through this series ❤❤❤
thank you so much sir , really appreciate it you lecture is easy to understand easy explanation with example you are really underrated gem . i hope you will keep upload further more lecture on another topics that are currently using in tech industries.
Glad to hear that!!
Bhut hi ache se apne explain kiya ❤
:)
THANK YOU, PRASHANT THAT IS A GREAT SQL SERIES , CAN YOU PLEASE CREATE SOME MORE INTERVIEW SQL QUESTIONS?
Sure soon
Thank you, sir, great video. Everything is crystal clear about SQL. Sir one request kya aap Excel, Payton jaise our bhi courses le sakte hai utube pe like SQL issase kafi help hogi. Thank you so much sir
Python - ruclips.net/video/-hh6raHUUvk/видео.html
Will try on others.
Will this course prepare me for Data Analytics / Data science interviews?
Really good to master the fundamentals which is core for Data analytics, this is good to start your journey
thank you sir your video is very helpful for fresher
Most welcome!
Sir should i watch video or ur playlist. Which one is better ?
both is same, i have added all videos from playlist into single video
although playlist is easy to follow
Hey, just started it and enjoying
Can you please clear one thing
40:40 - how did you add the contact column in the table. Please reply asap
ALTER TABLE students
ADD COLUMN contact INT NOT NULL DEFAULT 0
you are really amazing speaker, every basic dauts are clear thank you so much
You are most welcome
That's call the Depth Knowladge sir.
Thank you man.. Thank you so much for this excellent cource. I completed this entire cource and it's been incredibly helpful for me.
Glad it helped! Most welcome!!
Mr .Prashant SIR, u r genious,these all videos helped me alot ,CRYSTAL CLEAR EXPLANATION OF EVERY CONCEPT WITH PERFECT EASY WORDS
It's my pleasure!! :)
Kindly make a detailed Course on PostgreSQL 🔥
Will try for sure.
@@MPrashantTech thanks sir ❤️
great learning experience
Thanks for sharing!
Thanks Prashant bro 👍
Welcome 🤗
Mja aa gya😍
Thank you!!
Sir Video was awesome.One of the best so far on the internet.Sir can we get the ppt which is shown in the video.
Glad to hear that. you can find ppt link in Pinned Comment :)
Thank You SIR For This Awesome SQL Course
i dont know how to say thank u . your this mysql vdo lot of hlep me during my collage campus time.
Glad to hear that!!
Best for learning 👍
Glad you think so!
Sir you are creating very valueable conten it's very helpful so give me a faver creat a dedicated video on grafana monitring tool
Will try buddy and thanks for the feedback!
Amazing My SQL language video very good explanation style.
Thank you for making such videos
Thanks for the feedback!!
Great Tutorial Thanks Prashant Ji
Thanks for liking