MS509

Administering a MS SQL Server 2008 / 2012 / 2014 Database

96%

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
    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 2008 R2, MS SQL Server 2012 and 2014.

Targeted audience

Database administrators, system administrators and developers.

Prerequisite

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

Content

  • 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

DATES*

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

    January 30 to February 2 2017

  • Montreal

    April 24 to April 27 2017

  • Quebec City

    June 5 to June 8 2017

Trainer(s) assigned(s)

Other course(s) in this category