CA 133 - oracle Pl/ Sql Programming

Institution:

Antelope Valley College

Subject:

Description:

3 units 4 hours weekly Prerequisite: Completion of CA 132. Advisory: Eligibility for ENGL 099, READ 099, and MATH 102. Students will develop their Oracle Relational Database Structured Query Language (SQL) skills into writing Oracle Stored Procedures using PL/SQL in a client/server environment. In both lecture and lab, students will learn PL/ SQL Database Programming by using the Oracle SQL*Plus tool and a simple text editor. Proper structured programming design and formatting will be taught using flow diagrams and sample code. Students will refresh their knowledge of SQL Data Manipulation Language (DML) and Data Definition Language (DDL). Students will also learn how database security issues, such as database users, roles and grants, apply to the execution of PL/SQL code. This course helps prepare students for the PL/SQL portion of Oracle's Exam #1A0-001. BEFORE ENROLLING students should have used SQL to extract database records, create a table, enter, edit and delete records, sort, and group records. Students should 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.