Database Management System Lab (B.Sc Computer Science)

Creating and querying databases using SQL and simple PL-SQL.

6 MonthsDuration 5Chapters20Topics

Enquire now

Syllabus · पाठ्यक्रम

Download PDF

01DDL Commands 4 topics

CREATE TABLE with data types
Constraints: PRIMARY KEY, FOREIGN KEY, UNIQUE, NOT NULL, CHECK
ALTER, DROP and TRUNCATE
DESCRIBE a table

02DML and Simple Queries 4 topics

INSERT, UPDATE and DELETE
SELECT with WHERE, ORDER BY, DISTINCT
LIKE, BETWEEN, IN and NULL handling
COMMIT and ROLLBACK

03Functions, Grouping and Joins 4 topics

Aggregate functions
GROUP BY and HAVING
Inner join
Left, right and full outer joins

04Subqueries and Views 3 topics

Single-row and multi-row subqueries
Correlated subqueries
Creating and using views

05PL/SQL Basics 5 topics

Structure of a PL/SQL block
Conditions and loops
Cursors
Procedures and functions
Triggers

About

You will be able to

Create, alter and drop tables with primary key, foreign key, unique, not null and check constraints
Insert, update and delete records and write SELECT queries with conditions and sorting
Use aggregate functions, GROUP BY, HAVING and joins
Write subqueries and create views
Write simple PL/SQL blocks, procedures and triggers

Who it is for

B.Sc Computer Science students of Semester 2 (UP State Universities NEP 2020 common minimum syllabus)
Students preparing for the university practical exam and viva

What you need

Studying the theory paper Database Management System
MySQL or Oracle installed (the centre's lab can be used)

Questions

Which syllabus does this course follow?

It follows the UP State Universities NEP 2020 common minimum syllabus for B.Sc Computer Science, Semester 2. Where your own university's syllabus differs, the centre follows your university's syllabus and question pattern.

Is MySQL or Oracle taught?

Both are similar for SQL. The centre uses the one your university practical exam uses.

How are the practicals marked?

The trainer watches each experiment and marks it on a rubric; the viva questions here prepare you for the university practical exam.