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: SQL - DDL and DMLExp Group 2: SQL QueriesExp Group 3: Java BasicsExp Group 4: OOP in JavaExp Group 5: Exceptions, Threads and GUIExp Group 6: JDBC
- 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 · 19 topics
01Exp Group 1: SQL - DDL and DML
3 topics+
- CREATE, ALTER, DROP, TRUNCATE
- Constraints - PRIMARY KEY, FOREIGN KEY, NOT NULL, CHECK, UNIQUE
- INSERT, UPDATE, DELETE
02Exp Group 2: SQL Queries
4 topics+
- SELECT with WHERE, ORDER BY, LIKE, BETWEEN
- Aggregate functions, GROUP BY and HAVING
- Joins - inner, left, right
- Sub-queries and views
03Exp Group 3: Java Basics
3 topics+
- Compiling and running Java programs
- Arrays and strings
- Command-line arguments
04Exp Group 4: OOP in Java
3 topics+
- Classes and constructors
- Inheritance and method overriding
- Interfaces and packages
05Exp Group 5: Exceptions, Threads and GUI
3 topics+
- try-catch-finally and user-defined exceptions
- Creating threads
- Simple Swing form with event handling
06Exp Group 6: JDBC
3 topics+
- Loading the driver and connecting
- Inserting records with PreparedStatement
- Displaying records from a ResultSet
About this course
You will be able to
- Create tables with constraints and manipulate data using SQL
- Write SQL queries with joins, sub-queries, GROUP BY and HAVING
- Write Java programs using classes, inheritance, interfaces and exceptions
- Write multithreaded and GUI programs in Java
- Connect a Java program to MySQL using JDBC to insert and display records
Who it is for
- BCA students of Semester 5 (UP state universities, Lucknow University pattern)
- Students who want hands-on SQL and Java practice for placements
What you need
- DBMS and Java theory (studied alongside)
- Lab computer with MySQL and JDK (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 DBMS and Java Lab course follow?
It follows the common UP state university BCA syllabus (University of Lucknow pattern) for BCA Semester 5. If your own university's syllabus differs, the centre follows your university's syllabus and unit order.
How is the lab exam conducted?
Usually one SQL task and one Java program, plus the practical file and viva.
Can I practise at home?
Yes. MySQL Community Server and the JDK are free; the trainer helps you install both.
