IBSU-IT0407-2024

Course Overview

Enrol Now

Last Updated On 17 October 2024

16 Downloadable Resources
2 Assignments

Course Content

Start Date: 18/10/24
Category: IBSU Information Technology S3

General

Assessments and Evaluation

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
Course Commencement feedback survey
Mid Semester Student's Survey
Request for Special Consideration

Week1 - Week10: Study Materials

Introduction to the Unit
Label (copy)
Week 1- Introduction to DBMS- Lecture Slides
Topic 1 Introduction to DBMS
Label
Topic:2 Setting up User Accounts Lecture Slides
Topic 2 Setting up User Accounts and Database Objects
Label (copy)
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
Label (copy) (copy)
Topic-4 : Programming Oracle PL/SQL and Stored procedures-Lecture slides
Topic 4 Programming Oracle PL/SQL and Stored procedures
Label (copy) (copy) (copy)
Topic 5: Advanced PL/SQL procedures Lecture Slides
Topic 5 Advanced PL/SQL Procedures
Hands on 5.1
advanced procedures
Label (copy) (copy) (copy) (copy)
Topic6: Database Objects- Functions and Index Lecture Slides
Topic 6 Database Objects- Functions and Indexes
Hands-on PL/SQL Function and Index
Label (copy) (copy) (copy) (copy) (copy)
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

Section 3

Section 4

Enrolment options

IBSU-IT0407-2024-3 Advanced Database Systems

Lecturer: Valli Ramamurthy

Skill Level: Beginner

Guests cannot access this course. Please log in.

Enrol Now

Last Updated On 17 October 2024

16 Downloadable Resources
2 Assignments

Course Features

Lectures5
Quizzes2
Start Date18 Oct 2024
Skill level Beginner
Language English
Assessments Yes

Tags

No Tags.