Getting Started

This repository includes files with plain SQL that can be used to recreate a 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!

Diagram

Diagram

📗 Table of Contents

📖 Vet Clinic

Vet Clinic is a series of queries to demonstrate various types of actions that can be performed onto a database, as well as different queries to read data out of the databse.

🛠 Built With

Tech Stack

Database

Key Features

  • Creating new tables examples
  • Adding data examples
  • Reading data examples

(back to top)

🚀 Live Demo

  • Link comming soon

(back to top)

💻 Getting Started

To get a local copy up and running, follow these steps.

Prerequisites

In order to run this project you need a way to run SQL queries. Used database is PostgreSQL

Setup

Clone this repository to your desired folder:

  cd my-folder
  git clone git@github.com:Vgonma/vet-clinic.git

Usage

To run the project:

  • Run the queries in schema.sql to build your databse.
  • Run the queries in data.sql to fill your database with data.
  • Run your queries.(queries.sql contains some examples)

👥 Authors

👤 Victor Gonzalez

(back to top)

🔭 Future Features

  • Performance Audit
  • Ruby integration

(back to top)

🤝 Contributing

Contributions, issues, and feature requests are welcome!

Feel free to check the issues page.

(back to top)

⭐️ Show your support

If you like this project feel free to fork it and give it a star.

(back to top)

🙏 Acknowledgments

I would like to thank Microverse for seting me up on this project.

(back to top)

📝 License

This project is MIT licensed.

(back to top)