# Table of contents

## SQL

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

## MongoDB

* [MongoDB](https://dev117uday.gitbook.io/databases/broken-reference)
* [MQL](https://dev117uday.gitbook.io/databases/mongodb/mql)
* [Mongo Administration](https://dev117uday.gitbook.io/databases/mongodb/mongo-administration)
* [MongoDB Aggregation](https://dev117uday.gitbook.io/databases/mongodb/mongodb-aggregation)

## Redis

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

## Cassandra

* [Cassandra : Scylla](https://dev117uday.gitbook.io/databases/broken-reference)
* [Data Modelling](https://dev117uday.gitbook.io/databases/cassandra/data-modelling)
* [CQL](https://dev117uday.gitbook.io/databases/cassandra/cql)