muhammadusmanaslam/database-performance-audit

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
  • 🚀 Live Demo
• 💻 Getting Started
  • Setup
  • Prerequisites
  • Install
  • Usage
  • Run tests
  • Deployment
• 👥 Authors
• 🔭 Future Features
• 🤝 Contributing
• ⭐️ Show your support
• 🙏 Acknowledgements
• ❓ FAQ
• 📝 License

📖 [DATABASE-PERFORMANCE-AUDIT]

[DATABASE-PERFORMANCE-AUDIT] is a database project built with sql providing useful data about animals kept in the clinic

🛠 Built With SQL AND pgADMIN

Tech Stack

Database

• PostgreSQL

Key Features

Describe between 1-3 key features of the application.

• [Speed in querying database]

(back to top)

🚀 Live Demo

No live demo link yet

(back to top)

💻 Getting Started

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

git clone 'https://github.com/MuhammadUsmanAslam/database-performance-audit.git' cd database-performance-audit

Prerequisites

In order to run this project you need:

pgAdmin

sql CMD

Setup

Clone this repository to your desired folder:

cd my-folder git clone https://github.com/MuhammadUsmanAslam/database-performance-audit.git

Install

No installation needed for now

Usage

To run the project, execute the following command:

pgAdmin or preferred sql related applications

Run tests

No test needed at the moment

Deployment

No deployment needed at the moment

(back to top)

👥 Authors

Mention all of the collaborators of this project.

👤 Author1

• GitHub: @githubhandle
• Twitter: @twitterhandle
• LinkedIn: LinkedIn

👤 Author2

• GitHub: @githubhandle
• Twitter: @twitterhandle
• LinkedIn: LinkedIn

(back to top)

🔭 Future Features

• SCHEMA DIAGRAM

(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... Please leave a star for my project on github

(back to top)

🙏 Acknowledgments

I would like to thank Mivroverse for assigning this project to us for the purpose of learning how to index table columns in databases

(back to top)

❓ FAQ

Add at least 2 questions new developers would ask when they decide to use your project.

• [How to add indexes to a column in a table]

  • syntax: CREATE INDEX index_name ON table_name(column_name)

• [Between the CLI and pgAdmin application which is better]

  • Due to personal preference, i will pick pgAdmin, it gives a better and less scary UI,lol

(back to top)

📝 License

This project is MIT licensed.

(back to top)