23001 Business courses

Duration 3 Days 18 CPD hours This course is intended for Application Developer Data Modeler BI / BW Consultant Data Scientist Database Administrator SAP HANA Support Personnel Overview This course will prepare you to: Push down data intensive tasks to the SAP HANA database using SQL and SQLScript Understand how to code using advanced SQLScript techniques Follow recommended practices for writing optimal SQL and SQLScript Debug and analyze SQL and SQLScript code This course provides students with basic SQL knowledge or refreshes their SQL knowledge, and enables them to use basic and some advanced SQL techniques for querying and manipulating data in an SAP HANA database. Getting Started What is SQL and SQLScript? Understanding how ABAP developers work with SQLScript Understanding XS Advanced and HDI Working with Web IDE for SAP HANA Understanding the course data SQL Logic Container Creating user-defined functions Creating database procedures Trapping errors in SQLScript User defined libraries Declarative Logic Using declarative logic Imperative Logic Using imperative Logic Transactional Savepoints How to implement transactional savepoints Analytic Operations Using OLAP Analytic features Implementing Temporal Tables Working with Hierarchies Working with Hierarchies Troubleshooting and Best Practices Tools for troubleshooting Best Practices Appendix Starting from the beginning with SQL fundamentals Additional course details: Nexus Humans HA150 SAP HANA 2.0 SPS05 SQLScript for SAP HANA training program is a workshop that presents an invigorating mix of sessions, lessons, and masterclasses meticulously crafted to propel your learning expedition forward. This immersive bootcamp-style experience boasts interactive lectures, hands-on labs, and collaborative hackathons, all strategically designed to fortify fundamental concepts. Guided by seasoned coaches, each session offers priceless insights and practical skills crucial for honing your expertise. Whether you're stepping into the realm of professional skills or a seasoned professional, this comprehensive course ensures you're equipped with the knowledge and prowess necessary for success. While we feel this is the best course for the HA150 SAP HANA 2.0 SPS05 SQLScript for SAP HANA course and one of our Top 10 we encourage you to read the course outline to make sure it is the right content for you. Additionally, private sessions, closed classes or dedicated events are available both live online and at our training centres in Dublin and London, as well as at your offices anywhere in the UK, Ireland or across EMEA.

Duration 3 Days 18 CPD hours This course is intended for This advanced course is designed for those individuals who are responsible for operating and managing the operation of an IBM i system. Overview Explain the concept of how LPAR works Explain the functions served by the HMC Explain how user versus resource security are implemented Explain the difference between group profiles and authorization lists Describe how adopted authority works Describe how work is managed on the system and the concepts of the performance tuning process on the system Explain how Management Central can be used to manage a single system or a network of System i servers Perform the steps to create a basic CL program using both the traditional (PDM and SEU) and the newer GUI (RSE and LPEX) application development tools Perform the steps to create a menu using SDA Provide some tips on how you can improve your operations This course is designed to enhance the skills of an IBM i System Operator. This course explains the concept of how LPAR works and discusses the functions provided by the HMC LPAR concepts and overview . Console options and HMC overview . IASP concepts and overview . Security concepts and overview . System values . User security (user and group profiles) . Resource security . Authorization lists and adopted authority . Management Central overview . Commands and tasks using Management Central . Inventory using Management Central . System values using Management Central . Other Management Central functions . Work management: Concepts and overview . Work management: Subsystem concepts and overview . Work management: Job processing concepts and interactive jobs . Work management: Job processing concepts of other job types . Work management: Submitting and tracking of batch jobs . Programming concepts . CL programming concepts . Using PDM and SEU to create a CL program . Starting and setting up RSE . Creating a CL program using RSE and LPEX Editor . Creating a menu using SDA . Tips for improved operation .

