SQL Server Data Warehousing Fundamentals
The Microsoft SQL Server Data Warehousing Fundamentals course provides step-by-step instructions on how to perform a variety of Microsoft Data Warehousing implementation activities including E-T-L (Extract, Transform and Load) and Self-Service Reporting tasks using Microsoft SQL Server Integration and Reporting Services.
In this course, you will learn the tools needed to create managed enterprise business intelligence (BI) solutions including data modeling, analysis services, and reporting services. You will then learn how to create and publish reports using reporting services, report execution and delivery.
You will learn how to plan, build and deploy a Data warehouse in an Microsoft Database 2014 to 2022 environment using Microsoft SSIS as your primary ETL Tool for developing Extract, Transform and Load processes.
On successful Completion of this course you will be able to:
- Understand the Data Warehouse and ETL Development Lifecycle
- Understand the BI and Warehouse Development Process
- Understand Data Warehousing Concepts
- Understand Dimension Modelling
- Understand SQL Server Warehouse Capabilities
- Understand Data warehouse concepts and architecture considerations
- Design and implement a data warehouse
- Understand Data Quality Issues in ETL Process
- Understand the architecture of the SQL Server Integration Service system
- Select an appropriate hardware platform for a data warehouse
- Implement data flow and control flow in a SSIS package
- Define Integration Processes
- Manage metadata in SQL Server Integration Service
- Enforce data quality constraints in a Package
- Debug and troubleshoot SSIS packages
- Implement a SSIS incremental data warehouse loads and extracting data
- Deploy and configure SSIS packages
Course Requirements | |
Prerequisites | Knowledge of Database Management Systems |
Target Audience | |
Audience | Systems Analyst Database Developers Application Developers Software Architects |
SQL Server Data Warehousing Fundamentals
- Brand: Weblearning Publishing
- Product Code: SQL Server Data Warehousing Fundamentals
- Reward Points: 100
- Availability: In Stock
- £89.99
-
£69.99
- Price in reward points: 1200
-
- 2 or more £59.99
- 4 or more £51.99
Available Options
Related Products
Tags: Database Management, Oracle Database, DB2, SQL, DBA