Tuesday, March 4, 2014

Complete Practical realtime Weekend Classroom Training on MSBI @ SQL School



SQL School provides Interactive and Practical Classroom Trainings on T-SQL, SQL DBA and MSBI (SSIS, SSAS, SSRS). All sessions are completely PRACTICAL. No PPTs nor Screenshots during live sessions. We also provide Study and Practice Material.

Course Highlights for SQL Server Reporting Services (SSRS ) Online Training:

·         Need for Enterprise Reporting
·         Understanding and Configuring SSRS
·         Need for Web Services and Virtual Directories
·         Reporting life Cycle and SSRS Advantages
·         Designing Basics Table and Matrix Reports
·         Static & Dynamic Report Parameters & Filters
·         Chart and Bar Reports Properties
·         List and Rectangle Reports
·         Map, Data Bar and Indicator Reports
·         Sub Reports and Linked Reports
·         Gauges Reports and Dundas Report Control Operations
·         Cube Reports with MDX and DAX Expression Languages
·         Tuning Performance and Report Schedules
·         Report Caching, Refresh and Snapshot  Options
  • Report Expressions and Dynamic Properties
·         Data Driven Subscriptions and Schedules
·         Report Snapshots and History Management
·         SSRS Data and Item Level Security Roles
·         Managing Reporting Services via SSRS Console
·         Report Delivery and Report Builder
·         Report builder Applications
  • SSRS Performance Monitors and Tuning
·         Custom Application Integration Principles
For complete SSRS course content - http://sqlschool.com/SSRS_Classroom_Training.html 
Duration: 2 weeks, every day for 1.5 hours and all sessions are completely practical.
One Case Study will be dealt during the sessions. All sessions are on LIVE environment.

We also provide SSIS and SSAS LIVE Online Trainings along with Real Time Case Studies.  For free Demo and further training details, please contact us.

SQL School
India: (091) 09666440801
USA: (001) 214 628 5666(001) 214 628 5666
Office : SQL School, Flat No: 302, Sai Manor Complex, 8-3-224, X Roads, SR Nagar, Hyderabad, India
http://sqlschool.com


Excellent Weekend Classroom Training on Analysis Services (SSAS) @ SQL School



SQL School provides Interactive and Practical LIVE Online Trainings on T-SQL, SQL DBA and MSBI (SSIS, SSAS, SSRS). All sessions are completely PRACTICAL. No PPTs nor Screenshots during live sessions. We also provide Study and Practice Material.

Course Highlights for SQL Server Integration Services (SSAS) Online Training:

  • Data Warehousing Principles and need for SSAS
  • Introduction to SSAS & Architecture
  • Understanding SSAS Components – Multidimensional and Tabular
  • OLAP Cubes and Data Warehouse Design
  • SSAS  Cube Design Techniques
  • Advanced SSAS Design and Hierarchies
  • Multidimensional Cube Development Process
  • Tabular Cube Development Process
  • MDX Syntax, Functions, Uses and Rules
  • Defining Named Sets and Aggregates in MDX
  • SSAS KPIs and Functions – Multidimensional
  • SSAS KPIs and Functions – Tabular
  • SSAS Transactions and Types
  • XMLA Uses and Limitations
  • Partition Management and OLAP Storage Models
  • SSAS Audits and Usage Based Optimization (UBO)
  • Managing Multidimensional and Tabular OLAP Databases
  • Security Management with SQL Server Data Warehouses
  • Proactive Caching and Performance Tuning
  • OLAP Storage Models and Deployment Rules
  • Importing SSAS Projects and Reverse Engineering Techniques
  • Onsite Deployments and Cube uploads
  • Mining Extensions and Mining Algorithms
  • Performance Counters and SSAS Monitors
  • Migration Procedures and Upgradations


Duration: 2 weeks, every day for 1.5 hours and all sessions are completely practical.
One Case Study will be dealt during the sessions. All sessions are on LIVE environment.

We also provide SSIS and SSRS LIVE Online Trainings along with Real Time Case Studies.  For free Demo and further training details, please contact us.

SQL School
India: (091) 09666440801
USA: (001) 214 628 5666(001) 214 628 5666
Office : SQL School, Flat No: 302, Sai Manor Complex, 8-3-224, X Roads, SR Nagar, Hyderabad, India
http://sqlschool.com

Monday, March 3, 2014

Best Training on Microsoft Business Intelligence - SSIS @ SQL School



SQL School provides Interactive and Practical Classroom Trainings on T-SQL, SQL DBA and MSBI (SSIS, SSAS, SSRS). All sessions are completely PRACTICAL.

Course Highlights for SQL Server Integration Services (SSIS) Online Training:

  • Database Engine Limitations and Need for MSBI  Process
  • Introduction to SSIS Workflow Environment
  • Control Flow and Data Flow Operations
  • Custom Scripting and Data Import Techniques
  • ETL with non-SQL Server sources
  • SSIS Expressions and Advanced Control Flow
  • Variable Usage & Configurations
  • Transactions and Isolation Levels in SSIS
  • Advanced SSIS Controls
  • Variables and Configurations 
  • Custom Components and Profiling
  • Package Configurations & Deployment
  • SSIS Utilities and WMI Controls
  • Scheduling SSIS Packages
  • SSIS Security and Management
  • Fast Load and Performance Tuning Options
  • Buffer Sizing, Dump Files and Sizing
  • SSIS Isolation Levels and Transaction Options
  • SSIS Checkpoint Files and Usage
  • Type I, Type II and Type III SCD implementation in SSIS
  • SSIS CHECKSUM Transformation
  • Error Handling and Event Handling
  • SSIS Package Parameters and Configurations
  • WMI Events and Use in SSIS
  • Migrating SSIS 2005 Packages to 2008 R2 and SSIS 2012
  • Package Backups and Version Coding
  • Managing MSDB Packages and Monitoring
  • ISPAC Files and Package Conversions
  • Package Deployment & Management
  • SSIS Catalog DB and Management
  • MSDB and SSIS Catalog Security Enforcement
  • SSIS Reports and Audits

For detailed SSIS course content  http://sqlschool.com/SSIS_Classroom_Training.html

Duration: 2 weeks, every day for 1.5 hours and all sessions are completely practical.
One Case Study will be dealt during the sessions. All sessions are on LIVE environment.

We also provide SSAS and SSRS LIVE Online Trainings along with Real Time Case Studies.  For free Demo and further training details, please contact us.


SQL School
India: (091) 09666440801
USA: (001) 214 628 5666(001) 214 628 5666
Office : SQL School, Flat No: 302, Sai Manor Complex, 8-3-224, X Roads, SR Nagar, Hyderabad, India
http://sqlschool.com