OpenCourser brand icon
Sign in
We may earn an affiliate commission when you visit our partners.
Course Discontinued We've found some alternatives for you:

Top Active Alternatives

Using Memory-optimized Tables and Native Stored Procedures is no longer accepting new enrollments. We've matched the highest-rated active courses in this subject:

Read Reviews → Enroll Active
Read Reviews → Enroll Active
Read Reviews → Enroll Active
Pluralsight logo

Using Memory-optimized Tables and Native Stored Procedures

Pinal Dave

The objective of this course is to help your SQL Server-based applications to run at rapid speed to by taking advantages of In-Memory OLTP Technologies - Memory-optimized Tables and Native Stored Procedures.

Read more

The objective of this course is to help your SQL Server-based applications to run at rapid speed to by taking advantages of In-Memory OLTP Technologies - Memory-optimized Tables and Native Stored Procedures.

The In-Memory OLTP feature adds a new memory optimized RDBMS engine and a native compiled stored procedure. This new addition adds higher concurrency to the SQL Server and enables it to process a much higher amount of the workload than before. In this course, we will learn about how to get started with the memory optimized tables and build a use case around its effectiveness. Additionally, we will also understand how the efficiency of the stored procedure is increased when we use Native Stored Procedure along with Memory Optimized Tables.

This course is no longer available. Find something similar by browsing:
SQL Server In-Memory OLTP Memory-Optimized Tables Native Stored Procedures Performance Optimization

What's inside

Syllabus

Course Overview
Creating Memory Optimized Tables
Optimizing Performance of In-Memory Tables
Creating Natively Compiled Stored Procedures
Read more

Traffic lights

Read about what's good
what should give you pause
and possible dealbreakers
Develops skills and knowledge in utilizing In-Memory Optimized Technologies, relevant to both industry and SQL Server
Leverages hands-on learning and interactive material for better understanding
Taught by industry-recognized instructors
Prerequisites not specified, requiring learners to come in with foundational knowledge

Save this course

Create your own learning path. Save this course to your list so you can find it easily later.
Save

Reviews summary

Optimizing sql server with in-memory oltp

According to students who would typically seek such specialized training, this course offers a practical and in-depth exploration of SQL Server In-Memory OLTP technologies, including Memory-optimized Tables and Native Stored Procedures. It is particularly valued for its focus on optimizing application performance and achieving higher concurrency. While considered highly beneficial for experienced professionals seeking to speed up SQL Server workloads, some learners indicate it assumes a foundational understanding of database concepts, potentially making it challenging for beginners. The course's ability to help apply these advanced features in real-world use cases is a key strength.
Requires prior SQL Server and database understanding.
"I found this course quite advanced; it definitely assumes you have a solid background in SQL Server administration."
"While highly informative, I think beginners would struggle without a good grasp of standard SQL and database concepts."
"It's clear this course is for professionals; if you're not comfortable with SQL Server fundamentals, prepare for a challenge."
Provides specialized knowledge in a specific SQL Server area.
"The content is very specific to In-Memory OLTP, which is exactly what I needed for a particular project."
"It's great to find a course that dives deep into such a specialized and impactful SQL Server feature."
"I appreciate the focused approach on memory-optimized tables rather than a general SQL Server overview."
Demonstrates how to implement features effectively.
"The examples of creating and using memory-optimized tables were very practical and easy to follow."
"I liked how the course showed building a use case around the effectiveness of these technologies."
"Collecting execution statistics for native stored procedures was a hands-on skill I could immediately use."
Focuses on boosting SQL Server application speed.
"I learned how to significantly speed up my SQL Server-based applications by leveraging in-memory features."
"This course directly addresses improving database performance and concurrency, which is crucial for modern applications."
"I found the techniques taught for optimizing in-memory tables and procedures immediately applicable to my work."

Activities

