curriculum-databases-projects-template

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!

📗 Table of Contents

• 📖 About the Project
  • 🛠 Built With
    • Tech Stack
    • Key Features
• 💻 Getting Started
  • Setup
  • Prerequisites
  • Install
• 👥 Authors
• 🔭 Future Features
• 🤝 Contributing
• ⭐️ Show your support
• 🙏 Acknowledgements
• ❓ FAQ
• 📝 License

📖 [Vet_Clinic]

This project is created and focused to practice and test our knowledge in SQL and to learn best practices of it. [Vet_Clinic]

🛠 Built With

Tech Stack

This project is built with SQL and PostgresSQL

Database

• PostgreSQL

Key Features

• [CRUD]
• [ACID]
• [TRANSACTIONS]

(back to top)

💻 Getting Started

To use this project you must install PostgresSQL and then create a Database server, after that you can copy the scripts on this projects to create, fill and test queries

Prerequisites

Install PostgresSQL

Setup

Clone this repository to your desired folder

Install

Run the scripts in schema.sql in your PostgresSQL command console.

👥 Authors

👤 Nelson Araujo

• GitHub: @NelsonAraujo93
• LinkedIn: LinkedIn

👤 David Isea

• GitHub: @AlucardSanin

• LinkedIn: David Isea

(back to top)

🔭 Future Features

• [More tables]
• [Primay keys]
• [Foreign keys]

(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 take the time to give feedback, we will appreciate it.

(back to top)

🙏 Acknowledgments

We would like to thank Microverse for giving me the chance to improve my codding.

(back to top)

❓ FAQ

• Is this project a practice?

  • Yes, it is. The main reason of this project is to practice and learn the basics of SQL.

• Where can i learn more about SQL?

  • The best way to learn SQL and go deeper in knowledge is directly in PostgresSQL website or MySQL website.

(back to top)

📝 License

This project is MIT licensed.

(back to top)