SQL Tutorial

SQL Intro: What is SQL?

What is SQL? SQL stands for “Structured Query Language” and can be pronounced as “SQL” or “sequel – (Structured English Query Language)”. Defined, SQL is a query language used for accessing and modifying information in the database.

SQL Database Design

IBM first developed SQL in 1970s. Also it is an ANSI/ISO standard. It has become a Standard Universal Language used by most of the relational database management systems (RDBMS). Some of the RDBMS systems are: Oracle, Microsoft SQL server, Sybase etc. Most of these have provided their own implementation thus enhancing it's feature and making it a powerful tool.

SQL Commands: Few SQL Coding Statements?

Few of the sql commands used in sql code programming are:SELECT Statement, UPDATE Statement, INSERT INTO Statement,DELETE Statement, WHERE Clause, ORDER BY Clause, GROUP BY Clause, Subquery Clauses, Joins, Views, GROUP Functions,Indexes etc.

My SQL DataBase

In a simple manner, SQL is a non-procedural, English-like language that processes data in groups of records rather than one record at a time. Few functions of SQL are:

• store data
• modify data
• retrieve data
• modify data
• delete data
• create tables and other database objects
• delete data

Beginner SQL Reference

SQL Tutorial Topics

SQL Statements

• SQL SELECT
• SQL INSERT
• SQL UPDATE
• SQL DELETE
• SQL CREATE TABLE
• SQL ALTER TABLE
• SQL RENAME
• SQL TRUNCATE
• SQL DROP

SQL Clauses

• SQL WHERE
• SQL ORDER BY
• SQL GROUP BY
• SQL HAVING

SQL Operators

• SQL Logical Operators
• SQL Comparision Operators
• SQL LIKE, IN, ISNULL, BETWEEN..AND

SQL Integrity Constraints

• Primary Key Constraint
• Foreign Key Constraint
• Not Null Constraint
• Unique Key Constraint
• Check Constraint

SQL Other Topics

• SQL Commands
• SQL Aliases
• SQL Group Functions
• SQL JOINS
• SQL VIEWS
• SQL Subquery
• SQL Index
• SQL GRANT, REVOKE