So I'm not a programmer and I work in a niche field of health informatics . My company are attempting to create some automation software (isnt everyone) and I see an opportunity to develop my career by working alongside the devops team to help create bespoke software for individual hospitals and healthcare providers.

I have specialist training in my field that a programmer wouldn't be able to learn for several years so they would need me to assist in building this software. I believe they are using SQL but with my limited understanding this seems... inappropriate somehow?

When you work with non programmers what do you a) find the most frustrating when communicating on a project b) what would you want a non programmer to understand about the realities of your job c) would it help if they knew some of the basics of programming and if so what resources would you recommend?

Sometimes I think it would be useful to just learn a programming language or request to be sent on a training course/bootcamp (UK based) but I don't know where to start. Thanks!