🗃️ PDEU DBMS Lab Programs

                           

---

Repository Structure • Getting Started • Project • Contributing • Connect

---

Student Details

• Name: Yashvardhan Jani
• Branch: Computer Science & Engineering (CSE)
• College: Pandit Deendayal Energy University, Gandhinagar, Gujarat, India

Instructors (Professors)

• Lab Instructor: Dr. Kalgi Gandhi
• Theory Lecture Instructor: Dr. Debabrata Swain

Repository Structure

This repository contains SQL files as part of the Database Management Systems Course.

Experiments	Description	Topics Covered	Link
Experiment-01	Data Creation & File Handling	Using Python	🔗View
Experiment-02	DDL Commands	CREATE, ALTER, DROP, TRUNCATE	🔗View
Experiment-03	DML Commands	INSERT, UPDATE, DELETE with constraints NOT NULL, UNIQUE, CHECK	🔗View
Experiment-04	DDL with Data Constraints	PRIMARY KEY, FOREIGN KEY	🔗View
Experiment-05	DCL Commands	GRANT, REVOKE	🔗View
Experiment-06	TCL Commands	COMMIT, ROLLBACK, SAVEPOINT	🔗View
Experiment-07	Aggregate Functions	SUM(), AVG(), COUNT()	🔗View
Experiment-08	Subqueries & Nested Queries	Correlated & Non-correlated Subqueries	🔗View
Experiment-09	Joins & Clauses	All Joins, GROUP BY, HAVING	🔗View
Experiment-10	Stored Procedures, Functions & Triggers	PL/SQL Programming - Data Integrity & Automation	🔗View

• End-Sem Lab Practical Exam

Practical Exam - 2025

Set 01

Set 02

Set 03

Set 04

Lab Exercise Categories

• Data Definition Language (DDL)

  • Table creation and modification
  • Schema design and normalization
  • Index creation and management

• Data Manipulation Language (DML)

  • Data insertion, updating, and deletion
  • Bulk data operations
  • Transaction management

• Data Query Language (DQL)

  • Complex SELECT statements
  • Multi-table joins
  • Aggregate functions and grouping

• Data Control Language (DCL)

  • User access management
  • Grant and revoke permissions
  • Database security implementation

• Transaction Control Language (TCL)

  • Managing transactions
  • Using COMMIT, ROLLBACK and SAVEPOINT
  • Ensuring data consistency and recovery

Technologies & Tools Used

Category	Technologies
Database	MySQL 8.0
Languages	SQL, PL/SQL, Python
Tools	MySQL Workbench, Command Line Interface

Quick Start Guide

1. Clone the repository:

   git clone https://github.com/YashvardhanJani/PDEU-DBMS-LabWork.git
   cd PDEU-DBMS-LabWork

Major Project

DBMS Lab Project - University Management System

A comprehensive database project demonstrates real-world database design, implementation and management principles through building a complete university operations platform.

Learning Outcomes

After completing these lab exercises, you will have mastered:

• Database Design - ER diagrams, normalization, schema design
• SQL Programming - Complex queries, joins, subqueries
• Database Administration - User management, backup/recovery
• Performance Tuning - Index optimization, query optimization
• Data Integrity - Constraints, triggers, stored procedures
• Real-world Applications - Project development and implementation

Contribution

Contributions are welcome! If you have improvements or additional exercises:

1. Fork the repository
2. Create your feature branch (git checkout -b feature/NewExercise)
3. Commit your changes (git commit -m 'Add new SQL exercise')
4. Push to the branch (git push origin feature/NewExercise)
5. Open a Pull Request

---

⭐ Star this repository if you found it helpful! ⭐

💡 "Data is the new oil and databases are the refineries that transform raw information into valuable insights."

---

Connect & Collaborate

• LinkedIn: Connect with me
• Email: [email protected]
• GitHub: @YashvardhanJani

License

This project is licensed under the MIT License - see the LICENSE file for details.

---

Made with ❤️ by Yashvardhan Jani | CSE Student @ PDEU

---

⬆️ Back to Top