CS 275 Database Systems: SQL & Oracle

Introduces the design, purpose, and maintenance of a database system. Covers the entity-relationship (ER) model, relational systems, data definition, data manipulation, query language (SQL) and the Oracle and Access database management environments.

Credits

Prerequisite

Prerequisite: CS 161 Introduction to Computer Science I (Java) with a grade of C or better.

Offered

Offered Winter only

Notes

Lower Division Transfer (LDT) Course

General Education Requirements

Computer Competency

Outcomes

Upon successful completion of this course, students will be able to:

Describe and explain a select list of common database management system terms. Design and produce relational database models using entity relationship diagrams, integrity rules and normalization. Write structure query language (SQL) statements to select, update and delete records. Write SQL statements to create, modify and drop tables. Write SQL statements that use joins and set operators with multiple tables.