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.
Abstract:
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
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.