Your roadmap · आपका रोडमैप
- 1
Admission & first meetingप्रवेश और पहली मुलाकातEnquire at your nearest NDSS centre, meet the teacher, fix the batch time and get your study material.
- 2
Work planकार्य योजनाStep by step with your guide / trainer.
DDL and ConstraintsDML and QueriesJoins, Sub-queries and ViewsPL-SQL: Procedures, Functions and CursorsTriggersDatabase Design Mini Project
- 3
File, report & vivaफ़ाइल, रिपोर्ट और वाइवाPractical file / report checked, mock viva before the final one.
- 4
Online tests & resultऑनलाइन टेस्ट और रिज़ल्टTake the tests online; your marks and result show in your student login and at the centre.
सिलेबस · पाठ्यक्रम
1 subject · 6 chapters · 24 topics
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
About this course
आप यह कर पाएँगे
- 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)
Online tests & result
Practice and unit tests online; marks and result show in your student login and at the centre.
Student login →
सवाल
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.
