Home Courses Instructor Labs

SQL Server Integration Services (SSIS) - Introduciton

(17 Ratings) 1809 Students Enrolled
Created By David P Last Updated Mon, 16-Mar-2020 English
  • Course Duration
    4 Hours
  • Mode of Training
    Self-Paced
  • Lessons
    32 Lessons
  • Validity
    Life Time
$ 140 $ 20 86% off 100% Money Back Guarantee
12k+ satisfied learners Read Reviews
What Will I Learn?
  • Perform ETL (Extraction, Transformation & Load) Task
  • Learn how to change data types, add columns, aggregate, split, sort and join
  • How to use SQL Server tables, Excel spreadsheets and text files as your source
  • Save changes to the Spreadsheet, database tables or to the clipboard

Requirements
  • No prior experience in SQL server required
+ View More
Description

In this coursse, you will be downloading and installing the latest 2016 SQL Server Developer which is totally for free which is used in your course.

SSIS is SQL Server Integration Services which is to automate the importing and exporting the data or ETL(Extract, Transform and Load). It is a visual part of SSIS, using tasks, components and flowcharts. Hence it is easy to learn the basics of it.

We will we extracting the data from one table and then load into the another table. We will learning transformation, aggregation, conditional split, merging and auditing.

This course is also designed for one who is preparing for Microsoft certificates 70-463 as well.

Curriculum For This Course
32 Lessons 4 Hours
  • Download SQL Server 2016 00:07:50 Preview
  • Installing SQL Server 00:13:50
  • Install SQL Developer Part 2 00:12:34
  • Running SSMS and SSIS 00:09:03
  • Looking around SSIS 00:07:49
  • Data Flow Task 00:06:14 Preview
  • Connection Manager 00:07:56
  • OLE DB Source Task 00:11:07
  • OLE DB Destination 00:06:00
  • Data Viewer 00:05:29
  • Practice Activity - Extract and Load 00:04:03
  • Implicit Conversions 00:06:26
  • Data Conversion 00:08:23
  • Derived Column task 00:08:15
  • Practice Activity - Altering Data Type 00:04:24
  • Aggregation 00:04:15
  • Multi-cast 00:05:19 Preview
  • Conditional Split 00:05:27
  • Error handling 00:10:34
  • Row Sampling and Percentage Sampling 00:03:30
  • Practice Activity - Aggregation 00:02:32
  • Sort 00:08:24
  • Adding an Excel source 00:11:01
  • Add Text source and Excel destination 00:08:18
  • Practice Activity - Percentage Sampling and Conditional Split 00:03:49
  • Union All 00:10:04
  • Merge and solving Mapping problems 00:04:10
  • Add some auditing 00:07:23
  • Adding different destinations 00:04:09
  • Practice Activity - Different data sources, sort, merge and auditing 00:02:29
  • Adding Variables and Row Count 00:06:45
  • Script component 00:04:54

SQL Server Integration Services (SSIS) - Introduciton