CCIS2751 Oracle SQL and PL/SQL (Deleted - Decemeber 2020)
This course offers students an extensive introduction to data server technology. The class covers the concepts of relational databases and the powerful SQL and PL/SQL programming languages. Students are taught to create and maintain database objects and to store, retrieve, and manipulate data.
Course Requirements and Evaluation
Refer to Course Syllabus for detailed information regarding the requirements and evaluation standards for this course. The Course Syllabus will be distributed the first week of the course.
Learning Outcomes
The following outcomes will be addressed in the course:
Utilize Oracle database tools
Retrieve data using SQL
Retrieve data from multiple data sources
Use aggregate functions
Use analytical functions
Manipulate the database using DML, DDL, and DCL
Create basic procedural PL/SQL blocks
Retrieve data in a PL/SQL block using cursors
Control error handling using exceptions
Centralize related logic using packages
Embed PL/SQL logic into tables using triggers
Create a web interface for an Oracle database using XE
Control multiple instances of data using collections
Text and References
A list of textbooks required for this course is available at the
bookstore.
Course Scheduling
The scheduled hours of instruction include sixteen hours for each lecture credit, thirty two hours for each lab credit and forty hours for each credit of supervised occupational experience (SOE). Lecture credit may include formal or impromptu lectures, demonstrations or discussions with the entire class or with small groups or individuals. Refer to the Credit Details section of this course outline for the credit breakdown.
Accommodations Statement
Disability Services assists students with disabilities who need accommodations to access programs, services and college activities. If this applies to you, please contact the DS Office on your campus to initiate the accommodations process.
Brooklyn Park Campus - 763-488-2477
Eden Prairie Campus – 952-995-1544
Campus
Brooklyn Park Campus and Eden Prairie Campus: 952-995-1300
Credit Details