More SQL - Rocking Out

I’ve been playing around with the data science projects from codeacademy for a few weeks. First I played with stocks data here and here. Today, I’ll be working through the second [codeacademy data science independant project: Watching the Stock Market] This is a continuation of my work on the codeacademy data science independant project #2: Explore a Sample Database. The database for this project is related to a fictional music store.

Continue reading

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.

Continue reading

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?

Continue reading

Author's picture

Chris Friedman

I go on adventures and analyze data. When I’m away from my desk I make beer and build things with wood.

Data Analyst at Drexel University

Philadelphia, PA