Implementation, Creation, & Troubleshooting

SQL Server 2014    |    Expert
  • 15 Videos | 1h 24m 49s
  • Includes Assessment
  • Earns a Badge
Likes 10 Likes 10
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
    FREE ACCESS
  • Locked
    4. 
    Automating Backups using Scripts in SQL Server 2014
    4m 35s
    FREE ACCESS
  • Locked
    5. 
    Creating Calculated Columns in SQL Server 2014 Tables
    3m 30s
    FREE ACCESS
  • Locked
    6. 
    Implementing Constraints in SQL Server 2014
    7m 17s
    FREE ACCESS
  • Locked
    7. 
    Creating Indexed Views in SQL Server 2014
    4m 3s
    FREE ACCESS
  • Locked
    8. 
    Creating Aligned Indexes in SQL Server 2014
    7m 3s
    FREE ACCESS
  • Locked
    9. 
    Implementing XML Selective Indexes in SQL Server 2014
    6m 10s
    FREE ACCESS
  • Locked
    10. 
    Managing Transactions in SQL Server 2014
    7m 37s
    FREE ACCESS
  • Locked
    11. 
    Implementing Error Handling in SQL Server 2014
    6m 12s
    FREE ACCESS
  • Locked
    12. 
    Designing Objects for Concurrency in SQL Server 2014
    6m 34s
    FREE ACCESS
  • Locked
    13. 
    Designing a Locking Strategy in SQL Server 2014
    6m 24s
    FREE ACCESS
  • Locked
    14. 
    Designing Query Paging in SQL Server 2014
    4m 14s
    FREE ACCESS
  • Locked
    15. 
    Designing SET Based Operations in SQL Server 2014
    5m 43s
    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 of this course, which can be shared on any social network or business platform

Digital badges are yours to keep, forever.

YOU MIGHT ALSO LIKE

BOOK Pro T-SQL 2019: Toward Speed, Scalability, and Standardization for SQL Server Developers
BOOK SQL Server 2019 AlwaysOn: Supporting 24x7 Applications with Continuous Uptime, Third Edition
COURSE Azure Serverless Development Principles: Serverless Database & Storage