|
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. |
|