Microsoft SQL Server 2008 Package

The SQL Server 2008 Package is designed for individuals who create physical database designs, develop logical data models, create physical databases, create data services by using Transact-SQL, manage and maintain databases, configure and manage security, monitor and optimise databases, and install and configure SQL Server.

With the SQL Server Package, you will cover the following modules:

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

Introducing Business Intelligence in Microsoft SQL Server 2008 Implementing Packages and Control Flow in SQL Server Integration Services 2008 Implementing Data Flow in SQL Server Integration Services 2008 Managing Integration Services Packages in SQL Server 2008 Securing and Deploying SQL Server Integration Services 2008 Packages Creating a Multidimensional Solution in SQL Server Analysis Services 2008 Customizing Cube Functionality in SQL Server Analysis Services 2008 Deploying, Managing and Maintaining SQL Server 2008 Analysis Services Implementing Data Mining in SQL Server Analysis Services 2008 Creating Basic Reports in SQL Server Reporting Services 2008 Creating Interactive Reports in SQL Server Reporting Services 2008 Configuring, Deploying and Maintaining SQL Server Reporting Services 2008

Exam 70-433 MCTS: Microsoft SQL Server 2008, Database Development

An Introduction to Transact-SQL in Microsoft SQL Server 2008 Querying and Filtering Data in Microsoft SQL Server 2008 Grouping and Summarizing Data in Microsoft SQL Server 2008 Joining Data from Multiple Tables in Microsoft SQL Server 2008 Working with Subqueries Using Microsoft SQL Server 2008 Modifying Data in Tables with Microsoft SQL Server 2008 Integrated Full Text Search and Returning XML Result Sets in SQL Server 2008 An Introduction to Programming Objects in Microsoft SQL Server 2008 Querying Metadata in Microsoft SQL Server 2008

Exam 70-432 MCTS: Microsoft SQL Server 2008, Implementation and Maintenance

Automating Administrative Tasks in Microsoft SQL Server 2008       Backing Up and Restoring Databases in Microsoft SQL Server 2008         Creating and Managing Databases in Microsoft SQL Server 2008         Implementing High Availability and Replication in Microsoft SQL Server 2008         Installing and Configuring Microsoft SQL Server 2008     Managing Security in Microsoft SQL Server 2008  Monitoring and Controlling Resources in Microsoft SQL Server 2008         Planning, Creating, and Optimizing Indexes in Microsoft SQL Server 2008