Font size:

Description:

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

Course Price
Microsoft SQL Server 2012: Installation and Upgrade $74.95
Microsoft SQL Server 2012: Managing Databases and Automating Tasks $74.95
Microsoft SQL Server 2012: Instance Configuration and Database Creation $74.95
Microsoft SQL Server 2012: Security Management $74.95
Microsoft SQL Server 2012: Managing Database Data $74.95

Bundle Price: $199.00
Total Savings: $175.75


Microsoft SQL Server 2012: Installation and Upgrade

SQL Server 2012 is a comprehensive database platform, consisting of components and management tools such as SQL Server Management Studio, the SQL Server Database Engine, Integration Services, Analyzes Services, and Reporting Services. 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 2012 components and management tools, and outlines the requirements for installing SQL Server 2012, including the hardware, software, and security requirements. The steps required to complete a fresh installation of a SQL Server 2012 and how to upgrade a SQL Server instance are also explored. The course also addresses how to move database from an instance of SQL Server to SQL Server 2012 for a migration detach and attach methods and the Copy Database wizard. This course is one of a series in the SkillSoft learning path that covers the objectives for the Microsoft SQL Server 2012 exam 70-462: Administering Microsoft SQL Server 2012 Databases. This exam is one of the requirements for the Microsoft Certified Solutions Associated (MCSA): SQL Server 2012 certification.
  • distinguish between SQL Server 2012 editions
  • describe the considerations involved in planning a SQL Server 2012
  • recognize how to follow pre- and post-installation security best practices
  • describe network security considerations for SQL Server 2012
  • identify how to install SQL Server 2012 using the wizard
  • Recognize how to install SQL Server 2012 on Server Core
  • prepare for a SQL Server 2012 installation
  • install SQL Server 2012
  • describe the considerations involved in preparing to upgrade to SQL Server 2012
  • describe how to install and run Upgrade Advisor
  • identify the main tasks for upgrading to SQL Server 2012
  • migrate a databases to a new server
  • migrate to SQL Server 2012

Microsoft SQL Server 2012: Managing Databases and Automating Tasks

Database maintenance is an ongoing task for SQL Server 2012 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 2012 Transact-SQL provides DBCC, which is a command that provides statements to maintain the database and database files. An administrator can also create jobs using SQL Server Agent to automate administrative tasks in the SQL Server Database Engine and throughout the enterprise by having the jobs run on multiple SQL Server servers throughout the enterprise using a master server. SQL Server 2012 provides the Database Mail feature which allows e-mails to be sent from SQL Server to users through applications. These e-mails can be anything from alerts to query results and files from any network resource using SMTP. This course demonstrates how to confirm the integrity of a database and manage the size of the database files. It also demonstrates how to configure Database Mail and SQL Server Agent jobs for a single server and for multiple servers. This course also discusses the database architecture and how to create and configure a database. This course is one of a series in the SkillSoft learning path that covers the objectives for the Microsoft SQL Server 2012 exam 70-462: Administering Microsoft SQL Server 2012 Databases. This exam is one of the requirements for the Microsoft Certified Solutions Associated (MCSA): SQL Server 2012 certification.
  • recognize how to perform database management tasks using the DBCC CHECKDB command
  • alter the size of a database
  • describe the features of Database Mail
  • use the Database Mail Configuration Wizard to configure Database Mail
  • manage a SQL Server 2012 database
  • configure and manage Database Mail
  • identify the steps to configure SQL Server Agent to automate SQL Server administration
  • create a SQL Server Agent job
  • describe the characteristics of automated server administration in SQL Server 2012
  • set up servers to facilitate administrative job automation
  • recognize how to manage SQL Server Agent Jobs
  • recognize how to manage target servers
  • use SQL Server Agent to automate SQL Server administration
  • manage servers and jobs

Microsoft SQL Server 2012: Instance Configuration and Database Creation

