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 1-
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 MySQL Database Administrator - Exam 1 consists in 70 multiple choice questions, exam duration is 90 minutes and the passing mark is on 60%.

Exam Topics

Section 1: MySQL Architecture (10%)
Client/Server Overview
Communication Protocols
The SQL Parser and Storage Engine Tiers
How MySQL Uses Disk Space
How MySQL Uses Memory


Section 2: Starting, Stopping, and Configuring MySQL (20%)
Types of MySQL Distributions
Starting and Stopping MySQL Server on Windows
Starting and Stopping MySQL Server on Unix
Runtime MySQL Configuration
Log and Status Files
Loading Time Zone Tables
Security-Related Configuration
Setting the Default SQL Mode
Upgrading MySQL


Section 3: Client Programs for DBA Work (5%)
Overview of Administrative Clients
mysql
mysqladmin
mysqlimport
mysqldump
Client Program Limitations


Section 4: Character Set Support (5%)
Performance Issues
Choosing Data Types for Character Columns


Section 5: Locking (10%)
Locking Concepts
Explicit Table Locking
Advisory Locking


Section 6: Storage Engines (20%)
MySQL Storage Engines
The MyISAM Engine
The MERGE Engine
The InnoDB Engine
The MEMORY Engine
The FEDERATED Engine
The Cluster Storage Engine
Other Storage Engines


Section 7: Data/Table Maintenance (10%)
Types of Table Maintenance Operations
SQL Statements for Table Maintenance
Client and Utility Programs for Table Maintenance
Repairing InnoDB Tables
Enabling MyISAM Auto-Repair


Section 8: The INFORMATION_SCHEMA Database (5%)
INFORMATION_SCHEMA Access Syntax
INFORMATION_SCHEMA Versus SHOW
Limitations of INFORMATION_SCHEMA


Section 9: Data Backup and Recovery Methods (15%)
Introduction
Binary Versus Textual Backups
Making Binary Backups
Making Text Backups
Backing Up Log and Status Files
Replication as an Aid to Backup
MySQL Cluster as Disaster Prevention
Data Recovery
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