Feb 25, 2020  
2019 - 2020 Cowley College Academic Catalog 
    
2019 - 2020 Cowley College Academic Catalog

CIS1895 INTRODUCTION TO ORACLE COURSE PROCEDURE


CIS1895 INTRODUCTION TO ORACLE

3 Credit Hours

Student Level:  

This course is open to students on the college level in either the freshman or sophomore year.

Catalog Description:

CIS1895 - Introduction to Oracle (3 hrs.)

An introductory course for students to get an overview of the Oracle database including database updates, additions, deletions, and viewing data.  Programming in PL/SQL, developing Oracle applications, and managing databases is covered. 

Course Classification:

Lecture

Prerequisites: 

Basic Computer Skills

Controlling Purpose:

This course is designed to help the student increase their knowledge concerning database updates, additions, deletions, and viewing data.  The student will learn how to write programs in PL/SQL and build Oracle applications.  In addition, the student will learn how to manage databases.

Learner Outcomes:

Upon completion of the course, the student will be able to access database data with SQL, write programs in PL/SQL, build relational schema, build applications in Oracle application express, secure database access, manage database space, protect the database and tune database instances/applications.

Unit Outcomes for Criterion Based Evaluation:

The following defines the minimum core content not including the final examination period. Instructors may add other content as time allows.

UNIT 1: Introduction to Databases and Oracle

Outcomes:  After completion of this unit, the student will have a working knowledge of the basic concepts of a database, database management systems, database applications, and Oracle.

  • Explain information management with databases
  • Explain the components of Oracle: databases, instances, tables, SQL, data access, database users, sessions, SQL *Plus, Oracle Application Express
  • List the requirements for the database server system
  • Use basic Oracle XE skills

UNIT 2: Accessing Database Data with SQL

Outcomes:  After completion of this unit, the student will have a working knowledge of the basic concepts of how applications use SQL statements and encompassing transactions to interact with an Oracle database system.

  • Explain the role of SQL
  • Retrieve data with queries
  • Insert, update, and delete rows in tables
  • Commit and roll back transactions
  • Explain transaction design
  • Build SQL with Oracle Application Express

UNIT 3: Database Access Programs with PL/SQL

Outcomes:  After completion of this unit, the student will have a working knowledge of Oracle’s procedural language, PL/SQL, which can be used to program an Oracle database server and associated applications.

  • Explain what is PL/SQL
  • Write PL/SQL blocks
  • Write PL/SQL programs using variables, program flow, interaction with databases, subprograms, record types, cursors, %TYPE and %ROWTYPE attributes, collections, and exception handling
  • Write anonymous PL/SQL blocks
  • Write stored procedures and functions
  • Declare and use a package
  • Create and use database triggers

UNIT 4: Basic Relational Scheme

Outcomes:  After completion of this unit, the student will have a working knowledge of Oracle database objects and the logical concepts of database objects.

  • Describe schemas
  • Describe database tables columns and datatypes
  • Describe data integrity and integrity constraints
  • Create and modify tables and integrity constraints
  • Create views
  • Create and use sequences
  • Create synonyms
  • Create normal indexes
  • Explain the data dictionary
  • Explore other object browser features

UNIT 5: Oracle Application Express

Outcomes: After completion of this unit, the student will have a working knowledge of how to quickly design, build, test, and deploy a simple database application from start to finish using the Oracle application express application development environment.

  • Explain the application development lifecycle
  • Describe software modeling and the unified modeling language
  • Build the application schema
  • Load schema data
  • Create an application(s)
  • Run and test application(s)
  • Refine an application(s)
  • Maintain application(s)
  • Deploy application(s)
  • Manage application access and application users

UNIT 6: Securing Database Access

Outcomes: After completion of this unit, the student will have a working knowledge of the various security features of Oracle XE that can be used to control user access to an Oracle database and Oracle application express applications.

  • Perform user management
  • Perform privilege management
  • Monitor resources and manage limits
  • Display security information

UNIT 7: Manage Database Space

Outcomes:  After completion of this unit, the student will have a working knowledge of the basics for managing the following storage structures in an Oracle database: table spaces, data files, data, index, temporary, undo segments, extents, and data blocks.

  • Explain logical vs. physical storage structures
  • Create and manage permanent table spaces and data files
  • Manage storage for tables and indexes
  • Manage undo table spaces and retention times
  • Manage temporary table spaces

UNIT 8: Protecting the Database

Outcomes: After completion of this unit, the student will have a working knowledge of the database backup and recovery mechanisms of Oracle XE that can be used to protect and repair a database.

  • List database problems and solutions
  • Explain Oracle database backup and recovery
  • Configure Oracle XE database protection
  • Back up databases with recovery manager
  • List and explain database backup and recovery options
  • Recover databases from problems
  • Use Oracle flashback features

UNIT 9: Tune Application and Database Instance Performance

Outcomes: After completion of this unit, the student will have a working knowledge of performance tuning for an Oracle database application system.

  • Explain Oracle tuning concepts
  • Explain tuning statistics
  • Tune applications and SQL
  • Tune database instances

Projects Required: 

Various database projects.

Textbook:

Contact Bookstore for current textbook.

Materials/Equipment Required: 

None

Attendance Policy:

Students should adhere to the attendance policy outlined by the instructor in the course syllabus.

Grading Policy:

The grading policy will be outlined by the instructor in the course syllabus.

Maximum class size: 

Based on classroom occupancy.

Course Timeframe:  

The U.S. Department of Education, Higher Learning Commission and the Kansas Board of Regents define credit hour and have specific regulations that the college must follow when developing, teaching and assessing the educational aspects of the college. A credit hour is an amount of work represented in intended learning outcomes and verified by evidence of student achievement that is an institutionally-established equivalency that reasonably approximates not less than one hour of classroom or direct faculty instruction and a minimum of two hours of out-of-class student work for approximately fifteen weeks for one semester hour of credit or an equivalent amount of work over a different amount of time. The number of semester hours of credit allowed for each distance education or blended hybrid courses shall be assigned by the college based on the amount of time needed to achieve the same course outcomes in a purely face-to-face format.

Refer to the following policies:

402.00 Academic Code of Conduct

263.00 Student Appeal of Course Grades

403.00 Student Code of Conduct

Disability Services Program:

Cowley College, in recognition of state and federal laws, will accommodate a student with a documented disability.  If a student has a disability, which may impact work in this class, which requires accommodations, contact the Disability Services Coordinator.