TECHNICAL WORKSHOP SERIES: Advanced SQL Server Techniques by Atefeh Gilvari

Friday, November 17, 2023 - 14:30

School of Computer Science

Technical Workshop SeriesAdvanced SQL Server Techniques

Presenter:  Atefeh Gilvari

Date: Friday, November 17th, 2:30pm -3:30 pm

Location: 4th Floor (Workshop space) at 300 Ouellette Avenue (School of Computer Science Advanced Computing Hub)


LATECOMERS WILL NOT BE ADMITTED once the presentation has begun.



This workshop explores Advanced SQL Server techniques within real-world analytics scenarios. Participants will delve into the intricacies of SQL window functions, subqueries, and Common Table Expressions (CTEs). Window functions enable advanced data analysis, subqueries facilitate complex problem-solving, and CTEs enhance query structure and readability. Attendees will gain the skills necessary to address practical data analytic challenges with confidence.


Workshop Outline:

1. Introduction to SQL SERVER

2. Advanced Analysis with Window Functions

3. Subqueries

4. Common Table Expressions (CTEs)




Knowledge of SQL Fundamentals




Atefeh is a second-year Ph.D. student specializing in deep learning-based anomaly detection with applications spanning disease prediction and IoT Augmentation Frameworks