Leading Off - Pete Rose LF
Just a couple of quick notes:
I am assuming you know your way aroud your computer, whether Mac or Windows and you know your away around a browser.
I am also assuming if there is a term you dont understand you will look it up.
I will do my best to link terms, companies, etc, to definitions, or information about them.
That being said, feel free at any point, to reach out to me at luis.barnes@tekforward.org, and I will answer any questions you may have.
Let’s start.
For the purpose of this excercise, we are going to be using Postgres database. First released in 1989, it has become one of the most used databases in the world. It is Open Source, and as such, it’s free to use. To install Postgres, let’s head to www.postgresql.org:
Click on DOWNLOAD and select your OS of choice,.
From there, click on Download the installer and select the latest version for your OS. For me, it’s version 17.5 for MacOS. You should have the same version available for Windows
From there, select your specific OS for Version 17.5. Once downloaded, let’s run it. Follow the button/prompts. When you get to the end, please UNCHECK the selection about “Launch Stack Builder at exit”. We wont’t be messing with it for this blog.
And voila, you have installed Postgres.
Remember, do not hesitate to reach out to me. I will gladly answer any questions.
Alright, this was a very basic installation process and I am sure I left something out. To that end, below are two links, one for Mac, one for Windows, of far more in depth installations of Postgres.
For Windows: https://youtu.be/GpqJzWCcQXY?si=V9eRJ1YKS13j1jtk
Alrighty. Now that have Postgres installed, let’s talk about baseball and the basic data we need. First though, like with everything else in life, what’s our purpose? What do we want to know? In order to know what data we need, we need the question we need answers to. I figured two questions, to different type of questions, would be enough. I reached out to a friend of mine and asked to give me a question he would like answered. The second one I came up with:
First question: How many times does the team that wins the first game of a series, wins the series?
Second question: Hall of Famer Rod Carew was a lifetime .328 hitter and played from 1967 to 1985. My question is what was his batting average each decade he played?
With those two questions, now we can figure out what data we need. One of the key things when trying to figure what data you need is that you can alwyas have more data than less. You can always ignore data but adding data you may have missed if far more difficult.
Let’s stop there. Next time we will do a deep dive into the questions and figured what data we may need. This is where the fun really starts.
Until next time!
