MySQL Dev & Admin Training Syllabus
Theory, Terminology and Concepts
- Client/Server Concepts
- Database and Database Objects
Data Definition using SQL
- Databases
- Data Types
- Tables
- Constraints and Indexes
- Views
Basic Data Manipulation using SQL
- Recurring SQL Constructs
- Adding data
- Modifying data
- Removing data
- Searching data
Advanced Data Manipulation using SQL
- Expressions
- Grouping and Aggregate Functions
- Joining Tables
Transactions
- Transaction Concepts
- SQL for working with Transaction
Import/Export
- Tools for Import/Export
- SQL for Import/Export
MySQL Admin
- Install and configure MySQL Server and client programs.
- Recognize the key components of the MySQL architecture.
- Secure your server.
- Troubleshoot server slowdowns and other issues.
- Improve query performance.
- Configure and administer a variety of replication topologies.
- Understand the benefits of MySQL Cloud.