This is a continuation of my work on the codeacademy data science independant project #1: Watching the Stock Market. My first post on the subject explores how I put gathered the stock data. In my second post, I explored the data using basic sql queries (and put my sql code out into the world for the first time!) After completing the basic challenges from my last post on the topic, there are intermediate and advanced challenges too while playing with these stocks data.
This is a continuation of my work on the codeacademy data science independant project #1: Watching the Stock Market. My first post is here. In this project, the basic tasks are: What are the distinct stocks in the table? Query all data for a single stock. Do you notice any overall trends? Which rows have a price above 100? between 40 to 50, etc? Sort the table by price. What are the minimum and maximum prices?
I just started working on teaching myself sql and after completing the codeacadmey sql lessons, there are links to independant projects. My goal is to work on these independant projects in the coming weeks. To look ahead (and have a place to find them later outside my pocket list) here’s a list to all five I plan on working on: Watching the Stock Market Explore a Sample Database Education & Census Data Home Value Trends Analyze Airfare Data The first project has us working with stock market data.