Course Content
- Start Date: 1/06/23
- Category: IBSU Information Technology S2
- Announcements
- Unit Information Guide
- Staff Contact Details
- Timetable
- Announcements
- Announcement
- Unit Information Guide
- Staff Contact Details
- Timetable
- quiz
- quiz
quiz- Unit Assessments
- There are four assessments in this unit- Assessm...
- 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%
- Attendance
- Attendance
- Unit Evaluation
- 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
- Revision Test
- Test1
- Test2
- Test3
- Introduction to the Unit
- Label (copy)
- Topic 1 Introduction to DBMS
- Week 1- Introduction to DBMS- Lecture Slides
- Label
- Topic 2 Setting up User Accounts and Database Objects
- Topic:2 Setting up User Accounts Lecture Slides
- Label (copy)
- Topic 3 Database Administration Users, Roles and Permissions
- Topic-3 User Roles and Privileges Lecture Slides
- Activity 3.1 User Roles and Permissions
- Activity 3.2 User Roles and Permissions
- Label (copy) (copy)
- Topic 4 Programming Oracle PL/SQL and Stored procedures
- Topic-4 : Programming Oracle PL/SQL and Stored procedures-Lecture slides
- Label (copy) (copy) (copy)
- Topic 5 Advanced PL/SQL Procedures
- Hands on 5.1
- Topic 5: Advanced PL/SQL procedures Lecture Slides
- Label (copy) (copy) (copy) (copy)
- Topic 6 Database Objects- Functions and Indexes
- Topic6: Database Objects- Functions and Index Lecture Slides
- Hands-on PL/SQL Function and Index
- Label (copy) (copy) (copy) (copy) (copy)
- 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