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
Chapter 2: The Relational Database Model
Organizing Data in Tables
Primary Keys for Unique Identification
Relationships Between Tables
Foreign Keys for Linking Tables
Introduction to Normalization Principles
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
Chapter 4: An Overview of NoSQL Databases
Limitations of Relational Databases
Introducing NoSQL Concepts
SQL vs. NoSQL: A Basic Comparison
Chapter 5: Working with Databases
Factors in Choosing a Database
Using a Simple Database Environment
Hands-on Practical: Connecting and Querying