Home > SQL Server Training CD ROMs > SQL Server 2005 Integration Services

SQL Server 2005 Integration Services

SQL Server 2005 Integration Services
Item# ZSQIS-CD-50
Regular price: $1,495.95
Sale price: $1,295.95

Select:: 

Product Description

This course will enable technology professionals with little or no ETL experience and minimal exposure to SQL Server 2005 and Visual Studio 2005 to be comfortable and productive with the SSIS tools and technologies. In this course you will learn about the SQL Server Management Studio (SSMS) and building Database Maintenance Plans. You will be introduced to the Business Intelligence Development Studio (BIDS) and working with Control Flow and Data Flow. You will also become familiar with SSIS package management and package deployment along with learning to write solid code using debugging, error handling and logging techniques.

Introduction to SQL Server Integration Services

  • Product History
  • SSIS Package Architecture Overview
  • Development and Management Tools
  • Deploying and Managing SSIS Packages
  • Source Control for SSIS Packages
    •

    SSIS for DBAs: Using SQL Server Management Studio

  • The Import and Export Wizard
  • Importing and Exporting Data
  • Working with Packages
  • Database Maintenance Plans
  • Creating Database Maintenance Plans using SSMS
  • Scheduling and Executing Plans
  • Examining Database Maintenance Plan Packages
  • Changes in SQL Server 2005 Service Pack 2
    •

    Business Intelligence Development Studio

  • Launching BIDS
  • Project templates
  • The package designer
  • The Toolbox
  • Solution Explorer
  • The Properties window
  • The Variables window
  • The SSIS menu
    •

    Introduction to Control Flow

  • Control Flow Overview
  • Precedence Constraints
  • The Execute SQL Task
  • The Bulk Insert Task
  • The File System Task
  • The FTP Task
  • The Send Mail Task
    •

    Advanced Control Flow

  • Containers – grouping and looping
  • The Web Service Task
  • The WMI tasks
  • The Analysis Services tasks
  • The Execute Process Task
  • The Execute Package Task
    •

    Introduction to Data Flow

  • Data Flow Overview
  • Data Sources
  • Data Destinations
  • Data Transformations
  • The Copy Column Transformation
  • The Derived Column Transformation
  • The Data Conversion Transformation
  • The Conditional Split Transformation
  • The Aggregate Transformation
  • The Sort Transformation
  • Data Viewers
    •

    Variables and Configurations

  • Variables Overview
  • Variable scope
  • SSIS system variables
  • Using variables in control flow
  • Using variables in data flow
  • Using variables to pass information between packages
  • Property expressions
  • Configuration Overview
  • Configuration options
  • Configuration discipline
    •

    Debugging , Error Handling and Logging

  • SSIS debugging overview
  • Breakpoints in SSIS
  • SSIS debugging windows
  • Control Flow: The OnError event handler
  • Data Flow: Error data flow
  • Configuring Package Logging
  • Built-in log providers
    •

    Advanced Data Flow

  • Revisiting data sources and destinations
  • The Lookup Transformation
  • Getting Fuzzy: The Fuzzy Lookup and Fuzzy Grouping Transformations
  • The Multicast Transformation
  • The Merge and Merge Join Transformations
  • The Data Mining Query Transformation
  • The Data Mining Model Training Destination
  • The Slowly Changing Dimension Transformation
    •

    Extending SSIS through Custom Code

  • Introduction to SSIS scripting
  • The SSIS script editor
  • The SSIS object model
  • Script in Control flow: The Script Task
  • Script in Data flow: The Script Component
  • Introduction to SSIS component development
    •

    SSIS Package Deployment

  • Configurations and deployment
  • The deployment utility
  • Deployment options
  • Deployment security
  • Executing packages – DTExec and DTExecUI
    •

    SSIS Package Management
  • The SSIS Service
  • Managing packages with DTUtil
  • Managing packages with SQL Server Management Studio
  • Scheduling packages with SQL Server Agent
    •

    Your Instructor

    This course will be presented and written by Chris Randall.


    Multimedia Training DVD Course Features:

    Main Menu
    Move through hours of in-depth content - quickly and easily due to the efficient and organized structure.

    PowerPoint
    Utilizing PowerPoint presentations enhances the delivery by displaying a variety of visual information to the user. This type of representation allows the user to better interpret the material through charts, definitions, graphs, and more...

    Exclusive Learning Zone
    Train around the clock, around the world. Our certified online instructors are located at global support centers in the U.S., U.K., Australia, and Singapore to provide real-time answers to technology- and soft-skill-related questions 24x7. This means access to a live subject matter expert no matter where you are - day or night. This level of student/instructor interaction provides real-time training specific support and extends training beyond content and instructor-led solutions by providing flexibility to accommodate individual needs and schedules.

    Controls
    Move forward, back, and repeat entire topics or just a section. A progress bar illuminates as you advance through exercises.

    Full Motion Video
    All courses feature full-motion videos of instructors teaching the information as if they are speaking directly to you. Our unique delivery simulates a one-on-one classroom environment creating a more personal lesson and learning experience.

    Study Guides
    Printable study guides for the entire course are available. This allows all material to be viewed, reviewed, and printed for viewing at a later date.

    Review Exercises
    Each section has a review quiz to aid in the learning process by validating the comprehension of the material covered before moving on to a new section.

    Resume
    All courses are resumed to where you left off last session allowing you to learn when it is convenient for you without the hassle of remembering where you where.

    Live Demonstrations
    Demonstrations are a way for the instructor to show and tell the user how to perform a task by actually doing it on screen in front of them. In this format it gives the user the power to see things done by a professional in the intended environment as many times as they would like.

    Certificate of Completion
    Planetlearn's Career Academy is recognized worldwide for its technology-based IT training curriculums. Upon successful completion of our program, you will be receiving a Career Academy Distance Education Certificate of Completion.

    "Training Desktop Users, IT, and Business Professionals since 1997."
    computer training DVD's, cd roms, for Microsoft, Oracle, Novell, CompTia, Adobe, Macromedia, IBM, and more...

    Yahoo has awarded us with the Top Service Star! "Those with a star are the best of the best, with at least 95% positive ratings."

    		software training, microsoft office training, cisco certification, microsoft certification