SQL Server 2012 for DBAs and Developers

מק"ט: #7086 | משך קורס: 24 שעות אק'

This course covers the new features, changes and need to know elements for the DBA in the SQL Server 2012 release.
In this course you will find Infrastructure and programmability enhancements.

*שדות חובה
PDF version


  • Design and implement the new high availability features
  • Implement the security enhancements
  • Use the ColumnStore feature to improve DWH systems
  • Implement and use the new development features

קהל יעד

Database administrators, developers, architects.

תנאי קדם

Trainees should have at least 1 year working experience in database environments.


משך הקורס הינו 24 שעות לימוד


Always ON High availability and DR

  • Clustering
  • HADR
  • Availability Groups


Security enhancements

  • New Permissions and roles
  • Audit


Column store indexes


New object types

  • Go beyond relational data
    • File table
    • Spatial enhancements
  • Sequences

Distributed Replay


Contained databases


New T-SQL Functions and functionally

  • Code control
  • Functions and programmability enhancements