Technical Workshop " Advanced SQL Server Techniques" By: Atefeh Gilvari

Thursday, February 1, 2024 - 16:00 to 17:00

Advanced SQL Server Techniques
Presenter: Atefeh Gilvari


Date: Thursday, February 1st 2024
Time: 4:00 pm – 5:00 pm
Location: 4th Floor (Workshop space) at 300 Ouellette Avenue (School of Computer Science Advanced Computing Hub)


Abstract:
This workshop explores Advanced SQL Server techniques within the context of real-world analytics scenarios. Participants will delve into the intricacies of docker, SQL window functions, Ranking data, time traveling through data. Attendees will gain the skills necessary to address practical data analytics challenges with confidence.


Workshop Outline:

  • 1. introduction to SQL SERVER and installation
  • 2. Advanced Analysis with Window Functions
  • 3. Ranking Data functions
  • 4. Time-traveling methods
Prerequisites:

Knowledge of SQL Fundamentals

Biography:

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