Implementation, Creation, & Troubleshooting

SQL Server 2014    |    Expert
  • 15 videos | 1h 24m 49s
  • Includes Assessment
  • Earns a Badge
Rating 4.3 of 3 users Rating 4.3 of 3 users (3)
Microsoft SQL Server 2014 has new features added to help optimize performance. Discover In-Memory OLTP, how to write scripts to automate backups to the cloud, and how to design and create database and programming objects.

WHAT YOU WILL LEARN

  • 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

IN THIS COURSE

  • 5m 45s
    In this video, you will create in-memory OLTP tables. FREE ACCESS
  • 3m 9s
    In this video, learn how to troubleshoot issues with In-Memory OLTP. FREE ACCESS
  • Locked
    3.  Monitoring In-Memory OLTP Resources in SQL Server 2014
    6m 31s
    In this video, you will learn how to monitor In-Memory OLTP issues. FREE ACCESS
  • Locked
    4.  Automating Backups using Scripts in SQL Server 2014
    4m 35s
    In this video, you will create scripts to automate backups. FREE ACCESS
  • Locked
    5.  Creating Calculated Columns in SQL Server 2014 Tables
    3m 30s
    In this video, you will learn how to create calculated columns in tables. FREE ACCESS
  • Locked
    6.  Implementing Constraints in SQL Server 2014
    7m 17s
    Learn how to implement cascading deletes. FREE ACCESS
  • Locked
    7.  Creating Indexed Views in SQL Server 2014
    4m 3s
    In this video, you will learn how to create indexed views. FREE ACCESS
  • Locked
    8.  Creating Aligned Indexes in SQL Server 2014
    7m 3s
    In this video, learn how to create an aligned index on a partitioned table. FREE ACCESS
  • Locked
    9.  Implementing XML Selective Indexes in SQL Server 2014
    6m 10s
    In this video, you will create selective XML indexes. FREE ACCESS
  • Locked
    10.  Managing Transactions in SQL Server 2014
    7m 37s
    Find out how to manage transactions in a given scenario. FREE ACCESS
  • Locked
    11.  Implementing Error Handling in SQL Server 2014
    6m 12s
    In this video, you will learn how to implement error handling using TRY, CATCH, and THROW. FREE ACCESS
  • Locked
    12.  Designing Objects for Concurrency in SQL Server 2014
    6m 34s
    In this video, learn how to design for maximum concurrency and transaction isolation. FREE ACCESS
  • Locked
    13.  Designing a Locking Strategy in SQL Server 2014
    6m 24s
    In this video, you will learn how to design index locking properties and transactions to minimize locking. FREE ACCESS
  • Locked
    14.  Designing Query Paging in SQL Server 2014
    4m 14s
    During this video, you will learn how to design query paging, including using OFFSET and FETCH. FREE ACCESS
  • Locked
    15.  Designing SET Based Operations in SQL Server 2014
    5m 43s
    In this video, find out how to create scripts that use SET-based operations. FREE ACCESS

EARN A DIGITAL BADGE WHEN YOU COMPLETE THIS COURSE

Skillsoft is providing you the opportunity to earn a digital badge upon successful completion on some of our courses, which can be shared on any social network or business platform.

Digital badges are yours to keep, forever.

YOU MIGHT ALSO LIKE

Rating 4.7 of 37 users Rating 4.7 of 37 users (37)
Rating 4.5 of 147 users Rating 4.5 of 147 users (147)
Rating 4.6 of 23 users Rating 4.6 of 23 users (23)

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

Rating 4.6 of 64 users Rating 4.6 of 64 users (64)
Course T-SQL Queries
Rating 4.3 of 218 users Rating 4.3 of 218 users (218)
Course SSIS Packages
Rating 4.5 of 37 users Rating 4.5 of 37 users (37)