Description:

This is the official guide to passing the two MySQL certification tests for MySQL 5, the long-awaited major revision of MySQL. It includes a voucher for 25 percent off either exam-a $50 value! The number of MySQL certification exams taken has doubled in the last six months.

Certcities.com lists the MySQL certification as one of the top 10 certifications to grow in 2005. MySQL professionals need a way to distinguish themselves from the vast majority of database administrators and developers. With more than 4 million active installations, MySQL is the world's most popular open-source database. Known for its speed, reliability and case of use, MySQL has become a low-cost alternative to expensive database systems such as Oracle, IBM and Microsoft. MySQL AB has aggressively improved the feature set of MySQL with MySQL 5, making it more suitable for enterprise-level applications and uses. The MySQL certification tests, available at over 3,000 PearsonVUE testing centers, is a key component of this enterprise growth strategy, establishing a base level of skills for database users, administrators and programmers.

The MySQL Core Certification is aimed at the database user who wants proof of his or her abilities in such fundamental areas as SQL, data entry and maintenance, and data extraction. The MySQL Professional Certification test is designed for the advanced user who wants to prove his or her knowledge in such areas as database management, installation, security, disaster prevention and optimization. Both tests are thoroughly covered in the MySQL Certification Study Guide. Written by Paul DuBois, the leading author of books on MySQL topics, and reviewed for technical accuracy by MySQL AB, this book is the fastest, most reliable way for MySQL users, developers, and administrators to prepare for either of the MySQL tests.

 

Table of Contents:

Introduction.

About This Book.

    Sample Exercises

    Other Required Reading

      Manuals

      Sample Data

      Study Guide Errata

      Certification Information at www.mysql.com

      The MySQL Certification Candidate Guide

      The Certification Mailing List

    Conventions Used in This Book

      Running MySQL on Microsoft Windows

    About the Exams

      Registering for an Exam

      Going to the Exam

      Taking the Exam

      Reading Questions

      Answering Questions

      After the Exam

      Retaking Exams

      Warning

    Interpreting DESCRIBE Output

    Sample Tables

MYSQL DEVELOPER EXAMS.

MySQL Developer I Exam.

1. Client/Server Concepts.

    General MySQL Architecture

    Invoking Client Programs

      General Command Option Syntax

      Connection Parameter Options

      Using Option Files

      Selecting a Default Database

      Establishing a Connection with a GUI Client

    Server SQL Modes

2. The mysql Client Program.

    Using mysql Interactively

    Statement Terminators

    The mysql Prompts

    Using Editing Keys in mysql

    Using Script Files with mysql

    mysql Output Formats

    Client Commands and SQL Statements

Reference demo_5

In stock 297 Items

Data sheet

Compositions

Viscose

Styles

Casual

Properties

Maxi Dress