Skip to the notes
JSGroundwork
JSGroundwork handwritten · web dev
✎Playground→⌘Problems↻Review🔥Progress

Chapters

25 chapters
⌕
Beginner8›
B1Relational modelB2SELECT fundamentalsB3JoinsB4AggregationsB5Insert/update/deleteB6Types & constraintsB7Schema design basicsB8Using a DB client
Intermediate9›
I1Normalization in depthI2IndexesI3TransactionsI4Subqueries & CTEsI5Query performanceI6NoSQL fundamentalsI7ORMsI8MigrationsI9Backups & replication
Advanced8›
A1Database internalsA2Scaling readsA3Scaling writesA4Advanced transactionsA5Caching layersA6Security in depthA7Time-series & analyticalA8Schema case study
/ search[ ] chaptert top

SQL & Databases levels

1Beginner2Intermediate3Advanced

Ready to read

JSJavaScript⑂Git◎Interview prepΣDSA in JSSDSystem Design
More topics15›
</>HTML{ }CSS⚛ReactNNext.jsNeNest.jsTSTypeScriptNoNode.js🐳DockerDBSQL & Databases✓Testing🔒Web Security☁Cloud & DevOps◈GraphQL◆Redis☸Kubernetes
100%
I4

Subqueries & CTEs

not written yet

This section will cover:

  • Recursive CTEs, window functions
←previousTransactions↑ CovernextQuery performance→