MySQL 5.0 Developer Certification (225010230)
Issuer: mysql.com

MySQL personal certifications empowers employers, managers, developers and DBAs with

    * Verifiable skills and knowledge
    * Lowered risks
    * Higher service levels
    * Increased customer satisfaction
    * Improved productivity
    * Elimination of costly mistakes
    * Reduced operating costs
    * Increased revenues

MySQL Certification lays the foundation for becoming a trusted and valuable resource for your company and customers. MySQL certifications are available for Developers, DBAs and for those specializing in MySQL Cluster technologies.

Smart consultants, developers and DBAs use MySQL certification to show prospective employers and customers that they are up to date on the latest features, gain confidence that they are on top of MySQL tools and tricks, promote themselves with certification logos on business cards, personal weblogs and job interviews and demonstrate that they can apply their skillset in a business environment.

Effective employers and managers use the MySQL certification program to shortlist candidates and quickly gain a selection of pre-qualified candidates for a job position, validate their investment in MySQL training of their employees, establish a common base of knowledge and skills for project members before embarking on a new task and may use the fact that they retain certified personnel in promotional materials.

Clever customers demand that their contractors and suppliers retain MySQL certified personnel, use MySQL certification to reduce risks and make most of their resources and continuously update the skills of the personnel through MySQL training and certification

Candidates should carefully review the Non Disclosure Agreements and Logo Usage Agreements for the English and Chinese & Japanese examinations before registering for any exam.
Availability

    * Associate (CMA) Certification is an entry level certification that is attained by passing a single exam.
    * Developer (CMDEV) and DBA (CMDBA) Certification is available for MySQL 5.0 and is attained by passing two exams.
    * MySQL Cluster certification for MySQL 5.1 is attained by holders of the CMDBA certification by passing a single exam and is not version specific.

All exams are administered through one of more than 3,000 Pearson VUE testing centers available world-wide.

 

Developer and DBA Tracks
MySQL 5.0 Certification Tracks

An individual holding the Certified MySQL 5.0 Developer (CMDEV) or Certified MySQL 5.0 DBA (CMDBA) certification has extensive and broad competentences in his or her field of expertise.


Each certification focuses on specific application areas, expertise, and job skills. The CMDEV certification is targeted at candidates who will be developing applications that use MySQL as back-end storage, whereas the DBA certification is targeted at candidates who will take the administrative role of tuning, planning, and optimizing data layout for one or many servers, but do not write many applications.

Neither of these certifications implies an advancement level over the other. Rather, each certification covers a distinct area of expertise, aimed at different job roles. Candidates should choose to study for the certification that best suits his or her current or aspired professional position. Some candidates follow both tracks to become an all-round MySQL professional.

http://mysql.com/certification/candidates.php?exam=3

Certified MySQL 5.0 Developer Part I
http://pearsonvue.com/authenticate
Registration Number : 225010230
Validation Number : 453710700


Certified MySQL 5.0 Developer Part II
http://pearsonvue.com/authenticate
Registration Number : 225374771
Validation Number : 978063020

Exam Contents - Certified MySQL Developer - I

• Client/Server Concepts (5%)
  • General MySQL Architecture
  • Invoking Client Programs
  • Server SQL Modes
• The mysql Client Program (10%)
  • Using mysql Interactively
  • Statement Terminators
  • The mysql Prompts
  • Editing Keys in mysql
  • Using Script Files with MySQL
  • mysql Output Formats
  • Client Commands and SQL Statements
  • Using Server-Side Help
  • Using the --safe-updates Option
• Connectors (5%)
  • MySQL Client Interfaces
  • Connector/ODBC
  • Connector/J
  • Connector/NET
• Data Types (15%)
  • Numeric Data Types
  • The BIT Data Type
  • String Data Types
  • Temporal Data Types
  • Column Attributes
  • Using the AUTO_INCREMENT Column Attribute
  • Handling Missing or Invalid Data Values
