420-ENL-MT – Structures and Databases – Fall 2019 – MAD314

GENERAL COURSE DESCRIPTION
Students become familiar with the data formats most frequently used in the industry. They learn the concepts necessary for using and creating databases. They are able to convert the basic information from a specific request or problem into a usable format.

Course Plan

Important dates

Project – November 2, 2019

Final Exam – November 3, 2019

COURSE 1

Database vs Tables

Relational Algebra

COURSE 2

Oracle Installation file

HR Database deployment  

Cours 3

SQL -DML Part 1

Cours 4

SQL -DML Part 2

Cours 5

SQL -DDL

In Class Practice

Cours 6

DB – Alter Table

In Class Activity

DB – Tables Creation

DB  Review – Insert

DB  Review – Select

Course 7

DB – Triggers

Course 8

JSON: The Basics

JSON

catalog.json

JSON Libraries Information

Libraries

JSONLint

Course 10

CDM Class Diagrams

CDM to PDM translation