Data Modeling and ETL with PostgreSQL for Udacity Data Engineering Nanodegree

Data Modeling and ETL with Cassandra for Udacity Data Engineering Nanodegree

Creating a set of data and using several of the basic DML forms available in PostgreSQL.

Companion code for Aerospike Modeling: User Profile Store

Examples of using Aerospike's complex data types (Map and List) to implement common patterns

SQL Data Modeling, Data Engineering and Data Analysis.

Importing csv files to SQL database and analyse data based on requirement and create tables using different methods of data modeling.

Data modeling with Postgres and build an ETL pipeline using Python.

Udacity Data Engineering Nanodegree Capstone project that covers almost all the aspects of Data Engineering - Data Exploration, Data Cleaning, Data modeling, ELT(Extract, Load & Transform), Data Processing on AWS Cloud using Apache Spark and automating data-pipelines using Apache Airflow.

Built an ETL pipeline from AWS S3 storage to staging on AWS Redshift. Created a star schema data model from the original dataset. Managed cluster connections using Python and SQL queries.

This repository contains SQL notes.

This repository discusses a research project on the employee database at Pewlett Hackard Corporation from the 1980s and 1990s. All that remains of the database of employees from that period is in six CSV files. On this project, a table was created that holds employees data in the CSVs, import the CSVs into a SQL database, and the data exploratio…

Built a data model, data warehouse and pipeline for extracting transforming and loading data into a star schema-based data model in a redshift database

Data modelling with DynamoDB (Target stores)

Data Warehouse project on corona data. Analytics is done on country level, region level, and sub_region_level and visualized using python matplotlib.

ETL implementation in Python to load the data of JSON files into postgreSQL database.

A Project of Data Modeling and ETL with Apache Cassandra and Python