21st Century Standards Profile
Business and Marketing Education
Course Title: Oracle Database Design and Management with PL SQL WVEIS Code 1932
Student’s Name______________________________________________________________________________________________
School__________________________________________________Instructor____________________________________________
Course Description: This course is as an extension of the SQL programming language. This course provides additional database
functionality through variables, constants, conditional statements, and iterative controls. Students enhance their relational database
design and management skills by learning to write PL/SQL code that includes anonymous blocks, sub programs, built-in functions,
control structures, procedures, and triggers, all within a browser-based programming environment. This course prepares students to
take the Oracle OCA Certification exam (second part), Programming with PL/SQL. Students will utilize problem-solving techniques and
participate in hands-on activities to develop an understanding of course concepts. Teachers should provide each student with real world
learning database and technology opportunities. Students are encouraged to become active members of the student organizations
FBLA, DECA, or Skills USA. The West Virginia Standards for 21st Century Learning include the following components: 21st Century
Content Standards and 21st Century Learning Skills and Technology Tools. All West Virginia teachers are responsible for classroom
instruction that integrates learning skills, technology tools, and content standards and objectives. Instructors for this course must have
completed and received the Oracle certification.
Level of Competence:
Above Mastery: The student demonstrates exceptional and exemplary performance with distinctive and sophisticated
application of knowledge and skills that exceed standard. The student can independently solve problems and is self-directed.
Mastery: The student demonstrates competent and proficient performance and shows a thorough and effective application of
knowledge and skills that meet standard. Application of knowledge and skills is thorough and effective and the student can work
independently.
Partial Mastery: The student demonstrates basic but inconsistent performance of fundamental knowledge and skills
characterized by errors and/or omissions. Performance needs further development and supervision.
1
Mastery
Mastery
Mastery
Partial
Above
Content Standards and Objectives Date Comments
Standard 1: PL/SQL Programming Concepts
Objectives The student will
BE.O.ODDM1.1.1 explain the function of PL/SQL.
BE.O.ODDM1.2.2 differentiate between SQL and
PL/SQL.
BE.O.ODDM1.3.3 determine the need for PL/SQL.
BE.O.ODDM1.4.4 determine the structure of a PL/SQL
block.
BE.O.ODDM1.5.5 identify the different types of PL/SQL
blocks.
Standard 2: Using PL/SQL Program Data
Objectives The student will
BE.O.ODDM1.2.1 use variables in PL/SQL lists the types
of variables and identifiers of a
PL/SQL statement.-p.m.
BE.O.ODDM1.2.2 determine valid and invalid identifiers
in PL/SQL.
BE.O.ODDM1.2.3 establish reserved words, delimiters,
literals, and comments in PL/SQL.
BE.O.ODDM1.2.4 examine data types used in PL/SQL.
BE.O.ODDM1.2.5 identify the benefits of anchoring data
types with the %TYPE attribute.
BE.O.ODDM1.2.6 select built-in SQL functions in
PL/SQL.
BE.O.ODDM1.2.7 differentiate between implicit and
explicit conversions. Chooses between
a.m.
BE.O.ODDM1.2.8 demonstrate how functions can be
used to explicitly convert data types.
Standard 3: Using SQL in PL/SQL
2
Objectives Students will
BE.O.ODDM1.3.1 review SQL DML.
BE.O.ODDM1.3.2 retrieve data in PL/SQL.
BE.O.ODDM1.3.3 manipulate data in PL/SQL.
BE.O.ODDM1.3.4 use transaction control statements in
PL/SQL.
Standard 4: Manipulating PL/SQL Program Structures
Objectives The student will
BE.O.ODDM1.4.1 construct and use an IF statement.
BE.O.ODDM1.4.2 construct and use a CASE statement.
BE.O.ODDM1.4.3 use basic loops.
BE.O.ODDM1.4.4 use WHILE and FOR loops.
BE.O.ODDM1.4.5 utilize nested loops.
Standard 5: Using Cursors
Objectives The student will
BE.O.ODDM1.5.1 distinguish between implicit and
explicit cursors.
BE.O.ODDM1.5.2 utilize explicit cursor attributes.
BE.O.ODDM1.5.3 use cursor FOR loops.
BE.O.ODDM1.5.4 declare and use cursors with
parameters.
BE.O.ODDM1.5.5 utilize cursors for update.
BE.O.ODDM1.5.6 use multiple cursors.
Standard 6: Using Exception Handling
Objectives The student will
BE.O.ODDM1.6.1 describe purpose of an exception in
PL/SQL programs.
BE.O.ODDM1.6.2 write PL/SQL code to trap Oracle
Server error and recognize the scope
of an exception.
BE.O.ODDM1.6.3 write PL/SQL code for trapping user-
defined exceptions.
BE.O.ODDM1.6.4 recognize the scope of variables as
related to nested blocks.
3
Standard 7: Creating and Removing Procedures
Objectives The student will
BE.O.ODDM1.7.1 create, invoke, and correct errors in
procedures.
BE.O.ODDM1.7.2 use simple parameters to pass
information in a procedure.
BE.O.ODDM1.7.3 demonstrate PL/SQL procedures to
support different parameter modes.
BE.O.ODDM1.7.4 remove procedures.
Standard 8: Creating and Removing Functions
Objectives The student will
create and invoke functions.
BE.O.ODDM1.8.2 use functions in SQL statements.
BE.O.ODDM1.8.3 use the data dictionary.
BE.O.ODDM1.8.4 manage procedures and functions.
BE.O.ODDM1.8.5 review object privileges.
BE.O.ODDM1.8.6 identify invoker and definer rights.
Standard 9: Participating in the Student Organization
Objectives The student will
BE.O.ODDM1.9.1 assess the purposes and goals of the
local student organization.
BE.O.ODDM1.9.2 discover the benefits and
responsibilities of participation in
student organization as an adult.
BE.O.ODDM1.9.3 demonstrate leadership skills through
participation in student organization
activities such as meetings, programs,
and projects.
4
Profile Summary
STUDENT COMMENTS:
Student’s Signature______________________________________________________________ Date____________________
INSTRUCTOR COMMENTS:
Instructor’s Signature_____________________________________________________________ Date___________________
5