This is a 1 day course aimed at advanced users and Super Users.

In terms of the SQL course, it is designed for non technical people so it is a course designed to introduce users to the basics of SQL from a non technical perspective.

We can cover some more clever stuff in the latter end of the course depending on how we get on with the course for the early part of the day. It is aimed as an add-on to Excelerator so knowledge of Excelerator is preferred.

It would be beneficial for candidates to have completed the following courses beforehand:

Excelerator for Super Users

The course will cover :

• Designed to enhance the use of Excelerator by existing users/report writers
• Guides users through the preferred notation/layout
• Written from a non technical perspective so suitable for accountants
• Introduces the basic concepts of SQL (to allow users to extract and manipulate data from U4BW

• SELECT
• FROM
• WHERE
• [GROUP BY]
• [HAVING]
• ORDER BY
• SUM/COUNT/MIN/MAX
• Covers the main need-to-know aspects and then moves into some more complex concepts to leave users with a good understanding of how SQL interacts with U4BW, including the data model, database views, AG16s and a brief look at server process log files.

If there is time, we cover:

• Date conversion
• UNION
• Subselect
• CASE statements
• Search, LTRIM and RTRIM

The course will run from 9.30 - 4.30pm with an hours break for lunch. There will also be break times in the morning and afternoon to allow delegates to get refreshments and snacks.

Training manuals will be provided electronically along with a link to the session which will be delivered via Zoom.

There will be plenty of time for you to ask questions and groups will be kept small with a maximum of 6 delegates per session so that everyone has the chance to absorb and digest what they are learning.

Please note: As sessions are being delivered remotely due to the current Covid 19 situation, there may be some unavoidable background noise or interruptions. In addition if we do experience the odd technical glitch - we will do whatever we can to ensure they are overcome as quickly as possible.

This is a one-day course