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.
LEVEL – Intermediate
COURSE TOPICS:
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
READ MORE
LEARN THIS COURSE FOR FREE *10 days of free unlimited access to “Implementing a Data Warehouse with Microsoft SQL Server 2012”
Instructor’s Welcome Note:
Hi, this is Martin Guidry, and welcome to Implementing a Data Warehouse with Microsoft SQL Server 2012. In this course, we’ll look at designing and building an enterprise data warehouse using Microsoft SQL Server. I’ll start off by showing you how to design fact and dimension tables, using the star and snowflake techniques. Then I’ll show you how to use data quality services to cleanse data. We’ll see how to implement an ETL process, using SQL server integration services.
We’ll cover all these plus plenty of other tools and techniques. Now let’s get started with Implementing a Data Warehouse with Microsoft SQL Server 2012.
Get 10 days of FREE unlimited access to Lynda.com.
Implementing a Data Warehouse with Microsoft SQL Server 2012
Big Data Tutorials
Martin Guidry tutorials
Lynda review
from Course reviews, freebies, coupons http://www.coursetag.com/free-implementing-a-data-warehouse-with-microsoft-sql-server-2012-it-sql-server/
No comments:
Post a Comment