Free register and download UseNet downloader, then you can FREE Download from UseNet.

    Download without Limit " CBT Nuggets - MySQL 5.0 Database Administrator 1 (Exam 005-002) " from UseNet for FREE!

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.
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.
* Video 1: Series Overview|20:43
Understanding the Series. Tackling the DBA I Exam.
* Video 2: MySQL Architecture Part 1|43:40
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.
* Video 3: MySQL Architecture Part 2|47:36
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.
* Video 4: Configuring MySQL Part 1|36:34
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.
* Video 5: Configuring MySQL Part 2|51:51
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.
* Video 6: Configuring MySQL Part 3|40:11
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.
* Video 7: Using MySQL Client Programs Part 1|46:53
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.
* Video 8: Using MySQL Client Programs Part 2|24:37
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.
* Video 9: Implementing MySQL Security|41:12
Managing User ***s. Granting and Revoking User Privileges. Relevant Exam Objectives: None (bonus content). Description: In this nugget we learn the basics of user*** security in MySQL Server.
* Video 10: Managing Character Sets|30:28
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.
* Video 11: Administering Locking in MySQL|30:39
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.
* Video 12: Managing Storage Engines Part 1|31:20
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.
* Video 13: Managing Storage Engines Part 2|36:29
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.
* Video 14: Managing Storage Engines Part 3|21:15
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.
* Video 15: MySQL Table Maintenance Part 1|25:42
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.
* Video 16: MySQL Table Maintenance Part 2|20:33
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.
* Video 17: Using the INFORMATION_SCHEMA Database|30:15
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.
* Video 18: MySQL Disaster Recovery Part 1|31:35
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.
* Video 19: MySQL Disaster Recovery Part 2|22:35
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.
* Video 20: MySQL Disaster Recovery Part 3|22:13
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.
Homepage: http://www.cbtnuggets.com/series?id=566