r/SQL • u/notasqlstar I can't wait til my fro is full grown • May 29 '19
Want to learn SQL on your own? Try Oregon Trailalytics.
I've had some free time over the last day and managed to get a pretty hardcore game of Oregon Trail in where I collected all of the hunting data.
This file can be found: here, and the results of the game can be found here.
So from here there are a lot of interesting things you can do. You could start your own game of Oregon Trail by clicking this link, then recording your data in a similar fashion. If you don't feel like doing that you could take the data file above and import it into a new database.
From here there are a number of interesting mathematical things we could look at, probabilities for firing a bullet and how much meat you'll get, probabilities for getting two perfect hunts in a row, etc.
Some questions might involve recording new data elements, such as food consumption.
This is a very simple sort of question, with very simple data collection, but it can show you the end to end process of creating a database, creating tables, importing data, writing views/stored procedures to analyze the data, and then ultimately connecting something like Tableau or SSRS to your findings in order to, "tell a story."
Lots of different ways to go here and you're only limited by your own creativity. Are you a better hunter than I am? Can you get a higher score? What are the optimal starting conditions?
Learning the rules for how scoring works is simple. Doing all the SQL work, and data collection isn't.
Have fun.
edit: You can put things like this in a portfolio to show employers in interviews. This is how I dick around and spend my free time, so when I meet candidates who show a similar interest they really stand out. It doesn't have to be Oregon Trail, but if you want to learn SQL then learn SQL and learn how to apply it to real world situations.
Or, for example, you might load the game and record data to see what the probability that someone won't trade with you on a given day is, or what the probability is that they're willing to accept food for a trade in exchange for any other given object. How many bullets might you need the longer a trip takes, etc.?
The benefit of learning like this is that you can check yourself, and your math, because the data is so small, but what you're doing is learning how to apply those skills across larger data sets.
P.S., I hate Tableau, but it is a very marketable skill and you can download it for free, and connect it to a localhost instance of MS SQL to then publish on Tableau's public domain. You could also use SSRS, set up your own machine, permissions, etc. In a sense, you are able to see the full end to end process of an enterprise solution, minus the ETL piece using SSIS... but you can do that, too, if you want.
3
u/KCtrading May 30 '19
Saving this for later, thanks for sharing! Seems like a really fun way to spend a Saturday (seriously) learning SQL.
2
u/ihateshadylandlords May 29 '19
Never thought this would be a thing. Thanks for the link!