Implementing a Data Warehouse using Microsoft SQL Server Training in Australia

  • Delivery Method: Online Instructor-Led / Classroom Based / Onsite
  • Participation Model: Public Training / Private / In-House Training
  • Duration: 3 Days
  • Level: Intermediate
  • Price: From AUD 4,700 +TAX
  • Upcoming Date:
  • UK & Australia Based Global Training Provider

This three-day instructor-led course provides students who wish to administer and maintain a SQL Server data warehouse and ETL infrastructure using SQL Server Integration Services (SSIS).



Prerequisites

In addition to their professional experience, students who attend this training should already have the following technical knowledge:

Essential:

  • Basic knowledge of the Microsoft Windows operating system and its core functionality.
  • Working knowledge of Transact-SQL. (equivalent knowledge to QATSQL and QATSQLPLUS)

Nice to have:

  • Working knowledge of relational databases.
  • Some experience with database design.

Virtual Classroom

For learners attending remotely via any virtual classroom, an additional screen is required for this course to work through remote desktop labs and view training information. A remote Desktop will be provided using GoToMyPC or LearnOnDemand.

The additional screen must have a minimum screen size of 19 inch and minimum resolution of 1280x1024, with the vertical resolution (1024) being the most critical.

If you have questions,contact our Virtual team.

Target Audience

The primary audience for this course is individuals who will administer and maintain a SQL Server data warehouse and create and maintain SSIS packages.


We can organize this training at your preferred date and location.
HAVELSAN
ASELSAN
PepsiCo Türkiye
JTI TÜTÜN ÜRÜNLERİ SANAYİ A.Ş.
ING Bank
DHL
MASTERCARD
Huawei
TotalEnergies
Mercedes-Benz Türk A.Ş.
Goodyear
FORD OTOMOTIV SANAYI A.S.
3M COMPANY
Schneider Electric
Central Bank of Azerbaijan
BP Petrolleri
Procter & Gamble (P&G)
Qatar Foundation
Bank Of China
GlaxoSmithKline (GSK)
MORGAN STANLEY & CO Inc
Novo Nordisk
DEUTSCHE BANK
Azerbaycan Cumhuriyeti Emek ve Ahalinin Sosyal Güvenliği Bakanlığı
ACCENTURE

What You Will Learn

After completing this course, students will be able to:

  • Design a data warehouse
  • Build a data warehouse
  • Implement ETL control and data tasks
  • Control transactions and maintain consistency
  • Implement incremental updates
  • Manage and run packages
  • Debug packages

Training Outline

Module 1 : Data warehouse Overview

This module introduces the main terms used within data warehousing.

Lessons:

  • What is a data warehouse?
  • Components of a data warehouse
  • Data warehouse project roles
  • Using SQL Server as a data warehousing solution
  • Lab diagram

Module 2: Designing and implementing a data warehouse

This module is aimed at designing and implementing the data warehouse. The first few lessons cover the design including fact tables and different variations of dimension table.

Lessons:

  • Dimensional Model
  • Dimensions and fact tables
  • Star and snowflake schemas
  • Slowly changing dimensions
  • Partitioned tables
  • Measures
  • Time and junk dimensions
  • Indexes and compression
  • LAB A: Designing a data warehouse
  • LAB B: Creating the data warehouse
  • LAB C: Create a fact table
  • LAB D: Create dimension tables

Module 3: Implementing a control flow in an SSIS package

This module looks at the tasks within the control flow of the SSIS package. The lessons will cover the tasks primarily aimed at the data warehouse.

Lessons:

  • Introduction to SSIS
  • Control flow
  • Advanced control flow
  • Containers
  • Precedence
  • Consistency
  • LAB A: Create a basic control flow task
  • LAB B: Using variable and parameters
  • LAB C: Using a for each loop
  • LAB D: Using transactions and checkpoints

 

Module 4: Implementing extract, transform and load with SSIS

This module covers the aspects of the SSIS package working with the data flow.

Lessons:

  • Introduction to extract, transform and load (ETL)
  • Data sources
  • Destinations and transformations
  • LAB A: Using the SQL Server import and export wizard
  • LAB B: Profiling a source
  • LAB C: Implement a data flow with transformations

Module 5: Debugging and troubleshooting SSIS packages.

This module covers the tools available to record events and handle errors.

Lessons:

  • SSIS debugging
  • SSIS event logging
  • Error handling
  • LAB A: Debugging an SSIS package
  • LAB B: Configuring event logging
  • LAB C: Implement error handling

Module 6: Implementing an incremental ETL process

This module covers the creation and running of a SSIS package for implementing the change data capture (CDC) tool.

Lessons:

  • Introduction to incremental extract, transform and load
  • Configuring incremental ETL
  • Keeping historical data
  • LAB A: Using CDC
  • LAB B: Implementing slowly changing dimensions

Module 7: Deploying and configuring SSIS packages

This module covers the deployment and scheduling of SSIS packages. The packages can use environment variables.

