Advanced Database

Explores complex database concepts and technologies. It covers query optimization, advanced indexing, transaction management, and modern database systems for high-performance applications.

Database Programming

Course Title: Database Programming

Course No: CACS453

Nature of the Course: Theory + Lab

Semester: 8

Full Marks: 20 + 20 + 60

Pass Marks: 8 + 8 + 24

Credit Hours: 3

Course Description

This course provides the comprehensive knowledge about database programming in relational database management system, which encompasses with overview of fundamental SQL statement, PL/SQL Block, Exception, Cursors, Record, Triggers, Procedures, Functions and Packages.

Course Objectives

Upon the conclusion of the course, students should be able to: - Enhance advance programming skills in relational database management system

Course Contents

1. Unit 1: Introduction of RDBMS

10 hrs

1.1. Overview of the Oracle Database Architecture

1.2. Familiar with SQL*Plus

1.3. SQL*Plus Commands (DESCRIBE, LIST, APPEND, CHANGE, INPUT, DEL, CLEAR BUFFER, Using Script Files)

1.4. Accepting Values at Runtime

1.5. Fundamental Command (DDL, DML, DCL, Join and Subquery)

2. Unit 2: PL/SQL

13 hrs

2.1. PL/SQL Concepts, Architecture, Block structure

2.2. Executing PL/SQL Script

2.3. DBMS_OUTPUT.PUT_LINE Statement

2.4. substitution Variable feature

2.5. PL/SQL Language fundamentals

2.6. DML Statement in PL/SQL

2.7. Transaction Control in PL/SQL

2.8. Conditional Control (if, nested if, Case)

2.9. Repetitive Control (While, for, simple loop, Nested, continue, loop label)

3. Unit 3: PL/SQL Exception

5 hrs

3.1. Exception scope

3.2. user-defined exception

3.3. exception propagation

3.4. advance exception concepts (RAISE_APPLICATION_ERROR, EXCEPTION_INIT)

4. Unit 4: Database Cursors

5 hrs

4.1. Types of cursors

4.2. cursor loop

4.3. Nested cursors

4.4. cursor for loops

4.5. parameterized cursors

4.6. Nested cursors

5. Unit 5: Database Triggers

5 hrs

5.1. Database Triggers BEFORE, AFTER Triggers

5.2. row and statement triggers

5.3. INSTEAD OF triggers

6. Unit 6: Record and procedures

5 hrs

6.1. Record (Record types, Nested record)

6.2. Procedure (Block Structure, Anonymous Block, creating procedure, IN, OUT parameters in Procedure)

7. Unit 7: Functions and Package

5 hrs

7.1. Functions (creating and invoking function and optimizing function in execution)

7.2. Packages, extending the package, package instantiation and initialization

Laboratory Works

Laboratory works should be done covering all the topics listed above and a small work should be carried out using the concept learnt in each unit in individual or group.

1.Laboratory Works

Text Books

1.Benjamin Rosenzweig, E. R. (2015). Oracle PL/SQL by Example. New York: Prentice Hall.
2.Gupta, S. K. (2016). Advanced Oracle PL/SQL Developer's Guide. Birmingham: Packt Publishing.

Reference Books

1.Lex de Haan, T. G. (2014). Beginning Oracle SQL. Apress.
2.McLaughlin, M. (2014). Oracle Database 12c PL/SQL Programming. New Delhi: McGrawHill Education.

Notes:

This syllabus follows the official BCA curriculum of Pokhara University. In case of any doubt or revision, the university's published syllabus shall be considered authoritative.

Advanced Database

Advanced Database

Select University

Select Program

TabFlux . Database Programming . TU . BCA-OLD

Database Programming

Course Description

Course Objectives

Course Contents

Laboratory Works

Text Books

Reference Books

Notes:

Select University

Select Program

TabFlux . Database Programming . TU . BCA-OLD

Database Programming

Course Description

Course Objectives

Course Contents

Laboratory Works

Text Books

Reference Books

Notes: