Database Management System Lab (B.Sc Computer Science)

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

6 महीनेअवधि 5Chapters20टॉपिक

अभी पूछताछ करें

सिलेबस · पाठ्यक्रम

Download PDF

01DDL Commands 4 टॉपिक

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 टॉपिक

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

03Functions, Grouping and Joins 4 टॉपिक

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

04Subqueries and Views 3 टॉपिक

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

05PL/SQL Basics 5 टॉपिक

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

परिचय

आप यह कर पाएँगे

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

यह किसके लिए है

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

आपको क्या चाहिए

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

सवाल

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.