Student? Switch to our Career Center Site →
Contact Us

55321 SQL Server Integration Services

SQL Server Integration Services is the Community Courseware version of 20767CC Implementing a SQL Data Warehouse. This five-day instructor-led course is intended for IT professionals who need to learn how to use SSIS to build, deploy, maintain, and secure Integration Services projects and packages, and to use SSIS to extract, transform, and load data to and from SQL Server. This course is similar to the retired Course 20767-C: Implementing a SQL Data Warehouse but focuses more on building packages, rather than the entire data warehouse design and implementation.
Select Class Date
Course Details

Price:

$2,995.00

Days:

5

Location:

Virtual

Course Overview

SQL Server Integration Services is the Community Courseware version of 20767CC Implementing a SQL Data Warehouse. This five-day instructor-led course is intended for IT professionals who need to learn how to use SSIS to build, deploy, maintain, and secure Integration Services projects and packages, and to use SSIS to extract, transform, and load data to and from SQL Server. This course is similar to the retired Course 20767-C: Implementing a SQL Data Warehouse but focuses more on building packages, rather than the entire data warehouse design and implementation.
  • Scroll right to view Objectives, Prerequisites, and Agenda

Create sophisticated SSIS packages for extracting, transforming, and loading data Use containers to efficiently control repetitive tasks and transactions Configure packages to dynamically adapt to environment changes Use Data Quality Services to cleanse data Successfully troubleshoot packages Create and Manage the SSIS Catalog Deploy, configure, and schedule packages Secure the SSIS Catalog

Working knowledge of T-SQL and SQL Server Agent jobs is helpful, but not required. Basic knowledge of the Microsoft Windows operating system and its core functionality. Working knowledge of relational databases. Some experience with database design.

1 – Planning and implementing an IPv4 network

  • Planning IPv4 addressing
  • Configuring an IPv4 host
  • Managing and troubleshooting IPv4 network connectivity

2 – Implementing DHCP

  • Overview of the DHCP server role
  • Deploying DHCP
  • Managing and troubleshooting DHCP

3 – Implementing IPv6

  • Overview of IPv6 addressing
  • Configuring an IPv6 host
  • Implementing IPv6 and IPv4 coexistence
  • Transitioning from IPv4 to IPv6

4 – Implementing DNS

  • Implementing DNS servers
  • Configuring zones in DNS
  • Configuring name resolution between DNS zones
  • Configuring DNS integration with Active Directory Domain Services (AD DS)
  • Configuring advanced DNS settings

5 – Implementing and managing IPAM

  • Overview of IPAM
  • Deploying IPAM
  • Managing IP address spaces by using IPAM

6 – Remote access in Windows Server

  • Overview of remote access
  • Implementing the Web Application Proxy

7 – Implementing DirectAccess

  • Overview of DirectAccess
  • Implementing DirectAccess by using the Getting Started Wizard
  • Implementing and managing an advanced DirectAccess infrastructure

8 – Implementing VPNs

  • Planning VPNs
  • Implementing VPNs

9 – Implementing networking for branch offices

  • Networking features and considerations for branch offices
  • Implementing Distributed File System (DFS) for branch offices
  • Implementing BranchCache for branch offices

10 – Configuring advanced networking features

  • Overview of high performance networking features
  • Configuring advanced Microsoft Hyper-V networking features

11 – Implementing Software Defined Networking

  • Overview of SDN.
  • Implementing network virtualization
  • Implementing Network Controller
Select Class Date
Class Dates & Times
Filters Sort results
Reset Apply
03/30/2026 - 04/03/2026
Virtual
09:00:00 to 17:00:00 EST
Enroll Now
$2,995.00
07/27/2026 - 07/31/2026
Virtual
09:00:00 to 17:00:00 EST
Enroll Now
$2,995.00
12/08/2025 - 12/12/2025
Virtual
09:00:00 to 17:00:00 EST
Enroll Now
$2,995.00
— Questions?

Information Request

— Empower Change

Invest in Skills & Equality

Support Diversity, Equity, and Inclusion with Every Purchase.

Great Horizons is a North Carolina Certified HUB Vendor and WOSB. By becoming a patron of our organization, you are not only supporting a historically underutilized business, but a woman-owned small business as well.