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...Mar 17, 2023·6 min read
How to install Microsoft Office* on Linux using WineLinux 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 soft...Jul 24, 2022·4 min read
How to organize your data with namingConventionsHave 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't the...Jul 8, 2022·4 min read
How to create Macros in Excel without ScriptingIf 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 y...Jun 30, 2022·4 min read
How to Scrape Data from Websites using Google SheetsIn this article I'll show you how easy it is to scrape data from websites using Google sheets. It's very basic in nature and can not be compared with web crawler scripts designed in python or in other programming languages but it's easy and who knows...Jun 29, 2022·5 min read
How to install R and R Studio on LinuxIf 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 langua...Jun 19, 2022·5 min read
