Overview

This lab is dedicated for students to work on practical experiments, projects and research work, related to courses such as Database Management Systems, Distributed Data Computing, Hadoop, Data Warehousing and Mining, and Big Data Analysis.

Students gain hands-on experience with both traditional relational databases and modern big data technologies through practical implementation and research projects.

Primary Course

Course Details

Name: Database Management Systems Lab
Course ID: CS212
Programme: B.Tech.
Semester: IV Semester
Credits: 0-0-3-3 (L-T-P-C)
Department: Computer Science and Engineering

Course Objectives

Understand practical applicability of DBMS concepts
Work on existing database systems
Design and create relational databases
Learn advanced concepts like Data Mining and Big Data Analysis

Course Outcomes

Design and create relational database systems
Execute advanced queries (constraints, joins, triggers, views, embedded SQL)
Use software for ER Diagrams, UML, Flow charts
Design and implement database applications independently

Research Activities

Big Data Technologies

Hadoop ecosystem research
Distributed database systems
Data warehousing and mining
Scalable data processing frameworks

Lab Infrastructure

Database Systems

Oracle Database
MySQL, PostgreSQL
MongoDB, Cassandra
Redis, Neo4j

Big Data Tools

Hadoop Ecosystem
Spark, Hive, Pig
Kafka, Flink
Elasticsearch

Development Tools

Database design tools
ETL tools
Data visualization software
Version control systems

Faculty In Charge

Dr. Dilip Kumar Choubey

Assistant Professor

Lab Technician

Mr. Love Panday

Junior Technical Superintendent