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