FabGreen is one of the best training institutes in Bangalore. We are providing end
to end training in SQL Server 2012 Training. This training will sharpen the
knowledge needed to design and implement practical, cost-effective business
intelligence solutions. FabGreen has excellent trainers with real time experience
who will expertise you in SQL server 2012. The knowledge you gained through
this training program will help you to achieve / resolve your job and business
requirement.
Course Features:
- Sample Live
Projects are provided
- Lab Facility
14/7
- Interview
guidance - Questions and Sample Resumes
- Technical
guidance and support after the course completion
- Course Materials
Provide
- Flexible training - Individual and Batch
FabGreen Technologies
103/10,
60 Feet Road, JaiBheem Nagar,
Old
Madivala, BTM 1st Stage,
Phone:
8971120505 / 8971120606
Email: info@fabgreentech.com
Website: msbitraining.in
Company Website: Fabgreentech.com
Land
Marks: 1. Near Yellamma
Temple
Land
Marks: 2. Near JaiBheem nagar Bus Stand
Course Content:
v Introduction
- Import and Export Wizard
- SQL Server Data Tools
- Architecture
- SSIS Capabilities Available in Editions of SQL Server 2012
v Installation
and Getting Started
- Moving Data with the Import and Export Wizard
- Installing SQL Server Integration Services
- Installing the Sample Databases
- Creating a Solution and Project
- Exploring SQL Server Data Tools
- Creating Your First Package
- Upgrading Packages to SQL Server 2012
- Upgrading to the Project Deployment Model
v Control
Flow
- Using Precedence Constraints
- Manipulating Files with the File System Task
- Coding Custom Script Tasks
- Using the Execute SQL Task
- Using the Execute Process Task
- Using the Expression Task
- Using the Send Mail Task
- Using the FTP Task
- Creating a Data Flow
v Data Flow
- Extracting Data from Sources
- Loading Data to a Destination
- Changing Data Types with the Data Conversion Transform
- Creating and Replacing Columns with the Derived Column Transform
- Rolling Up Data with the Aggregate Transform
- Ordering Data with the Sort Transform
- Joining Data with the Lookup Transform
- Auditing Data with the Row Count Transform
- Combining Multiple Inputs with the Union All Transform
- Cleansing Data with the Script Component
- Separating Data with the Conditional Split Transform
- Altering Rows with the OLE DB Command Transform
- Handling Bad Data with the Fuzzy Lookup
- Removing Duplicates with the Fuzzy Grouping Transform
v Making
Packages Dynamic
- Making a Package Dynamic with Variables
- Making a Package Dynamic with Parameters
- Making a Connection Dynamic with Expressions
- Making a Task Dynamic with Expressions
v Common
ETL Scenarios
- Loading Data Incrementally
- Using the CDC Components in SSIS
- Using Data Quality Services
- Using the DQS Cleansing Transform
- Creating a Master Package
v Containers
- Using Sequence Containers to Organize a Package
- Using For Loop Containers to Repeat Control Flow Tasks
- Using the For Each Loop Container to Loop Through a Collection of Objects
v Configuring
Packages
- Easing Deployment with Configuration Tables
- Easing Deployment with Configuration Files
- Configuring Child Packages
v Troubleshooting
SSIS
- Logging Package Data
- Using Event Handlers
- Troubleshooting Errors
- Using Data Viewers
- Using Breakpoint
v Administering
SSIS
- Creating and Configuring the SSIS Catalog
- Deploying Packages to the Package Catalog
- Configuring the Packages
- Configuring the Service
- Securing SSIS Packages
- Running SSIS Packages
- Running Packages in T-SQL and Debugging Packages
- Scheduling Packages
v Loading a
Warehouse
- Dimension Load
- Fact Table Load
v Wrap up
and Review
- Bringing it all Together
- SSIS Component Crib Notes
- Problem and Solution Crib Notes
v Conclusion