Still no participant
Still no reviews
Course Objective:
| CO1 | Explain the fundamental concepts and principles of relational databases. (Understand, Remember) |
| CO2 | Apply advanced SQL queries and database normalization techniques. (Apply, Create) |
| CO3 | Describe the principles and architecture of distributed databases. (Understand, Remember) |
| CO4 | Implement and manage relational and distributed database systems. (Apply, Evaluate) |
| CO5 | Analyze and optimize database performance. (Analyze, Evaluate) |
Module 1: Database System Concepts and Data Models (14 Hours)
Practice
o Collect data from different data sources and identify the type of data source
o Installation of MySQL Workbench. Import and export the database into MySQL Workbench
o Create instances of database in MySQL.
o Viewing all databases
o Viewing all Tables in a Database
o Creating Tables (With and Without Constraints)
Module 2: Introduction to Relational Databases (14 Hours)
Practice
o Experiment 1.1: Creating ER Diagrams
o Experiment 1.2: Translating ER Diagrams to Relational Schemas
o Experiment 1.3: Implementing Relational Schemas in MySQL
o Experiment 1.4: Basic SQL Queries (SELECT, INSERT, UPDATE, DELETE)
o Experiment 1.5: Advanced SQL Queries (JOIN, UNION, INTERSECT)
o Experiment 1.6: Using Aggregate Functions in SQL
Module 3: Advanced SQL and Database Normalization (14 Hours)
Practice
o Experiment 2.1: Writing Subqueries in SQL
o Experiment 2.2: Creating and Managing Indexes
o Experiment 2.3: Implementing Views
o Experiment 2.4: Normalizing a Database to 3NF
o Experiment 2.5: Creating Transactions in SQL
o Experiment 2.6: Implementing Concurrency Control Mechanisms
Module 4: Introduction to Distributed Databases (14 Hours)
Practice
o Experiment 3.1: Setting Up a Distributed Database Environment
o Experiment 3.2: Implementing Data Fragmentation
o Experiment 3.3: Configuring Data Replication
o Experiment 3.4: Managing Data Allocation
o Experiment 3.5: Connecting and Querying Distributed Databases
o Experiment 3.6: Ensuring Data Consistency in a Distributed Environment
Module 5: Distributed Database Transactions (14 Hours)
Practice
o Experiment 4.1: Implementing Distributed Transactions
o Experiment 4.2: Applying the Two-Phase Commit Protocol
o Experiment 4.3: Distributed Query Processing
o Experiment 4.4: Optimizing Distributed Queries
o Experiment 4.5: Handling Failures in Distributed Transactions
o Experiment 4.6: Monitoring and Troubleshooting Distributed Transactions
Module 6: Database Performance and Tuning (14 Hours)
Practice
o Experiment 5.1: Analyzing Database Performance Metrics
o Experiment 5.2: Implementing Indexes for Performance Optimization
o Experiment 5.3: Query Optimization Techniques
o Experiment 5.4: Performing Database Tuning
o Experiment 5.5: Monitoring and Troubleshooting Database Performance
o Experiment 5.6: Conducting a Performance Audit
Module 7: Emerging Trends in Databases (14 Hours)
I am text block. Click edit button to change this text. Lorem ipsum dolor sit amet, consectetur adipiscing elit. Ut elit tellus, luctus nec ullamcorper mattis, pulvinar dapibus leo.
I am text block. Click edit button to change this text. Lorem ipsum dolor sit amet, consectetur adipiscing elit. Ut elit tellus, luctus nec ullamcorper mattis, pulvinar dapibus leo.
I am text block. Click edit button to change this text. Lorem ipsum dolor sit amet, consectetur adipiscing elit. Ut elit tellus, luctus nec ullamcorper mattis, pulvinar dapibus leo.
I am text block. Click edit button to change this text. Lorem ipsum dolor sit amet, consectetur adipiscing elit. Ut elit tellus, luctus nec ullamcorper mattis, pulvinar dapibus leo.
I am text block. Click edit button to change this text. Lorem ipsum dolor sit amet, consectetur adipiscing elit. Ut elit tellus, luctus nec ullamcorper mattis, pulvinar dapibus leo.
I am text block. Click edit button to change this text. Lorem ipsum dolor sit amet, consectetur adipiscing elit. Ut elit tellus, luctus nec ullamcorper mattis, pulvinar dapibus leo.
I am text block. Click edit button to change this text. Lorem ipsum dolor sit amet, consectetur adipiscing elit. Ut elit tellus, luctus nec ullamcorper mattis, pulvinar dapibus leo.
I am text block. Click edit button to change this text. Lorem ipsum dolor sit amet, consectetur adipiscing elit. Ut elit tellus, luctus nec ullamcorper mattis, pulvinar dapibus leo.
MANOJ KUMAR PADHI working as Assistant Professor, Dept of CSE, Centurion University of Technology and Management, ODISHA . Interested to work on Machine learning,Advanced Java Programming,Deep Learning. Programming Skill: C Programming Data Structure Object Oriented Programming using C++ Formal Language Automata Theory Python Web Development(HTML,CSS,PHP) Database Management Systems Compilers