Section 3.2 Training Exercises
The training exercises are to be found in Appendix J (Training Exercises), and are broken into ‘Easy’, ‘Moderate’ and ‘Difficult’ sections. Readers are also referred to Appendix A (Basic Outline and Use of Structured Query Language) for examples on the use of SQL as applied against the ORMGP database.
Software requirements for the training exercises in Appendix J include:
- Microsoft Access - all D_*, R_* and V_* tables/views have to be linked into an Access database (using the procedures described in Section 3.1.1);
- Microsoft SQL Management Studio - the user should be logged into the SQL Server hosting the partner database. A server name of ‘MAIN\PARTNER’ and a database of ‘OAK_20120615_CLOCA’ is assumed for the latter;
- SiteFX, Viewlog or other software (e.g. GIS applications) should have the appropriate file(s) or connection(s) available (see the appropriate section in Section 3.1).