What Will You Learn?
At the end of this course, students will be able to deploy and automate process to extract data from various sources, transform them so that the data can be queried, and finally load them into a warehouse using SQL Server Integration services. They would be able to apply these concepts in their day to day projects, where there might be a need to move data across systems and store it in a friendly query-able format for reporting and analysisAbout This Course
Provider: Udemy
Format: Online
Duration: 1hr 37min to complete [Approx]
Target Audience: Beginners
Learning Objectives: At the end of this course, students will be able to deploy and automate process to extract data from various sources, transform them so that the data can be queried, and finally load them into a warehouse using SQL Server Integration services.
Course Prerequisites: NA
Assessment and Certification: NA
Instructor: Rakesh Gopalakrishnan
Key Topics: Deploy and automate process to extract data, transform data, load data into a warehouse, SQL Server Integration.
Topic Covered:
- Course introduction
- basic and advanced concepts of SSIS
- tools provided by SSIS
- Extract, transform and Load data into various databases
- There are no-prerequisites to the course
- you will be comfortable building an ETL package
- moving data around systems
- SSIS controls like Fuzzy Lookup
- Web service tasks
- Email Tasks
- configuring and deploying production
- quality packages with tasks
- logging and checkpoint tasks
0 Comments