IBSU-IT0407-2023-2

Course Overview

Enrol Now

Last Updated On 31 May 2023

9 Students Enrolled
21 Downloadable Resources
2 Assignments

Course Content

Start Date: 1/06/23
Category: IBSU Information Technology S2

General

Assessments

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

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-2023-2 Advanced Database Systems

Lecturer: Valli Ramamurthy

Skill Level: Beginner

Guests cannot access this course. Please log in.

Enrol Now

Last Updated On 31 May 2023

9 Students Enrolled
21 Downloadable Resources
2 Assignments

Course Features

Lectures3
Quizzes2
Start Date1 Jun 2023
Skill level Beginner
Language English
Assessments Yes

Tags

No Tags.