SQL is a standard language for accessing and manipulating databases.
What is SQL?
- SQL stands for Structured Query Language
- SQL lets you access and manipulate databases
- SQL became a standard of the American National Standards Institute (ANSI) in 1986, and of the International Organization for Standardization (ISO) in 1987
SQL Examples
Learn by examples! This tutorial supplements all explanations with clarifying examples.
SQL Data Types
Data types and ranges for Microsoft Access, MySQL and SQL Server.
Curriculum
- 14 Sections
- 313 Lessons
- 10 Weeks
Expand all sectionsCollapse all sections
- SQL Server - Advanced Functions13
- 1.1SQL Server CAST() Function
- 1.2SQL Server COALESCE() Function
- 1.3SQL Server CONVERT() Function
- 1.4SQL Server CURRENT_USER Function
- 1.5SQL Server IIF() Function
- 1.6SQL Server ISNULL() Function
- 1.7SQL Server ISNUMERIC() Function
- 1.8SQL Server NULLIF() Function
- 1.9SQL Server SESSION_USER Function
- 1.10SQL Server SESSIONPROPERTY() Function
- 1.11SQL Server SYSTEM_USER Function
- 1.12SQL Server USER_NAME() Function
- 1.13MS Access Functions
- MS Access Functions - String Functions24
- 2.1MS Access Functions
- 2.2MS Access Asc() Function
- 2.3MS Access Chr() Function
- 2.4MS Access Concat With &
- 2.5MS Access CurDir() Function
- 2.6MS Access Format() Function
- 2.7MS Access InStr() Function
- 2.8MS Access InstrRev() Function
- 2.9MS Access LCase() Function
- 2.10MS Access Left() Function
- 2.11MS Access Len() Function
- 2.12MS Access LTrim() Function
- 2.13MS Access Mid() Function
- 2.14MS Access Replace() Function
- 2.15MS Access Right() Function
- 2.16MS Access RTrim() Function
- 2.17MS Access Space() Function
- 2.18MS Access Split() Function
- 2.19MS Access Str() Function
- 2.20MS Access StrComp() Function
- 2.21MS Access StrConv() Function
- 2.22MS Access StrReverse() Function
- 2.23MS Access Trim() Function
- 2.24MS Access UCase() Function
- MS Access - Numeric Functions0
- Introduction to SQLSQL is a standard language for storing, manipulating and retrieving data in databases. Our SQL tutorial will teach you how to use SQL in: MySQL, SQL Server, MS Access, Oracle, Sybase, Informix, Postgres, and other database systems.37
- 4.1Introduction to SQL
- 4.2SQL Syntax
- 4.3SQL SELECT Statement
- 4.4SQL SELECT DISTINCT Statement
- 4.5SQL WHERE Clause
- 4.6SQL AND, OR and NOT Operators
- 4.7SQL ORDER BY Keyword
- 4.8SQL INSERT INTO Statement
- 4.9SQL NULL Values
- 4.10SQL UPDATE Statement
- 4.11SQL DELETE Statement
- 4.12SQL TOP, LIMIT, FETCH FIRST or ROWNUM Clause
- 4.13SQL MIN() and MAX() Functions
- 4.14SQL COUNT(), AVG() and SUM() Functions
- 4.15SQL LIKE Operator
- 4.16SQL Wildcards
- 4.17SQL IN Operator
- 4.18SQL BETWEEN Operator
- 4.19SQL Aliases
- 4.20SQL Joins
- 4.21SQL INNER JOIN Keyword
- 4.22SQL LEFT JOIN Keyword
- 4.23SQL RIGHT JOIN Keyword
- 4.24SQL FULL OUTER JOIN Keyword
- 4.25SQL Self Join
- 4.26SQL UNION Operator
- 4.27SQL GROUP BY Statement
- 4.28SQL HAVING Clause
- 4.29SQL EXISTS Operator
- 4.30SQL ANY and ALL Operators
- 4.31SQL SELECT INTO Statement
- 4.32SQL INSERT INTO SELECT Statement
- 4.33SQL CASE Expression
- 4.34SQL NULL Functions
- 4.35SQL Stored Procedures for SQL Server
- 4.36SQL Comments
- 4.37SQL Operators
- SQL DatabaseThe SQL CREATE DATABASE Statement The CREATE DATABASE statement is used to create a new SQL database. Syntax CREATE DATABASE databasename;20
- 5.1The SQL CREATE DATABASE Statement
- 5.2SQL DROP DATABASE Statement
- 5.3SQL BACKUP DATABASE for SQL Server
- 5.4SQL CREATE TABLE Statement
- 5.5SQL DROP TABLE Statement
- 5.6SQL ALTER TABLE Statement
- 5.7SQL Constraints
- 5.8SQL NOT NULL Constraint
- 5.9SQL UNIQUE Constraint
- 5.10SQL PRIMARY KEY Constraint
- 5.11SQL FOREIGN KEY Constraint
- 5.12SQL CHECK Constraint
- 5.13SQL DEFAULT Constraint
- 5.14SQL CREATE INDEX Statement
- 5.15SQL AUTO INCREMENT Field
- 5.16SQL Working With Dates
- 5.17SQL Views
- 5.18SQL Injection
- 5.19SQL Hosting
- 5.20SQL Data Types for MySQL, SQL Server, and MS Access
- SQL ReferencesThis SQL keywords reference contains the reserved words in SQL.80
- 6.1SQL Keywords Reference
- 6.2SQL ADD Keyword
- 6.3SQL ADD CONSTRAINT Keyword
- 6.4SQL ALL Keyword
- 6.5SQL ALTER Keyword
- 6.6SQL ALTER COLUMN Keyword
- 6.7SQL ALTER TABLE Keyword
- 6.8SQL AND Keyword
- 6.9SQL ANY Keyword
- 6.10SQL AS Keyword
- 6.11SQL ASC Keyword
- 6.12SQL BACKUP DATABASE Keyword
- 6.13SQL BETWEEN Keyword
- 6.14SQL CASE Keyword
- 6.15SQL CHECK Keyword
- 6.16SQL COLUMN Keyword
- 6.17SQL CONSTRAINT Keyword
- 6.18SQL CREATE Keyword
- 6.19SQL CREATE DATABASE Keyword
- 6.20SQL CREATE INDEX Keyword
- 6.21SQL CREATE OR REPLACE VIEW Keyword
- 6.22SQL CREATE TABLE Keyword
- 6.23SQL CREATE PROCEDURE Keyword
- 6.24SQL CREATE UNIQUE INDEX Keyword
- 6.25SQL CREATE VIEW Keyword
- 6.26SQL DATABASE Keyword
- 6.27SQL DEFAULT Keyword
- 6.28SQL DELETE Keyword
- 6.29SQL DESC Keyword
- 6.30SQL SELECT DISTINCT Keyword
- 6.31SQL DROP Keyword
- 6.32SQL DROP COLUMN Keyword
- 6.33SQL DROP CONSTRAINT Keyword
- 6.34SQL DROP DATABASE Keyword
- 6.35SQL DROP DEFAULT Keyword
- 6.36SQL DROP INDEX Keyword
- 6.37SQL DROP TABLE and TRUNCATE TABLE Keywords
- 6.38SQL DROP VIEW Keyword
- 6.39SQL EXEC Keyword
- 6.40SQL EXISTS Keyword
- 6.41SQL FOREIGN KEY Keyword
- 6.42SQL FROM Keyword
- 6.43SQL FULL OUTER JOIN Keyword
- 6.44SQL GROUP BY Keyword
- 6.45SQL HAVING Keyword
- 6.46SQL IN Keyword
- 6.47SQL INDEX Keyword
- 6.48SQL INNER JOIN Keyword
- 6.49SQL INSERT INTO Keyword
- 6.50SQL INSERT INTO SELECT Keyword
- 6.51SQL IS NULL Keyword
- 6.52SQL IS NOT NULL Keyword
- 6.53SQL JOIN Keyword
- 6.54SQL LEFT JOIN Keyword
- 6.55SQL LIKE Keyword
- 6.56SQL SELECT TOP, LIMIT and ROWNUM Keywords
- 6.57SQL NOT Keyword
- 6.58SQL NOT NULL Keyword
- 6.59SQL OR Keyword
- 6.60SQL ORDER BY Keyword
- 6.61SQL FULL OUTER JOIN Keyword
- 6.62SQL PRIMARY KEY Keyword
- 6.63SQL CREATE PROCEDURE Keyword
- 6.64SQL RIGHT JOIN Keyword
- 6.65SQL SELECT TOP, LIMIT and ROWNUM Keywords
- 6.66SQL SELECT Keyword
- 6.67SQL SELECT DISTINCT Keyword
- 6.68SQL SELECT INTO Keyword
- 6.69SQL SELECT TOP, LIMIT and ROWNUM Keywords
- 6.70SQL SET Keyword
- 6.71SQL TABLE Keyword
- 6.72SQL SELECT TOP, LIMIT and ROWNUM Keywords
- 6.73SQL DROP TABLE and TRUNCATE TABLE Keywords
- 6.74SQL UNION Keyword
- 6.75SQL UNION ALL Keyword
- 6.76SQL UNIQUE Keyword
- 6.77SQL UPDATE Keyword
- 6.78SQL VALUES Keyword
- 6.79SQL VIEW Keyword
- 6.80SQL WHERE Keyword
- SQL Server Functions -String FunctionsSQL Server has many built-in functions. This reference contains string, numeric, date, conversion, and some advanced functions in SQL Server.31
- 7.1SQL Server Functions
- 7.2SQL Server ASCII() Function
- 7.3SQL Server CHAR() Function
- 7.4SQL Server CHARINDEX() Function
- 7.5SQL Server CONCAT() Function
- 7.6SQL Server Concat With +
- 7.7SQL Server CONCAT_WS() Function
- 7.8SQL Server DATALENGTH() Function
- 7.9SQL Server DIFFERENCE() Function
- 7.10SQL Server FORMAT() Function
- 7.11SQL Server LEFT() Function
- 7.12SQL Server LEN() Function
- 7.13SQL Server LOWER() Function
- 7.14SQL Server LTRIM() Function
- 7.15SQL Server NCHAR() Function
- 7.16SQL Server PATINDEX() Function
- 7.17SQL Server QUOTENAME() Function
- 7.18SQL Server REPLACE() Function
- 7.19SQL Server REPLICATE() Function
- 7.20SQL Server REVERSE() Function
- 7.21SQL Server RIGHT() Function
- 7.22SQL Server RTRIM() Function
- 7.23SQL Server SOUNDEX() Function
- 7.24SQL Server SPACE() Function
- 7.25SQL Server STR() Function
- 7.26SQL Server STUFF() Function
- 7.27SQL Server SUBSTRING() Function
- 7.28SQL Server TRANSLATE() Function
- 7.29SQL Server TRIM() Function
- 7.30SQL Server UNICODE() Function
- 7.31SQL Server UPPER() Function
- SQL Server - Numeric Functions:28
- 8.1SQL Server ABS() Function
- 8.2SQL Server ACOS() Function
- 8.3SQL Server ASIN() Function
- 8.4SQL Server ATAN() Function
- 8.5SQL Server ATN2() Function
- 8.6SQL Server AVG() Function
- 8.7SQL Server CEILING() Function
- 8.8SQL Server COUNT() Function
- 8.9SQL Server COS() Function
- 8.10SQL Server COT() Function
- 8.11SQL Server DEGREES() Function
- 8.12SQL Server EXP() Function
- 8.13SQL Server FLOOR() Function
- 8.14SQL Server LOG() Function
- 8.15SQL Server LOG10() Function
- 8.16SQL Server MAX() Function
- 8.17SQL Server MIN() Function
- 8.18SQL Server PI() Function
- 8.19SQL Server POWER() Function
- 8.20SQL Server RADIANS() Function
- 8.21SQL Server RAND() Function
- 8.22SQL Server ROUND() Function
- 8.23SQL Server SIGN() Function
- 8.24SQL Server SIN() Function
- 8.25SQL Server SQRT() Function
- 8.26SQL Server SQUARE() Function
- 8.27SQL Server SUM() Function
- 8.28SQL Server TAN() Function
- SQL Server - Date Functions:13
- 9.1SQL Server CURRENT_TIMESTAMP Function
- 9.2SQL Server DATEADD() Function
- 9.3SQL Server DATEDIFF() Function
- 9.4SQL Server DATEFROMPARTS() Function
- 9.5SQL Server DATENAME() Function
- 9.6SQL Server DATEPART() Function
- 9.7SQL Server DAY() Function
- 9.8SQL Server GETDATE() Function
- 9.9SQL Server GETUTCDATE() Function
- 9.10SQL Server ISDATE() Function
- 9.11SQL Server MONTH() Function
- 9.12SQL Server SYSDATETIME() Function
- 9.13SQL Server YEAR() Function
- MS Access - String Functions23
- 10.1MS Access Asc() Function
- 10.2MS Access Chr() Function
- 10.3MS Access Concat With &
- 10.4MS Access CurDir() Function
- 10.5MS Access Format() Function
- 10.6MS Access InStr() Function
- 10.7MS Access InstrRev() Function
- 10.8MS Access LCase() Function
- 10.9MS Access Left() Function
- 10.10MS Access Len() Function
- 10.11MS Access LTrim() Function
- 10.12MS Access Mid() Function
- 10.13MS Access Replace() Function
- 10.14MS Access Right() Function
- 10.15MS Access RTrim() Function
- 10.16MS Access Space() Function
- 10.17MS Access Split() Function
- 10.18MS Access Str() Function
- 10.19MS Access StrComp() Function
- 10.20MS Access StrConv() Function
- 10.21MS Access StrReverse() Function
- 10.22MS Access Trim() Function
- 10.23MS Access UCase() Function
- MS Access - Numeric Functions18
- 11.1MS Access Abs() Function
- 11.2MS Access Atn() Function
- 11.3MS Access Avg() Function
- 11.4MS Access Cos() Function
- 11.5MS Access Count() Function
- 11.6MS Access Exp() Function
- 11.7MS Access Fix() Function
- 11.8MS Access Format() Function
- 11.9MS Access Int() Function
- 11.10MS Access Max() Function
- 11.11MS Access Min() Function
- 11.12MS Access Randomize() Function
- 11.13MS Access Rnd Function
- 11.14MS Access Round() Function
- 11.15MS Access Sgn() Function
- 11.16MS Access Sqr() Function
- 11.17MS Access Sum() Function
- 11.18MS Access Val() Function
- MS Access - Date Functions20
- 12.1MS Access Date() Function
- 12.2MS Access DateAdd() Function
- 12.3MS Access DateDiff() Function
- 12.4MS Access DatePart() Function
- 12.5MS Access DateSerial() Function
- 12.6MS Access DateValue() Function
- 12.7MS Access Day() Function
- 12.8MS Access Format() Function
- 12.9MS Access Hour() Function
- 12.10MS Access Minute() Function
- 12.11MS Access Month() Function
- 12.12MS Access MonthName() Function
- 12.13MS Access Now() Function
- 12.14MS Access Second() Function
- 12.15MS Access Time() Function
- 12.16MS Access TimeSerial() Function
- 12.17MS Access TimeValue() Function
- 12.18MS Access Weekday() Function
- 12.19MS Access WeekdayName() Function
- 12.20MS Access Year() Function
- MS Access - Other Functions5
- SQL Quick Reference1
Instructors
