Free eBook —Structured Query Language (SQL)

All that wikipedia can tell you about Structured Query Language (SQL)
Download the PDF

 

Structured Query Language (SQL) is an ANSI (American National Standards Institute) Standard computer language. It is used to manage data stored in databases. Its basic functions are inputting, modifying, and deleting data from databases.

Although SQL is an ANSI standard, there are many flavors of the SQL language availble. For each of these variations to be compliant with the ANSI standard, they must all support at least the major commands (such as SELECT, UPDATE, DELETE, INSERT, WHERE) in a similar way.

 

 

SQL SELECT
SQL DISTINCT
SQL WHERE
SQL AND OR
SQL IN
SQL BETWEEN
SQL Wildcard
SQL LIKE
SQL ORDER BY
SQL Functions
SQL Average
SQL COUNT
SQL MAX
SQL MIN
SQL SUM
SQL GROUP BY
SQL HAVING
SQL ALIAS
SQL AS
SQL JOIN
SQL OUTER JOIN
SQL SELECT UNIQUE
SQL CONCATENATE
SQL SUBSTRING
SQL TRIM
SQL LENGTH
SQL REPLACE
SQL DATEADD
SQL DATEDIFF
SQL DATEPART
SQL GETDATE
SQL SYSDATE

SQL CREATE TABLE
SQL CONSTRAINT
SQL NOT NULL
SQL DEFAULT
SQL UNIQUE
SQL CHECK
SQL PRIMARY KEY
SQL FOREIGN KEY
SQL View
SQL CREATE VIEW
SQL Index
SQL CREATE INDEX
SQL ALTER TABLE
SQL DROP TABLE
SQL TRUNCATE TABLE
SQL USE
SQL INSERT INTO
SQL UPDATE
SQL DELETE FROM

SQL UNION
SQL UNION ALL
SQL INTERSECT
SQL MINUS
SQL LIMIT
SQL TOP
SQL Subquery
SQL EXISTS
SQL CASE
SQL NULL
SQL ISNULL
SQL IFNULL
SQL NVL
SQL COALESCE
SQL NULLIF
SQL Rank
SQL Median
SQL Running Totals
SQL Percent to Total
SQL Cumulative Percent to Total

SQL OVERVIEW
SQL BASICS
SQL SELECT
SQL WHERE
SQL INSERT
SQL UPDATE
SQL DELETE

SQL ADMINISTRATION
SQL CREATE DATABASE
SQL DROP DATABASE
SQL CREATE TABLE
SQL ALTER TABLE
SQL DROP TABLE
SQL CREATE INDEX
SQL DROP INDEX
SQL ADD FOREIGN KEY
SQL DROP FOREIGN KEY
SQL CREATE VIEW
SQL DROP VIEW

SQL ADVANCED
SQL CONCAT
SQL SUBSTRING
SQL TRIM
SQL AND & OR
SQL IN
SQL BETWEEN
SQL LIKE
SQL DISTINCT
SQL GROUP BY
SQL AGGREGATE
SQL HAVING
SQL ORDER BY
SQL JOIN
SQL OUTER JOIN

SQL - Introduction
SQL - Databases

SQL - Tables

SQL - Queries

SQL - Select

SQL - Where

SQL - As
SQL - Operators
SQL - Create
SQL - Insert

SQL - And / Or
SQL - Between
SQL - Order By

SQL - Update

SQL - Alter

SQL - Distinct
SQL - Subqueries

SQL - Join

SQL - In

SQL - Case

SQL - Group By

SQL - Views
SQL - Dates

SQL - Datepart

SQL - Dateadd

SQL - Delete

SQL - Union
SQL - Syntax

SQL - Data Types

SQL - Expressions

SQL - History
SQL - Platforms

SQL - Commands

SQL - Structure

SQL - Predicates
SQL - Identifiers

 

 


 

 

 
Share |

Visit our Flash video library

Featured video
Training Sessions from Hell

Training Sessions from Hell