Microsoft SQL Server 2014 - Developing Databases: New Features

Target Audience
Expected Duration
Lesson Objectives
Course Number
Expertise Level

Microsoft SQL Server 2014 builds from version 2012 to provide optimal performance for applications using In-Memory OLTP, which is a memory-optimized database engine integrated into the SQL Server engine. SQL Server 2014 also provides the ability to create hybrid platform and cloud scenarios by enabling cloud backups and recoveries to decrease on premise costs for storage. This course will discuss and demonstrate the objectives for SQL Server 2014 for the 70-464 Microsoft SQL Server: Developing Databases certification exam, this will include the In-Memory OLTP feature and how to write scripts to automate backups to the cloud. It will also demonstrate other database development tasks, such as designing and creating database objects and programming objects and how to optimize and troubleshoot queries.

Target Audience
Database Administrator and developers who create and manage databases within their organization as part of their daily tasks. This can include creating the database objects, ensuring their security, implementing and ensuring data integrity, managing transactions and locks, and ensuring the server instance and database are running efficiently.


Expected Duration (hours)

Lesson Objectives

Microsoft SQL Server 2014 - Developing Databases: New Features

  • start the course
  • create in-memory OLTP tables
  • troubleshoot In-Memory OLTP issues
  • monitor In-Memory OLTP issues
  • create scripts to automate backups
  • create calculated columns in tables
  • implement cascading deletes
  • create indexed views
  • create a aligned index on a partitioned table
  • create XML selective indexes
  • manage transactions in a given scenario
  • implement error handling using TRY, CATCH, and THROW
  • design for maximize concurrency and transaction isolation
  • design index locking properties and transactions to minimize locking
  • design query paging, including OFFSET and FETCH
  • create scripts that use SET based operations
  • create a plan guide
  • optimize queries for better performance
  • manage contention and auto growth in a database
  • implement Resource Governor to manage resources in a database
  • review Extended Event logs and optimize Extended Event session settings
  • use Activity Monitor
  • integrate performance monitor data with SQL Traces
  • Course Number:

    Expertise Level