Vet Clinic Database consists of the creation of the schema and all the necessary queries for a database of a veterinary clinic using postgreSQL
Database
- Creating a database using the sql 'CREATE DATABASE' statement.
- Creating a table using the sql 'CREATE TABLE' statement.
- Using the 'INSERT INTO' sql statement to record data in a table.
- Using the 'SELECT' sql statement to query data from a table.
- Using aggregate functions like COUNT, MAX, MIN and AVG.
- Using SQL transactions
- Use of JOINs clauses
- Working with join tables
To get a local copy up and running, follow these steps.
In order to run this project, you must have installed and configured the following tools in your local environment:
- PostgreSQL
You must ensure that you have the postgreSQL installed and the server is started before continuing.
First clone this repository to your desired folder:
git clone git@github.com:NitBravoA92/vet-clinic-database.git
Now, you need to create a database called vet_clinic.
In the command line, execute the following commands one by one in the same order as below:
Note: On all commands, you must replace the username
with your database's username and path/to/the/project-folder/
with the path to the project folder in your local environment.
psql -U username -d vet_clinic -f path/to/the/project-folder/schema.sql;
Running the above command will create a table named animals within it.
psql -U username -d vet_clinic -f path/to/the/project-folder/data.sql
Running the above command will insert four new records into the animals table.
psql -U username -d vet_clinic -f path/to/the/project-folder/queries.sql
When executing the above command, a series of queries will be made to the animals table.
👤 Nitcelis Bravo
- GitHub: Nitcelis Bravo
- Twitter: @softwareDevOne
- LinkedIn: Nitcelis Bravo Alcala
Describe 1 - 3 features you will add to the project.
- Update animals table records.
- Add other tables to the database with different queries
- Add "join tables"
- Create database performance audit
- Create database schema diagram
Contributions, issues, suggestions and feature requests are welcome! Feel free to check the issues page.
To do Contributions, please fork this repository, create a new branch and then create a Pull Request from your branch. You can find detailed description of this process in: A Step by Step Guide to Making Your First GitHub Contribution by Brandon Morelli
If you liked this project, give me a "Star" (clicking the star button at the beginning of this page), share this repo with your developer community or make your contributions.
I would like to thank my Microverse teammates for their support. They have supported me a lot in carrying out this project, giving me suggestions, good advice and solving my code doubts.
This project is MIT licensed.