SQL Server Integration Services
Данный пятидневный курс под руководством инструктора предназначен для ИТ-специалистов, которым необходимо научиться использовать SSIS для создания, развертывания, обслуживания и защиты проектов и пакетов Integration Services, а также использовать SSIS для извлечения, преобразования и загрузки данных в SQL Server и из него. Данный курс в большей степени фокусируется на создании пакетов, а не на всей разработке и реализации хранилища данных.
Приобретаемые знания и навыки
- 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
Целевая аудитория
The primary audience for this course is database professionals who need to fulfil a Business Intelligence Developer role. They will need to focus on hands-on work creating BI solutions including Data Warehouse implementation, ETL, and data cleansing.Предварительные требования
- 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. SSIS Overview
- Import/Export Wizard
- Exporting Data with the Wizard
- Common Import Concerns
- Quality Checking Imported/Exported Data
2. Working with Solutions and Projects
- Working with SQL Server Data Tools
- Understanding Solutions and Projects
- Working with the Visual Studio Interface
3. Basic Control Flow
- Working with Tasks
- Understanding Precedence Constraints
- Annotating Packages
- Grouping Tasks
- Package and Task Properties
- Connection Managers
- Favorite Tasks
4. Common Tasks
- Analysis Services Processing
- Data Profiling Task
- Execute Package Task
- Execute Process Task
- Expression Task
- File System Task
- FTP Task
- Hadoop Task
- Script Task Introduction
- Send Mail Task
- Web Service Task
- XML Task
5. Data Flow Sources and Destinations
- The Data Flow Task
- The Data Flow SSIS Toolbox
- Working with Data Sources
- SSIS Data Sources
- Working with Data Destinations
- SSIS Data Destinations
6. Data Flow Transformations
- Transformations
- Configuring Transformations
7. Making Packages Dynamic
- Features for Making Packages Dynamic
- Package Parameters
- Project Parameters
- Variables
- SQL Parameters
- Expressions in Tasks
- Expressions in Connection Managers
- After Deployment
- How It All Fits Together
8. Containers
- Sequence Containers
- For Loop Containers
- Foreach Loop Containers
9. Troubleshooting and Package Reliability
- Understanding MaximumErrorCount
- Breakpoints
- Redirecting Error Rows
- Logging
- Event Handlers
- Using Checkpoints
- Transactions
10. Deploying to the SSIS Catalog
- The SSIS Catalog
- Deploying Projects
- Working with Environments
- Executing Packages in SSMS
- Executing Packages from the Command Line
- Deployment Model Differences
11. Installing and Administering SSIS
- Installing SSIS
- Upgrading SSIS
- Managing the SSIS Catalog
- Viewing Built-in SSIS Reports
- Managing SSIS Logging and Operation Histories
- Automating Package Execution
12. Securing the SSIS Catalog
- Principals
- Securables
- Grantable Permissions
- Granting Permissions
- Configuring Proxy Accounts
Информация о курсе
Вендор: Microsoft
Код курса: 55321
Продолжительность: 5 дней / 40 ак. часов
Направление: SQL Server
Форма обучения:
под руководством инструктора
