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...
Category: Database
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...
Introduction of Database and Database Management System (DBMS)
As we are living in the age of Computer and Communication technology, we need data for all our daily life. For instance, a person withdraws money...