Work in SQL
A lot of my experience in SQL revolves around pulling data for review and verification. My experience with SQL started out at a web-based SaaS company. Typically, I’d run SQL queries to verify functionality of new updates. This would require running JOIN queries (mostly LEFT, but occasionally I’d run an INNER JOIN as well) combining the Customer table with other tables like Customer Listings, Appraisals, and so forth. This also commonly used the GROUP BY command, so I could view information sorted by the Customer Number. To quickly verify data was maintained during an update, I would sometimes utilize COUNT to tally the number of listings a customer had before and after the process was complete.
I also have experience utilizing SQL to clean up messy data. While working on the dashboard for The Great Taco and Burrito Locator in Tableau, I found that many rows had blank spots in the most critical columns: The min and max menu prices, and the latitude and longitude. Rather than clear them by hand, I utilized MS SQL Server 2018 to help clean up data, removing anything that had NULL values for the Min or Max prices, as well as the latitude and longitude.
Overall, commands I’d say I’ve had a reasonable amount of experience with: SELECT, DELETE, FROM, WHERE, GROUP BY, COUNT, AVG, and JOIN. I also have some experience with MIN/MAX, ORDER BY, and CASE WHEN.
Additionally, I am familiar with both MS SQL and MySQL variants of the language. In the meantime, if you’d like to see some of my SQL code, please click the GitHub kitty:
Python Work
I’m relatively new to Python, having only been working with it for a month or two. I’m surprised at how robust it is, allowing for almost a programming language-level of code. In my courses, I’ve completed work like building a Rock-Paper-Scissors game and some simple commands for working with data. Eventually, I’d like to reach the point where I’m implementing pandas into my Python code. In the meantime, I’m working on a version of Hunt the Wumpus to broaden my skills and experience.
Trying to teach Long John about my childhood playing Hunt the Wumpus. He’s not terribly interested.