IBS
  • IBSU-IT0407-2023-2 Advanced Database Systems
    0%
  • Previous
  • Course data
    General
    Announcements
    Unit Information Guide
    Staff Contact Details
    Timetable
    Announcements
    Announcement
    Unit Information Guide
    Staff Contact Details
    Timetable
    Assessments
    Assessment 1 Quiz1 5%
    Assessment 2 Table structure, writing queries and generating report- 15%
    Assessment 1: Quiz2 5%
    Assessment 3 Table structure, writing advanced queries and generating reports 25%
    Lecturer Evaluation Week 6 - Advanced Database Systems
    Lecturer Evaluation Week 11 - Advanced Database Systems
    Unit Survey Week 8-13 - Advanced Database Systems
    Request for Special Consideration
    Test1
    Test2
    Test3
    Study Materials
    Introduction to the Unit
    Topic 1 Introduction to DBMS
    Week 1- Introduction to DBMS- Lecture Slides
    Topic 2 Setting up User Accounts and Database Objects
    Topic:2 Setting up User Accounts Lecture Slides
    Topic 3 Database Administration Users, Roles and Permissions
    Topic-3 User Roles and Privileges Lecture Slides
    Topic 4 Programming Oracle PL/SQL and Stored procedures
    Topic-4 : Programming Oracle PL/SQL and Stored procedures-Lecture slides
    Topic 5 Advanced PL/SQL Procedures
    Topic 5: Advanced PL/SQL procedures Lecture Slides
    Topic 6 Database Objects- Functions and Indexes
    Topic6: Database Objects- Functions and Index Lecture Slides
    Topic 7 Triggers and packages
    Topic-7-Database Objects_triggers and Packages- Lecture Slides
    IT0407-Topic8-Building Forms -Lecture Slides
    IT0407-Topic9-Reports-Lecture Slides
    IT0407-Topic10-Database performance and Query optimization -Lecture Slides
  • Next
  IBS
  • Essentials
    my Future Academic Policy IBS Library e-Mail
  • IBS Moodle Guide
    Login to IBS Moodle IBS Moodle Dashboard
    Interacting with Assignment for Students Turnitin Assignment 2 for Students
    Interacting with Forum Activity
    Taking a quiz and viewing results
    Workshop Activity Phases for Students
    Contribute to a Wiki document
  • Quality Assurance
    • Log in
    IBSU-IT0407-2023-2
    Home
    Skip to main content

    Course info

    1. Home
    2. Courses
    3. 2023
    4. IBSU
    5. School of Information Technology
    6. IBSU Information Technology S2
    7. IBSU-IT0407-2023-2
    8. Summary

    IBSU-IT0407-2023-2 Advanced Database Systems

    • Lecturer: Valli Ramamurthy
    Skill Level: Beginner

    Digital Learning Services and Classroom Technology

    Phone: (+675) 74114100

    Email: digital.learning@ibs.ac.pg

    IBSU Mt. Eriama Campus

    Portion 1553,​
    Sogeri Road,​ 11 Mile,​ NCD,​ 111,​
    Papua New Guinea

    Phone: (+675) 74114100

    Email: ask@ibs.ac.pg


    IBS Saraga Campus

    Section 57, Lot 10​
    Magila Street,​ 6 Mile,​ NCD,​ 111,​
    Papua New Guinea​

    Email: ask@ibs.ac.pg

    Follow Us

    • Essentials
      • my Future
      • Academic Policy
      • IBS Library
      • e-Mail
    • IBS Moodle Guide
      • Login to IBS Moodle
      • IBS Moodle Dashboard
      • Interacting with Assignment for Students
      • Turnitin Assignment 2 for Students
      • Interacting with Forum Activity
      • Taking a quiz and viewing results
      • Workshop Activity Phases for Students
      • Contribute to a Wiki document
    • Quality Assurance
    Copyright © 2021 IBUniversity. All Rights Reserved.
    Powered by Edwiser RemUI
    You are not logged in. (Log in)
    Data retention summary
    Get the mobile app
    Policies