Skip to main content
Question

SQL query trainning


Forum|alt.badge.img+5
  • Sidekick (Customer)
  • 12 replies

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

Wimali Athulathmudali
Hero (Employee)
Forum|alt.badge.img+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


Forum|alt.badge.img+5
  • Author
  • Sidekick (Customer)
  • 12 replies
  • July 16, 2021

Thank you very much. I will try that.

 

Kind regards,

 

Sohail


Charith Epitawatta
Ultimate Hero (Employee)
Forum|alt.badge.img+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!


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings