Boost SQL Server Database Performance with In-Memory OLTP

Learn how to use the powerful In-Memory OLTP Engine in SQL Server for improving database performance

4.55 (38 reviews)
Udemy
platform
English
language
Databases
category
186
students
3 hours
content
Jan 2024
last update
$54.99
regular price

What you will learn

Master In-Memory OLTP: Understand and enable SQL Server's In-Memory OLTP feature for enhanced performance.

Optimize Memory-Optimized Tables: Design and implement efficient memory-optimized tables to boost data processing.

Harness Natively-Compiled Stored Procedures: Create and utilize high-performance natively-compiled stored procedures in SQL Server.

Enhance Database Performance: Improve workload performance by migrating databases and estimating gains with In-Memory OLTP.

Description

Welcome to the exciting world of SQL Server's In-Memory Database Processing Engine, also known as In-Memory OLTP! Get ready to supercharge your data processes and unlock unparalleled performance gains. Throughout this course, you'll dive deep into the inner workings of In-Memory OLTP, empowering you to harness its full potential. Discover how to enable In-Memory OLTP in SQL Server, leverage memory-optimized tables, and unleash the power of natively-compiled stored procedures.

Originally introduced in SQL Server 2014 and enhanced in subsequent versions, In-Memory OLTP has become an indispensable feature for database professionals. Whether you're a seasoned SQL Server expert or just starting your journey, exploring this powerful feature is a must. In-Memory OLTP is not limited to specific editions of SQL Server anymore. Since SQL Server 2016 SP1, it's available across all editions (except LocalDB), making it accessible to everyone. Embrace the opportunity to revolutionize your data processing capabilities.

In this data-driven era, where speed and efficiency are paramount, In-Memory OLTP emerges as the hero. Join this course and equip yourself with the knowledge and skills to unleash the true power of SQL Server's In-Memory OLTP Engine. Let's embark on this transformative journey together and revolutionize the way you handle data. Enroll now and elevate your SQL Server expertise to new heights!


Why Enroll in this Course?

  • Understand the core concepts and benefits of In-Memory OLTP in SQL Server.

  • Learn how to enable and configure In-Memory OLTP to harness its full potential.

  • Dive deep into creating and utilizing memory-optimized tables for maximum performance.

  • Harness the power of natively-compiled stored procedures to supercharge query execution.

  • Discover techniques to improve overall SQL Server performance using In-Memory OLTP.

  • Gain practical insights through real-world examples and scenarios.

  • Access valuable downloadable resources to enhance your learning experience.

  • Test your knowledge with quizzes and a practice test to reinforce your understanding.

  • Get personalized support and guidance from the instructor through the Q&A section.

  • Earn a certificate of completion, showcasing your expertise in SQL Server In-Memory OLTP.


What Other Learners Say About 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."


Major Learning Objectives:

  1. Unleash the Power of In-Memory OLTP in SQL Server:

    1. Explore the world of In-Memory OLTP and discover its potential for transforming your database performance.

    2. Identify the best-suited workloads that can benefit from In-Memory OLTP.

  2. Enabling In-Memory OLTP in SQL Server:

    1. Dive into the requirements for enabling In-Memory OLTP and unleash its full capabilities.

    2. Together, we'll create a SQL Server In-Memory OLTP-Enabled database to get you started.

  3. Memory-Optimized Tables: Turbocharge Your Database Performance:

    1. Master the art of creating and utilizing durable and non-durable memory-optimized tables in SQL Server.

    2. Witness the remarkable performance difference between these two types of memory-optimized tables through captivating examples.

  4. Natively-Compiled Stored Procedures: The Secret to Lightning-Fast Execution:

    1. Uncover the secrets of natively-compiled stored procedures in SQL Server and harness their power.

    2. Experience first-hand the performance comparison between disk-based processes, memory-optimized tables, and natively-compiled stored procedures.

  5. Supercharge Your Workload with In-Memory OLTP:

    1. Discover effective techniques for improving your overall database performance using In-Memory OLTP.

    2. Learn how to migrate your databases to In-Memory OLTP and estimate the performance gains specific to your workload.

  6. Real-World Examples: Unleashing the Speed of In-Memory OLTP:

    1. Embark on a journey through practical examples showcasing the real impact of In-Memory OLTP in SQL Server.

    2. Witness the performance difference between disk-based processes, memory-optimized tables, and the combination of memory-optimized tables with natively-compiled stored procedures.


Unlock the true potential of In-Memory OLTP in SQL Server and revolutionize your database performance. Enroll now to embark on this transformative learning experience!


Prerequisites:

  • Basic knowledge of SQL Server and data principles