• Identifiers (5%)
  • Identifier Syntax
  • Case Sensitivity
  • Using Qualifed Names
  • Reserved Words as Identifiers
• Databases (5%)
  • Database Properties
  • Creating Databases
  • Altering Databases
  • Dropping Databases
  • Obtaining Database Metatdata
• Tables and Indexes (15%)
  • Table Properties
  • Creating Tables
  • Altering Tables
  • Emptying Tables
  • Dropping Tables
  • Indexes
  • Dropping Indexes
  • Obtaining Table and Index Metadata
• Querying for Data (15%)
  • Using SELECT to Retrieve Data
  • Specifying Which Columns to Retrieve
  • Specifying Which Rows to Retrieve
  • Aggregating Results
  • Grouping Results
  • Using UNION
• SQL Expressions (15%)
  • Components of SQL Expressions
  • Numeric Expressions
  • String Expressions
  • Temporal Expressions
  • NULL Values
  • Functions in SQL Expressions
  • Comments in SQL Statements
• Updating Data (10%)
  • Update Operations
  • The INSERT Statement
  • The REPLACE Statement
  • The UPDATE Statement
  • The DELETE and TRUNCATE TABLE Statements
  • Privileges Required for Update Statements

Exam Contents - Certified MySQL Developer - II

• Joins (10%)
  • Overview
  • Writing Inner Joins
  • Writing Outer Joins
  • Resolving Name Clashes Using Qualifiers and Aliases
  • Multiple-Table UPDATE and DELETE Statements
• Subqueries (10%)
  • Types of Subqueries
  • Subqueries as Scalar Expressions
  • Correlated Subqueries
  • Comparing Subquery Results to Outer Query Columns
  • Comparison Using Row Subqueries
  • Using Subqueries in the FROM Clause
  • Converting Subqueries to Joins
  • Using Subqueries in Updates
• Views (15%)
  • Reasons to Use Views
  • Creating Views
  • Altering Views
  • Dropping Views
  • Checking Views
  • Displaying Information About Views
  • Privileges for Views
• Importing and Exporting Data (5%)
  • Import and Export Operations
  • Importing and Exporting Using SQL
  • Importing and Exporting Data from the Command Line
• User Variables (5%)
  • User Variable Syntax
  • User Variable Properties
• Prepared Statements (5%)
  • Benefits of Prepared Statements
  • Using Prepared Statements from the mysql Client
  • Preparing a Statement
  • Executing a Prepared Statement
  • Deallocating a Prepared Statement
• Stored Routines (20%)
  • Benefits of Stored Routines
  • Differences Between Stored Procedures and Functions
  • The Namespace for Stored Routines
  • Defining Stored Routines
  • Creating Stored Routines
  • Altering Stored Routines
  • Dropping Stored Routines
  • Invoking Stored Routines
  • Obtaining Stored Routine Metadata
  • Stored Routine Privileges and Execution Security
• Triggers (5%)
  • Reasons to Use Triggers
  • Trigger Concepts
  • Creating a Trigger
  • Restrictions on Triggers
  • Referring to Old and New Column Values
  • Destroying a Trigger
  • Privileges Required for Triggers
• Obtaining Database Metadata (10%)
  • Overview of Metadata Access Methods
  • Using INFORMATION_SCHEMA to Obtain Metadata
  • Using SHOW and DESCRIBE to Obtain Metadata
  • Using mysqlshow to Obtain Metadata
• Debugging MySQL Applications (5%)
  • Interpreting Error Messages
  • The SHOW WARNINGS Statement
  • The SHOW ERRORS Statement
  • The perror Utility
• Basic Optimizations (10%)
  • Overview of Optimization Principles
  • Using Indexes for Optimization
  • General Query Enhancement
  • Choosing Appropriate Storage Engines
  • Normalization

Preview	Attachment	Size
	mysql-5-dev.jpg	81.76 KB