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

Requirements Basic knowledge of SQL Server and database principles