Cultural View of Technology logo

Structured Query Language (SQL)

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.

Video Tutorial Sets

Select a video tutorial set from our collection

Topical Tutorials

Here are a a few tutorials that cover specific topics that you may find of interest:

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