MySQL Tutorial for Beginners [Full Course]

By - Programming with Mosh
Overview
Certification
Reminders

Description

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: https://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 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.

Chapters

Introduction
Introduction
1 min
What is SQL?
What is SQL?
3 min
Cheat Sheet
Cheat Sheet
26 sec
Installing MySQL on Mac
Installing MySQL on Mac
4 min
Installing MySQL on Windows
Installing MySQL on Windows
5 min
Creating the Databases for this Course
Creating the Databases for this Course
8 min
The SELECT Statement
The SELECT Statement
5 min
The SELECT Clause
The SELECT Clause
8 min
The WHERE Clause
The WHERE Clause
5 min
The AND, OR, and NOT Operators
The AND, OR, and NOT Operators
8 min
The IN Operator
The IN Operator
3 min
The BETWEEN Operator
The BETWEEN Operator
2 min
The LIKE Operator
The LIKE Operator
5 min
The REGEXP Operator
The REGEXP Operator
9 min
The IS NULL Operator
The IS NULL Operator
2 min
The ORDER BY Operator
The ORDER BY Operator
7 min
The LIMIT Operator
The LIMIT Operator
3 min
Inner Joins
Inner Joins
8 min
Joining Across Databases
Joining Across Databases
2 min
Self Joins
Self Joins
4 min
Joining Multiple Tables
Joining Multiple Tables
6 min
Compound Join Conditions
Compound Join Conditions
3 min
Implicit Join Syntax
Implicit Join Syntax
2 min
Outer Joins
Outer Joins
6 min
Outer Join Between Multiple Tables
Outer Join Between Multiple Tables
6 min
Self Outer Joins
Self Outer Joins
2 min
The USING Clause
The USING Clause
5 min
Natural Joins
Natural Joins
1 min
Cross Joins
Cross Joins
3 min
Unions
Unions
8 min
Column Attributes
Column Attributes
3 min
Inserting a Single Row
Inserting a Single Row
5 min
Inserting Multiple Rows
Inserting Multiple Rows
3 min
Inserting Hierarchical Rows
Inserting Hierarchical Rows
5 min
Creating a Copy of a Table
Creating a Copy of a Table
8 min
Updating a Single Row
Updating a Single Row
3 min
Updating Multiple Rows
Updating Multiple Rows
3 min
Using Subqueries in Updates
Using Subqueries in Updates
5 min
Deleting Rows
Deleting Rows
1 min
Restoring Course Databases
Restoring Course Databases
2 min
AI Mentor