Backend Developer| Curious about how stuff works under the hood and how performance can be improved across platforms.
Transitioning to a NoSQL database can be daunting for folks who have spent the better part of their coding journey dabbling in RDBMS systems (like yours truly :)). Which is what inspired this article. If you are one of those who can whip up an SQL qu...
Blockchain, a technology that has become synonymous with Bitcoin, has the potential to revolutionize many spaces and sectors apart from the world of finance. This article attempts to provide a glimpse into three important applications of blockchain ...
Python has some pretty fantastic libraries when it comes to extracting and manipulating data from various sources and file formats. Today we will look at how to extract tabular data present in a pdf file using a popular python library Camelot. There...
Ever wondered what happens under the hood when you issue an SQL query to a database? Well, today we dive deep into the internal working of the Oracle RDBMS to understand how an application connects to the database and what processes are followed for ...
Vim - which has its humble beginnings as the console based default editor of the Unix OS, has over the years attained some street cred as one of the preferred editors for developers. With a large scope for customization , extensive open-source commun...
In continuation of the previous article on improving SQL query performance, let us examine a few table level modifications that can be made for faster output generation. Indexes For the uninitiated, an index is a special lookup table that is created...
We often query the database to gather insights and analyse relations between the different entities. But how frustrating is it when a simple SQL statement takes ages to fetch the desired results , keeping you as a data analyst/new developer guessing,...
A short walk-through of the different types of joins in SQL