Главная
Study mode:
on
1
MySQL Beginner Tutorial 1 - Introduction to MySQL
2
MySQL Tutorial 2 - Primary Keys
3
MySQL tutorial 3 - Selecting stuff
4
MySQL tutorial 4 - Limit, Offset and Ordering
5
MySQL tutorial 5 - Using "Where"
6
MySQL tutorial 6 - Where, And, Or
7
MySQL tutorial 7 - Like and Wildcards
8
MySQL tutorial 8 - Where Not
9
MySQL tutorial 9 - Count, Sum and Average
10
MySQL tutorial 10 - Inserting a new row
11
MySQL tutorial 11 - Update a row
12
MySQL tutorial 12 - Deleting data
13
MySQL tutorial 13 - Creating and dropping tables
14
MySQL tutorial 14 - Altering tables
15
MySQL tutorial 15 - joining 2 tables
16
MySQL tutorial 16 - joining many tables
17
MySQL tutorial 17 - Aliases
18
MySQL tutorial 18 - Foreign Keys
Description:
Learn the fundamentals of MySQL in this comprehensive 2.5-hour tutorial series. Begin with an introduction to MySQL and progress through essential concepts such as primary keys, data selection, and filtering techniques. Master the use of SQL clauses like LIMIT, OFFSET, and ORDER BY, and explore advanced filtering with WHERE, AND, and OR operators. Discover how to use LIKE and wildcards for pattern matching, and learn to perform aggregate functions such as COUNT, SUM, and AVERAGE. Gain hands-on experience with data manipulation, including inserting, updating, and deleting rows. Delve into table management by creating, dropping, and altering tables. Finally, explore the power of joining tables, using aliases, and implementing foreign keys to establish relationships between data sets.

MySQL for Beginners

Add to list
#Programming #Databases #Relational Databases #MySQL #Data Science #Data Manipulation #Computer Science #Database Management #Domain-Specific Languages (DSL) #SQL #Foreign Keys
0:00 / 0:00
1 of 18

MySQL Beginner Tutorial 1 - Introduction to MySQL