CodeWithHarry via YouTube Free video
Learn complete MySQL in one shot using this full course in 4 hours.
Data Science Course discount Link: https://rzp.io/rzp/x7rNQT6g
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
Download the PDF Handbook: https://www.codewithharry.com/notes/
Blog with Source Code: https://www.codewithharry.com/blogpost/the-ultimate-sql-course
Download the Code: https://drive.google.com/file/d/108BIL73l-tz-bGZbccjg5pSoD1AVhmCW/view?usp=sharing
⌚ Timestamps
00:00:00 Introduction
00:02:43 What is a Database?
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
Latest Udemy Web dev Course With Certificate: https://goharry.in/webdev
➡️ 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…
Some points apply to every course of this kind; see how we rank.
CodeWithHarry is in Tier 3: good universities, respected companies, nonprofits and well-known teachers of our institution ranking (74/100). Hindi, beginner-friendly.
MIT 18.650 Statistics for Applications, Fall 2016 View the complete course: http://ocw.mit.edu/18-650F16 Instructor: Philippe Rigollet This course offers an in-depth the theoretical foundations for statistical methods that are useful in many applications. The goal is to understand the role of mathe…
A curated collection of videos featuring top experts in artificial intelligence.
-Learn more and enroll in the program: https://online.stanford.edu/programs/generative-ai-technology-business-and-society-program Recent advancements in generative AI are reshaping industries, pushing technological boundaries, and revolutionizing creative processes. In this fast-changing landscape…
For more information about Stanford's Artificial Intelligence programs visit: https://stanford.io/ai Delve into the exciting world of Artificial Intelligence with insights and research from the world's top experts. This playlist offers a comprehensive journey, from foundational machine learning con…
Led by Andrew Ng, this course provides a broad introduction to machine learning and statistical pattern recognition. Topics include: supervised learning (generative/discriminative learning, parametric/non-parametric learning, neural networks, support vector machines); unsupervised learning (cluster…
View the complete course: http://ocw.mit.edu/6-034F10 Instructor: Patrick Winston In these lectures, Prof. Patrick Winston introduces the 6.034 material from a conceptual, big-picture perspective. Topics include reasoning, search, constraints, learning, representations, architectures, and probabili…
