search

kamranahmedse / developer-roadmap

Interactive roadmaps, guides and other educational content to help developers grow in their careers.
https://roadmap.sh
Other
298.29k stars 39.23k forks source link

Conditional expressions are not really even mentioned #6962

Closed alessandrobaldazzi closed 1 month ago

alessandrobaldazzi commented 2 months ago

Roadmap URL

https://roadmap.sh/sql

Suggestions

Conditional expressions and statements are not really dived into, but they are a blessing to obtain simple, easy-to-read solutions and to manage nulls. The main ones I would add are the IF function and the IFNULL functions, but really there is so much that can be useful and it's not really mentioned.

For reference, I think these two links give quite the good list: https://medium.com/@ejirogabriell2019/conditional-statements-logic-and-expression-in-sql-understanding-the-differences-451ec183c81a https://www.geeksforgeeks.org/sql-conditional-expressions/

dansholds commented 2 months ago

@alessandrobaldazzi we currently have just these conditional statements, I can add a few more to this section if you think its required?

Screenshot 2024-09-09 at 16 08 19

alessandrobaldazzi commented 2 months ago

Yeah, I think a bit more insight on the argument would be great. If there were both a simpler and a more complex roadmap like for other topics I think it could be avoided in the simpler one, but as it is right now it could help.

dansholds commented 1 month ago

Added this to our internal list.