Software coding is never easy. We all know that. But what if you were given a challenge? In particular, what if you were asked to write a program to generate a maze, using any language you like, from Python to SQL to C#? The only constraint? To be able to demonstrate what you’ve done,... Read more
Mob programming is an emerging agile development approach for creating software. The whole development team gets in a room and works together on the same problem, at the same time, on a single computer. I spent a full week doing mob programming with my current team and I’d like to share my impressions and... Read more
Many freelancers find projects on online job platforms like Upwork and Freelancer. What kind of database model powers these sites? Let’s take a look ... Read more
Across the globe, the job portal site is a well-known feature of the Internet landscape. Big players like Indeed and Monster have turned job hunting and recruiting into a veritable online industry. Let’s dive into the elementary features leveraged by job portals and build a data model that can support them. Read more
When you’re using a data warehouse, some actions get repeated over and over. We will take a look at four common algorithms used to deal with these situations. Read more
Software development is a difficult and demanding discipline. It gets even more difficult when you bring teams of developers and database administrators together on a single project. One of the fundamental issues arises around the code itself. Who is responsible for what piece of it? What changes have they made? How do you get... Read more
The fledgling computer industry did not invent version control. It merely adopted practices that were already well established in industrial manufacturing and design, where large, complex machines such as aircraft, tanks or motor cars required a great deal of discipline, particularly in the technical drawing of components. It all started with engineering The engineering... Read more
If you ran a MOOC online learning platform like edX or Coursera, how would you keep it organized? In this article, we’ll look at a database model that would do the job. Read more
Call them taxis or cabs, these convenient rides for rent have been around for centuries. Nowadays, it’s a lot more complicated to run a taxi service. In this article, we’ll look at a database model designed to meet the needs of a cab company. Read more
When writing SQL, you can use SQL Prompt to quickly jump to some really handy formatting and refactoring actions. This little button right here is called the Actions List and it contains over 20 functions and snippets you can use in just a few keystrokes. Simply highlight your block of code and hit Ctrl,... Read more
