58 G3 courses in Liverpool delivered Online

Audience This is an intermediate course for system and database administrators, application developers, and other individuals who need a technical introduction to selected new features of Db2 13 for z/OS. Prerequisites You should have practical experience with Db2 for z/OS Duration 2 days.  Course Objectives Learn about the new features and enhancements of Db2 for z/OS (v13), including the technical detail of the functional enhancements of this significant new version of Db2 for z/OS. Course Content Unit 1: Db2 v12 Function Levels: Selected Highlights Unit 2: Migrating to Db2 13 Unit 3: Availability & Scalability Unit 4: Performance Unit 5: Application Management and SQL Changes Unit 6: SQL Data Insights Unit 7: Security Unit 8: IBM Db2 Utilities Unit 9: Instrumentation and Serviceability

C&G 2377-77 PAT 1 Day

Who is this Level 3 NVQ aimed at? The electrical NVQ is designed for those with five or fewer years of experience in the electrical industry, and who have completed their City & Guilds 2365 Level two and three diplomas. Prior to joining, candidates will be assessed on their readiness for the Level 3 NVQ. What does this Electrical NVQ cover? This Level 3 Diploma covers Domestic, Commercial, and Industrial sectors – it will include a range of units of New Installations such as: Health and Safety Overseeing and organising work environment Applying environmental legislation Inspection and Testing Fault finding Professional discussions with assessors AM2 (this is a separate course and has an additional cost.) This is not a training course; it is an assessment of competence. Unlike other courses, this will not be based in a classroom or workshop – instead, candidates will complete this qualification on work placement. Candidates will complete electrical installations on-site, and they will then be assessed by a qualified assessor, building their portfolio. Only a small amount of this will involve going to a training centre. Before entering a workplace, your assessor will go over and help you understand: How to build a portfolio What range of evidence is required to meet the qualification criteria What assessors are looking for in order for candidates to demonstrate full professional competence Assessors will use a range of methods to evaluate candidate’s electrical installations such as; witness testimony, photographic evidence, direct observation, and reflective accounts. How long does the NVQ take to complete? The length differs for each candidate as it depends on how quickly they take to cover the types of work required to complete all units. If you have been working in the industry, previous jobs can be used as evidence to hurry the process up. What qualifications will I gain? Once candidates have completed their portfolio and other assessments, they will gain a formal City & Guilds Level 3 NVQ certificate. When candidates have completed their NVQ, they must move on to the AM2 end point assessment, which must be completed at an AM2 approved centre, such as our Sheffield centre.

Virtual Classroom – Our hi tec virtual learning suite enables you as the trainee to experience exactly the same course and level of interaction with a trainer as though you were in the same room as them. This isn’t a slideshow-based course, it’s a real tutor, in a real room taking you through all you need to know to be successful in your City and Guilds 2391 – 52. Utilising equipment and software, the theoretical part of the course will be taught over 3 days via the internet. During this time, you will be taught the theory-based elements below, also allowing ample time for questions face to face with the tutor. The instructor will go through everything that you will be expected to know about Inspection and Testing on both new and existing installations. You will be given access to our dedicated online portal to work through sample questions in your own time until the information becomes second nature to you. Your only hardware prerequisite for this part of the course is access to the internet, whether it be on a computer or a smart device. The second stage of the course will involve you attending one of our numerous training centres around the UK, for both the practical training and the examinations over a 2.5 day period. This will be booked for a later date and one of our team will be in touch with you to arrange this. During your time at one of our centres you will be taught the inspection and testing practical elements you require on individual training rigs, with equipment and testers for each and every individual person. (Our centres are ALL Covid secure and the training bays, etc are all socially distanced). This City & Guilds qualification is aimed at practicing electricians who have not carried out inspection and testing since qualifying or who require some update of training. This qualification helps you to develop the knowledge and practical skills required to professionally install and carry out initial verification and periodic inspection and testing on electrical installations. It is expected that suitable candidates have a basic knowledge and understanding of electrical science and principles and experience of electrical installation work. This is an essential skill for any electrical installer.

Who is this Level 3 NVQ aimed at? The experienced worker qualification is for practising electricians with at least 5 years experience but have never formally completed an industry apprenticeship or equivalent Level 3 NVQ Qualification. This is suitable for self-employed and employed electricians. This is the Level 3 pathway for practising electricians to obtain your ECS Gold Card and JIB Grading. To complete the full qualification you will also need to: Have completed an AM2e Assessment Have a current Wiring Regulations Qualification BS7671 Have an initial verification qualification such as a C&G 2391-50 What’s involved in the qualification? After an initial Skills Scan, we will discuss the gaps that need to be filled and you will be assessed using a range of methods to complete the evidence gathering process.There will also be Professional Discussions to discuss areas of expertise and you can choose either an installation or maintenance route based on the work you carry out.There are seven Performance Units to be assessed for the qualification, these are: Apply Practices and Procedures for Maintenance Apply Health, Safety and Environmental Considerations Organise and Oversee the Electrical Work Environment Apply Design and Installation Practices and Procedures Terminate and Connect Conductors Inspect, Test and Commission Electrical Systems Apply Fault Diagnosis and Rectification On completion of the Experienced Worker assessment you will be able to use the qualification to apply for a JIB Gold Card. This qualification is for experienced electricians who can demonstrate over 5 years experience.It is not suitable for new entrants or those currently on an apprenticeship.

