Kameswara Sarma Uppuluri
(MCT, MCPD, MCTS, MCAD, MCDBA, MCSD)

 

SQL Server Integration Services 2019

Your Instructor for this course is Kameswara Sarma Uppuluri.

He is an accomplished Senior Technical Corporate Trainer here in India and a consultant. He has been a Microsoft Certified Trainer since 2004 and a Microsoft Certified Professional since 1998. He has delivered various trainings at client places, on Microsoft Technologies for top MNC's in India .

He is passionate about teaching developers how to make the most out of their chosen technologies and doing web development in the best way possible.

He has spent years of developing course materials and teaching professional developers online throughout the world.

He has worked in technology for 16 years, specializing in web Development,Content Management Systems,databases and business intelligence.

He is an independent consultant that enjoys development and teaching.

He is a consultant based in Hyderabad, India. He has over 16 years of experience in the IT field, and over a decade of experience as a trainer.

He is an expert in SharePoint Development/Configuration/,Administration and .NET development and Database business intelligence technologies.

Live Online Training Videos

Course Fee :
5000/-

Course Duration :
35 Days

Session Duration :
90 Minutes (Mon – Sat)

 

 

What is SSIS?

  • SSIS is an enterprise-level Extract,Transform and Load (ETL) Development tool.
  • SSIS is one of the most powerful application for moving data in and out of various databases and files.
What are the benefits of SSIS?
  • User friendly BIDS (Business Intelligence Development Studio) editor helps you to create,debug
    and execute SSISpackages.
  • Visual data integration with SSIS is a powerful tool for viewing, modifying, and loading data
  • SSIS Packages can be optimized for simple maintenance and high performance.
 Audience Profile:

This course is equally beneficial for those people who want to learn SSIS from scratch or who are

already involved in developing packages using earlier versions of DTS / SSIS.

 Prerequisites:

This course assumes that Students have already been introduced to any one database

software like Access,Oracle,MySql,SqlServer etc. We provide you 6 hours of free Sql Server 2008

Development course,in case, you don’t have any exposure to any database software.

 Our Trainer's Profile :

• Our Trainers speak from Experience
• Our Trainers Are Subject Matter Experts
• Our Trainers Are Expert instructors
• Our Trainers are Microsoft Certified
• Our Trainers have more than 16+ years of experience on Microsoft Technologies
 Career Path:

After completing this course you will be able to take up the roles of
• SSIS Developer
Why you should choose ITAcademy.IN as your Online Training provider?
    • We are into training industry for more than 16+ years.
    • Scenario Based Training.
    • Certification Exam preparation.
    • Our trainers are certified and qualified with Real-World experience.
    • Our Large List of Satisfied Students & Clients Around the World.
    • Students will have access to soft copies of all the Case Studies and other examples used during the sessions.
    • We provide complete guidance towards MCP Certification Exams.
    • Step by Step Lab Manuals and Course Materials.
    • Resume and Interview Preparation Guidance.

Lesson 1 - Introduction to SSIS

In this lesson, we will cover the following topics.

 

•SSIS Historical Overview
•The Business Intelligence Development Studio
•Development and Management Tools
•What is an ETL Tool?
•BI Application Life Cycle

Lesson 2 - Data Migration Techniques

In this lesson, we will cover the following topics.

 

•The Import and Export Wizard
•The Import and Export Wizard from BIDS
•The Import and Export Wizard from SSMS
•Working with Packages

Lesson 3 - Working with Data Flow Tasks

In this lesson, we will cover the following topics.

 

•CharacterMap
•Copy Column
•Derived Column
•Percentage Sampling
•Row Sampling

Lesson 4 - Working with Data Flow Tasks

In this lesson, we will cover the following topics.

 

•Sort
•Union All
•Multicast
•Conditional Split
•Data Conversion
•Aggregate

Lesson 5 - Working with Data Flow Tasks

In this lesson, we will cover the following topics.

 

•Audit
•Import Column
•Export Column
•Merge
•Merge Join

Lesson 6 - Working with Data Flow Tasks

In this lesson, we will cover the following topics.

 

•Lookup
•Cache Transform
•Fuzzy Lookup
•Fuzzy Grouping

Lesson 7 - Working with Data Flow Tasks

In this lesson, we will cover the following topics.

 

•OLE DB Command
•Row Count
•Pivot
•Unpivot

Lesson 8 - Working with Data Flow Tasks

In this lesson, we will cover the following topics.

 

•Data Mining Query
•Term Extraction
•Term lookup
•Slowly Changing Dimension

Lesson 9 - Working with ControlFlow

In this lesson, we will cover the following topics.

 

•Data Flow Task
•Bulk Insert Task
•Sequence Container
•Execute Package Task
•Execute Process Task

Lesson 10 - Working with ControlFlow

