Prior to the examination, I bought the guide book MySQL 5.0 Certification Study Guide from Amazon and read through all the chapters required.
Some important notes:
- Some websites recommended certain chapters or sections to study for the examination. Most of them did not include the Joining Table section.
- Also, do note that for Joining Tables, only INNER JOIN is tested (At least for my examination. There are 4 questions on INNER JOIN).
Here are the exam contexts
Exam Contents - Certified MySQL Associate
- Theory, Terminology and Concepts (10%)
- Client/Server Concepts
- Database and Database Objects
- Data Definition using SQL (25%)
- Databases
- Data Types
- Tables
- Constraints and Indexes
- Views
- Basic Data Manipulation using SQL (25%)
- Recurring SQL Constructs
- Adding data
- Modifying data
- Removing data
- Searching data
- Advanced Data Manipulation using SQL (20%)
- Expressions
- Grouping and Aggregate Functions
- Joining Tables
- Transactions (10%)
- Transaction Concepts
- SQL for working with Transaction
- Import/Export (10%)
- Tools for Import/Export
- SQL for Import/Export
One key tip for the examination is to practise the questions in the CD and do some practice questions which can be found online. Another tip is to try out the examples on an actual MySQL to understand the topics even better.
If you want to take a quick look at some of the MySQL syntax, you can check out my other blog here.
You can check out the price of the exam at the Oracle homepage
I did relatively well for the examination, scoring 92% which means getting 46 out of 50 questions correct. You will know your score immediately after you ended the examination.
If you have any questions on MySQL, do send me an email so that we can discuss about it. Alternatively, you can post it here so that we can share and discuss! :)
No comments:
Post a Comment