2019/2020 Competency-Based Task/Competency List for Database Design and Management (Oracle) (6660/36 weeks)
Tasks/competencies when marked as such; they and/or additional tasks/competencies may be taught at the discretion of the school division. All other tasks are considered essential statewide and are required of all students.are considered optional
Demonstrating Personal Qualities and Abilities
Demonstrating Interpersonal Skills
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
Exploring Database Technologies
- Research the history of databases.
- List the major types of databases.
- Distinguish between a conceptual and a physical database model.
- Compare the structure of relational and non-relational database structures.
- Identify the characteristics of a relational database.
- Examine the database development life cycle.
- Research the future direction of database technologies.
Identifying Business Requirements
Examining Entity-Relationship Basics
Applying Design Concepts to Database Models
- Identify elements of the graphic representation of a database model.
- Define drawing conventions for readability.
- Illustrate business rules in an entity-relationship model.
- Define the normalization process.
- Perform the normalization process.
- Resolve many-to-many relationships.
- Model hierarchical data.
- Model recursive relationships.
- Model exclusive relationships.
- Define relational-database terminology.
- Define a fact and dimension.
- Verbalize a diagram's relationship notation.
Transitioning from Design Concepts to Database Management
Writing Structured Query Language (SQL) Statements
- Describe SQL.
- Distinguish among categories of SQL statements.
- Demonstrate the syntax for select statements (projection).
- Demonstrate methods for selecting columns and arithmetic expressions (selection).
- Incorporate column alias and literals in a SELECT statement.
- Describe operator precedence.
- Describe methods for displaying a table.
Restricting and Sorting Data Using SQL
- Restrict data, using the WHERE clause.
- Define comparison operators (e.g., =, >, <, >=, <=, <>, !=)
- Restrict data, using the BETWEEN ... AND and IN clauses.
- Restrict data, using wildcards and patterns within the LIKE condition.
- Demonstrate the use of the ESCAPE character with wildcard characters.
- Restrict (or specify) data containing nulls, using the IS (NOT) NULL clause.
- Demonstrate the use of two or more conditional statements using logical operators (i.e., AND, OR, NOT).
- Sort data by using ResultSet with the ORDER BY clause.
Performing Single-Row Functions
- Explain the concept of functions.
- Distinguish between the two categories of functions in SQL.
- Demonstrate restricting data using ANY and ALL.
- Define single-row functions.
- Describe the types/categories of single-row functions.
- Demonstrate the use of character, number, and date functions in SELECT statements.
- Describe the use of conversion functions.
- Demonstrate the use of null character handling.
- Demonstrate the use of conditional expressions.
Using JOIN Tables
Aggregating Data Using GROUP Functions
Applying Advanced Data Selection Techniques
Applying Data Manipulation Language
Modifying and Managing Tables
- Describe data definition language (DDL).
- Create a table.
- Create a table, using a subquery.
- Describe the data dictionary.
- Define common data types.
- Describe date/time data types.
- Write code to alter table definitions.
- Write SQL code to manipulate column definitions, using DROP, RENAME, and TRUNCATE commands.
- Differentiate among TRUNCATE, DROP, and DELETE.
- Describe FLASHBACK.
Defining Database Constraints
Creating and Managing Views
- Describe a view.
- Create a view.
- Write SQL code to retrieve data through a view.
- Write SQL code to alter the definition of a view.
- Manipulate tables, using the INSERT, UPDATE, and DELETE commands through a view.
- Write SQL code to remove a view.
- Create an inline view.
- Describe the procedures for performing a top-n analysis.
Creating Additional Database Objects
- Describe database objects and their uses.
- Define a sequence object.
- Create a sequence.
- Use a sequence.
- Modify a sequence.
- Describe the index.
- Describe issues that affect the decision to create an index.
- Create an index.
- Create private and public synonyms.
- Describe the type of information available in the data dictionary.
- Create SQL code to retrieve information from the data dictionary.
Maintaining Database Security and System Security
Making Database Transactions
Preparing for Industry Certification
- Describe the process and requirements for obtaining industry certifications related to the Database Design and Management (Oracle) course.
- Identify testing skills and strategies for a certification examination.
- Demonstrate ability to successfully complete selected practice examinations.
- Complete an industry certification examination representative of skills learned in this course (e.g., MOS, MTA, IC3).