De Meest Voordelige Opleider van Nederland
Award winning E-Learning & Gecertificeerde Trainers
Upgrade uw cv met een certificaat van deelname van OEM
SpringestMicrosoft PartnerEC-CouncilOfferte Aanvragen
0

Tip: we verzorgen onze trainingen tegenwoordig ook VirtueelTip: we verzorgen onze trainingen tegenwoordig ook VirtueelKlik hier voor meer informatie

Tip: we verzorgen onze trainingen tegenwoordig ook VirtueelTip: we verzorgen onze trainingen tegenwoordig ook VirtueelKlik hier voor meer informatie

Microsoft SQL Server MCSA SQL Server 2012/2014 OEM Certkit

Product description
MCSA SQL Server 2012/2014 E-Learning OEM Certkit Order this unique E-Learning course MCSA SQL Server 2012/2014 online, 1 year 24/7 access to rich interactive videos, speech, progress monitoring through reports and tests per chapter to directly test the knowledge. Course content Querying Microsoft SQL Server 2012 exam 70-461 17 uur Micr...

MCSA SQL Server 2012/2014 E-Learning OEM Certkit

Order this unique E-Learning course MCSA SQL Server 2012/2014 online, 1 year 24/7 access to rich interactive videos, speech, progress monitoring through reports and tests per chapter to directly test the knowledge.


Course content

Querying Microsoft SQL Server 2012 exam 70-461

17 uur

Microsoft SQL Server 2012: Querying Basics and Modifying Data

describe how the SELECT statement is used to retrieve data
describe the characteristics of subqueries
use a join condition to define how tables are related
retrieve data from SQL Server database in a given scenario
alter the data in a given scenario
use the MERGE and OUTPUT statements to change the contents of a database in a given scenario
modify the contents of a databases in a given scenario

Microsoft SQL Server 2012: Manipulate Data Using Operators and Functions

describe the features of functions in SQL Server 2012
use built in functions in SQL Server 2012
determine the kind of scalar function required in a given scenario
manipulate data using built-in functions
manage results sets
return a single value by evaluating conditions
describe the considerations involved in creating summary reports
change a table-valued expression using the PIVOT and UNPIVOT operators in a given scenario
use the results returned from a subquery in an outer query
use operators and table expressions to work with data in given scenarios
determine which expression should be used in a given scenario

Microsoft SQL Server 2012: Creating Functions and Triggers

control the sequence of statement execution using control-of-flow language
match the transaction modes to their descriptions
create and modify user-defined functions
create a DML trigger
modify an existing DML trigger
specify the sequence of statement execution for a given scenario
create and modify functions and triggers in a given scenario

Microsoft SQL Server 2012: Creating Programming Objects and Optimizing Queries

recognize the characteristics of stored procedures
execute and modify a stored procedure in a given scenario
employ error handling techniques
use cursors to focus query results
use synonyms in a given scenario
create program objects for a given scenario
describe the characteristics of execution plans
creating a plan guide
create and update statistics in a given scenario
describe the characteristics of concurrency in SQL Server 2012
describe the characteristics of locking in SQL Server 2012
describe how queries can be optimized in a given scenario
improve query performance in a given scenario

Microsoft SQL Server 2012: Managing XML Data

describe the considerations involved in storing XML data directly within SQL Server 2012
recognize how to implement XML data storage in SQL Server 2012
describe the characteristics of indexes
recognize how to handle XML data in different scenarios
recognize how XPath is used
recognize how to query XML data using XQuery
recognize the modes that can be specified for a FOR XML clause
distinguish between regular and nested XML queries
retrieve and convert data using the OPENXML statement
use SQL Server 2012's XML integration features
recognize how to manage XML data in SQL Server 2012
control how XML-related queries are returned

TestPrep 70-461 Querying Microsoft SQL Server 2012

Administering Microsoft SQL Server 2012 Databases exam 70-462

30 uur

Microsoft SQL Server 2012: 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

Microsoft SQL Server 2012: 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

