Data Warehousing
datapandasadmin

Free Entity Relationship and Relational Schema Diagram Tool

ERDPLUS One tool I generally use when working on a projects, mini tasks and exploration is the ERDPLUS tool . It is quite simple and easy to use. It is a Free tool as well. Below are some diagrams I generated when i first got in contact with with tool. ERD DIAGRAMS: 1. 2.  A

Read More »
Coursera
datapandasadmin

Teradata Viewpoint – SQL Scratchpad – Writing Queries Dillard’s Department Store Database

Analysing ‘Big Data’ from a database with real world data requires retrieving data from the database by writing relevant queries. As part of “Managing Big Data with MySQL” by Duke University on Cousera, I dealt with real world data that comprise hundreds to millions of entries/rows. This is the database of Dillard’s Department stores, specifically, the UA_DILLARDS that contains

Read More »