2017 – 2018
Florida Department of Education
Curriculum Framework 

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

CCC	
CIP Number	0511020307	
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 an understanding of the Oracle architectural components.
02.0	Demonstrate how to create an Oracle database instance.
03.0	Demonstrate how to manage an instance of the database.
04.0	Demonstrate how to maintain Redo log files, and how to use the data dictionary views.
05.0	Demonstrate how to manage tablespaces and datafiles.
06.0	Demonstrate an understanding of the Oracle storage structures.
07.0	Demonstrate the ability to query a database.
08.0	Demonstrate how to manage constraints and indexes.
09.0	Demonstrate a basic understanding of the Oracle Recovery Manager tool for performing backup and recovery operations.
10.0	Demonstrate the ability to perform backups.
11.0	Demonstrate the ability to perform recovery procedures.
12.0	Demonstrate how to configure and use a Flashback Database.
13.0	Demonstrate the different methods that are used to recover from user errors.
14.0	Demonstrate an understanding of how to detect and resolve block corruptions.
15.0	Demonstrate an understanding of the goals and processes of performance tuning.
16.0	Demonstrate capability to use the Oracle Database Resource Manager (DRM) to manage database and operating system performance.
17.0	Demonstrate how to automate management tasks, create scheduled jobs, programs, and schedules.
18.0	Demonstrate the ability to efficiently manage space-related inefficiencies of the database.
19.0	Demonstrate the ability to understand the issues with memory management and shall demonstrate how to configure memory manually.
20.0	Demonstrate the ability to set up an Oracle database to be deployed globally.
21.0	Demonstrate the ability to use Oracle diagnostic tools and the Oracle listener.

2017 – 2018
Florida Department of Education
Student Performance Standards

