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

Register at Technologia

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

 

Author: Super User


Comments (0)

There are no comments posted here yet

Leave your comments

Posting comment as a guest. Sign up or login to your account.
Attachments (0 / 3)
Share Your Location