1Keydata SQL Tutorial Sitemap

SQL Tutorial

SQL Commands

• SQL SELECT
• SQL DISTINCT
• SQL WHERE
• SQL AND OR
• SQL IN
• SQL BETWEEN
• SQL Wildcard
• SQL LIKE
• SQL ILIKE
• SQL ORDER BY
• SQL GROUP BY
• SQL HAVING
• SQL ALIAS
• SQL AS
• SQL SELECT UNIQUE
• SQL JOIN
• SQL INNER JOIN
• SQL OUTER JOIN
• SQL LEFT OUTER JOIN
• SQL CROSS JOIN
• SQL INSERT INTO
• SQL INSERT INTO SELECT
• SQL UPDATE
• SQL DELETE FROM
• Comment

Advanced SQL

• SQL UNION
• SQL UNION ALL
• SQL Inline View
• SQL INTERSECT
• SQL MINUS
• SQL LIMIT
• SQL TOP
• SQL Subquery
• SQL WITH
• SQL EXISTS
• SQL CASE
• SQL PIVOT
• SQL WINDOW FUNCTIONS
• SQL DECODE
• SQL COMMIT
• SQL AUTO INCREMENT
• SQL IDENTITY
• SQL SEQUENCE and NEXTVAL
• Rank
• Median
• Running Totals
• Percent To Total
• Cumulative Percent To Total

SQL Functions

• SQL Average
• SQL COUNT
• SQL MAX
• SQL MIN
• SQL SUM
• SQL ROUND

String Functions

• SQL CAST
• SQL CONVERT
• SQL CONCATENATE
• SQL SUBSTRING
• SQL INSTR
• SQL TRIM
• SQL LENGTH
• SQL REPLACE
• SQL TO_DATE

Date Functions

• SQL DATEADD
• SQL DATEDIFF
• SQL DATEPART
• SQL GETDATE
• SQL SYSDATE
• SQL EXTRACT

Data Definition Language (DDL)

• SQL CREATE TABLE
• SQL Data Types
• SQL View
• SQL CREATE VIEW
• SQL Index
• SQL CREATE INDEX
• SQL DROP TABLE
• SQL TRUNCATE TABLE
• SQL USE
• SQL CREATE DATABASE
• SQL DROP DATABASE
• SQL GRANT
• SQL REVOKE

SQL CONSTRAINT

• SQL NOT NULL
• SQL DEFAULT
• SQL UNIQUE
• SQL CHECK
• PRIMARY KEY
• FOREIGN KEY

SQL ALTER TABLE

• Add Column
• Change Column
• Modify Column
• Rename Column
• Drop Column
• Add Index
• Drop Index
• Add Constraint
• Drop Constraint

SQL NULL

• SQL ISNULL Function
• SQL IFNULL Function
• SQL NVL Function
• SQL Coalesce Function
• SQL NULLIF Function

SQL Tutorial Videos

• SQL Basics Tutorial Video
• Union, Intersect, Minus Video
• Table Management Video
• Table Constraint Video
• Database View Video

SQL Syntax

SQL Quiz

Resources