DBMS and Java Lab (BCA)

SQL queries on an RDBMS and Java programming practicals.

6 MonthsDuration 6Chapters19Topics

Enquire now

Syllabus · पाठ्यक्रम

Download PDF

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

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)

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.