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 Sweden. 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 Sweden. Our hand-picked classroom venues in Sweden 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 Sweden. Experience expert-led learning at your own business premises, tailored to your corporate goals.
Join our public courses in our Sweden facilities. Private class trainings will be organized at the location of your preference, according to your schedule.
Sweden is the historic birthplace of global technology legends like Spotify and Ericsson, maintaining its status as a world leader in software engineering and sustainable digital solutions. Stockholm and Gothenburg serve as premier destinations for innovation, fueled by the academic prestige of KTH Royal Institute of Technology and a culture that embraces early technological adoption. The Swedish tech scene is characterized by its leadership in game development, green-tech, and secure communication systems, fostering a highly collaborative and creative professional environment. Our IT training programs in Sweden are tailored to this culture of excellence, focusing on Software Architecture, Cloud-Native development, and Cyber Defense. We support the Swedish workforce in maintaining their competitive edge within a Nordic region that consistently sets the global benchmark for digital integration and social innovation.
