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.
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.
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).
36 academic hours
Tatari 58, 10134 Tallinn, Moepärli moeturu koolitusruumis.
David Schryer Phd, Software developer at Thorgate
1350,00€ + VAT
Training materials, training.
Virve Roosimägi
virve.roosimagi@addenda.ee
tel +372 51 41 296
Ilmselt on kõigile teada Eesti regulatsioon, mille kohaselt on töölepingu alusel töötavate töötajate põhipuhkuse minimaalseks kestvuseks 28 kalendripäeva ning avaliku teenistuse seaduse alusel avalikus teenistuses oleval ametnikul 35 kalendripäeva. Viimasel ajal on tõusetunud küsimus sellise erinevuse põhjendatusest. Tõenäoliselt tuleb era- ja avaliku sektori ...
