70-463: Implementing a SQL Data Warehouse - e-learningshop.nl

Ga naar de inhoud
€ 453.75(incl. BTW)
Toevoegen
70-463: Implementing a SQL Data Warehouse
In de online cursus 70-463: Implementing a Data Warehouse with Microsoft SQL Server 2012 leer je datawarehouses op te zetten op basis van SQL Server 2012. Je leert wat datawarehouses zijn en hoe ze worden gebruikt om rapportages en (management) informatie te realiseren. Ook leer je hoe je de prestaties van je datawarehouse kunt verbeteren door gebruik te maken van indexen, partities en datacompressie.
Onderwerpen die onder andere aan bod komen zijn het ontwerpen en uitrollen van een datawarehouse, ETL oplossingen, installatie van SSIS, troubleshooting, DQS en MDS oplossingen, packages verrijken en uitbreiden en nog veel meer.

Doelgroep
Netwerkbeheerder, Databasebeheerder

Resultaat
Je kunt zelfstandig datawarehouses opzetten op basis van SQL Server 2012. Ook ben je voorbereid op het MCSA examen 70-463.

Voorkennis
Je hebt de volgende online cursus gevolgd of je hebt vergelijkbare kennis:
  • Querying Microsoft SQL Server 2012 (exam 70-461)

Inhoud
Tijdens de online cursus 70-463: Implementing a Data Warehouse with Microsoft SQL Server 2012 worden de volgende onderwerpen behandeld:
Create Basic Packages
describe 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 2012
ETL Solutions
Describe 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
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
Custom Components
Describe 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
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
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
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 2012
  • TestPrep 70-463 Implementing a Data Warehouse with Microsoft SQL Server 2012

Inbegrepen

Certificaat van deelname
ja
Voortgangsbewaking
ja
Geschikt voor mobiel
ja
Studieadvies
Onze consultants zijn beschikbaar om je te voorzien van studieadvies.StudiemateriaalGecertificeerde docenten met uitgebreide kennis over de onderwerpen.ServiceService via telefoon of e-mail.

Duur
28 uur

Beschikbare taal
Engels

Online toegang
6 maanden
CertKit - 70-463: Implementing a SQL Data Warehouse
Met de online cursus CertKit – 70-463: Implementing a SQL Data Warehouse van Sinteno krijg je de meest complete digitale leeromgeving en de beste voorbereiding op de praktijk of het examen. De CertKit is een dynamisch, uniek certificeringsvoorbereidingsproduct en biedt je de leer- en certificeringsvoorbereidingstools die volledig zijn geïntegreerd in een omgeving.
De CertKit geeft toegang tot zowel de e-Learning, de examensimulatie, een online mentor, examenquizzen, tips, trucs en links en Live LAB´s.

In de online cursus 70-463: Implementing a Data Warehouse with Microsoft SQL Server 2012 leer je datawarehouses op te zetten op basis van SQL Server 2012. Je leert wat datawarehouses zijn en hoe ze worden gebruikt om rapportages en (management) informatie te realiseren. Ook leer je hoe je de prestaties van je datawarehouse kunt verbeteren door gebruik te maken van indexen, partities en datacompressie.
Onderwerpen die onder andere aan bod komen zijn het ontwerpen en uitrollen van een datawarehouse, ETL oplossingen, installatie van SSIS, troubleshooting, DQS en MDS oplossingen, packages verrijken en uitbreiden en nog veel meer.

Doelgroep
Netwerkbeheerder, Databasebeheerder

Resultaat
Je kunt zelfstandig datawarehouses opzetten op basis van SQL Server 2012. Ook ben je voorbereid op het MCSA examen 70-463.

Voorkennis
Je hebt de volgende online cursus gevolgd of je hebt vergelijkbare kennis:
  • Querying Microsoft SQL Server 2012 (exam 70-461)

Inhoud
Tijdens de online cursus 70-463: Implementing a Data Warehouse with Microsoft SQL Server 2012 worden de volgende onderwerpen behandeld:
Create Basic Packages
describe 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 2012
ETL Solutions
Describe 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
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
Custom Components
Describe 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
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
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
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 2012
  • TestPrep 70-463 Implementing a Data Warehouse with Microsoft SQL Server 2012

Inbegrepen

Certificaat van deelname
ja
Voortgangsbewaking
ja
Geschikt voor mobiel
ja
Studieadvies
Onze consultants zijn beschikbaar om je te voorzien van studieadvies.StudiemateriaalGecertificeerde docenten met uitgebreide kennis over de onderwerpen.ServiceService via telefoon of e-mail.

Duur
28 uur

Beschikbare taal
Engels

Online toegang
6 maanden
e-learningshop.nl
SINTENO
Ketelweg 53
3356 LD  Papendrecht
www.sinteno.nl
info@sinteno.nl
+31 73 82 00 322
KvK: 70122016
IBAN: NL39 INGB 0007 9777 62

Terug naar de inhoud