New Model

Close panel
  •  
  •   New Model

  • Big Data BYOD Cloud Computing
  • Tutorials

    Close panel
  •  
  •   Web Design

  • CSS HTML JavaScript PHP XML
  •  
  •   Desktop

  • Access Captivate ColdFusion Dreamweaver Excel Flash Photoshop Project Sharepoint SQL Visio MS Word
  • eCommerce

    Close panel
  •  
  •   Getting Started

  • Making Money Online
  •  
  •   Methods

  • Affiliate Marketing eCommerce Store Google AdSense PODS Squidoo & Hubpages SEO
  • The Arts

    Close panel
  •  
  •   Fine Arts

  • Art Dance Music
  •  
  •   Contenporary Arts

  • Comedy Fashion Photography
  • Lifestyle

    Close panel
  •  
  •   Food & Drink

  • Beer Cooking Wine
  •  
  •   Recreation

  • Crafts Hobbies Sports
  •  
  •   Family

  • Babies Love
  • Home

    Cultural View of Technology logo

    Structured Query Language (SQL) Language

    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

    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