-
Have you been told “Use plain SQL, its faster than ORM” ?
You might have heard this advice before, Just use SQL; no need for ORMs. At first glance, that sounds elegant. SQL is expressive, close to the metal, and avoids the “magic” of an ORM. But as systems grow, accidental complexity sneaks in, the kind that comes not from business logic, but from all the…
-
A performance measurement for machine learning classification problem where output can be two or more classes, simply called as Confusion Matrix
Category: Day With AIIn Machine Learning, the problem of classification involves predicting the categorical class label to which the query data point belongs. And the confusion matrix is a tabular representation of the classification model’s performance. This tutorial will help you understand the confusion matrix and the various metrics that you can calculate from the confusion matrix.…
-
Saving and Reviving a Basic Machine Learning Model
Category: Day With AIIn Machine learning, while working with the scikit-learn (sklearn) library or any other modules, we need to save the trained models in a file and restore them in order to reuse them to compare the model with other models, to test the model on a new data. All the executed in this article can…
-
Introduction to DDL (Data Definition Language) in SQL
Category: UncategorizedWhen we talk about databases, we usually think of inserting, updating, or deleting data. But before doing any of that, we must first define the structure the blueprint of how data will be stored. That’s where DDL (Data Definition Language) comes in. What is DDL? DDL stands for Data Definition Language.It is a subset…
-
Understanding Common Table Expressions (CTE) in SQL — Simplifying Complex Queries
Category: UncategorizedIn SQL, we often deal with queries that involve multiple subqueries, aggregations, or recursive lookups. When these start to get long and unreadable, that’s where CTE (Common Table Expressions) come in. Let’s break it down from the basics, What is a CTE? A Common Table Expression (CTE) is a temporary named result set that…