Session Description


“SQL Query Advanced” is a session that focuses on enhancing your SQL skills by exploring advanced techniques for writing Stored Procedures and Functions. This course will provide valuable insights into optimizing query performance through SARGable practices.  


Session Content

In this session, participants will: 

  • Recognize the benefits of using Dynamic SQL and Query Hints to enhance query performance in SQL 

  • Identify and apply advanced concepts in SQL for writing efficient and high-performing queries 

  • Summarize the tools and techniques to optimize database operations at an advanced level 

  • Discuss advanced techniques for writing Stored Procedures and Functions in SQL 

  • Describe the principles and benefits of optimizing performance through SARG practices in SQL