SQL in InfoNet

Howbery Park, UK - December 5, 2017

This 1-day course is the starting point for anyone interested in getting familiar with the SQL functionality within InfoNet. In this course participants will learn to use the basic SQL functionality and will cover the fundamental concepts underlying it’s use within InfoNet, such as Object Schema and Hierarchy, Object Selection and Deselecting, SQL with GIS and an introduction to some of the many inbuilt functions in SQL.

Duration

This is a 1-day computer hands-on training course.

Teaching Method

Participants are guided through a series of practicals by computer hands-on training.

Competency

A basic understanding of computers is required. Some familiarity with GIS or MicroSoft Office programs would be advantageous although not essential. Understanding of sewer and water networks would also be helpful although not a requirement.

Course Agenda

The day long course is broken down into four sessions with topics as follows:

Session A: InfoNet Data Model 

  • What Will I learn from the InfoNet SQL Course?
  • What is InfoNet?
  • What is SQL?
  • Schema
  • Cardinality

Session B: Select/Deselect Queries

  • Basic Object Selection
  • Creating An SQL
  • Selection in Multiple Clauses and Overriding the Table Name
  • Creating a ‘Mini’ Table using SQL
  • Apply Filter to Current Selection
  • Deselecting Objects
  • Flag Fields

Session C: GIS Layers and Objects

  • Interrogating GIS Layers with SQL
  • Deletion
  • Insertion
  • Assignment

Session D: Functions

  • Working With functions
  • Aggregate Functions
  • Date Functions
  • String Functions
  • The MATCHES Function
  • Other Functions

Accreditation

Innovyze has been approved as an Authorized provider by the International Association for Continuing Education and Training (IACET) and by the Registered Continuing Education Program (RCEP) which is a joint program from the National Council of Examiners for Engineering and Surveying (NCEES) and the American Council of Engineering Companies. Innovyze is a high quality continuing education provider for engineers and industry professionals.

 

Registration Fee

£495 (+VAT)

Related Documents

  • none
Upcoming Training

Follow Us

Innovyze Insider BlogInnovyze Users LinkedInInnovyze TweetsInnovyze TweetsInnovyze YouTubeInnovyze User Forums