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 Kuwait. 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 Kuwait. Our hand-picked classroom venues in Kuwait 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 Kuwait. Experience expert-led learning at your own business premises, tailored to your corporate goals.
Join our public courses in our Kuwait facilities. Private class trainings will be organized at the location of your preference, according to your schedule.
Kuwait is rapidly advancing its digital landscape as part of the 'New Kuwait 2035' vision, with Kuwait City serving as the nation’s primary hub for technological integration and financial services. The country is investing heavily in modernizing its public sector and national infrastructure through large-scale cloud computing and cybersecurity initiatives. Supported by institutions like Kuwait University and the Kuwait Institute for Scientific Research, the local tech ecosystem is shifting toward high-end data analytics and software engineering. Our IT training programs in Kuwait are strategically designed to support this national transformation, providing professionals with the elite technical skills required to manage sophisticated enterprise systems. We offer specialized certifications in Network Security, Cloud Architecture, and Digital Leadership to ensure that Kuwait's workforce remains at the forefront of the region's evolving digital economy.
