Intelligent Query Architect (IQA) is a tool provided with iMIS that offers simple access to iMIS data for reporting, mailings, or letter and email merges and provides the ability to create sophisticated queries against the iMIS database even if you have limited experience with SQL. This on-line workshop covers the basics of creating, editing and running a query. You will learn how to perform simple joins, apply filters and work in both basic and advanced mode.
This workshop combines lecture, hand-outs and labs, with time for lab completion and discussion.
At the end of the class, attendees will have an understanding of:
- Running and editing queries
- Creating basic queries
- Applying filters and sort orders
- Creating a simple join
For more information, please feel free to review our detailed class page (including a downloadable brochure), or to learn more about our AYD classes in general, please check out our FAQ sheet.
Note: The times listed for this class are based on UK Time. (either Standard or Summer). Please be sure to keep this in mind if you live in another timezone.
From North America, this class is earlier in the morning (generally about 5am if you live on the East Coast). From Australia, this class is later in the evening (generally about 1900 or 2100 if you live in Melbourne). You are welcome to attend but in order to receive the benefits of the class, you will need to be in attendance. Details for accessing this At Your Desk class will be emailed to you approximately 24 hours before the start of the class.
Reminder: This session will be recorded, and the recording will be made available to all attendees. By registering for and attending the session, you give permission to ASI to record, reproduce and distribute the audio/video recordings from this training session. This session should be considered a public forum.