SQL Tutorials

Welcome to SQL Tutorials by ProgramGuru.org. We shall cover SQL Databases, SQL Tables, operations on Table rows and columns, etc., with examples.

SQL Tutorials

  1. Introduction to SQL
  2. SQL Syntax
  3. SQL Comments

SQL Database

  1. What is a Database?
  2. SQL CREATE DATABASE
  3. SQL DROP DATABASE
  4. SQL RENAME DATABASE
  5. SQL SELECT or USE DATABASE
  6. SQL BACKUP DATABASE

SQL Table

  1. What is a Table in SQL?
  2. SQL CREATE TABLE
  3. SQL DROP TABLE
  4. SQL DELETE FROM TABLE
  5. SQL RENAME TABLE
  6. SQL TRUNCATE TABLE
  7. SQL ALTER TABLE
  8. SQL COPY TABLE
  9. SQL Temporary Table
  10. SQL CREATE INDEX

Row Operations

  1. SQL INSERT Statement
  2. SQL SELECT Rows(s) From Table
  3. SQL UPDATE Row(s) in TABLE
  4. SQL DELETE Row(s) from TABLE
  5. SQL GROUP BY
  6. SQL ORDER BY

Select Row(s)

  1. SQL SELECT DISTINCT
  2. SQL SELECT COUNT
  3. SQL SELECT TOP
  4. SQL SELECT FIRST Row
  5. SQL SELECT LAST
  6. SQL SELECT RANDOM
  7. SQL SELECT IN

SQL Clauses

  1. SQL WHERE Clause
  2. SQL WITH Clause
  3. SQL AS Clause
  4. SQL HAVING Clause
  5. SQL Composite Key

SQL Operators

  1. SQL AND Operator
  2. SQL OR Operator
  3. SQL NOT Operator
  4. SQL ALL Operator
  5. SQL ANY Operator
  6. SQL BETWEEN Operator
  7. SQL EXISTS Operator
  8. SQL IN Operator
  9. SQL LIKE Operator

SQL Order By

  1. SQL ORDER BY Clause
  2. SQL ORDER BY ASC
  3. SQL ORDER BY DESC
  4. SQL ORDER BY RANDOM

SQL Constraints

  1. SQL Constraints
  2. SQL PRIMARY KEY
  3. SQL FOREIGN KEY
  4. SQL UNIQUE Key
  5. SQL CHECK Constraint
  6. SQL DEFAULT Constraint
  7. SQL AUTO_INCREMENT
  8. SQL NOT NULL Constraint

SQL Joins

  1. SQL JOIN
  2. SQL OUTER JOIN
  3. SQL INNER JOIN
  4. SQL LEFT JOIN
  5. SQL RIGHT JOIN
  6. SQL FULL JOIN
  7. SQL CROSS JOIN
  8. SQL SELF JOIN

SQL Functions

SQL Aggregate Functions

  1. SQL Functions
  2. SQL MIN Function
  3. SQL MAX Function
  4. SQL COUNT Function
  5. SQL SUM Function
  6. SQL AVG Function

SQL Server Functions

String Functions

  1. SQL Server String ASCII() Function
  2. SQL Server String CHAR() Function
  3. SQL Server String CHARINDEX() Function
  4. SQL Server String CONCAT() Function
  5. SQL Server String CONCAT_WS() Function
  6. SQL Server String DATALENGTH() Function
  7. SQL Server String DIFFERENCE() Function
  8. SQL Server String FORMAT() Function
  9. SQL Server String LEFT() Function
  10. SQL Server String LEN() Function
  11. SQL Server String LOWER() Function
  12. SQL Server String LTRIM() Function
  13. SQL Server String NCHAR() Function
  14. SQL Server String PATINDEX() Function
  15. SQL Server String QUOTENAME() Function
  16. SQL Server String REPLACE() Function
  17. SQL Server String REPLICATE() Function
  18. SQL Server String REVERSE() Function
  19. SQL Server String RIGHT() Function
  20. SQL Server String RTRIM() Function
  21. SQL Server String SOUNDEX() Function
  22. SQL Server String SPACE() Function
  23. SQL Server String STR() Function
  24. SQL Server String STUFF() Function
  25. SQL Server String SUBSTRING() Function
  26. SQL Server String TRANSLATE() Function
  27. SQL Server String TRIM() Function
  28. SQL Server String UNICODE() Function
  29. SQL Server String UPPER() Function

Math/Numeric Functions

  1. SQL Server ABS() Function
  2. SQL Server ACOS() Function
  3. SQL Server ASIN() Function
  4. SQL Server ATAN() Function
  5. SQL Server ATN2()
  6. SQL Server AVG()
  7. SQL Server CEILING()
  8. SQL Server COUNT()
  9. SQL Server COS()
  10. SQL Server COT()
  11. SQL Server DEGREES()
  12. SQL Server EXP()
  13. SQL Server FLOOR()
  14. SQL Server FLOOR()
  15. SQL Server LOG10()
  16. SQL Server MAX()
  17. SQL Server MIN()
  18. SQL Server PI()
  19. SQL Server POWER()
  20. SQL Server RADIANS()
  21. SQL Server RAND()
  22. SQL Server ROUND()
  23. SQL Server SIGN()
  24. SQL Server SIN()
  25. SQL Server SQRT()
  26. SQL Server SQUARE()
  27. SQL Server SUM()
  28. SQL Server TAN()

Date Functions

  1. SQL Server CURRENT_TIMESTAMP()
  2. SQL Server DATEADD()
  3. SQL Server DATEDIFF()
  4. SQL Server DATEFROMPARTS()
  5. SQL Server DATENAME()
  6. SQL Server DATEPART()
  7. SQL Server DAY()
  8. SQL Server GETDATE()
  9. SQL Server ISDATE()
  10. SQL Server MONTH()
  11. SQL Server SYSDATETIME()
  12. SQL Server YEAR()

Advanced Functions

  1. SQL Server CAST() Function
  2. SQL Server COALESCE() Function
  3. SQL Server CONVERT() Function
  4. SQL Server CURRENT_USER() Function
  5. SQL Server IIF() Function
  6. SQL Server ISNULL() Function
  7. SQL Server ISNUMERIC() Function
  8. SQL Server NULLIF() Function
  9. SQL Server SESSION_USER() Function
  10. SQL Server SESSIONPROPERTY() Function
  11. SQL Server SYSTEM_USER() Function
  12. SQL Server USER_NAME() Function