2015 – 2016
Florida Department of Education
Curriculum Framework 

Program Title:	Oracle Certified Administrator
Career Cluster:	Information Technology

CCC	
CIP Number	0511020312	
Program Type	College Credit Certificate (CCC)	
Program Length	33 credit hours	
CTSO	Phi Beta Lambda, BPA	
SOC Codes (all applicable) 	15-1141 – Database Administrators	
CTE Program Resources 	http://www.fldoe.org/academics/career-adult-edu/career-tech-edu/program-resources.stml	

Purpose

This certificate program is part of the Database Technology AS degree program (1511010306).

A College Credit Certificate consists of a program of instruction of less than sixty (60) credits of college-level courses, which is part of an AS or AAS degree program and prepares students for entry into employment (Rule 6A-14.030, F.A.C.).

This program offers a sequence of courses that provides coherent and rigorous content aligned with challenging academic standards and relevant technical knowledge and skills needed to prepare for further education and careers in the Information Technology career cluster; provides technical skill proficiency, and includes competency-based applied learning that contributes to the academic knowledge, higher-order reasoning and problem-solving skills, work attitudes, general employability skills, technical skills, and occupation-specific skills, and knowledge of all aspects of the Information Technology career cluster. 

The content includes but is not limited to database systems, software, management, and administration of databases.

Additional Information relevant to this Career and Technical Education (CTE) program is provided at the end of this document.

Standards

After successfully completing this program, the student will be able to perform the following:

01.0	Demonstrate proficiency in developing and operating a database.
02.0	Demonstrate proficiency in manipulating a database and creating tables and data structures.
03.0	Demonstrate proficiency in identifying the server physical and logical architecture.
04.0	Demonstrate proficiency in implementing and planning backup and recovery for the server.
05.0	Demonstrate proficiency in implementing a Net8 configuration on a workstation and server.
06.0	Demonstrate proficiency in tuning a server.
07.0	Demonstrate proficiency in implementing database security.

2015 – 2016
Florida Department of Education
Student Performance Standards

Program Title:	Oracle Certified Administrator
CIP Number:		0511020312
Program Length:	33 credit hours
SOC Code(s):		15-1141

This certificate program is part of the Database Technology AS degree program (1511010306).  At the completion of this program, the student will be able to:	
01.0	Demonstrate proficiency in developing and operating a database. – The student will be able to:	
01.01	Build a relational database.	
01.02	Query, display, and format data.	
01.03	Save, retrieve, and run queries.	
01.04	Build and format reports.	
01.05	Group and summarize data.	
02.0	Demonstrate proficiency in manipulating a database and creating tables and data structures. – The student will be able to:	
02.01	Insert, update, automatically generate, and delete data.	
02.02	Control transaction processing.	
02.03	Create, confirm, modify and remove tables to store data.	
02.04	Apply business rules to ensure data integrity.	
02.05	Restrict user access to tables.	
02.06	Improve query performance.	
03.0	Demonstrate proficiency in identifying the server physical and logical architecture. – The student will be able to:	
03.01	Identify and define the server architecture.	
03.02	Identify and utilize the functions and processes of the server.	
03.03	Create a database and construct the base data dictionary.	
03.04	Start up and shut down a database and instance.	
04.0	Demonstrate proficiency in implementing and backup and recovery planning and backup of a server. – The student will be able to:	
04.01	Identifying backup and recovery techniques.	
04.02	Define architecture implications for backup and recovery.	
04.03	Examining various failure scenarios and determining proper recovery strategies.	
04.04	Identify methods for restoration and recovery.	
05.0	Demonstrate proficiency in implementing a Net8 configuration on the server and workstation. – The student will be able to:	
05.01	Establish a connection from the Net8 client and server using connection methods.	
05.02	Implement troubleshooting strategies for the networking environment.	
05.03	Explain security features in networking products.	
05.04	Identify network problems using log and trace files.	
05.05	Set logging and tracing parameters.	
05.06	Start and stop the intelligent agent using the listener control utility.	
05.07	Identify the configuration files used to define the intelligent agent.	
06.0	Demonstrate proficiency in tuning a server. – The student will be able to:	
06.01	Explain the nature of server tuning.	
06.02	Outline the tuning methodology.	
06.03	List and define available diagnostic tools.	
06.04	Run the UTLBSTAT/UTLESTAT utility.	
06.05	Exam latch contention.	
06.06	Diagnose inappropriate use of the SYSTEM and TEMP tablespaces.	
06.07	Ensure that files are distributed to minimize 1/0 contention.	
07.0	Demonstrate proficiency in implementing database security. – The student will be able to:	
07.01	Demonstrate an understanding of essential database security.	
07.02	Set up and administer users and groups.	
07.03	Use appropriate procedures to secure database resources.	

Additional Information

Laboratory Activities

Laboratory investigations that include scientific inquiry, research, measurement, problem solving, emerging technologies, tools and equipment, as well as, experimental, quality, and safety procedures are an integral part of this career and technical program/course. Laboratory investigations benefit all students by developing an understanding of the complexity and ambiguity of empirical work, as well as the skills required to manage, operate, calibrate and troubleshoot equipment/tools used to make observations. Students understand measurement error; and have the skills to aggregate, interpret, and present the resulting data. Equipment and supplies should be provided to enhance hands-on experiences for students.

Career and Technical Student Organization (CTSO)

Phi Beta Lambda and Business Professionals of America (BPA) are the intercurricular career and technical student organizations providing leadership training and reinforcing specific career and technical skills.  Career and Technical Student Organizations provide activities for students as an integral part of the instruction offered.  The activities of such organizations are defined as part of the curriculum in accordance with Rule 6A-6.065, F.A.C.

Accommodations

Federal and state legislation requires the provision of accommodations for students with disabilities to meet individual needs and ensure equal access. Postsecondary students with disabilities must self-identify, present documentation, request accommodations if needed, and develop a plan with their counselor and/or instructors. Accommodations received in postsecondary education may differ from those received in secondary education. Accommodations change the way the student is instructed. Students with disabilities may need accommodations in such areas as instructional methods and materials, assignments and assessments, time demands and schedules, learning environment, assistive technology and special communication systems. Documentation of the accommodations requested and provided should be maintained in a confidential file.

Additional Resources

For additional information regarding articulation agreements, Bright Futures Scholarships, Fine Arts/Practical Arts Credit and Equivalent Mathematics and Equally Rigorous Science Courses please refer to:
http://www.fldoe.org/academics/career-adult-edu/career-tech-edu/program-resources.stml