Course Highlights:

  • Engaging and Concise: Experience 3 hours of high-quality video content that focuses on delivering key concepts without overwhelming you.

  • Practical Demonstrations: Learn through live demonstrations and hands-on guides that provide a comprehensive understanding of In-Memory OLTP in action.

  • Assess Your Progress: Reinforce your learning with useful quizzes at the end of each section to test your knowledge and track your progress.

  • Extensive Downloadable Resources: Access a wealth of downloadable resources, including helpful summaries and ready-to-use T-SQL scripts, to enhance your learning experience.

  • Final Assessment: Put your newfound knowledge to the test with a comprehensive practice test at the end of the course, ensuring you've grasped the essential concepts.

  • Instructor Interaction: Engage with the instructor and fellow learners through the Q&A section, where you can seek clarification and gain deeper insights.

  • Course Completion Certificate: Receive a certificate upon successfully completing the course, showcasing your mastery of In-Memory OLTP in SQL Server.

Content

Introduction

Welcome to the Course! What Will You Learn?
What is In-Memory OLTP in SQL Server?
Best-Suited Workload Types for In-Memory OLTP
Limitations of In-Memory OLTP in SQL Server
How Can this Course Help You?
Section Recap
Introduction

Enabling In-Memory OLTP in SQL Server

Section Overview
Requirements for Enabling In-Memory OLTP in SQL Server
How to Create a SQL Server In-Memory OLTP-Enabled Database
In-Memory OLTP T-SQL Limitations
Section Recap
Enabling In-Memory OLTP in SQL Server

Memory-Optimized Tables

Section Overview
What are Memory-Optimized Tables in SQL Server?
Creating a Non-Durable Memory-Optimized Table
Creating a Durable Memory-Optimized Table
Let’s Compare the Performance Between Disk-Based and Memory Optimized Tables
Section Recap
Memory-Optimized Tables

Natively-Compiled Stored Procedures

Section Overview
What are Natively-Compiled Stored Procedures in SQL Server?
Creating a Natively-Compiled Stored Procedure in SQL Server
Performance of Disk-Based vs Memory Optimized Tables vs Natively Compiled SPs
Section Recap
Natively-Compiled Stored Procedures

Improving SQL Server Performance Using In-Memory OLTP

Section Overview
Migrating your Databases to In-Memory OLTP: The Right Candidates
Will your Workload Execute Faster?
Ways of Estimating if You Can Benefit from In-Memory OLTP
Section Recap
Improving SQL Server Performance Using In-Memory OLTP

Examples of Using SQL Server In-Memory OLTP

Section Overview
About our Test Environment
Scenario: Import Text File of 100K Records
Scenario: Update Single Column in Table with 100K Records
Scenario: Run Aggregation on a Table with 100K Records
Section Recap
Examples of Using SQL Server In-Memory OLTP

Putting it All Together

What Have you Learned in this Course?
Boost SQL Server Database Performance with In-Memory OLTP

Learning More

Bonus Lecture

Screenshots

Boost SQL Server Database Performance with In-Memory OLTP - Screenshot_01Boost SQL Server Database Performance with In-Memory OLTP - Screenshot_02Boost SQL Server Database Performance with In-Memory OLTP - Screenshot_03Boost SQL Server Database Performance with In-Memory OLTP - Screenshot_04

Reviews

Tushar
March 22, 2023
The course is well structured for understanding the required concepts for implementation SQL Server In-Memory OLTP features. The explanation and demos are simple to understand and build on further.
Phanindra
April 18, 2022
This was very nice course about In-Memory Database & Providing more details about the Memory Optimized Tables & Natively-Compiled Stored Procedures.
Sayedkhalidsultani
November 25, 2021
thanks for the course , further material can be added on replication on memory optimized tables and HA considerations.
Thomas
January 14, 2021
Ich fand den Kurs recht gut, die Ausführungen waren klar und verständlich. Es wäre aber nicht nötig, die immer ähnlichen Vergleichstabellen und Diagramme die auch immer das gleiche Ergebnis liefern, jedes Mal so enorm ausführlich zu beschreiben.
Shaima
August 2, 2020
The course is giving high level and quick information. Since this course is advanced level and specifically for in-memory OLTP, as DBA i was expecting in depth information of the technology it self, how tables are being created and accessed in the memory without blocking, how durable tables are in sync between memory and disks.
Giannis
June 5, 2020
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.
Doros
June 3, 2020
Another great course from Mr. Artemiou. I especially like the clear structure, and it is surely full of helpful info and tips. Thanks!!

Charts

Price

Boost SQL Server Database Performance with In-Memory OLTP - Price chart

Rating

Boost SQL Server Database Performance with In-Memory OLTP - Ratings chart

Enrollment distribution

Boost SQL Server Database Performance with In-Memory OLTP - Distribution chart
2198958
udemy ID
2/5/2019
course created date
7/24/2020
course indexed date
Bot
course submited by