Course Duration: 7 Day(s)


SQL Server Community Technology Preview (CTP3) provides the foundation to the cloud-ready information platform and will help customers unlock breakthrough insights across the organization and quickly build solutions that extend data across on-premises and public cloud backed by capabilities for mission critical confidence.


  • Components of the SQL Server Architecture
  • Index Structures
  • SQL Server Security
  • Security Enhancements In 2012
  • Measuring Performance
  • Maintaining the Database
  • Query Optimization and Index Tuning
  • Managing Transactions, Locking, and Blocking
  • Scaling Very Large Databases
  • Monitoring SQL Server Performance
  • Performance Tuning of T-SQL
  • Improving Query Performance with Indexes
  • SQL Server Replication
  • Scalability and Performance Enhancements In 2012
  • SQL Server Database Mirroring
  • SQL Server Back and Recovery
  • SQL Server Log Shipping
  • Policy Management Framework
  • Managing Workload with Resource Governer
  • Transparent Data Encryption
  • Backup Compression
  • Plan Freezing
  • Extended Events
  • SQL Audit
  • Availability Enhancements In 2012

Who Should Attend

Participants attending this course must have development experience on:

  • Concepts of Relational Database Design & Implementation
  • Working Experience/Knowledge of SQL and TSQL.

Target Audience



Chitra Iyer

Chitra has been delivering exceptionally well in her professional capacity as consultant and trainer.  She has been successful at adopting new technologies for tackling IT challenges which makes her forefront in driving new technology adoption cycle amongst the growing developer base in India.

An excellent communicator, Chitra perfectly fits the bill in handling clients whilst offering technological solutions them by understanding the key requirements of the client expectations.  

Mr. Kedar Ghanekar

Definitely an asset to Synergetics, Kedar has played an in dominatable role in delivering training engagements as well as enterprise solutions. Over the years, Kedar has garnered immense training skills which are put to use along with his knowledge on beta technologies. He has been able to comply to the toughest of software challenges by applying beta technologies in real time scenarios.