|
Course Development Guide |
|
October 1, 2007
Course Title
Database Administration
Course Description
The student will be able to perform database administration duties.
Contact
Carrie DeMuth
405-743-5426
cdemu@okcareertech.org
| OCAS Codes | OHLAP Credit | Course Length | Prerequisites |
|---|---|---|---|
|
8509
|
Yes |
120 Hours
120 hours is based on a Carnegie unit, which accounts for 175 forty-five (45) minute class periods per school year. |
Database Developer SQL & PL/SQL Database Applications Development |
Knowledge and Skills
-
Install Oracle database software.
-
Create an Oracle database.
-
Manage database interfaces.
-
Control the database.
-
Manipulate storage structures.
-
Administer users.
-
Manage schema objects and data.
-
Understand PL/SQL
-
Implement database security.
-
Understand and use Oracle net services.
-
Understand Oracle shared services.
-
Demonstrate performance monitoring.
-
Perform proactive maintenance.
-
Monitor and resolve lock conflicts.
-
Demonstrate an understanding of backup and recovery concepts.
-
Perform database backups.
-
Perform database recovery.
Oracle University - http://education.oracle.com
Brainbench - http://www.brainbench.com
Accountability Measures, Assessments, or Evaluation Procedures
Microsoft - http://www.microsoft.com/learning/
Brainbench - http://www.okcareertech.org/certify
Industry Alignments
-
Oracle (select one):
-
Oracle Certified Database Associate
-
Oracle Certified Database Professional
-
Brainbench (select one from each group):
- Group 1: Data Warehousing Concepts, Networking Concepts, or Programming Concepts
- Group 2: MySQL Administration, MySQL Server Administration, Oracle Administration, DB 2 Administration, or Sybase Administration
- Group 3: MS Access Programming, MySQL Server Programming, or Oracle PL/SQL
Curriculum Resources
-
Oracle Internet Academy, by Oracle
-
Career Cluster Resources for Information Technology - http://www.careerclusters.org/resources/ClusterDocuments/itdocuments/ITFinal.pdf