SQL School
ISO 9001:2008 Certified Organization for Trainings
Authorized Microsoft Partner (ID# 4338151)
Regd: Sequelgate Innovative Technologies Pvt. Ltd.

108/2RT, Street No 2, Road No 1,

Landmark: Lane Beside SR Nagar Bus Stop
SR Nagar, Hyderabad - 38, India. Map

http://www.sqlschool.com

Call us

India (+91): (0)40 64577244 (Office) | (0)9666440801 (Mobile)

USA (+1): 510-400-4845

Outline

SQL Server Integration Services (SSIS)

Basic ETL Entities in SSIS
SSIS Expressions & Package Debugging
Data Flow Transformations and ETL
SSIS Customizations with .NET
SCD Transformation - ETL / DW
Checksum Operations for ETL/DW
Change Data Capture (CDC) for ETL/DW
Events, Errors and Logging
Master - Child Packages & Fact Loads
Deployment Procedures
SSIS Project Deployments
SSIS Package Security and Reports
SSIS Package Upgrades

SSAS Development Course:

SSAS Installation and Configuration
Basic SSAS Entities & Usage
Dimension Wizard and Attributes
Cube Wizard and Relations
Dimension Types & KPI
SSAS Partitions and Aggregations
MDX Functions, FILTERS and JOINS
Data Mining and Forecast
Tabular Mode Cube Design
Deployment (Tabular & Multidimensional)
OLAP Database Management
Usage Based Optimization (UBO)
Using OLAP Structures
Managing Security with MDX

SSRS Development Course:

Report Planning and Design
Report DataSets and Joins
Report Design and SubReports
Report Parameters & Usage
Enterprise Reports in SSRS
Map Reports and Cube Reports
Report Builder & Power View
Report Management Options
Subscriptions and Report Builder
Report Security and Upgrades
Power View with SSRS

SQL School
ISO 9001:2008 Certified Organization for Trainings
Authorized Microsoft Partner (ID# 4338151)
Regd: Sequelgate Innovative Technologies Pvt. Ltd.

108/2RT, Street No 2, Road No 1,

Landmark: Lane Beside SR Nagar Bus Stop
SR Nagar, Hyderabad - 38, India. Map

http://www.sqlschool.com

Call us

India (+91): (0)40 64577244 (Office) | (0)9666440801 (Mobile)

USA (+1): 510-400-4845

Follow us

https://www.facebook.com/sequelschool

https://www.linkedin.com/company/sql-school

Speaker/s

Trainer: Mr. Sai Phanindra T
8+ Years of experience on SQL Server, SQL DBA and MSBI (SSIS, SSAS, SSRS)

Complete profile of the trainer available @ http://www.linkedin.com/in/saiphanindra

Special Offer

10% Applicable discount for early bird registrations

Reviews

Be the first to write a review about this course.

Write a Review

SQL School Training institute have been providing interactive Online and Inhouse Training Services for the last 8 years. We at SQL School, are completely dedicated to offer complete realtime and practical trainings with Job Orientation and Placement Support.

SQL School is an ISO Certified Pvt. Ltd. Organization with 30+ employee count completely dedicated to Microsoft and realted technology offerings.

Courses Offered:

SQL Server Developer Training
SQL Server DBA (SQL DBA) Training
Microsoft Business Intelligence (MSBI) Training
SQL Server Integration Services (SSIS) Training
SQL Server Analysis Services (SSAS) Training
SQL Server Reporting Services (SSRS) Training
Data Modelling and DB Design
Datawarehouse Design and ETL with SSIS/SSAS
Crystal Reports and PowerView Integration to SSRS
Data Mining and Data Model Training

www.sqlschool.com

Complete Practical and Indepth technical courses fully loaded with Lab, Vitrual support and 24x7 LIVE Server access.

For Free demo and more details, please mail us to: [email protected]
or Log on to www.sqlschool.com/courses.html

Complete Practical and Indepth technical courses fully loaded with Lab, Vitrual support and 24x7 LIVE Server access. ...

View Complete Profile

Business Software & Tools