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 Ireland. 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 Ireland. Our hand-picked classroom venues in Ireland 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 Ireland. Experience expert-led learning at your own business premises, tailored to your corporate goals.
Join our public courses in our Ireland facilities. Private class trainings will be organized at the location of your preference, according to your schedule.
Ireland has firmly established itself as the premier digital gateway to Europe, with Dublin and Cork serving as the regional headquarters for the world's most influential technology giants. Known as the 'Silicon Docks,' the Irish tech ecosystem thrives on a unique blend of high-level academic research and a pro-business environment, supported by institutions like Trinity College Dublin and University College Cork. The country is a global leader in software localization, pharmaceutical tech, and cloud-based enterprise solutions, attracting top-tier talent from across the globe. Our IT training programs in Ireland are designed to meet the rigorous demands of these multinational corporations, focusing on advanced certifications in Data Analytics, Cybersecurity, and Cloud Architecture. We empower professionals to excel in a high-growth environment that remains at the absolute center of the global digital economy and innovation.
