Microsoft Official Courses (MOC)
Course 20463B: Implementing a Data Warehouse with Microsoft SQL Server 2014
About this Course:
-
-
This course describes how to implement a data warehouse platform to support a BI solution. Students will learn how to create a data warehouse with Microsoft SQL Server 2014, implement ETL with SQL Server Integration Services, and validate and cleanse data with SQL Server Data Quality Services and SQL Server Master Data Services.
-
Course Goals/Skills:
- Describe data warehouse concepts and architecture considerations.
- Select an appropriate hardware platform for a data warehouse.
- Design and implement a data warehouse.
- Implement Data Flow in an SSIS Package.
- Implement Control Flow in an SSIS Package.
- Debug and Troubleshoot SSIS packages.
- Implement an ETL solution that supports incremental data extraction.
- Implement an ETL solution that supports incremental data loading.
- Implement data cleansing by using Microsoft Data Quality Services.
- Implement Master Data Services to enforce data integrity.
- Extend SSIS with custom scripts and components.
- Deploy and Configure SSIS packages.
- Describe how BI solutions can consume data from the data warehouse.
Audience:
- This course is intended for database professionals who need to create and support a data warehousing solution. Primary responsibilities include:
- Implementing a data warehouse.
- Developing SSIS packages for data extraction, transformation, and loading.
- Enforcing data integrity by using Master Data Services.
- Cleansing data by using Data Quality Services.
Course Format:
Присъствен (Classroom) Курс в Учебната ни зала или В Офис на Клиент | Онлайн (Online/Virtual) Курс във виртуална зала с инструктор |
Course Language Option
Български (Bulgarian) | Английски (English) |
You can choose the language in which the training will be conducted – Bulgarian or English. All our instructors are fluent in English.
Student Guides:
The training materials are available in electronic format. They can be used online / offline on any device. Lifetime access.
Lab Environment:
Each student has their own lab environment where the exercises are conducted, part of the course. You do not need to install software on a computer or special hardware requirements.
Participants in a face-to-face format in our Training Center have an individual computer during the training.
At Course Completion:
Lifetime Access - Video Archive 24/7 | Certificate of Course Completion |
Lifetime access to a video archive with recording of each individual lecture.
Official internationally recognized certificate for completed training course.
Course Duration:
- 5 working days (09:00 – 17:00)
or - 40 hours training (theory and practice) in non-working hours lasting 4 weeks
Saturday and Sunday 10:00 – 14:00, 14:00 – 18:00, 18:00 – 22:00
Monday and Wednesday 19:00 – 23:00
Tuesday and Thursday 19:00 – 23:00
Payments:
An application for an invoice is accepted at the time of enrollment in the respective course.
An invoice is issued within 7 days of confirming the payment.
Next Class:
For more information, use the contact format. We will contact you to confirm the data.
Prerequisites:
-
-
-
-
- At least 2 years’ experience of working with relational databases, including:
- Designing a normalized database.
- Creating tables and relationships.
- Querying with Transact-SQL.
- Some exposure to basic programming constructs (such as looping and branching).
- An awareness of key business priorities such as revenue, profitability, and financial accounting is desirable.
-
-
-
Курсът подготвя за следните сертификационни нива
-
Exam 70-463: Implementing a Data Warehouse with Microsoft SQL Server 2014
- Може да се сертифицирате в нашия тест център с ваучер с отстъпка от цената на изпит.