Home     SQL Basic     Contact Us     Site Map    

SQL BASIC

SQL SELECT

SQL WHERE

SQL DISTINCT

SQL AND

SQL OR

SQL NOT

SQL ORDER BY

SQL IN

SQL BETWEEN

SQL LIKE

SQL ALIAS

SQL AGGREGATE

>SQL COUNT

>SQL SUM

>SQL MAX

>SQL MIN

>SQL AVG

SQL GROUP BY

SQL HAVING

SQL INSERT

SQL UPDATE

SQL DELETE

SQL SELECT INTO

SQL CREATE DATABASE

SQL CREATE TABLE

SQL DROP TABLE

SQL DROP DATABASE

SQL CREATE INDEX

SQL PRIMARY KEY

SQL FOREIGN KEY

SQL ALTER TABLE

SQL TRUNCATE TABLE

SQL JOIN

SQL INNER JOIN

SQL OUTER JOIN

SQL CROSS JOIN

SQL UNION

SQL UNION ALL

SQL INTERSECT



SQL BASIC

SQL is a standard computer language for accessing and manipulating databases. SQL is also known as computer language used to create, modify, retrieve and manipulate data from relational database management systems.

Client Program communicate your intent to the database server by means of queries written in Structured Query Language which known as SQL. Also can known as the language of relational databases.

Why SQL so important?
By learning SQL, the big advantage for you, is that, you will able to interact with numerous databases across all platform.

Just Imagine how horrible life will be if all the database tools like Oracle, MySQL, SQL server had entirely different sets of command to call the data and put the data from the database store.