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).
The primary audience for this course is individuals who will administer and maintain a SQL Server data warehouse and create and maintain SSIS packages.
In addition to their professional experience, students who attend this training should already have the following technical knowledge:
Essential:
Nice to have:
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.
After completing this course, students will be able to:
Module 1 : Data warehouse Overview
This module introduces the main terms used within data warehousing.
Lessons:
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:
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:
Module 4: Implementing extract, transform and load with SSIS
This module covers the aspects of the SSIS package working with the data flow.
Lessons:
Module 5: Debugging and troubleshooting SSIS packages.
This module covers the tools available to record events and handle errors.
Lessons:
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:
Module 7: Deploying and configuring SSIS packages
This module covers the deployment and scheduling of SSIS packages. The packages can use environment variables.
Lessons:
Experience live, interactive learning from the comfort of your home or office with Bilginç IT Academy's Online Instructor-Led Implementing a Data Warehouse using Microsoft SQL Server Training in Global. Engage directly with expert trainers in a virtual environment that mirrors the energy and schedule of a physical classroom.
Immerse yourself in our most sought-after learning style for Implementing a Data Warehouse using Microsoft SQL Server Training in Global. Our hand-picked classroom venues in Global offer an invaluable human touch, providing a focused and interactive environment for professional growth.
Streamline your organization's training requirements with Bilginç IT Academy’s Onsite Implementing a Data Warehouse using Microsoft SQL Server Training in Global. Experience expert-led learning at your own business premises, tailored to your corporate goals.
Join our public courses in our Global facilities. Private class trainings will be organized at the location of your preference, according to your schedule.
Our IT training and professional development services reach a global audience, transcending geographical boundaries through advanced digital learning platforms and strategic international hubs. We specialize in delivering world-class curriculum across continents, ensuring that no matter where you are located, you have access to the latest industry certifications and technical expertise. By partnering with global technology leaders and academic institutions, we provide a unified learning experience that meets the demands of a diverse, international workforce. Our commitment to global excellence ensures that professionals in every time zone can master the digital skills required to lead, innovate, and thrive in the ever-evolving global technology landscape.
