Category: Database

SQL Index

While executing SQL query, most important aspect to consider is performance.  So  how you achieve a good performance from database queries. Let us take the...

WHERE Vs HAVING CLAUSE IN SQL

While working with SQL, one of the question which often creates confusion is whether to use where or having clause.Though it appears that both clauses...

SQL – Select Statement

Select statement is a DML (Data Manipulation Language) statement.The SELECT statement is an SQL statement that specifies which rows and columns to fetch from one...

SQL Join

A SQL Join clause is used to combine rows from two or more tables, views, or materialized views based on a common field between them. A...

SQL – Drop Table

SQL – Drop Table is DDL (Data definition language) statement.The Drop Table command is used to delete table from database. Drop Table Statement : Removes named table...

SQL – Create Table

Create Table is a DDL (Data definition language) statement. The CREATE TABLE is used to create and define a new relational table. CREATE TABLE Statement :...

SQL – Alter Table

SQL – Alter Table is DDL (Data definition language) statement.The ALTER TABLE command is used to modify the definition (structure) of a table by modifying the...

What is SQL ?

Database is the most important part of decision system of any organization. Database stores the data of past and present and this data is used...

Types Of Databases

As we are in the age of computers, we deal with different kind of data in our day to day life. When we say about...