Tijdens de ICT-cursus CertKit – 70-462 (Administering Microsoft SQL Server 2012 Databases) worden de volgende onderdelen behandeld:
Instance Configuration and Database Creation
- 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
Managing Databases and Automating Tasks
- 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
Security Management
- 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
Managing Database Data
- 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
Managing Indexes, Full-Text Search and Partitions
- match the indexes that can be used in SQL Server 2012 to their descriptions
- recognize the considerations associated with creating different types of indexes
- recognize the options available for managing indexes
- perform index maintenance
- describe the characteristics of indexes in SQL Server 2012
- manage and maintain indexes
- recognize the steps for enabling full-text search
- implement full-text search in SQL Server 2012
- describe the features of partitioning in SQL Server 2012
- recognize how to manage partitioning in SQL Server 2012
- use full-text search in SQL Server 2012
- recognize how to employ partitioning in SQL Server 2012
Backing Up and Restoring Databases
- determine the most appropriate recovery model for a given scenario
- choose a logical backup device
- match the different kinds of backups to their descriptions
- recognize how to create a database backup
- describe the consideration involved in planning to restore a database
- recognize how to restore a database for a given scenario
- determine when to use particular backup types
- determine which recovery models and backup types should be used in a given scenario
- create database backups
- use SQL Server 2012 restore features
Database Monitoring and Performance Tuning
- describe the importance of database monitoring
- recognize how SQL Server Profiler is used to monitor a database
- describe the characteristics of SQL Server 2012’s performance monitoring tools
- create an Extended Event session using the CREATE EVENT SESSION statement
- configure the management data warehouse to support data storage on instances of SQL Server that are using the data collector
- recognize how Resource Governor is used to manage resources
- monitor databases
- access data to solve a server issues
- describe how to manage SQL Server workload using Resource Governor
- recognize how locking is used to secure data integrity in a SQL Server 2012 database
- describe how to minimize deadlocks
- manage deadlocks
- describe how locking is used in a SQL Server 2012 database
- use the features of SQL Server 2012 to manage and resolve deadlocks
Configuring High Availability
- match the high availability solutions to their descriptions
- describe the considerations involved in installing SQL Server AlwaysOn Failover Clustering
- match the steps in the failover process with appropriate examples
- describe the considerations involved in implementing AlwaysOn Availability Groups
- implement AlwaysOn Availability Groups
- prepare for database mirroring
- describe how to set up database mirroring
- describe how to monitor database mirroring sessions
- describe the options when setting up replication
- match the subscription types to their description
- determine the most appropriate high availability solution for a given scenario
- recognize the considerations involved in implementing AlwaysOn Availability Groups and SQL Server Failover Clustering
- implement database mirroring
- recognize how to distribute data and database objects using replication
TestPrep 70-462 Administering Microsoft SQL Server 2012 Databases
- TestPrep 70-462 Administering Microsoft SQL Server 2012 Databases
Volg ons: