TC56 - Sysmac SQL | Omron, UK

Login

Please use more than 6 characters. Forgot your password? Click here to reset.

Change password

We are experiencing technical difficulties. Your form submission has not been successful. Please accept our apologies and try again later. Details: [details]

Download

Register

We are experiencing technical difficulties. Your form submission has not been successful. Please accept our apologies and try again later. Details: [details]

Download

Thank you for registering

An email to complete your account has been sent to

Return to the website

get direct access

Fill in your details below and get direct access to view content

Text error notification

Text error notification

Checkbox error notification

Checkbox error notification

We are experiencing technical difficulties. Your form submission has not been successful. Please accept our apologies and try again later. Details: [details]

Download

Thank you for your interest

You now have access to TC56 - Sysmac SQL

A confirmation email has been sent to

Continue to page

Please or get direct access to download this document

Training

TC56 - Sysmac SQL

Designed to illustrate the powerful, yet easy, implementation of the Sysmac SQL data connection.

Course details:

The course is primarily hands-on using dedicated training equipment, incorporating our NJ Sysmac controller.

Introduction to SQL in Sysmac NJ:

  • The Sysmac NJ SQL controller.
  • Overview of the Sysmac SQL server interface.

NJ SQL programming:

  • Connecting Sysmac NJ to the SQL server.
  • Using the SELECT, INSERT, DELETE and UPDATE commands in Sysmac NJ to query and update an SQL database.
  • Discuss INSERT using Triggers (Utilising SQL Store Procedures).

Working with SQL:

  • Monitoring the performance and status of the SQL connection.
  • Handling lost connections with the Spooler.
  • SQL debugging and logging features in the Sysmac NJ.
  • Common SQL configuration problems.

The primary objective of the course is to provide a comprehensive introduction to the use of the Sysmac SQL server interface.

The course is suitable for engineers and technicians who have attended the Sysmac Control Basic course TC051.

£400.00 (1 day)

All course prices are subject to VAT.

Training availability

No available dates. If you are interested in following this training programme please contact us
£400 To be arranged

Related training

TC51 - Sysmac Control Basic

This course is designed to introduce engineers and technicians to Sysmac controllers.

SYSMAC
07 - 08 Sep £600 Milton Keynes
05 - 06 Oct £600 Milton Keynes
02 - 03 Nov £600 Milton Keynes
07 - 08 Dec £600 Milton Keynes