Session Description

In the SQL Query Beginning/Intermediate session, participants will build a strong foundation in SQL and progress into intermediate techniques that improve reporting, analysis, and performance. Starting with core query structure and essential commands (including SELECT and data manipulation statements), the session expands into more powerful tools such as joins, subqueries, variables, case statements, and advanced aggregation methods. This course is especially valuable for users who support reporting and data needs and for DBAs with SQL Server access who want to strengthen their ability to write efficient, reliable queries.    


Session Content

In this session, participants will: 

  • Summarize the structure of SQL statements and identify key components within queries. 
  • Demonstrate the ability to construct and execute queries to retrieve and manipulate data (SELECT, UPDATE, INSERT, DELETE). 
  • Explain and apply joins to link data across multiple tables, including dual-table query concepts. 
  • Recognize when to use subqueries, variables, and case statements to solve more complex reporting needs. 
  • Describe the purpose and implementation of ROLLUP and aggregate window functions to enhance query results. 
  • Discuss practical techniques for improving query efficiency and overall database performance using intermediate SQL skills.