Announcements: Welcome to COM390



Download COM 390 Syllabus

Lecture Notes:


How to setup Oracle online account

    1. Lecture 1: Database Fundamentals
    2. Assignment 1: Reading ERD
    3. Assignment 2: Miniworld Travelling
    4. Assignment 3: Library System
    5. Assignment 4: SQL Create Insert
    6. Assignment 5: SQL Create Insert
    7. Assignment 6: SQL Create Insert
    1. SQL: Creating and Modifying Database Tables
    2. SQL Practice 1.1 (CREATE, DROP, INSERT)
    3. SQL Practice 1.2 (UPDATE, SELECT)
    4. Assignment 1: SQL
    5. Assignment 2: SQL
    6. Assignment 3: SQL
    1. Project requirements
    2. Deliverable 2: Proposal
    1. Chapter2: Basic PL/SQL Block Structure
    2. Chapter3: Handling Data in PL/SQL Blocks
    3. Chapter4: Cursors and Exception Handling
    4. Chapter5: Procedures
    5. Chapter6: Functions
    6. Chapter7: Packages
    7. Chapter8: Dependencies Privileges and Compilation
    8. Chapter9: Triggers
librarySQL.zip