SQL Server Integration Services
Description
This course teaches how to build simple as well as complex data integration solutions using Microsoft SQL Server Integration Services. The course covers all aspects of development, deployment and administration of SSIS packages.
The course is based on SQL Server 2019, but it is relevant also for previous versions of SQL Server.
Intended audience
The course is intended for SQL Server developers, administrators and analysts who need to migrate and transform data amongst diverse platforms. Students should be familiar with the following topics:
Transact-SQL
SQL Server Agent
SQL Server Security
Topics
Introduction to SQL Server Integration Services
SSIS Historical Overview
SSIS Architecture
Tools of the Trade
Creating a Simple Package
SSIS Tasks
Tasks Overview
Data Preparation Tasks
RDBMS Server Tasks
Workflow Tasks
Administration Tasks
Script Task (.NET)
Working with Containers
Sequence Containers
Groups
For Loop Container
Foreach Loop Container
The Data Flow
Understanding the Data Flow
Sources & Destinations
Common Transformations
Other Transformations
Using Variables, Parameters and Expressions
Dynamic Package Objects
Understanding Data Types
Using Variables and Parameters
Working with Expressions
Loading a Data Warehouse
Data Profiling
Data Extraction and Cleansing
Dimension Table Loading
Fact Table Loading
SSAS Processing
Accessing Heterogeneous Data
The Connection Managers
Excel and Access
Oracle
Using XML and Web Services
Flat Files
Other Heterogeneous Sources
Scripting in SSIS
Introduction to Scripting in SSIS
The Script Component
The Script Task
Error and Event Handling
Package Transactions
Using Precedence Constraints
Event Handling
Breakpoints
Error Rows
Logging
SSIS Administration
Deployment Models
Security
Scheduling Packages
Monitoring Package Executions
High Availability and Disaster Recovery
Scale Out
האם אתה בטוח שאתה רוצה לסגור את הטופס ולאבד את כל השינויים?
