DEV Community

Cover image for SQL
Dennis Wachira
Dennis Wachira

Posted on

SQL

 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.

Top comments (0)