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.