• code,  data science

    Get this Free SQL Database

    For a long time, I’ve wanted to published guides to the programming languages that I use. Last week, I started by writing up quick notes on SQL but it occurred to me that you will need a SQL database to follow along. So I found a free SQL database system that you can download right now. Download MAMP The program that you need is called MAMP and you can download that here. Take care to download the correct version for your operating system. MAMP makes it easy to install these three open-source products: Apache, MySQL, and PHP. MySQL is the free SQL database, but you need all three working set…

  • data science

    How to Get a Data Analyst Job

    Data Analysts use data to answer questions about the state of an organization’s business. Since data is stored in computer systems, a Data Analyst needs to be comfortable with technology. Data Analysts investigate data problems and be able to communicate their findings. Sound like a good job? Read on to learn how to get a data analyst job. This is a good job for people who are Investigative on the Holland Scale. If you are a problem solver and like to think things through then this may be the job for you. My Holland Code is ISE (Investigative, Social, Enterprising) and I have found data analysis to be a good…

  • code

    Basic SQL Notes

    Here are my notes on SQL. This Notes series is meant to be light on narrative but heavy on code samples that you can copy and paste. At some point, if there is demand I will provide posts that explain what is actually happening. Datasets are located here https://data.world/mattjcamp/wiche-enrollment-projections and you can follow along right in the Data World web app. This project has two data tables: wiche_graduate_projections.csv and state_table.csv. Select All Columns From Table Essentially the simplest SQL query that you can write that returns records from a table. Join Two Tables Use JOIN or INNER JOIN to combine two tables when you only want records that appear in…

  • lifestyle business

    Can This Code Determine Work Satisfaction?

    Back in the Summer of 2018, I was in the middle of a work crisis that was so bad that went to see a therapist because I was afraid my mental health was at risk. The therapist I met with concluded that I was in the wrong job and we decided to work together to find my professional sweet spot. The idea was that my job was affecting me negatively and it was time to make a change. This therapist introduced me to the Holland Codes, a system developed by Dr. Holland that identifies a person with three out of six personality types that can be matched to jobs. You…

  • code,  covid-19

    Local Covid-19 Dashboard

    When I need a Data Science tool beyond vanilla SQL I usually reach for RStudio. There is no denying that R is fast and painless for doing statistical analysis, but it’s quirky and falls far out of the norms of coding and that’s always bugged me. So I’ve been debating making a switch. Lately, I’ve been experimenting with Python programming. Python is a very popular general-purpose programming language that is used in Data Science, but it’s also used to make apps, websites, and services. I’m particularly interested in using this language along with AWS services to publish small web APIs and things like that. But, I need to learn the…

  • ufology

    Is Bob Lazar for Real?

    I first learned about Bob Lazar last year when Netflix released a documentary titled Bob Lazar: Area 51 & Flying Saucers. This documentary was kinda crazy, it was filmed with a dramatic voice-over reading from a bizarre script. But, the subject of the film, Bob Lazar, seemed somewhat credible. Lazar and his associates have also appeared on the Joe Rogan podcast. For those of you who don’t know, Bob Lazar is a guy who claimed to work on reverse engineering alien technology for the government in 1989. His story was part of the reason that Area 51 became such an infamous spot in popular culture. The thing about Bob’s story…

  • time lapse photography of light on woman s head
    covid-19

    The Week I Hit My Breaking Point on Covid-19

    This week a video was circulating through social media showing a group of doctors, dressed in lab coats, and standing in front of the Supreme Court. They were having what seemed to be a press conference where they communicated their message which boiled down to “This virus has a cure, it’s called hydroxychloroquine, zinc, and Zithromax. You don’t need to worry about Covid-19, there is a cure.” The group is called “America’s Frontline Doctors”. The people pictured are in fact doctors who practice medicine. None are epidemiologists or immunologists. On that same day, America’s Frontline Doctors met with Vice President Pence. President Trump himself tweeted the video which helped it…

  • lifestyle business

    Personal Freedom

    I have been avoiding this topic for most of my adult life. Even when I’ve been at my lowest point. Even when I felt the worst. It was just too hard. Too much work. But wait, let me back up and give you some context. What am I talking about? Sounds serious, right? So, about two years ago I had a mental health crisis. Or at least I thought I had one. I was having panic attacks. I felt extremely anxious and occasionally depressed. I started drinking more than normal. My world felt like it was closing in on me. And it was. This was all toward the end of…

  • covid-19

    Is It Really Time to Reopen?

    So here we are at the end of May 2020. Our town has been closed since mid-March in an attempt to save the hospital system from total collapse due to the Coronavirus pandemic. And now, today, we are starting to come under mounting pressure to “reopen” our local economy. It’s hard to know what to think about this issue and what information sources to believe. Many people are misinformed and even the most informed people don’t know enough about this pandemic. This issue has become political and the stakes are high for the current government and for our collective future. So I wanted to take this time to try to…