• Introducing MySQL. This first topic in the MySQL (and MariaD video series introduces you to this powerful open source relational database. Install both client and server, on Windows or Linux. MariaDB can also be used as an alternative to MySQL, and almost everything in this course also applies to MariaDB.
• Creating and modifying tables in MySQL. This second topic in the MySQL (and MariaD video series focuses on tables. Tables are comprised of columns and rows, and both are illustrated in this session first in Microsoft Excel and then in MySQL. Follow along with Victor in this hands-on session to create and modify tables in MySQL. Ensure tables have data integrity using nullability, and primary and foreign keys.
• Data Types in MySQL. This third topic in the MySQL (and MariaD video series focuses on data types in MySQL. Follow along with Victor in this hands-on session to create numeric, date and time, and string data types in MySQL.
• Inserting Data in MySQL. This fourth topic in the MySQL (and MariaD video series focuses on inserting data in MySQL using the INSERT INTO statement and through a GUI. Follow along with Victor in this hands-on session to insert data using these two approaches in MySQL. Also experience some of the restrictions that exist in MySQL for inserting data.
• Querying Data in MySQL. This fifth topic in the MySQL (and MariaD video series focuses on querying data in MySQL. Learn about queries and subqueries. Follow along with Victor in this hands-on session using the SELECT, FROM, and WHERE statements to retrieve data from tables in MySQL.
• Performing Joins in MySQL. This sixth topic in the MySQL (and MariaD video series focuses on performing joins in MySQL. Learn about inner joins, left joins, right joins, and full outer joins. Follow along with Victor in this hands-on session to retrieve data from multiple tables in the same query using MySQL.
• Creating Views in MySQL. This seventh topic in the MySQL (and MariaD video series focuses on creating views in MySQL. Learn when views should be used. Follow along with Victor in this hands-on session to create and access data from virtual tables in MySQL.
• Leveraging Functions in MySQL. This eighth topic in the MySQL (and MariaD video series focuses on aggregate, string, control flow, date and time, and math functions in MySQL. Follow along with Victor in this hands-on session to apply functions in MySQL.
• Creating Stored Procedures in MySQL. This ninth topic in the MySQL (and MariaD video series focuses on stored procedures in MySQL. Learn what stored procedures are, how to use them, and when to use them (for reusability or security) in MySQL. Follow along with Victor in this hands-on session to create and run stored procedures in MySQL.
• Creating Triggers in MySQL. This tenth topic in the MySQL (and MariaD video series focuses on triggers in MySQL. Learn what triggers are, how they differentiate from stored procedures, how to build them, and when to use them. Follow along with Victor in this hands-on session to create and run triggers in MySQL.
• Optimizing MySQL. This 11th topic in the MySQL (and MariaD video series focuses on optimizing MySQL. Learn why optimization is so important and the different ways to optimize your database. Follow along with Victor in this hands-on session to optimize your database in MySQL.
• Performing Maintenance in MySQL. This 12th topic in the MySQL (and MariaD video series focuses on performing database backup and maintenance in MySQL. Learn why backups are so important and hear some valuable backup tips. Follow along with Victor in this hands-on session to backup your database and apply techniques to maintain your database in MySQL.