Database Management Systems Lab (MCA)

SQL queries, constraints, joins, views, PL-SQL procedures and triggers on a relational database.

6 महीनेअवधि 6Chapters22टॉपिक

अभी पूछताछ करें

सिलेबस · पाठ्यक्रम

Download PDF

01Exp Group 1: DDL and Constraints 3 टॉपिक

CREATE, ALTER, DROP and TRUNCATE
Primary key, foreign key, unique, check and not null
Describing table structure

02Exp Group 2: DML and Basic Queries 3 टॉपिक

INSERT, UPDATE and DELETE
SELECT with WHERE, ORDER BY, LIKE, IN and BETWEEN
COMMIT, ROLLBACK and SAVEPOINT

03Exp Group 3: Functions, Grouping and Joins 4 टॉपिक

Aggregate functions
GROUP BY and HAVING
Inner, outer, self and cross joins
String and date functions

04Exp Group 4: Subqueries, Views and Indexes 4 टॉपिक

Single-row and multi-row subqueries
Correlated subqueries
Creating and using views
Creating indexes and sequences

05Exp Group 5: PL-SQL Programming 4 टॉपिक

PL-SQL block structure and variables
Conditions and loops
Stored procedures and functions
Exception handling in PL-SQL

06Exp Group 6: Cursors and Triggers 4 टॉपिक

Implicit and explicit cursors
Cursor FOR loop
Row-level and statement-level triggers
Audit trigger on salary update

परिचय

आप यह कर पाएँगे

Create tables with primary key, foreign key, unique, check and not-null constraints
Insert, update and delete data and write single-table queries
Write queries with aggregate functions, GROUP BY, HAVING and joins
Use subqueries, views and indexes
Write PL-SQL blocks, stored procedures and functions
Create cursors and triggers for business rules

यह किसके लिए है

MCA students of Semester 2 (AKTU, Lucknow)
Students who want hands-on SQL practice for placements and projects

आपको क्या चाहिए

Database Management Systems theory (studied alongside)
Lab computer with Oracle / MySQL (provided at the centre)

सवाल

Which syllabus does this Database Management Systems Lab course follow?

It follows the AKTU (Lucknow) MCA syllabus for Semester 2. If your own university's syllabus differs, the centre follows your university's syllabus and unit order.

What happens in the lab exam?

You perform one or two experiments given by the examiner, show the output, submit the lab record and answer viva questions.

Oracle or MySQL?

The centre uses the database your college uses. SQL is mostly the same; PL-SQL experiments are done on Oracle (or MySQL stored procedures).