MySQL for DBA’,s

Ahana Systems & Solutions (P) Ltd.
Hanumanth nagar, Karnataka, India

Course Format: Classroom | E-learning | Virtual Class | Online/Live | On-site/In-house | Blended | Self-paced

Course Description:

'' MySQL Database Administration

MySQL for DBA’,s

At the completion of this course, you should be able to:

* Describe the MySQL Architecture, general operational characteristics and resources utilized for running it.
* Perform the most common Database Administration (DBA) tasks utilizing the various programs contained within the MySQL application
* Utilize the MySQL Administrator Graphical User Interface (GUI) to manage a MySQL server
* Use the INFORMATION_SCHEMA database to access metadata
* Install and Upgrade MySQL 5.0 for the most common operating systems
* Perform the MySQL start and shutdown operations
* Configure MySQL server options at runtime
* Activate and manage numerous server logs
* Evaluate data types and character sets for performance issues
* Understand data locking concepts and the different levels of locking in MySQL
* Differentiate between the multiple storage engines available in MySQL
* Create, Maintain and Manage MySQL tables
* Perform backup and restore operations utilizing multiple MySQL tools
* Manage user maintenance and access to a MySQL Server
* Maintain integrity of a MySQL installation utilizing security protocols
* Use stored routines and triggers for administration tasks
* Manage, apply and understand the reason for using views
* Improve performance through query optimization
* Optimize Schemas (Databases) utilizing multiple techniques
* Utilize MySQL monitoring tools to improve server performance
* Compare multiple environment options to improve server performance
* Scale MySQL operations up

...''

Elements of this syllabus are subject to change.

Phone:080-26675891

School Address/Venue(s):

Ahana Systems & Solutions (P) Ltd.

105/22, Ist floor, 50 Feet Road
Hanumanth Nagar, Near Nirmala Store Bus Stop
Banashankari, Bangalore- 560050

Jobs & Resumes: Hanumanth nagar
Houses & Roommates: Hanumanth nagar

Search other schools for MySQL for DBA’,s training resources.

performaernce and tuning: configuring adaptive server enterprise
Fast Track to Replication Server Administration
system and database administration: adaptive server enterprise
SQL Server 2005
sql server 2005 - performance tuning and optimisation
SQL Server 2005: Analysis Services
SQL Server 2005: Integration Services

Notice: The course description on this page was captured from the Internet as historical reference or submitted by visitors. It was archived statically and not updated from day to day.
 

Tips: Try the search form on top of each page to find the latest course information, using course topic and location as keywords. Keep the course topic keyword short to get more results.