DevShed has a new article posted today - the second part in the "Data Definition Language" series.

Studying for the MySQL Certification exam? This article, the second of two parts, covers the remainder of roughly 20 percent of the material that will appear on the exam, and includes several sections with questions and answers covering both articles. It is excerpted from chapter four of the book MySQL Certification Guide written by Paul Dubois et. al.

Using the things introduced in the previous article in the series, this new article steps through some exercises developed to help you prepare for the exam. Some of the questions range from simple tasks (show the databases on the current server) all the way up to the use of various MySQL functions to insert/update/delete your data. And, of course, they provide the answers to each question, ensuring that you understand where they are coming from...