Chapter 1 – Getting Started with MySQL and Installing MySQL

• MySQL Overview
• Basics of Relational Databases
• Entities and Relationships
• SQL Language and MySQL
• SQL data definition language and data
• manipulation language
• MySQL Client/Server Model
• MySQL Connectors
• Installation of the MySQL server
• Starting and stopping MySQL server
• Using the MySQL client
• MySQL Workbench

Chapter 2 - Designing Your Database and Understand Data Types

• Database Modeling
• Keys and Normalization
• Database Design
• Viewing and Evaluating a Database
• Data Types and Database Design
• Numeric, Temporal and String Data Types
• Character Set and Collation Support
• Data Type Considerations
• Meaning of NULL

Chapter 3: Creating Databases and Tables

• Creating a Database
• Creating a Table
• Showing How a Table Was Created
• Table Options
• Column Options
• Indexes, Keys, and Constraints
• Deleting database and tables
• Creating New Table Using an Existing Table
• Creating a Temporary Table
• Copying an Existing Table Structure
• Adding, removing and modifying table columns and indexes

Chapter 4: Querying and Modifying Table Data

• The SELECT Statement
• Creating Views
• Querying Data from an Application
• Exporting and Importing a Delimited File
• Troubleshooting: Authorization Levels
• Manipulating Data and inserting records
• Replacing and updating existing records
• Deleting records
• Exporting and importing a script
• Multistatement Transactions
• Modifying Data from an Application

Chapter 5 - Joining Tables and Functions

• Querying Multiple Tables
• Joining Tables with SELECT
• Inner Joins & Outer Joins
• Table Name Aliases
• Using & String Functions
• Date and time functions
• Numeric & Aggregate Functions
• Spaces in Function Names

Chapter 6 – MySQL Architecture and Administration Basics

• Architectural Overview
• Understand how MySQL Transmits Data
• MySQL Processes Requests
• Understand how MySQL Stores Data
• MySQL uses Memory
• Tablespaces, Redo and Undo Logs
• Plug-in Interface

Chapter 7 - Configuring & Monitoring MySQL Server

• Server Configuration Options
• Option Files and System Variables
• Launching Multiple Servers on the Same Host
• Monitoring Tools & Techniques
• MySQL Enterprise Audit & Monitor
• Monitoring User Activity

Chapter 8 - User Management

• Creating and Modifying User Accounts
• Configuring Passwords
• Authentication Plug-Ins
• Granting Permissions & Grant Tables

Chapter 9 - Security

• Understanding Security Risks
• Network Security & Secure Connections
• Password & Operating System Security

Chapter 10 - Backup Tools & Technique

• Understanding Backups & Backup Techniques
• Creating a Backup Strategy
• MySQL Backup Tools
• Raw Backup Methods

Chapter 11 - Percona Server

• Percona Overview
• Percona Server Installation
• Percona XtraBackup Installation
• Percona Features
• Configuration of XtraBackup
• Taking Full Backup
• Taking Incremental Backups
• Restoring / Recovering Full Backups and Incremental
• Partial Backups
• XtraBackup Installation on MySQL Server

Chapter 12 - Performance Tuning - Partitioning

• Overview of Partitioning in MySQL
• Partitioning Types
• RANGE Partitioning
• LIST Partitioning
• HASH Partitioning
• KEY Partitioning

Chapter 13 - Replication

• Overview Replication
• Master-Slave Configuration
• Master-Master Configuration
• Replication trouble shooting / errors

Chapter 14 - Performance Tuning

• MyISAM Key Cache
• InnoDB PT Parameters
• InnoDB Startup Options.
• Restrictions on InnoDB Tables
• The InnoDB Buffer Pool
• Optimization [ About Constraints ]
• Index Management
• About Locking & Issues
• Locking Methods, Table Locks, Deadlock
• Events
• Creating, Altering, Monitoring, Dropping Events

Chapter 15 - MariaDB Server Installation

• Features of MariaDB
• Differences of MariaDB and MySQL
• System databases

Chapter 16 - AZURE Cloud for DBA’s

• Introduction of Cloud Computing
• What is IAAS, PAAS & SAAS
• Installing MySQL Server in Azure
• Accessing MySQL from Azure Cloud
• MySQL Connecting from On-premises to Azure Cloud