MySQL Tutorial For Beginners

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





















Viewed 15 Times

Post On 2020-05-26