•  Section 0 - Student Resources 

•  Section 1 

•  L1 Introduction to The Oracle Academy 

•  Quiz: Introduction to The Oracle Academy  

•  L2 Data vs Information 

•  Quiz: Data vs Information 

•  L3 History of the Database 

•  Quiz: History of the Database  

•  L4 Major Transformations in Computing 

•  Quiz: Major Transformations in Computing

• Section 2 

•  L1 Conceptual and Physical Models 

•  Quiz: Conceptual and Physical Models 

•  L2 Entities, Instances, Attributes and Identifiers 

•  Quiz: Entities, Instances, Attributes and Identifiers 

•  L3 Entity Relationship Modeling and ERDs 

•  Quiz: Entity Relationship Modeling and ERDs 

•  L4 Effective Questioning: Finding the Missing Link]

• Section 3 

•  L1 Identifying Relationships 

•  Quiz: Identifying Relationships 

•  L2 ER Diagramming

•  Quiz: ER Diagramming 

•  L3 Speaking ERDish and Drawing Relationships 

•  Quiz: Speaking ERDish and Drawing Relationships 

•  L4 Matrix Diagrams 

•  Quiz: Matrix Diagrams 

• Section 4

•  L1 Supertypes and Subtypes 

•  Quiz: Supertypes and Subtypes 

•  L2 Documenting Business Rules 

•  Quiz: Documenting Business Rules 

• Section 5 

•  L1 Relationship Transferability

•  Quiz: Relationship Transferability 

•  L2 Relationship Types 

•  Quiz: Relationship Types

•  L3 Resolving Many to Many Relationships 

•  Quiz: Resolving Many to Many Relationships 

•  L4 Understanding CRUD Requirements 

• Section 6

• L1 Artificial, Composite and Secondary UIDs 

•  Quiz: Artificial, Composite and Secondary UIDs

•  L2 Normalization and First Normal Form 

•  Quiz: Normalization and First Normal Form 

•  L3 Second Normal Form

•  Quiz: Second Normal Form 

•  L4 Third Normal Form

•  Quiz: Third Normal Form 

• Section 7 

•  L1 Arcs

•  Quiz: Arcs 

•  L2 Hierarchies and Recursive Relationships 

•  Quiz: Hierarchies and Recursive Relationships 

•  L3 Modeling Historical Data

•  Quiz: Modeling Historical Data 

• Section 8  - Omit this section

• Section 9  - Omit this section

• Section 10 

•  L1 Modeling Change: Time 

•  Quiz: Modeling Change: Time 

•  L2 Modeling Change: Price

•  Quiz: Modeling Change: Price 

•  L3 Adding the Time Element to the Animal Shelter ERD 

•  L4 Leaders in Information Technology 

•  L5 What About Me? - Omit

• Mid Term Exam - Database Design 

•  Mid Term Exam - Database Design 

• Section 11 

•  L1 Drawing Conventions for Readability 

•  Quiz: Drawing Conventions for Readability

•  L2 Generic Modeling

•  Quiz: Generic Modeling 

•  L3 The Changing Nature of Work - Options but not required

• Section 12

•  L1 Introduction to Relational Database Concepts

•  Quiz: Introduction to Relational Database Concepts

•  L2 Basic Mapping: The Transformation Process 

•  Quiz: Basic Mapping: The Transformation Process 

•  L3 Relationship Mapping 

•  Quiz: Relationship Mapping 

•  L4 Subtype Mapping 

•  Quiz: Subtype Mapping 

•  L5 Introduction to Oracle Application Express (APEX)

• Section 13 

•  L1 SQL Introduction: Querying the Database 

•  Quiz: SQL Introduction: Querying the Database 

•  L2 Basic Table Modifications 

•  Quiz: Basic Table Modifications

•  L3 Teaming Up - Options but not required

•  L4 Project Overview & Getting Started - Options but not required

•  L5 Project Management: Final Presentation Checkpoint - Options but not required

• Section 14 Optional Section Not required

•  L1 System Development Life Cycle 

•  Quiz: System Development Life Cycle 

•  L2 Creating Tables for the Final Presentation Options but not required

• Section 15 - Omit this section

• Section 16 

•  L1 Anatomy of a SQL Statement

•  Quiz: Anatomy of a SQL Statement 

•  L2 Oracle Database Environment 

•  L3 Using Applications 

•  L4 Relational Database Technology 

•  Quiz: Relational Database Technology 

•  L5 Career Portfolio - Roadmap to Your Future - Options but not required

• Section 17 

•  L1 Working with Columns, Characters, and Rows 

•  Quiz: Working with Columns, Characters, and Rows 

•  L2 Limit Rows Selected 

