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 825
  • Preferential fee 1 640?
  • Locations
    • Montreal
    • Quebec City
  • Laboratory
    course
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

Very complete and instructive!

Marc-André L. / Responsable informatique, Trac-World Freight services

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

    March 25 to March 28 2019

  • Quebec City

    March 25 to March 28 2019 - Virtual Classroom

Trainer(s) assigned(s)

Other course(s) in this category