SQL Server Integration Services With Ron Davis

[xidau123 13]

 

SQL Server Integration Services With Ron Davis

506MB | Duration: 4h 09m | Video: AVC (.mp4) 1280x720 15fps | Audio: AAC 48KHz 2ch

Genre: eLearning | Level: Intermediate | Language: English

 

Microsoft SQL Server Integration Services, or SSIS, is an enterprise-level ETL tool: a tool for extracting, transforming, and loading data. Whether you're looking for information in flat files, via FTP, or on the web, SSIS allows you to transform it all into a uniform format for databases. In this course, Ron Davis teaches this mission-critical skill for IT professionals, developers, and data analysts. Ron covers the architecture of SQL Server Integration Services, the platform's tools, basic task scripting, and the variables, parameters, and expressions you can use to customize your ETL packages. Plus, discover how to use containers to group and repeat tasks, how to merge datasets with joins, and how to debug packages, and learn about common design patterns that will increase your efficiency in SSIS.

 

Topics include:

* Creating SSIS packages

* Coding and looping tasks

* Managing and administering SQL with SSIS tasks

* Optimizing data for extraction

* Making packages dynamic with variables and parameters

* Using sequences in a container

* Performing joins

* Handling errors

* Working with XML

 

Ukryta Zawartość

Treść widoczna tylko dla użytkowników forum DarkSiders. Zaloguj się lub załóż darmowe konto na forum aby uzyskać dostęp bez limitów.