💾
Welcome to DataGenesis !
  • 🚀 Welcome to the Database Management System Playground! 📊💾
  • Basics of DBMS
    • Database Management System
    • DBMS V/S File System
    • DBMS Architectures
    • Tier 3 Architecture / Three Schema Architecture
  • E-R Data Model
    • Basics of E-R Model
    • Attributes in E-R Model
    • Null Values
    • Strong & Weak Entities
    • Relationship Constraints
    • Recursive Relationships
    • E-R Diagrams
    • Extended E-R Model
  • Relational Model
    • Relational Model
    • Facts About Relational Model
    • Types of Keys in Relational Model
    • Integrity Constraints
    • Anomalies in Relational Model
  • Transform - ER Model to Relational Model
    • Mapping from ER Model to Relational Model
  • SQL - Structured Query Language
    • SQL
    • CRUD Operations
    • Data Types
    • Type of Commands in SQL
    • Working With Commands
    • Data Retrieval Commands
  • Normalisation
    • Functional Dependencies
    • Armstrong's Axioms
    • Multivalued Dependency
    • 1 Normal Form
    • 2 Normal Form
    • 3 Normal Form
    • Boyce-Codd Normal Form (BCNF)
    • 4 Normal Form
    • 5 Normal Form
    • Lossless Decomposition, Lossless Join ,and Dependency Preserving Decomposition, Denormalization
  • Concurrency Control
    • Transactions & Concurrency
    • Scheduling of Transactions
    • Problems & Strategies in Concurrency Control
    • Transaction & ACID Properties
    • How to implement ACID Properties
    • Atomicity Techniques
    • Durability Techniques
    • Implementing Locking in DBMS
    • Concurrency Control Protocols
      • Two Phase Locking
      • Timestamp Ordering
      • Multi Version Concurrency Control Techniques
    • Starvation in DBMS
    • Deadlock in DBMS
    • Log Based Recovery
  • NoSQL & Types of Databases
    • SQL V/S NoSQL
    • Types of Databases
  • DB Optimization
    • File Organization
      • Hash File Organizations
      • B+ Tree File Organization: A Guide to Efficient Data Indexing
      • Cluster File Organization
    • Indexing in DBMS
      • Primary Indexing
      • Clustered Indexing
      • Secondary Indexing
      • Multilevel Indexing
  • Distributed Databases
    • Database Clustering
    • Partitioning and Sharding
    • CAP Theorm
Powered by GitBook
On this page

Was this helpful?

🚀 Welcome to the Database Management System Playground! 📊💾

Are you ready to embark on an exciting journey into the world of databases? Buckle up, because we're about to explore the heart of data management, organization, and retrieval. 🌐🔍

🚀 Welcome to the Database Management System Playground! 📊💾

Are you ready to embark on an exciting journey into the world of databases? Buckle up, because we're about to explore the heart of data management, organization, and retrieval. 🌐🔍

📋 Table of Contents 📋

  1. 🌟 Introduction to DBMS

  2. 🧠 Why DBMS Matters

  3. 🏗️ Components of a DBMS

  4. 🏛️ Types of Database Models

  5. 💼 Relational Databases

  6. 🧬 NoSQL Databases

  7. 💽 Data Modeling

  8. 📜 SQL Fundamentals

  9. 🤖 Querying Databases

  10. 🚀 Advanced DBMS Concepts

  11. 📊 Database Security

  12. 💡 Tips and Tricks

  13. 🌐 Resources and References

Ready to dive in? Click on any section to begin your adventure into the fascinating realm of Database Management Systems! 🌟🔐💡

NextDatabase Management System

Last updated 1 year ago

Was this helpful?

Page cover image