Microsoft SQL Server 2014 - Developing Databases: New Features

Overview/Description
Target Audience
Prerequisites
Expected Duration
Lesson Objectives
Course Number
Expertise Level

---

Overview/Description
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.

Prerequisites
None

Expected Duration (hours)
2.1

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:
md_dsqd_a09_it_enus

Expertise Level
Expert