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 Australia Eastern Time (either Standard or Day Light Savings in Melbourne). Please be sure to keep this in mind if you live in another timezone.
From North America, this class is later in the evening but also a day earlier than what is listed (generally about 6pm to 8pm if you live on the East Coast on the day before the given date). From UK, this class is later in the evening (generally about 2300 or 0100 if you live in London). 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.