PL/SQL Programming With Oracle
Course Contents Listing

Class 1 Register
  1. Overview
    • Introductions
    • Class Syllabus
    • Homework
    • Grading
    • quizzes
    • mid-term
    • final
    • Class Website
    • Resources
    • Contacts
  2. Hardware (minimum requirements)
    • Pentium
    • 1GB RAM (500MB marginal)
    • CDROM drive or Fast Internet connection
  3. Software
    • Windows, Linux, UNIX
    • Oracle Database 10gR2 Enterprise Edition
  4. Method
    • Source
    • Download- otn.oracle.com
    • Purchase- store.oracle.com
  5. SQL*Plus (no GUIs)
  6. Database Contained Object Types (by Quarter)

    Q1

    • Heap Table
    • Global Temporary Table
    • External Tables
    • Compressed Tables
    • Index Organized Table
    • Partitioned Table
    • Cluster
    • Primary Key Constraint
    • Unique Constraint
    • Foreign Key Constraint
    • Check Constraint
    • B*Tree Indexes
    • Bitmap Indexes
    • Bitmap Join Indexes
    • Clusters
    • Compressed Indexes
    • Descending Indexes
    • Function Based Indexes
    • Global Indexes
    • Local Indexes
    • No Segment (Virtual) Indexes
    • Reverse Key Indexes
    • Sequences
    • Views
    • Materialized Views (Snapshot)
    • Built-in Functions

    Q2

    • Anonymous Blocks
    • Functions
    • Pipelined Table Functions
    • Procedures
    • Package Specification
    • Package Body
    • Pragmas
    • Operator
    • Exception Handling
    • Contexts
    • Table Trigger
    • Instead-of Trigger
    • DDL Event Trigger
    • System Event Trigger
    • Type
    • Directory
    • Built-in Packages dbms_application_info dbms_profiler dbms_output dbms_sql dbms_stats dbms_utility dbms_warning owa_util utl_file
    • System and Object Privileges


Class 2
  1. CREATE OR REPLACE
  2. IN, OUT, and IN OUT Parameters
  3. DEFAULT Parameters
  4. Parameters (NOCOPY)
  5. Private Functions
  6. Private Procedures
  7. ALTER PROCEDURE COMPILE
  8. DROP PROCEDURE
  9. PRAGMA AUTONOMOUS_TRANSACTION
  10. Cursors and Cursor Loops
  11. Array Processing
  12. dbms_metadata.get_data built-in
  13. dbms_output.put_line
  14. Control Structures - IF Statements and Loops


Class 3
  1. CREATE OR REPLACE PACKAGE
  2. CREATE OR REPLACE PACKAGE BODY
  3. ALTER PACKAGE COMPILE
  4. DROP PACKAGE
  5. Package Header
  6. Package Body
  7. Declaring Variables and Constants
  8. Declaring Data Types
  9. Overloading
  10. Public Functions
  11. Public Procedures
  12. Private Functions
  13. Private Procedures
  14. Cursors and Cursor Loops
  15. Array Processing
  16. dbms_metadata.get_data built-in
  17. dbms_output.put_line


Class 4
  1. Initialization Section
  2. Declaring Variables and Constants
  3. Declaring Data Types
  4. Overloading
  5. Public Functions
  6. Public Procedures
  7. Private Functions
  8. Private Procedures
  9. PRAGMA SERIALLY_REUSABLE
  10. DBMS_SESSION.MODIFY_PACKAGE_STATE
  11. DBMS_SESSION.RESET_PACKAGE Operators Keywords & Concepts
  12. CREATE OR REPLACE
  13. BIND statement
  14. COMPILE
  15. DROP
  16. Overloading Exception Handling Keywords & Concepts
  17. EXCEPTION
  18. WHEN OTHERS THEN
  19. Named Exceptions
  20. User Defined Exceptions
  21. PRAGMA EXCEPTION_INIT
  22. RAISE
  23. RAISE_APPLICATION_ERROR
  24. SQLCODE
  25. SQLERRM


Class 5
  1. EXCEPTION
  2. WHEN OTHERS THEN
  3. Named Exceptions
  4. SQLCODE
  5. SQLERRM
  6. User Defined Exceptions
  7. PRAGMA EXCEPTION_INIT
  8. RAISE
  9. RAISE_APPLICATION_ERROR
  10. DBMS_UTILITY.ACTIVE_INSTANCES
  11. DBMS_UTILITY.CURRENT_INSTANCE
  12. DBMS_UTILITY.DB_VERSION
  13. DBMS_UTILITY.FORMAT_CALL_STACK
  14. DBMS_UTILITY.FORMAT_ERROR_BACKTRACE
  15. DBMS_UTILITY.FORMAT_ERROR_STACK
  16. DBMS_UTILITY.IS_CLUSTER_DATABASE
  17. OWA_UTIL.WHO_CALLED_ME


Class 6
  1. DDL Triggers
  2. Dynamic SQL
  3. Instead-Of Triggers
  4. Performance Tuning
  5. System Triggers
  6. Table Triggers
  7. Securing Source Code - WRAP


Class 7
  1. Triggers Enforcing Integrity Constraints
  2. Triggers with Surrogate Keys
  3. Triggers and USER
  4. Triggers and SYSDATE and SYSTIMESTAMP
  5. Triggers and System Security Instead-Of Triggers Keywords & Concepts
  6. Triggers changing the default behavior of DML through a view
  7. Object Views (object-relational database) DDL Event Triggers Keywords & Concepts
  8. BEFORE and AFTER DDL events
  9. ON DATABASE
  10. ON SCHEMA
  11. System Event environment variables System Event Triggers Keywords & Concepts
  12. BEFORE and AFTER System Events
  13. ON DATABASE
  14. ON SCHEMA
  15. SYS_CONTEXT built-in function


Class 8
  1. Native Dynamic SQL
  2. DBMS_SQL
  3. Dynamic SQL and Array Processing
  4. Bind Variables
  5. DBMS_ASSERT
  6. SQL Injection (see Bind Variables)


Class 9
  1. SQL Injection Securing Source Code Keywords & Concepts
  2. WRAP
  3. DBMS_DDL Built-in Package Review Keywords & Concepts
  4. DBMS_ADVANCED_REWRITE
  5. DBMS_ADVISOR.QUICK_TUNE
  6. DBMS_ALERT


Class 10
  1. DBMS_APPLICATION_INFO
  2. DBMS_CRYPTO
  3. DBMS_ERRLOG
  4. DBMS_FEATURE_USAGE
  5. DBMS_FEATURE_USAGE_REPORT
  6. DBMS_RECTIFIER_DIFF
  7. DBMS_REDEFINITION
  8. DBMS_WARNING
  9. OWA_UTIL
  10. UTL_INADDR

 



    Copyright © SQLUniversity.net