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.
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 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. He worked first as a developer and started as a DBA in 2001, in Switzerland at MSC (Mediterranean Shipping Company). He moved to France in 2005 and is working freelance since 2006. He provides consulting, administration, audits and training. As SQL Server evolves into a more complex solution, he tries to make sure that d... more