Course Details - MySQL DBA
We offer World Class Job Oriented Hands on Practical MySQL DBA Class room & Online Training.
ORACLE RAC
Content!
The MySQL for Database Administrators training is designed for DBAs and other database professionals. Expert instructors will teach you how to install and configure the MySQL Server, set up replication and security, perform database backups and performance tuning and protect MySQL databases.
We offer world class Mysql 8.0 DBA training at an affordable price, you get 30 hours of quality instruction by our most experienced instructor. However, for Corporate enrollment (2 or more students), we are currently offering a 10% discount Online Trainings / Classroom.
Real Time Scenarious by MNC expert - Job Oriented with hands on Practicals
Installation,Configuration,Network Settings,Hostname,MountPoints,Firewall,Security Settings.
Getting Started, File Management, Directories, File permissions, Environment, Pipes,Filters, Processes, The Vi Editor
Installing MySQL on Linux using Yum Repository
Installing MySQL on Linux Using RPM Packages from Oracle
Installing MySQL on Microsoft Windows
Describing MySQL
Listing MySQL Products and Professional Services
Describing MySQL Enterprise Subscription
Currently Supported Operating Systems
Describing MySQL Certification Program
Listing Available MySQL Courses
Describing Installation of MySQL
Describing Installation of world Database
Creating MySQL database
Create a Table in MYSQL
Setting up default database
Client/Server Architecture
MySQL Architecture Overview
How MySQL Uses Disk Space
How MySQL Uses Memory
The MySQL Plug-In Interface
Types of MySQL Distributions
Starting and Stopping MySQL on Windows
Starting and Stopping MySQL on Linux
Upgrading MySQL
Managing Multiple Servers
Overview of Administrative Clients
Invoking MySQL Client Programs
Using the mysql Client
The mysqladmin Client
MySQL Connectors
Third-Party APIs
Data Types
Numeric Data Types
Character String Data Types
Binary String Data Types
Temporal Data Types
NULLs
Column Attributes
Metadata Access Methods
The INFORMATION_SCHEMA Database/Schema
Using SHOW and DESCRIBE
The mysqlshow Command
Transactions
Transaction Control statements
Isolation Levels
Locking
Storage Engine Overview
MyISAM, InnoDB, and MEMORY Storage Engines
Other Storage Engines
Choosing Appropriate Storage Engines
Using Multiple Storage Engines
Storage Engine Comparison Chart
Table Maintenance
SQL Statements for maintenance operations
Client and Utility Programs for table maintenance
Table Maintenance per Storage Engine
Security Risks
Security Measures
Privileges
Access Levels, including: 1 - User Accounts, 2 - Databases, 3 - Tables, 4 - Columns, 5 - Stored Routines
User Account Maintenance
Client Access Control
Using Secure Connections
Planning for Recovery Backup
Backup Tools Overview
Making Raw Backups
Making Logical (Text) Backups
Backup Log and Status Files
Replication as an Aid to Backup
Backup Method Comparison
Data Recovery
Using EXPLAIN to Analyze Queries
General Table Optimizations
Setting and Interpreting MySQL Server Variables
Downloading and Installing WebServer
Configuring Mysql DB in Webserver
Creating web page
configuring and integrating webpage with mysql database
Writing SQL statements in dynamic webpages with Mysql
Creating domain and Configuring DNS(Add on If student needed on Project)
Wordpress Download,installation,Configuration,Hosting.
Webpages Hosting with wordPress.
Adding pluggins using wordpress.
Interview Preparation,Mock interview,Doubt Clearance,Understanding HR,Manager,Technical Rounds.
Will Provide Support using Whatsapp and Skype with remote access to fix the doubts during Course Duration with in Working Hours - Till the Classes Completed.