Skip to content
My Notebook
Joins
Initializing search
My Notebook
Welcome to My Notebook
Databases
Databases
Graph DB : Neo4j
Redis
Cassandra
Cassandra
Cassandra
Cassandra Administration
Cassandra Features
CQL
Data modelling
Data modelling
Data Modelling
Advance Data Modelling
Mongodb
Mongodb
MongoDB
Mongo Administration
MongoDB Aggregation
MQL
Sql
Sql
Order of SQL Execution
1 Getting Started
1 Getting Started
Getting Started
PgAdmin Tool
10 Summarization
10 Summarization
Summarization
SubQueries
Window
2 Data Types
2 Data Types
Data Types
Arrays
Date/Time/Stamps
JSON
Internal Functions
Sequences
User Defined Data Types
3 Databases
3 Databases
Database
Schema
4 Tables
4 Tables
Table
Aggregation
Usefull Functions
Combining Tables
Constraints
Common Table Expression
GROUP BY and HAVING
OPERATORS
ORDER BY and DISTINCT
Views
WHERE Clause
6 Advance tables
6 Advance tables
Advance Tables
Managing Tables
Partitioning Tables
Pivotal or Crosstab Tables
7 Joins
7 Joins
Joins
Cross & Natural Joins
Full, Multiple & Self Joins
Inner Join
Left and Right JOIN
8 Functions
8 Functions
Functions
Cursors
PL/pgSQL
Stored Procedures
Triggers
Triggers
Triggers
More on Triggers
9 Indexing
9 Indexing
Indexing
Custom Indexes
GIN Index
Indexes
SQL
Unique Index
Codeblog
Codeblog
Index
Db
Db
Redis 101
Docs
Docs
Go Golang Go!
Julia: A fresh approach to technical computing
Rust: New Systems Programming Language
My experience of learning 3 programming languages in 3 weeks.
Go
Go
Golang 101 : Looking at when Garbage Collector runs
Go 101 : Testing simple Go server
Things Golang do differently
Info bank
Info bank
Indexdb
SWE 101 : Programming Terms Explained in simplest form
Proxy vs Reverse Proxy
URI | URL | URN
How to Deploy React/Vue/Angular on a VM
Java
Java
Java Threads
Js
Js
React Hooks for beginners
React.js From Scratch
Tutorials
Tutorials
Getting Started With TypeScript based Express Server
Data structure and algorithms
Data structure and algorithms
Data Structures and Algo
Arrays
Binary Search Tree
Bit Manipulation
Dynamic Programming
Graph
Greedy & Backtracking
Heap
Introduction
LinkedList
Mathematics
Matrix
Miscellaneous
Queue
Recursion
Sorting
Stack
Strings
Tree
Notes md
Notes md
Python
Python
Introduction to Python
Web
Web
React
React Hooks
Svelte Notes
Blockchain
Blockchain
Blockchain
Contract
Custom ERC20 token
Solidity
Cloud
Cloud
Google cloud platform
Google cloud platform
Cloud Networking
GCP Core Infrastructure
Golang
Golang
Golang
Competitive Programming in Go
Go Things
Golang Garbage Collector 101
Learning Go - 1
Testing simple web server
Things Golang do differently
Which is faster : Maps, slices
Java
Java
Articles to refer to
Data & Data Types
IO in Java
Miscellaneous
Java Roadmap
Threads in Java
Data structures
Data structures
Data Structures
Array in Java
Collections in Java
Enums in Java
Linked List in Java
List in Java
Map in Java
Queues & Stacks
Set in Java
TreeSet and TreeMap
Keywords in java
Keywords in java
Keywords in Java
Annotations
Comparators
Packages in Java
Name it something
Name it something
Useful Stuff Java
Lambda & Stream
Object oriented programming
Object oriented programming
Object Oriented Programming
Constructors
Generics
Immutable Class & Objects
Object Class Methods and Constructor
Visibility
Linux
Linux
Linux
Linux Commands Part 1 - 4
Linux Commands Part 5 - 8
Linux Commands Part 9 - 10
Shell programming
Troubleshooting and Debugging
Software design
Software design
Software Design
OOPS
Solid Design
Design patterns
Design patterns
Design Patterns
Adapter DP
Bridge DP
Iterator DP
State DP
Strategy DP
Behavioral design pattern
Behavioral design pattern
Behavioral Design Pattern
Observer DP
Creational design pattern
Creational design pattern
Creational Design Pattern
Builder DP
Factory DP
Singleton DP
Structural design pattern
Structural design pattern
Structural Design Pattern
Facade DP
Spring boot
Spring boot
Spring Boot
Apache Camel
Controller in Spring Boot
Spring MVC
Spring Things
Spring basics
Spring basics
Spring Basics
Important Annotations
Important Spring Things
Maven Things
Spring A.O.P
Spring Beans
Spring boot controller
Spring boot controller
Spring Boot Controller
Response Entity Exception Handling
Spring data
Spring data
Spring Data
JDBC
Redis
Spring Data JPA
Tools
Tools
Tools and Tech
Docker
Git version Control
Neovim shortcuts
Timeline
Timeline
Year 2021
Timeline : Things i tried learning
Joins
Cross & Natural Joins
Full, Multiple & Self Join
Inner Join
Left & Right Join