Pengantar MySQL
- Login / LogOut Database Server,
- Mengaktifkan dan Menonaktifkan Database
Desain Database & ERD
- Menggunakan Entity Relationship Diagram (ERD)
- Normalisasi, Relationship Structure dan Function Dependency
Membangun Database
- MySQL Database Structure, Create and Delete Database
MySQL Tabel
- Data Definition Language (DDL)
- Create, Delete and Alter Table, Data Integrity
Manipulasi Data
- Data Manipulation Tools, Modifikasi dan Menghapus Record
SQL
- Data Retrieval, SQL Commands in MySQL
- Sorting and Arithmetic , SQL Functions
Functions
- Query Flow, String , Encryption
Multi-user Access
- Transaction Paradigm, Locking , Sequences
Optimasi
- Menggunakan dan Mengolah Index, Query Optimizer
Security
- Security Concept, GRANT and REVOKE
- Privileges , Access Verification , Drop Privileges Security
Backup and Restore
- Backup Strategy, Techniques and Backup Media
- Online Backup Process, Restore Database Files
- Mysqldump dan Mysqlreport Utilities