Skip to Content
Tutorials

Programming

Programming tutorials for people who want code that actually runs, not code that only looks right. Pick a language, start at the beginning, and don't skip the basics. They are where most problems come from.

Any category Programming50 Python 10 JavaScript 10 TypeScript 10 SQL 10 HTML and CSS 10 DevOps10 Docker 10
Any topics Data Structures and Algorithms 2 Databases 10 Deployment and Containers 1 Packaging and Dependencies 2 Performance Optimization 1 Programming Basics 16 Security 1 Testing and Debugging 12 Type Systems 10 Web Development 11
Any level Beginner 50 Intermediate 55 Advanced 56
Programming Beginner Clear filters 50 results
0 likes
Run UPDATE and DELETE in a Transaction First

Run an UPDATE or DELETE inside a transaction, check the row count and roll back if it is wrong. After this, a missing WHERE no longer costs you the data.

3 min read
0 likes
Why = NULL Returns Nothing

See why a comparison with NULL returns no rows and fix it with IS NULL, IS DISTINCT FROM or COALESCE. After this, your WHERE clauses stop dropping rows with missing values.

3 min read