Главная
Study mode:
on
1
Introduction
2
What is SQL?
3
Cheat Sheet
4
Installing MySQL on Mac
5
Installing MySQL on Windows
6
Creating the Databases for this Course
7
The SELECT Statement
8
The SELECT Clause
9
The WHERE Clause
10
The AND, OR, and NOT Operators
11
The IN Operator
12
The BETWEEN Operator
13
The LIKE Operator
14
The REGEXP Operator
15
The IS NULL Operator
16
The ORDER BY Operator
17
The LIMIT Operator
18
Inner Joins
19
Joining Across Databases
20
Self Joins
21
Joining Multiple Tables
22
Compound Join Conditions
23
Implicit Join Syntax
24
Outer Joins
25
Outer Join Between Multiple Tables
26
Self Outer Joins
27
The USING Clause
28
Natural Joins
29
Cross Joins
30
Unions
31
Column Attributes
32
Inserting a Single Row
33
Inserting Multiple Rows
34
Inserting Hierarchical Rows
35
Creating a Copy of a Table
36
Updating a Single Row
37
Updating Multiple Rows
38
Using Subqueries in Updates
39
Deleting Rows
40
Restoring Course Databases
Description:
Learn MySQL, the world's most popular open-source database, in this comprehensive 3-hour video tutorial for beginners. Master essential SQL concepts including SELECT statements, WHERE clauses, JOIN operations, and data manipulation techniques. Explore topics such as installing MySQL, creating databases, writing complex queries, and performing CRUD operations. Follow along with practical examples and gain hands-on experience in database management. By the end of this course, write SQL queries confidently and extract valuable information from relational databases.

MySQL Tutorial for Beginners

Programming with Mosh
Add to list
#Programming #Databases #Relational Databases #MySQL #Domain-Specific Languages (DSL) #SQL #Computer Science #Database Management #Data Storage #Data Science #Data Extraction #Subqueries
0:00 / 0:00
1 of 40

Introduction