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

## MongoDB

* [MongoDB](broken://pages/-MguKkJphFJF4zaUi54F)
* [MQL](https://dev117uday.gitbook.io/databases/mongodb/mql.md)
* [Mongo Administration](https://dev117uday.gitbook.io/databases/mongodb/mongo-administration.md)
* [MongoDB Aggregation](https://dev117uday.gitbook.io/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](https://dev117uday.gitbook.io/databases/cassandra/data-modelling.md)
* [CQL](https://dev117uday.gitbook.io/databases/cassandra/cql.md)
