🥎 Baseball Stats Database Management - Using SQL

View on GitHub

Overview

Developed a comprehensive database to manage and analyze baseball statistics up to the year 2014, ensuring efficient data retrieval and storage.

Technologies Used

• Oracle SQL for database creation and management
• Excel for data visualization

Features

• Database Design and Normalization: Designed a relational database schema to minimize redundancy and enhance data integrity.
• Query Optimization: Implemented indexing to optimize database queries, significantly reducing data retrieval times.
• Data Visualization: Utilized Excel to create visual representations of player statistics such as home runs, hits, and batting averages over time.

Challenges Overcome

• Addressed performance issues by creating effective indexes on large datasets.
• Ensured data consistency and integrity through comprehensive SQL scripts and database administration practices.

Project Outcome

• Successfully managed a dataset encompassing player performances, team statistics, and historical game outcomes.
• Enhanced the accessibility and usability of baseball statistics for analytical purposes.

Screenshots and Code Snippets

• Include visual elements like screenshots of the ER diagram, data visualizations from Excel, and code snippets of crucial queries and scripts.

Conclusion

• This project not only refined my skills in database management and SQL queries but also enhanced my ability to visualize complex datasets for meaningful insights.