Certificate in MySQL DB Administration

Current Status

Not Enrolled

Price

5

Get Started

This course is currently closed

You must login before you access the courses page.

Course Content

Expand All

MySQL Basics 8 Topics

Expand

Lesson Content

0% Complete 0/8 Steps

MySQL Introduction

Client/Server Basics

Database, DBMS and RDBMS

Communication Protocols

MySQL Architecture

Storage Engine Tiers

MySQL Installation

Data Definition 5 Topics

Expand

Lesson Content

0% Complete 0/5 Steps

Databases and tables

Relational Theory

Constraints, Indexes and Views

Character Data Type

Data Manipulation 10 Topics

Expand

Lesson Content

0% Complete 0/10 Steps

Search, add, remove and update data

Stored Procedures

MySQL Subqueries

MySQL Service 5 Topics

Expand

Lesson Content

0% Complete 0/5 Steps

MySQL Distributions

Start and stop MySQL server and runtime configuration

Log and status files

Security-related configuration

INFORMATION_SCHEMA

Client Programs 6 Topics

Expand

Lesson Content

0% Complete 0/6 Steps

Locking in MySQL 4 Topics

Expand

Lesson Content

0% Complete 0/4 Steps

Locking Overview

Advisory Locking

Storage Engines of MySQL 5 Topics

Expand

Lesson Content

0% Complete 0/5 Steps

MySQL Storage Engines

FEDERATED Engine

Integrity and Repair of MySQL 4 Topics

Expand

Lesson Content

0% Complete 0/4 Steps

Integrity Basics

Table Maintenance

Client Programs

Backup and Recovery in MySQL 4 Topics

Expand

Lesson Content

0% Complete 0/4 Steps

Binary and Textual backups

Log and status files

Replication, Data Recovery and mysql cluster

MySQL Security 6 Topics

Expand

Lesson Content

0% Complete 0/6 Steps

User account management

Access Control System

Stored Procedures

Optimization of MySQL 4 Topics

Expand

Lesson Content

0% Complete 0/4 Steps

Query Optimization

Schema Optimization

Server Optimization

Error Handling in MySQL 3 Topics

Expand

Lesson Content

0% Complete 0/3 Steps

MySQL Diagnostics Area

Error Log and Slow Query Log

Hardware, Disk and Network issues

Scaling MySQL 5 Topics

Expand

Lesson Content

0% Complete 0/5 Steps

Database Scalability

Multiple Servers

Bonus: Course Videos