[COM506] Data Management

Course IDCOM506
ProgramBusiness Adminstration, Data Science
LevelBachelor, Master

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