SQL DBA Online Training and Classroom Training: Completely Practical

1

• SQL School is strongly committed to provide
  COMPLETE PRACTICAL REALTIME Trainings on SQL
  Server Technologies Dev, SQL DBA, MSBI (SSIS,
  SSAS, SSRS) and SQL Azure (Windows Cloud). We
  have been providing Trainings for the last SIX
  years successfully and our trainings are
  guaranteed to ASSURE you the quality you
  expect over LIVE production environment.
• http//sqlschool.com

ALL OUR SESSIONS ARE COMPLETELY PRACTICAL
2
Courses Offered

• Course 1 T-SQL with SQL Server Basics
• Course 2 T-SQL with Basic SQL DBA and Advanced
  SQL DBA
• Course 3 Microsoft Business Intelligence (MSBI
  SSIS, SSAS, SSRS)
• Course 4 SQL Server Integration Services (SSIS)
• Course 5 SQL Server Analysis Services (SSAS)
• Course 6 SQL Server Reporting Services (SSRS)
• Course 7 Windows SQL Azure
• ALL SESSIONS ARE COMPLETELY REALTIME PRACTICAL

3
Course2 T-SQL, Basic DBA, Advance DBA Project

• Real-time ONLINE training on SQL Server 2012
  (DENALI) Design Principles and T-SQL Programming.
  A step by step training course exclusively
  designed with Basic through Intermediate Transact
  SQL (T-SQL) Concepts. The course is carefully
  designed addressing all practical aspects of SQL
  Server fundamentals required for Database
  Administration and Business Intelligence (MSBI)
  areas. Study Material and Practice Material are
  provided during the course. All Sessions are
  Completely Practical.

ALL OUR SESSIONS ARE COMPLETELY PRACTICAL
4
T-SQL Basic SQL Server

• SQL Server Introduction 2008 Installation
• Services and Service Accounts
• SQL Server Database Design Planning
• SQL Server Table Design , Pages compression
  techniques
• Data Integrity Consistency
• SQL Server Views and Schemas
• JOINS and Sub Queries
• Uses of Indexes and Performance
• continue..gtgt

ALL OUR SESSIONS ARE COMPLETELY PRACTICAL
5

• 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 DENALI (SQL Server 2012)

ALL OUR SESSIONS ARE COMPLETELY PRACTICAL
6
Basic SQL Server Administration

• 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
• continue..gtgt

ALL OUR SESSIONS ARE COMPLETELY PRACTICAL
7

• 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

8
Advanced SQL Administration

• Certificates and Signatures
• Cryptography Security Keys
• Service Broker Implementation
• Query Troubleshooting Tuning
• SQL Server Profiler Filters
• DB Engine Tuning Advisor
• Data Movement Procedures
• SMO and BCP Tools
• Maintenance Plans SSIS continue..gtgt

ALL OUR SESSIONS ARE COMPLETELY PRACTICAL
9

• SQL CMD Utility Remote Access
• Database Mail and Alerts
• Clustering Configuration Issues
• Cluster Quorum Storage Issues
• Server and DB Upgrades
• Policy Based Management
• MSDTC and Server Linking
• Client Level Statistics Tuning
• IO and Memory Issues
• Optimizing SSIS Packages

ALL OUR SESSIONS ARE COMPLETELY PRACTICAL
10
Training Highlights

• REALTIME PROJECTS
• Completely Practical
• Highly Interactive
• Study Material
• Interview Guidance
• Resume Preparation
• Job Support
• Certification Material

ALL OUR SESSIONS ARE COMPLETELY PRACTICAL
11

• For further training details and
• Free Demo, please visit
• http//sqlschool.com
• SQL School
• 302, Sai Manohar Towers
• SR Nagar X Roads
• Hyderabad 500038 (India)