CA 132 - oracle Sql Database Management

Institution:

Antelope Valley College

Subject:

Description:

3 units 4 hours weekly Advisory: Eligibility for ENGL 099, READ 099, and MATH 102, and Completion of one of the following: CA 103, CA 121, CA 131, or CIS 101. This course trains students to work with the Oracle Relational Database Management System in a client/server environment. In both lecture and lab, students will learn Structured Query Language (SQL) by using the Oracle SQL*Plus tool. Proper relational database design that enforces referential integrity will be taught using schema diagrams and entity relationship diagrams. SQL Data Manipulation Language (DML) for reporting and Data Definition Language (DDL) for database creation will be covered. Students will also learn about database security issues such as database users, roles and grants. This course helps prepare students for the SQL portion of Oracle's Exam #1Z0-001. BEFORE ENROLLING students should have used database software to create a table, enter, edit and delete records, and sort the records. It is also recommended that students understand how to save and retrieve files from local and network drives. (CSU, AVC)

Credits:

4.00

Credit Hours:

Prerequisites:

Corequisites:

Exclusions:

Level:

Instructional Type:

Lecture

Notes:

Additional Information:

Historical Version(s):

Institution Website:

www.avc.edu

Phone Number:

(661) 722-6300

Regional Accreditation:

Western Association of Schools and Colleges

Calendar System:

Semester

The Course Profile information is provided and updated by third parties including the respective institutions. While the institutions are able to update their information at any time, the information is not independently validated, and no party associated with this website can accept responsibility for its accuracy.