In this lesson, we will cover the following topics.

 

•File System Task
•FTP Task
•Web Service Task
•XML Task

Lesson 11 - Working with ControlFlow

In this lesson, we will cover the following topics.

 

•Transfer Database task
•Transfer Error Messages Task
•Transfer Jobs Task
•Transfer Logins Task
•Transfer Master Stored Procedures Task
•Transfer SQL Server Objects task

Lesson 12 - Working with ControlFlow

In this lesson, we will cover the following topics.

 

•Execute SQL Task
•Execute DTS 2000 Package Task
•Data Profiling task
•SendMail
•Data Mining Query Task

Lesson 13 - Working with ControlFlow

In this lesson, we will cover the following topics.

 

•For Loop Container
•Foreach Loop Container

Lesson 14 - Working with ControlFlow

In this lesson, we will cover the following topics.

 

•Script Task
•WMI Data Reader Task
•WMI Event Watcher Task

Lesson 15 - Working with ControlFlow

In this lesson, we will cover the following topics.

 

•ActiveX Script Task
•Analysis Services Execute DDL Task
•Analysis Services Processing Task
•Message Queue Task

Lesson 16 - Working with Maintenance Plan Tasks

In this lesson, we will cover the following topics.

 

•Back Up Database Task
•Check Database Integrity Task
•Execute SQL Server Agent Job Task
•Execute T-SQL Statement Task
•History Cleanup Task
•Maintenance Cleanup Task

Lesson 17 - Working with Maintenance Plan Tasks

In this lesson, we will cover the following topics.

 

•Back Up Database Task
•Check Database Integrity Task
•Execute SQL Server Agent Job Task
•Execute T-SQL Statement Task
•History Cleanup Task
•Maintenance Cleanup Task

Lesson 18 - Working with Maintenance Plan Tasks

In this lesson, we will cover the following topics.

 

•Notify Operator Task
•Rebuild Index Task
•Reorganize Index Task
•Shrink Database task
•Update Statistics Task

Lesson 19 - Using Various Data Sources

In this lesson, we will cover the following topics.

 

•ADO NET Source
•Excel Source
•Flat File Source
•OLE DB Source
•XML Source
•Raw File Source

Lesson 20 - Using Various Data Destinations

In this lesson, we will cover the following topics.

 

•ADO NET Destination
•Data Mining Model Training
•DataReader Destination
•Dimension Processing
•Excel Destination
•Flat File Destination
•OLE DB Destination
•Partition Processing
•Raw File Destination
•Recordset Destination
•SQL Server Compact Destination
•SQL Server Destination

Lesson 21 - Variables and Configuration

In this lesson, we will cover the following topics.

 

•Variables Overview
•Variable scope
•SSIS system variables
•Using variables in control flow
•Using variables in data flow
•Using variables to pass information between packages
•Property expressions
•Configuration Overview
•Configuration options
•Dynamic Tasks
•Dynamic Connection Managers
•CheckPoints

Lesson 22 - Error and Event Handling Techniques

In this lesson, we will cover the following topics.

 

•Precedence Constraints
•Event Handling
•Breakpoints
•OnError event handler
•Configuring Package Logging
•Built-in log providers

Lesson 23 - Error and Event Handling Techniques

In this lesson, we will cover the following topics.

 

•Introduction to SSIS scripting
•The SSIS script editor
•The SSIS object model
•Script in Control flow: The Script Task
•Script in Data flow: The Script Component
•Introduction to SSIS component development

Lesson 24 - SSIS Package Deployment

In this lesson, we will cover the following topics.

 

•Configurations and deployment
•The deployment utility
•Deployment options
•Deployment security
•Executing packages – DTExec and DTExecUI

Lesson 25 - SSIS Package Deployment

In this lesson, we will cover the following topics.

 

•The SSIS Service
•Managing packages with DTUtil
•Managing packages with SQL Server Management Studio
•Scheduling packages with SQL Server Agent

 

 

Client Testimonials
 

What really impressed me, is their "Day Wise Course Outlines" of MSBI 2019 Course.  So at the time of paying fee, I know, what  for I am paying for.  All topics that were put in "Course Outline" were covered and that too, in the same order.

David
Canada
 

 

Client Testimonials
 

"As a student, I look for trainers who can communicate their subject in an easily understood manner and at UIAcademy.IN, I found their trainers just too good. I have learned MSBI 2019 at UIAcademy.IN and this course fits my bill."

Tarun Reddy
New Delhi
 

 

Client Testimonials
 

" I enjoyed MSBI 2019 course at UIAcademy.IN. So simple to listen to their trainers explanation and understand."

Radhika
Bangalore
 

 

 

 

 
© Copyright 2010 - 2023 | UIAcademy.co.in | All trademarks and logos are the sole property of their respective owners.