Scalar

Subqueries and CTEs

Learn how to nest queries and use Common Table Expressions to break complex T-SQL logic into readable, reusable, and recursive building blocks.

User-Defined Functions

Learn the differences between scalar, inline table-valued, and multi-statement table-valued functions in T-SQL, and when each is the right tool.

Context in Perl (Scalar vs List)

Learn how Perl's scalar and list context changes the meaning of operators and function calls, and how to control context explicitly.

Scalar and Object Types

A deep dive into GraphQL's built-in scalar types, custom scalars, enums, and how object types compose the graph.

Data Types in PHP

A tour of PHP's scalar, compound, and special types, plus how PHP's dynamic typing and type juggling behave in practice.