Data Analytics
SQL stands for Structured Query Language and it is a comprehensive language for manipulating databases. SQL can be used to create, modify, query, and control data in database systems such as PostgreSQL, MySQL, Microsoft SQL Server, and Oracle Database. However, SQL is not a single monolithic language; it can be
Linux
Swap space is a feature of Linux that allows the system to use some disk space as additional memory when the physical memory (RAM) is full. Swap space can be either a dedicated partition on the hard disk or a special file on the filesystem. In this blog post, we
Python
Learning a Programming language is a waste if you can't do cool things with it and things that makes your life easier. Like you can control your appliances using microcontrollers like Arduino and program them to turn the light switch on/off with a single click on your
Data Analytics
Yes, it kind of is same as IF/ELSE statement but instead of writing IF/ELSE, we use WHEN, THEN and ELSE. I know it sounds different but trust me it pretty much has the same function and it all comes under the SQL CASE Statement. What is Case? CASE
Raspberry Pi
VS Code is a powerful Code editor and a must have item in a developers toolkit. It is available on pretty much every platform like Windows, MacOS and even on Linux but what if you want to edit your code on-the-go with your iPad/ Android Tablets or in your Chromebook
Linux
Linux is awesome! You can do anything you want with it like resurrect your old computer, create a home server or even a cloud storage for yourself. Even though with it's super awesome feature set the one thing it is missing is modern proprietary software support, I mean
Data Analytics
Have you ever been in a situation where you want to send someone an important file really fast but you're not able to locate it after searching and even if you were able to find it, you end up sending the wrong one because final Draft.docx wasn&
Data Analytics
If you are someone who often spend time cleaning and processing raw and dirty data in spreadsheets you know how repetitive some tasks can be like filtering the data, sorting it, trimming unwanted spaces or writing same function several time. I mean you surely can just work your way out
Data Analytics
Uncover the simplicity of web data scraping with Google Sheets in this article. While it may not match the complexity of Python scripts, it's user-friendly and might suit your needs. Before we dive in, let's address the ethics of web scraping. Although not a major concern
Linux
If you're looking to install R on Linux that means you already know and familiar with R then you can just directly go to the instructions below but if you're new and still learning and figuring out about it, let me explain. R is a programming
