When you pass Exam 70-433: TS: Microsoft SQL Server 2008, Database Development, you complete the requirements for the following certification: • Microsoft Certified Technology Specialist (MCTS): SQL Server 2008, Database Development

Candidates should have one to two years of experience using Microsoft SQL Server 2008 or two to three years of experience using a previous version of SQL Server. Candidates for this exam are IT professionals who work in jobs in which database development is their main area of responsibility, or they work in environments in which databases are central to their primary job roles. These job roles include the following: • IT generalists who work in environments in which SQL Server 2008 is part of an overall solution • IT professionals who manage systems that run SQL Server 2008 • Developers who build applications that use SQL Server 2008 • IT professionals who work with third-party applications that are built on SQL Server 2008

This course provides students with the knowledge and skills to implement a Microsoft SQL Server 2008 database. The course focuses on teaching individuals how to use SQL Server 2008 product features and tools related to implementing a database.

Before attending this course, students must have: • Basic knowledge of the Microsoft Windows operating system and its core functionality. • Working knowledge of Transact-SQL. • Working knowledge of relational databases. • Some experience with database design.

• Create and alter tables and views, indexes.
  Implementing Programming Objects
  
• Working with Query Fundamentals
  
• Applying Additional Query Techniques
  
• Working with Additional SQL Server Components
  
• Working with XML Data
  Gathering Performance Information