Programming an MS SQL Server 2012 / 2014 / 2016 Database


overall satisfaction for this course

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

Formation path :

Databases Training Paths

View path


To provide the knowledge and skills required to develop MS SQL Server 2012, 2014 and 2016 databases.

Targeted audience

Developers, database administrators, network specialists and Web specialists.


Experience with the Windows user interface, and knowledge of conceptual data modeling (Course BD101) and SQL syntax (Course BD102).

Special Note

Customer Testimonials

Eric is an excellent popularizer! I learned a lot about SQL concepts!

Patrick G. / Chef informatique, Orchestre Symphonique de Montréal


  • New features and new development tools in MS SQL Server
  • Creating data types and tables
  • Data integrity: constraints, default values, etc.
  • Managing and manipulating data
  • Improvements to Transact-SQL
  • Implementation of stored procedures and functions
  • Creating views and stored procedures
  • Multiserver programming: partitioned views, queries on linked servers, etc.
  • Using XML
  • The architecture and use of Service Broker
  • Implementation of In-Memory objects
  • Using HTTP native support
  • Using Integrated Full-Text Search (IFTS)
  • Implementing CLR from Microsoft .NET
  • Planning, creating and maintaining indexes
  • Columnstore indexes
  • Managing transactions and locks
  • Planning and administering security, analyzing and optimizing performance


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

    January 29 to February 1 2018

  • Quebec City

    March 5 to March 8 2018

  • Montreal

    April 23 to April 26 2018

  • Montreal

    June 26 to June 29 2018 - English version

Trainer(s) assigned(s)

Other course(s) in this category