Part I: Programming

<aside> 💡 Final Project: https://github.com/tieukhoimai/plotly-nlp-news

• Result (Click to view) </aside>

Part II: Database

Lecture Notes

Relational model: models, instances, schemata, constraints

Relational Data Model

DB Schema

Query languages and Relational algebra

Relational Algebra

SQL

SQL - Structure Query Language

SQL - DML

SQL - DDL

Conceptual models and conceptual design

E-R model concept.pdf

Data Warehouses

Data Warehouse.pdf