Brooklyn Technical High School

Section 1 Introduction

• Introduction to the Oracle Academy
• Quiz: Introduction to the Oracle Academy
• Data vs. Information
• Quiz: Data vs. Information
• History of the Database
• Quiz: History of the Database
• Major Transformations in Computing
• Quiz: Major Transformations in Computing

Section 2 What is Data Modeling

• Conceptual & Physical Models
• Quiz: Conceptual & Physical Models
• Entities, Instances, Attributes and Identifiers
• Quiz: Entities, Instances, Attributes and Identifiers
• Entity Relationship Modeling and ERDs
• Quiz: Entity Relationship Modeling and ERDs

Section 3 Entity Relationship Diagramming

• Identifying Relationships
• Quiz: Identifying Relationships
• ER Diagramming Conventions
• Quiz: ER Diagramming Conventions
• Speaking ERDish and Drawing Relationships
• Quiz: Speaking ERDish and Drawing Relationships
• Matrix Diagrams
• Quiz: Matrix Diagrams

Section 4 Supertypes, Subtypes, and Business Rules

• Supertypes and Subtypes
• Quiz: Supertypes and Subtypes
• Documenting Business Rules
• Quiz: Documenting Business Rules

Section 5 Working With Entity Relationships

• Relationship Transferability
• Quiz: Relationship Transferability
• Relationship Types
• Quiz: Relationship Types
• Resolving Many-to-Many Relationships
• Quiz: Resolving Many-to-Many Relationships
• Understanding CRUD Requirements

Section 6 Unique Identifiers and Normalization

• Artificial, Composite and Secondary UID
• Quiz: Artificial, Composite and Secondary UID
• Normalization and First Normal Form
• Quiz: Normalization and First Normal Form
• Second Normal Form
• Quiz: Second Normal Form
• Third Normal Form
• Quiz: Third Normal Form

Section 7 Arcs, Hierarchies, and Historical Data

• Arcs
• Quiz: Arcs
• Hierarchies and Recursive Relationships
• Quiz: Hierarchies and Recursive Relationships
• Modeling Historical Data
• Quiz: Modeling Historical Data

Section 8 ERD Project Presentation

• Presentation of the ERD to the Client

Section 9 Modeling Change

• Modeling Change: Time
• Quiz: Modeling Change: Time
• Modeling Change: Price
• Quiz: Modeling Change: Price
• Adding the Time Element to an ERD

Section 10 Drawing Conventions and Generic Modeling

• Drawing Conventions for Readability
• Quiz: Drawing Conventions for Readability
• Generic Modeling
• Quiz: Generic Modeling
• Mid Term Exam Semester 1
• Mid Term Exam Semester 1

Section 11 Transforming From Conceptual Model to Physical Model

• Introduction to Relational Database Concepts
• Quiz: Introduction to Relational Database Concepts
• Basic Mapping: The Transformation Process
• Quiz: Basic Mapping: The Transformation Process
• Relationship Mapping
• Quiz: Relationship Mapping
• Subtype Mapping
• Quiz: Subtype Mapping

Section 12 Introduction to SQL

• Introduction to Oracle Application Express
• SQL Introduction: Querying the Database
• Quiz: SQL Introduction: Querying the Database
• Basic Table Modifications
• Quiz: Basic Table Modfications
• System Development Life Cycle
• Quiz: System Development Life Cycle

Section 13 Introduction to the Final Project

• Project Overview and Getting Started
• Presentation Project Management
• Final Presentation Components

Section 14 Preparing Project Final Presentation

• Creating Tables for the Final Presentation
• Preparing Written Documentation
• Preparing Visual Materials
• Final Presentations

Section 15 SELECT Statements and Relational Database Technology

• Anatomy of a SQL Statement
• Quiz: Anatomy of a SQL Statement
• Oracle Database Environment
• Using Applications
• Relational Database Technology
• Quiz: Relational Database Technology

Section 16 Using the WHERE Clause

• Working with Columns, Characters, and Rows
• Quiz: Working with Columns, Characters, and Rows
• Limit Rows Selected
• Quiz: Limit Rows Selected
• Comparison Operators
• Quiz: Comparison Operators

Section 17 Restricting Rows and Introduction to Functions

