MS510

Programming a MS SQL Server 2008 / 2012 / 2014 Database

96%

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

Formation path :

Databases Training Paths

View path
SUMMARY
DETAILS

Objectives

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.

Prerequisite

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

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
  • 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

DATES*

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

    February 27 to March 2 2017

  • Quebec City

    May 1 to May 4 2017

  • Montreal

    May 29 to June 1 2017

Trainer(s) assigned(s)

Other course(s) in this category