Programming a MS SQL Server 2008 / 2012 / 2014 Database


overall satisfaction for this course

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

Formation path :

Databases Training Paths

View path


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

Targeted audience

System administrators and developers.


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

Special Note

Customer Testimonials

Excellent trainer and the course corresponds exactly to what was advertised. Very useful for me.

Frédéric E. / Analyste, Vidéotron


  • 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
  • Creating views and stored procedures
  • Multiserver programming: partitioned views, queries on linked servers
  • Using XML
  • The architecture and use of Service Broker
  • Using HTTP native support
  • Using Integrated Full-Text Search (IFTS)
  • Implementing CLR from Microsoft .NET
  • Developing client applications
  • Designing, 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

    September 11 to September 14 2017

  • Quebec City

    October 23 to October 26 2017

  • Montreal

    October 30 to November 2 2017

Trainer(s) assigned(s)

Other course(s) in this category