CSC 256 - SQL Programming
- Instructor:
- Dr. Dylan Schwesinger
- Location:
- OM 158
- Meeting times:
- Section 010: Monday, Wednesday, and Friday 9:00am – 9:50am
- Office hours:
- Monday, Tuesday, Wednesday, Thursday, and Friday 12:00pm – 1:00pm
- 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: CSC120 or CSC123 or CSC135 or CSC243
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 |