Course Information
Registration period
Year-round Recruitment
Course Level
Study Mode
Duration
7 Hour(s) 23 Minute(s)
Language
English
Taught by
Bluelime Learning Solutions
Rating
Course Overview
Design and implement a data warehouse
This course describes how to implement a data warehouse solution.
students will learn how to create a data warehouse with Microsoft SQL Server 2014, implement ETL with SQL Server Integration Services, and validate and cleanse data with SQL Server Data Quality Services and SQL Server Master Data Services.
Target Audience:
=>This course is intended for database professionals
who need to create and support a data warehousing solution. Primary responsibilities include:
••Implementing a data warehouse.
••Developing SSIS packages for data extraction, transformation, and loading.
••Enforcing data integrity by using Master Data Services.
••Cleansing data by using Data Quality Services.
Prerequisites :
Experience of working with relational databases, including:
Designing a normalized database.
Creating tables and relationships.
Querying with Transact-SQL.
Some exposure to basic programming constructs (such as looping and branching).
An awareness of key business priorities such as revenue, profitability, and financial accounting is desirable.
Students will learn how to :
••Deploy and Configure SSIS packages.
••Download and installing SQL Server 2014
••Download and attaching Adventureworks2014 database
••Download and installing SSDT
••Download and installing Visual studio
••Describe data warehouse concepts and architecture considerations.
••Select an appropriate hardware platform for a data warehouse.
••Design and implement a data warehouse.
••Implement Data Flow in an SSIS Package.
••Implement Control Flow in an SSIS Package.
••Debug and Troubleshoot SSIS packages.
••Implement an ETL solution that supports incremental data extraction.
••Implement an ETL solution that supports incremental data loading.
••Implement data cleansing by using Microsoft Data Quality Services.
••Implement Master Data Services to enforce data integrity.
••Extend SSIS with custom scripts and components.
••Databases vs. Data warehouses
••Choose between star and snowflake design schemas
••Explore source data
••Implement data flow
••Debug an SSIS package
••Extract and load modified data
••Enforce data quality
••Consume data in a data warehouse
Course Content
- 13 section(s)
- 71 lecture(s)
- Section 1 Getting Started
- Section 2 SQL Server 2019 Setup
- Section 3 Setup for visual studio 2019 | SSIS |SSRS|SSAS
- Section 4 Introduction to Data Warehousing
- Section 5 Data Warehouse Hardware
- Section 6 Designing a Data Warehouse
- Section 7 Big Data Concepts
- Section 8 Creating ETL solution with SSIS
- Section 9 Debugging and Troubleshooting SSIS Packages
- Section 10 Implementing an Incremental ETL Process
- Section 11 Deploying and Configuring SSIS
- Section 12 Enforcing Data Quality
- Section 13 Consuming Data in a Data Warehouse
What You’ll Learn
- Describe how to consume data from the data warehouse., Create ETL Solution, Design a data warehouse, Troubleshoot and Debug SSIS package, Sort out duplicates, Extract Data, Load Data, Deploy SSIS, Enforce Data Quality, Cleanse data, Analysis data, Generate reports
Skills covered in this course
Reviews
-
AAlvaro Ramirez Barrantes
Not clear examples, incomplete exercises or inexistent case of usage, not external data like excels ETLs there are errors in deploy SSIS solutions unresolved. Useful guides to start researching more but I think it needs to be enhanced.
-
CCAD-IT Center
Overall is good. Course material delivery is on point. But sometimes while doing code demonstration there are some errors on it. Even the trainer is explaining why the error happens, it might be better to demonstrate it in the correct way.
-
RRahul
The topics covered aren't detailed as expected. There is scope for improvement in the way the lectures are presented. However, helped to learn basic concepts.
-
SSimon Wong
This course only provides basic knowledge so it's for beginner. The course is a little confusing because it's not based on a single version of SQL Server. It should be updated to the latest version because it's kind of outdated. The biggest drawback of this course is it doesn't guide you through a complete realistic project. Also there are no sample files provided.
