0
(
ratings
)
1
students
Created by:
Last updated:
September 25, 2023
Duration:
Unlimited Duration
FREE
This course includes:
Unlimited Duration
Badge on Completion
Certificate of completion
Unlimited Duration
Description
Fundamentals of Database Systems. Instructor: Dr. Arnab Bhattacharya, Department of Computer Science and Engineering, IIT Kanpur. Databases are at the core of all successful digital systems.
The course will introduce the basics of database systems. In addition to the traditional relational database systems, it will also introduce briefly the new paradigm of NoSQL databases used in big data systems. The topics will cover all important aspects including normalization, query processing and transactions. (from nptel.ac.in)
Course Curriculum
- Lecture 01 – Introduction to Databases Unlimited
- Lecture 02 – Relational Data Model Unlimited
- Lecture 03 – Relational Algebra: Basic Operators – Select, Project, Union, Set Difference Unlimited
- Lecture 04 – Relational Algebra: Composition of Operators Unlimited
- Lecture 05 – Relational Algebra: Additional Operators – Set Intersection, Join, Division Unlimited
- Lecture 06 – Extended Relational Algebra – Generalized Projection, Aggregation, Outer Join Unlimited
- Lecture 07 – Relational Algebra: Database Modifications – Deletion, Insertion, Updating Unlimited
- Lecture 08 – SQL (Structured Query Language): Introduction and Data Definition Unlimited
- Lecture 09 – SQL: Basic Queries Unlimited
- Lecture 10 – SQL: Advanced Queries Unlimited
- Lecture 11 – SQL: Updates, Joins, Views and Triggers Unlimited
- Lecture 12 – Normalization Theory: Motivation Unlimited
- Lecture 13 – Normalization Theory: 1NF and 2NF Unlimited
- Lecture 14 – Normalization Theory: 3NF Unlimited
- Lecture 15 – Normalization Theory: BCNF Unlimited
- Lecture 16 – Normalization Theory: MVD (Multi-Valued Dependency) Unlimited
- Lecture 17 – Physical Design: Physical Storage Medium Unlimited
- Lecture 18 – Database Indexing: Hashing Unlimited
- Lecture 19 – Database Indexing: Tree-Based Indexing Unlimited
- Lecture 20 – Query Processing: Selection Unlimited
- Lecture 21 – Query Processing: Sorting Unlimited
- Lecture 22 – Query Processing: Nested-Loop Joins and Merge Join Unlimited
- Lecture 23 – Query Processing: Hash Join and Other Operations Unlimited
- Lecture 24 – Query Optimization: Equivalent Expressions and Simple Equivalence Rules Unlimited
- Lecture 25 – Query Optimization: Complex Equivalence Rules Unlimited
- Lecture 26 – Query Optimization: Join Order Unlimited
- Lecture 27 – Query Optimization: Heuristics and Sizes Unlimited
- Lecture 28 – Database Transactions: Properties and Failures Unlimited
- Lecture 29 – Database Transactions: States and Systems Unlimited
- Lecture 30 – Recovery Systems: Deferred Database Modification Unlimited
- Lecture 31 – Recovery Systems: Immediate Database Modification Unlimited
- Lecture 32 – Recovery Systems: Checkpointing and Shadow Paging Unlimited
- Lecture 33 – Transaction Schedules: Introduction Unlimited
- Lecture 34 – Transaction Schedules: Conflict Serializability Unlimited
- Lecture 35 – Transaction Schedules: View Serializability Unlimited
- Lecture 36 – Transaction Schedules: Result Equivalence and Testing for Serializability Unlimited
- Lecture 37 – Transaction Schedules: Recoverability Unlimited
- Lecture 38 – Concurrency Control: Locks Unlimited
- Lecture 39 – Concurrency Control: Two-phase Locking Protocol Unlimited
- Lecture 40 – Concurrency Control: Timestamp Ordering Protocol Unlimited
- Lecture 41 – Concurrency Control: Validation-based Protocol Unlimited
- Lecture 42 – Concurrency Control: Multiple Granularity for Locks Unlimited
- Lecture 43 – Concurrency Control: Deadlock Prevention and Deadlock Detection Unlimited
- Lecture 44 – Concurrency Control: Deadlock Recovery and Update Operations Unlimited
- Lecture 45 – NoSQL: Introduction and Properties Unlimited
- Lecture 46 – NoSQL: Columnar Families Unlimited
- Lecture 47 – NoSQL: Different NoSQL Systems Unlimited
- Lecture 48 – Big Data Unlimited
About the instructor
5
5
Instructor Rating
6
Reviews
4637
Courses
24154
Students
OpenCoursa
We are an educational and skills marketplace to accommodate the needs of skills enhancement and free equal education across the globe to the millions. We are bringing courses and trainings every single day for our users. We welcome everyone woth all ages, all background to learn. There is so much available to learn and deliver to the people.
