1Z0-873: MySQL 5 Database Administrator Certified Professional Exam, Part I

Placeholder

1Z0-873: MySQL 5 Database Administrator Certified Professional Exam, Part I

1Z0-873: MySQL 5 Database Administrator Certified Professional Exam, Part I

Dit examen is onderdeel van de Oracle Certified Professional certificering.

Trainingen

Exameneisen

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

SKU: 1Z0-873 Categorieën: , ,
Meer weten over een training of advies? Bel met onze opleidingsadviseurs 085 02 01 070 of gebruik het contactformulier.