Boost SQL Server Database Performance with In-Memory OLTP
- 4.2
-
![]()
![]()
![]()
![]()
Brief Introduction
Learn how to use the powerful In-Memory OLTP Engine in SQL Server for improving database performanceDescription
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
Requirements
- Requirements
- Basic knowledge of SQL Server and database principles
Artemakis Artemiou
4.2 Raiting
Boost SQL Server Database Performance with In-Memory OLTP
- 4.2
-
![]()
![]()
![]()
![]()
![]()
Learn how to use the powerful In-Memory OLTP Engine in SQL Server for improving database performance In-Memory OLTP, is SQL Server's Database In-Memory Processing Engine, seamlessly integrated into its Database Engine....
