Description

Type

Course
Level

Intermediate
Methodology

Online

Duration

Flexible
Start date

Different dates available

MySQL DB Administrator certification for MySQL database assesses the candidate for a company’s database management needs. The certification tests the candidates on various areas of MySQL database which includes administration, configuration, security and management.

Facilities

Online

Start date

Different dates availableEnrolment now open

About this course

Who is it intended for?

Job seekers looking to find employment in IT department of various companies, students generally wanting to improve their skill set and make their CV stronger and existing employees looking for a better role can prove their employers the value of their skills through this certification.

Questions & Answers

Add your question

Our advisors and other users will be able to reply to you

Who would you like to address this question to?

All
Students
Centre

Fill in your details to get a reply

We will only publish your name and question

Reviews

Subjects

Database training
Database
MySQL
Server
Installation
Communication protocols
Expressions
Operating
MySQL Basics
MySQL Architecture
MySQL Distributions
Advisory Locking
InnoDB Engine
FEDERATED Engine

Teachers and trainers (1)

Name Name

Teacher

Course programme

MySQL Basics

Introduction
Client/Server Basics
Database, DBMS and RDBMS
Communication Protocols
MySQL Architecture
Storage Engine Tiers
The SQL Parser
Installation

Data Definition

Databases and tables
Relational Theory
Data types
Constraints, Indexes and Views
Character Data Type
Data Manipulation
Search, add, remove and update data
Expressions
Operators
Functions
Joins
Stored Procedures
Trigger
Views
Transactions
MySQL Subqueries

MySQL Service

MySQL Distributions
Start and stop MySQL server and runtime configuration
Log and status files
Security-related configuration
INFORMATION_SCHEMA

Client Programs

mysql
mysqladmin
mysqlcheck
mysqldump
mysqlimport
mysqlshow

Locking

Locking Overview
MySQL Locking
Explicit table
Advisory Locking

Storage Engines

MySQL Storage Engines
MyISAM
InnoDB Engine
MEMORY Engine
FEDERATED Engine

Integrity and Repair

Integrity Basics
Table Maintenance
Client Programs
Auto-Repair

Backup and Recovery

Backup Types
Binary and Textual backups
Log and status files
Replication, Data Recovery and mysql cluster

Security

User account management
User Privilege
Access Control System
Securing MySQL
Stored Procedures
Triggers

Optimization

Query Optimization
Caching
Schema Optimization
Server Optimization

Error Handling

The MySQL Diagnostics Area
Error Log and Slow Query Log
Hardware, Disk and Network issues

Scaling

Scaling Basics
Database Scalability
Multiple Servers
Replication
MySQL Cluster

Additional information

MySQL DB administrators are in great demand and companies in India looking for MySQL database management are hiring them.

See related categories

Contact us

Certified MySQL DB Administrator

Questions & Answers

Reviews

Subjects

Course programme

Add similar courses
and compare them to help you choose.

Certified MySQL DB Administrator

Questions & Answers

Reviews

Subjects

Course programme

Add similar coursesand compare them to help you choose.

Add similar courses
and compare them to help you choose.