• We’re currently investigating an issue related to the forum theme and styling that is impacting page layout and visual formatting. The problem has been identified, and we are actively working on a resolution. There is no impact to user data or functionality, this is strictly a front-end display issue. We’ll post an update once the fix has been deployed. Thanks for your patience while we get this sorted.

How to learn the programming mindset

Semidevil

Diamond Member
My current job requires me to use SQL on a daily basis. it's not just calling columns and joining tables, but there are a lot of programming involved. I.e. Setting variables, parameters, stored procs, loops, looking up tables and columns within specific ranges etc etc

I have no programming background and my issue is 1) Not being able to understand the syntax of existing code, and 2) Having trouble with creating new queries that involves variables and more complex queries

I bought a beginners book and I understand the commands of select, groups, joins, case etc etc but the programming part is still difficult.

What do you suggest is the best way to learn and improve that aspect in sql?
 
Practice is the best teacher. You can read books and tutorials from the Internet.

Second the above!

And read "Clean Code: A Handbook of Agile Software Craftsmanship" (If you haven't already done so). It's a solid way to begin thinking about good ways to code. It saved my life, and got me to think about my incurred technical debt in a more holistic and involved way.
 
Back
Top