2019 – 2020
Florida Department of Education
Curriculum Framework 

Program Title:	Database Technology
Career Cluster:	Information Technology

AS	
CIP Number	1511010308	
Program Type	College Credit	
Standard Length	60 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 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 such as Database Administrators and Developers Analysts 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. 

This program focuses on specific, transferable skills and stresses understanding and demonstration of the following elements of the database management and development industry: database creation, database management, database tuning, database software development, and database recovery.

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

Program Structure

This program is a planned sequence of instruction consisting of 60 credit hours.

Standards

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

01.0	Demonstrate an understanding of fundamental database concepts.
02.0	Demonstrate conceptual design principles.
03.0	Demonstrate the ability to create a database design.
04.0	Demonstrate an understanding of basic Data Definition Language and Data Manipulation Language SQL (Structured Query Language) syntax to create relational tables.
05.0	Demonstrate the ability to create, maintain, and delete sequences, indexes and synonyms and other schema objects.
06.0	Demonstrate the ability to query the database and optimize information retrieval.

In addition, students will complete the standards in one of the following specializations:

Microsoft Certified Database Administrator Specialization Standards

07.0	Demonstrate how to design and implement a data warehouse.
08.0	Demonstrate how to extract and transform data.
09.0	Demonstrate how to load data.

Oracle Certified Database Administrator Specialization Standards

10.0	Demonstrate how to create a database instance.
11.0	Demonstrate how to manage an instance of the database.
12.0	Demonstrate how to maintain Redo log files, and how to use the data dictionary views.
13.0	Demonstrate how to manage tablespaces and datafiles.
14.0	Demonstrate an understanding of database storage structures.
15.0	Demonstrate the ability to query a database.
16.0	Demonstrate how to manage constraints and indexes.
17.0	Demonstrate the ability to perform backups and recovery procedures.
18.0	Demonstrate an understanding of the goals and processes of performance tuning.
19.0	Demonstrate how to automate management tasks, create scheduled jobs, programs, and schedules.
20.0	Demonstrate the ability to efficiently manage space-related inefficiencies of the database.
21.0	Demonstrate the ability to understand a database memory management. 
22.0	Demonstrate the ability to set up a database to be deployed globally.

Oracle Certified Database Developer Specialization Standards

23.0	Demonstrate the use of general SQL programming language fundamental constructs. 
24.0	Demonstrate the use of DML simple selection statements in a SQL block.
25.0	Demonstrate the use of conditional control IF and CASE statements.
26.0	Demonstrate the use of employing iterative control loops for iterating through a set of instructions.
27.0	Demonstrate the use of incorporating exception handling methods.
28.0	Demonstrate how to design and implement functions and procedures.

2019 – 2020
Florida Department of Education
Student Performance Standards

Program Title:	Database Technology
CIP Number:		1511010308
Program Length:	60 credit hours
SOC Code(s):		15-1141

