Home Blog Learn

All Courses

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

Columns and Data Types

Rows as Records

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

Document Databases

Key-Value Stores

Column-Family Stores

Graph Databases

SQL vs. NoSQL: A Basic Comparison

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

Introduction to Databases

Prerequisites: No prior knowledge needed

Level: Beginner

What You'll Learn

Core Database Concepts
Explain what a database and a Database Management System (DBMS) are, and why they are used.
Relational Model Basics
Describe the fundamental components of the relational model, including tables, rows, columns, and primary keys.
Basic SQL Queries
Write simple SQL statements to retrieve (SELECT), insert (INSERT), modify (UPDATE), and remove (DELETE) data.
NoSQL Database Awareness
Recognize the existence and general purpose of different types of NoSQL databases.
Data Management Principles
Understand basic principles of organizing and managing data.

© 2025 ApX Machine Learning

;