Wednesday, October 30, 2013

MICROSOFT BI AND DATAWAREHOUSING : SQL Server 2012 ONLINE TRAINING



SQL School provides Interactive and Practical LIVE Online 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
  • Configuring SSIS Catalog Database
  • Introduction to SSIS Workflow Environment
  • Control Flow and Data Flow Operations
  • Custom Scripting and Data Import Techniques
  • Need for Datawarehouses and Design
  • 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 TDS Sizing
  • SSIS Isolation Levels and Transaction Options
  • SSIS Checkpoint Files & SSIS Logging
  • 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
  • SSIS Package Reports and ISPAC Files Security
  • MSDB and SSIS Catalog Security Enforcement
  • SSIS Server Health and Auditting
  • A Realworld Scenario

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

Duration: 2 weeks, every day for 1.5 hours and all sessions are completely practical.


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
contact@sqlschool.com
Office: (+91)   040 64577244
Mobil No: (+91) 0 9666440801
Flat No: 302, Sai Manor Complex, X Roads, SR Nagar, Hyderabad, India.
http://sqlschool.com

Tuesday, October 29, 2013

SQL SERVER REPORTING SERVICES (SSRS) REALTIME ONLINE TRAINING



SQL School provides Interactive and Practical LIVE Online Trainings on T-SQL, SQL DBA and MSBI (SSIS, SSAS and 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 Usage and Limitations
  • SSRS Performance Monitors and Tuning
·         Custom Application Integration Principles
For complete SSRS course content - http://sqlschool.com/SSRS_Online_Training.html 

Duration: 2 weeks, every day for 1.5 hours and all sessions are completely practical.
Course Fee: INR 4500 (fixed course fee). 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
contact@sqlschool.com
Office: (+91)   040 64577244
Mobil No: (+91) 0 9666440801
Flat No: 302, Sai Manor Complex, X Roads, SR Nagar, Hyderabad, India.
http://sqlschool.com

PROJECT ORIENTED PRACTICAL SQL DBA 2008 R2 ONLINE TRAINING



SQL School is one of the pioneers IT Institutions providing specialized in SQL Server 2012 DBA Training. We have been providing Online Training, Classroom Training and Corporate Training for the last SIX years. All our sessions are completely Practical and Real-time.
SQL SERVER DBA COURSE DETAILS FOR ONLINE TRAINING
SQL Server Basics
·          SQL Server Design Architecture – 2008 R2 & 2012
·          SQL Server Database Design & Planning
·          SQL Server Table Design & Pages
·          Table Compression Techniques
·          Data Integrity & Consistency
·          SQL Server Views and Schemas
·          JOINS and Sub Queries
·          Uses of Indexes and Performance
·          Stored Procedures  and User Defined Functions
·          DDL Triggers and DML Triggers
·          Cursors Usage and Limitations
·          T-SQL Transactions Concepts & Types
·          Locks and Memory Concepts & Locking Hints
·         New Features in SQL Server  2012

Basic SQL Server Administration (DBA)


·          Blocking & Deadlocks Issues
·          Backup Strategies & Backup Options
·          Point-In-Time, Partial and Piecemeal Restores
·          Replication Techniques and Monitoring
·          Peer – Peer Replication Topology and Limitations
·          Log Shipping Modes and Issues
·          DB Mirroring and Encryption
·          SQL Server Security & Client Security
·          Database & Object Security
·          Security Issues and Audits
·          Data Level Encryptions and Data Security
·          Performance Tuning & Tips
·          Import -Export Techniques 
·          Tuning & Troubleshooting
·          Security Audits in DENALI
·          DBCC Commands and Management
·          Server Level Audits

Advanced SQL Administration
·          Log Space Issues and Tempdb Issues
·          Profiler & Activity Monitor and Network Issues
·          Partitioning Techniques,  DB Snapshots and Usage
·          Certificates,  Signatures, Cryptography,  Keys and  TDE Implementation
·          DB Engine Tuning Advisor and Client Statistics
·          Optimizing SSIS Packages
·          Database Maintenance Plans
·          DB Mail & Alert System with Notifications
·          Upgrades, Migrations and Service Pack Installations
·          SQL Server Failover Cluster Configuration
·          Active Directory Configurations and Storage (SAN) Management
·          Active/Active and Active/Passive Cluster Configuration Issues
·          SQL Server Cluster Management Operations
·          MSDTC and Resource Governor Importance and Usage
·          Contained Databases and Always-On Availability Groups

For free Demo and fee details, please visit http://sqlschool.com

SQL School
contact@sqlschool.com
Office: (+91)   040 64577244
Mobil No: (+91) 0 9666440801
Flat No: 302, Sai Manor Complex, X Roads, SR Nagar, Hyderabad, India.
http://sqlschool.com