Refer to Rule 6A-14.030 (4) F.A.C., for the minimum amount of general education coursework required in the Associate of Science (AS) degree.  At the completion of this program, the student will be able to:	
01.0	Demonstrate an understanding of fundamental database concepts. – The student will be able to:	
01.01	Define data.	
01.02	Define information.	
01.03	Describe the process by which information is derived from data.	
01.04	Describe how a database is implemented.	
01.05	Distinguish between variant database models, how they differ, and the advantages to each model.	
01.06	Describe the advantages (i.e., improved data consistency, quality, integrity) and disadvantages of using databases (i.e., cost and complexity).	
01.07	Conducting online research to locate and identify the different database engines, models, and providers.	
01.08	Define and providing examples of a database transaction.	
02.0	Demonstrate conceptual design principles. – The student will be able to:	
02.01	Perform a use case analysis and determining the functional requirements from use case.	
02.02	Identify non-functional requirements that will affect a solution’s design.	
02.03	Analyze data requirements to determine data entities and attributes.	
02.04	Analyze entities and attributes to determine their relationships.	
02.05	Develop a conceptual model that captures the data flow and integrity constraints by using various components including:	
02.05.1	Base entity type.	
02.05.2	Bridging entity types.	
02.05.3	Composite attribute.	
02.05.4	Multivalued attribute.	
02.05.5	Derived attribute.	
02.05.6	Associative entity type.	
02.05.7	Relationships between entity types.	
02.05.8	Minimum and maximum cardinality constraints.	
02.05.9	Deletion rules.	
03.0	Demonstrate the ability to create a database design. – The student will be able to:	
03.01	Describe all data types (e.g., CHAR, NUMBER).	
03.02	Discuss the basic tenets of proper database design by describing the impact of:	
03.02.1	Data duplication.	
03.02.2	Data redundancy.	
03.02.3	Data integrity.	
03.02.4	Implicit information storage.	
03.02.5	Referential integrity.	
03.03	Derive candidate keys by decomposition and synthesis.	
03.04	Describe and executing the general methods of design using 3NF (third-normal form) to eliminate redundancy, partial and transitive dependencies.	
03.05	Identify the primary key foreign key relationships between the entity types.	
04.0	Demonstrate an understanding of basic Data Definition Language and Data Manipulation Language SQL (Structured Query Language) syntax to create relational tables. – The student will be able to:	
04.01	Describe the basic characteristics of the Standard Query Language.	
04.02	Write SQL statements to create simple tables.	
04.03	Create data integrity controls.	
04.04	Change/update table definitions.	
04.05	Insert, update, and delete data/records.	
04.06	Describe referential integrity and how it is enforced.	
04.07	Describe the advantages of using an index, and implementing different types of indexes on tables.	
04.08	Describe how a database implements and uses indexing (i.e., B-Tree, Bitmap).	
04.09	Verify the existence of an index using the data dictionary.	
04.10	Describe foreign keys and their use when relating tables.	
04.11	Define the purpose of a sequence and how it can be used in a database.	
04.12	Create and removing a sequence.	
05.0	Demonstrate the ability to create, maintain, and delete sequences, indexes and synonyms and other schema objects. – The student will be able to:	
05.01	Define the purpose of a sequence and how it can be used in a database.	
05.02	Create and removing a sequence.	
05.03	Create indexes and removing indexes.	
05.04	Verify the existence of an index using the data dictionary.	
06.0	Demonstrate the ability to query the database and optimize information retrieval. – The student will be able to:	
06.01	Identify the data elements by which to relate tables.	
06.02	Retrieve row and column data from tables executing simple SELECT statements.	
06.03	Identify keywords, mandatory clauses, and optional clauses in a SELECT statement.	
06.04	Use character, number, and date functions in SELECT statements.	
06.05	Create a search condition using mathematical comparison operators.	
06.06	Use the WHERE clause to restrict the rows returned by a query.	
06.07	Sort rows that are retrieved by a query, and use ampersand substitution to restrict and sort output at runtime.	
06.08	Write SELECT statements to access data from more than one table using equijoins and non-equijoins.	
06.09	Join a table to itself using a self-join.	
06.10	View data that does not meet a join condition by using outer joins.	
06.11	Generate a Cartesian product of all rows from two or more tables.	
06.12	Identify the available group functions (GROUP BY, HAVING, INTERSECT).	
06.13	Describe the use of the group functions.	
06.14	Group data by using the GROUP BY clause.	
06.15	Include or exclude grouped rows by using the HAVING clause.	
06.16	Write complex SELECT statements including the use of various JOIN, SUBQUERIES, and conditional expressions.	
06.17	Discuss when it is appropriate to use a subquery, and describing the types of problems that subqueries can solve.	
06.18	Identify which clauses can contain subqueries.	
06.19	Write single-row and multiple-row subqueries.	
06.20	Nest a subquery inside another subquery.	

Microsoft Certified Database Administrator Specialization Standards	
07.0	Demonstrate how to design and implement a data warehouse. – The student will be able to:	
07.01	Design and implement dimensions.	
07.02	Design and implement fact tables.	
08.0	 Demonstrate how to extract and transform data. – The student will be able to:	
08.01	Define connection managers.	
08.02	Design data flow.	
08.03	Implement data flow. 	
09.0	 Demonstrate how to load data. – The student will be able to:	
09.01	Design control flow.	
09.02	Implement control flow.	
09.03	Implement data load options.	

