TECHNICAL WORKSHOP SERIES - Advanced SQL Server Techniques - Part 1 (1st Offering) by: Atefeh Gilvari

Friday, June 14, 2024 - 13:00

Technical Workshop Series

Advanced SQL Server Techniques - Part 1 (1st Offering)

Presenter: Atefeh Gilvari

Date: Friday, June 14th, 2024

Time: 1:00 pm

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


This is a 2-part workshop. Please ensure you can attend both parts before registering (Part 2 will be held on Friday, July 5th, 2024 @ 1:00 pm). If you are registered for Part 1 (1st Offering), you will be automatically registered for Part 2 (1st Offering).


This is a hands-on workshop; it is recommended that you bring your laptop.



This workshop explores Advanced SQL Server techniques within real-world analytics scenarios. Participants will delve into the intricacies of docker, SQL window functions, ranking data, and time travelling through data. Attendees will gain the skills necessary to confidently address practical data analytics challenges.

Workshop Outline:

1. Introduction to SQL SERVER and installation

2. Advanced Analysis with Window Functions

3. Ranking Data functions

4. Time-traveling methods



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.


MAC STUDENTS ONLY - Register here