Courses Images
Name : Mr. Shekhar
Duration: 30 Days

Course Description

SQL Server Integration Services (SSIS) stands as a powerful tool in data integration, enabling users to design and execute the Extract, Transform, Load (ETL) processes. It empowers data professionals to build scalable and flexible solutions for handling data from various sources, transforming it as needed, and delivering it to the desired destinations. From this course, you will learn about SQL Server Integration Services (SSIS), how to design, develop, and deploy SSIS packages to extract, transform, and load (ETL) data from a variety of sources to various destinations We have expert training faculties to offer the best coaching in the city to enhance your skills with a performance tracker based on the job requirements of top companies. Enjoy the unique specializations of our SSIS Course in Hyderabad

SSIS Syllabus

Introduction to SQL Server Integration Services

  1. SSIS Historical Overview
  2. SSIS Architecture
  3. Tools of the Trade
  4. Creating a Simple Package
  5. Practice
  1. Import and Export Wizard
  2. SQL Server Data Tools
  3. SQL Server Management Studio
  1. Looping and Sequence Tasks
  2. Data Flow Task
  3. Data Preparation Tasks
  4. Workflow Tasks
  5. Administration Tasks
  6. Execute Package Task
  7. Script Task
  1. Sequence Containers
  2. For Loop Container
  3. Foreach Loop Container
  1. Understanding the Data Flow
  2. Sources & Destinations
  3. Common Transformations
  1. Dynamic Package Objects
  2. Understanding Data Types
  3. Using Variables and Parameters
  4. Working with Expressions
  1. The Connection Managers
  2. Excel and Access
  3. Oracle
  4. Using XML and Web Services
  5. Flat Files
  6. Other Heterogeneous Sources
  7. Practice
  1. Package Transactions
  2. Using Precedence Constraints
  3. Event Handling
  4. Breakpoints
  5. Error Rows
  6. Logging
  7. Practice
  1. Deployment Models
  2. Package Configuration
  3. Security
  4. Scheduling Packages
  5. Monitoring Package Executions
  6. Practice