Home

SQL Workshop 101

Time: Friday, April 26, 2024. 12 noon - 5 PM ET
Location: In person, 1001 Computer Lab C Hunter North

Department of Computer Science
Hunter College, City University of New York

Lecture Notes

0. Getting started with pgAdmin

1. Hello world in SQL and SQL style guide

2. SELECT, LIMIT, and aliasing with AS

3. SQL functions: mathematical and string functions

4. SQL data types

5. SQL functions: datetime, data type conversion, and aggregation functions

6. SQL conditionals

7. Filtering with WHERE conditions

8. De-duplicate with DISTINCT

9. Aggregation with GROUP BY

10. Filtering with HAVING conditions

11. Sorting with ORDER BY

12. In class lab via Hackerrank