PoÄŤĂ­taÄŤová škola GOPAS  

Gopas CZ 
Gopas SK 
   
     Site map · Advanced search 
Offer of courses » Databases » Microsoft SQL Server » Microsoft SQL Server 2005 » Implementing and Maintaining Microsoft SQL Server 2005 Analysis Services


   print

MOC 2792 - Implementing and Maintaining Microsoft SQL Server 2005 Analysis Services

This three-day course is intended for developers and database system administrators and teaches participants about a totally new ETL tool available in SQL Server 2005.

Who the course is for

This three–day course is intended for developers and database system administrators

What we teach you

  • You will explore the uses and architecture of SSIS packages
  • You will learn how to work with Control Flow
  • You will learn how to work with Data Flow
  • You will learn how to use the advanced package options such as variables, activity logging and error capture
  • You will learn how to configure and deploy packages
  • You will learn how to administer SSIS packages

    Required skills

  • Familiarity with the principles of relations databases
  • Knowledge of SQL language
  • Familiarity with object–oriented programming and .NET architecture

    Teaching methods

    Expert instruction with practical examples, computer practice

    Teaching materials

    Books published by specialist publishers.

    Course syllabus

    Overview of SSIS

    • Typical uses
    • SSIS architecture
    • Tools and utilities in SSIS

    SSIS packages

    • Development environment
    • SSIS solutions and projects
    • Concept and structure of SSIS packages

    Working with Control Flow

    • Containers
    • Tasks
    • Flow control

    Working with Data Flow

    • Data sources
    • Transformations
    • Data destinations

    Advanced features of packages

    • Using variables
    • Activity logging
    • Error handling
    • Transaction processing

    Deploying packages

    • Configuring packages
    • Deploying packages
    • Package security

    SSIS administration

    • SSIS services administration
    • SSIS packages administration
    • Activity monitoring

    SSIS programming

    • Programmatic packages building
    • Programmatic packages saving and validation
    • Programmatic packages execution

    Recommended prior courses

    GOC34 - Microsoft SQL Server 2005/2008 – Business Intelligence – the Path to Success

    Recommended subsequent courses

    MOC 2781 - Designing Microsoft SQL Server 2005 Server–Side Solutions
    MOC 2782 - Designing Microsoft SQL Server 2005 Databases
    MOC 2783 - Designing the Data Tier for Microsoft SQL Server 2005
    MOC 2784 - Tuning and Optimizing Queries Using Microsoft SQL Server 2005 – Workshop
    MOC 2786 - Designing Microsoft SQL Server 2005 Infrastructure and Services
    MOC 2787 - Designing Security for Microsoft SQL Server 2005
    MOC 2788 - Designing High Availability Database Solutions Using Microsoft SQL Server 2005
    MOC 2789 - Administering and Automating Microsoft SQL Server– 2005 Databases and Servers
    MOC 2790 - Troubleshooting and Optimizing Database Servers Using Microsoft SQL Server 2005 – Workshop

    Catalog price of course and handbook

    Locality Course price ex VAT Price of handbook ex VAT Number IT points
     Praha   11700 Kč  4700 Kč   30 items
     Brno   11400 Kč  4700 Kč   30 items

    Course dates

    Course date Course length Locality Price ex VAT Handbook ex VAT  Speaker language  
     31.01.2011   3   GOPAS Praha   11700 Kč 4700 Kč Course
     27.09.2010   3   GOPAS Bratislava   390 EUR 179 EUR Course
     17.01.2011   3   GOPAS Bratislava   390 EUR 179 EUR Course

    If none of the offered dates suits you, please contact our customer service department on tel. +420 234 064 900-3 (Prague), +420 542 219 935-6 (Brno).