CodeWithHarry
Learn complete MySQL in one shot using this full course in 4 hours. This is a free tutorial with no ads for an enhanced experience Enroll in the Data Science Course: https://www.codewithharry.com/courses/the-ultimate-job-ready-data-science-course Data Science Course (International Students): https://buy.stripe.com/9B65kF3790jS2kCeiZ1gs04 Blog with Source Code: https://www.codewithharry.com/blogpost/the-ultimate-sql-course Download the PDF Handbook & Code: https://drive.google.com/file/d/108BIL73l-tz-bGZbccjg5pSoD1AVhmCW/view?usp=sharing Download the PDF Handbook & Code (Mirror): https://drive.google.com/file/d/1TFWujyCNSXA4oRNf9SFuIIcGOwxf4vF1/view?usp=sharing Download the PDF Handbook & Code: https://drive.google.com/file/d/1U15gFATAQPTYsmy63_nSbhEhv5vvcqKj/view?usp=sharing ⌚ Timestamps 00:00:00 Introduction 00:09:51 Windows Installation 00:11:46 Linux Installation 00:14:29 Mac OS Installation 00:23:18 Creating a Table 00:29:17 Dropping the Database 00:30:00 Writing and Saving our SQL Script 00:32:45 Datatypes and Constraints in MySQL 00:37:50 Selecting Data From Table 00:40:25 Altering a Table 00:48:29 Inserting Data 00:57:38 Using Starter SQL 01:00:15 Querying Data 01:11:28 Updating the Data 01:18:06 Deleting Data 01:24:17 Constraints in Detail 01:35:20 Functions in MySQL 01:48:24 Auto Commit and Transactions 01:57:59 Primary Key & Auto Increment 02:04:08 Foreign Keys 02:17:58 MySQL Joins 02:28:11 UNION & UNION ALL in MySQL 02:38:32 Self Joins in MySQL 02:47:32 Views in MySQL 02:57:12 MySQL Indexes 03:06:53 Subqueries in MySQL 03:13:56 GROUP BY & HAVING in MySQL 03:23:59 Stored Procedures in MySQL 03:35:46 Triggers in MySQL 03:46:43 More on MySQL ➡️ Download Notes and CheatSheets: https://www.codewithharry.com/notes/ ➡️ Udemy Python Course: https://goharry.in/python ➡️ Checkout Data Science The Ultimate Job Ready Data Science Course: https://www.codewithharry.com/courses/the-ultimate-job-ready-data-science-course ➡️ Data Science (International Students): https://buy.stripe.com/9B65kF3790jS2kCeiZ1gs04 ➡️ Career Advice: If you are into college and C/C++/Java is being taught, please continue with it. Here are my respective videos/playlists: Learn C Programming: https://www.youtube.com/watch?v=aZb0iu4uGwA Learn C++ Programming: https://www.youtube.com/playlist?list=PLu0W_9lII9agpFUAlPFe_VNSlXW5uE0YL Learn Java Programming: https://www.youtube.com/playlist?list=PLu0W_9lII9agS67Uits0UnJyrYiXhDS6q But if you are not in college and want to learn programming, then I would suggest you to start with Python. Also if you are a beginner and want to learn programming, start with Python. It is beginner-friendly and has a large community for support and a lot of jobs. If you're serious start with my Udemy course in English. Its updated + has a lot of projects. Here is the discounted link which will get you this course for less than ₹400-500. I request you to leave a review if you have enrolled: Udemy Course: https://goharry.in/python After you finish this course, you can start with Data Science. It is a very profitable field to get into and has a lot of job opportunities. You can learn Data Science through my "Ultimate Job Ready Data Science Course". It is a complete course that covers everything you need to know to get a job in Data Science. Here is the discounted link to the course that will get you this course for ₹2899: Data Science Course: https://www.codewithharry.com/courses/the-ultimate-job-ready-data-science-course If you are looking for free resources to learn Python, you can start with my Python Course on YouTube. It is a complete course that covers everything you need to know to become a Python developer. Its Free and you can access it here: 10 Hour Long Python Course (VS Code): https://www.youtube.com/watch?v=UrsmFxEIp5k 100 Days of Code Playlist that uses Replit: https://www.youtube.com/playlist?list=PLu0W_9lII9agwh1XjRt242xIpHhPT2llg If you want to learn web development, you can start with my Sigma Web Development Course. It is a complete course that covers everything you need to know to become a web developer. Its Free and you can access it here: Web Development Course: https://www.youtube.com/playlist?list=PLu0W_9lII9agq5TrH9XLIKQvv0iaF2X3w ➡️ Hosting If you want to host a website on a VPS and get $200 in credits, use my DigitalOcean Link Get Free 200$ DigitalOcean Credits here: https://m.do.co/c/2f2aa100b7ee ➡️ Follow Me On Social Media ► Website (Created Using Next.js): https://www.codewithharry.com ► Facebook: https://www.facebook.com/CodeWithHarry ► Instagram: https://www.instagram.com/CodeWithHarry/ ► Twitter: https://twitter.com/CodeWithHarry ► English channel: https://www.youtube.com/channel/UC7btqG2Ww0_2LwuQxpvo2HQ Comment "#HarryBhai" if you read this 😉😉
Complete understanding of the topic
Hands-on practical knowledge
Real-world examples and use cases
Industry best practices
Take your learning to the next level with premium features