DBMS Practicals

Here you go!
These are all the DBMS Practicals .

Practical 1
To study any two open source and commercial Relational database management system(Open source-MySQL, PostgreSQL, Commercial - SQL Server, Oracle)
Practical 2
To study and draw a ER(entity representation) diagram

Practical 3
To implement DML & DCL SQL queries

Practical 4
To study different types of SQL constraints and implement them

Practical 5
To implement set operations , string operations and aggregate functions

Practical 6
SQL queries to implement Group by and Having clause

Practical 7
SQL queries to implement basic subquery, Subquery with WHERE clause, Subquery in SELECT clause, Subquery with EXISTS , Subquery with aggregates, Subquery with Multiple Conditions

Practical 8
Understanding and Utilizing Views in SQL for Efficient Data Management

Practical 9
SQL Queries to study joins in SQL.

Demo Practical
In this pdf you'll get a demo PDF about the format of experiments

© Class Comp C | All Rights Reserved.