1. DML
1.1. SELECT
1.2. WHERE
1.3. INSERT INTO
1.4. UPDATE
1.5. DELETE
1.6. MERGE
1.7. Арифметические функции
1.7.1. +
1.7.2. -
1.7.3. *
1.7.4. /
1.7.5. %
1.8. Операторы сравнения
1.8.1. =, !=, (<>), <, <=, >, >=, !>, !<
1.9. Логические операторы
1.9.1. AND, OR, NOT
1.9.2. ALL, ANY, SOME
1.9.3. IN, NOT IN, BETWEEN
1.9.4. EXISTS
1.9.5. LIKE
1.9.5.1. %
1.9.5.2. -
1.9.5.3. []
1.9.5.4. [-]
1.9.5.5. [^]
1.10. Нюансы при работе с NULL
1.10.1. IS NULL, IS NOT NULL
1.10.2. NOT NULL
1.11. ISNULL()
1.12. Агрегатные функции
1.12.1. MIN ()
1.12.2. MAX()
1.12.3. AVG()
1.12.4. SUM()
1.12.5. COUNT()
1.12.6. SQRT()
1.13. GROUP BY
1.14. HAVING
1.15. ORDER BY
1.15.1. ASC
1.15.2. DESC
1.16. DISTINCT
1.17. TOP/LIMIT
1.18. JOINS
1.18.1. INNER JOIN
1.18.2. OUTER JOIN
1.18.2.1. FULL
1.18.2.2. LEFT
1.18.2.3. RIGHT
1.18.3. CROSS JOIN
1.18.4. SELF JOIN
1.18.5. Advanced Joins
1.19. UNION, UNION ALL
1.20. INTERSECT, EXCEPT
1.21. JOINS VS UNION, INTERSECT, EXCEPT
1.22. Date and time functions
1.22.1. DATEDIFF
1.22.2. DATEPART
1.22.3. YEAR
1.22.4. NOW
1.23. VIEW
1.24. SUBQUERY
1.25. CTE
1.26. CASE (WHEN-ELSE-END)
1.27. Window functions
1.27.1. OVER, ORDER BY, PARTITION BY
1.27.2. ROW_NUMBER
1.27.3. RANK
1.27.4. DENSE_RANK
2. Database Fundamentals
2.1. SQL
2.2. База данных (Database), 3 фунд характ
2.3. Виды БД
2.3.1. Flat file
2.3.2. Hierarchical
2.3.3. RElational
2.3.4. Non-relational
2.4. СУБД, ГПИ (DBMS, GUI)
2.5. Подмножества языка SQL
2.6. Таблица, поле, запись
2.7. Запрос (query)
2.8. Особенности SQL
2.9. Виды связей, структура, 2 вида таблиц
2.9.1. One to one
2.9.2. One to many
2.9.3. Many to one
2.9.4. Many to many