Sisukord

Data parsing and database loading

Jaga

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


Jaga

Vandeadvokaat Annika Vait - Töötasu maksmise aeg, koht ja viis

Töölepingulistes suhetes kehtivad töötasu maksmise aja, koha ja viisi üldreeglid on sätestatud töölepingu seaduse §-s 33.  Tegemist on kõigile töölepingutele kohalduvate üldiste põhimõtetega, mida tuleks praktikas kindlasti järgida. Viidatud sätte esimese lõigu kohaselt maksab tööandja töötajale töötasu ...

Loe rohkem

Liitu meie uudiskirjaga

Addenda OÜ ei jaga teie andmeid kolmandate osapooltega ning kasutab saadud andmeid vaid uudiskirjade ja turundusmaterjalide edastamiseks.