Be better prepared before your course. Deepen your understanding during and after it. Supplement your coursework and achieve mastery of the topics covered in Using Memory-optimized Tables and Native Stored Procedures with these activities:
Organize and review all course materials, including notes, assignments, and quizzes
Regularly organizing and reviewing all course materials will reinforce your understanding, identify areas for improvement, and improve your overall retention.
Show steps
  • Gather all course materials.
  • Create a system for organizing the materials.
  • Review the materials regularly.
  • Identify areas where you need further clarification.
  • Seek additional resources or support if necessary.
Read the Microsoft documentation on Memory Optimized Tables
Reviewing the Microsoft documentation on Memory Optimized Tables will provide you with authoritative information and a deeper understanding of their technical details and best practices.
View Exam 70-432 on Amazon
Show steps
  • Access the Microsoft documentation.
  • Read and understand the concepts of Memory Optimized Tables.
  • Review the best practices for using Memory Optimized Tables.
  • Bookmark important sections for future reference.
Follow a tutorial on creating and using In-Memory Tables in SQL Server
Following a guided tutorial on creating and using In-Memory Tables will provide hands-on experience and deepen your understanding of their usage and benefits.
Browse courses on SQL Server
Show steps
  • Identify a suitable tutorial.
  • Follow the steps in the tutorial to create and use an In-Memory Table.
  • Experiment with different scenarios and parameters.
  • Document your findings and observations.
Five other activities
Expand to see all activities and additional details
Show all eight activities
Write and execute T-SQL queries to create and query Memory Optimized Tables
Practice writing and executing T-SQL queries to create and query Memory Optimized Tables, which will help you solidify your understanding of their structure and usage.
Browse courses on SQL Server
Show steps
  • Create a new database for the exercise.
  • Create a Memory Optimized Table.
  • Insert data into the Memory Optimized Table.
  • Query the Memory Optimized Table.
Write a blog post that explains the benefits and limitations of using Native Stored Procedures
Write a blog post that explains the benefits and limitations of using Native Stored Procedures to enhance your understanding of their potential and constraints.
Show steps
  • Research the benefits and limitations of using Native Stored Procedures.
  • Write an outline for the blog post.
  • Draft the blog post.
  • Edit and proofread the blog post.
  • Publish the blog post.
Execute queries against Memory Optimized Tables and analyze execution plans
Execute queries against Memory Optimized Tables and analyze execution plans to identify and resolve performance bottlenecks, enhancing your ability to optimize query performance.
Browse courses on SQL Server
Show steps
  • Create a query that performs a specific operation on a Memory Optimized Table.
  • Capture the execution plan for the query.
  • Analyze the execution plan to identify potential bottlenecks.
  • Modify the query to optimize performance.
  • Re-run the query and verify the improved performance.
Attend a workshop on Memory Optimized Tables in SQL Server
Attending a workshop on Memory Optimized Tables will provide expert insights and hands-on experience, accelerating your learning and improving your skills.
Browse courses on SQL Server
Show steps
  • Research and identify relevant workshops.
  • Register for a workshop.
  • Attend the workshop and actively participate.
  • Take notes and ask questions.
  • Apply what you learn to your own projects.
Create a data visualization that compares performance metrics of regular tables and Memory Optimized Tables
Create a data visualization to compare performance metrics of regular tables and Memory Optimized Tables, providing tangible evidence of the performance benefits offered by Memory Optimized Tables.
Browse courses on Performance Optimization
Show steps
  • Collect performance metrics for regular tables and Memory Optimized Tables.
  • Choose an appropriate data visualization tool.
  • Create a data visualization that compares the performance metrics.
  • Interpret the results of the visualization.
  • Draw conclusions and make recommendations.

Career center

