Curriculum
Course:
SQL
Login
Curriculum
SQL
SQL Tutorial
0/42
SQL Intro
5 minutes
SQL Syntax
5 minutes
SQL SELECT
5 minutes
SQL SELECT DISTINCT
5 minutes
SQL WHERE
5 minutes
SQL ORDER BY
5 minutes
SQL AND
10 minutes
SQL OR
5 minutes
SQL NOT
10 minutes
SQL INSERT INTO
5 minutes
SQL NULL Values
5 minutes
SQL UPDATE
5 minutes
SQL DELETE
10 minutes
SQL Select Top
10 minutes
SQL Aggregate Functions
10 minutes
SQL MIN and MAX
10 minutes
SQL COUNT
10 minutes
SQL SUM
10 minutes
SQL AVG
10 minutes
SQL LIKE
10 minutes
SQL Wildcards
10 minutes
SQL IN
10 minutes
SQL BETWEEN
10 minutes
SQL Aliases
10 minutes
SQL Joins
10 minutes
SQL INNER JOIN
10 minutes
SQL LEFT JOIN
5 minutes
SQL RIGHT JOIN
5 minutes
SQL FULL Join
10 minutes
SQL Self Join
10 minutes
SQL UNION
10 minutes
SQL GROUP BY
10 minutes
SQL HAVING
10 minutes
SQL EXISTS
10 minutes
SQL ANY, ALL
10 minutes
SQL Select Into
5 minutes
SQL INSERT INTO SELECT
10 minutes
SQL CASE
10 minutes
SQL NULL Functions
5 minutes
SQL Stored Procedures
10 minutes
SQL Comments
10 minutes
SQL Operators
10 minutes
SQL Database
0/20
SQL CREATE DB
5 minutes
SQL DROP DB
5 minutes
SQL BACKUP DB
5 minutes
SQL CREATE TABLE
5 minutes
SQL DROP TABLE
5 minutes
SQL ALTER TABLE
10 minutes
SQL Constraints
5 minutes
SQL NOT NULL
5 minutes
SQL UNIQUE
5 minutes
SQL PRIMARY KEY
5 minutes
SQL FOREIGN KEY
5 minutes
SQL CHECK
5 minutes
SQL DEFAULT
5 minutes
SQL INDEX
5 minutes
SQL AUTO INCREMENT
5 minutes
SQL Dates
5 minutes
SQL Views
5 minutes
SQL Injection
5 minutes
SQL Hosting
5 minutes
SQL Data Types
10 minutes
SQL References
0/80
SQL Keywords
10 minutes
ADD
5 minutes
ADD CONSTRAINT
5 minutes
ALL
5 minutes
ALTER
5 minutes
ALTER COLUMN
5 minutes
ALTER TABLE
5 minutes
AND
5 minutes
ANY
5 minutes
AS
5 minutes
ASC
5 minutes
BACKUP DATABASE
5 minutes
BETWEEN
5 minutes
CASE
5 minutes
CHECK
5 minutes
COLUMN
5 minutes
CONSTRAINT
5 minutes
CREATE
5 minutes
CREATE DATABASE
5 minutes
CREATE INDEX
5 minutes
CREATE OR REPLACE VIEW
5 minutes
CREATE TABLE
5 minutes
CREATE PROCEDURE
5 minutes
CREATE UNIQUE INDEX
5 minutes
CREATE VIEW
5 minutes
DATABASE
5 minutes
DEFAULT
5 minutes
DELETE
5 minutes
DESC
5 minutes
DISTINCT
5 minutes
DROP
5 minutes
DROP COLUMN
5 minutes
DROP CONSTRAINT
5 minutes
DROP DATABASE
5 minutes
DROP DEFAULT
5 minutes
DROP INDEX
5 minutes
DROP TABLE
5 minutes
DROP VIEW
5 minutes
EXEC
5 minutes
EXISTS
5 minutes
FOREIGN KEY
5 minutes
FROM
5 minutes
FULL OUTER JOIN
5 minutes
GROUP BY
5 minutes
HAVING
5 minutes
IN
5 minutes
INDEX
5 minutes
INNER JOIN
5 minutes
INSERT INTO
5 minutes
INSERT INTO SELECT
5 minutes
IS NULL
5 minutes
IS NOT NULL
5 minutes
JOIN
5 minutes
LEFT JOIN
Text lesson
LIKE
5 minutes
LIMIT
5 minutes
NOT
5 minutes
NOT NULL
5 minutes
OR
5 minutes
ORDER BY
5 minutes
OUTER JOIN
5 minutes
PRIMARY KEY
5 minutes
PROCEDURE
5 minutes
RIGHT JOIN
5 minutes
ROWNUM
5 minutes
SELECT
5 minutes
SELECT DISTINCT
5 minutes
SELECT INTO
5 minutes
SELECT TOP
5 minutes
SET Keyword
5 minutes
TABLE
5 minutes
TOP
5 minutes
TRUNCATE TABLE
Text lesson
UNION
5 minutes
UNION ALL
5 minutes
UNIQUE
5 minutes
UPDATE
5 minutes
VALUES
5 minutes
VIEW
5 minutes
WHERE
5 minutes
MySQL Functions
0/139
MySQL String Functions
5 minutes
ASCII
5 minutes
CHAR_LENGTH
5 minutes
CHARACTER_LENGTH
5 minutes
CONCAT
5 minutes
CONCAT_WS
5 minutes
FIELD
5 minutes
FIND_IN_SET
5 minutes
FORMAT
5 minutes
INSERT
5 minutes
INSTR
5 minutes
LCASE
5 minutes
LEFT
5 minutes
LENGTH
5 minutes
LOCATE
5 minutes
LOWER
5 minutes
LPAD
5 minutes
LTRIM
5 minutes
MID
5 minutes
POSITION
5 minutes
REPEAT
5 minutes
REPLACE
5 minutes
REVERSE
5 minutes
RIGHT
5 minutes
RPAD
5 minutes
RTRIM
5 minutes
SPACE
5 minutes
STRCMP
5 minutes
SUBSTR
5 minutes
SUBSTRING
5 minutes
SUBSTRING_INDEX
5 minutes
TRIM
5 minutes
UCASE
5 minutes
UPPER
5 minutes
ABS
5 minutes
ACOS
5 minutes
ASIN
5 minutes
ATAN
5 minutes
ATAN2
5 minutes
AVG
5 minutes
CEIL
5 minutes
CEILING
5 minutes
COS
5 minutes
COT
5 minutes
COUNT
5 minutes
DEGREES
5 minutes
DIV
5 minutes
EXP
5 minutes
FLOOR
5 minutes
GREATEST
5 minutes
LEAST
5 minutes
LN
5 minutes
LOG
5 minutes
LOG10
5 minutes
LOG2
5 minutes
MAX
5 minutes
MIN
5 minutes
MOD
5 minutes
PI
5 minutes
POW
5 minutes
POWER
10 minutes
RADIANS
10 minutes
RAND
10 minutes
ROUND
10 minutes
SIGN
10 minutes
SIN
10 minutes
SQRT
10 minutes
SUM
10 minutes
TAN
10 minutes
TRUNCATE
10 minutes
ADDDATE
10 minutes
ADDTIME
10 minutes
CURDATE
10 minutes
CURRENT_DATE
10 minutes
CURRENT_TIME
10 minutes
CURRENT_TIMESTAMP
10 minutes
CURTIME
10 minutes
DATE
10 minutes
DATEDIFF
10 minutes
DATE_ADD
10 minutes
DATE_FORMAT
10 minutes
DATE_SUB
10 minutes
DAY
10 minutes
DAYNAME
10 minutes
DAYOFMONTH
10 minutes
DAYOFWEEK
10 minutes
DAYOFYEAR
10 minutes
EXTRACT
10 minutes
FROM_DAYS
10 minutes
HOUR
10 minutes
LAST_DAY
10 minutes
LOCALTIME
10 minutes
LOCALTIMESTAMP
10 minutes
MAKEDATE
10 minutes
MAKETIME
10 minutes
MICROSECOND
10 minutes
MINUTE
10 minutes
MONTH
10 minutes
MONTHNAME
10 minutes
NOW
10 minutes
PERIOD_ADD
10 minutes
PERIOD_DIFF
10 minutes
QUARTER
10 minutes
SECOND
10 minutes
SEC_TO_TIME
10 minutes
STR_TO_DATE
10 minutes
SUBDATE
10 minutes
SUBTIME
10 minutes
SYSDATE
Text lesson
TIME
10 minutes
TIME_FORMAT
10 minutes
TIME_TO_SEC
10 minutes
TIMEDIFF
10 minutes
TIMESTAMP
10 minutes
TO_DAYS
10 minutes
WEEK
10 minutes
WEEKDAY
10 minutes
WEEKOFYEAR
10 minutes
YEAR
10 minutes
YEARWEEK
10 minutes
BIN
10 minutes
BINARY
10 minutes
CASE
10 minutes
CAST
10 minutes
COALESCE
10 minutes
CONNECTION_ID
10 minutes
CONV
10 minutes
CONVERT
10 minutes
CURRENT_USER
10 minutes
DATABASE
10 minutes
IF
10 minutes
IFNULL
10 minutes
ISNULL
10 minutes
LAST_INSERT_ID
10 minutes
NULLIF
10 minutes
SESSION_USER
10 minutes
SYSTEM_USER
10 minutes
USER
10 minutes
VERSION
10 minutes
SQL Server Functions
0/84
SQL Server Functions
10 minutes
ASCII
10 minutes
CHAR
10 minutes
CHARINDEX
10 minutes
CONCAT
10 minutes
Concat With +
10 minutes
CONCAT_WS
10 minutes
DATALENGTH
10 minutes
DIFFERENCE
10 minutes
FORMAT
10 minutes
LEFT
10 minutes
LEN
10 minutes
LOWER
10 minutes
LTRIM
10 minutes
NCHAR
10 minutes
PATINDEX
10 minutes
QUOTENAME
10 minutes
REPLACE
10 minutes
REPLICATE
10 minutes
REVERSE
10 minutes
RIGHT
10 minutes
RTRIM
10 minutes
SOUNDEX
10 minutes
SPACE
10 minutes
STR
10 minutes
STUFF
10 minutes
SUBSTRING
10 minutes
TRANSLATE
10 minutes
TRIM
10 minutes
UNICODE
10 minutes
UPPER
10 minutes
ABS
10 minutes
ACOS
10 minutes
ASIN
10 minutes
ATAN
10 minutes
ATN2
10 minutes
AVG
10 minutes
CEILING
10 minutes
COUNT
10 minutes
COS
10 minutes
COT
10 minutes
DEGREES
10 minutes
EXP
10 minutes
FLOOR
10 minutes
LOG
10 minutes
LOG10
10 minutes
MAX
10 minutes
MIN
10 minutes
PI
10 minutes
POWER
10 minutes
RADIANS
10 minutes
RAND
10 minutes
ROUND
10 minutes
SIGN
10 minutes
SIN
10 minutes
SQRT
10 minutes
SQUARE
10 minutes
SUM
10 minutes
TAN
10 minutes
CURRENT_TIMESTAMP
10 minutes
DATEADD
10 minutes
DATEDIFF
10 minutes
DATEFROMPARTS
10 minutes
DATENAME
10 minutes
DATEPART
10 minutes
DAY
10 minutes
GETDATE
10 minutes
GETUTCDATE
10 minutes
ISDATE
10 minutes
MONTH
10 minutes
SYSDATETIME
10 minutes
YEAR
10 minutes
CAST
10 minutes
COALESCE
10 minutes
CONVERT
10minutes
CURRENT_USER
10 minutes
IIF
10 minutes
ISNULL
10 minute
ISNUMERIC
10 minutes
NULLIF
10 minutes
SESSION_USER
10 minutes
SESSIONPROPERTY
10 minutes
SYSTEM_USER
10 minutes
USER_NAME
10 minutes
MS Access Functions
0/67
MS Access Functions
10 minutes
Asc
10 minutes
Chr
10 minutes
Concat With &
10 minutes
CurDir
10 minutes
Format
10 minutes
InStr
10 minutes
InstrRev
10 minutes
LCase
10 minutes
Left
10 minutes
Len
10 minutes
LTrim
10 minutes
Mid
10 minutes
Replace
10 minutes
Right
10 minutes
RTrim
10 minutes
Space
10 minutes
Split
10 minutes
Str
10 minutes
StrComp
10 minutes
StrConv
10 minutes
StrReverse
10 minutes
Trim
10 minutes
UCase
10 minutes
Abs
10 minutes
Atn
10 minutes
Avg
10 minutes
Cos
10 minutes
Count
10 minutes
Exp
10 minutes
Fix
10 minutes
Format
10 minutes
Int
10 minutes
Max
10 minutes
Min
10 minutes
Randomize
10 minutes
Rnd
10 minutes
Round
10 minutes
Sgn
10 minutes
Sqr
10 minutes
Sum
10 minutes
Val
10 minutes
Date
10 minutes
DateAdd
10 minutes
DateDiff
10 minutes
DatePart
10 minutes
DateSerial
10 minutes
DateValue
10 minutes
Day
10 minutes
Format
10 minutes
Hour
10 minutes
Minute
10 minutes
Month
10 minutes
MonthName
10 minutes
Now
10 minutes
Second
10 minutes
Time
10 minutes
TimeSerial
10 minutes
TimeValue
10 minutes
Weekday
10 minutes
WeekdayName
10 minutes
Year
10 minutes
CurrentUser
10 minutes
Environ
10 minutes
IsDate
10 minutes
IsNull
10 minutes
IsNumeric
10 minutes
SQL Quick Ref
0/1
SQL Quick Ref
10 minutes
Text lesson
LAST_INSERT_ID
LAST_INSERT_ID() is a function in SQL that returns the ID generated for the last AUTO_INCREMENT column in the current session.
Previous
Next
