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 Kazakhstan. 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 Kazakhstan. Our hand-picked classroom venues in Kazakhstan 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 Kazakhstan. Experience expert-led learning at your own business premises, tailored to your corporate goals.
Join our public courses in our Kazakhstan facilities. Private class trainings will be organized at the location of your preference, according to your schedule.
Kazakhstan stands as the preeminent technological and financial powerhouse of Central Asia, with the dynamic cities of Almaty and Astana serving as global magnets for innovation. The country is home to the Astana Hub, an international tech startup center, and Nazarbayev University, both of which are at the forefront of pioneering research in Artificial Intelligence, Blockchain, and Big Data analytics. Kazakhstan has achieved worldwide recognition for its advancements in digital mining and financial technologies, supported by a national strategy that prioritizes high-quality IT education and continuous professional development. Our comprehensive training programs are strategically designed to empower professionals in Kazakhstan to master complex corporate systems and lead large-scale digital innovation processes. By bridging the gap between local talent and global industry standards, we ensure that the Kazakh workforce remains highly competitive in the rapidly evolving Eurasian digital economy.
