Top Private Engineering Colleges in India

Database Management System Lab

A database management system (DBMS) is a computer software application that interacts with the user, other applications, and the database itself to capture and analyze data. A general-purpose DBMS is designed to allow the definition, creation, querying, update, and administration of databases. Well-known DBMSs include MySQL, PostgreSQL, MongoDB, Microsoft SQL Server, Oracle, Sybase, SAP HANA, and IBM DB2.

Sr. No.Name of PracticalSoftware and Hardware RequiredIcon
1Write the queries for Data Definition and Data Manipulation Language.Developer 2000/Oracle9i/SQL SERVER or DB2
2Write SQL queries using logical operations (=,<,>,etc)Developer 2000/Oracle9i/SQL SERVER or DB2
3Write SQL queries using SQL operatorsDeveloper 2000/Oracle9i/SQL SERVER or DB2
4Write SQL query using character, number, date and group functionsDeveloper 2000/Oracle9i/SQL SERVER or DB2
5Write SQL queries for relational algebraDeveloper 2000/Oracle9i/SQL SERVER or DB2
6Write SQL queries for extracting data from more than one tableDeveloper 2000/Oracle9i/SQL SERVER or DB2
7Write SQL queries for sub queries, nested queriesDeveloper 2000/Oracle9i/SQL SERVER or DB2
8Write programme by the use of PL/SQLDeveloper 2000/Oracle9i/SQL SERVER or DB2
9Concepts for ROLL BACK, COMMIT & CHECK POINTSDeveloper 2000/Oracle9i/SQL SERVER or DB2
10Create VIEWS, CURSORS and TRGGERS & write ASSERTIONSDeveloper 2000/Oracle9i/SQL SERVER or DB2
11Create FORMS and REPORTSDeveloper 2000/Oracle9i/SQL SERVER or DB2

Paste your AdWords Remarketing code here