AllonData Academy, Simplify the Complexity

Fundamentals

94 items

  • Basic SELECT & Filtering6 items
    • SELECT
    • WHERE
    • ORDER BY
    • DISTINCT
    • LIMIT
    • Column aliases
  • Operators18 items
    • Arithmetic Operators4 items
      • +
      • -
      • *
      • /
    • Comparison Operators6 items
      • =
      • <
      • >
      • <=
      • >=
      • <>
    • Logical Operators3 items
      • AND
      • OR
      • NOT
    • Membership Operators2 items
      • IN
      • NOT IN
    • Range Operator1 item
      • BETWEEN ... AND
    • Pattern Matching Operators2 items
      • LIKE
      • NOT LIKE
  • Data Types5 items
    • Numeric data types
    • String data types
    • Date and time data types
    • Boolean values
    • NULL
  • Single-Row Functions36 items
    • CASE / Conditional Logic2 items
      • CASE
      • IF
    • Character Functions15 items
      • UPPER()
      • LOWER()
      • INITCAP()
      • SUBSTR()
      • INSTR()
      • LPAD()
      • RPAD()
      • LTRIM()
      • RTRIM()
      • TRIM()
      • CONCAT()
      • REPLACE()
      • TRANSLATE()
      • REVERSE()
      • LENGTH()
    • Number Functions5 items
      • ROUND()
      • TRUNC()
      • MOD()
      • POWER()
      • ABS()
    • Date Functions9 items
      • CURRENT_DATE()
      • DATE_ADD()
      • DATE_SUB()
      • DATE_DIFF()
      • DATE_TRUNC()
      • EXTRACT()
      • LAST_DAY()
      • FORMAT_DATE()
      • PARSE_DATE()
    • Conversion Functions2 items
      • CAST()
      • EXTRACT()
    • General / NULL Functions3 items
      • IFNULL()
      • NULLIF()
      • COALESCE()
  • Aggregate Functions & Grouping7 items
    • Aggregate Functions5 items
      • MIN()
      • MAX()
      • COUNT()
      • AVG()
      • SUM()
    • Grouping2 items
      • GROUP BY
      • HAVING
  • Joins4 items
    • INNER JOIN
    • LEFT JOIN
    • RIGHT JOIN
    • FULL OUTER JOIN
  • Subqueries5 items
    • Subqueries in SELECT
    • Subqueries in WHERE
    • Subqueries in FROM
    • IN subqueries
    • Correlated subqueries
  • Window / Analytical Functions12 items
    • Window-Specific Functions5 items
      • ROW_NUMBER()
      • RANK()
      • DENSE_RANK()
      • LEAD()
      • LAG()
    • Aggregate Functions Used as Window Functions5 items
      • MIN()
      • MAX()
      • COUNT()
      • AVG()
      • SUM()
    • Window Clauses2 items
      • OVER
      • PARTITION BY
  • CTEs (WITH Clause)1 item
    • WITH clause
Full curriculumDownload Curriculum