This article offers an overview of Stored procedures. 🧐 What is Stored Procedures Simply put, stored procedures are collections of one or more SQL statements that are kept for future use. Although you can think about them as batch files, they are more than that. SQLite does not support stored procedures. 🔗 Understanding Why to Use Stored Procedures To simplify complex operations…

In this article, we will take a ‘gentle’ introduction to SQL indexes 👾 — 💭 Understanding Indexes Indexes are used to logically sort data in order to speed up searching and sorting operations. Imagine the index at the beginning of a book to better understand indexes. Assume you wish to find every instance of the word cheese cake in this book. The simplest method would be to…

In this article, we'll discuss how to merge numerous SELECT queries into a single result set using the UNION operator, as well as the many forms of UNION and the distinction between a UNION and a JOIN. Understanding Combined Queries A single SELECT statement is present in the majority of…

This article will explain what aggregate functions are and how to use them. What is an Aggregate Functions They are functions that operate on a set of rows to calculate and return a single value, we see the aggregate functions here: AVG(): Returns a column’s average value. COUNT(): Returns the number of rows in a…

The beautiful world of joins, let’s dive deeper into it today! SQL joins are classified into four types based on the expected outcome of combining records, from two or more tables using common columns from the tables involved in the Join function. Inner join is used to find records that…

In this article we will learn about the SOLID principles and how to use them in Ruby 💎. SOLID Principles are concepts in object-oriented design that are relevant to software development. …

This is going to be a long article, so grab a cup of whatever you want and come have some fun! Let’s first of all create a new project, create an card model that has: title :string publisher :string published_at :datetime Open the rails console (type rails console in your…

The fundamentals and the Rails way ❤️ In this article, we’ll go over the fundamentals of MVC and how they apply to Rails. Before we get into the rails approach to MVC, let’s first define MVC. MVC Previously called “Thing Model View Editor” MVC is a design pattern for software application…

We all wanted to learn more about object oriented programming, what it is and what makes it so great; in this post, we will cover the fundamentals. First of all, what is OOP ? it is a programming paradigm based on the concept of “objects”, a car is an object…