B.Sc. (Computer Science) Database Management Systems Using PL SQL Syllabus - Mumbai University
This is the FY BSc Computer Science syllabus under NEP 2020, in force from the academic year 2024-25. The University still sets the earlier Choice Based papers alongside it — her Summer 2026 third-year timetables name that scheme — so check which scheme your exam form names before you revise.
Loading syllabus...
Syllabus for Database Management Systems Using PL SQL
Module I
- Overview of PL/SQL: Advantages of PL/SQL, Main Features of PL/SQL, Architecture of PL/SQL
- Fundamentals of PL/SQL: Character Sets, Lexical Units, Declarations, References to Identifiers, Scope and Visibility of Identifiers, Assigning Values to Variables, Expressions, Error-Reporting Functions, Data Types., Control Statements: Conditional Selection Statements, LOOP Statements, Sequential Control Statements, GOTO, and NULL Statements.
- Sequences: creating sequences, referencing, altering, and dropping a sequence.
- Stored Procedures and Functions: Procedures: Types and benefits of stored procedures, creating stored procedures, executing stored procedures, altering stored procedures, viewing stored procedures. Functions: Calling function and recursion function.
- Collections and Records: Associative Arrays, Varrays (Variable-Size Arrays), Nested Tables, Collection Constructors, Assigning Values to Collection Variables, Multidimensional Collections, Collection Comparisons, Collection Methods, Collection Types Defined in Package Specifications, Record Variables, Assigning Values to Record Variables.
- Error Handling: Compile-Time Warnings, Overview of Exception Handling, Internally Defined Exceptions, Predefined Exceptions, User- Defined Exceptions, Redeclared Predefined Exceptions, Raising Exceptions Explicitly, Exception Propagation, Unhandled Exceptions.
Module II
- Cursors: Overview of Cursor, Types of cursors, Invalid cursor Exception.
- Static SQL: Description of Static SQL, Cursors Overview, Processing Query Result Sets, Cursor Variables, CURSOR Expressions,
- Transaction Processing and Control: Autonomous Transactions, Commit Protocol, Concurrency Control, Lock Management, Read-Write Locks, Deadlocks Handling,
- Dynamic SQL: Native Dynamic SQL, DBMS_SQL Package, SQL Injection.
- Triggers: Overview of Triggers, implementing triggers – creating triggers, Insert, delete, and update triggers, nested triggers, viewing, deleting, and modifying triggers, enforcing data integrity through triggers.
- Packages: Overview of a Package. Need of Packages, Package Specification, Package Body, Package Instantiation, and Initialization. Create nested tables and work with nested tables.
Text Books
- 1 Mastering PL/SQL Through Illustrations: From Learning Fundamentals to Developing Efficient PL/SQL Blocks, Dr. B. Chandra, BPB Publication, 2020
- 2 Oracle Pl/SQL Training Guide., Training guide, BPB Publications, 2016
- 3 Raghu Ramakrishnam, Gehrke, Database Management Systems, McGraw‐ Hill,3rd Edition, 2014
- 4 Abraham Silberschatz, Henry F. Korth,S. Sudarshan , Database System Concepts, 6th Edition 2019
- 1 Ivan Bayross, SQL, PL/SQL -The Programming language of Oracle, B.P.B. Publications 2009
- 2 Ramez Elmasri & Shamkant B.Navathe, Fundamentals of Database Systems, Pearson Education, 2008
Reproduced from the University of Mumbai syllabus for B.Sc. (Computer Science) under NEP 2020, in force from the academic year 2024-25. Wording is as printed in that syllabus. Module numbering is as printed there too.