Title: Database Design and Management with PL/SQL (Oracle) (10053)

Demonstrating Personal Qualities and Abilities
  Demonstrate creativity and innovation.
  Demonstrate critical thinking and problem-solving.
  Demonstrate initiative and self-direction.
  Demonstrate integrity.
  Demonstrate work ethic.
  WorkplaceReadinessSkillsPoster2019.pdf
Demonstrating Interpersonal Skills
  Demonstrate conflict-resolution skills.
  Demonstrate listening and speaking skills.
  Demonstrate respect for diversity.
  Demonstrate customer service skills.
  Collaborate with team members.
Demonstrating Professional Competencies
  Demonstrate big-picture thinking.
  Demonstrate career- and life-management skills.
  Demonstrate continuous learning and adaptability.
  Manage time and resources.
  Demonstrate information-literacy skills.
  Demonstrate an understanding of information security.
  Maintain working knowledge of current information-technology (IT) systems.
  Demonstrate proficiency with technologies, tools, and machines common to a specific occupation.
  Apply mathematical skills to job-specific tasks.
  Demonstrate professionalism.
  Demonstrate reading and writing skills.
  Demonstrate workplace safety.
Examining All Aspects of an Industry
  Examine aspects of planning within an industry/organization.
  Examine aspects of management within an industry/organization.
  Examine aspects of financial responsibility within an industry/organization.
  Examine technical and production skills required of workers within an industry/organization.
  Examine principles of technology that underlie an industry/organization.
  Examine labor issues related to an industry/organization.
  Examine community issues related to an industry/organization.
  Examine health, safety, and environmental issues related to an industry/organization.
Addressing Elements of Student Life
  Identify the purposes and goals of the student organization.
  Explain the benefits and responsibilities of membership in the student organization as a student and in professional/civic organizations as an adult.
  Demonstrate leadership skills through participation in student organization activities, such as meetings, programs, and projects.
  Identify Internet safety issues and procedures for complying with acceptable use standards.
Exploring Work-Based Learning
  Identify the types of work-based learning (WBL) opportunities.
  (Optional) Reflect on lessons learned during the WBL experience.
  Explore career opportunities related to the WBL experience.
  (Optional) Participate in a WBL experience, when appropriate.
Introducing PL/SQL Programming Concepts
  Explain PL/SQL.
  Differentiate between SQL and PL/SQL.
  Explain the need for PL/SQL.
  Describe the structure of a PL/SQL block.
  Identify the different types of PL/SQL blocks.
Using PL/SQL Program Data
  Use variables in PL/SQL.
  Describe valid and invalid identifiers in PL/SQL.
  Describe reserved words, delimiters, literals, and comments in PL/SQL.
  List data types used in PL/SQL.
  Identify the benefits of anchoring data types with the %TYPE attribute.
  Use built-in SQL functions in PL/SQL.
  Differentiate between implicit and explicit conversions.
  Demonstrate how functions can be used to explicitly convert data types.
Using SQL in PL/SQL
  Evaluate the SQL statements that can be directly included in a PL/SQL executable block.
  Retrieve data in PL/SQL.
  Manipulate data with DML statements in PL/SQL.
  Use SQL cursor attributes.
  Use transaction control statements in PL/SQL.
Constructing PL/SQL Program Structures to Control Execution Flow
  Identify the uses and types of conditional control structures.
  Construct and use an IF statement.
  Construct and use an IF-THEN-ELSE statement.
  Use basic loops with EXIT conditions.
  Use basic loops with EXIT WHEN conditions.
  Use WHILE loops.
  Use FOR loops.
  (Optional) Use nested loops.
Using Cursors
  Distinguish between an implicit and an explicit cursor.
  Declare and control explicit cursors.
  Use cursor simple LOOP to FETCH data.
  Use cursor FOR LOOP to fetch data.
  Describe cursors with parameters.
  (Optional) Declare and use cursors with parameters.
  (Optional) Lock rows using the FOR UPDATE clause.
  (Optional) Reference the current row with the WHERE CURRENT clause.
  (Optional) Use multiple cursors.
Using Exception Handling
  Describe the function of exceptions.
  Describe the function of an exception handler.
  Handle exceptions in PL/SQL programs.
  (Optional) Trap predefined Oracle server exceptions.
  (Optional) Trap non-predefined Oracle server errors.
  Trap user-defined errors.
  Describe scope of exceptions.
