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

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

Are you interested in this training course ?

Only private sessions of this course are currently available.

Request a quote

Trainer(s) assigned(s)

Other course(s) in this category