• SQL Server Data Warehousing Fundamentals

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

Write a review

Please login or register to review

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

Oracle Database SQL Workshop

Oracle Database SQL Workshop

Oracle Database SQL Workshop  This course is a combination of Oracle Database: SQL Workshop ..

£72.99 £89.99

Oracle Database Design and Programming with SQL CBT

Oracle Database Design and Programming with SQL CBT

Oracle Database Design and Programming with SQL This covers the Data Modelling and Database Devel..

£59.99 £79.99

Oracle Database Design and Programming with SQL eLearning

Oracle Database Design and Programming with SQL eLearning

Oracle Database Design and Programming with SQL This covers the Data Modelling and Database Devel..

£59.99 £79.99

Oracle Database Design and Programming with SQL Training Guide

Oracle Database Design and Programming with SQL Training Guide

Oracle Database Design and Programming with SQL This covers the Data Modelling and Database Devel..

£23.99 £29.99

Oracle Database 12c Performance Management and Tuning

Oracle Database 12c Performance Management and Tuning

Oracle Database 12c Performance Management and Tuning The Oracle Database 19c: Performance Manage..

£79.99 £99.99

Oracle Database 12/19c Essentials Certified Implementation

Oracle Database 12/19c Essentials Certified Implementation

Oracle Database 12/19c Essentials Certified Implementation The Oracle Database 12/19c Essentials ..

£169.99 £329.99

Oracle and SQL Server Data Warehousing Boot Camp CBT

Oracle and SQL Server Data Warehousing Boot Camp CBT

Oracle and SQL Server Data Warehousing Boot Camp The Oracle and SQL Server Data Warehousing Boot ..

£84.99 £99.99

Oracle and SQL Server Data Warehousing Boot Camp eLearning

Oracle and SQL Server Data Warehousing Boot Camp eLearning

Oracle and SQL Server Data Warehousing Boot Camp The Oracle and SQL Server Data Warehousing Boot ..

£84.99 £99.99

Oracle Business Intelligence and Data Warehousing

Oracle Business Intelligence and Data Warehousing

Oracle Business Intelligence and Data Warehousing The Oracle Business Intelligence, Analytics and..

£69.99 £84.99

Oracle Data Warehousing Fundamentals

Oracle Data Warehousing Fundamentals

Oracle Data Warehousing Fundamentals The Oracle Data Warehousing course provides step-by-step ins..

£79.99 £89.99

Database Administration Unlimited

Database Administration Unlimited

Database Administration Unlimited Cloud Learning SubscriptionThe Database Administration Unlimited C..

£320.00 £355.00

Oracle Database 23ai Data Warehousing Fundamentals

Oracle Database 23ai Data Warehousing Fundamentals

Oracle 23ai Data Warehousing Fundamentals This course introduces students to the Oracle Database ..

£110.99 £129.99

Oracle Database 23ai: SQL Workshop

Oracle Database 23ai: SQL Workshop

Oracle Database 23ai: SQL Workshop This course is designed for Developers and Database Administra..

£84.99 £99.99

Oracle Database 19c Data Warehousing Fundamentals CBT

Oracle Database 19c Data Warehousing Fundamentals CBT

Oracle Database 19c Data Warehousing Fundamentals This course introduces students to the Oracle D..

£79.99 £99.99

Oracle Database 19c Data Warehousing Fundamentals eLearning

Oracle Database 19c Data Warehousing Fundamentals eLearning

Oracle Database 19c Data Warehousing Fundamentals This course introduces students to the Oracle D..

£79.99 £99.99

Oracle Business Intelligence 11g Administration

Oracle Business Intelligence 11g Administration

Oracle Business Intelligence 11g Administration The Oracle Business Intelligence 11g Administrati..

£49.99 £69.99

Oracle 19c Data Warehousing Fundamentals

Oracle 19c Data Warehousing Fundamentals

Oracle 19c Data Warehousing Fundamentals The Oracle 19c Data Warehousing course provides step-by-..

£69.99 £89.99

Oracle 21c Data Warehousing Fundamentals

Oracle 21c Data Warehousing Fundamentals

Oracle 21c Data Warehousing Fundamentals The Oracle 21c Data Warehousing course provides step-by-..

£69.99 £89.99

Oracle Analytics and Data warehousing

Oracle Analytics and Data warehousing

Oracle Analytics and Data warehousing The Oracle Analytics and Data Warehousing course provides s..

£72.99 £89.99

Oracle Advanced Analytics: Concepts and Techniques

Oracle Advanced Analytics: Concepts and Techniques

Oracle Advanced Analytics: Concepts and Techniques The Oracle Advanced Analytics: Concepts and Te..

£79.99 £99.99

Introduction to Machine Learning Algorithms

Introduction to Machine Learning Algorithms

Introduction to Machine Learning Algorithms This course introduces you to the most commonly used ..

£59.99 £89.99

Predictive Analytics using SQL Server Machine Learning

Predictive Analytics using SQL Server Machine Learning

Predictive Analytics using SQL Server Machine Learning The course begins with an introduction to ..

£69.99 £89.99

Data Science Unlimited

Data Science Unlimited

Data Science Unlimited Cloud Learning SubscriptionThe Data Science Unlimited Cloud Learning Sub..

£310.00 £348.00

AI & Machine Learning Unlimited

AI & Machine Learning Unlimited

AI & Machine Learning Unlimited Cloud Learning SubscriptionThe Machine Learning Unlimited C..

£310.00 £348.00

Oracle Database 23ai: New Features for Developers

Oracle Database 23ai: New Features for Developers

Oracle Database 23ai: New Features for Developers This course focuses on the latest advancements ..

£124.00 £149.99

Tags: Database Management, Oracle Database, DB2, SQL, DBA