Sign In   |   View Cart   |     |   Help
 
Course Catalog
 
Print Course information
E-mail to a friend
Return to Course Catalog

Courses and Programs > Community Education > Alphabetic Class List

SQL Server Integration Services (SSIS)  

Do you know how much faster SSIS performs under SQL Server 2012? If your agency is planning to upgrade or has already transitioned to SQL Server 2012, this class is for you. SSIS has exceptional Extract, Transform, Load (ETL) and integration capabilities, enabling you to more easily manage your agency’s data from a variety of sources. In this class you can practice making SSIS packages to transform data, create a workflow, and design maintenance routines in SQL Server 2012.
Learning Objectives: Upon successful completion of this course you should be able to:
  • Describe what is new in SSIS 2012
  • Use the Import and Export Wizards
  • Create packages with the SSIS package designer
  • Discuss the difference between control flow, data flow and packages
  • Design packages which transform data from one data source to another
  • Write basic scripts in .NET languages to allow custom data transformations
  • Work with reliability and scalability
  • Describe the relationship between connection sources and packages
  • Create event handlers to manage interaction and data flow
  • Encrypt sensitive information for more secure communication
  • Debug, troubleshoot and optimize packages
  • Resolve some of the more problematic issues associated with data transfers
Intended Audience: Experienced SQL database developers and managers. While previous knowledge of SSIS is not necessary, at least 6 months of administrative and development experience with SQL Server 2005, 2008, or 2012 is strongly recommended. Some knowledge of .NET programming is also useful.

 

SQL Server Integration Services (SSIS)

Item: C120 Bernie Benson
8:00 AM - 4:30 PM ONLINE
Sessions: 3 W Th F Location: ONLINE
, WA
9/2/2020 - 9/4/2020 Fee: $1,100.00

This class is offered online using Zoom and Remote Desktop.

Zoom Requirements:

  • Access to a computer with speakers & microphone (or the ability to call in via phone).
  • A web camera (suggested but not required).
  • Access to high-speed internet.

  • Zoom link will be sent prior to the start of class. You must have the ability to connect via Remote Desktop on your computer to participate in the class. A second monitor is recommended.

    Refund Policy: Cancellations must be received 5 business days prior to the 1st day of class in order to receive a full refund.