Introduction To
DBMS
DBMS(DATABASE MANAGEMENT SYSTEM)
A database is an organized collection of data, generally stored and accessed electronically from a computer system. Where databases are more complex they are often developed using formal design and modeling techniques.
A database management system (DBMS) is system software for creating and managing databases. The DBMS provides users and programmers with a systematic way to create, retrieve, update and manage data.
Database is a very important aspect of computing, it is useful to both programmers and non programmers so this course is for everyone. Feel free to follow the course outline and advance your knowledge
Course Structure
Introduction
- Database Management System – Introduction | Set 1Database Management System – Introduction | Set 2All DBMS ArticlesDBMS Quizzes
- Database Management System Introduction | Set 2 (3-Tier Architecture)All DBMS ArticlesDBMS Quizzes
- DBMS Architecture 2-Level, 3-Level
- Need for DBMS
- Data Abstraction and Data Independence
- DBMS | Database Objects
- DBMS | Multimedia Database
- DBMS | Interfaces
- DBMS | Categories of End Users
- Use of DBMS in System Software
- Choice of DBMS | Economic factors
- Disadvantages of DBMS
Entity Relationship Model
Relational Model
- DBMS | Relational Model Introduction and Codd Rules
- Relational Model
- DBMS | Keys in Relational Model (Candidate, Super, Primary, Alternate and Foreign)
- DBMS | Number of possible Superkeys
- DBMS | Anomalies in Relational Model
- Mapping from ER Model to Relational Model
- DBMS | Strategies for Schema design
- DBMS | Schema Integration
- Star Schema in Data Warehouse modeling
- Data Warehouse Modeling | Snowflake Schema
- Dimensional Data Modeling
Relational Algebra
- Basic Operators in Relational Algebra
- Extended Operators in Relational Algebra
- Database Management system | Relational Algebra
- DBMS | Join operation Vs nested query
- DBMS | Tupple Relational Calculus
- DBMS | Row oriented vs. column oriented data stores
- DBMS | How to solve Relational Algebra problems for GATE
- DBMS | How to solve Relational Algebra problems for GATE
Functional Dependencies
Normalisation
- Database Normalization | Introduction
- Database Normalization | Normal Forms
- DBMS | Minimum relations satisfying 1NF
- The Problem of redundancy in Database
- Database Management System | Dependency Preserving Decomposition
- Database Management System | Lossless Decomposition
- Lossless Join and Dependency Preserving Decomposition
- DBMS | How to find the highest normal form of a relation
- DBMS | Domain Key normal form
- DBMS | Introduction of 4th and 5th Normal form
- Denormalization in Databases
- DBMS | Data Replication
Transactions and Concurrency Control
- DBMS | Concurrency Control -Introduction
- ACID Properties in DBMS
- Implementation of Locking in DBMS
- DBMS | Concurrency Control Protocols – Lock Based Protocol
- DBMS | Concurrency Control Protocol | Graph Based Protocol
- DBMS | Concurrency Control Protocol | Two Phase Locking (2-PL)-I
- DBMS | Concurrency Control Protocol | Two Phase Locking (2-PL)-II
- DBMS | Concurrency Control Protocol | Two Phase Locking (2-PL)-III
- DBMS | Concurrency Control Protocol | Multiple Granularity Locking
- DBMS | Concurrency Control Protocol | Thomas Write Rule
- Concurrency Control | Polygraph to check View Serializabilty
- DBMS | Log based recovery
- DBMS | Concurrency Control Protocols | Timestamp Ordering Protocols
- DBMS | Introduction to TimeStamp and Deadlock Prevention Schemes
- DBMS | Dirty read in SQL
- DBMS | Concurrency Control | Types of Schedules
- DBMS | Conflict Serializability
- DBMS | How to test if two schedules are View Equal or not ?
- DBMS | Recoverability of Schedules
- DBMS | Precedence Graph For Testing Conflict Serializability
- Transaction Isolation Levels in DBMS
- DBMS | Database Recovery Techniques
- Starvation in DBMS
- Deadlock in DBMS
- DBMS | OLAP vs OLTP
- DBMS | Types of OLAP Systems
- DBMS | Types of Recoverability of Schedules and easiest way to test schedule | Set 2
- Web Information Retrieval | Vector Space Model
- DBMS | Why recovery is needed?
Indexing, B and B+ trees
File Organization
Advanced Topics
- RAID
- Query Optimization
- How to store a password in database?
- Storage Area Networks
- DBMS | Network attached storage
- Data Warehousing
- Data Warehouse Architecture
- Characteristics and Functions of Data warehouse
- Difficulties of Implementing Data Warehouses
- Data Mining
- Data Mining | KDD process
- Data Mining | Sources of Data that can be mined
- DBMS | Data Marts
- ODBMS – Definition and overview
- Architecture of HBase
- Apache HBase
- Architecture and Working of Hive
- Apache Hive
- Difference between Hive and HBase
- Difference between RDBMS and HBase
- DBMS | Challenges of database security
- Federated database management system issues
- Distributed Database System
- Functions of Distributed Database System
- DBMS | Semantic Heterogeneity
- Advantages of Distributed database
- Comparison – Centralized, Decentralized and Distributed Systems
- DBMS | Characteristics of Biological Data (Genome Data Management)
- DBMS | Data Management issues in Mobile database
- DBMS | Future Works in Geographic Information System
- Difference between Structured, Semi-structured and Unstructured data
DBMS practices questions
- Database Management Systems | Set 1
- Database Management Systems | Set 2
- Database Management Systems | Set 3
- Database Management Systems | Set 4
- Database Management Systems | Set 5
- Database Management Systems | Set 6
- Database Management Systems | Set 7
- Database Management Systems | Set 8
- Database Management Systems | Set 9
- Database Management Systems | Set 10
- Database Management Systems | Set 11