Database Management Systems Lab (MCA)

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

6 MonthsDuration 6Chapters22Topics

Enquire now

Syllabus · पाठ्यक्रम

Download PDF

01Exp Group 1: DDL and Constraints 3 topics

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 topics

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 topics

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

04Exp Group 4: Subqueries, Views and Indexes 4 topics

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

05Exp Group 5: PL-SQL Programming 4 topics

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 topics

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

About

You will be able to

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

Who it is for

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

What you need

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

Questions

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).