Skip to the notes

JSGroundwork handwritten · web dev

✎Playground→⌘Problems ↻Review 🔥Progress

Chapters

25 chapters

⌕

Beginner8›

B1Relational model B2SELECT fundamentals B3Joins B4Aggregations B5Insert/update/delete B6Types & constraints B7Schema design basics B8Using a DB client

Intermediate9›

I1Normalization in depth I2Indexes I3Transactions I4Subqueries & CTEs I5Query performance I6NoSQL fundamentals I7ORMs I8Migrations I9Backups & replication

Advanced8›

A1Database internals A2Scaling reads A3Scaling writes A4Advanced transactions A5Caching layers A6Security in depth A7Time-series & analytical A8Schema case study

/ search[ ] chaptert top

SQL & Databases levels

1Beginner 2Intermediate 3Advanced

Ready to read

JSJavaScript ⑂Git ◎Interview prep ΣDSA in JS SDSystem Design

More topics15›

</>HTML { }CSS ⚛React NNext.js NeNest.js TSTypeScript NoNode.js 🐳Docker DBSQL & Databases ✓Testing 🔒Web Security ☁Cloud & DevOps ◈GraphQL ◆Redis ☸Kubernetes

100%

B8

Using a database client

not written yet

This section will cover:

psql/mysql CLI or a GUI client, the basics

←previousSchema design basics↑ Cover nextNormalization in depth→