Leading People through Change (Virtual) Research shows that 70% of change initiatives fail in large organizations. The largest factor contributing to this failure rate is leadership - the inability to plan and lead people through change. In many change situations, tremendous focus is put on strategy, processes, and systems, while the issue of changing people's behavior is assumed it will 'just happen'. In this interactive course, you will learn why the people side of change is crucial. We will begin by understanding why and how people resist change, and how important it is to become strong and effective change champions. Next, we will focus on critical change management practices - creating our vision of the future state, planning for acceptance in our change audience and stakeholders, mitigating threats, and capitalizing on opportunities. We will use metrics to plan, show progress, and confirm success. Lastly, we will focus on the need to reinforce and sustain change, and to prevent relapse to old ways and methods. What you will Learn At the end of this program, you will be able to: Realize the nature of change and describe how resistance manifests in people Compare prevalent change models and categorize their similarities Identify and rate the skills, traits, and behaviors of effective change champions Envision the future state and assess stakeholders Plan for change communication, training, and risks Evaluate change effectiveness using feedback and metrics Develop reinforcement practices for benefits and communication Getting Started Foundation Concepts What is Change? Resistance to Change Common Change Management Theories Becoming a Change Champion Plan Envisioning the future state Planning for people Change management plan Do Change communication Training Piloting Risks Study Feedback Metrics Variance analysis Act Benefits realization Change sustainment Reinforcement messaging and communications Summary and Next Steps

Duration 5 Days 30 CPD hours This course is intended for In order to be successful in this class, incoming attendees are required to have current, hands-on experience in developing basic web applications, and be versed in HTML5, CSS3 and JavaScript. This is an intermediate level web development class, designed for experienced web developers, new to Angular, that need to further extend their skills in modern web development. Overview At the end of this five-day course, students will have an application up and running that incorporates components, directives, custom pipes, reactive forms, routes, services, unit testing, and the REST API. They will add authentication, implement the Material library, and learn how to maintain state with NgRX. They will then take a deeper dive including making their own custom directives, lazy loading modules, and E2E testing. They will learn how to enhance their application with animations and create their own Angular library. Working within in an engaging, hands-on learning environment, guided by our expert team, attendees will learn explore: What Angular is and why should you use it How Angular reduces the amount of code that you must write to add rich functionality to both existing and new web pages What TypeScript is, why it is useful, and how to use it with Angular How to facilitate development and deployment using Angular CLI How to work with the various aspects of the Angular architecture to implement clean, responsive web interfaces How Routers can support navigation within a Single Page Application What the best practices are for using Angular so that it works unobtrusively and performs well How to use Angular with HTTP to support JSON, REST, and other services Working with the Ahead of Time compiler including its impact of developers and the development process How to defend against DOM-based XSS How to manage routing decisions based on pre-defined criteria such as a successful authentication How to meet huge data requirements by processing asynchronous data streams with RxJS Simplify server-side rendering How to facilitate unit testing Enhance an Angular user interface with animations and other advanced features Optimize Angular applications with various tools and techniques Maintain state within an Angular application What Angular 9 brings to the table and its relationship to Angular 8 Mastering Angular is a five-day, hands-on course that thoroughly explores the latest Angular features and advances, demonstrating how to solve the traditional challenges of JavaScript web application development. Throughout the course students will build custom components using application routes, form validation, and unit-testing. The course starts with an introduction of Angular CLI and TypeScript, and then delves into component-driven development with Angular components, covering data-binding, directives, services, routing, HTTP, the RxJS library, forms unit testing, and REST. Students will also learn how to add authentication, use the Material library, learn the NgRX design pattern to implement the NgRX store, make custom directives, enhance their application with animations, write an E2E test, and increase their application's efficiency by lazy loading modules and creating their own Angular library Angular Overview Overview of Angular Architecture Getting Started with Angular Getting Started with TypeScript Bootstrapping with Angular CLI Angular Project Structure Working with Angular Components and Events Third Party Libraries Dynamic Views Pipes Angular Forms Forms and the Forms API Single Page Applications and Routes Single Page Applications Services and Dependency Injection Modules Using RESTful Services Overview of REST Angular and REST Angular Best Practices Angular Style Guide What is New in Angular 9 Reactive Programming in Angular Working with RxJS Security and Authentication DomSanitizer JSON Web Tokens Route Guards Enhancing the Angular App Angular Animations Angular Material Angular Elements Deep Dive into Angular Testing and Angular Deep Dive into Components and Directives Deep Dive into Services and Dependency Injection Optimizing for the Enterprise Lazy Loading Optimizing with Universal Creating Your Own Angular Library Maintain State with NgRX NgRX Store Lesson: ES6+ Sass and SCSS for Angular and Material

