Skip to main content

Is there any way to train oneself to creating SQL queries? for non IT person like me.

Hi @Sohail,

I think you can use query tool to create sql queries for quick reports. Please refer the following link it might be helpful for you.

https://docs.ifs.com/techdocs/foundation1/040_administration/300_system_information/080_sql_query_tool/default.htm

Thanks & Best Regards,

Wimali

Thank you very much. I will try that.

 

Kind regards,

 

Sohail

Hi @Sohail,

If you don’t have any experience with SQL and want to learn SQL in general, I would recommend W3Schools. You would be able to learn SQL from scratch and there are several exercises along with answers so you can practise easily. Once you have a good understanding of the syntax, you can practise with IFS databases using the SQL Query tool Wimali has suggested above. 

Hope this helps!

Terms & ConditionsCookie settings