Title: Introduction to Oracle SQL and PL/SQL (10610)

Syllabus
  ITSE-1345 Syllabus
Schedule_APT
  ITSE 1345 APT Schedule
Competency Modules
  Course Orientation
    Course Welcome Video
    Orientation Learning Outcomes
    Orientation learning procedures
  Competency 1: Build Databases
    Introduction to Building Database
    Learning Objectives
    Option 1: Remote Database setup
      Step 1: Install 11g Express
      Step 2: Install SQL Developer
      Step 3: Create Database for Lab Assignments
    Option 2: On Campus Database Setup
      Step 1: Install SQL Developer
      Step 2: Create Database for Lab Assignments
    Competency 1 Lab
      Lab 1: SQL Review
    Competency 1 Exam
  Competency 2: Manipulate Data in PL/SQL Blocks
    Competency 2 Introduction
    Competency 2 Challenge - Exam 2C
    Competency 2.1: Describe PL/SQL
      Competency 2.1 Introduction
      Learning Objectives
      Read it
      Competency 2.1 Hands-On Practice Assignment - Chapter 1
        Hands On Practice Assignment - Chapter 1
    Competency 2.2: Employ Basic PL/SQL Blocks
      Competency 2.2 Introduction
      Learning Objectives
      Read It
      Competency 2.2 Hands-On Practice Assignment- Chapter 2
        Hands-On Practice Assignment - Chapter 2
    Competency 2.3: Manipulate Data in PL/SQL Blocks
      Competency 2.3 Introduction
      Learnng Objectives
      Read it
      Competency 2.3 Hands-On Assignment - Chapter 3
        Hands-On Practice Assignment - Chapter 3
    Competency 2 Exam (Check for Due Date)
    Competency 2 Lab (Check for Due Date)
      Lab 2
  Competency 3: Develop Stored Program Units
    Competency 3 Introduction
    Competency 3 Challenge - Exam 3C
    Competency 3.1: Apply Cursors and Exceptions in Blocks
      Competency 3.1 Introduction
      Learning Objectives
      Read It
      Competency 3.1 Hands-On Practice Assignments - Chapter 4
        Hands-on Practice Assignment - Chapter 4
    Competency 3.2: Develop Procedures
      Competency 3.2 Introduction
      Learning Objectives
      Read It
      Competency 3.2 Hands-On Practice Assignment - Chapter 5
        Hands-on Practice Assignment - Chapter 5
    Competency 3.3: Create Functions
      Competency 3.3 Introduction
      Learning Objectives
      Read It
      Competency 3.3 Hands-On Practice Assignments - Chapter 6
        Hands-On Practice Assignment - Chapter 6
    Competency 3.4: Build Packages
      Competency 3.4 Introduction
      Learning Objectives
      Read It
      Competency 3.4 Hands-on Practice Assignment - Chapter 7
        Hands On Practice Assignment - Chapter 7
    Competency 3 Exam (Check for Due Date)
    Competency 3 Lab ( Check for Due Date)
      Lab 3
  Competency 4 : Build Program Units
    Competency 4 Introduction
    Competency 4 Challenge - Exam 4C
    Competency 4.1 Develop Program Unit Dependencies
      Competency 4.1 Introduction
      Learning Objectives
      Read It
      Competency 4.1 Hands-On Practice Assignment - Chapter 8
        Hands-on Practice Assignment - Chapter 8
    Competency 4.2 Build Triggers
      Competency 4.2 Introduction
      Learning Objectives
      Read It
      Competency 4.2 Hands-On Practice Assignment - Chapter 9
        Hands-on Practice Assignment - Chapter 9
    Competency 4.3 Use Oracle-Supplied Packages
      Competency 4.3 Introduction
      Learning Objectives
      Read It
      Competency 4.3 Hands-On Practice Assignment - Chapter 10
        Hands-on Practice Assignment - Chapter 10
    Competency 4 Exam (Check for Due Date)
    Competency 4 Lab (Check for Due Date)
      Lab 4
Course Resources
  Database Scripts
    Orders Database Files used for lab assignments
      DBCREATE.SQL
      DBLOAD.SQL
  Orders Labs Information
    ITSE1345_Orders_DB_Lab1.docx
    ITSE1345_Orders_DB_Lab2.docx
    ITSE1345_Orders_DB_Lab3.docx
    ITSE1345_Orders_DB_Lab4.docx
  HandOuts
    ITSE1345_APT_CONSTRAINTS_HAND_OUT.pdf
    ITSE1345_APT_The Problem of Nulls.pdf
Adobe Connect--tutor
  Adobe Connect -- Tutor
Class Meeting--Instructor
  Class Meeting Link
  Class Meeting Recordings
  Adobe Connect Tutorial for Students
Course Disclaimers
  U. S. Department of Labor Disclaimer
  Creative Commons License
Instructors - Getting Started
  Quick Tips
    Copying a Course Site
    Course Availability
    Adding a Course Banner
    Add Images to an Assessment
    Removing a Gradebook Item
    Arranging Grade Center Columns
    Removing Old Course Sites
  Instructors - Getting Started
  Technology Resources
  Quick Tips
    Copying a Course Site
    Course Availability
    Adding a Course Banner
    Add Images to an Assessment
    Removing a Gradebook Item
    Arranging Grade Center Columns
    Removing Old Course Sites
  Instructors - Getting Started
  Technology Resources
  Quick Tips
    Copying a Course Site
    Managing the Course Menu
    Course Availability
    Adding a Course Banner
    Adding another instructor to your course site
    Add Images to an Assessment
    Removing a Gradebook Item
    Arranging Grade Center Columns
    Removing Old Course Sites
  Instructors - Getting Started
  Removing this area from your course site
  Hands On Practice it