ImmersiveAmbientModecolor: #f0ddd6 (color 2)
Video Format : 22 (720p) openh264 ( https://github.com/cisco/openh264) mp4a.40.2 | 44100Hz
Audio Format: Opus - Normalized audio
PokeTubeEncryptID: f6a762b35a5e9444b214b6097e961d72645cba791667b3336da660b56140f32fcef9e0119cd2de628bcb07960faf1114
Proxy : usa-proxy.poketube.fun - refresh the page to change the proxy location
Date : 1714652185742 - unknown on Apple WebKit
Mystery text : N1NfdHoxel81YkEgaSAgbG92ICB1IHVzYS1wcm94eS5wb2tldHViZS5mdW4=
143 : true
11,245,385 Views β’ Mar 19, 2019 β’ Click to toggle off description
π Want a complete MySQL deep dive?
- Check out my full course: bit.ly/2uAoPM3
- Subscribe for more awesome content: goo.gl/6PYaGF
β Want more? Follow me on:
- Twitter: twitter.com/moshhamedani
- Facebook: www.facebook.com/programmingwithmosh/
- Instagram: www.instagram.com/codewithmosh.official/
- LinkedIn: www.linkedin.com/school/codewithmosh/
π Get the FREE goodies:
- SQL cheat sheet: bit.ly/2JCO73l
- Scripts to create databases: bit.ly/3rvtqdO
π TABLE OF CONTENT
0:00:00 Introduction
0:01:02 What is SQL?
0:04:24 Cheat Sheet
0:04:50 Installing MySQL on Mac
0:09:48 Installing MySQL on Windows
0:15:08 Creating the Databases for this Course
0:23:40 The SELECT Statement
0:29:30 The SELECT Clause
0:38:18 The WHERE Clause
0:43:35 The AND, OR, and NOT Operators
0:51:38 The IN Operator
0:54:41 The BETWEEN Operator
0:56:53 The LIKE Operator
1:02:31 The REGEXP Operator
1:11:51 The IS NULL Operator
1:14:18 The ORDER BY Operator
1:21:23 The LIMIT Operator
1:24:50 Inner Joins
1:33:16 Joining Across Databases
1:36:03 Self Joins
1:40:17 Joining Multiple Tables
1:47:03 Compound Join Conditions
1:50:44 Implicit Join Syntax
1:53:04 Outer Joins
1:59:31 Outer Join Between Multiple Tables
2:05:50 Self Outer Joins
2:08:02 The USING Clause
2:13:25 Natural Joins
2:14:46 Cross Joins
2:18:01 Unions
2:26:29 Column Attributes
2:29:54 Inserting a Single Row
2:35:40 Inserting Multiple Rows
2:38:58 Inserting Hierarchical Rows
2:44:51 Creating a Copy of a Table
2:53:38 Updating a Single Row
2:57:33 Updating Multiple Rows
3:00:47 Using Subqueries in Updates
3:06:24 Deleting Rows
3:07:48 Restoring Course Databases
π‘ Why Learn SQL?
- It's the standard language for working with databases.
- In-demand skill for developers, data scientists, and more.
- MySQL is popular, open-source, and easy to learn.
π This tutorial is perfect for you if:
- You're completely new to SQL.
- You want a practical, hands-on approach.
- You work (or want to work) with data.
#programming #coding
Views : 11,245,385
Genre: Education
Date of upload: Mar 19, 2019 ^^
Rating : 4.96 (2,420/240,928 LTDR)
RYD date created : 2022-04-09T20:15:03.064519Z
See in json
YouTube Comments - 9,206 Comments
Top Comments of this video!! :3
There are no dummies , there are only bad teachers. After taking many udemy courses trying to master SQL without any progress, I finally understand SQL. You are a great teacher.
2.6K |
Note to everyone: If the tables is stuck at fetching, just restart the MySQL application and it should fix the infinite queuing.
1.8K |
I first learned SQL from you a couple of years ago, now I hold two jobs utilizing the skills I learned here. Thank you for giving me an amazing career!
598 |
As a teacher I really appreciate the hands-on examples that are given, very well made!
13 |
Mosh, you should be under the United Nations legal protection. You are a world's treasure!
3.1K |
I saw that someone stuck on downloading the sample database querys. I was stuck on that too and i solved it copying the download link and past it a new section and clicking on enter. If you up this more people can see and solve the problem. Thanks for the course by the way. It was really helpful for me.
232 |
I've explored a couple of tutorials, and this course is BY FAR the best one ! Thank you so much for sharing your knowledge ! ... I really appreciate it Mosh !
15 |
I'm still not confident with the basics, but this was a good foundation. I really like the way this was delivered. I liked the exercises as well
13 |
I learnt HTML AND PYTHON now MySQL all of them with Lecture Mosh but people out there thinks I went to University
Thanks a lot Sirπ
114 |
I truly cannot thank you enough for this. Probably the most simple, straightforward, and comprehensive tutorial I've ever seen. Thank you.
47 |
Thanks Mosh, you're Awesome.I've learned React JS, Node JS, DSA and now MYSQL from you more than what i learned during my graduation.
3 |
I was stuck with MySQL server installation and about to give up learning database management. When I first installed it myself, it did not accept any password that I gave. I could not establish any connection and move further as it demanded a password but did not allow me to set one. I reinstalled MySql using your video and it worked. You are a life saver.
|
TABLE OF CONTENT ( For those on mobile)
0:00:00 Introduction
0:01:02 What is SQL?
0:04:24 Cheat Sheet
0:04:50 Installing MySQL on Mac
0:09:48 Installing MySQL on Windows
0:15:08 Creating the Databases for this Course
0:23:40 The SELECT Statement
0:29:30 The SELECT Clause
0:38:18 The WHERE Clause
0:43:35 The AND, OR, and NOT Operators
0:51:38 The IN Operator
0:54:41 The BETWEEN Operator
0:56:53 The LIKE Operator
1:02:31 The REGEXP Operator
1:11:51 The IS NULL Operator
1:14:18 The ORDER BY Operator
1:21:23 The LIMIT Operator
1:24:50 Inner Joins
1:33:16 Joining Across Databases
1:36:03 Self Joins
1:40:17 Joining Multiple Tables
1:47:03 Compound Join Conditions
1:50:44 Implicit Join Syntax
1:53:04 Outer Joins
1:59:31 Outer Join Between Multiple Tables
2:05:50 Self Outer Joins
2:08:02 The USING Clause
2:13:25 Natural Joins
2:14:46 Cross Joins
2:18:01 Unions
2:26:29 Column Attributes
2:29:54 Inserting a Single Row
2:35:40 Inserting Multiple Rows
2:38:58 Inserting Hierarchical Rows
2:44:51 Creating a Copy of a Table
2:53:38 Updating a Single Row
2:57:33 Updating Multiple Rows
3:00:47 Using Subqueries in Updates
3:06:24 Deleting Rows
3:07:48 Restoring Course Databases
254 |
I have been working at an educational institution for years. And I can tell that Mosh is born to be a teacher.
79 |
Thank you so much! I have never watched such a clear tutorial, very clear and also friendly! You make MySQL seem easy.
1 |
After many struggles, the best SQL course which I have gone through . Thanks Mosh β€
5 |
I have taken a few courses online and this is by far the most helpful guide to learning SQl I have seen so far. Thank you so much for posting this tutorial free.
21 |
Probably the best crash courses Iβve ever taken. The pace and material is just so easy to understand. Thank you so much Mosh!
98 |
Thanks, Mosh for the easy-to-understand, easy-to-follow tutorial. I feel a lot more confident.
I split it into 1hr blocks over 3 consecutive days to make it manageable. I'm looking forward to doing the rest.
1 |
@programmingwithmosh
2 years ago
π₯ Want to master MySQL? Get the full MySQL course: bit.ly/2uAoPM3 π Subscribe for more SQL tutorials like this: goo.gl/6PYaGF
331 |