2014 – 2015
Florida Department of Education
Curriculum Framework 

Program Title:	Microsoft Certified Database Administrator Certificate
Career Cluster:	Information Technology

CCC	
CIP Number	0511020309	
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	
Targeted Occupation List	http://www.labormarketinfo.com/wec/TargetOccupationList.htm	
Perkins Technical Skill Attainment Inventory	http://www.fldoe.org/workforce/perkins/perkins_resources.asp 	
Statewide Articulation	http://www.fldoe.org/workforce/dwdframe/artic_frame.asp 	

Purpose

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

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 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 developing applications and using the procedure builder tool.
04.0	Demonstrate proficiency in creating SQL procedural language blocks of application code that can be shared by multiple forms, reports and data management applications.
05.0	Demonstrate proficiency in creating a complete forms application using Developer/2000 while working in a graphical user interface (GUI) development environment.
06.0	Demonstrate proficiency in designing multiple forms applications.
07.0	Demonstrate proficiency in developing a variety of standard and custom reports using the reports component of Developer/2000 in a client/server environment.
08.0	Demonstrate proficiency in identifying the server physical and logical architecture.
09.0	Demonstrate proficiency in implementing and planning backup and recovery for the Server.
10.0	Demonstrate proficiency in implementing a Net8 configuration on a workstation and server.
11.0	Demonstrate proficiency in tuning a server.
12.0	Demonstrate proficiency in implementing database security.

2014 – 2015
Florida Department of Education
Student Performance Standards

Program Title:	Microsoft Certified Database Administrator Certificate
CIP Number:		0511020309
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 (0511020306).  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 developing applications and using the procedure builder tool.  ̶  The student will be able to:	
03.01	Develop programs in PL/SQL.	
03.02	Insert and manipulate data with PL/SQL.	
03.03	Manage and execute program units using the object navigator and the PL/SQL interpreter.	
03.04	Define and compile procedures using the program unit editor.	
03.05	Control the execution of a PL/SQL program unit.	
03.06	Test possible solutions by making changes to variables and procedures at runtime.	
04.0	Demonstrate proficiency in creating PL/SQL procedural language blocks of application code that can be shared by multiple forms, reports and data management applications.  ̶  The student will be able to:	
04.01	Nest sub-queries within another SQL procedural language command.	
04.02	Develop applications using procedural capabilities.	
04.03	Insert and manipulate data with SQL procedural language.	
04.04	Use the procedure builder tool to develop and debug SQL procedure language code.	
04.05	Manage and execute program units using the object navigator and the SQL procedural language interpreter.	
04.06	Define environmental requirements for peripherals and media.	
04.07	Define and compile procedures using the program unit editor.	
04.08	Control the execution of an SQL procedural language program unit.	
05.0	Demonstrate proficiency in creating a complete forms application using developer/ 2000 while working in a graphical user interface (GUI) development environment.  ̶  The student will be able to:	
05.01	Build a new data block using an existing table specification.	
05.02	Save and run a form module from the designer.	
05.03	Develop a master/detail form module.	
05.04	Identify characteristics of each forms file storage type.	
05.05	Create forms containing check boxes, radio groups, containing list items, display items, image items and buttons.	
05.06	Start additional forms with the same transaction and session.	
05.07	Enhance the default menu.	
05.08	Add basic menu items.	
05.09	
Attach a menu module to a forms module.	
05.10	Save and running a form module from the designer.	
06.0	Demonstrate proficiency in designing multiple forms applications.  ̶  The student will be able to:	
06.01	Redefine function keys and determining when key triggers should be used or avoided.	
06.02	Cause a form module to respond to mouse movement and mouse button actions.	
06.03	Create trigger code to interact with windows.	
06.04	Build robust multiple form transactions.	
06.05	Choose between different ways of invoking forms.	
06.06	Pass data between forms using parameter lists.	
06.07	Control coded events and methods.	
07.0	Demonstrate proficiency in developing a variety of standard and custom reports using the reports component of developer/2000 in a client / server environment.  ̶  The student will be able to:	
07.01	Design and execute a simple report.	
07.02	Manage the appearance and display of data in reports with layout objects.	
07.03	Customize the display of data in reports.	
07.04	Tailor the appearance of simple and advanced business reports.	
07.05	Integrate text and graphics in reports.	
07.06	Import charts and graphs from the graphics component of Developer/2000	
07.07	Apply the packaged functions and procedures supplied with the reports component of Developer/2000.	
07.08	Write queries to retrieve data.	
07.09	Manage the structure of data in reports using data objects.	
07.10	Determine how to best produce reports by analyzing report structures.	
07.11	Filter report information from the database server.	
07.12	Implement graphics into reports.	
07.13	Build modules in Developer 2000 reports for use with other Developer/2000 tools. 	
07.14	Manage module storage and security.	
07.15	Build reports in which the end user supplies values at runtime to control report output.	
08.0	Demonstrate proficiency in identifying the server physical and logical architecture.  ̶  The student will be able to:	
08.01	Identify and define the server architecture.	
08.02	Identify and utilize the functions and processes of the server.	
08.03	Create a database and construct the base data dictionary.	
08.04	Start up and shut down a database and instance.	
09.0	Demonstrate proficiency in implementing and backup and recovery planning and backup of a server.  ̶  The student will be able to:	
09.01	Identify backup and recovery techniques.	
09.02	Define architecture implications for backup and recovery.	
09.03	Examine various failure scenarios and determining proper recovery strategies.	
09.04	Identify methods for restoration and recovery.	
10.0	Demonstrate proficiency in implementing a Net8 configuration on the server and workstation.  ̶  The student will be able to:	
10.01	Establish a connection from the Net8 client and server using connection methods.	
10.02	Implement troubleshooting strategies for the networking environment.	
10.03	Explain security features in networking products.	
10.04	Identify network problems using log and trace files.	
10.05	Set logging and tracing parameters. 	
10.06	Start and stop the intelligent agent using the listener control utility.	
10.07	Identify the configuration files used to define the intelligent agent.	
11.0	Demonstrate proficiency in tuning a server.  ̶  The student will be able to:	
11.01	Explain the nature of server tuning.	
11.02	Outline the tuning methodology.	
11.03	List and define available diagnostic tools.	
11.04	Run the UTLBSTAT/UTLESTAT utility.	
11.05	Exam latch contention.	
11.06	Diagnose inappropriate use of the SYSTEM and TEMP tablespaces.	
11.07	Ensure that files are distributed to minimize 1/0 contention.	
12.0	Demonstrate proficiency in implementing database security.  ̶  The student will be able to:	
12.01	Demonstrate an understanding of essential database security concepts.	
12.02	Set up and administer users and groups.	
12.03	Use appropriate procedures to secure database resources.	

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 appropriate career and technical student organizations for 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 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

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