•  Quiz: Limit Rows Selected

•  L3 Comparison Operators 

•  Quiz: Comparison Operators 

•  L4 Work Experience & Community Involvement Options but not required

• Section 18 

•  L1 Logical Comparisons and Precedence Rules 

•  Quiz: Logical Comparisons and Precedence Rules 

•  L2 Sorting Rows

•  Quiz: Sorting Rows 

•  L3 Mock Interviews - Options but not required

•  L4 Introduction to Functions 

•  Quiz: Introduction to Functions 

• Final Exam - Database Design 

•  Final Exam - Database Design 

•  Oracle Academy Database Programming with SQL

•  Academy Curriculum Tour 

• Section 0 - Student Resources 

• Section 1  

•   L1 Case and Character Manipulation 

•  Quiz: Case and Character Manipulation 

•  L2 Number Functions 

•  Quiz: Number Functions  

•  L3 Date Functions  

•  Quiz: Date Functions  

•  L4 Interest and Aptitudes and Career Exploration    - Options but not required

• Section 2  

•   L1 Conversion Functions  

•  Quiz: Conversion Functions  

•  L2 Null Functions  

•  Quiz: Null Functions  

•  L3 Conditional Expressions  

•  Quiz: Conditional Expressions  

• Section 3  

•  L1 Destinations: What's In My Future   - Options but not required  

•  L2 Cartesian Product and the Join Operations  

•  Quiz: Cartesian Product and the Join Operations  

•  L3 Nonequijoins  

•  Quiz: Nonequijoins  

•  L4 Outer Joins  

•  Quiz: Outer Joins  

•  L5 Self Joins  

•  Quiz: Self Joins  

• Section 4  

•  L1 Putting It All Together    - Options but not required - very interesting

•  L2 Cross Joins and Natural Joins  

•  Quiz: Cross joins and Natural Joins  

•  L3 Join Clauses  

•  Quiz: Join Clauses  

•  L4 Inner versus Outer Joins  

•  Quiz: Inner versus Outer Joins  

• Section 5  

•  L1 Review of Joins  

•  L2 Group Functions  

•  Quiz: Group Functions  

•  L3 Count, Distinct, NVL  

•  Quiz: Count, Distinct, NVL  

• Section 6  

•  L1 Group By and Having Clauses  

•  Quiz: Group By and Having Clauses  

•  L2 Subqueries  

•  Quiz: Subqueries  

•  L3 Single-Row Subqueries  

•  Quiz: Single-Row Subqueries  

•  L4 Multiple-Row Subqueries  

•  Quiz: Multiple-Row Subqueries  

• Section 7  

•  L1 Insert Statement  

•  Quiz: Insert Statement  

•  L2 Updating Column Values and Deleting Rows  

•  Quiz: Updating Column Values and Deleting Rows  

•  L3 Default Values and the Merge Statement  

•  Quiz: Default Values and the Merge Statement  

• Mid Term Exam - Database Programming with SQL  

•  Mid Term Exam - Database Programming with SQL 

• Section 8  

• L1 Creating Tables  

•  Quiz: Creating Tables  

•  L2 Using Data Types  

•  Quiz: Using Data Types  

•  L3 Modifying A Table  

•  Quiz: Modifying A Table  

• Section 9  

•  L1 Defining Not Null and Unique Constraints  

•  Quiz: Defining Not Null and Unique Constraints  

•  L2 Primary Key, Foreign Key, and Check Constraints  

•  Quiz: Primary Key, Foreign Key, and Check Constraints  

•  L3 Managing Constraints  

•  Quiz: Managing Constraints  

• Section 10  

•  L1 Creating Views  

•  Quiz: Creating Views  

•  L2 DML Operations and Views  

•  Quiz: DML Operations and Views  

•  L3 Managing Views  

•  Quiz: Managing Views  

• Section 11  

•  L1 In Class Interview   - Options but not required

•  Quiz: In Class Interview   - Options but not required

•  L2 Sequences  

•  Quiz: Sequences  

•  L3 Indexes and Synonyms  

•  Quiz: Indexes and Synonyms  

• Section 12  

•  L1 Looking For A Job  - Options but not required

•  L2 Controlling User Access 

•  Quiz: Controlling User Access 

•  L3 Creating and Revoking Object Privileges 

•  Quiz: Creating and Revoking Object Privileges  

• Section 13  

•  L1 Testing  

•  Quiz: Testing  

•  L2 Final Project  

•  L3 Final Exam Review  

• Section 14  

•  L1 Database Transactions  

•  Quiz: Database Transactions  

•  L2 Certification Exam Prep  

• Final Exam - Database Programming with SQL   

•  Final Exam - Database Programming with SQL