No More Posts This Week

I've been fighting with my syntax highlighter for as long as I've been operating this blog. I have decided to move from SyntaxHighlighter (which is garbage in the visual editor) to Enlighter. Unfortunately, this change affects almost every post on this site, so I have a LOT of rework to do. While that's going on,

Weird Things in SQL

SQL, as we have already established, is built on collections of tables. These tables can be linked together by queries to form increasingly complex tables, which allows us to draw conclusions that would otherwise be extraordinarily difficult to obtain. There are some very powerful (yet weird) things we can do to create more useful queries. Aliases By

SQL Databases – It’s All in the Plan

It doesn't take very long to learn SQL, because it's a very simple scripting language with only four basic operations. No matter how complex you make your queries, with any number of conditions and tests, ultimately it boils down to CRUD. Why is it, then, that so few people can develop databases effectively? Like all

Building a Simple SQL Database

So, we've looked at the four basic SQL commands, but we haven't really seen any useful examples of how they would work. In a moment, we'll look at a set of commands that will create a basic database, fill it with some values, and run a simple SELECT command. These commands are designed to run

CRUD – The Things SQL Can Do

CRUD: Create, Read, Update, Destroy. These are the four basic database operations. Logically, they're the four basic data operations as well. CREATE - The act of producing new data which has not previously been introduced to the system. This data can be produced internally (through calculations, mostly) or externally (through input). READ - The act of retrieving

What is SQL? A Basic Introduction

In today's society, it's virtually impossible to find anyone who hasn't worked with Microsoft Excel at some point. We are somewhat familiar with the idea of spreadsheets and tables. We've written a simple macro or two. And, of course, there is great value to Excel and its competitors. But Excel is weak. It's virtually impossible

How to Use Big-O Notation

As we design functions, we have to consider how they will work in the real world. There are two common considerations as we compare solutions: Time complexity - The amount of time it will take for our solution to complete Space complexity - The amount of memory that our solution will consume Unfortunately, because we can't afford

Cleaning up – Comment out old code

If you've spent any appreciable time in the programming world, you've probably reorganized your code any number of times. When I'm writing code, I usually slap things out as I think of them, resulting in code that (while easy enough to read) defies the principle of unity. You'll see me write things like this: [c] int

A Quick Request

I'm still not back from my holiday due to an important family concern, so I'll not be ready to resume my regular posting schedule until after next week. I'm a bit disappointed in myself, because I do strive to put out content every week, but sometimes life happens. I do have one request for you