Database Design and Programming Course Map by Oracle

Oracle Database Design and Programming Course Map

1. Copyright © 2019 , Oracle and/or its affiliates. All rights reserved. Oracle and Java are registered trademarks of Oracle and/or its affiliates. Other names may be trademarks of their respective owners.


Pacing Guidelines for Database Design and Programming
Session Length 45 Minutes
Semester 1
Session 1 Session 2 Session 3 Session 4 Session 5
Week 1
Introduction
Week 2
Entities and Attributes Relationship Basics
Week 3
Super/Sub Types and Business Rules
Week 4
Relationship Fundamentals
Week 5
Exam Review
Week 6
MIDTERM Exam UIDs and Normalization
Week 7

Week 8
Arcs, Hierarchies and Recursive Modeling
Week 9
Changes and Historical Modeling Mapping
Week 10
Creating Database Projects
Week 11
Presenting Database Projects
Week 12
Introduction to the Final Project
Week 13
Preparing Project Final Presentation
Week 14
Week 15
Week 16
Final Presentations
Week 17
Exam Review
Week 18
FINAL Exam
academy.oracle.com

2. 2

Copyright © 2019 , Oracle and/or its affiliates. All rights reserved. Oracle and Java are registered trademarks of Oracle and/or its affiliates. Other names may be trademarks of their respective owners.
Semester 2 Session 1 Session 2 Session 3 Session 4 Session 5
Week 1
Introduction
Week 2
SELECT and WHERE
Week 3
WHERE, ORDER BY, and Intro to Functions
Week 4
Single Row Functions Part I Single Row Functions Part II
Week 5
JOINs Part I
Week 6
JOINs Part II Group Functions Part I
Week 7
Group Functions Part II Subqueries
Week 8
Exam Review
Week 9
MIDTERM
Ensuring Quality Queries
Part I

Week 10
DML DDL
Week 11
Constraints
Week 12
Views
Week 13
Sequences and Synonyms
Week 14
Priviledges and Regular Expressions TCL
Week 15
Exam Review
Week 16
FINAL Exam Ensuring Quality Queries Part II
Week 17
Final Project
Week 18