Home

CSCI 23200 Relational Databases and SQL

Department of Computer Science
Hunter College, City University of New York
Fall 2021 Semester

Quick Links

Lecture Notes

Lecture 25:
- In class code-along for DDL + DML via localhost Postgres SQL database(s) using PgAdmin4 - Part II
- Entity Relationship Diagrams (ERD) via PgAdmin4 and draw.io
Lecture 24:
- In class code-along for DDL + DML via localhost Postgres SQL database(s) using PgAdmin4 - Part I
Lecture 23:
- In class code-along for setting up localhost Postgres SQL database(s) using PgAdmin4 - Part II
Lecture 22:
- In class code-along for setting up localhost Postgres SQL database(s) using PgAdmin4 - Part I
Lecture 21:
- In class lab via Gradescope.
Lecture 20:
- In class lab via Gradescope.
Lecture 19:
- Finish up Subqueries and CTEs
Lecture 18:
- Subqueries and CTEs
Lecture 17:
- UNION and UNION ALL
Lecture 16:
- No new content today.
- Students will use the class time to work on the midterm project, with some instructor guidance.
Lecture 15:
- Review of lecture 14’s 2nd set breakout exercise solutions.
- In class lab via Hackerrank. See Gradescope for exercises.
Lecture 14:
- Advanced JOINs
Lecture 13:
- Intro to JOINs
Lecture 12:
- In class lab via Hackerrank. See Gradescope for exercises.
Lecture 11:
- Filtering with HAVING conditions
- Sorting with ORDER BY
Lecture 10:
- Aggregation with GROUP BY
Lecture 9:
- De-duplicate with DISTINCT
Lecture 8
- Filtering with WHERE conditions
Lecture 7
- Finish up SQL conditionals
Lecture 6
- SQL conditionals
Lecture 5
- SQL data types
- SQL functions: datetime, data type conversion, and aggregation functions
Lecture 4
- SQL functions: mathematical and string functions
Lecture 3
- SELECT, LIMIT, and aliasing with AS
Lecture 2
- Hello world in SQL
- Getting started with psql
- SQL style guide
Lecture 1
- Review the syllabus.
- Go over set up instructions.