Overview

An "Introduction to Database Management Systems (DBMS)" This course provides an introduction to the fundamental principles and practices of database management systems. Topics covered include database design, data modeling, SQL, normalization, indexing, transaction management, concurrency control, and database security. The teaching methodology adopted throughout the course is holistic, incorporating lectures, hands-on exercises, and real-world case studies. This approach ensures that students not only grasp theoretical concepts but also develop the practical skills necessary for success in the field. The utilization of industry-standard databases and tools provides students with exposure to the technologies prevalent in the industry, enhancing their readiness for real-world applications. Evaluation and grading are structured to assess various facets of student performance. Quizzes and assignments gauge theoretical understanding, class participation ensures engagement and comprehensive assessment of practical skills. This multifaceted evaluation approach ensures that students are not only well-versed in theoretical concepts but also proficient in applying them to solve real world problems.

Syllabus

Publishing Week Video Title Week-1 Introduction to Databases and their importance, Evolution of Database Systems Types of Databases: Relational, NoSQL Components of DBMS: Data Definition Language (DDL), Data Manipulation Language (DML), etc. Week-2 Introduction to SQL: SELECT, INSERT, UPDATE, DELETE Filtering Data: WHERE clause, AND/OR conditions-I Filtering Data: WHERE clause, AND/OR conditions-II Week-3 Data Defination Language (DDL): Alter, Drop, Truncate I Data Defination Language (DDL): Alter, Drop, Truncate II Sorting and Aggregating Data: ORDER BY, GROUP BY, Aggregate Functions-I Sorting and Aggregating Data: ORDER BY, GROUP BY, Aggregate Functions-II Week-4 Entities, Attributes, and Relationships in the Relational Model-I Entities, Attributes, and Relationships in the Relational Model-II Primary and Foreign Keys: Ensuring Data Integrity and other different types of constraints-I Primary and Foreign Keys: Ensuring Data Integrity and other different types of constraints-II Week-5 Joins in SQL: INNER JOIN, LEFT JOIN, RIGHT JOIN Subqueries and Derived Tables Modifying Data: INSERT INTO...VALUES, UPDATE...SET, DELETE Views, Stored Procedures, and Functions in SQL Week-6 Database Design Process: Requirements Analysis, Conceptual, Design, Logical Design, Physical Design, Introduction to Normalization: First Normal Form (1NF) and Second Normal Form (2NF) Third Normal Form (3NF), Boyce-Codd Normal Form (BCNF), Fourth Normal Form (4NF), Denormalization and its use cases Week-7 Introduction to Indexing, Types of Indexes: B-Tree, Query Optimization Techniques Query Execution Plans and Cost Estimation Week-8 Introduction to Transactions, ACID Properties o Transactions Concurrency Control: Locking, Two-Phase Locking, Timestamp Ordering Deadlocks and Transaction Isolation Levels Week-9 Introduction to Database Security, Authentication and Authorization Access Control: Grant and Revoke Statements, Database Auditing and Encryption-I Access Control: Grant and Revoke Statements, Database Auditing and Encryption-II Week-10 Introduction to NoSQL Databases, Types of NoSQL Databases: Document, Key Value, Column-Family, Graph Overview of MongoDB and Cassandra Introduction to Data Warehousing and OLAP Week-11 Data Integration Concepts, Extract, Transform, Load (ETL) Processes, ETL Tools and Techniques Data Warehousing Architectures Week-12 Introduction to Big Data , Challenges and Opportunities in Big Data Management, Distributed Database Systems, Scalability and Consistency in Distributed Databases