Skip to Content
E-Learning

Tutorials

Practical tutorials for the work we actually do. Pick one, read it in order, and apply it.

Any category Programming2 TypeScript 1 SQL 1
Any topics APIs and Integrations 7 Automation and Scripting 3 Data Structures and Algorithms 2 Databases 11 Deployment and Containers 14 Object-Oriented Programming 3 Packaging and Dependencies 5 Performance Optimization 24 Programming Patterns 10 Security 5 Testing and Debugging 10 Type Systems 14 Web Development 15
Any level Beginner 2 Intermediate 4 Advanced 2
Data Structures and Algorithms Advanced Clear filters 2 results
0 likes
const Assertions for a Fixed Lookup Table

Freeze a lookup table with as const and derive its keys and values as types. After this, the table and the type that describes it can never drift apart.

5 min read
0 likes
Walk a Tree With a Recursive CTE

Walk down an employee tree, walk up to the top, count each manager's team and guard the query against a loop with CYCLE. After this, you can query a parent-child table of any depth.

5 min read