Database Management System Lab (B.Tech)

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

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

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

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

Download PDF

01DDL and Constraints 3 टॉपिक

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 टॉपिक

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 टॉपिक

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 टॉपिक

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

05Triggers 3 टॉपिक

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

06Database Design Mini Project 4 टॉपिक

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

परिचय

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

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

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

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

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

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

सवाल

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.