1. SylabUZ
2. Faculty of Computer Science, Electrical Engineering and Automatics
3. winter term 2022/2023
4. E-business - First-cycle Erasmus programme
5. System integration

Generate PDF for this page

System integration - course description

Aim of the course

Presentation of the software used for data integration. Education skills in programming ETL packages (Extract, Transform, Load). Presentation of knowledge in the methods and components used for system integration. Examples of the use of ETL systems.

Prerequisites

Save changes

Databases, Data warehouses and reporting services

Scope

Introduction to system integration using the ETL approach (Extract, Transform, Load). The architecture of ETL systems. Developing the ETL packages. Analysis of data sources and data destinations. Data modeling. Combine data from heterogeneous sources. Data transformation and integration methods. Profiling and cleaning of data. System integration for data warehouses and Business Intelligence systems.

 

Teaching methods

Lecture - conventional lecture using a video projector.
Laboratory - practical exercises in the computer laboratory.

Learning outcomes and methods of theirs verification

Outcome description	Outcome symbols	Methods of verification	The class form

Assignment conditions

Lecture - the passing criteria is to obtain positive grades from tests carried out at least once in a semester.

Laboratory - the passing criterion is to obtain positive marks for laboratory exercises and tests.

Final mark components = lecture: 50% + teaching laboratory: 50%

Recommended reading

1. Tok W-H., Parida R., Masson M., Ding x., Sivashanmugam K., Microsoft SQL Server 2012. Integration Services, APN Promise, 2012.
2. Cote C., Lah M., Sarka D., SQL Server 2017 Integration Services Cookbook: Powerful ETL techniques to load and transform data from almost any source, Packt Publishing, 2017.
3. Knight B., Knight D., Davis M., Snyder W., Knight's Microsoft SQL Server 2012 Integration Services 24-Hour Trainer, John Wiley & Sons, 2013.
4. Brian K., Professional Microsoft SQL Server 2014 Integration Services, Wiley & Sons, 2014.
5. Kimball, R., Caserta J., The Data Warehouse ETL Toolkit: Practical Techniques for Extracting, Cleaning, Conforming, and Delivering Data, Wiley, 2004.

Further reading

 

1. Aspin, A., SQL Server 2012 Data Integration Recipes: Solutions for Integration Services and Other ETL Tools, APress, 2012.
2. Ferrari A., Russo M. Introducing Microsoft Power BI, Microsoft, 2016.
3. Petkovic D., Microsoft SQL Server 2019: A Beginner's Guide, Seventh Edition, Microsoft, 2020.

Notes

Modified by dr hab. inż. Marek Kowal, prof. UZ (last modification: 28-04-2022 11:34)