"Vet clinic database: database performance audit" is a database where we optimized some slow queries.
- SELECT COUNT(*) FROM visits where animal_id = 4;
- SELECT * FROM visits where vet_id = 2;
- SELECT * FROM owners where email = '[email protected]';
To get a local copy up and run the app, follow these simple example steps.
- Postgres
Clone the repository with:
git clone [email protected]:safafa/vet_db.git
or download ZIP file
Run the commands from schema.sql
and data.sql
to create the database locally.
๐ค Aleksandar Ivezic
- GitHub: @Aleksandar Ivezic
- Twitter: @AIvezic
- LinkedIn: Aleksandar Ivezic
๐ค Safa Aballagh
- GitHub: @Safafa
- Twitter: @safa aballagh
- LinkedIn: Aballagh Safa
Contributions, issues, and feature requests are welcome!
Feel free to check the issues page.
Give a โญ๏ธ if you like this project!
- This project was inspired by Microverse