> For the complete documentation index, see [llms.txt](https://dev117uday.gitbook.io/databases/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://dev117uday.gitbook.io/databases/index.md).

# Table of contents

## SQL

* [Getting Started](/databases/sql/getting-started.md)
* [PgAdmin Tool](/databases/sql/getting-started/administration-task.md)
* [Database](/databases/sql/working-with-database.md)
  * [Schema](/databases/sql/working-with-database/schema.md)
* [Data Types](/databases/sql/data-types.md)
  * [JSON](/databases/sql/data-types/json.md)
  * [User Defined Data Types](/databases/sql/data-types/user-defined-data-types.md)
  * [Date/Time/Stamps](/databases/sql/data-types/date-time-stamps.md)
  * [Sequences](/databases/sql/data-types/sequences.md)
  * [Arrays](/databases/sql/data-types/arrays.md)
  * [Internal Functions](/databases/sql/data-types/miscellaneous-1.md)
* [Order of SQL Execution](/databases/sql/order-of-sql-execution.md)
* [Table](/databases/sql/tables.md)
  * [ORDER BY and DISTINCT](/databases/sql/tables/order-by.md)
  * [WHERE Clause](/databases/sql/tables/where.md)
  * [OPERATORS](/databases/sql/tables/miscellaneous.md)
  * [GROUP BY and HAVING](/databases/sql/tables/group-by-and-having.md)
  * [Combining Tables](/databases/sql/tables/combining-tables.md)
  * [Aggregation](/databases/sql/tables/aggregation.md)
  * [Constraints](/databases/sql/tables/constraints.md)
  * [Useful Functions](/databases/sql/tables/coalesce.md)
  * [Views](/databases/sql/tables/views.md)
  * [Common Table Expression](/databases/sql/tables/cte.md)
* [Joins](/databases/index.md)
  * [Inner Join](/databases/sql/joins/inner-join.md)
  * [Left and Right JOIN](/databases/sql/joins/left-and-right-join.md)
  * [Full, Multiple & Self Joins](/databases/sql/joins/full-multiple-and-self-joins.md)
  * [Cross & Natural Joins](/databases/sql/joins/cross-join.md)
* [Indexing](/databases/sql/indexing.md)
  * [SQL](/databases/sql/indexing/sql.md)
  * [Indexes](/databases/sql/indexing/indexes.md)
  * [Unique Index](/databases/sql/indexing/unique-index.md)
  * [GIN Index](/databases/sql/indexing/gin-index.md)
  * [Custom Indexes](/databases/sql/indexing/custom-indexes.md)
* [Summarization](/databases/sql/summarization.md)
  * [Window](/databases/sql/summarization/window.md)
  * [Sub Queries](/databases/sql/summarization/subqueries.md)
* [Advance Tables](/databases/index.md)
  * [Managing Tables](/databases/sql/advance-tables/managing-tables.md)
  * [Partitioning Tables](/databases/sql/advance-tables/paritioning-tables.md)
  * [Internals](/databases/sql/advance-tables/internals.md)
  * [Pivotal or Cross-tab Tables](/databases/sql/advance-tables/pivotal-or-crosstab-tables.md)
* [Functions](/databases/sql/functions.md)
  * [PL/pgSQL](/databases/sql/functions/pl-pgsql.md)
  * [Stored Procedures](/databases/sql/functions/stored-procedures.md)
  * [Triggers](/databases/sql/functions/triggers.md)
    * [More on Triggers](/databases/sql/functions/triggers/more-on-triggers.md)
  * [Cursors](/databases/sql/functions/cursors.md)

## MongoDB

* [MongoDB](broken://pages/-MguKkJphFJF4zaUi54F)
* [MQL](/databases/mongodb/mql.md)
* [Mongo Administration](/databases/mongodb/mongo-administration.md)
* [MongoDB Aggregation](/databases/mongodb/mongodb-aggregation.md)

## Redis

* [Redis](https://github.com/dev117uday/learning-databases/blob/main/redis.md)

## Cassandra

* [Cassandra : Scylla](broken://pages/-MguK0XQt3StQhXSzJfw)
* [Data Modelling](/databases/cassandra/data-modelling.md)
* [CQL](/databases/cassandra/cql.md)