What is DDL, DML, DQL and DCL in SQL?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 Databas...6 min read·abhishk.hashnode.devMar 17, 2023
What is Swap Space in Linux and Should You Use It?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 b...4 min read·abhishk.hashnode.devMar 16, 2023
How to create your own YouTube video downloader in python?An How-to guide to build your own YouTube downloader using Python and making it an Windows exe file so that it can be used on other Windows system.6 min read·abhishk.hashnode.devAug 26, 2022
What is Case statement in SQL and Is it same as IF/ELSE statement?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. CASE returns records ...4 min read·abhishk.hashnode.devJul 30, 2022
How to create a VS Code Server on Raspberry PiVS 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...4 min read·abhishk.hashnode.devJul 29, 2022