Thursday, February 15, 2024 - 13:30 to 14:30
The School of Computer Science at the University of Windsor Presents....
UNRAVELLING DATABASE COMPLEXITY
Presenter: Atefeh Gilvari
Date: Thursday, February 15th 2024
Time: 1:30 pm – 2:30 pm
Location: 4th Floor (Workshop space) at 300 Ouellette Avenue (School of Computer Science Advanced Computing Hub)
Abstract:
This workshop covers a concise recap of previous concepts, hands-on subquery practice, an introduction to Common Table Expressions (CTEs) in SQL, and an exploration of the usage of temporary tables. Participants will strengthen their SQL skills through practical exercises and real-world applications of these fundamental database concepts.
This workshop covers a concise recap of previous concepts, hands-on subquery practice, an introduction to Common Table Expressions (CTEs) in SQL, and an exploration of the usage of temporary tables. Participants will strengthen their SQL skills through practical exercises and real-world applications of these fundamental database concepts.
Workshop Outline:
- 1. Brief Recap of Previous Workshop
- 2. Hands-On Practice With Subqueries
- 3. Introduction to Common Table Expressions
- 4. Exploring Temporary Tables in SQL
Prerequisites:
Basic SQL Knowledge
Biography:
Atefeh is a second-year Ph.D. candidate at the University of Windsor, bringing four years of practical experience in both working with and teaching SQL Server.