Common Table Expression (CTE) is a form of recursive SQL that makes a temporary result set of a query. It is an alternative to subqueries, views and user-defined functions that is useful for generating summary reports of a query. …

This post will cover what the S.O.L.I.D. principle is and show examples of each in Javascript so that you will have a SOLID understanding of it. Let’s break these down and show examples: Single Responsibility Principle A class should have one and only one reason to change, meaning that a class should only…

Most programmers are familiar with SQL (Structured Query Language) and Database Management Systems (DBMS) like PostgreSQL, SQL Server, Oracle, MongoDB, MariaDB, Redis, and MySQL. What you may not know is that these DBMS’s are either Relational or Non-Relational. …

This is a clickbaity title, but this was easily the most difficult code challenge problem that I have solved yet. This is in no way the most efficient solution to this problem, but it works. I am very interested if anyone reading this knows of a more elegant solution to…

This week I am going over some Javascript coding problems that I found rather challenging and learned a lot from working on. Shortest Substring Given a string input, find the shortest substring that has all of the unique letters of the string within it. For example, when given s = “dabbcabcd”, the…

Recursion Recursion is the process in which a function calls itself directly or indirectly. A recursive function is a function that calls itself during its execution. A simple example of a recursive function: const factorial = (n) => { if (n === 1) {…

This blog post will discuss how to implement Stacks and Queues in Javascript. Stack A stack is a linear data structure represented by a real physical stack or pile, a structure where insertion and deletion of items takes place at one end called top of the stack. The basic implementation of…

This blog post will discuss how to implement Array Lists and Hash Tables in Javascript. Array List An Array List uses a dynamic array for storing elements. Array Lists are created with an initial size, when this size is exceeded, it gets enlarged automatically. The elements shift whenever an element is deleted…

One of the most important principles of working with databases is that you always need a way to recover the database structures and data in case of an emergency. Some examples of an emergency could be that a table was loaded with bad data or a database structure was modified…