Exam 70-432: TS: Microsoft SQL Server 2008 R2 - Implementation and Maintenance Curriculum Outline
SQL Server 2008 R2: Installation
Overview/Description
SQL Server 2008 R2 is a comprehensive database platform, consisting of components and management tools such as SQL Server Management Studio, Business Intelligence Development studio, and the SQL Server Database Engine. These tools allow administrators and developers to build and maintain software solutions, and perform required functions in a server environment. This course identifies SQL Server 2008 R2 components and management tools, and outlines the requirements for installing SQL Server 2008 R2. The steps required to complete a fresh installation of a SQL Server 2008 R2 instance and how to upgrade a SQL Server instance are also explored. This course is one of a series in the SkillSoft learning path that covers the objectives for Microsoft SQL Server 2008 exam number 70-432. Passing this exam will earn the learner the Microsoft Certified Technology Specialist (MCTS): Microsoft SQL Server 2008, Implementation and Maintenance certification.
Target Audience
Professionals typically pursuing a career as a Database Administrator; individuals who dont work directly with SQL Server as part of their primary job but wish to show their breadth of technology experience, including developers and systems administrators.
Prerequisites
One to two years of experience using SQL Server 2008, SQL Server 2008 R2, or two to three years of experience using a previous version of SQL Server
Expected Duration (hours)
1.5
Lesson Objectives
SQL Server 2008 R2: Installation
md_mcir_a01_it_enus <
Back to List
SQL Server 2008 R2: Instance and Database Configuration
Overview/Description
SQL Server 2008 R2s core component is its Database Engine, which provides storage, processing, and security for enterprise data through its controlled access and rapid transaction processing. Another feature of SQL Server 2008 R2 is the SQL Server Management Studio graphical user tool which allows administrators and developers to create and configure instances and databases on an enterprise level. SQL Server 2008 R2 also includes the SQL Server Configuration Manager for managing SQL Server services, SQL Server network configuration, and SQL Native Client. This course addresses how to configure a SQL Server instance and how to create a new database using SQL Server Management Studio and SQL Server Configuration Manager. This course is one of a series in the SkillSoft learning path that covers the objectives for Microsoft SQL Server 2008 exam number 70-432. Passing this exam will earn the learner the Microsoft Certified Technology Specialist (MCTS): Microsoft SQL Server 2008, Implementation and Maintenance certification.
Target Audience
Professionals typically pursuing a career as a Database Administrator; individuals who dont work directly with SQL Server as part of their primary job but wish to show their breadth of technology experience, including developers and systems administrators.
Prerequisites
One to two years of experience using SQL Server 2008, SQL Server 2008 R2 or two to three years of experience using a previous version of SQL Server
Expected Duration (hours)
2.0
Lesson Objectives
SQL Server 2008 R2: Instance and Database Configuration
md_mcir_a02_it_enus <
Back to List
SQL Server 2008 R2: Security Management
Overview/Description
Microsoft SQL Server 2008 R2 provides enhanced security features to ensure that each instance is secure. Using SQL Server 2008 R2 security features, administrators can guarantee that access to a SQL Server instance is granted only to specified users, using either Windows Authentication or Mixed Mode Authentication by creating logins and then mapping the logins to the databases within the instance. Administrators also have the ability to encrypt a SQL Server instance using transparent data encryption (TDE) and to encrypt the data within a database using encryption certificates and asymmetric and symmetric keys. Impersonation is another SQL Server security feature, which is used to make sure that the person who accesses the database has the appropriate permissions to complete the task, for example, running a specific stored procedure to access underlying objects. This course demonstrates how to create SQL Server logins, database users, and how to grant permissions, including server and database roles. It also addresses how to use encryption to protect a database and database data, how to use impersonation using the EXECUTE AS clause, and how to configure auditing to monitor access to SQL Server. This course is one of a series in the SkillSoft learning path that covers the objectives for Microsoft SQL Server 2008 exam number 70-432. Passing this exam will earn the learner the Microsoft Certified Technology Specialist (MCTS): Microsoft SQL Server 2008, Implementation and Maintenance certification.
Target Audience
Professionals typically pursuing a career as a Database Administrator; individuals who dont work directly with SQL Server as part of their primary job but wish to show their breadth of technology experience, including developers and systems administrators.
Prerequisites
One to two years of experience using SQL Server 2008, SQL Server 2008 R2 or two to three years of experience using a previous version of SQL Server
Expected Duration (hours)
2.0
Lesson Objectives
SQL Server 2008 R2: Security Management
md_mcir_a03_it_enus <
Back to List
SQL Server 2008 R2: Database Management
Overview/Description
Database maintenance is an ongoing task for SQL Server 2008 R2 administrators. This requires the integrity of the database to be checked, the database size to be kept to a minimum by ensuring the files are the correct sizes, and maintenance tasks to be run regularly. SQL Server 2008 R2 Transact-SQL provides DBCC statements, which in turn provides statements to maintain the database and database files. An administrator can also use maintenance plans to run a series of tasks on specific databases using a schedule or on demand. This course demonstrates how to confirm the integrity of a database, manage database files, and how to create maintenance plans using a wizard or the designer. The course also addresses how to move data between SQL Server instances using detach and attach methods and the Copy Database Wizard, and how to move database files within the same SQL Server instance. SQL Server Agent and Policy-Based Management is also covered to demonstrate how to manage SQL Server 2008 R2. This course is one of a series in the SkillSoft learning path that covers the objectives for Microsoft SQL Server 2008 exam number 70-432. Passing this exam will earn the learner the Microsoft Certified Technology Specialist (MCTS): Microsoft SQL Server 2008, Implementation and Maintenance certification.
Target Audience
Professionals typically pursuing a career as a Database Administrator; individuals who dont work directly with SQL Server as part of their primary job but wish to show their breadth of technology experience, including developers and systems administrators.
Prerequisites
One to two years of experience using SQL Server 2008, SQL Server 2008 R2, or two to three years of experience using a previous version of SQL Server
Expected Duration (hours)
2.0
Lesson Objectives
SQL Server 2008 R2: Database Management
md_mcir_a04_it_enus <
Back to List
SQL Server 2008 R2: Data Management
Overview/Description
SQL Server 2008 R2 provides table and index partitioning to allow data to be stored across multiple filegroups within a database. This makes tables and indexes that contain large amounts of data more manageable. Partitions in the database may need to be split to allow for more data to be stored, or data from one partition may need to be moved to another partition. SQL Server 2008 R2 provides Transact-SQL statements to ensure that administrators can perform these tasks to manage the table partitions. SQL Server also provides data compression at the table row and page level. Indexes can be created to allow for the quick retrieval of data from database tables. Administrators need to monitor and manage these indexes to ensure that they are being used efficiently. Importing and exporting data provides a way for database administrators to move data between tables, databases, and servers. This course demonstrates how to manage table partitions, configure data compression, as well as create and manage indexes in a database. It also shows how to import data using the BULK INSERT and OPENROWSET (BULK...) statements and how to import or export data using the bcp utility and the Import and Export Wizard. This course is one of a series in the SkillSoft learning path that covers the objectives for Microsoft SQL Server 2008 R2 exam number 70-432. Passing this exam will earn the learner the Microsoft Certified Technology Specialist (MCTS): Microsoft SQL Server 2008 R2, Implementation and Maintenance certification.
Target Audience
Professionals typically pursuing a career as a Database Administrator; individuals who dont work directly with SQL Server as part of their primary job but wish to show their breadth of technology experience, including developers and systems administrators.
Prerequisites
One to two years of experience using SQL Server 2008, SQL Server 2008 R2, or two to three years of experience using a previous version of SQL Server
Expected Duration (hours)
2.5
Lesson Objectives
SQL Server 2008 R2: Data Management
md_mcir_a05_it_enus <
Back to List
SQL Server 2008 R2: Database Monitoring and Performance
Overview/Description
To keep SQL Server 2008 R2 databases running as efficiently as possible, administrators use a variety of performance tuning and monitoring tools. The SQL Server Profiler enables administrators to use trace files and logs to analyze a databases performance. They can also use the Windows System Monitor to monitor SQL Server 2008 R2 using counters, which monitor specific aspects of the server for performance issues. SQL Server 2008 R2 includes the Activity Monitor, which provides an overview of the systems performance in real-time. And the Database Engine Tuning Advisor enables administrators to analyze a databases workload and then implement recommendations to provide better performance for the database. SQL Server 2008 R2 provides a Resource Monitor, which allocates specific resources, and a data collector, which collects specific data and stores it in a management data warehouse. In SQL Server 2008 R2, concurrency issues may arise that require the administrator to intervene by detecting the locking issue and possibly terminating a process that could be blocking a session from performing its task. Concurrency issues can arise when multiple users are trying to access the same data in a database. This course demonstrates how to use SQL Server Profiler, the Database Engine Tuning Advisor, Resource Monitor, and the data collector to monitor and tune the performance of the database. It also addresses how to use the Windows System Monitor, Activity Monitor, and how to detect and resolve locks. This course is one of a series in the SkillSoft learning path that covers the objectives for Microsoft SQL Server 2008 exam number 70-432. Passing this exam will earn the learner the Microsoft Certified Technology Specialist (MCTS): Microsoft SQL Server 2008, Implementation and Maintenance certification.
Target Audience
Professionals typically pursuing a career as a Database Administrator; individuals who dont work directly with SQL Server as part of their primary job but wish to show their breadth of technology experience, including developers and systems administrators.
Prerequisites
One to two years of experience using SQL Server 2008, SQL Server 2008 R2, or two to three years of experience using a previous version of SQL Server
Expected Duration (hours)
2.5
Lesson Objectives
SQL Server 2008 R2: Database Monitoring and Performance
md_mcir_a06_it_enus <
Back to List
SQL Server 2008 R2: Backups, Restores, and Database Snapshots
Overview/Description
Enterprises use databases to store their most critical data. To protect and ensure the datas availability, database administrators need to establish a solid backup and restoration plan. Such plans are used to protect data in the event of a disaster by allowing complete sets of duplicate data to be restored in a timely fashion. There are multiple types of backups that can be taken to ensure the recovery of data, including a full recovery or a point-in-time recovery. SQL Server 2008 R2 also offers database snapshots, which can be used to revert a database to a specific point when the snapshot was taken. This helps to store historical data and provides protection against administrative errors. This course demonstrates how to perform backup and recovery operations, as well as how to create database snapshots and revert to a database snapshot. This course is one of a series in the SkillSoft learning path that covers the objectives for Microsoft SQL Server 2008 exam number 70-432. Passing this exam will earn the learner the Microsoft Certified Technology Specialist (MCTS): Microsoft SQL Server 2008, Implementation and Maintenance certification.
Target Audience
Professionals typically pursuing a career as a Database Administrator; individuals who dont work directly with SQL Server as part of their primary job but wish to show their breadth of technology experience, including developers and systems administrators.
Prerequisites
One to two years of experience using SQL Server 2008, SQL Server 2008 R2, or two to three years of experience using a previous version of SQL Server
Expected Duration (hours)
1.5
Lesson Objectives
SQL Server 2008 R2: Backups, Restores, and Database Snapshots
md_mcir_a07_it_enus <
Back to List
SQL Server 2008 R2: High Availability
Overview/Description
SQL Server 2008 R2 provides several key features that improve the availability of servers and databases so that downtime for users is minimized. These solutions include database mirroring, log shipping, replication, and failover clusters. These reliability features help administrators maintain multiple sets of data that help ensure that critical systems remain accessible, and can be fully recovered in the event of a disaster. This course addresses how to configure database mirroring, log shipping, replication, and failover clusters to ensure that SQL Server 2008 R2 environments are available to users at all times by providing a high-availability and complete disaster-recovery solution. This course is one of a series in the SkillSoft learning path that covers the objectives for Microsoft SQL Server 2008 exam number 70-432. Passing this exam will earn the learner the Microsoft Certified Technology Specialist (MCTS): Microsoft SQL Server 2008, Implementation and Maintenance certification.
Target Audience
Professionals typically pursuing a career as a Database Administrator; individuals who dont work directly with SQL Server as part of their primary job but wish to show their breadth of technology experience, including developers and systems administrators.
Prerequisites
One to two years of experience using SQL Server 2008, SQL Server 2008 R2, or two to three years of experience using a previous version of SQL Server
Expected Duration (hours)
2.0
Lesson Objectives
SQL Server 2008 R2: High Availability
md_mcir_a08_it_enus <
Back to List
Mentoring 70-432 TS: Microsoft SQL Server 2008, Implementation and Maintenance
Overview/Description
SkillSoft Mentors are available to help students with their studies for exam 70-432 TS: Microsoft SQL Server 2008, Implementation and Maintenance. You can reach them by entering a Mentored Chat Room or by using the E-mail My Mentor service.
Target Audience
Individuals who are studying the associated SkillSoft content in preparation for, or to become familiar with, the skills and competencies being measured by the actual certification exam.
Prerequisites
Familiarity with the exam objectives listed below and skills and competencies being measured in the associated certification exam.
Expected Duration (hours)
0.0
Lesson Objectives
Mentoring 70-432 TS: Microsoft SQL Server 2008, Implementation and Maintenance
mnt70432 <
Back to List
TestPrep 70-432 TS: Microsoft SQL Server 2008, Implementation and Maintenance
Overview/Description
To test your knowledge on the skills and competencies being measured by the vendor certification exam*. TestPrep can be taken in either Study or Certification mode. Study mode is designed to maximize learning by not only testing your knowledge of the material, but also by providing additional information on the topics presented. Certification mode is designed to test your knowledge of the material within a structured testing environment, providing valuable feedback at the end of the test.
* This TestPrep has been updated for SQL Server 2008 R2.
Target Audience
Individuals seeking practice in a structured testing environment, covering the skills and competencies being measured by the vendor certification exam.
Expected Duration (hours)
2.0
Lesson Objectives
TestPrep 70-432 TS: Microsoft SQL Server 2008, Implementation and Maintenance
Course Number:md_mcim_a01_tp_enus <
Back to List
Exam 70-433: TS: Microsoft SQL Server 2008 R2 - Database Development Curriculum Outline
SQL Server 2008 R2: Creating and Implementing Database Objects
Overview/Description
SQL Server 2008 R2 is a robust database system that provides a number of database objects used to store and view data. In order to configure a SQL Server 2008 R2 database to meet business requirements, administrators and developers must fully understand how to design, create, and configure these database objects. These objects include tables for storing data in the database, views to allow access to the data within specific tables, and indexes to optimize the performance of the database for data retrieval. This course identifies each of these database objects and demonstrates the steps required to administer them within the SQL Server 2008 R2 Management Studio tool. This course is one of a series in the SkillSoft learning path that covers the objectives for the Microsoft exam: 70-433 TS: Microsoft SQL Server 2008, Database Development. Passing this exam will earn the learner Microsoft Certified Technology Specialist (MCTS): SQL Server 2008, Database Development certification.
Target Audience
IT professionals who have jobs in which database administration is their main area of responsibility, or who work in environments in which databases are central to their job roles. These job roles include ™ 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 ™ IT professionals who work with third-party applications that are built on SQL Server 2008 or SQL Server 2008 R2 ™ Developers who build applications that use SQL Server 2008 or SQL Server 2008 R2
Prerequisites
The prerequisites for the exam are that candidates should have one to two years of experience using Microsoft SQL Server 2008, SQL Server 2008 R2, or two to three years of experience using a previous version of SQL Server.
Expected Duration (hours)
2.5
Lesson Objectives
SQL Server 2008 R2: Creating and Implementing Database Objects
md_msdr_a01_it_enus <
Back to List
SQL Server 2008 R2: Creating and Altering Partitions
Overview/Description
SQL Server 2008 R2 offers the use of partitions to manage subsets of data for large tables and indexes. Partitions can be used to improve the read/write performance on tables within a database by allowing the data within tables to be spread across multiple filegroups, whereas standard tables must be contained within a single filegroup. Data that is stored within partitions is treated as a logical entity, and the partitioned tables and indexes support the same properties as a standard table. SQL Server 2008 R2 allows views to be partitioned, which joins data from multiple tables from one or more servers. The data is returned as one set of information, making it appear as if it were from one table within one database. When partitioned views are used to access multiple tables from various servers they are known as distributed partitioned views. These are used to gather data from independent servers or a federation of servers. This course demonstrates how to create and manage such partitioned tables and indexes, and distributed partitioned views. This course is one of a series in the SkillSoft learning path that covers the objectives for the Microsoft exam: 70-433 TS: Microsoft SQL Server 2008, Database Development. Passing this exam will earn the learner Microsoft Certified Technology Specialist (MCTS): SQL Server 2008, Database Development certification.
Target Audience
IT professionals who have jobs in which database administration is their main area of responsibility, or who work in environments in which databases are central to their job roles. These job roles include ™ 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 R2
Prerequisites
The prerequisites for the exam are that candidates should have one to two years of experience using Microsoft SQL Server 2008, SQL Server 2008 R2, or two to three years of experience using a previous version of SQL Server.
Expected Duration (hours)
1.0
Lesson Objectives
SQL Server 2008 R2: Creating and Altering Partitions
md_msdr_a02_it_enus <
Back to List
SQL Server 2008 R2: Running Queries and Manipulating Data
Overview/Description
SQL Server 2008 R2 includes the SQL Server Management Studio which allows access to SQL Server databases and enables you to access database data. This data can be retrieved and modified through the use of Transact-SQL within the Query Edit window of the Management Studio tool. Using Transact-SQL you can select data from a database’s tables and filter the results to include only the data that you require. Transact-SQL statements also allow you to update, change, and remove data from tables. This course identifies the basic T-SQL statements that can be used to retrieve and modify data within SQL Server databases. This course is one of a series in the SkillSoft learning path that covers the objectives for the Microsoft exam: 70-433 TS: Microsoft SQL Server 2008, Database Development. Passing this exam will earn the learner Microsoft Certified Technology Specialist (MCTS): SQL Server 2008, Database Development certification.
Target Audience
IT professionals who have jobs in which database administration is their main area of responsibility, or who work in environments in which databases are central to their job roles. These job roles include • 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 R2
Prerequisites
The prerequisites for the exam are that candidates should have one to two years of experience using Microsoft SQL Server 2008, SQL Server 2008 R2, or two to three years of experience using a previous version of SQL Server.
Expected Duration (hours)
1.5
Lesson Objectives
SQL Server 2008 R2: Running Queries and Manipulating Data
md_msdr_a03_it_enus <
Back to List
SQL Server 2008 R2: Performing Avanced Query Techniques
Overview/Description
Transact-SQL offers advanced query techniques, such as built-in aggregate, scalar, and ranking functions, and common table expressions to manipulate the result set for a query. To manipulate the result sets and generate rollup information, such as totals, the CUBE, GROUPING SETS, and ROLLUP operators can be used with the GROUP BY statement. UNION, INTERSECT, and EXCEPT can be used to gather specific results in a query. Transact-SQL also provides features that manage international concerns with regards to stored data, such as the collation and sort order. This course demonstrates how to perform advanced query techniques to manipulate data. It also identifies how to work with the COLLATE clause to manage international considerations when working with data. This course is one of a series in the SkillSoft learning path that covers the objectives for the Microsoft exam: 70-433 TS: Microsoft SQL Server 2008, Database Development. Passing this exam will earn the learner Microsoft Certified Technology Specialist (MCTS): SQL Server 2008, Database Development certification.
Target Audience
IT professionals who have jobs in which database administration is their main area of responsibility, or who work in environments in which databases are central to their job roles. These job roles include ™ 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 R2
Prerequisites
The prerequisites for the exam are that candidates should have one to two years of experience using Microsoft SQL Server 2008, SQL Server 2008 R2, or two to three years of experience using a previous version of SQL Server.
Expected Duration (hours)
1.0
Lesson Objectives
SQL Server 2008 R2: Performing Avanced Query Techniques
md_msdr_a04_it_enus <
Back to List
SQL Server 2008 R2: Implementing Programming Objects
Overview/Description
In SQL Server 2008 R2 you can use Transact-SQL statements to access data in the databases. Transact-SQL statements can be grouped together in a number of ways to create more complex queries when one Transact-SQL statement will not retrieve the desired results. You can group Transact-SQL statements by creating programming objects within a database. These programming objects include stored procedures, functions, and triggers (based on either DML or DDL statements). SQL Server 2008 R2 provides integration with Common-runtime language (CLR). This enables a developer to create programming objects using any of the Microsoft .NET Framework languages and then deploy them within SQL Server using assemblies. This course demonstrates how to create user-defined functions, DML and DDL triggers, and stored procedures, as well as how to use the control of flow language in transactions and handle any errors that might arise within them using TRY...CATCH, RAISERROR, and @@ERROR. The course also demonstrates how to use CLR integration in SQL Server 2008 by deploying CLR code into SQL Server. This course is one of a series in the SkillSoft learning path that covers the objectives for the Microsoft exam: 70-433 TS: Microsoft SQL Server 2008, Database Development. Passing this exam will earn the learner Microsoft Certified Technology Specialist (MCTS): SQL Server 2008, Database Development certification.
Target Audience
IT professionals who have jobs in which database administration is their main area of responsibility, or who work in environments in which databases are central to their job roles. These job roles include ™ 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 R2
Prerequisites
The prerequisites for the exam are that candidates should have one to two years of experience using Microsoft SQL Server 2008, SQL Server 2008 R2, or two to three years of experience using a previous version of SQL Server.
Expected Duration (hours)
2.0
Lesson Objectives
SQL Server 2008 R2: Implementing Programming Objects
md_msdr_a05_it_enus <
Back to List
SQL Server 2008 R2: Querying and Managing XML Data
Overview/Description
XML has been integrated into SQL Server 2008 R2 so that XML data can be stored within databases using the XML data type. You can query this data using the XQuery language within the XML data type methods. SQL Server 2008 R2 also provides support for using FOR XML to extract relational data from a database in XML format and the use of OPENXML to generate relational views from XML. This course demonstrates how to use the xml data type, XML schema collations, and how to create XML indexes. It also explores how to retrieve data using FOR XML, process XML data using OPENXML, and how to query data using the XQuery language. This course is one of a series in the SkillSoft learning path that covers the objectives for the Microsoft exam: 70-433 TS: Microsoft SQL Server 2008, Database Development. Passing this exam will earn the learner Microsoft Certified Technology Specialist (MCTS): SQL Server 2008, Database Development certification.
Target Audience
IT professionals who have jobs in which database administration is their main area of responsibility, or who work in environments in which databases are central to their job roles. These job roles include ™ 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 R2
Prerequisites
The prerequisites for the exam are that candidates should have one to two years of experience using Microsoft SQL Server 2008, SQL Server 2008 R2, or two to three years of experience using a previous version of SQL Server.
Expected Duration (hours)
2.0
Lesson Objectives
SQL Server 2008 R2: Querying and Managing XML Data
md_msdr_a06_it_enus <
Back to List
SQL Server 2008 R2: Messaging, Full-Text Search, Scripts, and Track Changes
Overview/Description
SQL Server 2008 R2 provides many components to ensure that database developers can perform many tasks within the database without having to create custom applications. SQL Servers Service Broker component allows developers to create applications that can work with other SQL Server components to complete a specific task by communicating using messages to relay the task information within the instance or between instances of SQL Server 2008 R2. SQL Server 2008 R2 also offers a way for developers to track changes within the database using either change tracking or change data capture. SQL Servers full-text search component can be implemented to ensure that specific data is returned based on search words and phrases. PowerShell has been integrated into SQL Server and offers cmdlets to perform actions on database objects using methods within SQL Server Management Object (SMO) models, and to run scripts to perform tasks within SQL Server. Developers can also use Database Mail to send messages to mail accounts within a profile. This course demonstrates how to implement Server Broker, change tracking, full-text search, and Database Mail. It also demonstrates how to invoke and use PowerShell to run scripts and perform actions on objects. This course is one of a series in the SkillSoft learning path that covers the objectives for the Microsoft exam: 70-433 TS: Microsoft SQL Server 2008, Database Development. Passing this exam will earn the learner Microsoft Certified Technology Specialist (MCTS): SQL Server 2008, Database Development certification.
Target Audience
IT professionals who have jobs in which database administration is their main area of responsibility, or who work in environments in which databases are central to their job roles. These job roles include ™ 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 R2
Prerequisites
The prerequisites for the exam are that candidates should have one to two years of experience using Microsoft SQL Server 2008, SQL Server 2008 R2, or two to three years of experience using a previous version of SQL Server.
Expected Duration (hours)
2.5
Lesson Objectives
SQL Server 2008 R2: Messaging, Full-Text Search, Scripts, and Track Changes
md_msdr_a07_it_enus <
Back to List
SQL Server 2008 R2: Gathering Performance Data
Overview/Description
In order to keep SQL Server 2008 R2 running as efficiently as possible, SQL Server 2008 R2 provides a variety of performance tuning and optimization utilities. Among these utilities are the SQL Server Profiler and the Database Engine Tuning Advisor. The SQL Server Profiler allows you to use trace files and logs to analyze your database’s performance. The Database Engine Tuning Advisor allows you to analyze a database’s workload and effectively configure the physical design structure of databases based on your analysis. SQL Server 2008 R2 offers the ability to view the actual or planned execution plan for queries to ensure transactions are executed with the most efficient path possible. Another set of diagnostic tools provided by SQL Server 2008 R2 are the Dynamic Management Views (DMVs), which help you monitor the health of a server and diagnose problems that may be occurring. This course demonstrates how to view execution plans for transactions and how to use SQL Server Profiler to monitor the databases. It also demonstrates how to tune a database using a workload in Database Engine Tuning Advisor tool and how to use DMVs and catalog views to view system metadata. This course is one of a series in the SkillSoft learning path that covers the objectives for the Microsoft exam: 70-433 TS: Microsoft SQL Server 2008, Database Development. Passing this exam will earn the learner Microsoft Certified Technology Specialist (MCTS): SQL Server 2008, Database Development certification.
Target Audience
IT professionals who have jobs in which database administration is their main area of responsibility, or who work in environments in which databases are central to their job roles. These job roles include • 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 R2
Prerequisites
The prerequisites for the exam are that candidates should have one to two years of experience using Microsoft SQL Server 2008, SQL Server 2008 R2, or two to three years of experience using a previous version of SQL Server
Expected Duration (hours)
1.5
Lesson Objectives
SQL Server 2008 R2: Gathering Performance Data
md_msdr_a08_it_enus <
Back to List
Mentoring 70-433 TS: Microsoft SQL Server 2008, Database Development
Overview/Description
SkillSoft Mentors are available to help students with their studies for exam 70-433 TS: Microsoft SQL Server 2008, Database Development. You can reach them by entering a Mentored Chat Room or by using the E-mail My Mentor service.
Target Audience
Individuals who are studying the associated SkillSoft content in preparation for, or to become familiar with, the skills and competencies being measured by the actual certification exam.
Prerequisites
Familiarity with the exam objectives listed below and skills and competencies being measured in the associated certification exam.
Expected Duration (hours)
0.0
Lesson Objectives
Mentoring 70-433 TS: Microsoft SQL Server 2008, Database Development
mnt70433 <
Back to List
TestPrep 70-433 TS: Microsoft SQL Server 2008, Database Development
Overview/Description
To test your knowledge on the skills and competencies being measured by the vendor certification exam*. TestPrep can be taken in either Study or Certification mode. Study mode is designed to maximize learning by not only testing your knowledge of the material, but also by providing additional information on the topics presented. Certification mode is designed to test your knowledge of the material within a structured testing environment, providing valuable feedback at the end of the test.
* This TestPrep has been updated for SQL Server 2008 R2.
Target Audience
Individuals seeking practice in a structured testing environment, covering the skills and competencies being measured by the vendor certification exam.
Expected Duration (hours)
2.6
Lesson Objectives
TestPrep 70-433 TS: Microsoft SQL Server 2008, Database Development
Course Number:md_msdd_a01_tp_enus <
Back to List
Exam 70-448: TS: Microsoft SQL Server 2008 - Business Intelligence Development and Maintenance Curriculum Outline
Implementing SQL Server 2008 Integration Services
Overview/Description
Microsoft SQL Server 2008 offers a combination of powerful Business Intelligence services to help clients develop and manage sophisticated business intelligence solutions. With the Database Engine at its core, SQL Server 2008 offers integration, reporting, and analysis tools to access and process the data necessary to create business solutions. This course gives an overview of the importance of business intelligence in todays competitive market and introduces the capabilities provided by SQL Server 2008 Integration Services, Reporting Services, and Analysis Services. It then focuses on the use of SQL Integration Services as a data integration solution and outlines the installation and configuration of this server component. The course also covers the key utilities used to configure and manage Integration Services, including the SQL Server Management Studio, Business Intelligence Development Studio, configuration wizards, and command-line tools. This course is one of a series in the SkillSoft learning path that covers the objectives for the Microsoft exam: 70-448 TS: Microsoft SQL Server 2008, Business Intelligence Development and Maintenance. Passing this exam will earn the learner Microsoft Certified Technology Specialist (MCTS): SQL Server 2008, Business Intelligence Development and Maintenance certification.
Target Audience
IT professionals working to develop and maintain Microsoft SQL Server 2008 business intelligence solutions or those pursuing a career as a database administrator or developer
Prerequisites
Familiarity with Microsoft .NET Framework; experience with SQL Server 2005 or SQL Server 2008 business intelligence components; experience performing queries on relational databases and using SQL Server Management Studio and Business Intelligence Development Studio
Expected Duration (hours)
1.5
Lesson Objectives
Implementing SQL Server 2008 Integration Services
md_mqbm_a01_it_enus
Back to List
Configuring SQL Server 2008 Integration Services Packages
Overview/Description
This course explores the various components that make up an SSIS package. This includes elements of package control flow, such as containers used to provide the structure in packages, the actual tasks that provide the package functionality, and precedence constraints that define the interconnection between tasks to create the control flow. For package data flow, the elements covered are the sources used to extract the data, transformations used to manipulate the data, and destinations responsible for loading the data. Paths are then used to connect the components to form the data flow. The course also covers Integration Services features that can be used to extend the functionality of packages, including event handlers, transactions, checkpoints, variables, expressions, and queries. This course is one of a series in the SkillSoft learning path that covers the objectives for the Microsoft exam: 70-448 TS: Microsoft SQL Server 2008, Business Intelligence Development and Maintenance. Passing this exam will earn the learner Microsoft Certified Technology Specialist (MCTS): SQL Server 2008, Business Intelligence Development and Maintenance certification.
Target Audience
IT professionals working to develop and maintain Microsoft SQL Server 2008 business intelligence solutions or those pursuing a career as a database administrator or developer
Prerequisites
Familiarity with Microsoft .NET Framework; experience with SQL Server 2005 or SQL Server 2008 business intelligence components; experience performing queries on relational databases and using SQL Server Management Studio and Business Intelligence Development Studio
Expected Duration (hours)
2.0
Lesson Objectives
Configuring SQL Server 2008 Integration Services Packages
md_mqbm_a02_it_enus
Back to List
Deploying SQL Server 2008 Integration Services Packages
Overview/Description
This course discusses the deployment and execution of SQL Server Integration Services (SSIS) packages. Once packages have been created, they must be deployed to a production server. This course gives an overview of the package deployment options available, the preparations of packages for deployment using package configurations, and the creation of a deployment utility. It also covers the methods used to install packages once deployed to the server, including the use of the Package Installation Wizard. The course also discusses the methods for running packages from within BIDS and using the DTExec command utility, and outlines how to schedule package execution using SQL Server Agent jobs. Also discussed are the methods and tools available to monitor and secure Integration Services and SSIS packages. This includes an overview of the logging feature and how to use it to enable logging on packages, the event handling process in Integration Services, and the debugging options used. The course also describes best practices for securing packages during development, deployment, and operation using roles, package protection levels, and digital certificates. This course is one of a series in the SkillSoft learning path that covers the objectives for the Microsoft exam: 70-448 TS: Microsoft SQL Server 2008, Business Intelligence Development and Maintenance. Passing this exam will earn the learner Microsoft Certified Technology Specialist (MCTS): SQL Server 2008, Business Intelligence Development and Maintenance certification.
Target Audience
IT professionals working to develop and maintain Microsoft SQL Server 2008 business intelligence solutions or those pursuing a career as a database administrator or developer
Prerequisites
Familiarity with Microsoft .NET Framework; experience with SQL Server 2005 or SQL Server 2008 business intelligence components; experience in performing queries on relational databases and using SQL Server Management Studio and Business Intelligence Development Studio.
Expected Duration (hours)
1.5
Lesson Objectives
Deploying SQL Server 2008 Integration Services Packages
md_mqbm_a03_it_enus
Back to List
Managing SSIS Packages in SQL Server 2008
Overview/Description
This course discusses managing SQL Server Integration Services (SSIS) packages. Once packages have been created, they must be deployed to a production server and then managed by administrator and users. This course gives an overview of the logging feature and how to use it to enable logging on packages, the event handling process in Integration Services, and the debugging options used. The course also describes best practices for securing packages during development, deployment, and operation using roles, package protection levels, and digital certificates. This course is one of a series in the SkillSoft learning path that covers the objectives for the Microsoft exam: 70-448 TS: Microsoft SQL Server 2008, Business Intelligence Development and Maintenance. Passing this exam will earn the learner Microsoft Certified Technology Specialist (MCTS): SQL Server 2008, Business Intelligence Development and Maintenance certification.
Target Audience
IT professionals working to develop and maintain Microsoft SQL Server 2008 business intelligence solutions or those pursuing a career as a database administrator or developer
Prerequisites
Familiarity with Microsoft .NET Framework; experience with SQL Server 2005 or SQL Server 2008 business intelligence components; experience in performing queries on relational databases and using SQL Server Management Studio and Business Intelligence Development Studio
Expected Duration (hours)
1.5
Lesson Objectives
Managing SSIS Packages in SQL Server 2008
md_mqbm_a10_it_enus
Back to List
Implementing SQL Server 2008 Reporting Services Solutions
Overview/Description
SQL Server 2008 Reporting Services provides powerful and flexible solutions for enterprise reporting needs. This course introduces the reporting services functionality, tools, installation, and enhancements provided by SQL Server 2008. It outlines the fundamental tasks involved in authoring a basic report and explores the features available to customize and enhance report functionality. This includes understanding the Report Definition Language used with reports, the types of report objects and items that can be added to reports, defining and manipulating data sources and datasets, and formatting the appearance of reports. The course also covers the use of parameters and filters in manipulating report data sets, as well as the addition of user interactivity features such as drilldowns, document maps, and sorting. The course also discusses how the functionality of reports can be extended through the incorporation of expressions and custom code assemblies. This course is one of a series in the SkillSoft learning path that covers the objectives for the Microsoft exam: 70-448 TS: Microsoft SQL Server 2008, Business Intelligence Development and Maintenance. Passing this exam will earn the learner Microsoft Certified Technology Specialist (MCTS): SQL Server 2008, Business Intelligence Development and Maintenance certification.
Target Audience
IT professionals working to develop and maintain Microsoft SQL Server 2008 business intelligence solutions or those pursuing a career as a database administrator or developer
Prerequisites
Familiarity with Microsoft .NET Framework; experience with SQL Server 2005 or SQL Server 2008 business intelligence components; experience in performing queries on relational databases and using SQL Server Management Studio and Business Intelligence Development Studio
Expected Duration (hours)
3.0
Lesson Objectives
Implementing SQL Server 2008 Reporting Services Solutions
md_mqbm_a04_it_enus
Back to List
Deploying and Delivering SQL Server 2008 Reporting Services Reports
Overview/Description
This course discusses features and tasks performed by administrators when working with SQL Server 2008 Reporting Services (SSRS) reports and content. After reports have been created and formatted, it is time to make them available to the users that need them. This involves the process of deploying reports and the associated data. This course describes the various methods and processes involved in the deployment and execution of reports. It covers the publishing of reports using the Report Manager web interface and BIDS Report Designer tool. Also discussed is the use and creation of report models; report models are needed to create reports using the user-friendly Report Builder tool. Another key benefit of Reporting Services is interoperability with a range of external applications. This course provides an overview of rendering report data to applications using the Report Server Web Service, Report Viewer controls, and URL access. Also discussed are options that can be configured for the delivery of reports, including the use of report subscriptions, schedules, cached reports, and the use of snapshots. This course is one of a series in the SkillSoft learning path that covers the objectives for the Microsoft exam: 70-448 TS: Microsoft SQL Server 2008, Business Intelligence Development and Maintenance. Passing this exam will earn the learner Microsoft Certified Technology Specialist (MCTS): SQL Server 2008, Business Intelligence Development and Maintenance certification.
Target Audience
IT professionals working to develop and maintain Microsoft SQL Server 2008 business intelligence solutions or those pursuing a career as a database administrator or developer
Prerequisites
Familiarity with Microsoft .NET Framework; experience with SQL Server 2005 or SQL Server 2008 business intelligence components; experience performing queries on relational databases and using SQL Server Management Studio and Business Intelligence Development Studio
Expected Duration (hours)
2.0
Lesson Objectives
Deploying and Delivering SQL Server 2008 Reporting Services Reports
md_mqbm_a05_it_enus
Back to List
Maintaining SQL Server 2008 Reporting Services
Overview/Description
Administration and maintenance of Microsoft SQL Server 2008 Reporting Services and its components is key in providing customers and clients access to the Business Intelligence information they need. This course outlines the tools used and tasks involved in managing and maintaining access to Reporting Services and corresponding data. It covers the authentication subsystem and role-based authorization model used by Reporting Services, as well as the configuration of system-level and item-level role-based security. SQL Server 2008 also provides the ability to deploy and manage the report server and content using the Report Server Web Service and command-line tools. This course describes how to use these tools to automate administrative tasks and manage reports remotely through the web interface. It also outlines the options for monitoring server performance, report activities, and statistics using performance counters and the use of log files in evaluating server status and performance. This course is one of a series in the SkillSoft learning path that covers the objectives for the Microsoft exam: 70-448 TS: Microsoft SQL Server 2008, Business Intelligence Development and Maintenance. Passing this exam will earn the learner Microsoft Certified Technology Specialist (MCTS): SQL Server 2008, Business Intelligence Development and Maintenance certification.
Target Audience
IT professionals working to develop and maintain Microsoft SQL Server 2008 business intelligence solutions or those pursuing a career as a database administrator or developer
Prerequisites
Familiarity with Microsoft .NET Framework; experience with SQL Server 2005 or SQL Server 2008 business intelligence components; experience in performing queries on relational databases and using SQL Server Management Studio and Business Intelligence Development Studio
Expected Duration (hours)
1.5
Lesson Objectives
Maintaining SQL Server 2008 Reporting Services
md_mqbm_a06_it_enus
Back to List
Implementing SQL Server 2008 Analysis Services Solutions
Overview/Description
SQL Server 2008 Analysis Services gives you the opportunity to take the vast amount of information in your databases and analyze it so that you can use the information to improve your overall business. This course will introduce you to SQL Server 2008 Analysis Services and look at the benefits your business can gain from it. It will also introduce the different types of analysis services solutions that can be implemented and how analysis services is installed on SQL Server 2008. This course will also cover the logical and physical architecture of Multi-dimensional Analysis Services and introduce the tools that can be used to manage and deploy analysis services. In addition, the course will discuss data sources and data source views, including how to create, modify, and delete them. This course will also show how to create a SQL Server 2008 Analysis Services cube. This includes how you would use the Cube Designer, how you would define dimensions, define hierarchies, and define attributes. In addition, it includes a discussion on how to define measures, measure groups, and calculations. This course is one of a series in the SkillSoft learning path that covers the objectives for the Microsoft exam: 70-448 TS: Microsoft SQL Server 2008, Business Intelligence Development and Maintenance. Passing this exam will earn the learner Microsoft Certified Technology Specialist (MCTS): SQL Server 2008, Business Intelligence Development and Maintenance certification.
Target Audience
IT professionals working to develop and maintain Microsoft SQL Server 2008 business intelligence solutions or those pursuing a career as a database administrator or developer
Prerequisites
Familiarity with Microsoft .NET Framework; experience with SQL Server 2005 or SQL Server 2008 business intelligence components; experience performing queries on relational databases and using SQL Server Management Studio and Business Intelligence Development Studio
Expected Duration (hours)
2.5
Lesson Objectives
Implementing SQL Server 2008 Analysis Services Solutions
md_mqbm_a07_it_enus
Back to List
Querying Cubes and Working with Data Mining in SSAS
Overview/Description
SQL Server 2008 Analysis Services takes relational data and provides a robust way to analyze it in a meaningful way through MDX queries and data mining. This course will introduce the fundamentals of querying multi-dimensional data. It will introduce the MDX language which used to query multi-dimensional data. This includes a discussion on how to create a basic MDX query, how to establish a cube context, how to build subcubes and named sets, and how data can be modified with MDX. The course also provides a review of Key Performance Indicators (KPI), Actions, Perspectives, Translations, and Stored Procedures. In addition, this course introduces data mining. It looks at the logical and physical architecture of data mining including data mining structures, models, and algorithms. Tools related to data mining such as the Data Mining Wizard, Data Mining Designer, and SQL Server Management Studio will also be discussed in this course. This course will also look at how you can create, view, validate, and query a data mining solution. This course is one of a series in the SkillSoft learning path that covers the objectives for the Microsoft exam: 70-448 TS: Microsoft SQL Server 2008, Business Intelligence Development and Maintenance. Passing this exam will earn the learner Microsoft Certified Technology Specialist (MCTS): SQL Server 2008, Business Intelligence Development and Maintenance certification.
Target Audience
IT professionals working to develop and maintain Microsoft SQL Server 2008 business intelligence solutions or those pursuing a career as a database administrator or developer
Prerequisites
Familiarity with Microsoft .NET Framework; experience with SQL Server 2005 or SQL Server 2008 business intelligence components; experience performing queries on relational databases and using SQL Server Management Studio and Business Intelligence Development Studio
Expected Duration (hours)
2.0
Lesson Objectives
Querying Cubes and Working with Data Mining in SSAS
md_mqbm_a08_it_enus
Back to List
Managing SQL Server 2008 Analysis Services Solutions
Overview/Description
SQL Server 2008 Analysis Services provides a powerful solution for analyzing extremely large amounts of data in a relational database. This course looks at Analysis Services from a management perspective. It outlines the considerations involved with deploying SSAS projects. This includes project deployments using various methods and synchronization. The course also covers analysis services security solutions related to securing an instance and securing user access. A discussion about disaster recovery, including high-availability solutions and backup solutions is also included in this course. In addition, the course looks at administration, including the tools that can be used to maintain analysis services, how you can process SSAS objects, and how you can use SQL Server Profiler to monitor analysis services.This course is one of a series in the SkillSoft learning path that covers the objectives for the Microsoft exam: 70-448 TS: Microsoft SQL Server 2008, Business Intelligence Development and Maintenance. Passing this exam will earn the learner Microsoft Certified Technology Specialist (MCTS): SQL Server 2008, Business Intelligence Development and Maintenance certification.
Target Audience
IT professionals working to develop and maintain Microsoft SQL Server 2008 business intelligence solutions or those pursuing a career as a database administrator or developer
Prerequisites
Familiarity with Microsoft .NET Framework; experience with SQL Server 2005 or SQL Server 2008 business intelligence components; experience performing queries on relational databases and using SQL Server Management Studio and Business Intelligence Development Studio
Expected Duration (hours)
2.0
Lesson Objectives
Managing SQL Server 2008 Analysis Services Solutions
md_mqbm_a09_it_enus
Back to List
Microsoft MCTS Certification for SQL 2008
(Microsoft Certified Technology Specialist)
Microsoft Certified Technology Specialist (MCTS): SQL Server 2008 implement and maintain databases using specific instructions
and specifications. They have thorough knowledge of the product, understand how to use the tools and Transact-SQL language, and
know how to explore the user interface. Technology Specialists typically pursue careers as database administrators, database
developers, or business intelligence developers. They may also be developers and systems administrators who do not work with
SQL Server daily but who want to show their breadth of technology experience.
Benefits of CBT Direct’s Online Microsoft MCTS Certification Training
CBT Direct boasts the most beneficial online certification training on the market. With online training, you have the flexibility to study on your schedule, and with the speed and reliability of the internet, CBT Direct’s Microsoft MCTS training course is accessible anywhere you have an internet connection. Convenience finally costs less with CBT Direct – the most affordable online training solution today. CBT Direct is also a Microsoft Certified Partner.
The unique design of CBT Direct’s Microsoft MCTS certification course incorporates a proven four-step learning process: presentation, demonstration, guidance and independent practice. This four-step proven learning model for CBT Direct’s Microsoft MCTS training course ensures the greatest level of retention to prepare you for your Microsoft MCTS certification exam.
CBT Direct also offers online mentoring for over 100 current major certification exams, including Microsoft MCTS, for IT
professionals and end-users alike. CBT Direct’s mentors have a minimum of 20 certifications each and are available 24/7*.
* Available for most courses.
Who Benefits from CBT Direct’s Microsoft MCTS Training?
This training would be beneficial for individuals looking for IT job positions such as; SQL Database Administrator or a Database Manager.
What Professionals Will Learn from CBT Direct’s Microsoft
MCTS Training
Exam 70-432: TS: Microsoft SQL Server 2008 R2 - Implementation and Maintenance
This course teaches students about the components and management tools of SQL Server 2008 and what steps are required to
install and upgrade a SQL Server. Students will learn how to create a new database, DDL and logon triggers and an event
notification to audit access. This course also covers managing database integrity, using maintenance plans, database
monitoring, database performance, SQL Server backups and disaster recovery.
Click here to see a detailed curriculum outline.
Exam 70-433: TS: Microsoft SQL Server 2008 R2 - Database Development
This course teaches students how to create and manage database objects used to store and view data. It covers
everything from how to create stored procedures to how to implement database mail and scripts. You’ll also learn
to work with new technologies for Microsoft SQL Server 2008, such as “SQL Server Always On”, improved support for
multimedia, Powershell integration and improvements to searching reporting and compression.
Click here to see a detailed curriculum outline.
Exam 70-448: TS: Microsoft SQL Server 2008 - Business Intelligence Development and Maintenance
This online course provides students with the knowledge to create a data package and use SQL Server 2008
Integration Services tools, control flows, Property Expressions, checkpoint and transactions. Students will
also learn how to install, run, schedule, deploy, debug and secure SSIS packages. This course also covers how
to deploy, deliver and maintain SQL Reporting Services, manage analysis solutions and work with data mining in SSAS.
Click here to see a detailed curriculum outline.
Exam#
Certification
Certified Mentoring
Hours
Hours
24x7
Mon-Fri
(9-5 EST)
(9-5 EST)
Tier 3
TestPrep
| 70-432 | TS: Microsoft SQL Server 2008 R2, Implemenation and Maintenance | ü | ü | |
| 70-433 | TS: Microsoft SQL Server 2008 R2 - Database Development | ü | ü |
Success is a journey. The first step is deciding which direction to go. Get some advice from a training advisor based on your needs here.
Exam 70-432: TS: Microsoft SQL Server 2008 R2 - Implementation and Maintenance
Exam 70-433: TS: Microsoft SQL Server 2008 R2 - Database Development
Exam 70-448: TS: Microsoft SQL Server 2008 - Business Intelligence Development and Maintenance