Learners who complete Using Memory-optimized Tables and Native Stored Procedures will develop knowledge and skills that may be useful to these careers:
Database Administrator (DBA)
A Database Administrator (DBA) is responsible for maintaining and optimizing the performance of database systems. This role often requires knowledge of multiple database technologies, including Microsoft SQL Server. The Using Memory-optimized Tables and Native Stored Procedures course can help DBAs learn how to use these technologies to improve the performance of their SQL Server databases. This course can be particularly helpful for DBAs who are working with high-performance applications that require fast data access.
See salaries and explore the career path for Database Administrator (DBA)
Data Engineer
Data Engineers design and build data pipelines that move data from various sources into a central data warehouse or data lake. They also develop and maintain the infrastructure that supports these pipelines. The Using Memory-optimized Tables and Native Stored Procedures course can help Data Engineers learn how to use these technologies to improve the performance of their data pipelines. This course can be particularly helpful for Data Engineers who are working with large datasets or who need to process data in real-time.
See salaries and explore the career path for Data Engineer
Data Scientist
Data Scientists use data to build models that can predict future events or identify trends. They also develop and implement algorithms that can be used to analyze data and make decisions. The Using Memory-optimized Tables and Native Stored Procedures course can help Data Scientists learn how to use these technologies to improve the performance of their models and algorithms. This course can be particularly helpful for Data Scientists who are working with large datasets or who need to process data in real-time.
See salaries and explore the career path for Data Scientist
Software Engineer
Software Engineers design, develop, and maintain software applications. They also work with other engineers to integrate software applications with other systems. The Using Memory-optimized Tables and Native Stored Procedures course can help Software Engineers learn how to use these technologies to improve the performance of their software applications. This course can be particularly helpful for Software Engineers who are working with high-performance applications that require fast data access.
See salaries and explore the career path for Software Engineer
Systems Analyst
Systems Analysts analyze and design computer systems. They also develop and implement solutions to improve the efficiency and effectiveness of these systems. The Using Memory-optimized Tables and Native Stored Procedures course can help Systems Analysts learn how to use these technologies to improve the performance of their systems. This course can be particularly helpful for Systems Analysts who are working with high-performance systems that require fast data access.
See salaries and explore the career path for Systems Analyst
Database Architect
Database Architects design and develop the structure and architecture of databases. They also work with other engineers to ensure that databases are scalable, reliable, and secure. The Using Memory-optimized Tables and Native Stored Procedures course can help Database Architects learn how to use these technologies to improve the performance of their databases. This course can be particularly helpful for Database Architects who are working with high-performance databases that require fast data access.
See salaries and explore the career path for Database Architect
Data Warehouse Architect
Data Warehouse Architects design and develop data warehouses. They also work with other engineers to ensure that data warehouses are scalable, reliable, and secure. The Using Memory-optimized Tables and Native Stored Procedures course can help Data Warehouse Architects learn how to use these technologies to improve the performance of their data warehouses. This course can be particularly helpful for Data Warehouse Architects who are working with high-performance data warehouses that require fast data access.
See salaries and explore the career path for Data Warehouse Architect
ETL Developer
ETL Developers extract, transform, and load data from various sources into a central data warehouse or data lake. They also develop and maintain the infrastructure that supports these processes. The Using Memory-optimized Tables and Native Stored Procedures course can help ETL Developers learn how to use these technologies to improve the performance of their ETL processes. This course can be particularly helpful for ETL Developers who are working with large datasets or who need to process data in real-time.
See salaries and explore the career path for ETL Developer
BI Developer
BI Developers develop and implement business intelligence solutions. They also work with other engineers to ensure that these solutions are scalable, reliable, and secure. The Using Memory-optimized Tables and Native Stored Procedures course can help BI Developers learn how to use these technologies to improve the performance of their BI solutions. This course can be particularly helpful for BI Developers who are working with high-performance BI solutions that require fast data access.
See salaries and explore the career path for BI Developer
Data Analyst
Data Analysts collect, analyze, and interpret data to identify trends and patterns. They also develop and implement solutions to improve the efficiency and effectiveness of businesses. The Using Memory-optimized Tables and Native Stored Procedures course can help Data Analysts learn how to use these technologies to improve the performance of their data analysis processes. This course can be particularly helpful for Data Analysts who are working with large datasets or who need to process data in real-time.
See salaries and explore the career path for Data Analyst
Database Programmer
Database Programmers write and maintain code that interacts with databases. They also work with other engineers to ensure that this code is scalable, reliable, and secure. The Using Memory-optimized Tables and Native Stored Procedures course can help Database Programmers learn how to use these technologies to improve the performance of their code. This course can be particularly helpful for Database Programmers who are working with high-performance applications that require fast data access.
See salaries and explore the career path for Database Programmer
Information Security Analyst
Information Security Analysts protect computer systems and networks from unauthorized access, use, disclosure, disruption, modification, or destruction. They also develop and implement security policies and procedures to ensure that computer systems and networks are secure. The Using Memory-optimized Tables and Native Stored Procedures course may be useful for Information Security Analysts who are interested in learning how to use these technologies to improve the security of their systems and networks.
See salaries and explore the career path for Information Security Analyst
IT Manager
IT Managers plan, implement, and manage computer systems and networks. They also work with other managers to ensure that IT systems and networks are aligned with the business goals of the organization. The Using Memory-optimized Tables and Native Stored Procedures course may be useful for IT Managers who are interested in learning how to use these technologies to improve the performance of their IT systems and networks.
See salaries and explore the career path for IT Manager
Project Manager
Project Managers plan, execute, and close projects. They also work with other stakeholders to ensure that projects are completed on time, within budget, and to the required quality standards. The Using Memory-optimized Tables and Native Stored Procedures course may be useful for Project Managers who are interested in learning how to use these technologies to improve the performance of their projects.
See salaries and explore the career path for Project Manager
Technical Writer
Technical Writers create and maintain technical documentation. They also work with other engineers to ensure that this documentation is clear, accurate, and complete. The Using Memory-optimized Tables and Native Stored Procedures course may be useful for Technical Writers who are interested in learning how to use these technologies to improve the quality of their documentation.
See salaries and explore the career path for Technical Writer

