• 100 Queen St W, Brampton, ON L6X 1A4, Canada
  • +1-800-961-0337
START DATE END DATE CLASS TIMINGS MODE LOCATION ACTION
10/29/2018 11/02/2018
  • VLT
Live Online
11/26/2018 11/30/2018
  • VLT
Live Online
11/14/2018 11/16/2018
  • VLT
  • GTR
Live Online

20767: Implementing a SQL Data Warehouse Course 

20767: Implementing a SQL Data Warehouse five-day educator drove course furnishes understudies with the learning and aptitudes to arrangement a Microsoft SQL Server 2016 database. The course covers SQL Server 2016 arrangement both on-commence and in Azure, and covers introducing from new and relocating from a current introduce. 

20767: Implementing a SQL Data Warehouse Audience Profile 

The essential gathering of people for this course are database experts who need to satisfy a Business Intelligence Developer part. They should concentrate on hands-on work making BI arrangements including Data Warehouse usage, ETL, and information purging. 

20767: Implementing a SQL Data Warehouse At Course Completion

Subsequent to finishing this course, understudies will have the capacity to: 

  • Arrangement a Database Server. 
  • Update SQL Server. 
  • Design SQL Server. 
  • Oversee Databases and Files (shared). 

20767: Implementing a SQL Data Warehouse Course Outline 

Module 1: Introduction to Data Warehousing 

20767: Implementing a SQL Data Warehouse module depicts information distribution center ideas and engineering thought. 

Lessons 

  • Diagram of Data Warehousing 
  • Contemplations for a Data Warehouse Solution 

Lab : Exploring a Data Warehouse Solution 

  • Investigating information sources 
  • Investigating an ETL procedure 
  • Investigating an information distribution center 
  • Subsequent to finishing this module, you will have the capacity to: 
  • Depict the key components of an information warehousing arrangement 
  • Portray the key contemplations for an information warehousing arrangement 

Module 2: Planning Data Warehouse Infrastructure 

20767: Implementing a SQL Data Warehouse in this module portrays the primary equipment contemplations for building an information distribution center. 

Lessons 

  • Contemplations for information stockroom framework. 
  • Arranging information stockroom equipment. 

Lab : Planning Data Warehouse Infrastructure 

  • Arranging information stockroom equipment 
  • In the wake of finishing this module, you will have the capacity to: 
  • Portray the primary equipment contemplations for building an information distribution center 
  • Disclose how to utilize reference designs and information stockroom apparatuses to make an information distribution center 

Module 3: Designing and Implementing a Data Warehouse 

20767: Implementing a SQL Data Warehouse in this module portrays how you approach outlining and executing a pattern for an information distribution center. 

Lessons 

  • Outlining measurement tables 
  • Outlining certainty tables 
  • Physical Design for a Data Warehouse 

Lab : Implementing a Data Warehouse Schema 

  • Executing a star pattern 
  • Executing a snowflake pattern 
  • Executing a period measurement table 

In the wake of finishing this module, you will have the capacity to: 

  • Execute a sensible plan for an information stockroom 
  • Actualize a physical plan for an information distribution center 

Module 4: Columnstore Indexes 

20767: Implementing a SQL Data Warehouse module presents Columnstore Indexes. 

Lessons 

  • Prologue to Columnstore Indexes 
  • Making Columnstore Indexes 
  • Working with Columnstore Indexes 

Lab : Using Columnstore Indexes 

  • Make a Columnstore file on the FactProductInventory table 
  • Make a Columnstore file on the FactInternetSales table 
  • Make a memory upgraded Columnstore table 

Subsequent to finishing this module, you will have the capacity to: 

  • Make Columnstore files 
  • Work with Columnstore Indexes 

Module 5: Implementing an Azure SQL Data Warehouse 

20767: Implementing a SQL Data Warehouse module depicts Azure SQL Data Warehouses and how to execute them. 

Lessons 

  • Points of interest of Azure SQL Data Warehouse 
  • Executing an Azure SQL Data Warehouse 
  • Building up an Azure SQL Data Warehouse 
  • Relocating to an Azure SQ Data Warehouse 
  • Replicating information with the Azure information processing plant 

Lab : Implementing an Azure SQL Data Warehouse 

  • Make an Azure SQL information distribution center database 
  • Relocate to an Azure SQL Data distribution center database 
  • Duplicate information with the Azure information manufacturing plant 

Subsequent to finishing this module, you will have the capacity to: 

  • Depict the upsides of Azure SQL Data Warehouse 
  • Execute an Azure SQL Data Warehouse 
  • Depict the contemplations for building up an Azure SQL Data Warehouse 
  • Plan for relocating to Azure SQL Data Warehouse 

Module 6: Creating an ETL Solution 

Toward the finish of 20767: Implementing a SQL Data Warehouse in this module you will have the capacity to actualize information stream in a SSIS bundle. 

Lessons 

  • Prologue to ETL with SSIS 
  • Investigating Source Data 
  • Executing Data Flow 

Lab : Implementing Data Flow in a SSIS Package 

  • Investigating source information 
  • Exchanging information by utilizing an information push errand 
  • Utilizing change segments in an information push 

Subsequent to finishing this module, you will have the capacity to: 

  • Depict ETL with SSIS 
  • Investigate Source Data 
  • Execute a Data Flow 

Module 7: Implementing Control Flow in a SSIS Package 

20767: Implementing a SQL Data Warehouse module depicts actualizing control stream in a SSIS bundle. 

Lessons 

  • Prologue to Control Flow 
  • Making Dynamic Packages 
  • Utilizing Containers 
  • Overseeing consistency. 

Lab : Implementing Control Flow in a SSIS Package 

  • Utilizing undertakings and priority in a control stream 
  • Utilizing factors and parameters 
  • Utilizing holders 

