Implementation, Creation, & Troubleshooting
SQL Server 2014
| Expert
- 15 videos | 1h 24m 49s
- Includes Assessment
- Earns a Badge
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 45sIn this video, you will create in-memory OLTP tables. FREE ACCESS
-
3m 9sIn this video, learn how to troubleshoot issues with In-Memory OLTP. FREE ACCESS
-
3. Monitoring In-Memory OLTP Resources in SQL Server 20146m 31sIn this video, you will learn how to monitor In-Memory OLTP issues. FREE ACCESS
-
4. Automating Backups using Scripts in SQL Server 20144m 35sIn this video, you will create scripts to automate backups. FREE ACCESS
-
5. Creating Calculated Columns in SQL Server 2014 Tables3m 30sIn this video, you will learn how to create calculated columns in tables. FREE ACCESS
-
6. Implementing Constraints in SQL Server 20147m 17sLearn how to implement cascading deletes. FREE ACCESS
-
7. Creating Indexed Views in SQL Server 20144m 3sIn this video, you will learn how to create indexed views. FREE ACCESS
-
8. Creating Aligned Indexes in SQL Server 20147m 3sIn this video, learn how to create an aligned index on a partitioned table. FREE ACCESS
-
9. Implementing XML Selective Indexes in SQL Server 20146m 10sIn this video, you will create selective XML indexes. FREE ACCESS
-
10. Managing Transactions in SQL Server 20147m 37sFind out how to manage transactions in a given scenario. FREE ACCESS
-
11. Implementing Error Handling in SQL Server 20146m 12sIn this video, you will learn how to implement error handling using TRY, CATCH, and THROW. FREE ACCESS
-
12. Designing Objects for Concurrency in SQL Server 20146m 34sIn this video, learn how to design for maximum concurrency and transaction isolation. FREE ACCESS
-
13. Designing a Locking Strategy in SQL Server 20146m 24sIn this video, you will learn how to design index locking properties and transactions to minimize locking. FREE ACCESS
-
14. Designing Query Paging in SQL Server 20144m 14sDuring this video, you will learn how to design query paging, including using OFFSET and FETCH. FREE ACCESS
-
15. Designing SET Based Operations in SQL Server 20145m 43sIn 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.