Our purpose is to ensure that people of all ages, especially young people aged 12-35, are able to acquire the social and emotional benefits of creative music-making and multimedia activities. We work especially with those suffering from loneliness and isolation; communities disproportionately affected by the health crisis; and schoolchildren who are suffering from social isolation that sadly prevents them from achieving their potential.

NPORS Crusher Training The aim of the NPORS Crusher Training is to provide theoretical and practical training for operators of Mobile Crushing equipment in the workplace. This Crusher training Course Or Test is carried out on your site using your own equipment. Please contact us for a competitive quote The Crusher Training Course is designed to provide candidates with the skills and knowledge required in order to operate a crusher safely and competently in the workplace. NPORS is an approved CSCS Partner Card Scheme, providing evidence that individuals working on construction sites have the appropriate Crusher training and qualifications for the Crusher Operation. Furthermore, training criteria is based on the approved standards of the Construction Leadership Council. Most major contractors should accept the NPORS Crusher card when presented on-site, which displays the silver CSCS logo. This NPORS crusher training meets the statutory requirements of the Health & Safety at Work Act 1974 and other relevant statutory provisions and Approved Codes of Practice. NPORS Crusher Test For Experienced Operators Book with Confidence at Vally Plant Training At Vally Plant Training, we guarantee unbeatable value with our Crusher Experienced Test Price Match Promise. When you choose us, you can book with confidence, knowing that we will not be beaten on price. If you find a lower price for the same NPORS Crusher Experienced Worker Test, we’ll match it—ensuring you receive top-quality training at the best possible rate. Click for our terms and conditions Your skills, our commitment—always at the best price. NPORS Crusher Test is for operators who have received some form of training in the past or alternatively has been operating Crusher for a number of years. If you are unsure if you qualify to go down the test route please contact us to discuss this in more detail. Discounts are available for multiple bookings There are two parts to the Crusher Test, a theory section comprised of 25 questions and a practical session operating the Crusher, revision notes are available when booking. Crusher Course Content Crushers are essential equipment in mining, quarrying, and construction industries, tasked with breaking down large rocks and materials into smaller, more manageable sizes. Operating mobile crushers requires specialised skills and knowledge to ensure safety, efficiency, and optimal performance. In this comprehensive course overview, we will explore the essential content covered in a crusher training course, designed to equip participants with the expertise needed to operate crushers safely and effectively in the workplace. 1. Introduction to Crushers: Overview of crusher types: jaw crushers, cone crushers, impact crushers, etc. Understanding the components and operating principles of crushers Different configurations and applications for specific tasks 2. Crusher Safety Procedures: Importance of safety in crusher operation Pre-operational checks and inspections Understanding crusher capacities and limitations Personal protective equipment (PPE) requirements Emergency procedures: shutdown, lockout/tagout, and evacuation protocols 3. Crusher Operation Basics: Starting, stopping, and controlling the crusher, including emergency stops Familiarisation with crusher controls: power source, conveyor belts, feeders, etc. Monitoring and adjusting crusher settings for optimal performance Understanding crusher dynamics: feed size, speed, and throughput 4. Material Handling and Crushing Techniques: Proper assessment of materials: hardness, size, and moisture content Loading and feeding materials into the crusher safely and efficiently Adjusting crusher settings for different material types and sizes Maximising crusher efficiency and product quality 5. Site Safety and Hazard Awareness: Identifying potential hazards in the crusher area Working safely around moving parts, conveyor belts, and rotating equipment Recognising environmental hazards: dust, noise, and vibration Understanding site-specific safety rules and regulations 6. Maintenance and Inspections: Importance of regular maintenance for crusher performance and reliability Daily, pre-shift, and post-shift inspection procedures Lubrication points and maintenance schedules Identifying and reporting mechanical issues and wear parts replacement 7. Practical Hands-On Crusher Training: Moving the crusher in reverse and forwards through obstructions Loading and feeding materials into the crusher using excavator and loading shovels Adjusting crusher settings and monitoring performance for efficiency Emergency response drills: simulated scenarios to test response and decision-making skills 8. Assessment and Certification: Written examination to assess theoretical knowledge Practical assessment of crusher operation skills Certification upon successful completion of the course Conclusion: A crusher training course equips participants with the essential knowledge, skills, and confidence to operate crushers safely and efficiently in various work environments. By covering topics such as safety procedures, operation techniques, material handling, site safety awareness, best maintenance practices, and practical hands-on training, participants can enhance their proficiency and contribute to a safer and more productive workplace. Whether you’re a novice operator or an experienced professional, investing in crusher training with Vally Plant Training is essential for ensuring compliance, reducing risks, and maximising productivity in crushing operations. Frequently Asked Questions About Crusher Training What is Crusher Training, and why is it necessary? Crusher Training provides individuals with the skills and knowledge required to safely and effectively operate crushers, heavy machinery used in mining, construction, and recycling industries. It’s essential for ensuring operator safety, maximising productivity, and preventing accidents on job sites. Who should undergo Crusher Training? Crusher Training is essential for anyone involved in operating or working around crushers, including quarry workers, machine operators, maintenance personnel, and site supervisors. Proper training ensures that individuals understand equipment operation procedures and safety protocols. What topics are covered in Crusher Training programs? Crusher Training programs cover a range of topics, as above, including equipment familiarisation, safety precautions, preventive maintenance, operational techniques, troubleshooting, and emergency procedures. Participants learn how to operate crushers efficiently while prioritising safety and minimising risks. How long does Crusher Training take? The duration of Crusher Training programs varies depending on factors such as the complexity of the equipment and the depth of the curriculum. Basic training courses may last a couple of days, while more comprehensive programs could extend over 1 week to cover advanced concepts and practical applications. Is Crusher Training mandatory in certain industries? While Crusher Training may not be legally mandated in all areas, many employers in the mining, construction, and recycling industries require operators to undergo training as part of their occupational health and safety policies. Compliance with training requirements helps prevent accidents and ensures regulatory compliance along with productivity. Where can I find reputable Crusher Training courses? Reputable Crusher Training courses are offered by various institutions, including industry associations, equipment manufacturers, and specialised training providers like Vally Plant Training. It’s important to choose a program that offers accredited certification and covers relevant industry standards and best practices. Crusher Courses Available 7 days a week to suit your business requirements. VPT have a team of friendly and approachable Crusher instructors, who have a wealth of knowledge of crushers and the construction industry We have our own training centre conveniently located close to the M5 junction 9, In Tewkesbury. With its own purpose-built practical training area to simulate an actual working environment, however, Crusher Training can only be conducted on your sites Our Crusher course and test packages are priced to be competitive. Discounts are available for multiple bookings We can send a fully qualified NPORS Crusher Tester to your site nationwide, to reduce the amount of time away from work and complete the crusher test Our more courses: Polish your abilities with our dedicated Lift Supervision Training, Slinger Signaller Training, Telehandler Training, Cat & Genny Training, Plant Loader Securer, Ride-On Road Roller, Abrasive Wheel Training, Lorry Loader Training and Scissor Lift Training sessions. Learn the safe and effective operation of these vital machines, crucial for construction and maintenance tasks. Elevate your skills and career prospects by enrolling in our comprehensive courses today.

MS PowerPoint is really easy, but in this PowerPoint Training Courses, we cover most aspects in a fast-paced day, and attend the to more tricky aspects. This course is one-to-one to attend to specific aspects per delegate. Group training could be organised on request.

This course aims to provide a more in depth understanding of confidentiality and record keeping. Providing information on the importance of accurate and true record keeping.