MS509

Administering an MS SQL Server 2012 / 2014 / 2016 Database

96%

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
    • Montreal
    • Quebec City
  • Top pick
  • Laboratory
    course
Parcours

Formation path :

Databases Training Paths

View path
SUMMARY
DETAILS

Objectives

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.

Prerequisite

knowledge of SQL (Course BD102).

Special Note

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

Content

  • 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

DATES*

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

    February 12 to February 15 2018

  • Quebec City

    March 19 to March 22 2018

  • Montreal

    May 14 to May 17 2018

  • Quebec City

    June 18 to June 21 2018

Trainer(s) assigned(s)

Other course(s) in this category