Sql commands you should know as a computer geek

Being a computer geek, there is a lot of information to learn each day it passes. Lately I am experimenting a little with the structured query language, a language which is a domain specific one. According to the information shared on Wikipedia, sql is a language which is being put to use to manage data in a relational database management system.
Continue reading “Sql commands you should know as a computer geek”

How to write a python script which communicates with the MySQL server

Python is a very useful utility when it comes to scripting automatic tasks. When interacting with a database management system in the backend, Python is my favorite programming language to automate the job. Through this blog post, I am going to teach you guys how to automate the process of interacting with a MySQL server by sharing the Python code which I have written for my personal usage.
Continue reading “How to write a python script which communicates with the MySQL server”

How to write a Python script to grab banners for network geeks

Lately i haven’t posted much because i have been busy working on some programming projects, but today i will share a python script with you guys. This script is written in pure python and it can be used to grab banners from different services running on your subnet. Some of these services are SSH, Telnet, FTP, SMTP etc.

This script is useful to system administrators to check their services and penetration testers to check the service for different vulnerabilities. We use the socket library, Continue reading “How to write a Python script to grab banners for network geeks”

How to make use of the Python pytube tool to download videos from YouTube

Introduction to the pytube tool

pytube is a python package written for the main purpose of downloading videos from the famous video website Youtube. According to the official documentation there are no third party dependencies to this tool, in other words it is a standalone package making use of the standard python libraries. Continue reading “How to make use of the Python pytube tool to download videos from YouTube”

A simple introduction to the fuser utility for linux geeks

What Is The fuser Command?

The fuser command is a very smart unix utility used to find which process is using a file, a directory or a socket. It also gives information about the user owning the process and the type of access. The fuser tool displays the process id(PID) of every process using the specified files or file systems.
Continue reading “A simple introduction to the fuser utility for linux geeks”

How to check CPU information through command line in Unix based operating systems

Sometimes you need to find information about your CPU on your Linux machine and there are many ways to do it. So in this tutorial I will teach you how to find details about your CPU such as processor, architecture, vendor name and many others that are very useful to you.

I like to learn how to do the same thing in different ways, especially when it comes to the Linux command line because it makes me practice many things and I feel closer to my dream of being a ninja. Continue reading “How to check CPU information through command line in Unix based operating systems”

How to read and write csv files with the help of Python programming language

When one starts their computer programming journey, there are many already builtin libraries and functions they need to explore with the main purpose of stepping their coding skills to the next level. A very useful Python package is the csv, a module which helps the Python programmer with prebuiltin utilities that can deal with comma-separated values.

For those of you who have never been exposed to the csv file format; a csv file is a simply a text file in which each line of data contains values separated by commas. Based on my personal experience with this popular format, it is mostly and widely being used to represent tabular data.
Continue reading “How to read and write csv files with the help of Python programming language”