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.