Implementing a SQL Data Warehouse
This 4-day instructor led course provides students how to design and build a data warehouse, how to implement ETL processes, how to validate, clean, consolidate and check data using SQL Server Integration Services (SSIS).
Code
DB-DW
Course length
4
days
(8:30 – 16:00)
Form
In our classroom or online
Questions about the course?
Ing. Jitka Sotonová
Leader of training center
Dates
This course is intended for
This course is intended for end users, Database Administrators, IT Managers, Database Developers, and BI professionals.
Syllabus
Module 1: Design and implementation of the data warehouse
- Lesson 1: Data Warehouses
- Lesson 2: Data Warehouse Design
- Lesson 3: Infrastructure Planning
- Lesson 4: Dimensions
- Lesson 5: Facts
- Lesson 6: Indexes
Module 2: Creating ETL solutions
- Lesson 1: Introduction to ETL using SSIS
- Lesson 2: Data Sources
- Lesson 3: Implementing Data Flow
- Lesson 4: Implementing Control Flow
- Lesson 5: Dynamic packages, parameters, variables
- Lesson 6: Checkpoints, transactions
Module 3: Debugging and Troubleshooting
- Lesson 1: Debugging packages
- Lesson 2: Logging
- Lesson 3: Troubleshooting
Module 4: Implementing Data Transfers
- Lesson 1: Incremental ETL
- Lesson 2: Extraction of modifications
- Lesson 3: Load data
- Lesson 4: Change tracking
Module 5: Extending Integration Services
- Lesson 1: Using and creating scripts
- Lesson 2: Using components and connectors
Module 6: Deploying, running and configuring SSIS packages
- Lesson 1: Deploying SSIS packages, configuring SSIS
- Lesson 2: Running SSIS packages
- Lesson 3: Permissions and security
- Lesson 4: Using DW data
Students will be able to
- Describe the basic elements of data warehouse.
- Describe HW and SW requirements for data warehouse.
- Implement logical and physical data warehouse structure.
- Implement data flow in SSIS.
- Implement control flow in SSIS.
- Create dynamic packages using parameters and variables.
- Debug SSIS packages.
- Describe and implement the ETL solution.
- Describe and use custom components to extend SSIS.
- Deploy and secure SSIS projects.
Course requirements
- TSQL-Language.
- Basic knowledge of SQL Server and databases.
- Basic knowledge of the Microsoft Windows operating system.
Hardware
Classrooms are equipped with high-performance computers with Internet access and the possibility of wireless connection.
Literature
All participants will get internal OKsystem student materials.
Prices do not include VAT. OKsystem a.s. reserves the right to change dates and prices of courses.
Similar courses
Take a look at some similar courses from our wide range.
High Availability in SQL Server MSSQL-HA
Performance Tuning and Optimizing SQL Databases DB-TUNING
Writing Queries Using SQL SQL-Jazyk 1
Need some advice?
Do not hesitate to contact us. We are at your disposal and will be happy to help you.
Why OKškolení?
What are the main advantages of our training centre?
36+ years in business
We have been on the market for more than 36 years and have a wealth of experience in this field.
We are a training center with a rich history and tradition.
Experienced tutors
The basis of any quality education is good and experienced lecturers and this is something that we at OKškolení take particular pride in. Our top lecturers are waiting for you.
Modern classrooms
All classrooms are spacious, air-conditioned, barrier-free and equipped with high-standard computers, with Wi-Fi connection.
Bonus program
Protect your investments into education, loyalty program, advantageous offers, refreshments, grants...
Contact us
Do not hesitate to contact us with any questions you may have.
Do you need to know more about us or would you prefer to contact us using the form?
