Setup Menus in Admin Panel

Course 7: SQL Server Integration Services (SSIS)


         This course is designed for those who want to learn how to create SQL SSIS packages that migrate data from various heterogeneous sources to a central point; while at the same time it will show the student how to extract, transform and load data to various destinations. The course will cover the following: 

    • Prerequisite courses: SQL Administration Part 1, 2, 3, Learn T-SQL and SSRS are highly recommended
    • Creating SSIS packaged from scratch
    • Executing Data transformation tasks such as, data conversion, term extraction, for each look container
    • Connecting to various databases sources and destinations
    • Examples of movement of data from heterogeneous environments and much more

    Course Curriculum

    1. SSIS Scripts and Docs
    SSIS Scripts and Docs 00:00:00
    2. Table of Contents
    Table of Contents 00:00:00
    3. Install SQL 2016 if you have not
    Install SQL 2016 if you have not 00:00:00
    4. Download Site for SQL 2016 Server
    Download Site for SQL 2016 Server 00:00:00
    5. Correction
    Correction 00:00:00
    6. Data Tools
    Data Tools 00:00:00
    7. Sample Database
    Sample Database 00:00:00
    8. What is SQL Server Integration Services
    What is SQL Server Integration Services 00:00:00
    9. SQL to SQL Export
    SQL to SQL Export 00:00:00
    10. SQL to Excel
    SQL TO Excel 00:00:00
    11. Control Flow vs Data Flow
    Control Flow vs Data Flow 00:00:00
    12. Create a Simple Package Using SSIS
    Create a Simple Package Using SSIS 00:00:00
    13. Truncate Table
    Truncate Table 00:00:00
    14. SQL to Flat File
    SQL to Flat File 00:00:00
    15. FTP
    FTP 00:00:00
    16. Conditional Split
    Conditional Split 00:00:00
    17. Conditional Split Truncate Table
    Conditional Split Truncate Table 00:00:00
    18. Derived Columns
    Derived Columns 00:00:00
    19. Character Map Transformation
    Character Map Transformation 00:00:00
    20. Merge Transformation
    Merge Transformation 00:00:00
    21. Union All
    Union All 00:00:00
    22. Multicast Transformation
    Multicast Transformation 00:00:00
    23. Aggregate Transformation
    Aggregate Transformation 00:00:00
    24. Term Extraction
    Term Extraction 00:00:00
    25. Audit Transformation
    Audit Transformation 00:00:00
    26. Data Conversion
    Data Conversion 00:00:00
    27. Backup Task
    Backup Task 00:00:00
    28. For Each Loop Container
    For Each Loop Container 00:00:00
    29. For Each Container Task
    For Each Container Task 00:00:00
    30. Foreach Loop Job
    Foreach Loop Job 00:00:00
    © Copyright by Rafacademy@2016