Question

SQL query trainning

  • 16 July 2021
  • 3 replies
  • 875 views

Userlevel 4
Badge +5

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


This topic has been closed for comments

3 replies

Userlevel 5
Badge +8

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

Userlevel 4
Badge +5

Thank you very much. I will try that.

 

Kind regards,

 

Sohail

Userlevel 7
Badge +31

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!