# Database Mentoship

## Course Syllabus

### SQL

- Where
- Group By
- Union
- View
- Joins
- Json
- CTE
- Functions

### Internals

- Query lifecycle
- System tables

### Indexing

- B-Tree
- Hash
- GiST
- SP-GiST
- GIN
- BRIN
- Multi Column Indexing
- Indexing impact on read/write performance

### Connection Pooling

- pgbouncer
- pgpool
- pgcat

### Timeseries

- Timeseries database design
- Timeseries data storage
- Timeseries data retrieval

### Scalability

- Postgres master/slave cluster
- Sharding