SQL Server Integration Services (SSIS) – an introduction

47

LESSONS

ALL

SKILL LEVEL

3:52 hr

DURATION

ENGLISH

AUDIO

ENG/ESP

SUBTITLES

OVERVIEW

SQL Server Integration Services (SSIS) is a way to automate in the importing and exporting and data or ETL: extract, transform and load. It is a visual part of SSIS, using tasks, components and flowcharts, so it is simple to learn the basics. The course covers:

  • Extraction, Transform and Load (ETL) tasks.
  • Using SQL Server tables, Excel spreadsheets and text files as your source.
  • Changing data types, adding columns, aggregating, splitting, sorting and joining.
  • Viewing what has been created, and saving it to a spreadsheet, database table, or the clipboard.

On completion of this course, you will be confident in using the main Data Flow components and Control Flow tasks, and will be able to apply it to your own work.

.

WHO IS THE COURSE FOR?

No prior knowledge of SQL Server is required.

Some experience of T-SQL is desirable but not essential.

.

LEARNING PATH

INSTALLATION

  • Install SQL Server Developer, Visual Studio, and SSIS.
  • Familiarisation with SQL Server Management Studio (SSMS) and SSIS.

EXTRACT AND LOAD TASKS

  • Data Flow Task.
  • Connection Manager.
  • OLE DB Source Task.
  • OLE DB Destination.

TRANSFORMING

  • Implicit Conversions.
  • Data Conversion.
  • Derived Column task.
  • Aggregation.
  • Multi-cast.
  • Conditional Split.
  • Error handling.
  • Sort.
  • Adding an Excel source.
  • Add Text source and Excel destination.
  • Union All.
  • Merge and solving Mapping problems.
  • Auditing.
  • Adding different destinations.

CONTROL FLOW TASKS

  • Adding variables and Row Count.
  • Script component.

REVIEWS

“Awesome explanation! Very simple and understandable. I am very glad that I took this course!” Shuhail Abdul

“Just wow, with zero prior knowledge, I really learnt a lot from this course. I’d highly recommend it to anyone wanting to learn about ETL.” Bond

“Excellent course! Informative and easy to follow instructions. Instructor was organized, and it was easy to understand his presentations and practice activities. Thank you!” Sue

.

READY TO START?