REST APIsHTTP MethodsIntermediate</> ProgramWhat are the main best practices for PUT versus PATCH in REST APIs?PUT usually represents replacement of a resource representation, while PATCH applies a partial change. Define exact semantics in the API contract and make validation behavior consistent for each method.
REST APIsHTTP MethodsIntermediate</> ProgramWhat is the recommended way to use PUT versus PATCH in REST APIs?Define exact semantics in the API contract and make validation behavior consistent for each method.
REST APIsHTTP MethodsIntermediate</> ProgramHow does PUT versus PATCH work in REST APIs?PUT usually represents replacement of a resource representation, while PATCH applies a partial change.
REST APIsHTTP MethodsBeginner</> ProgramWhat problem does safe HTTP methods solve in REST APIs?Safe methods such as GET are intended to retrieve data without requesting a state change on the server. Do not design GET endpoints that perform destructive or state-changing actions.
REST APIsHTTP MethodsBeginner</> ProgramWhen should you use safe HTTP methods in REST APIs?Do not design GET endpoints that perform destructive or state-changing actions.
REST APIsHTTP MethodsBeginner</> ProgramWhat is safe HTTP methods in REST APIs?Safe methods such as GET are intended to retrieve data without requesting a state change on the server.
Git & GitHubGit BasicsBeginner</> ProgramWhat are the main best practices for git status in Git & GitHub?`git status` summarizes branch state and shows staged, unstaged, and untracked changes. Run it frequently before add, commit, switch, merge, or rebase operations.
Git & GitHubGit BasicsBeginner</> ProgramWhat is the recommended way to use git status in Git & GitHub?Run it frequently before add, commit, switch, merge, or rebase operations.
Git & GitHubGit BasicsBeginner</> ProgramHow does git status work in Git & GitHub?`git status` summarizes branch state and shows staged, unstaged, and untracked changes.
Git & GitHubGit BasicsBeginner</> ProgramWhat problem does the staging area solve in Git & GitHub?The staging area holds the exact changes that will be included in the next commit. Review staged diffs before committing so one commit represents one coherent change.
Git & GitHubGit BasicsBeginner</> ProgramWhen should you use the staging area in Git & GitHub?Review staged diffs before committing so one commit represents one coherent change.
Git & GitHubGit BasicsBeginner</> ProgramWhat is the staging area in Git & GitHub?The staging area holds the exact changes that will be included in the next commit.
MySQLQueriesBeginner</> ProgramWhat are the main best practices for DISTINCT in MySQL?`DISTINCT` removes duplicate result rows based on the selected columns. Use it when duplicates are semantically unwanted, but investigate whether unexpected duplicates come from an incorrect join.
MySQLQueriesBeginner</> ProgramWhat is the recommended way to use DISTINCT in MySQL?Use it when duplicates are semantically unwanted, but investigate whether unexpected duplicates come from an incorrect join.
MySQLQueriesBeginner</> ProgramHow does DISTINCT work in MySQL?`DISTINCT` removes duplicate result rows based on the selected columns.
MySQLQueriesBeginner</> ProgramWhat problem does GROUP BY solve in MySQL?`GROUP BY` aggregates rows into groups so aggregate functions such as COUNT, SUM, or AVG can operate per group. Group by the actual dimensions required by the report and avoid selecting unrelated non-aggregated columns.
MySQLQueriesBeginner</> ProgramWhen should you use GROUP BY in MySQL?Group by the actual dimensions required by the report and avoid selecting unrelated non-aggregated columns.
MySQLQueriesBeginner</> ProgramWhat is GROUP BY in MySQL?`GROUP BY` aggregates rows into groups so aggregate functions such as COUNT, SUM, or AVG can operate per group.
PHPLanguage BasicsBeginner</> ProgramWhat are the main best practices for null coalescing in PHP?The `??` operator uses a fallback when a value is missing or null. Use it for optional inputs when null/missing means use a default, while still validating required data.
PHPLanguage BasicsBeginner</> ProgramWhat is the recommended way to use null coalescing in PHP?Use it for optional inputs when null/missing means use a default, while still validating required data.