Microsoft SQL Server 2012: 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

Microsoft 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

Microsoft SQL Server 2012: 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

Microsoft 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

Microsoft SQL Server 2012: 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

Microsoft SQL Server 2012: 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

Implementing a Data Warehouse with Microsoft SQL Server 2012 exam 70-463

21 uur

Microsoft SQL Server 2012 – Implementing a Data Warehouse: Create Basic Packagesdescribe the process for creating simple SSIS packages in SQL Server 2012 describe the main elements of packages: connection managers, control flow, and date flow create and manage connection managers in SSDT recognize how to create a basic package using data flow to extract, transform, and load data in SQL Server 2012 create a basic package using data flow to extract, transform, and load data in SQL Server 2012Microsoft SQL Server 2012 – Implementing a Data Warehouse: ETL Solutionsdescribe how to design control flow in SQL Server 2012 recognize how to implement control flow in SQL Server 2012 recognize how to design data transformations in SQL Server 2012 recognize how to implement advanced data flow transformations in SQL Server 2012 implement an ETL solution using the control flow tasks and data flow components to create an SSIS project based on a scenario

Microsoft SQL Server 2012 – Implementing a Data Warehouse: Enhancing Packages

recognize how to create dynamic SSIS packages using parameters, variables, and expressions, and explain what event handlers can be used for
recognize how to implement dynamic SSIS packages using parameters, variables, expressions, and event handlers
recognize how to use a Data Mining prediction model in an SSIS package using the Data Mining Query Transformation
differentiate between the Term Extraction Transformation and Term Lookup Transformation in SSIS packages
recognize how to use the term extraction and term lookup transformations within an SSIS package in a given scenario
create SSIS packages using parameters, variables, and expressions, and sample text mining and data mining for predictions

Microsoft SQL Server 2012 – Implementing a Data Warehouse: Custom Componentsdescribe how to use scripting components in SQL Server 2012 SSIS identify the planning considerations for custom components in SQL Server 2012 SSIS describe how to manage data that slowly changes over time implement the custom components and handle slowly changing dimensions in SQL Server 2012 SSIS

Microsoft SQL Server 2012 – Implementing a Data Warehouse: Installing SSIS

recognize the different methods of managing SSIS package execution
describe reasons for monitoring the SSIS package execution
to describe the considerations for SSIS install
recognize the SSIS install procedure and its features
identify the features of SSIS deployment
recognize the stages involved in deployment of SSIS packages
deploy SSIS and SSIS Packages in SQL Server 2012

Microsoft SQL Server 2012 – Implementing a Data Warehouse: Troubleshooting

determine which debugging technique to use in a given scenario
recognize how to debug a SSIS package in a given scenario
identify the correct debugging technique to use on production SSIS packages
identify the best way to optimize SSIS packages using the different tuning techniques
recognize how to view performance information on SSIS packages
identify how to implement auditing in SSIS for a given scenario
Troubleshoot data integration, auditing, logging, and event handling issues

Microsoft SQL Server 2012 – Implementing a Data Warehouse: DQS and MDS Solutions

describe the features of DQS
recognize the steps for configuring Data Quality Services
identify the type of DQS project needed to identify invalid data
recognize DMS supporting components
describe the attributes created by MDS
recognize how to configure matching rules
create and implement an MDS solution

Product specifications

Delivery time
Within 1 working day
Online access
Standard 12 months
Lesson duration
68 hours
Study load
Variable because of practical assignments.

Reviews

0 / 5Based on 0 reviews

There are no reviews written yet about this product..

Create your own review

Eerder bekeken door jou

Microsoft SQL Server MCSA SQL Server 2012/2014 OEM Certkit
Microsoft SQL ServerMCSA SQL Server 2012/2014 OEM Certkit

Order this unique E-Learning course MCSA SQL Server 2012/2014 online, 1 year 24/7 access to rich interactive videos and tests.

€897,00 Excl. tax
Please accept cookies to help us improve this website Is this OK? YesNoMore on cookies »