Search Colleges, Exams, Schools & more
Login
Fundamentals of Database Systems
Online
8 Weeks
Free Quick Facts
| Medium Of Instructions | Mode Of Learning | Mode Of Delivery |
|---|---|---|
| English | Self Study | Video and Text Based |
Courses and Certificate Fees
| Certificate Availability | Certificate Providing Authority |
|---|---|
| yes | IIT Kanpur |
The Syllabus
- Introduction to Databases
- Relational Data Model
- Relational Algebra Basic Operators
- Relational Algebra Composition of Operators
- Relational Algebra Additional Operators
- Relational Algebra Extended Relational Algebra
- Relational Algebra: Database Modifications
- SQL: Introduction and Data Definition
- SQL: Basic Queries
- SQL: Advanced Queries
- SQL: Updates, Joins, Views and Triggers
- Normalization Theory: Motivation
- Normalization Theory: 1 NF and 2NF
- Normalization Theory: 3NF
- Normalization Theory: BCNF
- Normalization Theory: MVD
- Physical Design
- Database Indexing: Hashing
- Database Indexing: Tree-based Indexing
- Query Processing: Selection
- Query Processing: Sorting
- Query Processing: Nested-Loop joins and Merge join
- Query Processing: Hash join and other Operations
- Query Optimization: Equivalent Expressions and Simple Equivalance Rules
- Query Optimization: Complex Equivalence Rules
- Query Optimization: Join Order
- Query Optimization: Heuristics and Sizes
- Database Transactions: Properties and Failures
- Database Transactions: States and Systems
- Recovery Systems: Deferred Database Modification
- Recovery Systems: Immediate Database Modification.
- Recovery Systems: Checkpointing and Shadow Paging
- Schedules: Introduction
- Schedules: Conflict Serializability
- Schedules: View Serializability
- Schedules: Result Equivalence and Testing for Serializability
- Schedules: Recoverability
- Concurrency Control: Locks
- Concurrency Control: Two-phase Locking Protocol
- Concurrency Control: Timestamp Ordering Protocol
- Concurrency Control: Validation-based Protocol
- Concurrency Control: Multiple Granularity for Locks
- Concurrency Control: Deadlock Prevention and Deadlock Detection
- Concurrency Control: Deadlock Recovery and Update Operations
- NoSQL: Introduction and Properties
- NoSQL: Columnar Families
- NoSQL: Different NoSQL Systems
- Big Data
Instructors
Articles
7 Nov'24, 09:24 AM
15 Jul'24, 06:17 AM
16 Apr'24, 11:54 AM
15 Apr'24, 11:24 AM
28 Feb'24, 11:09 AM
25 Sep'23, 03:14 PM
25 May'22, 09:29 AM
17 Feb'22, 07:53 AM
18 Sep'21, 06:37 AM
7 Nov'24, 09:24 AM
15 Jul'24, 06:17 AM
16 Apr'24, 11:54 AM
15 Apr'24, 11:24 AM
28 Feb'24, 11:09 AM
25 Sep'23, 03:14 PM
25 May'22, 09:29 AM
17 Feb'22, 07:53 AM
18 Sep'21, 06:37 AM