Reading list

We've selected seven books that we think will supplement your learning. Use these to develop background knowledge, enrich your coursework, and gain a deeper understanding of the topics covered in Using Memory-optimized Tables and Native Stored Procedures.
Cover image
SQL Server MVP Deep Dives, Volume 2
Save
Covers SQL Server storage architecture, including object structure, buffer pool operations, and locking mechanisms.
SQL Server MVP Deep Dives, Volume 2
Kindle Edition
$$
Cover image
SQL Server 2022 Query Performance Tuning
Save
Provides a practical approach in SQL Server query performance tuning and optimization using execution plans.
SQL Server 2022 Query Performance Tuning
Paperback
Check
SQL Server 2022 Query Performance Tuning
Kindle Edition
Check
Cover image
Data Structures And Algorithms Made Easy
Save
Provides a solid foundation in data structures and algorithms, which are essential concepts for understanding database systems.
Data Structures and Algorithms Made Easy: Data...
Paperback
$$
Data Structures and Algorithms Made Easy in Java:...
Paperback
$$
Data Structures and Algorithms Made Easy: Data...
Paperback
$$
Data Structures and Algorithms Made Easy: Data...
Kindle Edition
$
Data Structures and Algorithms Made Easy in Java:...
Kindle Edition
$
Data Structures and Algorithms Made Easy in Java:...
Kindle Edition
$
Data Structures and Algorithms Made Easy: Data...
Paperback
$$
Data Structures and Algorithms Made Easy: Data...
Paperback
$$
Data Structures and Algorithms Made Easy
Kindle Edition
$
Data Structures and Algorithms Made Easy in Java
Hardcover
$$$
Cover image
SQL in a Nutshell
Save
Contains practical advice on administration and maintenance tasks within SQL
SQL in a Nutshell
Kindle Edition
$$
Cover image
Secret Colors
Save
Provides insight into how to design and implement systems with large datasets with a focus on data consistency and scalability.
Secret Colors
Paperback
Check
Secret Colors
Kindle Edition
Check
Cover image
Database Systems: The Complete Book
Save
Provides a comprehensive introduction to database systems and concepts.
Database Systems: The Complete Book
Kindle Edition
$$$
Database Systems The Complete Book
Paperback
$$
Database Systems: The Complete Book
Hardcover
$$$$
Goal Student Access Code Card for Database Systems:...
Printed Access Code
$$
Cover image
High Performance MySQL
Save
Provides a different perspective on performance tuning using MySQL. While not SQL Server-specific, it covers general principles that can be applied.
High Performance MySQL: Optimization, Backups, and...
Paperback
$$
High Performance MySQL: Optimization, Backups,...
Paperback
$$
(中文) High Performance MySQL ( 3rd Edition ) (MySQL...
Paperback
$$

Share

Help others find this course page by sharing it with your friends and followers:
Facebook
LinkedIn
Reddit
X
Link
Email

Similar courses

Here are nine courses similar to Using Memory-optimized Tables and Native Stored Procedures.
Real-world Scenarios: SQL Server Query Tuning in Action
Most relevant
SQL Server: Scaling SQL Server 2012 and 2014: Part 2
Most relevant
Compiled Data Binding Fundamentals in UWP 10 Using XAML
Most relevant
JCache Fundamentals
Most relevant
Shifting JavaScript into High Gear with Web Workers
Most relevant
Using Memcached and Varnish to Speed Up Your Linux Web App
Most relevant
Practical SQL Server Security, Compliance, and Auditing
Most relevant
Implement Windows Server 2016 IP Address Management (IPAM)
Most relevant
SQL Server Application Development Best Practices
Most relevant

Pluralsight Buyer Protection & Guarantee

Verified partner policies & purchase protections

Enterprise Technology Platform
Free Trial & Audit

10-Day Free Trial

10-day free trial (up to 200 minutes of content) with access to the Skills video library and skill assessments. Cancel before day 10 to avoid automatic conversion.

Return & Refund Policy

Cancel Anytime (Non-Refundable Once Billed)

Cancel easily online anytime before the 10-day trial expires to prevent billing. Once subscription fees are paid, individual subscriptions are non-refundable (cancellation stops future renewals).

Buyer Protections

Verified Academic & Industry Partner

Skill IQ and Role IQ diagnostic benchmark assessments, hands-on lab environments, and curated learning paths designed by technology leaders.

Key Purchase Protections
10-day free trial on individual Skills plans
Skill IQ assessments to benchmark proficiency
Cancel anytime online before trial ends without fees
Hands-on interactive labs and enterprise-grade tech content
OpenCourser Verified Partner Policy details last reviewed: 2026-10-22
Course image
Time
118 hours
Level
Intermediate
Via
Pluralsight
Instructor
Pinal Dave
Language
English
This course belongs to a collection called Developing SQL Server Databases. It's comprised of ten courses:
  1. Designing and Implementing SQL Server Tables and Views
  2. Designing and Implementing SQL Server Database Indexes
  3. Programming SQL Server Database Stored Procedures
  4. Programming SQL Server Database Triggers and Functions
  5. Managing SQL Server Database Concurrency
  6. Using Memory-optimized Tables and Native Stored Procedures (viewing)
  7. Optimizing SQL Server Statistics and Indexes
  8. Analyzing SQL Server Query Plans
  9. Managing SQL Server Database Performance
  10. Managing Azure SQL Server Database Performance
Traffic lights
Read about what's good
what should give you pause
and possible dealbreakers
Develops skills and knowledge in utilizing In-Memory Optimized Technologies, relevant to both industry and SQL Server
Leverages hands-on learning and interactive material for better understanding
Taught by industry-recognized instructors
Prerequisites not specified, requiring learners to come in with foundational knowledge
Share this
Share to help others discover this course.
Facebook LinkedIn X Reddit Link Email
Begin learning today
This course is currently discontinued or unavailable. See active alternatives above.
Course Unavailable
Save for later
Add this course to your list. Find it anytime.
Save
Our mission

OpenCourser helps millions of learners each year. People visit us to learn workspace skills, ace their exams, and nurture their curiosity.

Our extensive catalog contains over 50,000 courses and twice as many books. Browse by search, by topic, or even by career interests. We'll match you to the right resources quickly.

Find this site helpful? Tell a friend about us.

Affiliate disclosure

We're supported by our community of learners. When you purchase or subscribe to courses and programs or purchase books, we may earn a commission from our partners.

Your purchases help us maintain our catalog and keep our servers humming without ads.

Thank you for supporting OpenCourser.

© 2016 - 2025 OpenCourser