Introduction to Databases
Chapter 1: Understanding Databases and Data Storage
Defining Data and Information
Limitations of File-Based Storage
Introducing the Database Concept
Database Management Systems (DBMS)
Benefits of Using a Database
Common Database Applications
Quiz for Chapter 1
Chapter 2: The Relational Database Model
Organizing Data in Tables
Columns and Data Types
Rows as Records
Primary Keys for Unique Identification
Relationships Between Tables
Foreign Keys for Linking Tables
Introduction to Normalization Principles
Quiz for Chapter 2
Chapter 3: Querying Data with SQL
Introduction to Structured Query Language (SQL)
The SELECT Statement: Retrieving Data
Filtering Data with WHERE Clause
Sorting Results with ORDER BY
The INSERT Statement: Adding Data
The UPDATE Statement: Modifying Data
The DELETE Statement: Removing Data
Practice Writing Basic SQL Queries
Quiz for Chapter 3
Chapter 4: An Overview of NoSQL Databases
Limitations of Relational Databases
Introducing NoSQL Concepts
Document Databases
Key-Value Stores
Column-Family Stores
Graph Databases
SQL vs. NoSQL: A Basic Comparison
Quiz for Chapter 4
Chapter 5: Working with Databases
Factors in Choosing a Database
Common Database Tools
Connecting to a Database
Using a Simple Database Environment
Hands-on Practical: Connecting and Querying
Quiz for Chapter 5
Document Databases
Was this section helpful?
- NoSQL Distilled: A Brief Guide to the Emerging World of Polyglot Persistence, Pramod J. Sadalage and Martin Fowler, 2012 (Addison-Wesley Professional) - A foundational book offering a high-level overview of NoSQL databases, including an introduction to document databases and their core principles like schema flexibility.
- MongoDB Manual - Documents, MongoDB Documentation, 2024 - Official documentation detailing the structure, characteristics, and practical implementation of documents in MongoDB, a leading example of a document database.
- Designing Data-Intensive Applications: The Big Ideas Behind Reliable, Scalable, and Maintainable Systems, Martin Kleppmann, 2017 (O'Reilly Media) - Offers a comprehensive comparison of different data models, including relational and document databases, discussing their trade-offs, advantages, and use cases.
- NoSQL Databases: A Survey and Taxonomy, Eder J. S. de Macedo, José J. P. C. Rodrigues, Joel P. L. Silva, Tiago M. A. C. Silva, 2019 Journal of Parallel and Distributed Computing, Vol. 131 (Elsevier) DOI: 10.1016/j.jpdc.2018.11.002 - Provides a structured overview and classification of various NoSQL database types, including document databases, explaining their characteristics and applications.