SQL Server Integration Services
0.0 (0 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
3 students enrolled

SQL Server Integration Services

SQL Server Integration Services
0.0 (0 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
3 students enrolled
Last updated 11/2019
English
Current price: $13.99 Original price: $19.99 Discount: 30% off
5 hours left at this price!
30-Day Money-Back Guarantee
This course includes
  • 1.5 hours on-demand video
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
Training 5 or more people?

Get your team access to 4,000+ top Udemy courses anytime, anywhere.

Try Udemy for Business
What you'll learn
  • Perform basic ETL(Extract Transform Load) tasks at your work
  • Analyze data and do marketing more effectively for a particular application
  • Build reports for any category of data
Requirements
  • Students must know the basics of SQL.
Description

What is Microsoft SQL Server? Microsoft SQL Server is a relational database management system, or RDBMS, that supports a wide variety of transaction processing, business intelligence and analytics applications in corporate IT environments. It's one of the three market-leading database technologies, along with Oracle Database and IBM's DB2. SQL Server Integration Services is a platform for data integration and workflow applications. It features a data warehousing tool used for data extraction, transformation, and loading (ETL). The tool may also be used to automate maintenance of SQL Server databases and updates to multidimensional cube data. You will learn the basics about the development tools and what they are capable of, clear instruction on how to handle various issues that you might face when designing your packages and how to overcome them. By the end of this course you will understand many basic concepts and how to perform data integration and transformation.

Who this course is for:
  • Database Managers
  • Database Administators
  • Database Developers
Course content
Expand all 52 lectures 01:15:40
+ Module 2: Creating a Simple ETL Package | Create Project and Basic Package
10 lectures 13:55
Creating a New Integration Services Project
00:58
Adding and Configuring a Flat File Connection Manager
02:52
Adding and Configuring an OLE DB Connection Manager
00:52
Adding a Data Flow Task to the Package
02:05
Adding and Configuring the Flat File Source
01:45
Adding and Configuring the OLE DB Destination
01:37
Making the Package Easier to Understand
01:03
Testing the Package
00:58
+ Module 2: Creating a Simple ETL Package | Adding Looping
5 lectures 05:09
Creating a Simple ETL Package | Adding Looping
00:13
Copying the Lesson 1 Package
01:19
Adding and Configuring the Foreach Loop Container
02:02
Modifying the Flat File Connection Manager
00:55
Testing the Package
00:40
+ Module 2: Creating a Simple ETL Package | Adding Logging
4 lectures 03:29
Creating a Simple ETL Package | Adding Logging
00:13
Copying the Lesson 2 Package
00:34
Adding and Configuring Logging
02:07
Testing the Package
00:35
+ Module 2: Creating a Simple ETL Package | Adding Error Flow Redirection
6 lectures 08:33
Creating a Simple ETL Package | Adding Error Flow Redirection
00:13
Copying the Lesson 3 Package
00:35
Creating a Corrupted File
00:48
Adding Error Flow Redirection
03:48
Adding a Flat File Destination
01:48
Testing the Package
01:21
+ Module 2:Creating a Simple ETL Package | Adding Package Deployment Configuration
5 lectures 07:14
Creating a Simple ETL Package | Adding Package Deployment Configuration
00:13
Copying the Lesson 4 Package
00:27
Enabling and Configuring Package Configurations
04:41
Modifying the Directory Property Configuration Value
01:16
Testing the Package
00:37
+ Module 2: Creating a Simple ETL Package | Using Project Deployment Parameters
5 lectures 11:51
Creating a Simple ETL Package | Using Project Deployment Parameters
00:13
Copying the Lesson 5 Package
00:32
Converting the Project to the Project Deployment Model
08:10
Testing the Package
00:21
Deploying the Package
02:35
+ Module 3: Deploying Packages | Preparing to Create the Deployment Bundle
6 lectures 07:43
Deploying Packages | Preparing to Create the Deployment Bundle
00:13
Creating Working Folders and Environment Variables
01:02
Creating the Deployment Project
01:11
Adding Packages and Other Files
03:22
Adding Package Configurations
01:14
Testing the Updated Packages
00:41
+ Module 3: Deploying Packages | Creating the Deployment Bundle
3 lectures 02:02
Deploying Packages Using The Package Deployment Model | Creating the Deployment
00:13
Building the Deployment Utility
00:53
Verifying the Deployment Bundle
00:56