Technical Workshop Series
Unravelling Database Complexity - Part 2 (2nd Offering)
Presenter: Atefeh Gilvari
Date: Monday, July 8th, 2024
Time: 2:30 pm
Location: 4th Floor (Lecture Space) at 300 Ouellette Avenue (School of Computer Science Advanced Computing Hub)
This is a hands-on workshop; students must bring laptops. This is the 2nd part of a 2-part workshop. If you previously registered for Part 1 (2nd Offering), you were automatically registered for Part 2 (2nd Offering).
Note for MAC students only: MAC students must attend both parts to get any points (no points will be given if you only attend one).
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.
Workshop Outline:
- Brief Recap of Previous Workshop
- Hands-on practice with Subqueries
- Introduction to Common Table Expressions
- 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.