- Home
- All Courses
- IT & Software
- Server Side
- Learn SQL (Structured Query Language)
Learn SQL (Structured Query Language)
Quality education for everyone, everywhere at Your pace online
- 0 (Registered)
-
(0 Reviews)
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
MS Access IsNumeric() Function
Prev