Transcend your Programming Skills and Thoughts
Data visualization is simply the understanding of data or its presentation in a visual context. It helps the relevant parties understand what has been presented visually so that they have the right information to make informed decisions. Data visualization helps one to understand concepts that could be very difficult in…
Read more
SQL Datatypes Data types specify the type of data for a particular column.If a column called “LastName” is going to hold names, then that particular column should have a “varchar” (variable-length character) data type.The most common data types: SQL Datatypes – Numeric INT -A normal-sized integer that can be signed…
Read more
SQL Reference JOIN, UNION, SET Operations. This article is all about those. Custom Names SELECT ct.ID, ct.Name, ord.Name, ord.Amount FROM customers AS ct, orders AS ord WHERE ct.ID=ord.Customer_ID ORDER BY ct.ID; Types of Join The following are the types of JOIN that can be used in MySQL: – INNER JOIN…
Read more
WordPress website transferring from remote to local machine, it is a necessary when it comes to backups or testing. This tutorial is all about WordPress website transferring from remote to local machine. Before we starting, we need the backups of Database, Website folder ((Normally, everything inside public-html folder of the…
Read more
Installing Composer on Debian. Composer is a dependency management tool used in PHP, to easily manage resources. Composer can install or update libraries, that you are using in your projects. Minimum Requirements : Debian 6, 7 or 8 PHP (including php-cli) Curl (use command sudo apt-get install curl, to install…
Read more
VestaCP Creating Packages, adding Users. In VestaCP you can as many as packages you want.Users too. So, For creating one package there are some minimum requirements. The following package is with minimum requirements. You can expand or shrink these with as per your requirements. Step 1 : Adding a new…
Read more
Vestacp Hosting Control Panel Setup. Many of you don’t know how to do Vestacp Hosting Control Panel Setup. So, here it is for those, who have a system with a terminal and ssh access only. # ——————————————– # Vestcp Setup – Debian 8 # ——————————————– > sudo apt-get update >…
Read more
Cannot load JDBC driver class ‘com.mysql.jdbc.Driver’ on Intellij is an error shows due to driver files missing. To resolve an issue like this follow the following procedure. How to add the JDBC library using Intellij: Steps 1.) Goto View -> Tool Windows -> Database. 2.) Now, Select a database and…
Read more
IntelliJ vs Eclipse Keymap Action IntelliJ IDEA Eclipse Open any file quickly Ctrl + Shift + N Ctrl + Shift + R Find a type or class Ctrl + N Ctrl + Shift + T Show all the members of current type Ctrl + F12 Ctrl + O Jump to…
Read more
Debian Linux Mint F.lux error quick fix. Sometimes, F.lux will not automatically start in your Debian systems. It also, happened to me. So, what i did was manually setting the f.lux configuration and adding it to the startup program. xflux must be installed on your system. To test this, open…
Read more