70-432: Microsoft SQL Server 2008, Implementation and Maintenance
Audience Profile
Candidates should have one to two years of experience using 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 have jobs in which database administration
is their main area of responsibility, or they work in environments in which databases
are central to their job roles. These job roles include the following:
- IT generalists who work in environments in which SQL Server 2008 R2 is part of an
overall solution
- IT professionals who manage systems that run SQL Server 2008 R2
- IT professionals who work with third-party applications that are built on SQL Server
2008 R2
- Developers who build applications that use SQL Server 2008 R2Is an IT administrator involved in SharePoint installation, configuration, and maintenance.
Credit Toward Certification
When you pass Exam 70-432: TS: Microsoft SQL Server 2008, Implementation
and Maintenance,
you complete the requirements for the following certification(s):
Microsoft Certified Technology Specialist (MCTS): Microsoft SQL Server 2008, Implementation
and Maintenance
Exam 70-432: TS: Microsoft SQL Server 2008, Implementation and Maintenance: counts
as credit toward the following certification(s):
MCSA, MCSE
|
Microsoft SQL Server 2008 - Implementation and Maintenance (70-432)
- 5 day(s)
This course covers these SQL Server 2008 topics: Configure, manage, back up, and
restore databases, Create a partitioned table, index, or indexed view, Configure
services and components to manage your environment, Help prevent unauthorized access
at each security infrastructure layer, Design and deploy high-availability solutions,
Manage SQL Server Agent jobs, alerts, and operators, Identify service, concurrency,
and job execution problems.
|
70-433: Microsoft SQL Server 2008, Database Development
Audience Profile
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 R2 is part of an
overall solution
- IT professionals who manage systems that run SQL Server 2008 R2
- Developers who build applications that use SQL Server 2008 R2
- IT professionals who work with third-party applications that are built on SQL Server
2008 R2
Credit Toward Certification
When you pass Exam 70-433: TS: Microsoft SQL Server 2008, Database Development,
you complete the requirements for the following certification(s):
Microsoft Certified Technology Specialist (MCTS): SQL Server 2008, Database Development
|
Microsoft SQL Server 2008 - Database Development (70-433) - 5 day(s)
This course covers these SQL Server 2008 topics: Create and manage database objects,
Query and modify data; implement subqueries and CTEs, Optimize table structures
and data integrity, Create stored procedures, functions, and triggers, Manage transactions,
error handling, and change tracking, Tune query performance, Implement database
mail, full-text search, Service Broker, scripts, Work with XML and SQLCLR.
|
70-448: Microsoft SQL Server 2008, Business Intelligence Development and Maintenance
Audience Profile
Candidates for this exam are responsible
for creating business intelligence
(BI) solutions by using Microsoft SQL Server 2008 for their organizations. Candidates
typically work with the full suite of BI technologies in SQL Server 2008, including
Reporting Services, Analysis Services, and Integration Services. The qualified candidate for this exam typically has:
- One to two years of experience working with the Microsoft .NET Framework
- Two to three years of experience using SQL Server 2005 BI components
- Six months to one year of experience using SQL Server 2008
- Experience using the SQL Server 2008 Business Intelligence
- Development Studio (BIDS) Experience using Microsoft SQL Server
- Management Studio (SSMS) Knowledge of relational and multi-dimensional database
schemas Experience creating and deploying a cube in SQL Server Analysis Services
(SSAS)
- Experience creating and deploying a data mining model in SSAS
- Experience writing relational and multi-dimensional database queries
- Experience creating and deploying SQL Server Reporting Services (SSRS) reports
- Experience authoring and deploying SQL Server Integration Services (SSIS) packages
- Experience debugging, monitoring, and troubleshooting BI solutions
Credit Toward Certification
When you pass Exam 70-448: TS: Microsoft SQL Server 2008, Business Intelligence
Development and Maintenance, you complete the requirements for the following certification(s):
Microsoft Certified Technology Specialist (MCTS): SQL Server 2008, Business Intelligence
Development and Maintenance
|
Microsoft SQL Server
2008 - Business Intelligence Development (70-448) - 5 day(s)
This course covers these SQL Server 2008 topics: Create SSIS packages; troubleshoot
data flow and control flow, Configure, debug, and deploy SSIS solutions, Develop
SSAS cubes for OLAP and data mining services, Implement custom logic with MDX, Optimize
storage design and query performance, Create SSRS reports; enable interactivity;
write custom code, Manage the report environment, Configure security features for
SSIS, SSAS, and SSRS
|
Download PDF with Full Details