TECHNICAL WORKSHOP SERIES: Unraveling Database Complexity: Subqueries and Common Table Expressions (CTEs) by Atefeh Gilvari

Thursday, November 30, 2023 - 14:00

School of Computer Science

 

Technical Workshop SeriesUnraveling Database Complexity: Subqueries and Common Table Expressions (CTEs)

Presenter:  Atefeh Gilvari

Date: Thursday, November 30th, 2023 - 2:00pm - 3:00pm

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: 

Subqueries are embedded queries within a main SQL statement, used for tasks like filtering, calculations, or comparisons. They offer a modular approach to problem-solving, breaking down complex queries into more manageable components. CTEs provide a structured way to define temporary result sets in SQL using the WITH clause. They enhance code readability and maintainability by allowing the creation of named, reusable result sets, particularly beneficial for recursive queries and modularizing complex SQL statements.
 

Workshop Outline:

1.subqueries

2.CTEs

 

Prerequisites:

Basic SQL

 

Biography: 

Atefeh is currently studying in her second year of the PhD program in computer science.