Examining PL/SQL Composite Data Types
  Describe user-defined PL/SQL records.
  Create a user-defined PL/SQL record.
  (Optional) Use PL/SQL INDEX BY Table and INDEX BY Table of Records.
Creating and Managing Procedures
  Identify the characteristics and benefits of a stored procedure.
  Invoke a stored procedure.
  List the steps for creating a procedure.
  Create a procedure with parameters.
  Invoke a procedure that has parameters.
  List the types of parameter modes.
  Describe the DEFAULT option for parameters.
  (Optional) Describe the method for propagating exceptions.
  Remove a procedure.
  Identify how to view and manage procedures.
Creating and Managing Functions
  Define stored function.
  Create a function.
  List the procedures for invoking a function.
  List the advantages of user-defined functions in SQL statements.
  List circumstances in which user-defined functions can be called from within a SQL statement.
  Describe the restrictions on calling functions from SQL statements.
  Remove a function.
  Identify how to view stored objects in the data dictionary.
  Identify differences between invoker and definer rights.
Designing Packages
  Identify a package specification and body.
  (Optional) Create packages (e.g., related variables, cursors, constants, exceptions, procedures, and functions).
  (Optional) Invoke a package construct.
  (Optional) Designate package constructs as public or private.
  (Optional) Drop packages.
  Identify benefits of packages.
  (Optional) Create packages that use the overloading feature.
  Identify restrictions on using packaged functions in SQL statements.
  (Optional) Invoke packaged functions from SQL.
  Identify persistent states in package variables and cursors.
  Describe the use and application of some Oracle server-supplied packages (e.g., DBMS_SQL, DBMS_OUTPUT, and UTL_FILE).
  (Optional) Use EXECUTE IMMEDIATE.
  (Optional) Describe the benefits of EXECUTE IMMEDIATE over DBMS_SQL for native dynamic SQL.
Creating and Removing Triggers
  Describe database triggers and types and the uses of each.
  List the DML trigger components.
  Create a DML trigger.
  Create a statement-level trigger.
  Describe the trigger-firing sequence options.
  (Optional) Use conditional predicates in a DML trigger.
  (Optional) Create a row-level trigger.
  (Optional) Use the OLD and NEW qualifiers in a database trigger.
  (Optional) Create an INSTEAD OF trigger.
  Describe events that cause database triggers to fire.
  (Optional) Create a trigger for a DDL statement.
  (Optional) Create a trigger for a system event.
  (Optional) Describe the functionality of the CALL statement.
  Describe the effect of a mutating table.
  (Optional) View trigger information in the dictionary views.
  (Optional) Alter a trigger status.
  (Optional) Remove a trigger.
Using Advanced Data Types
  Describe the function of LOB (large object) data types.
  (Optional) Migrate from LONG to LOB.
  (Optional) Manage BFILES.
Understanding Procedural Dependencies
  Describe the implications of procedural dependencies.
  Describe dependent objects and referenced objects.
  View dependency information in the dictionary views.
  (Optional) Use the UTLDTREE script.
  (Optional) Use the IDEPTREE and DEPTREE views.
  List the procedures for minimizing dependency failures.
Using the PL/SQL Compiler
  Describe PL/SQL initialization parameters.
  (Optional) Use PL/SQL initialization parameters.
  Identify compiler warning messages.
  (Optional) Describe conditional compilation.
  Describe the hiding of source code.
Preparing for Industry Certification
  Describe the process and requirements for obtaining industry certifications related to the Database Design and Management with PL/SQL (Oracle) course.
  Identify testing skills and strategies for a certification examination.
  Demonstrate the ability to successfully complete selected practice examinations (e.g., practice questions similar to those on certification exams).
  (Optional) Complete an industry certification examination representative of skills learned in this course.
Developing Employability Skills
  Investigate job opportunities, using the Internet and other sources.
  Investigate careers in the information technology field.
  Research certification and educational opportunities.
  Compose or update a printed résumé.
  Prepare an electronic résumé.
  Create a letter of application.
  Complete an electronic application form.
  Create an interview follow-up letter.
  Identify the steps to follow in resigning from a position.
  Develop a portfolio containing representative samples of the student's work (e.g., program design, technical documentation and design, source code, and output).
  Deliver an oral presentation of portfolio.
  Identify potential employment barriers for nontraditional groups and ways to overcome barriers.
ADDITIONAL COURSE INFORMATION
  6662 Student Competency Record_Copyright 2025.xlsx
  Printable Version with SOL and FBLA Correlations
  Instructional Scenarios
  Acknowledgments and Copyright Information