Database Developer

Candidates for this certification are expected to be  writing application code against systems that run SQL Server 2008, writing T-SQL or Microsoft .NET CLR code that runs inside SQL Server 2008, or developing solutions in SQL Server 2008.

For details of its  MCTS exam, which covers topics including implementing tables, views and programming objects, query fundamentals and working with XML go to:

Exam 70-433: SQL Server 2008, Database Development

Business Intelligence Developer

Candiates for this certification are expected to be working with SQL Server 2008 and its business intelligence technologies, including Reporting Services, Analysis Services, and Integration Services

To find out about the MCTS exam which tests your ability to implement, configure, deploy and maintain  SQL Server Integration Services (SSIS), SQL Server Analysis Services (SSAS) and SQL Server Reporting Services solutions see :

Exam 70-448: SQL Server 2008, Business Intelligence Development and Maintenance

MCTIP

From MCTS to MCTIP on all three of these career paths involves one more exam These exams are more demanding and candidates usually have at least two to three years of experience.

Candidates for the Microsoft Certified Database Administrator certification, Exam 70-450, are expected to have experience with the following:

• Defining high-availability solutions
• Data distribution
• Automating administrative tasks (for example, checking db stats, backups)
• Maintaining administrative tasks (for example, determining index rebuild time, file groups for backup)
• Defining security solutions
• Monitoring and troubleshooting the database server
• Performance optimization (for example, physical tuning, including hardware, operating system, instance-level tuning), PerfMon
• Designing and executing deployments
• Deployments and migration
• Defining the infrastructure (for example, storage, hardware, and number of servers or instances)

For more information see:

Exam 70-450: PRO: Designing, Optimizing and Maintaining a Database Administrative Solution Using Microsoft SQL Server 2008

Candidates for the Microsoft Certified Database Developer certification, Exam 70-451, are expected to have experience with the following:

• Writing transact SQL queries
• Programming the database
• Troubleshooting programming objects (for example, stored procedures, triggers, user-defined functions [UDFs], user-defined types [UDTs], and queries)
• Database performance tuning and optimization
• Designing databases at both the conceptual and logical levels
• Implementing databases at the physical level
• Might be involved in designing and troubleshooting the data access layer of the application
• Gathering business requirements

Exam 70-451: PRO: Designing Database Solutions and Data Access Using Microsoft SQL Server 2008

Candidates for the Microsoft Certified Business Intelligence Developer certification, Exam 70-452, are expected to have experience with the following:

• Working with SQL Server Analysis Services (SSAS), SQL Server Integration Services (SSIS), and SQL Server Reporting Services (SSRS)
• Using the SQL Server 2005 and SQL Server 2008 Business Intelligence Development Studio (BIDS)
• Designing both relational and multidimensional database schemas
• Writing both relational and multidimensional queries
• Designing and building cubes
• Designing and creating reports
• Applying data mining algorithms to business problem domains
• Aggregating data from multiple sources into a data warehouse in a heterogeneous data environment
• Designing and managing enterprise-level solutions for multidimensional databases
• Collecting and interpreting business requirements

Exam 70-452: PRO: Designing a Business Intelligence Infrastructure Using Microsoft SQL Server 2008

<ASIN:0735626391>

<ASIN:0470183748>

<ASIN:1597494216>

<ASIN:0735626367>

<ASIN:0470554207>