2018 – 2019
Florida Department of Education
Curriculum Framework 

Program Title:	Oracle Certified Database Developer
Career Cluster:	Information Technology

CCC	
CIP Number	0511020308	
Program Type	College Credit Certificate (CCC)	
Program Length	Primary:  15 credit hours; Secondary: 16 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 (1511010308).

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, programming and analysis and design 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 the use of general PL/SQL programming language fundamental constructs. 
02.0	Demonstrate the use of DML simple selection statements in a PL/SQL block.
03.0	Demonstrate the use of conditional control IF and CASE statements.
04.0	Demonstrate the use of employing iterative control loops for iterating through a set of instructions.
05.0	Demonstrate the use of incorporating exception handling methods.
06.0	Demonstrate how to manipulate cursors and use parameters with cursors and complex nested cursors.
07.0	Demonstrate how to design and implement functions and procedures.
08.0	Demonstrate how to design and implement packages and triggers.
09.0	Demonstrate the use of collections to store and manipulate data.
10.0	Demonstrate how to manipulate large objects, such as LOB and BFILEs.
11.0	Demonstrate how to tune PL/SQL code and improve performance with caching.

2018 – 2019
Florida Department of Education
Student Performance Standards

Program Title:	Oracle Certified Database Developer
CIP Number:		0511020308
Program Length:	Primary:  15 credit hours; Secondary: 16 credit hours
SOC Code(s):		15-1141

This certificate program is part of the Database Technology AS degree program (1511010308).  At the completion of this program, the student will be able to: 	
01.0	Demonstrate the use of general PL/SQL programming language fundamental constructs. The student will be able to:	
01.01	Employ PL/SQL language components including variables and identifiers.	
01.02	Make use of anchored data types.	
01.03	Explain the use of a block, nested block, and labels.	
02.0	Demonstrate the use of DML simple selection statements in a PL/SQL block.  The student will be able to:	
02.01	Use the SELECT INTO syntax for variable initialization.	
02.02	Use Data Manipulation Language statement sin a PL/SQL block.	
02.03	Make use of a sequence in a PL/SQL block.	
02.04	Make use of the COMMIT, ROLLBACK, and SAVEPOINT commands in a PL/SQL block.	
03.0	Demonstrate the use of conditional control IF and CASE statement. The student will be able to:	
03.01	Use the IF-THEN, and IF-THEN-ELSE control statements.	
03.02	Use nested IF statements.	
03.03	Use the CASE statement in a procedural block of code.	
03.04	Use a CASE expression.	
04.0	Demonstrate the use of employing iterative control loops for iterating through a set of instructions. The student will be able to:	
04.01	Use simple loops with EXIT conditions.	
04.02	Use simple loops with EXIT WHEN conditions.	
04.03	Use WHILE loops.	
04.04	Use numeric FOR loops with the IN and REVERSE option.	
05.0	Demonstrate the use of incorporating exception handling methods. The student will be able to:	
05.01	Explain the use of error handling methods.	
05.02	Use built-in exception handling mechanisms.	
05.03	Create user-defined exceptions.	
06.0	Demonstrate how to manipulate cursors and use parameters with cursors and complex nested cursors. The student will be able to:	
06.01	Utilize cursor attributes to control the memory where statements are executed.	
06.02	Process an explicit cursor.	
06.03	Use cursors to fetch rows.	
06.04	Use cursors for loops.	
06.05	Use parameters in a cursor.	
06.06	Use complex nested cursors.	
06.07	Use FOR UPDATE and WHERE CURRENT clause in a cursor.	
07.0	Demonstrate how to design and implement functions and procedures. The student will be able to:	
07.01	Create procedures.	
07.02	Query the data dictionary for information on procedures.	
07.03	Use IN and OUT parameters with procedures.	
07.04	Create stored functions.	
07.05	Invoke functions with SQL statements.	
08.0	Demonstrate how to design and implement packages and triggers. The student will be able to:	
08.01	Create package specifications.	
08.02	Create package bodies, package variables and cursors.	
08.03	Call stored packages.	
08.04	Write triggers in response to DML, DDL, system and user generated events.	
09.0	Demonstrate the use of collections to store and manipulate data. The student will be able to:	
09.01	Use associative arrays.	
09.02	Use nested tables.	
09.03	Create table-based and cursor-based records.	
09.04	Create and use user-defined records.	
10.0	Demonstrate how to manipulate large objects, such as LOB and BFILEs. The student will be able to:	
10.01	Describe a LOB object.	
10.02	Use BFILEs.	
10.03	Use DBMS_LOB.READ and DBMS_LOB.WRITE to manipulate LOBs.	
10.04	Create a temporary LOB programmatically with the DBMS_LOB package.	
10.05	Use SecureFile LOBs to store documents.	
10.06	Convert BasicFile LOBs to SecureFile LOB format.	
10.07	Enable reduplication and compression.	
11.0	Demonstrate how to tune PL/SQL code and improve performance with caching. The student will be able to:	
11.01	Describe result caching.	
11.02	Use SQL query result cache.	
11.03	Use PL/SQL function cache.	

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.  

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