Lynda SQL Server Integration Services
آموزش استفاده از امکانات و قابلیت های SQL Server Integration Services
- کاربرد : آموزش استفاده از امکانات و قابلیت های SQL Server Integration Services
- نوع فایل : فیلم آموزشی
- زبان : انگلیسی
- سیستم عامل : Windows-Mac-Linux-Android-iOS
- تولید کننده : Lynda
- سال تولید : 2000
توضیحات
با مشاهده این کورس آموزشی استفاده از امکانات و قابلیت های SQL Server Integration Services را بخوبی خواهید آموخت.
این مجموعه آموزش ویدیویی به مدت زمان 4 ساعت و 9 دقیقه در اختیار علاقه مندان قرار می گیرد.
این مجموعه آموزش ویدیویی به مدت زمان 4 ساعت و 9 دقیقه در اختیار علاقه مندان قرار می گیرد.
Description
Microsoft SQL Server Integration Services, or SSIS, is an enterprise-level ETL tool: a tool for extracting, transforming, and loading data. Whether you're looking for information in flat files, via FTP, or on the web, SSIS allows you to transform it all into a uniform format for databases. In this course, Ron Davis teaches this mission-critical skill for IT professionals, developers, and data analysts. Ron covers the architecture of SQL Server Integration Services, the platform's tools, basic task scripting, and the variables, parameters, and expressions you can use to customize your ETL packages. Plus, discover how to use containers to group and repeat tasks, how to merge datasets with joins, and how to debug packages, and learn about common design patterns that will increase your efficiency in SSIS.
Topics include:
Creating SSIS packages
Coding and looping tasks
Managing and administering SQL with SSIS tasks
Optimizing data for extraction
Making packages dynamic with variables and parameters
Using sequences in a container
Performing joins
Handling errors
Working with XML
Topics include:
Creating SSIS packages
Coding and looping tasks
Managing and administering SQL with SSIS tasks
Optimizing data for extraction
Making packages dynamic with variables and parameters
Using sequences in a container
Performing joins
Handling errors
Working with XML
