Week 02: SQL – Intermediate Concepts

SLOs for Week 02

At the end of this unit, students will be able to…

Join tables using INNER, LEFT, RIGHT, and FULL JOINs.
Understand the concepts and perform self-joins and cross joins using CROSS JOIN.
Perform complex data aggregation using GROUP BY and HAVING.
Perform set operations using UNION, UNION ALL, EXCEPT and INTERSECT. 📔 Notebook 2.4
Construct subqueries for complex queries using WHERE, IN, EXISTS.
Using CTEs to make queries more readable using WITH.
Importing data from a CSV file using .mode csv and .import.

Slides, videos, and application exercises

Week 02: Slides

Mark Simon. (2023). Getting Started with SQL and Databases : Managing and Manipulating Data with SQL. Apress. - Chapters 4, 5 and 6

Homework 02

Instructions

Project 02

Instructions

---
title: "Week 02: SQL – Intermediate Concepts"
# draft: true
# draft-mode: visible
---

## SLOs for Week 02

At the end of this unit, students will be able to...

1.  Join tables using `INNER`, `LEFT`, `RIGHT`, and `FULL JOINs`.
2.  Understand the concepts and perform self-joins and cross joins using `CROSS JOIN`.
3.  Perform complex data aggregation using `GROUP BY` and `HAVING`.
4.  Perform set operations using `UNION`, `UNION ALL`, `EXCEPT` and `INTERSECT`. [📔 Notebook 2.4](week02-04-union.ipynb)
5.  Construct subqueries for complex queries using `WHERE`, `IN`, `EXISTS`.
6.  Using CTEs to make queries more readable using `WITH`.
7.  Importing data from a CSV file using `.mode csv` and `.import`.

## Slides, videos, and application exercises

:::::: slide-deck
**Week 02: Slides**

<!-- ::: slides
[Slides](){target="_blank"}
::: -->

::: source
[Summary of the Week](/week02-summary.qmd)
:::

::: source
[Library Case Notebook](/week02-library.ipynb)
:::

::: source
[Notes for W02 Notebook](/week02-notes.ipynb)
:::

::: reading
Mark Simon. (2023). Getting Started with SQL and Databases : Managing and Manipulating Data with SQL. Apress. - [Chapters 4, 5 and 6](https://calvin.primo.exlibrisgroup.com/permalink/01CALVIN_INST/1p09kqq/cdi_skillsoft_books24x7_bks000165833){target="_blank"}
:::

::::::

<!-- ## Homework assignments -->

:::: homework
**Homework 02**

::: instructions
[Instructions](/hws/hw02.qmd)
:::

::::

<!-- ## Lab -->

:::: lab
**Project 02**

::: instructions
[Instructions](/projects/proj02.qmd)
:::

::::