IBS
  • IBSU-IT0407-2024-2 Advanced Database Systems
    0%
  • Previous
  • Course data
    General
    Announcement
    Unit Information Guide
    Staff Contact Details
    Timetable
    Announcements
    Assessments and Evaluation
    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%
    Course Commencement feedback survey
    Mid Semester Student's Survey
    End Semester Survey
    Request for Special Consideration
    Week1 - Week10: Study Materials
    Introduction to the Unit
    Week 1- Introduction to DBMS- Lecture Slides
    Topic 1 Introduction to DBMS
    Topic:2 Setting up User Accounts Lecture Slides
    Topic 2 Setting up User Accounts and Database Objects
    Topic-3 User Roles and Privileges Lecture Slides
    Topic 3 Database Administration Users, Roles and Permissions
    Activity 3.1 User Roles and Permissions
    Activity 3.2 User Roles and Permissions
    Topic-3 hands on
    Topic-4 : Programming Oracle PL/SQL and Stored procedures-Lecture slides
    Topic 4 Programming Oracle PL/SQL and Stored procedures
    Topic 5: Advanced PL/SQL procedures Lecture Slides
    Topic 5 Advanced PL/SQL Procedures
    Hands on 5.1
    advanced procedures
    Topic6: Database Objects- Functions and Index Lecture Slides
    Topic 6 Database Objects- Functions and Indexes
    Hands-on PL/SQL Function and Index
    Topic-7-Database Objects_triggers and Packages- Lecture Slides
    Topic 7 Triggers and packages
    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-2024
    Home
    Skip to main content

    Course info

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

    IBSU-IT0407-2024-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