Kurs: Implement and Maintain MS SQL Server 2005 Integration Services

Etter endt kurs skal du kunne:

    * Describe SQL Server Integration Services and its tools.
    * Create an Integration Services package.
    * Implement control flow in an Integration Services package.
    * Implement data flow in an Integration Services package.
    * Implement logging in an Integration Services package.
    * Debug and implement error handling in an Integration Services package.
    * Implement checkpoints and transactions in an Integration Services package.
    * Deploy an Integration Services package.
    * Manage and secure an Integration Services package.

Prisen inkluderer offisiell Microsoft dokumentasjon, lunch og kaffe/frukt/kjeks.

Forkunnskaper:

    * Exposure to enterprise data import and export scenarios.
    * Experience navigating the Microsoft Windows Server environment.
    * Experience with Microsoft SQL Server, including:
          o SQL Server Agent.
          o SQL Server query language (SELECT, UPDATE, INSERT, and DELETE).
          o SQL Server System tables.
          o SQL Server accounts (users and permissions).

Innhold:

    * Module 1: Introduction to SQL Server 2005 Integration Services
    * Module 2: Developing Integration Services Solutions
    * Module 3: Implementing Control Flow
    * Module 4: Implementing Data Flow
    * Module 5: Implementing Logging
    * Module 6: Debugging and Error Handling
    * Module 7: Implementing Checkpoints and Transactions
    * Module 8: Deploying Packages
    * Module 9: Managing and Securing Packages

Sertifisering:

Kurset leder (sammen med kursene MS 2793 og MS 2791 ) frem til test 70-445 (testene er ikke inkludert i kursprisen).

Ved bestått test får du tittelen Microsoft Certified Technology Specialist SQL Server Business Intelligence.

Målgruppe

Kurset retter seg mot database-administratorer, utviklere og databaseutviklere som har behov for å implementere ETL-løsninger (extract, transform and load), ved bruk av Microsoft SQL Server 2005 Integration Services.