Curriculum & Instruction Manual - DOC 1

							ITSE2356
Oracle Database Administration I

Database Management Technology

Total training hours per semester
96

Course Level
Advanced

Suggested Prerequisites
Oracle SQL

WECM/ACGM Course Description
Fundamentals of the tasks and functions required of a database administrator using
Oracle.

WECM/ACGM Learning Outcomes
Create an operational database using Oracle; will demonstrate the ability to create, delete,
and modify associated files, tablespaces, segments, extents, and blocks; start up and shut
down an Oracle instance and database; add, delete, and modify users, privileges, and
resources; and demonstrate use of National Language and Support (NLS) features.

Course Goals/Essence
This course focuses on the use of a Database Management System through the day-to-day
duties of a database administrator including creation, management, maintenance, and
operation of a DBMS.

Learning Outcomes

   A. Create an operational database using Oracle
      The student will:
          Create a new database instance using both manual SQL commands and
             database tools

   B. Demonstrate the ability to create, delete, and modify associated files, tablespaces,
      segments, extents, and blocks
      The student will:
          Create, delete, and modify associated files, tablespaces, segments, extents,
             and blocks

   C. Start up and shut down an Oracle instance and database
      The student will:
           Start up and shut down an Oracle instance and database
   D. Add, delete, and modify users, privileges, and resources
      The student will:
          Create, modify and drop users, privileges, and resources

   E. Demonstrate use of National Language and Support (NLS) features
      The student will:
          Demonstrate use of NLS features

   F. Discuss administrative duties necessary to manage a RDBMS
      The student will:
          Identify key components of the Oracle database architecture and
             installation options
          Use DBA tools, including the Enterprise Manager Console and the
             Database Control Interface that reflect the background processes that
             perform database operations
          Use data dictionary views to monitor database structures and activities
          Use SQL to create, modify, or remove redo log files, control files, and
             database-generated diagnostic files and understand the concepts
          Identify the physical and logical structures that make up the database
          Use SQL to create, modify, and drop many types of tables and indexes
             using additional clauses that control storage setting, LOB storage, and
             partitioning

   G. Solve problems and build employability skills such as critical thinking, reading,
      work ethic, attitude, teamwork and writing
      The student will:
          Use critical thinking skills to create database programming assignments
          Use reading skills to read technical information regarding software and
             programming solutions
          Use critical thinking skills to complete projects and assignments by due
             dates
          Use listening skills to successfully complete programming projects
          Exhibit professional principles by coming to class on time or calling in as
             required when absent
          Exhibit a positive attitude toward work and individuals
          Use writing skills to complete written assignments in an appropriate
             manner

Students may vary in their competency levels on these abilities. You can expect to acquire
these abilities only if you honor all course policies, attend classes regularly, complete all
assigned work in good faith and on time, and meet all other course expectations of you as
a student.