CIS 147 — Query Programming
Hours: 3
Course ID: 000255
This first-level programming language course covers the fundamentals of SQL (a standard relational query and definition language). The syntax for table creation, modification, and access will be introduced. The relational database model will be emphasized using the data definition language and data manipulation language, including relational algebra (projection, selection, join, etc.). The host language interface will be used to design interactive screens and format reports.
Components: Lecture
Lecture: 3 hours.
Prerequisites: CIS 110, CIS 120 and CIS 130.