Programmers Point

Site for Programmers

  • Increase font size
  • Default font size
  • Decrease font size
Oracle Certified Associate, MySQL 5.0/5.1/5.5

I passed my Oracle Certified Associate Exam on November 2011 with 92%!! i like to share my experience here. I strongly recommend to read the MySQL 5.0 Certification Study Guide.

This exam is conducted by Oracle.The cost of the exam and other details related to the Oracle Certified Associate, MySQL 5.0/5.1/5.5 can be found in the Oracle Certification Website.

List of topics covered by the MySQL 5.0, 5.1 and 5.5 Certified Associate Exam (CX-310-814) as per the Oracle website:

Section 1: Theory, Terminology and Concepts (10%)

Client/Server Concepts

Database and Database Objects

Section 2: Data Definition using SQL (25%)

Databases

Data Types

Tables

Constraints and Indexes

Views

Section 3: Basic Data Manipulation using SQL (25%)

Recurring SQL Constructs

Adding data

Modifying data

Removing data

Searching data

Section 4: Advanced Data Manipulation using SQL (20%)

Expressions

Grouping and Aggregate Functions

Joining Tables

Section 5: Transactions (10%)

Transaction Concepts

SQL for working with Transaction

Section 6: Import/Export (10%)

Tools for Import/Export

SQL for Import/Export

I would suggest reading these chapters from MySQL 5.0 Certification Study Guide

Chapter 1 and 2

Chapter 5 to 11

Chapter 12, 14 and 15

I will be explaining about how i went reading about each of those topics and what i felt i should have done better in those topics. I hope these articles will be helpful for any one preparing for the exam in the future.

Title Filter     Display # 
# Article Title
1 Oracle Certified Associate, MySQL 5.0/5.1/5.5 : Import/Export
2 Oracle Certified Associate, MySQL 5.0/5.1/5.5 : Transactions
3 Oracle Certified Associate, MySQL 5.0/5.1/5.5 : Advanced Data Manipulation using SQL
4 Oracle Certified Associate, MySQL 5.0/5.1/5.5 : Basic Data Manipulation using SQL
5 Oracle Certified Associate, MySQL 5.0/5.1/5.5 : Data Definition using SQL
6 Oracle Certified Associate, MySQL 5.0/5.1/5.5 : Theory, terminology and concepts
 

poll

Which PHP IDE you use?