MySQL Tutorial for Beginners [Full Course]
MySQL tutorial for beginners - Learn MySQL, the world's most popular open source database.
🔥 Want to master MySQL? Get the full MySQL course: http://bit.ly/2uAoPM3
👍 Subscribe for more SQL tutorials like this: https://goo.gl/6PYaGF
⭐️Want to learn more from me? Check out these links:
Courses: https://codewithmosh.com
Twitter: https://twitter.com/moshhamedani
Facebook: https://www.facebook.com/programmingwithmosh/
Blog: https://programmingwithmosh.com
📕Get my FREE SQL cheat sheet:
http://bit.ly/2JCO73l
📔Scripts to create the databases in this course:
http://bit.ly/2LNdvCd
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
If you're looking for a complete SQL tutorial for beginners with examples, this tutorial is a great way to learn SQL basics. Just follow through and you'll be able to write SQL queries in no time.
SQL, short for Structured Query Language, is a language used by software developers, data scientists and anyone who works with data. With SQL, you can store data in relational databases and write queries to extract valuable information.
There are various database management systems (DBMS) that support SQL but each product has its own implementation of SQL. In this course, we'll be using MySQL to learn SQL. MySQL is the most popular free and open-source database management system in the world. If you use a different DBMS (eg SQL Server), you can still benefit from this course as 90% of the skills you'll learn in this course can be transferred to other database management systems.
Видео MySQL Tutorial for Beginners [Full Course] канала Programming with Mosh
🔥 Want to master MySQL? Get the full MySQL course: http://bit.ly/2uAoPM3
👍 Subscribe for more SQL tutorials like this: https://goo.gl/6PYaGF
⭐️Want to learn more from me? Check out these links:
Courses: https://codewithmosh.com
Twitter: https://twitter.com/moshhamedani
Facebook: https://www.facebook.com/programmingwithmosh/
Blog: https://programmingwithmosh.com
📕Get my FREE SQL cheat sheet:
http://bit.ly/2JCO73l
📔Scripts to create the databases in this course:
http://bit.ly/2LNdvCd
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
If you're looking for a complete SQL tutorial for beginners with examples, this tutorial is a great way to learn SQL basics. Just follow through and you'll be able to write SQL queries in no time.
SQL, short for Structured Query Language, is a language used by software developers, data scientists and anyone who works with data. With SQL, you can store data in relational databases and write queries to extract valuable information.
There are various database management systems (DBMS) that support SQL but each product has its own implementation of SQL. In this course, we'll be using MySQL to learn SQL. MySQL is the most popular free and open-source database management system in the world. If you use a different DBMS (eg SQL Server), you can still benefit from this course as 90% of the skills you'll learn in this course can be transferred to other database management systems.
Видео MySQL Tutorial for Beginners [Full Course] канала Programming with Mosh
Показать
Комментарии отсутствуют
Информация о видео
Другие видео канала
Python Tutorial - Python for Beginners [Full Course]Day in the Life of a Japanese Game ProgrammerMosh's Christmas Present to You (2019)SQL vs NoSQL or MySQL vs MongoDBWhat is SQL? [in 4 minutes for beginners]Learn SQL In 60 MinutesIQ15: 6 SQL Query Interview QuestionsHow To Install MySQL on Windows 10SQL Tutorial - Full Database Course for BeginnersWeb Developer Reacts to Incredible Personal Websites // Personal PortfoliosSQL Server Overview TrainingWhat is Git? Explained in 2 Minutes!5 Things I Wish I Knew Before Starting ProgrammingTop 5 Programming Languages to Learn in 2020 to Get a Job Without a College DegreePython Tutorial - Python for Beginners [2020]JavaScript Tutorial for Beginners: Learn JavaScript in 1 Hour [2020]Top 65 SQL Interview Questions and Answers | SQL Interview Preparation | SQL Training | EdurekaMySQL Crash Course | Learn SQLCreate MySQL Database - MySQL Workbench Tutorial