|
Phase 1
|
|
|
|
MySQL tutorial for beginners (intro + installation) 🐬
11:00
|
|
|
|
MySQL: How to create a DATABASE
4:00
|
|
|
|
MySQL: How to create a TABLE
8:00
|
|
|
|
MySQL: How to INSERT rows into a TABLE
6:00
|
|
|
|
MySQL: How to SELECT data from a TABLE
5:00
|
|
|
|
MySQL: How to UPDATE and DELETE data from a TABLE
4:00
|
|
|
|
MySQL: AUTOCOMMIT, COMMIT, ROLLBACK
3:00
|
|
|
|
MySQL: CURRENT_DATE() & CURRENT_TIME()
3:00
|
|
|
|
MySQL: UNIQUE constraint
5:00
|
|
|
|
MySQL: NOT NULL constraint
3:00
|
|
|
|
MySQL: CHECK constraint is easy
4:00
|
|
|
|
MySQL: DEFAULT constraint is easy
8:00
|
|
|
|
MySQL: PRIMARY KEYS are easy
5:00
|
|
|
|
MySQL: AUTO_INCREMENT is awesome
4:00
|
|
|
|
MySQL: FOREIGN KEYS are easy (kind of)
8:00
|
|
|
|
MySQL: JOINS are easy (INNER, LEFT, RIGHT)
5:00
|
|
|
|
Functions in MySQL are easy
4:00
|
|
|
|
MySQL logical operators are easy
6:00
|
|
|
|
MySQL wild cards are easy
4:00
|
|
|
|
MySQL ORDER BY clause is easy
3:00
|
|
|
|
MySQL LIMIT clause is easy
3:00
|
|
|
|
MySQL UNIONS are easy
4:00
|
|
|
|
MySQL SELF JOINS are ... ughhh
10:00
|
|
|
|
MySQL VIEWS are awesome
6:00
|
|
|
|
MySQL: INDEXES are awesome
6:00
|
|
|
|
MySQL: SUBQUERIES
7:00
|
|
|
|
MySQL: GROUP BY
5:00
|
|
|
|
MySQL: ROLLUP
4:00
|
|
|
|
MySQL: ON DELETE
8:00
|
|
|
|
MySQL: STORED PROCEDURES
8:00
|
|
|
|
MySQL: TRIGGERS
17:00
|
|
|
Phase 2
|
|
|
|
MySQL Installation Using Debian Packages
7:00
|
|
|
|
MySQL Installation Using Linux Generic Binary and Securing the Installationv1
17:00
|
|
|
|
MySQL Client - Connecting to the Server From a Remote Host
11:00
|
|
|
|
MySQL Client Commands
8:00
|
|
|
|
MySQL Logs
19:00
|
|
|
|
MYSQL Basic Operations
11:00
|
|
|
|
MySQL INFORMATION SCHEMA
9:00
|
|
|
|
Transaction in MySQL
15:00
|
|
|
|
MySQL Deadlock Situation
4:00
|
|
|
|
MySQL Partitioning
16:00
|
|
|
|
Exporting and Importing Data in MySQL
11:00
|
|
|
|
MySQL User Administration
10:00
|
|
|
|
MySQL Backup & Restoration
11:00
|
|
|
|
MySQL Replication (With MySQL Proxy in front)
13:00
|
|
|
Quiz
|
|
|
|
MY SQL
|
|