Data Modeling with Apache Cassandra

See how to extract data from CSV files, transform it, and load it into Apache Cassandra. Understand how Cassandra -- or any partition row store databases -- provides scalability and fast reads and writes by adding redundant or de-normalized tables.

more ...

Data Modeling with PostgreSQL

See how to extract data from CSV files, transform it, and load it into PostgreSQL. Learn how to extract log data from CSV files using pandas, transform it with SQL and python, and then load it into a star-scheme perfect for aggregations and analytics.

more ...