MYSQL 5 Database Admin DVD 1 (2010) | 925.41 MB
Exam 005 002
In addition to prepping you for the first of two MySQL Certified Dabase Admuinistraror (CMDBA) exam certification exams, Tim Warner packs this video series with real-world practical examples and industry advice that you can apply immediately in your MySQL, Oracle, PostgreSQL or Microsoft SQL Server environments.
Once you’ve finished watching these videos, you can choose to round back and pass the baseline Certified MySQL Associate (CMA) exam, or simply take your skills into the workplace and apply those skills to a new or existing job with MySQL or another another relational database management system.
Series 1: MySQL Database 5.0 Administrator 1 005 002
Understanding the Series. Tackling the DBA I Exam.
MySQL Architecture Part 1
Communication Protocols. The SQL Parser and Storage Engine Tiers. Relevant Exam Objectives: Communication Protocols; The SQL Parser and Storage Engine Tiers. Description: In this nugget we peek under the hood in MySQL and examine some of its internals.
MySQL Architecture Part 2
MySQL Disk Space Usage. MySQL Memory Usage. Relevant Exam Objectives: How MySQL Uses Disk Space; How MySQL Uses Memory. Description: In this nugget we learn how the various MySQL storage engines manifest files in the host OS file system. We also learn about the various memory caches used by MySQL to increase performance.
Configuring MySQL Part 1
Types of MySQL Distributions. Starting and Stopping MySQL Server on Windows. Starting and Stopping MySQL Server on Linux. Relevant Exam Objectives: Types of MySQL Distributions; Starting and Stopping MySQL Server on Windows; Starting and Stopping MySQL Server on Unix. Description: In this nugget we differentiate among the potentially confusing array of MySQL Server distributions that are available at the MySQL.com Web site. We also learn how to start, stop, and restart the MySQL daemon on Windows and NIX.
Configuring MySQL Part 2
Runtime MySQL Configuration. Managing MySQL Log Files. Administering Time Zone Tables. Relevant Exam Objectives: Runtime MySQL Configuration; Log and Status Files; Loading Time Zone Tables. Description: In this nugget we learn how to control the MySQL daemon at runtime. We also learn how to view and manage server log files and time zone data.
Configuring MySQL Part 3
Setting the Default SQL Mode. Upgrading MySQL. Relevant Exam Objectives: Setting the Default SQL Mode; Upgrading MySQL. Description: In this nugget we learn all about SQL mode, which deals with how MySQL Server handles invalid and/or out of bounds data. We also consider how to upgrade an existing MySQL server to a newer version.
Using MySQL Client Programs Part 1
Understanding the MySQL Administrative Clients. The mysql Client. The mysqladmin Client. Relevant Exam Objectives: Overview of Administrative Clients; mysql; mysqladmin; Client Program Limitations. Description: In this nugget we conduct a global overview of the MySQL administrative clients. We then perform a deep dive into the mysql and mysqladmin client utilities.
Using MySQL Client Programs Part 2
Using the mysqlimport Utility. Using the mysqldump Utility. Relevant Exam Objectives: Overview of Administrative Clients; mysqlimport; mysqldump; Client Program Limitations. Description: In this nugget we learn how to use the mysqlimport and mysqldump utilities to perform data imports and exports, respectively, with MySQL Server.
Implementing MySQL Security
Managing User Accounts. Granting and Revoking User Privileges. Relevant Exam Objectives: None (bonus content). Description: In this nugget we learn the basics of user account security in MySQL Server.
Managing Character Sets
What are Character Sets and Collations, Anyway? Performance Issues Related to Character Sets. Choosing Data Types for Character Columns. Relevant Exam Objectives: Performance Issues; Choosing Data Types for Character Columns. Description: In this nugget we learn exactly what character sets and collations are and how they work together. We then learn how to optimize database and table performance by selecting the proper character set(s) for each table and the proper data type for each column.
Administering Locking in MySQL
Locking Concepts. Implicit vs. Explicit Locking. Advisory Locking. Relevant Exam Objectives: Locking Concepts; Explicit Table Locking; Advisory Locking. Description: In this nugget we learn the fundamentals of locking in MySQL. We differentiate between implicit and explicit locking, and understand the rudiments of advisory locking and how this relates to MySQL application development.
Managing Storage Engines Part 1
MySQL Storage Engines Overview. The MyISAM Engine. The InnoDB Engine. Relevant Exam Objectives: MySQL Storage Engines; The MyISAM Storage Engine; The InnoDB Storage Engine. Description: In this nugget we learn what storage engines are and precisely how and why they are so useful to MySQL DBAS. We then undertake a detailed considersation of the MyISAM and InnoDB storage engines.
Managing Storage Engines Part 2
The MERGE Storage Engine. The MEMORY Storage Engine. The FEDERATED Storage Engine. Relevant Exam Objectives: MySQL Storage Engines; The MERGE Storage Engine; The MEMORY Engine; The FEDERATED Engine. Description: In this nugget we learn a great deal about the MERGE, MEMORY, and FEDERATED storage engines.
Managing Storage Engines Part 3
The Cluster Storage Engine. The CSV Engine. The BLACKHOLE Storage Engine. Relevant Exam Objectives: MySQL Storage Engines; The Cluster Storage Engine; Other Storage Engines. Description: In this nugget we learn about the Cluster, CSV, and BLACKHOLE storage engines.
MySQL Table Maintenance Part 1
Table Maintenance Options. Table Maintenance via SQL. Table Maintenance via Client Applications. Relevant Exam Objectives: Types of Table Maintenance Operations; SQL Statements for Table Maintenance; Client and Utility Programs for Table Maintenance. Description: In this nugget we examine the native table maintenance tools that are available to DBAs in MySQL Server.
MySQL Table Maintenance Part 2
Repairing Corrupted InnoDB Tables. Automating MyISAM Table Repair. Relevant Exam Objectives: Repairing InnoDB Tables; Enabling MyISAM Auto Repair. Description: In this nugget we learn how to repair corrupted InnoDB tables by using first and third party tools. We also learn how to enable MyISAM table auto repair.
Using the INFORMATION_SCHEMA Database
Accessing INFORMATION_SCHEMA Metadata. Differentiating INFORMATION_SCHEMA from SHOW. Relevant Exam Objectives: INFORMATION_SCHEMA Access Syntax; INFORMATION_SCHEMA Versus SHOW; Limitations of INFORMATION_SCHEMA. Description: In this nugget we learn how to access MySQL metadata by leveraging the INFORMATION_SCHEMA virtual database. We also weigh the relative pros and cons of INFORMATION_SCHEMA versus the MySQL SHOW statements.
MySQL Disaster Recovery Part 1
Binary Versus Text Based Backups. Performing Binary Backups. Relevant Exam Objectives: Binary Versus Textual Backups; Making Binary Backups. Description: In this nugget we discuss the differences between binary and text backups in MySQL Server. We then learn how to perform binary backups.
MySQL Disaster Recovery Part 2
Performing Text Based Backups. Using MySQL Replication as a Means of Backup. Relevant Exam Objectives: Making Text Backups; Replication as an Aid to Backup. Description: In this nugget we learn how to perform text backups, and understand the rudiments of MySQL replication with a focus on leveraging replication for disaster recovery purposes.
MySQL Disaster Recovery Part 3
Backing up the Log and Status Files. MySQL Cluster as Means of Backup. The Data Restore Process. Relevant Exam Objectives: Backing Up Log and Status Files; MySQL Cluster as Disaster Prevention; Data Recovery. Description: In this nugget we learn how to back up the MySQL Server log and status files. We then consider how backup is performed in a MySQL Cluster environment. Finally, we examine how the data restore process works.