43616 Courses

Public Speaking Courses That Work Our public speaking courses are refreshingly different and transformative. Mindful presenting is the key to the future of high impact public speaking training. In fact, we are changing organisations one presentation at a time. We do that by providing training that empowers and equips professionals to present with greater confidence, clarity and impact.

During this 3 hour workshop, you will learn why it is important to detach from work and every day life, which will improve the wellbeing of both your physical and mental health. Y ou will learn some easy and effective methods of relaxation, that can be incorporated into every day life. You will learn of the importance of sleep.  Understand that the workshop does not cover all methods of relaxation and methods to detach, and that not all methods of relaxation can be, or will be, suitable for all sufferers of work-related stress.  This workshop is aimed at the employed, volunteers and self-employed who want to learn simple ways to ‘switch off’ from work. Helping you to have a healthier relationship with yourself, your loved ones, your work and improved sleep.

Learn how to code with Python. Work on a small real-life project from conception to tested app, in a team or on your own.

Take your knowledge to the next level with EnergyEdge's course focusing on pipeline integrity management incorporating API 1160, 1173, and ASME B31.8S. Enroll now!

Duration 2 Days 12 CPD hours This course is intended for This course can be valuable for anyone who needs to write basic SQL or Transact-SQL queries. This includes anyone working with data as a data analyst, a data engineer, a data scientist, a database administrator or a database developer. It can also be useful for others peripherally involved with data, or wanting to learn more about working with data such as solution architects, students and technology managers. This course will teach the basics of Microsoft's dialect of the standard SQL language: Transact-SQL. Topics include both querying and modifying data in relational databases that are hosted in Microsoft SQL Server-based database systems, including: Microsoft SQL Server, Azure SQL Database and, Azure Synapse Analytics. 1 - Introduction to Transact-SQL Work with schemas Explore the structure of SQL statements Examine the SELECT statement Work with data types Handle NULLs 2 - Sort and filter results in T-SQL Sort your results Limit the sorted results Page results Remove duplicates Filter data with predicates 3 - Combine multiple tables with JOINs in T-SQL Understand joins concepts and syntax Use inner joins Use outer joins Use cross joins Use self joins 4 - Write Subqueries in T-SQL Understand subqueries Use scalar or multi-valued subqueries Use self-contained or correlated subqueries 5 - Use built-in functions and GROUP BY in Transact-SQL Categorize built-in functions Use scalar functions Use ranking and rowset functions Use aggregate functions Summarize data with GROUP BY Filter groups with HAVING 6 - Modify data with T-SQL Insert data Generate automatic values Update data Delete data Merge data based on multiple tables Additional course details: Nexus Humans DP-080T00 Querying Data with Microsoft Transact-SQL 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 DP-080T00 Querying Data with Microsoft Transact-SQL 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.

Develop your proficiency in hazardous waste management and logistics for upstream oil and gas with EnergyEdge's specialized course. Enroll now to advance your career.

Course Overview This comprehensive First Aid at Work course is designed to equip learners with the knowledge needed to effectively manage health-related emergencies in professional settings. Covering a wide range of workplace incidents, it explores the role of appointed persons, emergency protocols, and how to respond to common injuries and illnesses. Learners will develop confidence in managing both physical and mental health-related situations at work, including remote support and procedures adapted for the COVID-19 era. Whether you are an employee, manager, or business owner, this course provides essential guidance that aligns with UK regulations and first aid expectations in modern work environments. By the end of the course, learners will be familiar with key emergency response procedures and legal requirements, contributing to a safer and more responsible workplace culture. Course Description The First Aid at Work course offers in-depth learning across a structured series of modules that cover everything from primary and secondary assessments to CPR, AED usage, and mental health support. It examines various types of injuries and illnesses such as fractures, dislocations, breathing problems, and minor workplace injuries. The course also discusses the legal framework for first aid at work, risk assessments, and the importance of mental health awareness. Additionally, it addresses recent considerations such as pandemic-specific protocols and remote psychological support. Learners will gain theoretical insight into emergency handling, including when and how to contact emergency services. With up-to-date content aligned with UK standards, this course is ideal for those looking to support a health-conscious and safety-oriented work environment. Course Modules: Module 01: Introduction to Workplace First Aid Module 02: Appointed Persons in the Workplace First Aid Module 03: Incident Management at Work Module 04: Classifications and Abbreviations Module 05: Emergency Management Module 06: Primary Survey Module 07: Secondary Survey Module 08: Basic First-Aid Techniques Module 09: AED Module 10: Minor Injuries at Workplace Module 11: Loss of Responsiveness and CPR Module 12: Breathing Problems Module 13: Secondary Illnesses and Injuries Module 14: Fractures and Dislocations Module 15: Call for an Emergency Module 16: Things to Keep in Mind for A First Aider Module 17: Legal Framework for Workplace First Aid Module 18: Mental Health First Aid in the Workplace Module 19: First Aid during Coronavirus Pandemic Module 20: First Aid Qualifications During the Pandemic, Risk at Work and PPE Regulations Module 21: Remote Psychological First Aid (See full curriculum) Who is this course for? Individuals seeking to understand workplace first aid responsibilities. Professionals aiming to support health and safety compliance in the workplace. Beginners with an interest in health and safety protocols. Managers, HR personnel, or safety officers seeking foundational knowledge in first aid. Career Path Workplace Health & Safety Officer HR and Compliance Manager Office Administrator with Safety Responsibilities Site or Facility Supervisor Community Support Worker Mental Health Support Facilitator Risk Management and Corporate Safety Advisor

