Implementation, Creation, & Troubleshooting

SQL Server 2014    |    Expert
  • 15 Videos | 1h 31m 19s
  • Includes Assessment
  • Earns a Badge
Likes 8 Likes 8
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

  • Playable
    1. 
    Creating In-Memory OLTP Tables in SQL Server 2014
    5m 45s
    UP NEXT
  • Playable
    2. 
    Troubleshooting In-Memory OLTP in SQL Server 2014
    3m 9s
  • Locked
    3. 
    Monitoring In-Memory OLTP Resources in SQL Server 2014
    6m 31s
  • Locked
    4. 
    Automating Backups using Scripts in SQL Server 2014
    4m 35s
  • Locked
    5. 
    Creating Calculated Columns in SQL Server 2014 Tables
    3m 30s
  • Locked
    6. 
    Implementing Constraints in SQL Server 2014
    7m 17s
  • Locked
    7. 
    Creating Indexed Views in SQL Server 2014
    4m 3s
  • Locked
    8. 
    Creating Aligned Indexes in SQL Server 2014
    7m 3s
  • Locked
    9. 
    Implementing XML Selective Indexes in SQL Server 2014
    6m 10s
  • Locked
    10. 
    Managing Transactions in SQL Server 2014
    7m 37s
  • Locked
    11. 
    Implementing Error Handling in SQL Server 2014
    6m 12s
  • Locked
    12. 
    Designing Objects for Concurrency in SQL Server 2014
    6m 34s
  • Locked
    13. 
    Designing a Locking Strategy in SQL Server 2014
    6m 24s
  • Locked
    14. 
    Designing Query Paging in SQL Server 2014
    4m 14s
  • Locked
    15. 
    Designing SET Based Operations in SQL Server 2014
    5m 43s

EARN A DIGITAL BADGE WHEN YOU COMPLETE THIS COURSE

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

Digital badges are yours to keep, forever.