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?
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?