OpenCourser brand icon
Sign in
We may earn an affiliate commission when you visit our partners.
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.

Enroll now

Here's a deal for you

We found an offer that may be relevant to this course.
Save money when you learn. All coupon codes, vouchers, and discounts are applied automatically unless otherwise noted.
Valid for a limited time only
Future-proof your career
Access O'Reilly books, live events, courses, and more. Save with an annual subscription.
Take
15%
off

What's inside

Syllabus

Course Overview
Creating Memory Optimized Tables
Optimizing Performance of In-Memory Tables
Creating Natively Compiled Stored Procedures
Read more
Collecting Execution Statistics for Natively Compiled Stored Procedure
Summary

Good to know

Know what's good
, what to watch for
, 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

Save Using Memory-optimized Tables and Native Stored Procedures to your list so you can find it easily later:
Save

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.
SAS® Programming for Distributed Computing in SAS® Viya®
Most relevant
Automate Data Workflows with SQL Server Stored Procedures
Most relevant
Programming SQL Server Database Stored Procedures
Most relevant
Troubleshooting SQL Server Performance with sp_WhoIsActive
Most relevant
Automating Data Cleansing in SQL Server
EssentialSQL: Stored Procedures Unpacked - Code in TSQL
Introduction to SQL and relational databases
Securing and Maintaining Stored Procedures in T-SQL
Learn Advanced T-SQL For SQL Server Administrator
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
Good to know
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 and help others discover this course.
Facebook LinkedIn X Reddit Link Email
Don't miss out
Enroll today to gain access to this course
Enroll in this course
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 - 2024 OpenCourser