CIS1895 INTRODUCTION TO ORACLE
3 Credit Hours
This course is open to students on the college level in either the freshman or sophomore year.
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.
Basic Computer Skills
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.
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
Various database projects.
Contact Bookstore for current textbook.
Students should adhere to the attendance policy outlined by the instructor in the course syllabus.
The grading policy will be outlined by the instructor in the course syllabus.
Maximum class size:
Based on classroom occupancy.
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.