NASIS: Basic Query and Report Writing (NRCS-NEDC-000184)
This training will provide soil scientists with skills needed to select data from the NASIS database and create simple to moderately complex reports in tabular, narrative, or export formats which are suitable for everyday use.
Upon completion of this training, participants will be able to:
List the NASIS CVIR commands used in report scripts;
Explain the syntax used in the NASIS CVIR language;
Describe how report scripts are organized;
Describe how report scripts collect data from the selected set, permanent tables, or both;
Describe the concept of a database view as used in NASIS reports;
Explain basic row and column aggregation;
Define and use variables within report scripts;
Use reports to call properties and generate interpretive results;
Define and use page, line, and column layouts;
Perform NASIS Query Editor software interface navigation and operation procedures;
Explain NASIS database structure and content;
List the query writing tools;
Describe the relationship between comparison operators and data types;
Explain the common query rules;
Define selected sets;
Exhibit full understanding of target tables;
Use the DATE function in queries;
Use subqueries; and
Demonstrate when and how to use an outer join when writing a query.
Prerequisites and Recommendation
Basic NASIS training plus a working understanding of data objects, target tables, selected sets, security, and editing in NASIS.