An API for shopping-cart using go, go-gin, swaggo, and postgresql.
Employee Database: A Mystery in Two Parts
Employee data analysis using pgAdmin, PostrgreSQL, and quickdatabasediagrams to create the ERD.
Creating SQL database using PostgreSQL and pgAdmin
Built an ETL pipeline to clean and load crowdfunding campaign data into a PostgreSQL database using Python and SQL.
🛠️ Simplify database design with drawDB, your free and intuitive tool for editing schemas and generating SQL effortlessly.
[MySQL ERD] Demonstrates knowledge of Entity Relationship Diagrams(ERD's). Shows ability to differnetiate one to many and many to many relationships. Uses a many to many relationship to create RSVP list.
A PostgreSQL database built with DBeaver which stores information on a Car Dealership
End-to-end database engineering project: Transforming raw academic data into a normalized 5NF schema and extracting business insights using Advanced SQL (PostgreSQL).
In this project, a database is created for an organization based on six existing separate tables of data in csv form. Relationships between the tables are defined based on the existing data. In the new relational database, specific queries are performed.
Analyze the data to identify possible fraudulent transactions by using ERD, PostgreSQL, ERD and Python.
Data Modelling and Engineering, using ERD diagrams, and sqlalchemy for an employee database.
Applied basic- to intermediate-level SQL statements to organize and query large scale data.
Creating a physical relational database based on our ERD, inserting data, and solving queries.
This project delivers a production‑ready e‑commerce database schema focused on scalability, data integrity, and high performance. Its design and optimization strategies are based on concepts and best practices from the book Practical Web Database Design by Chris Auld.
7. SQL Engineering and Data Analysis
This repository is for me to practice SQL using PostGreSQL and connecting it with Pandas.
Practised building an ETL pipeline using Python and Pandas to extract and transform data. After which the data was loaded into a Postgres database.
Add a description, image, and links to the erd topic page so that developers can more easily learn about it.
To associate your repository with the erd topic, visit your repo's landing page and select "manage topics."