Path icon Learning Paths
Skills

Crafting Functions and Procedures in SQL Server

  • Number of Courses5 courses
  • Duration2 hours

This learning path is aimed at developers and database administrators who want to build expertise in creating, managing, and optimizing functions and stored procedures within SQL Server. Starting with the fundamentals of SQL Server functions, learners will go through the construction of their first functions, and then advance to complex scenarios that focus on performance and practical application. The path also helps learners master stored procedures, emphasizing optimization techniques, best practices for performance enhancement, and strategies for seamlessly integrating functions and procedures into SQL Server workflows.

Courses in this path

Crafting Functions and Procedures in SQL Server

Watch the following courses to get started.

SQL Server Functions Fundamentals: Building Your First Functions

  • by Ben Weissman
  • 20m Duration

Advanced Functions in SQL Server: Performance and Practicality

  • by Rudi Bruchez
  • 35m Duration

Mastering Stored Procedures in SQL Server

  • by Nikola Ilic
  • 30m Duration
  •  (16)

Optimizing SQL Server Procedures: Best Practices and Performance

  • by Nikola Ilic
  • 33m Duration
  •  (13)

Integrating Functions and Procedures in SQL Server Workflows

  • by Gerald Britton
  • 30m Duration

Learn with the best

Ben Weissman
Ben Weissman
Ben Weissman, a Microsoft Data Platform MVP, has been working with SQL Server since SQL Server 6.5, mainly in the BI/Datawarehousing field. Besides his Pluralsight courses, Ben is also the co-author of multiple books on data and kubernetes including "SQL Server on Kubernetes ", "Azure Arc-enabled Data Services", "SQL Server Big Data Clusters" and "The Biml Book". He is also a regular speaker at international events. Ben and his team at Solisyon have been involved in more than 200 Business I... more
Rudi Bruchez
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. 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
Nikola Ilic
Nikola Ilic
Nikola Ilic is an officially Business Intelligence Developer, focusing on Microsoft Data Platform technologies, especially Power BI - but “off the record” he is a data fanatic, interested in everything related to extracting meaningful information from the raw data. Nikola is self-proclaimed "Data-Mozart". As he lives in the wonderful city of Salzburg, Austria, which is well-known as the birthplace of W.A.Mozart, he was brave enough to use the composer's last name as part of his nickname. That'... more
Gerald Britton
Gerald Britton
Gerald Britton is a Pluralsight author and expert on Python programming practices and Microsoft SQL Server development and administration.  A multiple-year of the Microsoft MVP award, Gerald has led introductory classes in Python and SQL for industry-sponsored events at Ryerson University, Toronto and the University of Toronto (his alma mater). 

Join our learners and upskill
in leading technologies