CSC 256 - SQL Programming
- Instructor:
- Dr. Dylan Schwesinger
- Location:
- OM 158
- Meeting times:
- Section 010: Monday, Wednesday, and Friday 12:00pm – 12:50pm
- Office hours:
- Monday, Wednesday and Friday: 10:00am – 11:00am
Tuesday & Thursday: 8:00am – 9:00am - Office hours Zoom meeting ID:
- 732 788 237
Course Description
The Structured Query Language (SQL) is the standard programming language used to create, modify, and query relational databases. The purpose of this course is to provide a comprehensive coverage of the SQL language.
Prerequisite: CSC 125 or MAT 224.
Course Information
Tentative Schedule
| Week | Topics |
|---|---|
| 1 | Overview |
| 2 - 3 | Query Fundamentals |
| 4 | Aggregate Functions |
| 5 | Data Types |
| 6 - 7 | Joins |
| 8 | Subqueries |
| 9 | Window Functions |
| 10 | Creating Tables and Constraints |
| 11 | Data Manipulation and Transactions |
| 12 | Views and Functions |
| 13 | Query Performance |
| 14 | Access Control |
| 15 | Additional Topics |