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.
Exp Group 1: DDL and ConstraintsExp Group 2: DML and Basic QueriesExp Group 3: Functions, Grouping and JoinsExp Group 4: Subqueries, Views and IndexesExp Group 5: PL-SQL ProgrammingExp Group 6: Cursors and Triggers
- 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.
Syllabus · पाठ्यक्रम
1 subject · 6 chapters · 22 topics
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 this course
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)
Online tests & result
Practice and unit tests online; marks and result show in your student login and at the centre.
Student login →
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).