Program Title:	Oracle Certified Database Administrator
CIP Number:		0511020307
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 an understanding of the Oracle architectural components. The student will be able to:	
01.01	Define an Oracle Database, the Oracle server, and the Oracle Instance, and Oracle database memory architecture. 	
01.02	Explain the differences between Oracle 10g client and server installation. 	
01.03	Use the Oracle Universal Installer to install Oracle on a host machine. 	
01.04	Establish a connection and creating a session to the database instance. 	
01.05	Explain the physical structure, memory structure, and process structure of the Oracle database.	
02.0	Demonstrate how to create an Oracle database instance. The student will be able to:	
02.01	Explain the steps needed to create a database. 	
02.02	Identify the database administrative tools. 	
02.03	Configure the initial settings for creating the database. 	
02.04	Create, start, and stop a database instance. 	
02.05	Explain the basic steps in managing the configuration parameter files, and using Net Manager to configure Oracle Net Services.	
03.0	Demonstrate how to manage an instance of the database. The student will be able to:	
03.01	Create, manage, and use the initialization files: PFILE and SPFILE. 	
03.02	Identify the various states of starting an instance. 	
03.03	Identify the various options available to shutdown an instance. 	
03.04	Monitor the Alert and Trace files.	
04.0	Demonstrate how to maintain Redo log files, and how to use the data dictionary views. The student will be able to:	
04.01	Explain how the control file, data files, redo log files, and archive files are linked and work together. 	
04.02	Explain the uses of the control file. 	
04.03	List the contents of the control file. 	
04.04	Maintain and manage the online redo log files. 	
04.05	Obtain and archive online redo log file information 	
04.06	Use the Oracle Managed Files (OMF) to create, manage, and obtain information from the control files. 	
04.07	Identify the use and contents of the data dictionary. 	
04.08	Use the data dictionary to retrieve information about the database.	
05.0	Demonstrate how to manage tablespaces and datafiles. The student will be able to:	
05.01	Describe the storage hierarchy. 	
05.02	Differentiate between the logical and physical structures. 	
05.03	Create many types of tablespaces. 	
05.04	Configure and viewing storage for tablespaces and datafiles. 	
05.05	Use and managing undo data. 	
05.06	Describe and configuring diagnostic (trace) files.	
06.0	Demonstrate an understanding of the Oracle storage structures. The student will be able to:	
06.01	Describe and differentiating between the logical and physical structure of the database (segments, extents, blocks). 	
06.02	List the segment types and their uses. 	
06.03	Maintain storage structures with automatic segment – space management. 	
06.04	Maintain storage structures manually. 	
06.05	Obtain storage structure information.	
07.0	Demonstrate the ability to query a database. The student will be able to:	
07.01	Write basic SQL single row, datatype conversion, group, and user-defined functions. 	
07.02	Write filtered, sorted, and aggregated queries. 	
07.03	Write SQL statements using advanced queries involving joins, subqueries, and other specialized queries.	
08.0	Demonstrate how to manage constraints and indexes. The student will be able to:	
08.01	List the different types of indexes, their uses, and constraints. 	
08.02	Develop an example of each type of index. 	
08.03	Create index-organized tables. 	
08.04	Create, modify, and drop constraints 	
08.05	Maintain indexes. 	
08.06	Identify unused indexes.	
09.0	Demonstrate a basic understanding of the Oracle Recovery Manager tool for performing backup and recovery operations. The student will be able to:	
09.01	Explain the different backup options available to the database administrator. 	
09.02	Describe the Recovery Manager architecture. 	
09.03	Start RMAN to connect to the database. 	
09.04	Describe the different settings used to configure the persistent RMAN parameters.	
10.0	Demonstrate the ability to perform backups. The student will be able to:	
10.01	Explain the purpose of the Flash Recovery area. 	
10.02	Describe the various types of backups. 	
10.03	Perform block-level backups. 	
10.04	Implement the commands for performing backups at various levels. 	
10.05	Demonstrate the use of the RUN command. 	
10.06	Set Duration and Throttling. 	
10.07	Explain the Block Tracking feature. 	
10.08	Use RMAN commands to display information about backups.	
11.0	Demonstrate the ability to perform recovery procedures. The student will be able to:	
11.01	Identify the different types of failures that occur in the database. 	
11.02	Perform a complete recovery on a database. 	
11.03	Perform an incomplete recovery on a database. 	
11.04	Demonstrate how to perform a recovery of non-critical files.	
12.0	Demonstrate how to configure and use a Flashback Database. The student will be able to:	
12.01	Explain the Flashback Database feature. 	
12.02	Describe the components of Flashback Database. 	
12.03	Explain the guidelines and restrictions of Flashback Database. 	
12.04	Configure, maintain, and monitor Flashback Database. 	
12.05	Perform Flashback Database using SQL, RMAN, and Enterprise Manager. 	
12.06	Resolve errors that may occur during the Flashback Database creation operation.	
13.0	Demonstrate the different methods that are used to recover from user errors. The student will be able to:	
13.01	Describe the Flashback Technology features available in Oracle. 	
13.02	Explain the configuration and implementation of the Flashback Drop operation. 	
13.03	Manage the recycle bin. 	
13.04	Explain the configuration and implementation of the Flashback Query operation. 	
13.05	Recover from user errors using the Flashback Versions Query operation. 	
13.06	Perform transaction level recovery using Flashback Transaction Query operation. 	
13.07	Explain the configuration and implementation of the Flashback Table.	
14.0	Demonstrate an understanding of how to detect and resolve block corruptions. The student will be able to:	
14.01	Describe what block corruption is. 	
14.02	Identify instances of block corruptions. 	
14.03	Resolve block corruptions. 	
14.04	Use the ANALYZE command to check the integrity of a schema object (i.e., tables and indexes). 	
14.05	Describe the use of the DBVERIFY utility. 	
14.06	Utilize the DB_BLOCK_CHECKING parameter. 	
14.07	Execute the DBMS_REPAIR package. 	
14.08	Perform Block Media recovery using RMAN.	
15.0	Demonstrate an understanding of the goals and processes of performance tuning. The student will be able to:	
15.01	Describe the job roles in performance tuning. 	
15.02	List the steps in the tuning phases. 	
15.03	Explain tuning goals and service level agreements. 	
15.04	Describe common performance problems. 	
15.05	Explain the tuning methodology.	
16.0	Demonstrate how to use the Oracle Database Resource Manager (DRM) to manage database and operating system performance. The student will be able to:	
16.01	Explain the purpose of the Data Resource Manager. 	
16.02	Describe each of the components of the DRM. 	
16.03	Create consumer groups. 	
16.04	Create resource plans. 	
16.05	Create resource plan directives. 	
16.06	Use the DRM to automatically map user sessions with consumer groups. 	
16.07	Obtain information about database performance using the DRM.	
17.0	Demonstrate how to automate management tasks, create scheduled jobs, programs, and schedules. The student will be able to:	
17.01	Use the Oracle Scheduler to create jobs, programs, and schedule tasks. 	
17.02	Reuse the Scheduler to view information about job executions and job instances. 	
17.03	Use the Scheduler to perform automatic gathering of optimizer statistics. 	
17.04	Use the Scheduler to automatically gather object statistics to make efficient decisions about execution plans.	
18.0	Demonstrate the ability to efficiently manage space-related inefficiencies of the database. The student will be able to:	
18.01	Tune redo writing and archiving operations. 	
18.02	Set and modifying thresholds for space usage. 	
18.03	Manage tablespace usage to reduce space-related error conditions. 	
18.04	Use different storage options to improve the performance of queries. 	
18.05	Manage Resumable Space Allocation using the DBMS_RESUMABLE package.	
19.0	Demonstrate the ability to understand the issues with memory management and shall demonstrate how to configure memory manually. The student will be able to:	
19.01	Explain the memory structures in the Oracle instance and their function. 	
19.02	Manually configure memory structures of the System Global Area (SGA). 	
19.03	Implement Automatic Shared Memory Management. 	
19.04	Configure the SGA parameters for various memory components in the SGA manually. 	
19.05	Configure memory structures of the Program Global Area manually.	
20.0	Demonstrate the ability to set up an Oracle database to be deployed globally. The student will be able to:	
20.01	Customize language-dependent behavior for the database and individual sessions. 	
20.02	Specify different linguistic sorts for queries. 	
20.03	Use date-time data types for different time zones. 	
20.04	Query data using case-sensitive and accent-insensitive searches. 	
20.05	Obtain globalization support configuration information.	
21.0	Demonstrate the ability to use Oracle diagnostic tools and the Oracle listener. The student will be able to:	
21.01	Describe the purpose and use of the diagnostic tools that are available within the database. 	
21.02	Describe the vulnerabilities of the listener and the different methods that can be used to secure it.	

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