SQL and Database Design

This project showcases advanced SQL querying and database design, focusing on key aspects such as database schema creation, performance optimization, and transaction management. Developed as part of a comprehensive database course.

Key Features

• SQL Querying: Worked with complex databases to perform efficient data retrieval and analysis.
• Database Design: Designed and normalized schemas for real-world scenarios, such as medication usage, to ensure data integrity.
• Performance Optimization: Improved query efficiency and optimized database structures for large-scale datasets.
• Transaction Management: Ensured consistency and integrity through transaction handling.

Repository Structure

SQL_and_Database_Design/
├── queries/              # SQL scripts for querying and analysis
├── design/               # ER diagrams and database schemas
├── optimization/         # Performance tuning scripts
└── transactions/         # SQL scripts for transaction management

License

This project is licensed under the MIT License.