Oracle Certified Database Administrator Specialization Standards	
10.0	Demonstrate how to create a database instance. – The student will be able to:	
10.01	Explain the steps needed to create a database. 	
10.02	Identify the database administrative tools. 	
10.03	Configure the initial settings for creating the database. 	
10.04	Create, start, and stop a database instance. 	
11.0	Demonstrate how to manage an instance of the database. – The student will be able to:	
11.01	Create, manage, and use the initialization files.	
11.02	Identify the various states of starting an instance. 	
11.03	Identify the various options available to shutdown an instance. 	
12.0	Demonstrate how to maintain log files, and how to use the data dictionary views. – The student will be able to:	
12.01	Explain how the data files, log files, and archive files are linked and work together. 	
12.02	Maintain and manage the log files. 	
12.03	Obtain and archive log file information.	
12.04	Identify the use and contents of the data dictionary. 	
12.05	Use the data dictionary to retrieve information about the database.	
13.0	Demonstrate how to manage tablespaces and datafiles. – The student will be able to:	
13.01	Describe the storage hierarchy. 	
13.02	Differentiate between the logical and physical structures. 	
13.03	Create many types of tablespaces. 	
13.04	Configure and viewing storage for tablespaces and datafiles. 	
13.05	Use and managing undo data. 	
13.06	Describe and configuring diagnostic (trace) files.	
14.0	Demonstrate an understanding of database storage structures. – The student will be able to:	
14.01	Describe and differentiating between the logical and physical structure of the database. 	
14.02	List the segment types and their uses. 	
14.03	Maintain storage structures with automatic segment – space management. 	
14.04	Maintain storage structures manually. 	
14.05	Obtain storage structure information.	
15.0	Demonstrate the ability to query a database. – The student will be able to:	
15.01	Write basic SQL single row, datatype conversion, group, and user-defined functions. 	
15.02	Write filtered, sorted, and aggregated queries. 	
15.03	Write SQL statements using advanced queries involving joins, subqueries, and other specialized queries.	
16.0	Demonstrate how to manage constraints and indexes. – The student will be able to:	
16.01	List the different types of indexes, their uses, and constraints. 	
16.02	Develop an example of each type of index. 	
16.03	Create index-organized tables. 	
16.04	Create, modify, and drop constraints.	
16.05	Maintain indexes. 	
16.06	Identify unused indexes.	
17.0	Demonstrate the ability to perform backup and recovery procedures. – The student will be able to:	
17.01	Describe the various types of backups.	
17.02	Explain the different backup options available to the database professional.	
17.03	Perform a backup.	
17.04	Identify the different types of failures that occur in the database. 	
17.05	Perform a complete recovery on a database. 	
17.06	Perform an incomplete recovery on a database. 	
17.07	Demonstrate how to perform a recovery of non-critical files.	
18.0	Demonstrate an understanding of the goals and processes of performance tuning. – The student will be able to:	
18.01	Describe the job roles in performance tuning. 	
18.02	List the steps in the tuning phases. 	
18.03	Explain tuning goals and service level agreements. 	
18.04	Describe common performance problems. 	
18.05	Explain the tuning methodology.	
19.0	Demonstrate how to automate management tasks, use diagnostic tools, create scheduled jobs, programs, and schedules. – The student will be able to:	
19.01	Use database utilities to create jobs, programs, and schedule tasks. 	
19.02	Describe the purpose and use of the diagnostic tools that are available within the database. 	
19.03	Use database utilities to view information about job executions and job instances.	
19.04	Use database utilities to perform automatic gathering of optimizer statistics. 	
19.05	Use database utilities to automatically gather object statistics to make efficient decisions about execution plans.	
20.0	Demonstrate the ability to efficiently manage space-related inefficiencies of the database. – The student will be able to:	
20.01	Tune redo writing and archiving operations. 	
20.02	Set and modifying thresholds for space usage. 	
20.03	Manage tablespace usage to reduce space-related error conditions. 	
20.04	Use different storage options to improve the performance of queries. 	
21.0	Demonstrate the ability to understand database memory management. – The student will be able to:	
21.01	Explain the memory structures. 	
21.02	Configure memory structures for database efficiency.	
22.0	Demonstrate the ability to set up a database to be deployed globally. – The student will be able to:	
22.01	Customize language-dependent behavior for the database and individual sessions. 	
22.02	Specify different linguistic sorts for queries. 	
22.03	Use date-time data types for different time zones. 	
22.04	Query data using case-sensitive and accent-insensitive searches. 	
22.05	Obtain globalization support configuration information.	
22.06	

