Truly enjoying this Intro to Database Systems course from Carnegie Mellon University. Some really great breakdowns of common join algorithms in this lecture. Here are my notes. Lecture 11- Join Algorithms (CMU Databases Systems / Fall 2019) Prof. Andy Pavlo, Carnegie Mellon Database Group screenshot from lecture Table Positioning for a Join “In general, your […]
Follow the three step path to enlightenment and productivity gained: Write scripts. Follow them manually. Refine and automate if preferable. Below I “scripted” out catching my flight from Chicago’s O’hare Airport to Denver. Writing things down is often the first step to realizing what needs done. Ideally, you’d turn those written steps into a script […]
Preface These are my YouTube lecture notes from MIT’s Distributed Systems course. Thank you MIT and Professor Morris! MIT 6.824 Distributed Systems Lecture 2: RPC and Threads – Feb 7, 2020 Prof. Robert Morris (Spring 2020) Introduction Go is a popular programming language choice so my ears perked up when this lecture began. These notes […]
Thank you Carnegie Mellon Database Group for putting this online! These are my notes from watching on YouTube. Carnegie Mellon Databases Storage II, Lecture 4 Prof. Andy Pavlo [Watch on YouTube] The Problem and Solution How should the DBMS represent the database in storage files on disk? Solve it by choosing the right storage model […]
Below you’ll find a balanced curriculum of juicy courses and videos that are available for free on the internet. I’ll definitely be diving into most of these in the 2nd half of 2020. Stay curious! University CS Courses For Free CS50’s Web Programming with Python and JavaScript | Harvard University CS 61-C Great Ideas in […]
Sometimes a spark comes from seemingly nowhere. That’s when you reach for your tools and create. After a series of successful experiments, I decided this stack might be my quickest, best shot to get a functional website up and running in Python. I was pleasantly surprised to make rapid progress over the span of a […]
This is the post I wish I could have read before I approached my first API. All APIs have their own style, quirks and unique requirements. This post explains general terminology, tips and examples if you’re looking to tackle your first API. Here’s what is covered: API & HTTP Lingo You Should Know Testing and […]
Preface I always enjoy reading when technical people share their stories of the times things went a little haywire. Times when, despite their best intentions, a solution didn’t work as planned and it ends in unpleasant or catastrophic failure. I had an experience like this recently, so here’s my “oops” story. Fortunately, I think this […]
Here are a few useful corners of the vast array of Windows scripting tools. Helpful Windows Command Line Documentation Windows command line Documentation Syntax Command-line reference A-Z Command shell overview Using command redirection operators About Windows Remote Management A Few General Windows Commands Use find to look in a text file to count the lines […]
Prior to learning Python, I had no programming experience. I worked in marketing for a book publisher and did not perform well at my job. It was not a good fit. They eventually fired me. As my previous job unraveled, I discovered Python and the Coursera course, Programming for Everybody (Getting Started with Python). Fortunately, […]
