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 tablestroubleshoot In-Memory OLTP issuesmonitor In-Memory OLTP issuescreate scripts to automate backupscreate calculated columns in tablesimplement cascading deletescreate indexed viewscreate a aligned index on a partitioned table
-
create XML selective indexesmanage transactions in a given scenarioimplement error handling using TRY, CATCH, and THROWdesign for maximize concurrency and transaction isolationdesign index locking properties and transactions to minimize lockingdesign query paging, including OFFSET and FETCHcreate scripts that use SET based operations
IN THIS COURSE
-
1.Creating In-Memory OLTP Tables in SQL Server 20145m 45sUP NEXT
-
2.Troubleshooting In-Memory OLTP in SQL Server 20143m 9s
-
3.Monitoring In-Memory OLTP Resources in SQL Server 20146m 31s
-
4.Automating Backups using Scripts in SQL Server 20144m 35s
-
5.Creating Calculated Columns in SQL Server 2014 Tables3m 30s
-
6.Implementing Constraints in SQL Server 20147m 17s
-
7.Creating Indexed Views in SQL Server 20144m 3s
-
8.Creating Aligned Indexes in SQL Server 20147m 3s
-
9.Implementing XML Selective Indexes in SQL Server 20146m 10s
-
10.Managing Transactions in SQL Server 20147m 37s
-
11.Implementing Error Handling in SQL Server 20146m 12s
-
12.Designing Objects for Concurrency in SQL Server 20146m 34s
-
13.Designing a Locking Strategy in SQL Server 20146m 24s
-
14.Designing Query Paging in SQL Server 20144m 14s
-
15.Designing SET Based Operations in SQL Server 20145m 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.