AP2V Academy

Introduction
Lesson : 1 | Duration 1.5 hours

MySQL Product, MySQL Services and Support MySQL Resources, Example Databases
2
MySQL Server and Client
Lesson : 2 | Duration 1.5 hours

The client/server model overview, Communication protocols, Connectors and MySQL, The LAMP stack, Installation of the MySQL server, MySQL server and client startup
3
Database Basics
Lesson : 3 | Duration 1.5 hours

Basics of relational databases, SQL language and MySQL
4
Database Designs
Lesson : 4 | Duration 1.5 hours

Database Modelling, Keys, Normalization
5
Table Data Types
Lesson : 5 | Duration 1.5 hours

Data types, Numeric data types, Temporal data types, Character string data types, The meaning of null
6
Database and Table Creation
Lesson : 6 | Duration 1.5 hours

Database structure Creation, Database Creation, Table Creation
7
Basic Queries
Lesson : 7 | Duration 1.5 hours

The select statement, MySQL workbench for SQL Development, Troubleshooting
8
Database and Table Maintenance
Lesson : 8 | Duration 1.5 hours

Deleting an entire database, Maintaining tables, Maintaing columns, Indexes and constraints
9
Table Data Manipulation
Lesson : 9 | Duration 1.5 hours

Delete/Modify table row data, The INSERT statement, The REPLACE statement, The UPDATE statement, The DELETE statement
10
Functions
Lesson : 10 | Duration 1.5 hours

Simple Functions, Grouping with functions
11
Joining Tables
Lesson : 11 | Duration 1.5 hours

Combining multiple tables, Inner joins, Outer joins
12
Table Queries
Lesson : 12 | Duration 1.5 hours

What is a subquery, Categories of subqueries, Subquery types, Placing subqueries, Other subquery uses, Converting subqueries to joins
13
Exporting and Importing Data
Lesson : 13 | Duration 1.5 hours

Exporting data, Importing data
14
MySQL GUIs
Lesson : 14 | Duration 1.5 hours

MySQL enterprise monitor, MySQL workbench