Administering an MS SQL Server 2012 / 2014 / 2016 Database


overall satisfaction for this course

?Average calculated from scores obtained from 550 participants who took this course.
  • Duration 4 DAYS
  • Regular fee 1 815
  • Preferential fee 1 540?
  • Locations
    • Quebec City
    • Montreal
  • Top pick
  • Laboratory

Formation path :

Databases Training Paths

View path


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).

Customer Testimonials

Excellent overview of the tools and functionalities available in the software with concrete and relevant examples.

Alexandre D. / Technicien informatique, Commission scolaire des Draveurs


  • 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


*Unless stated otherwise, all sessions are in French.
  • Quebec City

    November 12 to November 15 2018

  • Montreal

    November 19 to November 22 2018

Trainer(s) assigned(s)

Other course(s) in this category