B.Sc. (Information Technology) PLSQL Practical Syllabus - Mumbai University

This is the FY BSc IT syllabus under NEP 2020, in force from the academic year 2024-25. The University still sets the earlier Choice Based papers alongside it for ATKT candidates, so check which scheme your exam form names before you revise.

Loading syllabus...

Syllabus for PLSQL Practical

Skill enhancement course · Semester 2 · FY BSc IT · 2 credits · 50 marks

Module I

1. PL/SQL Basics- Use of variables, Write executable statement, Interacting with Oracle Server, Create anonymous PL/SQL block,Sequences 2. Control Structure in PL/SQL- Using while loop, Do loop, For loop, Use of GOTO statement 3. Create conditional statement using PL/SQL- Using if statement, Using if else statement, Using elsif ladder, Using case expression. 4. Create cursor in PL/SQL- Implicit cursor, Explicit cursor, Parameterized cursor 5. Collection and Composite Data Types - Working with Collections,Working with Composite Data Types

Module II

1. Creation of Procedures in PL/SQL 2. Functions in PL/SQL 3. Creation of Trigger – Create Row level trigger, Create Statement level trigger, Create instead of trigger 4. Handling exceptions- Creation of user defined exception, Creation of system defined exception 5. Creation of Package in PL/SQL

Text Books

1 Programming with PL/SQL for Beginners , H. Dand, R. Patil and T. Sambare, X –Team
2 Oracle pl/sql Programming ,Feuerstein, S., & Pribyl, B. ," O'Reilly Media, Inc.".
1 Oracle Database PL/SQL Language Reference, 12c Release 1 (12.1) E50727- 04 , Alpern, D., Belden, E., Agrawal, S., Baer, H., Castledine, S., Chang, T., & Yang, M.
2 Oracle PL/SQL for dummies , Rosenblum, M., & Dorsey, P. (2006), John Wiley & Sons.
3 PL/SQL Programming ,Ivan Bayross, BPB

Reproduced from the University of Mumbai syllabus for B.Sc. (Information Technology) 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.

The complete syllabus

This subject is cut from the University circular for its year. Open a document here if you want the whole thing rather than a single subject.

PDF BSc IT SEM I & II (2024 25) NEP NEP 2020 syllabus, in force from 2024-25 Read full PDF Read

PDF BSc IT V & VI 2024 25 Earlier Choice Based syllabus, still set for ATKT candidates Read full PDF Read

PDF SY BSc IT 23 24 Earlier Choice Based syllabus, still set for ATKT candidates Read full PDF Read

BSc IT Syllabus Study Path

Start with the year folder.
Use FYBSc IT, SYBSc IT, or TYBSc IT first so your syllabus check matches the semester you are preparing for.

Check units before opening notes.
Use the syllabus to confirm topics, then open BSc IT notes for the same semester.

Practice after the syllabus check.
Move to BSc IT question papers after reviewing the module scope.

FYBSc IT Syllabus SYBSc IT Syllabus TYBSc IT Syllabus BSc IT Notes BSc IT Papers

Report or request