Unit4 ERP SQL for Excelerator  Users Training Course

Myriad are the strategic training partner of Unit4 UK&I and we understand the importance of training in the success of your project. Our mission is to take your people on a journey, from awareness, through knowledge, and on to expertise in whatever their interaction with Unit4 ERP. This is our core belief and how we measure the success of our projects.

Myriad Consulting

A unit4 ERP webinar on SQL for Excelerator

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 UsersThe course will cover :<ul><li>	Designed to enhance the use of Excelerator by existing users/report writers
</li><li>	Guides users through the preferred notation/layout
</li><li>	Written from a non technical perspective so suitable for accountants
</li><li>	Introduces the basic concepts of SQL (to allow users to extract and manipulate data from U4BW
</li></ul><ul><li>	SELECT
</li><li>	FROM
</li><li>	WHERE
</li><li>	[GROUP BY]
</li><li>	[HAVING]
</li><li>	ORDER BY
</li><li>	SUM/COUNT/MIN/MAX
</li><li>	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.
</li></ul>	If there is time, we cover:
<ul><li>	Date conversion
</li><li>	UNION
</li><li>	Subselect
</li><li>	CASE statements
</li><li>	Search, LTRIM and RTRIM
</li></ul> 
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

Unit4 ERP SQL for Excelerator Users Training Course

More events from Myriad Consulting

Discover more events from Myriad Consulting, from Business to other experiences you might love.

Still looking for the right event?

Explore all online events to browse and filter by date, category, and more.

Unit4 ERP SQL for Excelerator Users Training Course

More events from Myriad Consulting

Discover more events from Myriad Consulting, from Business to other experiences you might love.

You might also like...

Browse more events with different dates, prices, and formats to find your next great experience.

Still looking for the right event?

Explore all online events to browse and filter by date, category, and more.