Skip

NASIS – Basic Query and Report Writing | NRCS NEDC

NASIS – Basic Query and Report Writing (NRCS-NEDC-000184)

Overview

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. .

Objectives

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.
  • 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.

Duration

3 days.

Eligibility

Any National Cooperative Soil Survey partner.

NEDC Contact

Tony Lovell

Technical Specialist

Paul Finnell
402/437-4136

Enrollment

Go to AgLearn to request enrollment in NASIS – Basic Query and Report Writing (NRCS-NEDC-000184).