Главная
Study mode:
on
1
#1 MySQL intro + installation
2
Windows installation
3
MAC OS installation
4
#2 DATABASES
5
#3 TABLES
6
#4 INSERT ROWS
7
#5 SELECT
8
#6 UPDATE & DELETE
9
#7 AUTOCOMMIT, COMMIT, ROLLBACK
10
#8 CURRENT_DATE & CURRENT_TIME
11
#9 UNIQUE
12
#10 NOT NULL
13
#11 CHECK
14
#12 DEFAULT
15
#13 PRIMARY KEYS
16
#14 AUTO_INCREMENT
17
#15 FOREIGN KEYS
18
#16 JOINS
19
#17 FUNCTIONS
20
#18 AND, OR, NOT
21
#19 WILD CARDS
22
#20 ORDER BY
23
#21 LIMIT
24
#22 UNIONS
25
#23 SELF JOINS
26
#24 VIEWS
27
#25 INDEXES
28
#26 SUBQUERIES
29
#27 GROUP BY
30
#28 ROLLUP
31
#29 ON DELETE
32
#30 STORED PROCEDURES
33
#31 TRIGGERS
Description:
Learn MySQL from the ground up in this comprehensive 3-hour video tutorial. Begin with installation instructions for both Windows and Mac OS, then dive into essential concepts like creating databases and tables, inserting and selecting data, and performing updates and deletions. Master advanced topics including autocommit, rollback, primary and foreign keys, joins, functions, and wildcards. Explore practical skills such as using ORDER BY, LIMIT, and UNION clauses, creating views and indexes, writing subqueries, and implementing stored procedures and triggers. Perfect for beginners, this course covers everything needed to become proficient in MySQL database management.

MySQL Full Course - 2023

Bro Code
Add to list
0:00 / 0:00