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

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.
• Identify and use Oracle net services.
• Use Oracle shared services.
• Demonstrate performance monitoring.
• Perform proactive maintenance.
• Monitor and resolve lock conflicts.
• Apply backup and recovery concepts appropriately.
• Perform database backups.
• Perform database recovery.

Accountability Measures, Assessments, or Evaluation Procedures

• 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, MySQL Servery Programming, or Oracle PL/SQL
  

Industry Alignments

Oracle–  http://education.oracle.com/pls/web_prod-plq-dad/show_desc.redirect?dc=D47311&p_org_id=1001&lang=US&source_call=

Microsoft – http://www.microsoft.com/learning/

Brainbench – http://www.brainbench.com

Curriculum Resources

• Oracle Internet Academy, by Oracle
• Oracle University – http://education.oracle.com
• Career Cluster Resources for Information Technology – http://www.careerclusters.org/resources/ClusterDocuments/itdocuments/ITFinal.pdf

This Course Found In These Career Majors