Administering a MS SQL Server 2008 / 2012 / 2014 Database


overall satisfaction for this course

?Average calculated from scores obtained from 504 participants who took this course.
  • Duration 4 days
  • Regular fee 1 650
  • Preferential fee 1 400?
  • Locations
    • Montreal
    • Quebec City
  • 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 2008 R2, MS SQL Server 2012 and 2014.

Targeted audience

Database administrators, system administrators and developers.


knowledge of SQL (Course BD102).

Special Note

Customer Testimonials

Good explanations, real facts in the work environment, practical examples. Good trainer, clear, specific and well-detailed.

Alexandre L. / Technicien gestion de réseau, Fonds de solidarité des travailleurs du Québec


  • Overview of the architecture of MS SQL Server
  • Planning an installation of MS SQL Server
  • Migrating to MS SQL Server 2014
  • Overview of improvements in SQL Server 2014
  • The memory buffer pool extension
  • Optimized memory tables
  • Creation and configuration of user and system databases
  • Data transfer within the database
  • Backing up and restoring databases
  • Optimizing storage with backup compression
  • Managing access, permissions and certificates
  • Running and automating administrative procedures
  • Managing and optimizing indexes
  • The Columnstore index
  • The 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.
  • Montreal

    September 18 to September 21 2017

  • Quebec City

    October 10 to October 13 2017

  • Montreal

    November 6 to November 9 2017

Trainer(s) assigned(s)

Other course(s) in this category