This repository includes files with plain SQL that can be used to recreate a clinic-database database:
- Use schema.sql to create all tables.
- Use data.sql to populate tables with sample data.
- Check queries.sql for examples of queries that can be run on a newly created database. Important note: this file might include queries that make changes in the database (e.g., remove records). Use them responsibly!
Project description.
[clinic-database] is a Postgresql database project containing all the steps and codes involved in creating a database in Postgresql.
The tech stack used in this project includes.
PostgreSQL Database
Database
Key features of the application include.
- [Select Statement]
- [Create Statement]
- [Update Statement]
Install Postgresql, open the Postgresql terminal, and run the codes.
In order to run this project you need:
- [postgresql terminal]
Clone this repository to your desired folder:
- [postgresql terminal]
Install this project with:
- [postgresql terminal]
To run the project, execute the following command:
- [Paste the codes in postgresql terminal]
Collaborators of this project include:
👤 Christopher Uduekwe
- GitHub: @githubhandle
- Twitter: @twitterhandle
- LinkedIn: LinkedIn
👤 Mohammad Mahdi Niazi
- GitHub: @Mahdi-Niazi
- Twitter: @mahdinazi1
- LinkedIn: Mohammad Mahdi Niazi
Features of this project include.
- [Join Statement]
Contributions, issues, and feature requests are welcome!
Feel free to check the issues page.
If you like this project...
I would like to thank Microverse for this wonderful opportunity.
2 questions new developers would ask when they decide to use this project.
-
[What languages where used?]
- [SQL]
-
[What git control system was used?]
- [Github]
This project is MIT licensed.