Knowledge base – SQL

sql knowledge base

With this SQL knowledge base I am aiming to give you the best most concise pill of SQL tech skills you need to master.

SQL – The Language of Databases

SQL (Structured Query Language) is the foundation for analyzing large datasets stored in databases. Here, you will learn the basics of JOINs, data grouping, filtering, nested queries, and window functions, which are essential for effective data processing and analysis. You will also find query examples that you can apply in practice.

SQL (Structured Query Language) is the foundation for analyzing large datasets stored in databases. Here, you will learn the basics of JOINs, data grouping, filtering, nested queries, and window functions, which are essential for effective data processing and analysis. You will also find query examples that you can apply in practice.

SQL – Basic operations

  • SELECT DISTINCT
  • WHERE
  • GROUP BY
  • ORDER BY
  • HAVING
  • LIMIT
  • OFFSET

    • SQL – Aggregations

  • COUNT
  • SUM
  • AVG
  • MIN
  • MAX
  • STRING_AGG
  • GROUP_CONCAT

    • SQL – JOIN or UNION

  • JOIN
  • INNER JOIN
  • LEFT JOIN
  • RIGHT JOIN
  • FULL JOIN
  • CROSS JOIN
  • SELF JOIN
  • UNION
  • UNION ALL
  • INTERSECT
  • EXCEPT

    • SQL – Logical or NULL operations

  • CASE WHEN
  • COALESCE
  • NULLIF
  • IS NULL
  • IS NOT NULL

    • SQL – Math or number operations

  • ROUND
  • CEIL
  • FLOOR
  • ABS
  • MOD
  • POWER
  • SQRT
  • LOG
  • EXP
  • RANDOM

    • SQL – Logical or NULL operations

  • CHAR_LENGTH
  • LENGTH
  • LOWER
  • UPPER
  • TRIM
  • LTRIM
  • RTRIM
  • SUBSTRING
  • REPLACE
  • POSITION
  • CONCAT
  • LEFT
  • RIGHT
  • LPAD
  • RPAD
  • INITCAP
  • STRING_SPLIT
  • REGEXP
  • CASE_INSENSITIVE_COMPARE

    • SQL – Time or date operations

  • NOW
  • CURRENT_DATE
  • CURRENT_TIME
  • CURRENT_TIMESTAMP
  • DATE_TRUNC
  • DATEADD
  • DATEDIFF
  • EXTRACT
  • YEAR
  • MONTH
  • DAY
  • HOUR
  • MINUTE
  • SECOND

    • SQL – Window functions

  • RANK
  • DENSE_RANK
  • ROW_NUMBER
  • NTILE
  • LEAD
  • LAG
  • FIRST_VALUE
  • LAST_VALUE
  • WINDOW FUNCTIONS

    • SQL – Other operations / key words

  • CAST
  • CONVERT
  • LIKE
  • ILIKE
  • PATINDEX
  • JSON_EXTRACT
  • JSON_VALUE
  • ARRAY_AGG
  • UNNEST
  • PIVOT
  • PARTITION BY
  • CTE (WITH)
  • RECURSIVE CTE
  • STORED PROCEDURE
  • TRIGGER
  • INDEX
  • FOREIGN KEY

    • Check other stuff 👇

    Get back to the main knowledge base page here.