ORACLE SQL AND PL/SQL

  • Program: Information Technology/Computer Careers
  • Course: Oracle SQL and PL/SQL
  • Course #: CCIS2751
  • Total Credits: 4

Course Description

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 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.

Disability Services

Hennepin Technical College offers reasonable accommodations to qualified students with disabilities. If you have a documented disability that may require accommodations, contact the college’s Disability Services Director: Sara Laviolette at Brooklyn Park (763-488-2477) or Jean Kreutter at Eden Prairie (952-995-1544).

Course Goals

The following goals 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

Credit Details
  • Lecture: 4
  • MnTC Goal: 0
Course Details
  • Prerequisites:  CCIS2701
  • Campus: Brooklyn Park/Eden Prairie

Apply Now Search Awards Search Courses