LearnNowOnline_SSIS_2014_Concepts_and_Data_Tools

SSIS یا SQL Server Integration Services یکی از سرویس‌های SQL Server است که وظیفه آن فراهم کردن زیر ساختی برای تبدیل داده‌ها از یک ساختار به ساختار دیگر است.

در این آموزش تصویری با Concepts و Data Tools در SSIS 2014  آشنا می شوید.
این دوره آموزشی محصول موسسه LearnNowOnline است.

سرفصل های دوره:

  • کار با SSIS
  • نحوه یکپارچه سازی سرویس ها
  • کار با ابزارها و معماری برنامه
  • نحوه کنترل جریان
  • نحوه اولویت بندی داده ها
  • نحوه ایجاد داده ها
  • نحوه هدف گذاری برنامه
  • کار با اینترنت اکسپلورر
  • نحوه ساخت Package
  • کار با Export Wizard
  • نحوه انتقال داده ها
  • نحوه ذخیره  سازی داده ها
  • کار اب ابزارهای SSIS
  • نحوه کنترل جریان برنامه
  • معرفی Data Flow Task
  • کار با منبع ویرایشگر
  • کار با نرم افزارهای امنیتی
  • و…

عنوان دوره: LearnNowOnline SSIS 2014: Concepts and Data Tools
مدت زمان: 1 ساعت و 40 دقیقه
نویسنده: Don Kiely


توضیحات:

LearnNowOnline SSIS 2014: Concepts and Data Tools

Don Kiely
1h 40m


Course description
SQL Server Integration Services is part of the Microsoft suite of SQL Server Business Intelligence tools or BI Tools, which also includes Analysis Services and Reporting Services. Integration Services is Microsoft's Enterprise grade tool for the extraction, transformation and loading or ETL of data. It's designed to handle the migration and manipulation of data through the life cycle of a BI application and is a critical part of moving data in to data warehouses that is used in BI. But has usefulness far beyond BI applications. Any time you need to move data from one storage source to another, particularly if you need to change the data along the way, consider using Integration Services. In this course you'll learn about what Integration Services is good for and explore its architecture and components, you'll learn the basics of control and data flows. As well as how to make a connection to varies data sources and destinations. Then you'll learn about two of the main ways to create packages, import and export wizard, as well as how to build them from scratch using SQL Server Data Tools, which is Microsoft's replacement of the old Business Intelligence Studio or BIDS. You'll also see a couple of ways to execute packages, both within data tools as well as using the execute package utility.
Prerequisites
This course assumes that you have a basic familiarity with the concept of relational databases and a basic understanding of what SQL Server is and the high-level tools in it, as well as how to create and manage objects using Management Studio. You should also have a basic understanding of how SQL Server implements security, including its authentication and authorization schemes, and how to assign permissions on securable objects to principals. You should know the fundamentals of Transact-SQL to write queries to retrieve data and join data from multiple tables, and how to execute scripts using the query editor in Management Studio. You must also know how to connect to an instance of SQL Server 2012 using the various connection dialog boxes in Management Studio and development tools. It will be very helpful, but not absolutely necessary, to have experience with .NET development using Visual Studio 2012 or later for the portions of the course that deal with SQL Server Data Tools which is a lot of it. At the very least, we'll assume that you are well familiar with the Visual Studio user interface. This course assumes no prior knowledge of SQL Server Integration Services.

Understanding SSIS
17:52
Introduction
01:09
Integration Services and ETL
02:28
Architecture and Components 1
00:47
Architecture and Components 2
01:19
Control Flows
00:36
Tasks
03:36
Precedence Constraints
01:57
Containers - builds
00:34
Containers - purpose
04:28
Summary
00:53
IS Packages with IE Wizard
19:22
Introduction
00:34
Tools for Building IS Packages
03:47
Import and Export Wizard
00:47
Demo: Simple IS Package
03:57
Demo: Data Transfer
03:29
Demo: Save and Run Package
02:38
Demo: Successful I/E
01:59
Other Ways to Launch
01:55
Summary
00:10
Building Integrated Packages
27:03
Introduction
00:42
Demo: Integration Services
04:48
Demo: SSIS Toolbox
04:54
Demo: Control Flow
05:18
Demo: Transformations
02:36
Demo: Connection Managers
02:05
Demo: Event Handler
02:46
Demo: Package Explorer
03:22
Summary
00:29
Building Services Packages
17:03
Introduction
00:25
Demo: IS Project
04:44
Demo: Data Flow Task
04:07
Demo: Source Editor
02:56
Demo: Flat File Destination
04:04
Summary
00:45
Executing Packages
19:33
Introduction
00:36
Executing a Package
02:03
Demo: Export Package
04:51
Executing a Package w/o SSDT
02:01
Demo: Execute Package Utility
04:20
Demo: Connection Manager
05:23
Summary
00:17