Featured resource
pluralsight tech forecast
2025 Tech Forecast

Which technologies will dominate in 2025? And what skills do you need to keep up?

Check it out
Hamburger Icon
  • Course
    • Libraries: If you want this course, consider one of these libraries.
    • Data

Advanced Functions in SQL Server: Performance and Practicality

Master advanced SQL Server functions for data manipulation and performance tuning. Learn through real-world scenarios to optimize database efficiency and solve common data problems.

Rudi Bruchez - Pluralsight course - Advanced Functions in SQL Server: Performance and Practicality
by Rudi Bruchez

What you'll learn

Businesses and organizations must manage and analyze vast amounts of data efficiently in today's data-driven world. Slow query responses and inefficient data handling can significantly impact your business. In this course, Advanced Functions in SQL Server: Performance and Practicality, you'll learn to optimize database performance through advanced SQL Server functions. First, you'll learn how to write user-defined functions for advanced data manipulation, including scalar, table-valued, multi-statement functions, as well as writing clean, efficient, and reusable code. Next, you’ll discover techniques for optimizing these functions' performance, particularly in large databases. Finally, you’ll learn how to differentiate between deterministic and nondeterministic functions, identify and avoid common pitfalls in function usage, and apply functions for efficient data manipulation and analysis in real-world scenarios. When you’re finished with this course, you’ll have the skills and knowledge of advanced SQL Server functions needed to design, implement, and optimize complex functions, improving data retrieval speeds, report generation, and overall database efficiency.

Table of contents

About the author

Rudi Bruchez - Pluralsight course - Advanced Functions in SQL Server: Performance and Practicality
Rudi Bruchez

Rudi Bruchez is a freelance consultant and trainer based in Paris, France. He has more than 15 years of experience with SQL Server and started to venture into NoSQL territories. As SGBD evolve into more complex solutions, he tries to make sure that people understand the fundamentals and implement their databases wisely.

More Courses by Rudi