Database Management System Lab (B.Tech)

SQL queries, PL-SQL, views, triggers and database design exercises.

6 MonthsDuration 6Chapters24Topics

Enquire now

Syllabus · पाठ्यक्रम

Download PDF

01DDL and Constraints 3 topics

CREATE, ALTER, DROP, TRUNCATE and RENAME
Primary key, foreign key, unique, not null, check and default
Creating a student-course database

02DML and Queries 4 topics

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

03Joins, Sub-queries and Views 5 topics

Inner, left, right and full outer joins
Self join
Nested and correlated sub-queries
UNION, INTERSECT and MINUS
Creating and using views and indexes

04PL-SQL: Procedures, Functions and Cursors 5 topics

PL-SQL block structure and variables
Conditional and loop statements
Stored procedures and functions
Explicit cursors and cursor attributes
Exception handling

05Triggers 3 topics

Row-level and statement-level triggers
BEFORE and AFTER triggers
Audit trigger for salary updates

06Database Design Mini Project 4 topics

ER diagram for a library / hospital / college system
Reducing ER to tables
Normalising to 3NF
Writing queries for reports

About

You will be able to

Create tables with primary key, foreign key, unique, not null and check constraints
Write SQL queries with WHERE, ORDER BY, GROUP BY, HAVING and aggregate functions
Use joins, nested queries, set operations and views
Write PL-SQL blocks, procedures, functions and cursors
Create triggers for auditing and validation
Design and normalise a small database from an ER diagram

Who it is for

B.Tech Computer Science & Engineering, Information Technology students of Semester 5 (AKTU)
Students of other universities studying the same subject who want unit-wise coaching

What you need

Database Management System theory of the same semester
MySQL or Oracle installed (the centre helps with setup)

Questions

Which syllabus does the Database Management System Lab course follow?

It follows the AKTU (Dr. A.P.J. Abdul Kalam Technical University, Lucknow) B.Tech syllabus for Database Management System Lab. If your own university's syllabus differs, the centre follows your university syllabus.

Will this help in the university examination?

Yes. Teaching is unit-wise as per the AKTU scheme, with previous-year question practice, MCQ tests and doubt sessions before the semester exam.

Which database software is used?

MySQL (with MySQL Workbench) and Oracle Live SQL / Oracle XE; PL-SQL is practised on Oracle as in the AKTU lab list.