Session Description

For Database Administrators (DBAs) with SQL Server Access. 

Intermediate SQL topics will include the Content seen below;

Session Content

  • Subqueries and how they can be utilized in place of complex joins and other purposes
  • Utilizing variables
  • The ROLLUP aggregate function
  • Window Functions using PARTITION BY
  • Case Statements
  • Other Useful Aeries SQL Queries

Related Documentation

Presentation and SQL queries used in this session are attached.