SQL Tutorial for Beginners (Complete Course using MySQL)

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 u0026 Auto Increment
02:04:08 Foreign Keys
02:17:58 MySQL Joins
02:28:11 UNION u0026 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 u0026 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 \