Lessons:

  • Package deployment options
  • Running SSIS packages
  • Validation and logging
  • LAB A: Creating an SSIS catalog, environments and deploying a project
  • LAB B: Running an SSIS package

Why Choose Us

Experience Implementing a Data Warehouse using Microsoft SQL Server in Australia through Bilginç IT Academy's live and interactive virtual classroom environment. Join a Public course as an individual delegate or arrange a dedicated Private / In-house online training program exclusively for your organization.

  • Delivery Method: Online Instructor-Led
  • Participation Model: Public / Private (In-house)
  • Live and Interactive Training: Connect with your instructor in real time and actively participate through discussions, Q&A sessions, practical exercises, and group activities.
  • Flexible Participation: Join the training from your home, office, or any location with a suitable internet connection.
  • Expert Trainer Network: Learn from experienced trainers with strong industry backgrounds and practical field expertise.
  • Over 30 Years of Training Expertise: Benefit from Bilginç IT Academy's professional training experience since 1995.
  • Worldwide Access: Join our live virtual classrooms from Australia or anywhere else in the world, or arrange a dedicated online training program for your organization.

Experience Implementing a Data Warehouse using Microsoft SQL Server through face-to-face Classroom Based training in Australia. Training can be delivered as a Public course open to individual delegates or as a dedicated Private / In-house class for your organization.

  • Delivery Method: Classroom Based
  • Participation Model: Public / Private (In-house)
  • Face-to-Face Learning: Interact directly with your instructor and fellow delegates in an engaging classroom environment.
  • Experienced Trainers: Learn from specialists with extensive industry experience and practical real-world knowledge.
  • Professional Training Environment: Attend training in comfortable, well-equipped classrooms designed to support effective learning.
  • Practical Learning: Depending on the course, reinforce your knowledge through hands-on exercises, scenarios, case studies, and instructor-led activities.

Arrange Implementing a Data Warehouse using Microsoft SQL Server in Australia as a dedicated Onsite training program for your organization. Bilginç IT Academy trainers can deliver the training at your office or another location of your choice, with the program planned around your team's requirements and business objectives.

  • Delivery Method: Onsite
  • Participation Model: Private (In-house)
  • Training at Your Preferred Location: Organize the training at your company's office or another location selected by your organization.
  • Tailored Course Content: Adapt the training program to your projects, team structure, existing skill levels, and specific business requirements.
  • Team-Focused Learning: Develop your team around a shared knowledge base while strengthening internal collaboration and knowledge transfer.
  • Flexible Scheduling: Plan the training dates, location, and program according to your organization's operational requirements.
  • Worldwide Onsite Delivery: Arrange the training in Australia or at another preferred location worldwide. Bilginç IT Academy trainers can travel to your selected location to deliver the dedicated training program.
Contact us for more detail about our trainings and for all other enquiries!

Implementing a Data Warehouse using Microsoft SQL Server Training Course in Australia Schedule

Join our public courses in our Australia facilities. Private class trainings will be organized at the location of your preference, according to your schedule.

We can organize this training at your preferred date and location.
07 October 2026 (3 Days)
Sydney, Melbourne, Brisbane, Perth
AUD 4,700 +TAX
09 October 2026 (3 Days)
Sydney, Melbourne, Brisbane, Perth
AUD 4,700 +TAX
12 October 2026 (3 Days)
Sydney, Melbourne, Brisbane, Perth
AUD 4,700 +TAX
11 November 2026 (3 Days)
Sydney, Melbourne, Brisbane, Perth
AUD 4,700 +TAX
12 November 2026 (3 Days)
Sydney, Melbourne, Brisbane, Perth
AUD 4,700 +TAX
15 November 2026 (3 Days)
Sydney, Melbourne, Brisbane, Perth
AUD 4,700 +TAX
17 November 2026 (3 Days)
Sydney, Melbourne, Brisbane, Perth
AUD 4,700 +TAX
24 November 2026 (3 Days)
Sydney, Melbourne, Brisbane, Perth
AUD 4,700 +TAX

Australia’s technology scene is a powerhouse of innovation in the Southern Hemisphere, with Sydney, Melbourne, and Brisbane acting as world-class centers for fintech, cloud computing, and software development. The nation’s digital economy is supported by top-tier academic institutions like the University of New South Wales (UNSW) and the University of Melbourne, which foster a culture of research excellence in Cybersecurity and Artificial Intelligence. Australia has become a global leader in mining-tech and sustainable energy software, requiring a workforce that is proficient in the latest DevOps and Data Science frameworks. Our training solutions in Australia are designed to meet these high industry standards, offering specialized certifications that empower professionals to lead digital transformation projects across the Oceania region. We provide the technical expertise necessary to excel in a highly competitive and digitally integrated market that consistently attracts global tech investment.

Bilginç IT Academy All Rights Reserved

By using this website you agree to let us use cookies. For further information about our use of cookies, check out our Cookie Policy.