Understanding Data Management and Database Concepts

• Data Management Process
• File to Database
• SQL: Relational Database Model
• NoSQL

Modeling Relational Database: Entity Relationship Diagram (ERD)

• Conceptual Models
• Logical Models
• Physical Models

Building Databases using Docker Containers with Docker Compose

• Reviewing the Basics of Docker and Docker Compose
• Building SQL Database: MariaDB container
• Building NoSQL Database: Elasticsearch container

Using NoSQL: Elasticsearch

• Generating JSON Data
• Inserting the JSON Data
• Querying Elasticsearch with REST APIs using curl and Python

Transforming Data from NoSQL to SQL

• Extracting JSON from Elasticsearch
• Parsing JSON into Table Matrices
• Generating Insertion Queries with the Table Matrices

Using SQL: MariaDB

• Creating Databases and Tables using Data Definition Language (DDL)
• Dealing with Data using Data Manipulation Language (DML): Create, Read, Update, Delete
• Backing Up and Restoring Databases