Administering an MS SQL Server 2012 / 2014 / 2016 Database


overall satisfaction for this course

?Average calculated from scores obtained from 578 participants who took this course.
See the training dates
  • Duration 4 days
  • Regular fee 1 825
  • Preferential fee 1 640?
  • Locations
    • Virtual Classroom
  • Laboratory


To provide the knowledge and skills required to install, configure and administer MS SQL Server 2012, 2014 and 2016.

Targeted audience

Developers, database administrators, network specialists and Web specialists.


knowledge of SQL (Course BD102).

Special Note

Training Details


  • Overview of MS SQL Server architecture
  • Planning the installation of MS SQL Server
  • MS SQL Server administration tools
  • Migrating to MS SQL Server 2016
  • Overview of improvements to SQL Server 2016
  • New features of tempdb
  • The memory buffer pool extension
  • Optimized memory tables
  • Presentation, creation and configuration of user and system databases
  • New features of performance optimization
  • Backing up and restoring databases
  • Optimizing storage with backup compression
  • Managing access, permissions and certificates
  • Using Always Encrypted, Row-level Security and Dynamic Data Masking
  • Running and automating administrative procedures
  • Managing and optimizing indexes
  • The Columnstore index
  • Using Profiler and Extended Events (XEvents) for monitoring usage
  • Tracking and optimizing performance and load levels
  • Implementing replication
  • Maintaining high availability with AlwaysOn

Customer Testimonials

Very complete and instructive!

Marc-André L. / Responsable informatique, Services de Transport Trac-World Inc.

Select the training date*

*Unless stated otherwise, all sessions are in French.
  • Virtual Classroom

    November 23 to November 26 2020 - CONFIRMED

Trainer(s) assigned(s)

Other course(s) in this category