SQL Server 2012's core component is its Database Engine instance, which provides storage, processing, and security for enterprise data through its controlled access and rapid transaction processing. SQL Server 2012 also provides additional features and components to manage and view data, these include Analysis Services and Reporting Services.SQL Server 2012 provides tools to manage the features and components which includes Server Management Studio’s graphical user tool which allows administrators and developers to create and configure instances and databases on an enterprise level, SQL Server Configuration Manager for managing SQL Server services and protocols, and Reporting Services Configuration Manager to configure Reporting Services. This course demonstrates how to add additional features and components to an installation of SQL Server 2012, how to configure and manage an instance, and how to configure Reporting Services. This course also discusses the database architecture and how to create and configure a database. This course is one of a series in the SkillSoft learning path that covers the objectives for the Microsoft SQL Server 2012 exam 70-462: Administering Microsoft SQL Server 2012 Databases. This exam is one of the requirements for the Microsoft Certified Solutions Associated (MCSA): SQL Server 2012 certification.
  • use Configuration Manager to manage SQL Server 2012 services
  • recognize the steps involved in configuring a Windows Firewall for Database Engine Access
  • recognize the functions of the different pages in the Server Properties dialog box
  • describe how to add features and components to a SQL Server 2012 installation
  • configure Reporting Services using Reporting Services Configuration Manager
  • identify how Reporting Services can work with SharePoint
  • enable SQL Server features
  • perform configuration tasks on SQL Server 2012 instances
  • describe the characteristics of databases and their architecture
  • match the database type to its description
  • create a database
  • change database options
  • identify the features of databases
  • use a variety of methods to create databases and alter their preferences

Microsoft SQL Server 2012: Security Management

Microsoft SQL Server 2012 provides enhanced security features to ensure that each instance is secure. Using SQL Server 2012 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. SQL Server 2012 also provides an auditing feature to audit the instance using server-level and database-level events, which can then be reviewed in log files. Policy-based management is another feature which provides administrators the means to specify policies throughout the SQL Server instance that objects need to adhere too to keep the database security and running efficiently. This course demonstrates how to create SQL Server logins, database users, schemas, roles, and how to grant permissions. It also addresses how to use encryption to protect a database and database data, as well as how to use the SQL Server Auditing feature and Policy-Based Management. This course is one of a series in the SkillSoft learning path that covers the objectives for the Microsoft SQL Server 2012 exam 70-462: Administering Microsoft SQL Server 2012 Databases. This exam is one of the requirements for the Microsoft Certified Solutions Associated (MCSA): SQL Server 2012 certification.
  • describe the characteristics of resource security in SQL Server 2012
  • recognize how the fn_builtin_permissions function is used to obtain information on granted permissions
  • recognize how to create logins
  • describe the characteristics of credentials and roles
  • describe how to manage database users in SQL Server 2012
  • identify how data encryption is used in SQL Server 2012
  • sequence the steps involved in Transparent Data Encryption
  • manage access in SQL Server 2012
  • use data encryption in SQL Server 2012
  • match the SQL Server 2012 audit components to their descriptions
  • use the auditing features in SQL Server 2012
  • describe the characteristics of policy-based management in SQL Server 2012
  • recognize how to use policy-based management in SQL Server 2012
  • create an audit and an audit specification for a given scenario
  • use policy-based management in SQL Server 2012

Microsoft SQL Server 2012: Managing Database Data

SQL Server 2012 provides various features and utilities to manage data stored in the databases within a SQL Server instance. This includes support for storing large unstructured data, such as files and documents within or outside the database. The ability to store large data is supported through the FILESTREAM database feature. This enables large unstructured data to be store outside the database on the file system by providing integration between the file system and SQL Server. FileTables is another database feature that allows large data to be store within tables, but accessed from the file system. SQL Server also provides data compression at the row and page level to compress data that is stored within a database which can help reduce its size. Bulk exporting and importing of data is another feature supported by SQL Server 2012 to allow data to be moved from outside sources into SQL Server or out of SQL Server to outside source or other SQL Server databases. This course provides an overview of the FILESTREAM and FileTable features, including how to enable and use them within a SQL Server 2012 database. It also covers data compression and how to use the bcp utility, BULK INSERT, and OPENROWSET(BULK) function to import and export data. This course is one of a series in the SkillSoft learning path that covers the objectives for the Microsoft SQL Server 2012 exam 70-462: Administering Microsoft SQL Server 2012 Databases. This exam is one of the requirements for the Microsoft Certified Solutions Associated (MCSA): SQL Server 2012 certification.
  • identify the characteristics of FILESTREAM
  • enable and configure FILESTREAM
  • identify the considerations involved in implementing FileTables
  • manage FileTables using Transact-SQL
  • determine the most appropriate method for populating FileTables for a given scenario
  • describe the considerations involved in using data compression
  • enable compression
  • use SQL Server 2012 features to manage the storage of files
  • implement a data compression solution for a given scenario
  • describe the considerations involved in working with bulk data in SQL Server 2012
  • use the bcp utility to move data
  • recognize how to create file formats
  • use the Transact-SQL statements that support bulk importing
  • use SQL Server 2012 data import and export tools
Register Now
Microsoft SQL Server 2012: Database Administration Part 1 e-learning bundle
  • Course ID:
    252788
  • Duration:
    11 hours
  • Price:
    $199