In this course you will learn all about SQLServer'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 SQLServer, 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 SQLServer feature.

In-Memory OLTP, is SQLServer'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 OLTPcan help you achieve significant performance improvements and speedups for many of your data processes.

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

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. SQLServer's In-Memory OLTPEngine can help with that.

WHAT OTHERSTUDENTSSAYABOUT THE COURSE:

• "Excellent and helpful course regarding SQL Server. Very suitable for my job."

• "So far the course is great! The simplicity of explaining the different concepts is outstanding!"

• "An easy to follow course with excellent content!"

• "I was impressed by this course! It explains in plain words how to utilize In-Memory Optimization in SQL Server and the demos are really amazing."

  
  

THE BENEFITS OF THIS COURSE:

By the time you complete this 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

MAJOR LEARNING OBJECTIVES:

Throughout the course, I will take you through all the necessary steps that you need to learn, in order to start utilizing SQLServer's powerful In-Memory OLTPengine.

First, via the introductory section, you will learn what In-Memory OLTPis and which are the best-suited workloads for In-Memory OLTP.

After that, we will be discussing about the requirements for enabling In-Memory OLTPin SQLServer, and we will create together, a SQL Server In-Memory OLTP-Enabled database.

Then, we will thoroughly discuss about memory-optimized tables, and you will learn how to create and use durable and non-durable memory optimized tables in SQLServer. Moreover, we will run some examples for comparing the performance of these two types of memory-optimized tables.

After that, we will be discussing about natively-compiled stored procedures in SQLServer, and among other, you will learn how to create and use this special type of SQLServer stored procedures. Moreover, we will run some interesting examples, for comparing the performance of a disk-based process vs. a process that uses memory-optimized tables vs. a process that uses memory-optimized tables combined with natively-compiled stored procedures.

Then, we will be discussing about how you can improve the performance of your database workload using In-Memory OLTP, and more specifically, we will discuss about, how you can migrate your databases to In-Memory OLTP and how you can estimate if your specific workload type, can benefit from In-Memory OLTPprocessing in SQLServer.

Finally, we will go through together, many examples of using In-Memory OLTPin SQLServer, where among other, we will be comparing the performance of different disk-based processes vs. processes that use memory-optimized tables vs. processes that use memory-optimized tables combined with natively-compiled stored procedures.

PREREQUISITES:

• Basic knowledge of SQLServer and data principles

  
  

THIS COURSE CONTAINS/OFFERS:

• 3 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-SQLscripts)

• A practice test in the end of the course

• Ability to ask the instructor questions via the Q&Asection

• Certificate on course completion