Sign In
|
View Cart
|
|
Help
|
Advanced Search
HOME
CERTIFICATE PROGRAMS
CUSTOMIZED TRAINING
ABOUT US
Course Catalog
Print Course information
Email me when offered
Return to Course Catalog
Courses and Programs
>
Computers
>
Networking
Data Warehouse Design and Implementation
In this two-day class you will discuss the essentials of data warehousing using the Kimball guide to dimensional modeling. Data warehouses should use a different design than a regular transactional database. The large amount of data the warehouse stores and the different use patterns of business intelligence work more efficiently if the database reflects these characteristics. You will become familiar with those traits and learn how to design a database that your business intelligence teams can use for the best results. This class uses SQL Server as the demo data source though it covers topics useful on a variety of database systems. This class is targeted to anyone working with data warehouses and does not require coding—though SQL knowledge is nice.
Upon completion of this course, you should be able to:
Design a clean and efficient schema for a data warehouse
Create fact and dimension tables
De-normalize data to give more rapid and efficient access
Create a star or snowflake schema
Implement solutions to Slowly Changing Dimensions
Secure the data within the data warehouse and in transit to users
Implement a simple Extract – Transform – Load (ETL) strategy
Audience:
Database Administrators, Managers, Testers and Developers
Recommended Prerequisites:
at least 6 months experience using SQL Server or another database system.
No classes currently available.
Click here
to continue searching for courses.
Some Title
Alert
Powered by CampusCE
Education Management System