School of Computer Science
Technical Workshop Series: Advanced 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.
Abstract:
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)
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