SQL Tutorial - Full Database Course for Beginners

In this course, we'll be looking at database management basics and SQL using the MySQL RDBMS.

The course is designed for beginners to SQL and database management systems, and will introduce common database management topics.

Throughout the course we'll be looking at various topics including schema design, basic C.R.U.D operations, aggregation, nested queries, joins, keys and much more.

⭐️ Contents ⭐
⌨️ (0:00) Introduction
⌨️ (2:36) What is a Database?
⌨️ (23:10) Tables & Keys
⌨️ (43:31) SQL Basics
⌨️ (52:26) MySQL Windows Installation
⌨️ (1:01:59) MySQL Mac Installation
⌨️ (1:15:49) Creating Tables
⌨️ (1:31:05) Inserting Data
⌨️ (1:38:17) Constraints
⌨️ (1:48:11) Update & Delete
⌨️ (1:56:11) Basic Queries
⌨️ (2:08:37) Company Database Intro
⌨️ (2:14:05) Creating Company Database
⌨️ (2:30:27 ) More Basic Queries
⌨️ (2:26:24) Functions
⌨️ (2:45:13) Wildcards
⌨️ (2:53:53) Union
⌨️ (3:01:36) Joins
⌨️ (3:11:49) Nested Queries
⌨️ (3:21:52) On Delete
⌨️ (3:30:05) Triggers
⌨️ (3:42:12) ER Diagrams Intro
⌨️ (3:55:53) Designing an ER Diagram
⌨️ (4:08:34) Converting ER Diagrams to Schemas

--

[freecodecamp]

Click the "JOIN" button below the video to support freeCodeCamp.org!

[afrozalam]

For me It all started from this 4 hour video. This youtube video changed my life. I had no clue what SQL or what database was. I used to be an accountant and today I work as a database developer. Thank you so much.

To all those people who are trying to change their careers, you can do it!

[meatbucket]

my man sat down for 4 hours and 20 minutes and just talked about databases the whole time, god level

[katbarako]

When my kid went down for her nap today I had no idea what SQL was. By the time she woke up, I knew how to write queries and turn ER diagrams into to database schemas. Thanks, Giraffe man.

[KaTe-bber]

Thanks! Awesome instructor & format! I’m very impressed young man. Keep us the good work.

[ZoldarMusic]

This was the only lesson of SQL I have ever taken and I managed to get a job as a Junior Data analyst! Thanks

[sahilpawarr]

who are these 1k people who disliked this video. The guy is teaching an entire language in 4hrs for free what the heck do you

[noir]

Nearly done learning all the full stack web stuff and I just gotta say...mad respect to this guy. Might not have made it without you.

[jane_emilith]

This course is way better than those I paid for on Udemy. Clear, well-structured and concise. Thank you so much for your hard work, you are a really great teacher! *Followed you on Linkedin*

[haiphan]

This man is going to heaven on a first-class seat.

[lilnasd]

Two weeks ago I started doing this course thinking that it would be useful for my placements and today I'm here to let you know that because of your teaching I actually learnt DBMS and got placed in an MNC .The recruiter asked me about DBMS functions and in particular he asked me about group by function which I otherwise wouldn't have answered . I'm really grateful for you and thank you very much Sir for taking your time to explain DBMS to us.

[prajwaltawade]

Trust me, if you want to start with basics, this is the best tutorial available on the internet, which clears your concepts without wasting much of your time.

-- Five years experienced Data Analyst

[angiemakhubela]

To everyone who does not have the means to go to University or College and are self teaching, keep on going! your efforts will definitely be recognised 🙏🏾

[rs]

4h20m without ads! Humanity still exists.

[allenc]

Hi Mike, I just want to say thank you for providing such a great beginner's course for SQL and DB. I spent the last three weeks studying thoroughly and it's absolutely eye-opening for me. Thanks lot!

[light]

Thank you so much Mike! You are an excellent teacher! I am going to take a data analysis course in college this upcoming semester and I got put in a half semester class and I was very concerned that the pace of the class would be too fast for me. I decided I would try to start learning the material ahead of time so I could keep up and came across your tutorial. You are helping me so much! Much appreciation!

[terrabyte-techy]

Some of this YouTubers really know how to prepare and convey tech materials way better than some lecturers in high-end institutions. Thank you so much for this upload.

[iben]

I like how this guy sits, leans and relaxes like a king

[bjmckenney]

I am thoroughly impressed and refreshed with the flow of this tutorial. With years of managing data and creating minor databases (study as I go), I needed to be updated to search for a part-time job after being retired for 2 years. Thank you

[pirvuadriana-elena]

This guy is hands down the best professor of all time. Even a 5-year-old can understand this thing. :)