Kursen har inget datum. Ring vår kursbokning 077 186 10 37 för information om en privat utbildning.
Översikt
| Kurskod | 0S2C1SE | Leveranstyp | Classroom
(Hands-on labs) |
|---|---|---|---|
| Kurslängd | 2.0 dagar | Kurstyp | |
| Listpris | Set by Partner |
This class begins with a discussion of the ShowCase Suite environment and the connectivity required for accessing a database on the IBM System i5 (iSeries) platform. Defining expressions and building complex conditions with SQL are discussed. Extensive time is spent using the Query add-ins with Microsoft Excel. The student will learn how to work with Structured Query Language (SQL) to create Subselects and Unions. The use of dates and data storage of dates is discussed, as well as how to use the various options provided for running queries. Lab exercises are included to reinforce the learning.
Målgrupp
This class is intended for experienced users of Query and Report Writer who want to use more advanced functions for creating reports.
Förkunskaper
The students must have completed the ShowCase Query course or have Query experience. A thorough understanding of Microsoft Windows is required. Some experience with Microsoft Excel or Lotus 1-2-3 is recommended.