->
Lynda - SQL Server Integration Services (2015) - 191941
Lynda - SQL Server Integration Services (2015)
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.


Table of Contents

  • Introduction
  • 1. Architecture
  • 2. SQL Server Integration Services Tools
  • 3. SQL Server Integration Services Tasks
  • 4. Data Flow
  • 5. Variables, Parameters, and Expressions
  • 6. Performing Joins
  • 7. Debugging SQL Server Integration Services Packages
  • 8. Common Designs in SQL Server Integration Services
  • Conclusion
  • Lynda - SQL Server Integration Services (2015)


     TO MAC USERS: If RAR password doesn't work, use this archive program: 

    RAR Expander 0.8.5 Beta 4  and extract password protected files without error.


     TO WIN USERS: If RAR password doesn't work, use this archive program: 

    Latest Winrar  and extract password protected files without error.


     Coktum   |  

    Information
    Members of Guests cannot leave comments.




    rss