Table of contents

SQL

• Getting Started

• PgAdmin Tool

• Database

  • Schema

• Data Types

  • JSON

  • User Defined Data Types

  • Date/Time/Stamps

  • Sequences

  • Arrays

  • Internal Functions

• Order of SQL Execution

• Table

  • ORDER BY and DISTINCT

  • WHERE Clause

  • OPERATORS

  • GROUP BY and HAVING

  • Combining Tables

  • Aggregation

  • Constraints

  • Useful Functions

  • Views

  • Common Table Expression

• Joins

  • Inner Join

  • Left and Right JOIN

  • Full, Multiple & Self Joins

  • Cross & Natural Joins

• Indexing

  • SQL

  • Indexes

  • Unique Index

  • GIN Index

  • Custom Indexes

• Summarization

  • Window

  • Sub Queries

• Advance Tables

  • Managing Tables

  • Partitioning Tables

  • Internals

  • Pivotal or Cross-tab Tables

• Functions

  • PL/pgSQL

  • Stored Procedures

  • Triggers

    • More on Triggers

  • Cursors

MongoDB

• MongoDB

• MQL

• Mongo Administration

• MongoDB Aggregation

Redis

• Redis

Cassandra

• Cassandra : Scylla

• Data Modelling

• CQL