# Databases

## Databases

- [Table of contents](https://dev117uday.gitbook.io/databases/index.md)
- [SQL](https://dev117uday.gitbook.io/databases/sql.md)
- [Getting Started](https://dev117uday.gitbook.io/databases/sql/getting-started.md)
- [PgAdmin Tool](https://dev117uday.gitbook.io/databases/sql/getting-started/administration-task.md)
- [Data Types](https://dev117uday.gitbook.io/databases/sql/data-types.md)
- [Arrays](https://dev117uday.gitbook.io/databases/sql/data-types/arrays.md)
- [Date/Time/Stamps](https://dev117uday.gitbook.io/databases/sql/data-types/date-time-stamps.md)
- [JSON](https://dev117uday.gitbook.io/databases/sql/data-types/json.md): the usual
- [Internal Functions](https://dev117uday.gitbook.io/databases/sql/data-types/miscellaneous-1.md): one day, you will need them
- [Sequences](https://dev117uday.gitbook.io/databases/sql/data-types/sequences.md)
- [User Defined Data Types](https://dev117uday.gitbook.io/databases/sql/data-types/user-defined-data-types.md): yours truely
- [Database](https://dev117uday.gitbook.io/databases/sql/working-with-database.md)
- [Schema](https://dev117uday.gitbook.io/databases/sql/working-with-database/schema.md)
- [Table](https://dev117uday.gitbook.io/databases/sql/tables.md)
- [Aggregation](https://dev117uday.gitbook.io/databases/sql/tables/aggregation.md)
- [Usefull Functions](https://dev117uday.gitbook.io/databases/sql/tables/coalesce.md)
- [Combining Tables](https://dev117uday.gitbook.io/databases/sql/tables/combining-tables.md)
- [Constraints](https://dev117uday.gitbook.io/databases/sql/tables/constraints.md)
- [Common Table Expression](https://dev117uday.gitbook.io/databases/sql/tables/cte.md)
- [GROUP BY and HAVING](https://dev117uday.gitbook.io/databases/sql/tables/group-by-and-having.md)
- [OPERATORS](https://dev117uday.gitbook.io/databases/sql/tables/miscellaneous.md): bodmas 3000
- [ORDER BY and DISTINCT](https://dev117uday.gitbook.io/databases/sql/tables/order-by.md): a clause
- [Views](https://dev117uday.gitbook.io/databases/sql/tables/views.md)
- [WHERE Clause](https://dev117uday.gitbook.io/databases/sql/tables/where.md): ??
- [Order of SQL Execution](https://dev117uday.gitbook.io/databases/sql/order-of-sql-execution.md)
- [Advance Table](https://dev117uday.gitbook.io/databases/sql/advance-tables.md)
- [Internals](https://dev117uday.gitbook.io/databases/sql/advance-tables/internals.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)
- [Pivotal or Crosstab Tables](https://dev117uday.gitbook.io/databases/sql/advance-tables/pivotal-or-crosstab-tables.md)
- [Joins](https://dev117uday.gitbook.io/databases/sql/joins.md)
- [Cross & Natural Joins](https://dev117uday.gitbook.io/databases/sql/joins/cross-join.md)
- [Full, Multiple & Self Joins](https://dev117uday.gitbook.io/databases/sql/joins/full-multiple-and-self-joins.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)
- [Functions](https://dev117uday.gitbook.io/databases/sql/functions.md)
- [Cursors](https://dev117uday.gitbook.io/databases/sql/functions/cursors.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)
- [Indexing](https://dev117uday.gitbook.io/databases/sql/indexing.md)
- [Custom Indexes](https://dev117uday.gitbook.io/databases/sql/indexing/custom-indexes.md)
- [GIN Index](https://dev117uday.gitbook.io/databases/sql/indexing/gin-index.md)
- [Indexes](https://dev117uday.gitbook.io/databases/sql/indexing/indexes.md)
- [SQL](https://dev117uday.gitbook.io/databases/sql/indexing/sql.md)
- [Unique Index](https://dev117uday.gitbook.io/databases/sql/indexing/unique-index.md)
- [Summarization](https://dev117uday.gitbook.io/databases/sql/summarization.md)
- [SubQueries](https://dev117uday.gitbook.io/databases/sql/summarization/subqueries.md)
- [Window](https://dev117uday.gitbook.io/databases/sql/summarization/window.md)
- [MongoDB](https://dev117uday.gitbook.io/databases/mongodb.md)
- [Mongo Administration](https://dev117uday.gitbook.io/databases/mongodb/mongo-administration.md)
- [MongoDB Aggregation](https://dev117uday.gitbook.io/databases/mongodb/mongodb-aggregation.md)
- [MQL](https://dev117uday.gitbook.io/databases/mongodb/mql.md)
- [Redis](https://dev117uday.gitbook.io/databases/redis.md)
- [Cassandra](https://dev117uday.gitbook.io/databases/cassandra.md): SycllaDB to be precise
- [CQL](https://dev117uday.gitbook.io/databases/cassandra/cql.md)
- [Data Modelling](https://dev117uday.gitbook.io/databases/cassandra/data-modelling.md)
- [Advance Data Modelling](https://dev117uday.gitbook.io/databases/cassandra/data-modelling/advance-data-modelling.md)
- [Cassandra Administration](https://dev117uday.gitbook.io/databases/cassandra/cassandra-administration.md)
- [Cassandra Features](https://dev117uday.gitbook.io/databases/cassandra/cassandra-features.md)