Building_Data_Model_and_Database

POC- Practice Building Data Model and Database

Tools

• Postgres
• Python
  • Pandas
  • sqlalchemy

Agenda

DataModelNotes.md

• Basics Data Models
• what is data model
• why is data modeling important
• who requires to learn data modeling
• relational model and database to ACID properties
• exercise - creating a table with postgres.

working_with_postgresDB_through_python.ipynb

• Building a table with python

dataModels_python_postgres.ipynb

• Building a data model then deploying the data model into the database. using python with pandas and sqlalchemy

Reference

• Data Engineering Project Portfolio
• Data Modeling Tutorial | Data Modeling for Data Warehousing | Data Warehousing Tutorial | Edureka
• Guru99

🎯 Get Data Set For Project

👉 opendata.aws
👉 dataset search
👉 UCI Dataset
👉 kaggle