One of my goals for this project is to analyze the same dataset using different tools. By doing this, I can compare how Excel and SQL solve the same business problems while building practical skills in both.

Creating a Database

Using PostgreSQL and DBeaver, I created a new database named:

hospital_analysis

This database will store everything related to my project as I continue building. It will establish a place where the data will live before any tables or queries are created.

Creating a Schema

After creating the database, I created a schema named:

hospital

A database is the overall container, while a schema helps organise related database objects such as tables, views, and functions. Using a dedicated schema makes the project more organised and easier to manage as it grows.