Making sense of computers

How to use LeetCode without melting your brain

For those of you who are preparing for the so called “technical interviews” at any kind of coding position, LeetCode is probably your bread and butter. For the rest of the blissfully unaware folks, LeetCode (often abbreviated as LC) is a platform where people go to torment their brain … I mean to improve their programming skills. LC is especially famous for improving the so called Data Structures and Algorithms (DSA) skills. What is DSA Read more…

By Sohhom, ago

Python Availability In Excel – A New Era Of Data Analysis

Microsoft announced on August 22, 2023 that Excel will support Python functions. What does it mean for you, a data wrangler? Let’s find out what the official docs say and how other people have reacted. Microsoft Excel needs no introduction to anyone who has used tabular data. Spreadsheets were introduced was (and continues to be) the workhorse of data storage, manipulation and behind businesses at all levels. Python, along with the scientific computing packages NumPy, Read more…

By Sohhom, ago

Future of technology with artificial intelligence: what did experts say in 2022 and 2023?

This page is a collection of recent videos on the significant advances in artificial intelligence. These advances are actually did not happen overnight. However, since the release of Stable Diffusion in August 2022 and ChatGPT in November 2022, there seems to be an ongoing race to release new AI/ML based products for various purposes. Between the giant tech companies such as Microsoft, Google and Meta, and new contenders such as OpenAI, Cohere and Anthropic, we Read more…

By Sohhom, ago

So You Want To Land a Developer Relations Role

Ever read some technical documentation that leaves you scratching your head? Or the opposite — admire the friction-less experience of using a new tool or library? In both cases, you probably had some DevRel professionals to blame/thank for that! Developer Relations, often abbreviated as DevRel, is a discipline which exists to make it easy for a company to communicate to its users, when those users are actually programmers i.e. developers. Unlike normal sales roles, this Read more…

By Sohhom, ago

Beginner’s Guide on Sharing Files Across Devices

In today’s connected world, we often need to share files between different devices like computers, phones, and tablets. Whether you want to transfer photos from your phone to your laptop or collaborate on a work document with a colleague remotely, there are several ways to easily share files across devices. P2P File Sharing One of the most straightforward ways to share files is through peer-to-peer (P2P) file sharing. This allows you to directly connect two Read more…

By Sohhom, ago

Introduction to Main Memory a.k.a RAM

The incredible speed, precision, and functionality in our everyday digital devices can be primarily attributed to two essential components: the processor and the functioning of ‘Main Memory’ also known as Random Access Memory (RAM). In this article we look at this key aspect of our computers, whether laptop or desktop, to gain a more profound comprehension of what goes under their device’s enclosure. The main memory is the heart of your laptop or desktop’s performance Read more…

By Sohhom, ago

Brief introdution to SQL

Structured Query Language (SQL) is an essential skill for data scientists. It allows them to interact with and manipulate large datasets stored in relational databases. Proficiency in SQL can help data scientists to clean, transform, and analyze data, enabling them to draw insights from the data they work with effectively. In this article, we will examine SQL’s essential features and provide examples of how they can be used for data manipulation in a data science Read more…

By Sohhom, ago

A Quick Introduction to DNS

Introduction to DNS DNS, or the Domain Name System, might sound highly technical, but its essence is easy to understand. Remember the process of trying to navigate to a new destination — you would plug the address into your trusty GPS device and voilà, turn by turn, it would direct you to your destination. DNS achieves something similar, albeit within the realm of internet communication. If you have ever wondered how your device knows which Read more…

By Sohhom, ago