Tags
Language
Tags
<<
April 2024
Su Mo Tu We Th Fr Sa
31 1 2 3 4 5 6
7 8 9 10 11 12 13
14 15 16 17 18 19 20
21 22 23 24 25 26 27
28 29 30 1 2 3 4
  1. Home
  2. eBooks & eLearning

Implementing a Data Warehouse with Microsoft SQL Server 2012

Posted By: Landau17
Date: 12 Oct 2017 19:01:21
Implementing a Data Warehouse with Microsoft SQL Server 2012

Implementing a Data Warehouse with Microsoft SQL Server 2012
MP4 | Video: 720p | Duration: 3:06:40 | English | Subtitles: VTT | 543.1 MB



Learn how to design and implement an enterprise data warehouse. Microsoft Certified Trainer Martin Guidry shows how to design fact and dimension tables using both the star and snowflake techniques, use data quality services to cleanse data, and implement an ETL process with SQL Server integration services.

Topics include:
  • Typical databases vs. vdata warehouses
  • Choosing between star and snowflake design schemas
  • Working with appliances and "big data"
  • Exploring source data
  • Implementing data flow
  • Debugging an SSIS package
  • Extracting and loading modified data
  • Enforcing data quality
  • Consuming data in a data warehouse
UPWARDS