Expert Wayne Snyder explains and demonstrates the tools and technologies for maintaining a database and shows complete implementation procedures including creating data types, using tables, constraints, triggers, and XML schemas. Students should have a basic knowledge of Transact-SQL along with familiarity of database design. This course, combined with TrainingSol's SQL Server 2005 Writing Queries and SQL Server 2005 Implementing a Database will prepare you for the Microsoft MCTS exam 70-431.