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.
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.
1. Introduction to SQL SERVER
2. Advanced Analysis with Window Functions
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