About this Training Course In the oil & gas industry, it is common knowledge that operators and main contractors, contract or sub-contract a wide range of their activities. The service contract is the tool used to share the risk of a service between the operator and contractor. It is also an approach adopted by the operator to control the efficiency of his contractor. This course allows all parties involved, company, contractors and subcontractors, to better understand the contractual relationship, their rights and obligations. It gives a detailed review of the contract and its main features. This course will particularly focus on the services contracts that are put in place to support a drilling campaign, covering all specificities of the various contracts. Training Objectives At the end of this course, participants will: Get a thorough understanding of the service contract clauses Be able to administer the contract and optimise the relationship with the company or contractor Target Audience This course will be useful and applicable for the following professionals: contract engineers, contracts administrators, any party involved in the relationship between the company and the contractors of a service contract Drillers and logisticians may also have interest in this course as it covers the contractual aspects of their operational activity: They are the 'Owners' of these services contracts Trainer Your expert course leader has 25 years of experience in management positions in Contracting, Procurement and Logistics, mainly in the Oil & Gas Industry. During his Oil & Gas industry experience, he has worked on major Oil and Gas development projects like the Yadana project in Myanmar, Akpo project in Nigeria and YLNG in Yemen. His international experience allows him to adapt very easily and integrate the multicultural specificities of the Oil & Gas industry in his teaching. POST TRAINING COACHING SUPPORT (OPTIONAL) To further optimise your learning experience from our courses, we also offer individualized 'One to One' coaching support for 2 hours post training. We can help improve your competence in your chosen area of interest, based on your learning needs and available hours. This is a great opportunity to improve your capability and confidence in a particular area of expertise. It will be delivered over a secure video conference call by one of our senior trainers. They will work with you to create a tailor-made coaching program that will help you achieve your goals faster. Request for further information post training support and fees applicable Accreditions And Affliations

Definitive Ethernet switching course description A hands on comprehensive look at Ethernet switches with extensive coverage of VLANs. The course focuses on the technology and not any one manufacturers product enabling delegates to configure switches from any manufacturer. What will you learn Configure and troubleshoot switches using: Console port telnet HTTP TFTP Configure and troubleshoot switch features such as: Duplex/speed Port based MAC security Spanning Tree Link aggregation Tagged ports Configure and troubleshoot VLANs. Definitive Ethernet switching course details Who will benefit: Technical staff. Prerequisites: Intro to data communications & networking. Duration 3 days Definitive Ethernet switching course contents What is Ethernet? LANs, network cards and cables, CSMA/CD, Ethernet frames, Ethernet evolution, 802.3. Hands on: ping, Ethernet speeds, CSMA/CD. Ethernet layer 2 Layer 2 functions, NICs, MAC addresses, unicasts, multicasts and broadcasts, frame formats. Hands on: Configuring NICs, Analysing MAC addresses with Wireshark IP and Ethernet Relationship Hands on: ARP. What is a switch? Switches connect multiple devices, switches versus hubs, simultaneous conversations, switches work at layer 2, the forwarding database, how the forwarding database is built, broadcast and collision domains Hands on: Difference between hubs and switches. Switch configuration Switch configuration Managed/unmanaged switches, configuration methods, reasons to configure switches. Console ports, HyperTerminal (and alternatives). Hands on: Using the console port to troubleshoot and configure switches. Switches in more detail Latency, forwarding mechanisms, switch fabrics. Hands on: Using telnet and HTTP to switches. Ethernet extensions Auto negotiation, Power over Ethernet. Hands on:Configuring and troubleshooting switch ports: Speed, duplex and security. Redundant links Loops, broadcast storms, STP, BPDU format, STP convergence. Hands on: Tracking blocked ports. STP convergence. Backbone links Architectures, link aggregation, LACP, load sharing, resilience. Hands on: fail over times. VLANs Virtual versus physical LANs, Why have VLANs? Broadcast domains, Creating VLANs, Assigning ports to VLANs. Hands on: Analysing the effect of VLANs on traffic. Enterprise VLANs VLANS are internal, multiple VLANs, Load balancing, Default VLAN, VLAN registration protocols: VTP, GVRP, MVRP. Hands on: VLANs on multiple switches. Tagging/Trunking Reason for tagging, terminology, tagging process, 802.1Q, Tag format, VLAN stacking. Hands on: Configuring and troubleshooting tags. STP variants RSTP, Common STP, Multiple STP, PVST, ring alternatives. Hands on: RSTP. Inter VLANs Layer 3 switching, IP addressing rules, Interconnecting VLANs. Hands on: Routing between VLANs. Troubleshooting Ethernet Methods, tools, locating faults, layer 1 issues, layer 2 issues Hands on: Fixing the network.

Online Marketing course for individuals, companies, professionals that want to succeed on the job and improve marketing skills.