Session Description

“SQL Query Intermediate” is designed for Database Administrators (DBAs) with SQL Server Access. Participants will delve into intermediate SQL topics to enhance their query skills.   

Session Content

In this session, participant will:  

  • Recognize the purpose and benefits of using joins, subqueries, and variables in SQL queries 

  • Summarize the function and implementation of ROLLUP and aggregate window functions in SQL 

  • Describe the usage and impact of case statements in SQL queries 

  • Discuss techniques for optimizing database performance through intermediate SQL query skills 

  • Explain the relevance of intermediate SQL query skills for database administrators in enhancing their role and responsibilities