Font size:

Description:

This is a bundled training package. It contains training for each of the bundled items below:

Course Price
SQL Server 2008 R2: Installation $74.95
SQL Server 2008 R2: Instance and Database Configuration $74.95
SQL Server 2008 R2: Security Management $74.95
SQL Server 2008 R2: Database Management $74.95
SQL Server 2008 R2: Data Management $74.95

Bundle Price: $199.00
Total Savings: $175.75


SQL Server 2008 R2: Installation

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.
  • recognize how SQL Server 2008 R2 improves business solutions
  • recognize the purpose of the various editions of SQL Server 2008 R2
  • identify the requirements for installing SQL Server 2008 R2
  • recognize the considerations for installing SQL Server 2008 R2
  • recognize how to install a SQL Server 2008 R2 instance in a given scenario
  • identify the requirements and considerations for upgrading an instance of SQL Server to SQL Server 2008 R2
  • recognize how to use the Upgrade Advisor to ensure component compatibility with SQL Server 2008 R2
  • recognize how to perform an upgrade to SQL Server 2008 R2
  • install an instance of SQL Server 2008 and prepare an instance for an upgrade to SQL Server 2008

SQL Server 2008 R2: Instance and Database Configuration

SQL Server 2008 R2's 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.
  • recognize how to configure services using SQL Server Configuration Manager
  • recognize how to configure a SQL Server 2008 R2 instance using sp_configure
  • recognize how to configure SQL Server 2008 R2 features using surface area configuration
  • recognize the features of Database Mail
  • recognize how to set up Database Mail
  • create a Master Data Services database
  • create and associate a Master Data Manager web application in a new web site
  • enable Master Data Services
  • recognize how the SQL Server 2008 R2 database architecture is structured
  • recognize how to create a database in SQL Server Management Studio
  • configure a SQL Server 2008 R2 instance and create a database

SQL Server 2008 R2: Security Management

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.
  • recognize how security works in the SQL Server 2008 R2 Database Engine
  • recognize how to create a login for SQL Server 2008 R2
  • recognize how to create a schema for SQL Server 2008 R2
  • recognize how to use T-SQL to create a user for SQL Server 2008 R2
  • recognize how to implement encryption in SQL Server 2008 R2
  • recognize how to use impersonation in a given scenario
  • recognize how to create a DDL trigger to audit access
  • recognize how to create a logon trigger to audit access
  • recognize how to create an event notification to audit access
  • create logins, users, and schemas to allow access to SQL Server 2008 R2
  • use impersonation to change the execute context for a session
  • create a DDL trigger for auditing access in SQL Server 2008 R2

SQL Server 2008 R2: Database Management

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.
  • recognize how to check database integrity
  • recognize how to shrink a database
  • recognize how to expand a database
  • recognize how to detach a database
  • recognize how to move a database between instances
  • recognize how to create database maintenance plans to automate administrative tasks
  • check database integrity
  • detach and reattach a database
  • use the maintenance plan design surface to create a database maintenance plan
  • recognize the purpose of SQL Server Agent
  • recognize how to use SQL Server Agent to create operators
  • recognize how to use a SQL Server Agent job to automate a task
  • recognize how to create an alert that responds to events that occur on a SQL Server computer
  • recognize how the Policy-Based Management feature works in SQL Server 2008 R2
  • recognize how to use SQL Server 2008 R2 Policy-Based Management to create a policy
  • configure SQL Server Agent
  • use Policy-Based Management to administer a database

SQL Server 2008 R2: Data Management

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.
  • recognize how to partition a table
  • recognize how to partition an index
  • recognize how to modify a partition
  • recognize how row compression works in SQL Server 2008 R2
  • recognize how to enable data compression on a new table or index
  • recognize the basic principles of indexes in SQL Server 2008 R2
  • recognize how to create indexes in a database
  • recognize how to manage indexes in a database
  • recognize the considerations for using SQL Server 2008 R2 to perform a bulk import
  • recognize how to use Transact-SQL to perform a bulk data transfer
  • recognize how to use bcp to import and export data between SQL Server and data files
  • recognize how to use the SQL Server Import and Export Wizard
  • modify a partition
  • modify a function
  • determine the fragmentation of an index
  • export data
Register Now
Microsoft SQL Server 2008 R2: Part 1 e-learning bundle
  • Course ID:
    252796
  • Duration:
    10 hours
  • Price:
    $199