Winkelwagen
U heeft geen artikelen in uw winkelwagen
Microsoft SQL Server MCSA SQL Server 2012/2014 OEM Certkit
MCSA SQL Server 2012/2014 OEM Certkit
€897,00

Goedkoper ergens anders?

Laat het ons weten!

+31367601019 [email protected]

MCSA SQL Server 2012/2014 OEM Certkit

|
€897,00 Excl. btw
€1.085,37 Incl. btw
Op voorraad
|
Bestel voor 16:00 uur en start vandaag.
Je hebt nog counting... uur
  • Combideals
  • Bestellen op Factuur
  • Beste opleider 2019
  • Na Betaling Direct Starten
Cursusinhoud/-informatie

MCSA SQL Server 2012/2014 E-learning OEM Certkit

Bestel de MCSA SQL Server 2012/2014 OEM CertKit. Een dynamisch, uniek certificeringsvoorbereidingsproduct met 1 klik. OEM CertKit biedt de student leer- en certificeringsvoorbereidingstools die volledig zijn geïntegreerd in een op maat gemaakt leerbeheersysteem (LMS).
Met de OEM CertKit heeft de gebruiker toegang tot alle volgende producten vanuit één LMS. Volledig geïntegreerde producten omvatten: uitgebreide E-Learning met 1 jaar online toegang, examen quizzen, tips en informatie, MeasureUp examensimulatie is 60 dagen beschikbaar en begint met de eerste keer dat u het oefentest gebied betreedt. Sommige OEM Cert Kit-titels bevatten 1 jaar online Mentoring en Virtuele LAB´s (meerprijs). *Controleer het gedeelte Algemene eigenschappen hieronder om te zien of online Mentoring en Virtuele LAB´s zijn inbegrepen voor deze titel.

Cursusinhoud

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 SSISMicrosoft 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

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

En dat alles voor een fractie van de kosten van een klassikale training
Wilt U meer informatie over OEM Cert Kit? Neem contact op.

Heeft u niet gevonden wat u zocht?
Laat ons helpen!
Specificaties
Algemene eigenschappen
Duur: 7 uur
Taal: Engels
Certificaat van deelname: Ja
Online toegang: 365 dagen
Voortgangsbewaking: Ja
Award Winning E-learning: Ja
Geschikt voor mobiel: Ja
Beoordelingen
average of 0 review(s)
Geen reviews gevonden
Help ons en andere klanten door het schrijven van een review
Schrijf uw beoordeling!




Combideals
MCSA SQL Server 2012/2014 OEM Certkit + 70-461 Querying Microsoft SQL Server 2012 OEM Certkit + 70-462 Administering Microsoft SQL Server 2012 Databases OEM Certkit + 70-463 Implementing a Data Warehouse with Microsoft SQL Server 2012 OEM Certkit
Wij slaan cookies op om onze website te verbeteren. Is dat akkoord? Ja Nee Meer over cookies »