BCA Database Programming

bcasemester 8Elective

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

semester photo

Chapter Wise Notes Question Banks Syllabus Chapter Wise Questions Viva Practical

Unit 1:Introduction of RDBMS

Overview of the Oracle Database Architecture, Familiar with SQL*Plus, SQL*Plus Commands (DESCRIBE, LIST, APPEND, CHANGE, INPUT, DEL, CLEAR BUFFER, Using Script Files), Accepting Values at Runtime, Overview of Fundamental SQL Fundamental Command (DDL, DML, DCL, Join and Subquery)

Unit 2:PL/SQL

PL/SQL Concepts, Architecture, Block structure, Executing PL/SQL Script, DBMS_OUTPUT.PUT_LINE Statement, substitution Variable feature, PL/SQL Language fundamentals, DML Statement in PL/SQL, Transaction Control in PL/SQL, Conditional Control (if, nested if, Case), Repetitive Control (While, for, simple loop, Nested, continue, loop label)

Unit 3:PL/SQL Exception

Exception scope, user-defined exception, exception propagation, advance exception concepts (RAISE_APPLICATION_ERROR, EXCEPTION_INIT)

Unit 4:Database Cursors

Types of cursors, cursor loop, Nested cursors cursor for loops, parameterized cursors, Nested cursors

Unit 5:Database Triggers

Database Triggers BEFORE, AFTER Triggers, row and statement triggers, INSTEAD OF triggers

Unit 6:Record and procedures

Record (Record types, Nested record), Procedure (Block Structure, Anonymous Block, creating procedure, IN, OUT parameters in Procedure)

Unit 7:Functions and Package

Functions (creating and invoking function and optimizing function in execution), creating packages, extending the package, package instantiation and initialization