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.
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:
Develop amd Enrty relationship diagram. Design a database the is normalized. Create tables and populate them with data. Use SQL to query a database. Define and use Views. Format reports created from database.