# SQL

- [DQL vs DDL vs DML vs DCL vs TCL](/my-de-learning-logs/sql/dql-vs-ddl-vs-dml-vs-dcl-vs-tcl.md): Categories of commands within Structured Query Language (SQL) used for managing and interacting with relational databases
- [SQL concepts](/my-de-learning-logs/sql/sql-concepts.md)
- [SQL command lifecycle](/my-de-learning-logs/sql/sql-concepts/sql-command-lifecycle.md)
- [Order of Execution](/my-de-learning-logs/sql/sql-concepts/order-of-execution.md)
- [Abstract Syntax Tree](/my-de-learning-logs/sql/sql-concepts/abstract-syntax-tree.md)
- [CREATE TABLE](/my-de-learning-logs/sql/sql-concepts/create-table.md)
- [DESCRIBE](/my-de-learning-logs/sql/sql-concepts/describe.md)
- [DROP](/my-de-learning-logs/sql/sql-concepts/drop.md)
- [DISTINCT](/my-de-learning-logs/sql/sql-concepts/distinct.md)
- [ALTER TABLE](/my-de-learning-logs/sql/sql-concepts/alter-table.md)
- [UPDATE and DELETE](/my-de-learning-logs/sql/sql-concepts/update-and-delete.md)
- [MERGE](/my-de-learning-logs/sql/sql-concepts/merge.md)
- [FILTER](/my-de-learning-logs/sql/sql-concepts/filter.md)
- [Data types](/my-de-learning-logs/sql/sql-concepts/data-types.md)
- [Nested data types](/my-de-learning-logs/sql/sql-concepts/data-types/nested-data-types.md)
- [CAST](/my-de-learning-logs/sql/sql-concepts/cast.md)
- [Filtering: WHERE clause](/my-de-learning-logs/sql/sql-concepts/filtering-where-clause.md)
- [Grouping, Aggregate functions, Ordering](/my-de-learning-logs/sql/sql-concepts/grouping-aggregate-functions-ordering.md)
- [Working with identifiers](/my-de-learning-logs/sql/sql-concepts/working-with-identifiers.md)
- [Creating primary, secondary keys](/my-de-learning-logs/sql/sql-concepts/working-with-identifiers/creating-primary-secondary-keys.md)
- [Creating constraints](/my-de-learning-logs/sql/sql-concepts/working-with-identifiers/creating-constraints.md)
- [Creating hashes](/my-de-learning-logs/sql/sql-concepts/working-with-identifiers/creating-hashes.md)
- [Auto increments](/my-de-learning-logs/sql/sql-concepts/working-with-identifiers/auto-increments.md)
- [Working with dates and timestamps](/my-de-learning-logs/sql/sql-concepts/working-with-dates-and-timestamps.md)
- [String Manipulation](/my-de-learning-logs/sql/sql-concepts/string-manipulation.md)
- [Logical joins](/my-de-learning-logs/sql/sql-concepts/logical-joins.md): Types of Joins
- [Row Explosion](/my-de-learning-logs/sql/sql-concepts/logical-joins/row-explosion.md)
- [Physical joins](/my-de-learning-logs/sql/sql-concepts/physical-joins.md)
- [GROUP BY and Aggregations](/my-de-learning-logs/sql/sql-concepts/group-by-and-aggregations.md)
- [HAVING](/my-de-learning-logs/sql/sql-concepts/having.md)
- [Subqueries](/my-de-learning-logs/sql/sql-concepts/subqueries.md)
- [CTEs - Common Table Expressions](/my-de-learning-logs/sql/sql-concepts/ctes-common-table-expressions.md)
- [Views, Materialized Views, and Temporary Tables](/my-de-learning-logs/sql/sql-concepts/views-materialized-views-and-temporary-tables.md)
- [Window functions](/my-de-learning-logs/sql/sql-concepts/window-functions.md)
- [COALESCE and NULLIF](/my-de-learning-logs/sql/sql-concepts/coalesce-and-nullif.md)
- [CASE WHEN END](/my-de-learning-logs/sql/sql-concepts/case-when-end.md)
- [Query Optimizations](/my-de-learning-logs/sql/sql-concepts/query-optimizations.md)
- [EXPLAIN and EXPLAIN ANALYZE](/my-de-learning-logs/sql/sql-concepts/explain-and-explain-analyze.md)
- [UNION and UNION ALL](/my-de-learning-logs/sql/sql-concepts/union-and-union-all.md)
- [EXCEPT and INTERSECT](/my-de-learning-logs/sql/sql-concepts/except-and-intersect.md)
- [COPY](/my-de-learning-logs/sql/sql-concepts/copy.md)
- [TO\_CHAR](/my-de-learning-logs/sql/sql-concepts/to_char.md)
- [Math in SQL](/my-de-learning-logs/sql/sql-concepts/math-in-sql.md)
- [GRANT, REVOKE](/my-de-learning-logs/sql/sql-concepts/grant-revoke.md)
- [Transactions](/my-de-learning-logs/sql/sql-concepts/transactions.md)
- [Indexing](/my-de-learning-logs/sql/sql-concepts/indexing.md)
- [Inverted Index](/my-de-learning-logs/sql/sql-concepts/indexing/inverted-index.md)
- [Table scans](/my-de-learning-logs/sql/sql-concepts/indexing/table-scans.md)
- [Partitioning](/my-de-learning-logs/sql/sql-concepts/partitioning.md)
- [Partitioning + Clustering](/my-de-learning-logs/sql/sql-concepts/partitioning/partitioning-+-clustering.md)
- [Triggers](/my-de-learning-logs/sql/sql-concepts/triggers.md)
- [Stored Procedures](/my-de-learning-logs/sql/sql-concepts/stored-procedures.md)
- [Anti-patterns](/my-de-learning-logs/sql/sql-concepts/anti-patterns.md)
- [Working with JSON data](/my-de-learning-logs/sql/working-with-json-data.md)
- [Working with geospatial data](/my-de-learning-logs/sql/working-with-geospatial-data.md)
- [SQL flavors (dialects)](/my-de-learning-logs/sql/sql-flavors-dialects.md)