Adept
Your courses
Sign in
MySQL tutorial for beginners (intro + installation)
MySQL tutorial for beginners 🐬
·
Bro Code
Mark complete
00:00:00 introduction 00:02:22 Windows installation 00:06:05 Mac OS installation
Course content
0 of 31 completed
·
2h 59m left
MySQL tutorial for beginners (intro + installation)
10:30
2
How to create a DATABASE
4:01
3
How to create a TABLE
8:10
4
How to INSERT rows into a TABLE
5:54
5
How to SELECT data from a TABLE
5:01
6
How to UPDATE and DELETE data from a TABLE
3:32
7
AUTOCOMMIT, COMMIT, ROLLBACK
2:38
8
CURRENT_DATE() & CURRENT_TIME()
2:46
9
UNIQUE constraint
4:43
10
NOT NULL constraint
2:53
11
CHECK constraint is easy
3:57
12
DEFAULT constraint is easy
8:19
13
PRIMARY KEYS are easy
5:25
14
AUTO_INCREMENT is awesome
3:55
15
FOREIGN KEYS are easy (kind of)
8:17
16
Learn MySQL joins in 5 minutes!
5:04
17
Functions in MySQL are easy
3:45
18
MySQL logical operators are easy
5:57
19
MySQL wild cards are easy
4:18
20
MySQL ORDER BY clause is easy
2:37
21
MySQL LIMIT clause is easy
2:53
22
MySQL UNIONS are easy
4:14
23
MySQL SELF JOINS are ... ughhh
10:03
24
MySQL VIEWS are awesome
6:03
25
MySQL: INDEXES are awesome
6:26
26
MySQL: SUBQUERIES
6:46
27
MySQL: GROUP BY
5:08
28
MySQL: ROLLUP
3:51
29
MySQL: ON DELETE
7:31
30
MySQL: STORED PROCEDURES
8:02
31
MySQL: TRIGGERS
16:50
