Introduction to SQL Server Integration Services -SSIS
4.1 (15 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
1,204 students enrolled
Wishlisted Wishlist

Please confirm that you want to add Introduction to SQL Server Integration Services -SSIS to your Wishlist.

Add to Wishlist

Introduction to SQL Server Integration Services -SSIS

A beginners introduction to SQL Server Integration Services -SSIS
4.1 (15 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
1,204 students enrolled
Last updated 1/2017
English
Current price: $10 Original price: $125 Discount: 92% off
5 hours left at this price!
30-Day Money-Back Guarantee
Includes:
  • 3 hours on-demand video
  • 2 Supplemental Resources
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
What Will I Learn?
  • Perform data extraction
  • Perform data transformation
  • Load data into one or more destinations
View Curriculum
Requirements
  • Basic knowledge of SQL
  • Basic knowledge of T- SQL
  • Basic knowledge of database concepts
Description

SQL Server Integration Services (SSIS) is a useful  and powerful Business Intelligence Tool . It is best suited to work with SQL Server Database . It is added to SQL Server Database when you install SQL Server Data Tools  (SSDT)which adds the Business Intelligence Templates to Visual studio that is used to create Integration projects.

This course is a beginners course to SSIS and will teach relevant skills that will give you
the confidence to use the tool.

SSIS can be used for:

• Data Integration
• Data Transformation
• Providing solutions to complex Business problems
• Updating data warehouses
• Cleaning data
• Mining data
• Managing SQL Server objects and data
• Extracting data from a variety of sources
• Loading data into one or several destinations


What You Will Learn ....

• How to install SQL Server Database
• How to download and attach a database to SQL Server
• How to download and install SQL Server Data Tools
• How to Create a New Integration Services Project
• How to add and Configuring a Flat File Connection Manager
• How to add and Configuring an OLE DB Connection Manager
• How to add a Data Flow Task to the Package
• How to add and Configuring the Flat File Source
• How to add and Configuring the Lookup Transformations
• How to Create Integration Services Tasks
• How to Create  New Connection Manager
• How to Write data to a SQL Server database
• How to Execute a package from SQL Server Data Tools
• How to Control Data Flow for Flat Files
• How to test  Packages
 
On completion of this course you will be able to use SSIS to perform basic:

• Data extract  
• Data Transform
• Data Load

I look forward to welcoming you to the course :-)


Who is the target audience?
  • Aspiring Data Analyst
  • Aspiring Data warehouse professionals
  • Aspiring Database Administrators
  • Aspiring SQL developers
  • Anyone with basic SQL and T-SQL basic knowledge
Students Who Viewed This Course Also Viewed
Curriculum For This Course
32 Lectures
03:05:48
+
Getting the lab environment ready
13 Lectures 01:09:16




Finishing visual studio installation and configuration
05:09

Working with Solution explorer and Projects
11:44

Hardware and Software Requirements for SQL Server
02:49

Download SQL Server Express 2014
04:07

Install SQL Server Express2014
06:47

Download Adventureworks 2014 Database
05:06

Add Adventureworks 2014 Database to SQL Server
04:14

Download and attach AdventureworksDW2014
06:39

Download and Install SQL Server Data Tools -SSDT
06:03
+
Creating basic ETL(Extract,Transform,Load) process with SSIS
11 Lectures 01:09:17
Create new Integration Services Project
05:35

Adding a Flat File Connection Manager
06:26

Remapping Column Data Types
11:12

Add and Configure OLE DB Connection Manager
03:39

Add a Data Flow Task to Package
05:02

Add and Configure Flat File Source
04:28

Add and Configure Lookup Transformation
11:29

Add and Configure Lookup for DateKey Transformation
09:28

Add and Configure OLE DB Destination
07:53

Testing SSIS Package
02:02

Summary
02:03
+
How to implement Lookup Logic in SSIS
8 Lectures 47:15
Introduction
03:29

Create new SSIS Package
04:05

Write data to cache - Part 1
08:10

Write data to cache - Part 2
07:09

Performing lookups from cached data - Part1
09:22

Performing lookups from cached data - Part2
09:16

Running Your SSIS Package
03:36

Conclusion
02:08
About the Instructor
Bluelime Learning Solutions
4.1 Average rating
1,556 Reviews
35,095 Students
85 Courses
Learning made simple

Bluelime is UK based and creates quality easy to understand eLearning solutions .All our courses are 100% video based. We teach hands –on- examples that teach real life skills .

Bluelime has engaged in various types of projects for fortune 500 companies and understands what is required to prepare students with the relevant skills they need.