Week 01: Introduction to Databases & SQL Basics

SLOs for Week 01

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

Explain the purpose and importance of relational databases.
Differentiate between relational databases and other types of data storage.
Query data from a single table using SELECT statement.
Sort the result set in ascending and descending order using ORDER BY.
Filter data according to various conditions using DISTINCT, WHERE, AND, OR, LIMIT/OFFSET, BETWEEN, IN, LIKE and ILIKE, GLOB and IS NULL.
Analyze a dataset using simple queries.

Slides, videos, and application exercises

Week 01: Slides

Only people at Calvin can access the slides.

Mark Simon. (2023). Getting Started with SQL and Databases : Managing and Manipulating Data with SQL. Apress. - Chapters 1, 2 and 3

Homework 01

Instructions

Project 01

Instructions

---
title: "Week 01: Introduction to Databases & SQL Basics"
# draft: true
# draft-mode: visible
---

## SLOs for Week 01

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

1.  Explain the purpose and importance of relational databases.
2.  Differentiate between relational databases and other types of data storage.
3.  Query data from a single table using `SELECT` statement.
4.  Sort the result set in ascending and descending order using `ORDER BY`.
5.  Filter data according to various conditions using `DISTINCT`, `WHERE`, `AND`, `OR`, `LIMIT/OFFSET`, `BETWEEN`, `IN`, `LIKE` and `ILIKE`, `GLOB` and `IS NULL`.
6.  Analyze a dataset using simple queries.

#### 

## Slides, videos, and application exercises

::::: slide-deck
**Week 01: Slides**

Only people at Calvin can access the slides.

::: slides
[Slides](https://calvincollege-my.sharepoint.com/:p:/g/personal/ea47_calvin_edu/Ed4i8gUmZMdPlhcFrXyUilsBnIxoMmYw0g0K3M1ifQR6aw?e=Adrz4w){target="_blank"}
:::

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

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

<!-- ## Homework assignments -->

:::: homework
**Homework 01**

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

::::

<!-- ## Lab -->

:::: lab
**Project 01**

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