GeekAustin free class - MySQL Associate Certification Prep

Here's the scoop. The class begins on Wednesday February 11th, and will meet every Wednesday, 7:15PM, at Union Park downtown, for eight weeks. Sun charges $1995.00 for this same class. The GeekAustin class is free. We still have a few seats left.

There are three core MySQL certifications: 1)MySQL Associate, 2) MySQL DBA, and 3) MySQL Developer. The MySQL Associate certification is not tied to any particular version of MySQL, but focuses on details of using MySQL that are universal no matter what version of the software you are using.

It is our goal to prepare you to successfully pass the test by the time you complete the class.

Although the class is free, you will be required to have a copy of the MySQL 5.0 Certification Guide. You can purchase it online at Amazon, BookPool, or NerdBooks. You can also save money by reading it online at Safari. You will not be required to read the whole book -- only about a third of it.

You will also be required to have MySQL installed on a computer. For the Associate certification, it doesn't matter whether you use Linux or Windows. The test covers material common to all versions of MySQL.

This is what the exam covers:

• 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

We will cover all the above material in the class. We have keyed the course material to the book, so that you won't have to waste time covering material which may not be on the test.

We will only be teaching this class one time this year. The remaining seats are first come, first served. To sign up, send an email to linearb@gmail.com

-Lynn