Linux Distributions
After Linus Torvalds created Linux back in the 1990s, he wanted to stop working for a little bit. So, what
Read moreAuthor: Krishna
Why Use Linux?
The reason that you should learn Linux and start deploying
Read moreHeuristic in Query optimization
Heuristic optimization often includes making transformations to the query tree by moving operators up and down the tree so that
Read moreQuery Optimization
Before query optimization is carried out, one would of course need to decide what needs to be optimized. The goal
Read moreQuery Processing
In most database systems, queries are posed in a non-procedural language like SQL and as we have noted earlier such
Read moreHow To Format USB Drive in Linux Command Line
Step 1 – Insert USB and Identify Volume $ df -h Filesystem Size Used Avail Use% Mounted on /dev/sda1 28G
Read moreData Manipulation Language in SQL (DML)
SQL language also includes syntax to update, insert, and delete records. These query and update commands together form the Data
Read moreData Definition Language (DDL) in SQL
The Data Definition Language (DDL) part of SQL permits database tables to be created or deleted. We can also define
Read moreCharacteristics of SQL Commands
Here you can see that SQL commands follow a number of basic rules: • SQL keywords are not normally case
Read moreSQL Commands
There are three groups of commands in SQL: 1. Data Definition 2. Data Manipulation and 3. Transaction Control
Read more