IBSU-IT0407-2022-2

Course Overview

Enrol Now

Last Updated On 23 June 2022

5 Students Enrolled
18 Downloadable Resources
2 Assignments

Course Content

Start Date: 26/06/22
Category: IBSU Information Technology S2

General

Assessments

Unit Assessments
There are five assessments in this unit- Assessm...
Assessment 1 Quiz1 5%
Assessment 2 Table structure, queries and output 15%
Assessment 3: Quiz2 5%
Assessment 4 Table structure, queries and output(advanced) 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

Study Materials

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

Enrolment options

IBSU-IT0407-2022-2 Advanced Database Systems

Skill Level: Beginner

Guests cannot access this course. Please log in.

Enrol Now

Last Updated On 23 June 2022

5 Students Enrolled
18 Downloadable Resources
2 Assignments

Course Features

Lectures3
Quizzes2
Start Date26 Jun 2022
Skill level Beginner
Language English
Assessments Yes

Tags

No Tags.