The Definitive Guide to MySQL and MariaDB Video

The Definitive Guide to MySQL and MariaDB Video

Objectives:

1. Install both client and server, on Windows or Linux.
2. Create and modify tables in MySQL.
3. Ensure tables have data integrity using nullability, and primary and foreign keys.
4. Create numeric, date and time, and string data types in MySQL.
5. Insert data using these two approaches in MySQL.
6. Experience some of the restrictions that exist in MySQL for inserting data.
7. Use the SELECT, FROM, and WHERE statements to retrieve data from tables in MySQL.
8. Learn about inner joins, left joins, right joins, and full outer joins.
9. Learn when views should be used. Explore aggregate, string, control flow, date and time, and math functions in MySQL.
10. Learn what stored procedures are, how to use them, and when to use them (for reusability or security) in MySQL.
11. Create and run triggers in MySQL.
12. Optimize your database in MySQL.
13. Backup your database and apply techniques to maintain your database in MySQL.

Instructor: Victor Deras

Length: 3 hours

Access period: For one year starting from purchase date