In this article I introduce you to the world of Sabermetrics. Sabermetrics is the analysis of baseball statistics to measure player performance, in game probabilities and much more.
With Sabermetrics you’ll be able to do most anything from decide who was the greatest hitter of all time to analyze the probability that your team will win.
But, to get started with Sabermetrics, you need to first get your tools being MySQL and a Baseball Stat Database. Both are free! More info follows the video below.
If you like videos like this tell google [googleplusone], or share it [nttfblike]
More on Sabermetrics
I plan on covering many more Sabermetric formulas, but you can find mostly everyone of them in The Bill James Historical Baseball Abstract. He is credited with first publishing many of the formulas we will explore.
Code from the Video
Thanks for new lesson.
You’re welcome. I wanted to make the Java Tutorial a little more interesting
I need help I can’t seem to get it to run right it always sends the following error message:
-bash: mysql: command not found
HELP PLEASE
Do this to make sure you have MySQL in your terminal program sudo find / -name mysql
You’ll see a bunch of lines if you have MySQL installed. Copy and past the one that is in the bin directory.
To make everything executable by just typing mysql, check out this nice tutorial http://495west.com/post/4895753657/bash-mysql-command-not-found
Now when i did that it makes me enter a password
what is this ?
When i do that it makes me enter a password
what is the password to?
You need a password and userid to use the database
Where do i change this
what do i do if i don’t know the password
You need the MySQL database. Do you have it?
Where do i change this
hello derek,
if i do not give ‘group by s.teamID’ clause for query, i get single record for teamID ANA why?
i want to understand this.
Select s.yearID, s.teamID, sum(s.salary) as salary, t.w as wins, salary/t.w as cpw from salaries s ,teams t where s.yearID = 2002 and s.teamID = t.teamID and s.yearID = t.yearID;
hello derek,
If i remove
Group by clause
In any of your sql query,
I get only one entry instead of multiple entries.
Why?