Data parsing and database loading
Eeltutvustus
The course is aimed at those responsible for working with large amounts of data that comes from different sources and needs to be loaded to a common database. The course focuses on increasing automation and employing the more advanced tools offered.
Eesmärk
As a result of the course the participant will have overview of data flows in packages extract and how to load data between heterogeneous data stores, which may use a variety of standard and custom data types. The course will clarify how in a data flow, Integration Services sources do the work of extracting data, parsing string data, and converting data to an Integration Services data type.
The participant will understand how the data is loaded into a data store, how the destination may parse the data to convert it to a data type that the destination uses.
The participant will have knowledge of building intuitive data models and use filtering options to achieve higher efficiency of worktime.
Teemad
TIMETABLE
Day 1 at 19. december 2017 8:30 – 11.30 (4 academic hours).
3h -- Setup development environment and explain what the core tools do.
Day 2 at 28. december 2017 8:30 – 11.30 (4 academic hours).
3h -- File parsing and practice with basic programming concepts.
Day 3 at 2.January 2018 8:30 – 11.30 (4 academic hours).
3h -- Error handling and dealing with unexpected input.
Day 4 at 9.January 2018 8:30 – 11.30 (4 academic hours).
3h -- Building intuitive data models that read from and write to databases.
Day 5 at 16.January 2018 8:30 – 11.30 (4 academic hours).
3h -- Using the data models to write the parsed data into the database.
Day 6 at 23. January 2018 8:30 – 11.30 (4 academic hours).
3h -- More complex parsing and filtering operations that deal with corner cases.
Day 7 at 30. January 2018 8:30 – 11.30 (4 academic hours).
3h -- Building an admin interface that allows graphical access to the database.
Day 8 at 6. February 2018 8:30 – 11.30 (4 academic hours).
3h -- Making the database application future proof.
Day 9 at 13. February 2018 8:30 – 11.30 (4 academic hours).
3h -- Final assignment and assessment (4 academic hours).
Aeg ja maht
36 academic hours
Toimumiskoht
Tatari 58, 10134 Tallinn, Moepärli moeturu koolitusruumis.
Koolitajad
David Schryer Phd, Software developer at Thorgate
Maksumus
1350,00€ + VAT
Maksumus sisaldab
Training materials, training.
Lisainfo
Virve Roosimägi
virve.roosimagi@addenda.ee
tel +372 51 41 296