Microsoft SQL Server Certification classes in Brooklyn, NY

Exam

Preparation Course

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