SQL Server Integration Services (SSIS)
Skill level: Beginner
To Study and pass Microsoft 70-763 certification
This course Introduces you to the basics of SQL Server Integration Services (SSIS) – with real Enterprise level practical activities.
SSIS is used to automate importing and exporting of data known as the ETL Process: extract, transform and load.
ETL is a very vital part of the Data framework and companies are paying a lot of money for talented ETL Developers.
In this class, you will learn how to use tasks, components and flowcharts.
What you’ll learn
- Do Extraction, Transform and Load (ETL) tasks.
- You can use SQL Server tables, Excel spreadsheets, SAS datasets, Microsoft Access and text files as your source.
- You’ll be able to change data types, add columns, aggregate, split, sort and join
- You can then view what has been created, and save it to spreadsheet, database tables, or the clipboard.
- Lectures 18
- Quizzes 1
- Duration 54 hours
- Skill level Beginner
- Language English
- Students 0
- Assessments Yes
Data Extraction and Loading
SSIS PROJECT (ETL Package)
SSIS PROJECT (Data migration SAS to SQL Server)
SSIS PROJECT (Data Migration Different Sources to SQL Server)