Boost SQL Server Database Performance with In-Memory OLTP

In this course you will learn all about SQL Server's In-Memory Database Processing Engine also known as In-Memory OLTP. To this end, you will learn how to enable In-Memory OLTP in SQL Server, what memory-optimized tables and natively-compiled stored procedures are, as well as, how to boost the performance of your data processes using this powerful SQL Server feature.

In-Memory OLTP, is SQL Server's Database In-Memory Processing Engine, seamlessly integrated into its Database Engine. With its two main components, that is memory-optimized tables and natively-compiled stored procedures, In-Memory OLTP can help you achieve significant performance improvements and speedups for many of your data processes.

In-Memory OLTP was originally shipped with SQL Server 2014 but was significantly enhanced in SQL Server 2016 and later. From SQL Server 2016 SP1 and later, In-Memory OLTP is available for use in all editions of SQL Server (besides the LocalDB edition), which is something that makes it a must, to at least try this great feature in SQL Server.

Especially now, in this data-driven era we live in, where business decisions and many other areas depend on the fast analysis of large sets of data, maintaining a low latency for your data processes is critical. SQL Server's In-Memory OLTP Engine can help with that.

Via my course "Boost SQL Server Database Performance with In-Memory OLTP", you will get introduced to SQL Server In-Memory OLTP and you will learn how to start using it fast and easy. Since In-Memory OLTP is integrated into SQL Server's Database Engine, it is very easy to start using it. By the time you work with memory-optimized tables and natively-compiled stored procedures via the well-known T-SQL, it makes it easy to start using memory-optimized tables and natively-compiled stored procedures too. Via my course, I provide all the necessary knowledge and hands-on guides, that will help you start using In-Memory OLTP and realize its huge potential when it comes to significantly improving the performance of your data processes.

AFTER THE COURSE YOU WILL KNOW:

• What is the In-Memory OLTP Engine in SQL Server and how it works

• What Memory-Optimized Tables are and which are their main characteristics

• What Natively-Compiled Stored Procedures are and how they work

• How to Use In-Memory OLTP for Boosting the Performance of your Data Processes, by utilizing memory-optimized tables and natively-compiled stored procedures

• How to migrate your data processes to In-Memory OLTP

  • How to find the right candidate databases, data processes and tables for migrating it to In-Memory OLTP 

  • How to analyze your tables and stored procedures prior to planning their migration to In-Memory OLTP

  • Ways to estimate if your workload's performance can benefit from In-Memory OLTP

    
    

PREREQUISITES:

• Basic knowledge of SQL Server and data principles

  
  

THIS COURSE CONTAINS/OFFERS:

• 2.5 hours of high-quality video

• Live demonstrations and hands-on guides

• Useful quizzes for testing your knowledge on each section

• Many downloadable resources (i.e. summaries and T-SQL scripts)

• A practice test in the end of the course

• Ability to ask the instructor questions via the Q&A section

• Certificate on course completion