Oracle Certified Database Developer Specialization Standards	
23.0	Demonstrate the use of general SQL programming language fundamental constructs. – The student will be able to:	
23.01	Employ SQL language components including variables and identifiers.	
23.02	Make use of data types.	
23.03	Explain the use of a block, nested block, and labels.	
24.0	Demonstrate the use of DML simple selection statements in a SQL block. – The student will be able to:	
24.01	Use the SELECT INTO syntax for variable initialization.	
24.02	Use Data Manipulation Language statements in a SQL block.	
24.03	Make use of a sequence in a SQL block.	
24.04	Make use of the COMMIT, ROLLBACK, and SAVEPOINT commands in a SQL block.	
25.0	Demonstrate the use of conditional control IF and CASE statement. – The student will be able to:	
25.01	Use the IF-THEN, and IF-THEN-ELSE control statements.	
25.02	Use nested IF statements.	
25.03	Use the CASE statement in a procedural block of code.	
25.04	Use a CASE expression.	
26.0	Demonstrate the use of employing iterative control loops for iterating through a set of instructions. – The student will be able to:	
26.01	Use simple loops with EXIT conditions.	
26.02	Use simple loops with EXIT WHEN conditions.	
26.03	Use WHILE loops.	
26.04	Use numeric FOR loops with the IN and REVERSE option.	
27.0	Demonstrate the use of incorporating exception handling methods. – The student will be able to:	
27.01	Explain the use of error handling methods.	
27.02	Use built-in exception handling mechanisms.	
27.03	Create user-defined exceptions.	
28.0	Demonstrate how to design and implement functions and procedures. – The student will be able to:	
28.01	Create procedures.	
28.02	Query the data dictionary for information on procedures.	
28.03	Use IN and OUT parameters with procedures.	
28.04	Create stored functions.	
28.05	Invoke functions with SQL statements.	

Additional Information

Laboratory Activities

Laboratory activities are an integral part of this program.  These activities include instruction in the use of safety procedures, tools, equipment, materials, and processes related to these occupations.  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 as identified on the secondary student’s Individual Educational Plan (IEP) or 504 plan or postsecondary student’s accommodations’ plan 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.

Articulation

To be transferable statewide between institutions, this program must have been reviewed, and a “transfer value” assigned the curriculum content by the appropriate Statewide Course Numbering System discipline committee.  This does not preclude institutions from developing specific articulation agreements with each other. 

The following industry certifications have been approved by the Florida State Board of Education for statewide articulation credit into this degree program.

Oracle Certified Associate (ORACL001) – 6 credits

For details on articulation agreements which correlate to programs and industry certifications refer to http://www.fldoe.org/workforce/dwdframe/artic_frame.asp .

Program Length

The AS degree requires the inclusion of a minimum of 15 credits of general education coursework according to SACS, and it must be transferable according to Rule 6A-14.030 (2), F.A.C.  The standard length of this program is 60 credit hours according to Rule 6A-14.030, F.A.C.

Certificate Programs

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 AS degree program includes the following College Credit Certificates:

Microsoft Certified Database Administrator (0511020309) – 15 credit hours
Oracle Certified Database Administrator (0511020307) – 15 credit hours
Oracle Certified Database Developer (0511020308) – 15 credit hours

Standards for the above certificate programs are contained in separate curriculum frameworks.