timofte andrei
Homepage timofte andrei About PHP timofte andrei About Java timofte andrei About MySQL timofte andrei About C timofte andrei About C++ timofte andrei About Linux timofte andrei Contact Us
Oracle MySQL Database Administrator
-Exam 2-
timofte andrei
MySQL is not a new name nowadays in information technology as it is the only easy way to handle with databases. It is an efficient way of managing websites by using less energy and time. It has proper support system for new and professional users and they can run it with training and practice. It can help in many ways and in many fields including business, social networking websites containing bulk of data, and marketing large amounts of storage data in finance. For those candidates without prior experience, certifications will help prove to their employers that have the understanding and skills required for job roles that demand knowledge of MySQL products. The certification is not a guarantee that you will get the job, the certification will only improve your chances of getting the job. For those candidates with experience, the certification will boost their resume and chances are, there will be something new that you will learn. With the title of Oracle Certified Professional, MySQL 5 Database Administrator on your resume, you have proof that you have mastered server-related issues, such as installing a server from scratch, keeping the server running smoothly at all times, using the storage engine for a given task, analyzing the trouble spots of other users queries and often helping users of MySQL products. The examination can be taken at any Pearson VUE testing center worldwide. The Database Administrator - Exam 2 consists in 70 multiple choice questions, exam duration is 90 minutes and the passing mark is on 60%.

Exam Topics

Section 1: Stored Routines (5%)
Using Stored Routines and Triggers for Security Purposes
Using Stored Routines to Enhance Performance


Section 2: User Management (20%)
User Account Management
Client Access Control


Section 3: Securing the Server (10%)
Security Issues
Operating System Security
Filesystem Security
Log Files and Security
Network Security
FEDERATED Table Security


Section 4: Upgrade-Related Security Issues (5%)
Upgrading the Privilege Tables
Security-Related SQL Mode Values


Section 5: Optimizing Queries (15%)
Identifying Candidates for Query Analysis
Using EXPLAIN to Analyze Queries
Using SHOW WARNINGS for Optimization
MyISAM Index Caching


Section 6: Optimizing Schemas (15%)
General Table Optimizations
Normalization
MyISAM-Specific Optimizations
InnoDB-Specific Optimizations
MERGE-Specific Optimizations
MEMORY-Specific Optimizations


Section 7: Optimizing the Server (10%)
Interpreting mysqld Server Information
Measuring Server Load
Tuning Memory Parameters
Using the Query Cache


Section 8: Interpreting Error Messages (5%)
Sources of Diagnostic Information
Using the Error Log for Diagnostic Purposes
Using The Slow Query Log for Diagnostic Purposes


Section 9: Optimizing the Environment (5%)
Choosing Hardware for MySQL Use
Configuring Disks for MySQL Use
Network Issues
Optimizing the Operating System for MySQL Use


Section 10: Scaling MySQL (10%)
Using Multiple Servers
Replication
HTML/CSS Courses
timofte andrei
HTML is the basic language of web programmming domain. This course presents the principles of HTML and CSS and the way it can be combined this two languages. With HTML and CSS we can create profesional webpages with a simple text editor and a common Internet browser.
Read More
Javascript/JQuery Courses
timofte andrei
This course presents the basics of Javascript programming language and also the JQuery technology. Javascript is a very popular web programming language and it's very useful for creating interactive web pages. DHTML is a combination of HTML, CSS and Javascript.
Read More