Part I: Programming


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

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