TECHNICAL WORKSHOP SERIES: Advanced SQL Server Techniques by Atefeh Gilvari

Friday, November 17, 2023 - 14:30

School of Computer Science

Technical Workshop SeriesAdvanced 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