Data Conversions training – 2 days – private courses from £1790 + vat

Data Conversions training uk

This Data Conversions training course benefits business users who co-ordinate the collection of data. Typical delegates would have good general appreciation of some computer office or studio applications. The delegates learn methods and tools to convert disparate forms of data. There is review of the nature and use of different forms of data.

Data Conversions Training Course Objective

Throughout the Data Conversions course there is illustration with practical examples. A key aspect of the course is the six workshops in which students develop their own data conversion skills, hands-on.

Data Conversions Training Course Content

Data store on different operating systems – their quirks
Cooks tour of media – best use and inherent limitations
Comma separated variable files – the de facto standard for table data
Passing data between essential office applications – suitable export format, using wizards
Loading relational databases – build SQL; mass inserts, updates, deletes
Exporting from relational databases – comma/pipe separated records or inserts
Web browser reference files – XML and wizards

Convert CSV &ndash XML &ndash HTML &ndash CSV
Email client reference and content files – lists and packed emails
Saving space - and then filling it up again; archiving and structured filing
Small proprietary databases – data files of PC-based stores
Unmasking the pretenders – beware false extensions; seek real nature
Legacy system data feeds – header and trailer records; streams of data
Simple parsing routines

Data Conversions Course Prerequisites

Students should be computer literate with hands-on knowledge of office applications and experience of at least two applications to generate their own ad hoc reports given raw data.

Hardware

This course requires a PC equipped with:

Means to load new programs files (Perl)from CD or the Internet (course tutor will install the program files)
Web Browser such as IE or Netscape Navigator
Email client such as MSOutlook, Eudora, Netscape Messenger
Word Processor
Spreadsheet
High speed Internet access

Data Conversions Training Recommended Reading

Data Conversion Handbook - Engineering Staff Analog Devices Inc – buy from amazon

home book this course resources 01273 622272 info@siliconbeachtraining.co.uk