• Logical Comparisons and Precedence Rules
• Quiz: Logical Comparisons and Precedence Rules
• Sorting Rows
• Quiz: Sorting Rows
• Introduction to Functions - Single Row Functions
• Quiz: Introduction to Functions - Single Row Functions
• Final Exam Semester 1

Section 1 Using Character, Number, and Date Functions

• Case and Character Manipulation
• Quiz: Case and Character Manipulation
• Number Functions
• Quiz: Number Functions
• Date Functions
• Quiz: Date Functions

Section 2 Using Single Row Functions

• Conversion Functions
• Quiz: Conversion Functions
• Null Functions
• Quiz: Null Functions
• Conditional Expressions
• Quiz: Conditional Expressions

Section 3 Executing Database Joins

• Cross Joins and Natural Joins
• Quiz: Cross Joins and Natural Joins
• Join Clauses
• Quiz: Join Clauses
• Inner Versus Outer Joins
• Quiz: Inner Versus Outer Joins
• Self Joins and Hierarchical Queries
• Quiz: Self Joins and Hierarchical Queries

Section 4 Working With Group Functions

• Review of Joins
• Group Functions
• Quiz: Group Functions
• Count, Distinct, NVL
• Quiz: Count, Distinct, NVL

Section 5 Using Complex SQL with Aggregated Data

• Using Group By and Having clauses
• Quiz: Using Group By and Having Clauses
• Using Rollup and Cube Operations, and Grouping Sets
• Quiz: Using Rollup and Cube Operations, and Grouping Sets
• Using Set Operators
• Quiz: Using Set Operators

Section 6 Creating Subqueries

• Fundamentals of Subqueries
• Quiz: Fundamentals of Subqueries
• Single Row Subqueries
• Quiz: Single Row Subqueries
• Multiple-row Subqueries
• Quiz: Multiple-row Subqueries
• Correlated Subqueries
• Quiz: Correlated Subqueries

Section 7 Constructing DML Statements

• Insert Statements
• Quiz: Insert Statements
• Updating Column Values and Deleting Rows
• Quiz: Updating Column Values and Deleting Rows
• Default Values, Merge, and Multi-Table Inserts
• Quiz: Default Values, Merge, and Multi-Table Inserts
• Mid Term Exam Semester 2
• Mid Term Exam Semester 2 - Part I
• Mid Term Exam Semester 2 - Part II

Section 8 Working with DDL Statements

• Creating Tables
• Quiz: Creating Tables
• Using Data Types
• Quiz: Using Data Types
• Modifying a Table
• Quiz: Modifying A Table

Section 9 Ensuring Quality Query Results

• Ensuring Quality Query Results

Section 10 Creating and Managing Constraints

• Defining Not Null and Unique Constraints
• Quiz: Defining Not Null and Unique Constraints
• Primary Key, Foreign Key, and Check Constraints
• Quiz: Primary Key, Foreign Key, and Check Constraints
• Managing Constraints
• Quiz: Managing Constraints

Section 11 Creating and Managing Views

• Creating Views
• Quiz: Creating Views
• DML Operations and Views
• Quiz: DML Operations and Views
• Managing Views
• Quiz: Managing Views

Section 12 Working With Sequences

• Working with Sequences
• Quiz: Working with Sequences
• Indexes and Synonyms
• Quiz: Indexes and Synonyms

Section 13 Fundamentals of Database Security

• Controlling User Access
• Quiz: Controlling User Access
• Creating and Revoking Object Privileges
• Quiz: Creating and Revoking Object Privileges
• Regular Expressions
• Quiz: Regular Expressions

Section 14 Understanding Database Transactions

• Database Transactions
• Quiz: Database Transactions

Section 15 Oracle Proprietary Join Syntax

• Cartesian Product and the Join Operations
• Quiz: Cartesian Product and the Join Operations
• Nonequijoins
• Quiz: Nonequijoins
• Outer Joins
• Quiz: Outer Joins

Section 16 Amazing Books Final Project

• Testing
• Quiz: Testing
• Final Project Database Creation
• Final Exam Review

Section 17 Ensuring Quality Query Results - Advanced Techniques

• Ensuring Quality Query Results - Advanced Techniques
• Final Exam Semester 2
• Final Exam Semester 2 - Part I
• Final Exam Semester 2 - Part II