Title: Database Programming: Oracle (10036)

For DOL Upload
Orientation
  Welcome Video
  Orientation Learning Procedures
  Assessment
Syllabus_APT
  Syllabus
Course Schedule_16wk
  Schedule
Textbook
Competency Modules
  Competency 1: Demonstrate how to use SQL to query a database and list a database structure
    Learning Progression
    START HERE!
    Read Appendix B and C
    Competency 1 Introduction
    Learning Objectives
    Read it
    Competency 1 Quizzes
      Lab Quiz
      Lecture Quiz
    Competency 1 Assessment
      Appendix B and C
      Review Basic Commands
      Lab 1
      Upload files into BlackBoard Tutorial
  Competency 2: Identify Databse Systems and Desgin Models
    Learning Progression
    Competency 2 Introduction
    Competency 2.1: Idenfity Database System
      Foreword
      Learning Objectives
      Read it
      Think about it
      Review it
      Assessment Quiz
    Competency 2.2: Idenfity Data Models
      Foreword
      Learning Objectives
      Read it
      Think about it
      Review it
      Assessment Quiz
    Competency 2.3: Design, Implement and Manage Database
      Foreword
      Learning Objectives
      Read it
      Think about it
      Review It
      Assessment Quiz
    Compentency 2.4: Entity Relation Modeling
      Foward
      Learning Objectives
      Read it
      Think about it
      Review It
      Assessment Quiz
    Compentency 2.5 Describe Normalization of Database Tables
      Foreword
      Learning Objectives
      Read it
      Think about it
      Review It
      Assessment Quiz
    Competency 2 Assessment
  Competency 3: Operate Sample Database
    Learning Progression
    Competency 3 Introduction
    Learning Objectives
    Read it
    Competency 3 Quizzes
    Competency 3 Assessment
      Lab 2
  Competency 4: Implement Advanced SQL and Database Design
    Learning Progression
    Competency 4 Introduction
    Competency 4.1: Identify Advanced Data Modeling
      Foreword
      Learning Objectives
      Read it
      Think about it
      Review it
      Assessment Quiz
    Competency 4.2 Interpret Advanced SQL
      Foreword
      Learning Objectives
      Read it
      Think about it
      Review it
      Assessment Quiz
    Competency 4.3 Design Databse
      Foreword
      Learning Objectives
      Read it
      Think about it
      Review it
      Assessment Quiz
    Competency 4.4 Define Transaction Management and Concurrency Control
      Foreword
      Learning Objectives
      Read it
      Think about it
      Review it
      Assessment Quiz
    Chapter 7
      Read it
    Competency 4 Assessment
  Competency 5: Design and Normalize Database
    Competency 5 Introduction
    Learning Objectives
    Competency 5 Assessment
      Lab 3
  Competency 6: Examine Advance Database Concepts
    Learning Progression
    Competency 6 Introduction
    Competency 6.1: Explain Database Performance Tuning and Query Optomization
      Foreword
      Learning Objectives
      Read it
      Think about it
      Review it
      Assessment Quiz
    Competency 6.2 Explain Distributed Database Management Systems
      Foreword
      Learning Objectives
      Read it
      Think about it
      Review it
      Assessment Quiz
    Competency 6.3 Explain Business Intelligence and Data Warehouses
      Foreword
      Learning Objectives
      Read it
      Think about it
      Review it
      Assessment Quiz
    Competency 6.4 Explain Business Intelligence and Data Warehouses
      Foreword
      Learning Objectives
      Read it
      Think about it
      Review it
      Assessment Quiz
    Competency 6.5 Explain Business Intelligence and Data Warehouses
      Foreword
      Learning Objectives
      Read it
      Think about it
      Review it
      Assessment Quiz
    Competency 6 Assessment
SQL Developer
  Appendix B
  SQL Developer
    SQL Developer PowerPoint
Lab Resources
  Oracle 11g Link - due to security likes-- this will require multiple mouse clicks
  Uninstall Oracle 11g pdf
  Printing_Infomation_Spooling
  Constraints Handout
Video - A Day of Glass Just to get you to think about databases
Course Disclaimers
  U. S. Department of Labor Disclaimer
  Creative Commons License