Free Consultation Careers Contact Us
☰

Embridge Training

Products
Training Courses

SQL Basics for Unit4 ERP

Enable your users to enter into the wonderful world of SQL and give them the understand how it can be used to interrogate the Unit4 ERP.

Duration: 1 Day

Level | Getting Advanced

Enable your users to enter into the wonderful world of SQL and give them the understand how it can be used to interrogate the Unit4 ERP.

Summary

Increase your internal skills levels for superior maintenance and query reporting at the database level.
Aimed at the more technical user, this course gives an introduction to SQL and how it can be used to enhance the Unit4 ERP, making query reports more flexible by combining database tables so that enquiries are more flexible and ultimately more relevant to your audience.
Learning outcomes
Designed for users to gain an overview and guidance on how to write simple SQL for use primarily in Unit4 Excelarator reporting covering:
  • The basics of SQL enabling you to extract and manipulate data for Excelarator reports
  • An introduction to basic SQL Language
  • The tools to enhance Excelarator reporting capabilities
Delegate pre-requisites

Good technical and functional understanding of Unit4 ERP

Who is it for?
  • Application Support
  • System Administrator
  • Technical Support
  • Report Writers
Language

Interactive workshop with an experienced consultant. All Embridge Unit4 courses are currently delivered in English.

Course Structure

Session 1

Introduction to SQL

In this session, you will gain a basic understanding of SQL and its formats.
This session covers:
  • The structure of a SQL Query
  • How it can be used in Unit4 Excelarator
Session 2

Selecting Data

In this session you will understand how to select data for your SQL query.
This session covers:
  • How to identify fields to select
  • How to avoid duplicate field names
  • How field names relate to different Unit4 tables
Session 3

Table Selection

In this session you will understand the Unit4 table names and table joins.
This session covers:
  • A single table enquiry
  • Multiple table joins
  • Use of table aliases
  • The difference between inner and outer joins
Session 4

Data Restriction

In this session, you will look at the ‘where’ clause in a SQL statement.
This session covers:
  • Why you restrict in the ‘where’ clause?
  • The ‘where’ terminology.
Session 5

Sorting

In this session you will discover how to sort data in your SQL query and understand the ‘order by’ clause.
Session 6

Sum and Group

In this session you will understand how to aggregate data to make your query more efficient.
This session covers:
  • How to sum amounts in SQL
  • How to select the Max / Min date etc
  • The purpose of group and having
Session 7

Advanced functions

In this session you will understand some of the additional functions available in SQL
Note: This session is deigned using a selection of the more useful features and does not cover all available functions.
This session covers:
  • Some additional functions and SQL code
  • How to use a sub select statement
  • Various other hints and tips
Session 8

Database Structure

In this session you will understand how the data dictionary and data model fit into the Unit4 ERP model.
This session covers:
  • What is the data dictionary?
  • How can it be used for SQL queries?
  • What is the Data Model and how does it work in the Unit4 ERP?
Session 9

SQL and Unit4 ERP

In this session you will understand more about how SQL works with Unit4 ERP and can be used behind the scenes in the product.
This session covers:
  • What is a database view and how is it created / used?
  • How What is an AG16 and what is its purpose?
  • SQL with Excelarator
  • How to interpret log files

Premium Education training subscription

Part of the College of Reporting and Technical

Premium Education training is a people-centric approach to driving training and development by always learning; learning all ways. Our subscription-based training services gives the employee and employer a suite of Unit4 training allowing the flexibility to empower your employees for effective, efficient, and proficient use of technology and solution platforms at their fingertips.

More details about Premium Education will be coming soon. Watch this space!

In the mean time if you would like to know more email enquiries@embridgeconsulting.com

Cancellation policy

All courses are delivered virtually, price per person plus VAT. On site training is available on request. Please read our cancellation policy and booking terms and conditions before checkout.

£549.00

*Interactive workshop with an experience consultant. Select the number of attendees above. Course is delivered virtually and the price is plus VAT. By booking, you agree to our Terms & Conditions. An invoice with details on how to pay will be sent to your registered email address.

Overall we found the course extremely useful and could possibly benefit from being a 2 day course that would allow more time on examples and to embed knowledge further.

Plymouth University Senior Finance Systems Manager
Products
Training Courses

Other Courses

Unit4 Timings Workspaces

Enhance your user's experience of the Unit4 ERP by learning to create your own tailored role based workspaces that provide meaningful information and central navigation to key system processes.

1 Day | £549.00

Unit4 Webservice API Workshop

An interactive workshop which familiarises users with Unit4 API’s and how these can be leveraged to support integration, reporting and automation.

1 Day | £549.00

Admin – Flexi-fields and Forms for Unit4 ERP

Enhance the capabilities of your Unit4 ERP by creating your own unique flexible fields and electronic forms to record and report on the key data needed for your business.

1 Day | £549.00

Excelerator for Unit4 ERP

Learn how to enhance your informative spreadsheet reporting by using standard Unit4 ERP browser enquiries and the Excelerator Add-in tool.

£549.00

Admin – Workflow Advanced for Unit4 ERP

Learn how to enhance your existing Unit4 ERP workflow skills by gaining a deeper understanding of the extensive workflow automation and its capabilities to improve your internal automation processing.

1 Day | £549.00

Admin – Workflow Basics for Unit4 ERP

A full day introduction course to the Unit4 Workflow facilities enabling an understanding of how in-system automation can support your organisation.

1 Day | £549.00

Admin – System Administration for Unit4 ERP

Learn how to effectively manage and maintain your Unit4 ERP environment, in this comprehensive 2 day course so you can maintain best practices and maximise your investment.

2 Days | £1,098.00

Advanced Reporting for Unit4 ERP

Using the Unit4 Report Engine software, this course will enable you to create formatted, function rich customer facing reports to suit all workforce audiences.

2 Days | £1,098.00

Finance Reporting in Web for Unit4 ERP

Learn how to enable your users in the maintenance and creation of their own Unit4 ERP financial reports without reliance on costing reporting consultancy.

1 Day | £549.00

Unit4 Service Call Workshop

Explore how to leverage Unit4 Service Call functions to automate processes.

1 Day | £549.00
Shop All Training Courses

Contact us about Training

    Embridge Consulting is committed to protecting and respecting your privacy. From time to time, we would like to contact you about our products and services, as well as other content that may be of interest to you. You consent to allow us to store and process the personal information submitted above to provide you the content requested.