Vet Clinic Database

This is a repo to test my knowlegde of SQL on day one of Database curriculum in Microverse School

> Day 1 : worked on basics of sql using clauses like the comparison (<,>,=,<>,is not,not), like, where etc

Day 2: I used clauses like Having, Group by , aggregate fuctions transaction,rollback etc

Day 3: I made use of Join , right join, Order by,

Day 4: Made use of fetch row, order by, multiple join table

> Week 2, Day 1: Made use of indexing and tuning to optimize query excution time.

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!

Kanu Mike**

• GitHub: @Ginohmk
• Twitter: @michotall95
• LinkedIn: @kanumike
• Instagram: @savy_kanu_mike
• Facebook: @mike.kanu

🤝 Contributing

Contributions, issues, and feature requests are welcome!

Feel free to check the issues page.

Show your support

Give a ⭐️ if you like this project!

Acknowledgments

• Microverse School
• Hat tip to anyone whose code was used
• Inspiration
• etc

📝 License

This project is MIT licensed.