M20767 Implementing a SQL Data Warehouse - Seminar / Kurs von brainymotion AG

Inhalte

Students will learn how to create a data warehouse with Microsoft SQL Server 2016 and with Azure SQL Data Warehouse, to implement ETL with SQL Server Integration Services, and to validate and cleanse data with SQL Server Data Quality Services.

Lernziele

1 - Introduction to Data WarehousingOverview of Data WarehousingConsiderations for a Data Warehouse Solution2 - Planning Data Warehouse InfrastructureConsiderations for Building a Data WarehouseData Warehouse Reference Architectures and Applianc3 - Designing and Implementing a Data WarehouseLogical Design for a Data WarehousePhysical Design for a Data Warehouse4 - Columnstore IndexesIntroduction to Columnstore IndexesCreating Columnstore IndexesWorking with Columnstore Indexes5 - Implementing an Azure SQL Data WarehouseAdvantages of Azure SQL Data WarehouseImplementing an Azure SQL Data WarehouseDeveloping an Azure SQL Data WarehouseMigrating to an Azure SQ Data Warehouse6 - Creating an ETL SolutionIntroduction to ETL with SSISExploring Source DataImplementing Data Flow7 - Implementing Control Flow in an SSIS PackageIntroduction to Control FlowCreating Dynamic PackagesUsing Containers8 - Debugging and Troubleshooting SSIS PackagesDebugging an SSIS PackageLogging SSIS Package EventsHandling Errors in an SSIS Package9 - Implementing an Incremental ETL ProcessIntroduction to Incremental ETLExtracting Modified DataTemporal Tables10 - Enforcing Data QualityIntroduction to Data QualityUsing Data Quality Services to Cleanse DataUsing Data Quality Services to Match Data11 - Using Master Data ServicesMaster Data Services ConceptsImplementing a Master Data Services ModelManaging Master DataCreating a Master Data Hub12 - Extending SQL Server Integration Services (SSIS)Using Custom Components in SSISUsing Scripting in SSIS13 - Deploying and Configuring SSIS PackagesOverview of SSIS DeploymentDeploying SSIS ProjectsPlanning SSIS Package Execution14 - Consuming Data in a Data WarehouseIntroduction to Business IntelligenceIntroduction to ReportingAn Introduction to Data AnalysisAnalyzing Data with Azure SQL Data Warehouse

SG-Seminar-Nr.: 5150575

Anbieter-Seminar-Nr.: 855707767

Preis jetzt anfragen

Seminar merken ›

Semigator berücksichtigt

  • Frühbucher-Preise
  • Last-Minute-Preise
  • Gruppenkonditionen

und verfügt über Sonderkonditionen mit einigen Anbietern.

Der Anbieter ist für den Inhalt verantwortlich.

Über Semigator mehr erfahren

  • Anbietervergleich von über 1.500 Seminaranbietern
  • Vollständige Veranstaltungsinformationen
  • Schnellbuchung
  • Persönlicher Service