An Introduction To SQL Using Hockey Stats

hockey

#1

Highly recommend this intro into using SQL to look at Hockey Stats. It’s extremely through and steps you through the install process, loading up a database, and starting to run some queries.

I’ve taken some of the tables and queries and placed it on SQLFiddle if you don’t have the time right now to install. It’s a limited dataset, but it has some fun things to play with.

http://sqlfiddle.com/#!17/8395d/4/0

In case SQLFiddle doesn’t work and erases the text, I’ve backed up my setup and sample queries here.


Let me know what queries you tried, and if you have any questions. Thanks again to DragLikePull for originally putting this together!


#2

Using this so I can learn SQL for work. Any other pieces similar to this would be amazing.