For Database Administrators (DBAs) with SQL Server Access.
Intermediate SQL topics will include the Content seen below;
- 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
Presentation and SQL queries used in this session are attached.