The latest articles on DEV Community by Michael Breshock (@mbreshock). https://dev.to/mbreshock https://media2.dev.to/dynamic/image/width=90,height=90,fit=cover,gravity=auto,format=auto/https:%2F%2Fdev-to-uploads.s3.amazonaws.com%2Fuploads%2Fuser%2Fprofile_image%2F2589485%2F0fd7ce82-ec4a-49ea-8dbe-2262b8c79394.jpeg https://dev.to/mbreshock en Michael Breshock Mon, 13 Jan 2025 08:18:39 +0000 https://dev.to/mbreshock/sql-tables-for-marvel-rivals-characters-team-up-abilities-32fb https://dev.to/mbreshock/sql-tables-for-marvel-rivals-characters-team-up-abilities-32fb <h2> Happy New Year!✨ </h2> <p>To start off the year strong, I'm learning SQL through a <a href="https://en.khanacademy.org/computing/computer-programming/sql" rel="noopener noreferrer">Khan Academy course</a>. I was tasked with creating tables of 'famous' people for a project. I decided to make it more fun for myself by creating tables about <a href="https://www.marvelrivals.com/" rel="noopener noreferrer">Marvel Rivals</a>, a video game released recently that has taken the world by storm, myself included. I know I'm not the only data nerd that likes to game in their downtime, so I thought I'd share the SQL code I wrote in case it could be of use.😊</p> <p>I constructed two tables. The first has every playable character in the game listed in each row, along with their role, difficulty, HP, and affiliation. The second table represents all of the different team-up abilities possible by combining characters 2-3 from the first table. The tables consist of the following columns: </p> <h4> <strong>heroes</strong> </h4> <p>| hero_id | name | role | hp | difficulty | affiliation |</p> <h4> <strong>team_ups</strong> </h4> <p>| id | combo_name | activator_id | party1_id | party2_id |</p> <p>The SQL code to generate these tables can be found on GitHub at <a href="https://github.com/mbreshock/MarvelRivalsDB/blob/main/rivals.sql" rel="noopener noreferrer">github.com/mbreshock/MarvelRivalsDB/blob/main/rivals.sql</a>. This repository also provides a script with <a href="https://github.com/mbreshock/MarvelRivalsDB/blob/main/query_example.sql" rel="noopener noreferrer">example commands</a> for querying these tables. All of the information in these tables was sourced from <a href="https://marvelrivals.fandom.com/wiki/Heroes" rel="noopener noreferrer">Marvel Rivals Wiki</a>.</p> <h4> Happy coding and happy gaming!👾 </h4> sql database learning github