SylabUZ
Course name | System integration |
Course ID | 11.3-WE-BizElP-SystInteg-Er |
Faculty | Faculty of Computer Science, Electrical Engineering and Automatics |
Field of study | E-business |
Education profile | practical |
Level of studies | First-cycle Erasmus programme |
Beginning semester | winter term 2021/2022 |
Semester | 6 |
ECTS credits to win | 5 |
Course type | obligatory |
Teaching language | english |
Author of syllabus |
|
The class form | Hours per semester (full-time) | Hours per week (full-time) | Hours per semester (part-time) | Hours per week (part-time) | Form of assignment |
Lecture | 30 | 2 | - | - | Exam |
Laboratory | 30 | 2 | - | - | Credit with grade |
Presentation of the software used for data integration. Overview of typical data sources. Presentation of data cleaning and transformation methods. Familiarize students with the architecture of ETL systems (Extract, Transform, Load). Developing practical skills in operating selected systems supporting ETL processes. Presentation of the issue of semantic data integration. Familiarization with integration platform architectures.
Databases, Data warehouses and reporting services
Data integration using ETL (Extract, Transform, Load) systems. The architecture of ETL systems. Data sources: relational databases, flat files, XML, JSON. Data transformation and integration methods. Profiling and data cleansing. Software tools supporting the design and deployment of ETL processes. Structure of the ETL package. Learning to program ETL packages using SQL Server Integration Services (SISS). Configuration of SISS packages.
The architecture of the integration platforms. Enterprise ESB (Enterprise Service Bus) architecture. SOA (Service-Oriented Architecture). Microservices. REST and SOAP technologies.
Lecture - conventional lecture using a video projector.
Laboratory - practical exercises in the computer laboratory.
Outcome description | Outcome symbols | Methods of verification | The class form |
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%
Modified by dr hab. inż. Marek Kowal, prof. UZ (last modification: 21-07-2021 09:36)