This online PLC training course is done as a live classroom, using an online virtual classroom platform with live classes and a tutor present throughout the course. Not just an e-Learning package, this is a REAL LIFE classroom, giving you the opportunity to interact with the tutor. This course is fully interactive and a free copy of the software to each attendee which the tutor can view and give feedback on. The course is the best possible online experience you can have with a fully accredited certificate on completion of the exam. All instructions for installing the software and licencing it will be given prior to the course beginning. No prior knowledge is required for this course as it starts from scratch and assumes no previous experience, you will reach the skilled level where you can look at becoming a programmer, get into engineering maintenance in an industrial environment, fault find or make amendments to programs, this is the course for you. The course covers 2 of the major manufacturers, Siemens S7 and Allen Bradley (but will be slightly bias towards Allen Bradley due to the simulation software being used, which will also be given to you to keep). The course aims to be 90% practical, as we believe the easiest way to learn is to do it! A full set of course notes and manuals will be emailed to you.

Overview This 2 day course provides a practical introduction to Interest Rate Derivatives, equipping participants with the skills to price, trade, and manage risk across financial markets. Participants will explore key pricing concepts like bootstrapping, zero-coupon curves, and forward curves, while developing risk management techniques to navigate various market scenarios. The course also covers using derivatives to express macroeconomic views, bridging theory with real-world applications. By the end, participants will have the tools and insight to confidently engage with Interest Rate Derivatives in professional settings Learning Objectives Understand how to use Interest Rate Derivatives in different roles Grasp major pricing concepts like bootstrapping, zero-coupon curve, forward curve Develop risk management techniques to manage multiple scenarios Express Macro views using derivatives Who the course is for Anyone seeking practical insights into interest rate derivatives which include: Bank traders, market makers, sales, structurers, market risk Portfolio managers, execution traders Corporate treasurers, private bankers Operations, mid and back office personnel, brokers Graduate students and aspiring professionals aiming for careers in financial markets Course Content To learn more about the day by day course content please click here To you are interested in speaking with a course specialist, you can book a meeting here

Join us for a masterclass in bi-directional charging for electric vehicles. Otherwise known as Vehicle-to-Grid (V2G) or Vehicle-to-Anything (V2X), and learn about this potentially game-changing technology which brings together the transport and energy systems.

This course takes you through the history of cellular wireless technology and explains the new features that you will experience in 5G technology. From what is an antenna to how can cloud aid 5G and what is frequency to how Voice Over Internet Protocol (VoIP) fits in mobile communication, you will learn it all.

This Oracle 11g PL/SQL Part 2 course will be very advantageous for you to learn about developing database server-side PL/SQL program units within an Oracle database. This course covers a variety of topics which include understanding the basic form and structure of program units stored within the database, building and maintaining stored procedures, functions, packaged programs, and database triggers. In addition to that, you'll take the support of advanced programming techniques such as cursor variables and cursor expressions, which broadly discussed in the course. This course is ideal to prepare yourself for the Oracle certification exams (OCP). Upon successful completion of this course, you'll stand out from your competition while you're chasing your dream job! What Will I Learn? Prepare your environment Introducing Database Program Units Creating and Maintaining Stored Procedures & Functions Creating and Maintaining Packages Advanced Cursor Techniques Using System-Supplied Packages Creating and Maintaining Database Triggers Implementing System Event Triggers Requirements Familiarity with database and programming principles Who is the target audience? Application designers and developers Database administrators Business users and non-technical senior end users Introduction Introduction 00:03:00 Install Oracle XE 00:11:00 SQL Developer Installation 00:00:00 Workstation Setup 00:12:00 Database Program Units Introducing the Database Program Unit 00:19:00 Working with Stored Procedures and Functions Creating Stored Procedures and Functions 00:19:00 Understanding the Parameter Specification 00:23:00 Executing Procedures and Functions 00:26:00 Calling Functions from within SQL 00:13:00 Handling Compilation Errors 00:08:00 Maintaining Stored Procedures and Functions Recompiling and Dropping Programs 00:16:00 Data Dictionary Storage 00:25:00 Managing Dependencies 00:13:00 Tracking Dependencies 00:08:00 Using the Dependency Tracking Utility 00:09:00 Creating and Maintaining Packages What Is a Package? 00:10:00 Creating a Package 00:19:00 Package Definition Information 00:08:00 Advanced Programming Techniques 00:06:00 Using Persistent Global Objects 00:04:00 Including Initialization Logic 00:15:00 Object Oriented Support within Packages 00:14:00 Package Maintenance 00:18:00 Advanced Cursor Techniques Learning to Use Cursor Variables 00:24:00 Advanced Cursor Techniques Weak Cursor Definitions 00:16:00 REFCURSOR Cursor Definition 00:05:00 Using Cursor Expression 00:14:00 Using System Supplied Packages Using the DBMS OUTPUT() Package 00:12:00 Using the UTL FILE() Package 00:30:00 Creating Database Triggers Understanding the Database Trigger 00:23:00 Statement-Level Triggers 00:23:00 Row-Level Triggers 00:12:00 Row Level Trigger Example 1 00:11:00 Row Level Trigger Example 2 00:07:00 Row Level Trigger Example 3 00:08:00 Working with the INSTEAD OF Trigger 00:11:00 Using Triggers within an Application 00:09:00 Trigger Maintenance Using the CALL Statement 00:09:00 Trigger Maintenance Tasks 00:12:00 Work with Multiple Triggers for a Single Table 00:11:00 Handling Mutating Table Issues 00:22:00 Using the Compound Trigger 00:06:00 Working with System Event Triggers What Is a System Event Trigger 00:05:00 Defining Scope 00:04:00 Identifying Available System Events 00:12:00 Conclusion Conclusion 00:02:00 Course Certification