Lab : Using Transactions and Checkpoints 

  • Utilizing exchanges 
  • Utilizing checkpoints 

Subsequent to finishing this module, you will have the capacity to: 

  • Depict control stream 
  • Make dynamic bundles 
  • Utilize holders 

Module 8: Debugging and Troubleshooting SSIS Packages 

20767: Implementing a SQL Data Warehouse module depicts how to investigate and investigate SSIS bundles 

Lessons 

  • Investigating a SSIS Package 
  • Logging SSIS Package Events 
  • Dealing with Errors in a SSIS Package 

Lab : Debugging and Troubleshooting a SSIS Package 

  • Troubleshooting a SSIS bundle 
  • Logging SSIS bundle execution 
  • Actualizing an occasion handler 
  • Taking care of mistakes in information stream 

In the wake of finishing this module, you will have the capacity to: 

  • Troubleshoot a SSIS bundle 
  • Log SSIS bundle occasions 
  • Handle blunders in a SSIS bundle 

Module 9: Implementing a Data Extraction Solution 

20767: Implementing a SQL Data Warehouse module portrays how to execute a SSIS arrangement that backings incremental DW stacks and evolving information. 

Lessons 

  • Prologue to Incremental ETL 
  • Separating Modified Data 
  • Stacking adjusted information 
  • Transient Tables 

Lab : Extracting Modified Data 

  • Utilizing a datetime segment to incrementally extricate information 
  • Utilizing change information catch 
  • Utilizing the CDC control assignment 
  • Utilizing change following 

Lab : Loading an information stockroom 

  • Stacking information from CDC yield tables 
  • Utilizing a query change to embed or refresh measurement information 
  • Actualizing a gradually changing measurement 
  • Utilizing the union explanation 

In the wake of finishing this module, you will have the capacity to: 

  • Portray incremental ETL 
  • Concentrate altered information 
  • Load altered information. 
  • Portray transient tables 

Module 10: Enforcing Data Quality 

20767: Implementing a SQL Data Warehouse module portrays how to execute information purging by utilizing Microsoft Data Quality administrations. 

Lessons 

  • Prologue to Data Quality 
  • Utilizing Data Quality Services to Cleanse Data 
  • Utilizing Data Quality Services to Match Data 

Lab : Cleansing Data 

  • Making a DQS information base 
  • Utilizing a DQS venture to scrub information 
  • Utilizing DQS in a SSIS bundle 

Lab : De-copying Data 

  • Making a coordinating strategy 
  • Utilizing a DS venture to coordinate information 

In the wake of finishing this module, you will have the capacity to: 

  • Portray information quality administrations 
  • Wash down information utilizing information quality administrations 
  • Match information utilizing information quality administrations 
  • De-copy information utilizing information quality administrations 

Module 11: Using Master Data Services 

20767: Implementing a SQL Data Warehouse module depicts how to actualize ace information administrations to uphold information trustworthiness at source. 

Lessons 

  • Prologue to Master Data Services 
  • Actualizing a Master Data Services Model 
  • Orders and accumulations 
  • Making a Master Data Hub 

Lab : Implementing Master Data Services 

  • Making an ace information administrations demonstrate 
  • Utilizing the ace information administrations include for Excel 
  • Upholding business rules 
  • Stacking information into a model 
  • Expending expert information administrations information 

In the wake of finishing this module, you will have the capacity to: 

  • Depict the key ideas of ace information administrations 
  • Execute an ace information benefit demonstrate 
  • Oversee ace information 
  • Make an ace information center point 

Module 12: Extending SQL Server Integration Services (SSIS) 

20767: Implementing a SQL Data Warehouse module portrays how to broaden SSIS with custom contents and segments. 

Lessons 

  • Utilizing scripting in SSIS 
  • Utilizing custom parts in SSIS 

Lab : Using contents 

  • Utilizing a content assignment 

In the wake of finishing this module, you will have the capacity to: 

  • Utilize custom parts in SSIS 
  • Utilize scripting in SSIS 

Module 13: Deploying and Configuring SSIS Packages 

20767: Implementing a SQL Data Warehouse module portrays how to convey and design SSIS bundles. 

Lessons 

  • Outline of SSIS Deployment 
  • Sending SSIS Projects 
  • Arranging SSIS Package Execution 

Lab : Deploying and Configuring SSIS Packages 

  • Making a SSIS list 
  • Sending a SSIS extend 
  • Making situations for a SSIS arrangement 
  • Running a SSIS bundle in SQL server administration studio 
  • Planning SSIS bundles with SQL server operator 

In the wake of finishing this module, you will have the capacity to: 

  • Portray a SSIS organization 
  • Send a SSIS bundle 
  • Plan SSIS bundle execution 

Module 14: Consuming Data in a Data Warehouse 

20767: Implementing a SQL Data Warehouse module portrays how to investigate and investigate SSIS bundles. 

Lessons 

  • Prologue to Business Intelligence 
  • An Introduction to Data Analysis 
  • Prologue to announcing 
  • Breaking down Data with Azure SQL Data Warehouse 

Lab : Using an information distribution center 

  • Investigating an announcing administrations report 
  • Investigating a PowerPivot exercise manual 
  • Investigating a power see report 

In the wake of finishing this module, you will have the capacity to: 

  • Depict at an abnormal state business insight 
  • Demonstrate a comprehension of announcing 
  • Demonstrate a comprehension of information investigation 
  • Dissect information with Azure SQL information stockroom

Notwithstanding their expert experience, understudies who go to 20767: Implementing a SQL Data Warehouse preparation should as of now have the accompanying specialized information: 

  • Fundamental learning of the Microsoft Windows working framework and its center usefulness. 
  • Working learning of social databases. 
  • Some involvement with database outline.

Awards