MS510

Programming an MS SQL Server 2012 / 2014 / 2016 Database

97%

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
    course
Parcours

Formation path :

Databases Training Paths

View path
SUMMARY
DETAILS

Objectives

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.

Prerequisite

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

Content

  • 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

DATES*

*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

  • 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