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 5 Days 30 CPD hours This course is intended for This course is intended for: Network administrators Network engineers with little or no programming or Python experience Network managers Systems engineers Overview After taking this course, you should be able to: Create a Python script Describe data types commonly used in Python coding Describe Python strings and their use cases Describe Python loops, conditionals, operators, and their purposes and use cases Describe Python classes, methods, functions, namespaces, and scopes Describe the options for Python data manipulation and storage Describe Python modules and packages, their uses, and their benefits Explain how to manipulate user input in Python Describe error and exception management in Python Describe Python code debugging methods The Programming for Network Engineers (PRNE) v2.0 course is designed to equip you with fundamental skills in Python programming. Through a combination of lectures and lab experience in simulated network environments, you will learn to use Python basics to create useful and practical scripts with Netmiko to retrieve data and configure network devices. Upon completion of this course, you should have a basic understanding of Python, including the knowledge to create, apply, and troubleshoot simple network automation scripts. Course outline Introducing Programmability and Python for Network Engineers Scripting with Python Examining Python Data Types Manipulating Strings Describing Conditionals, Loops, and Operators Exploring Classes, Methods, Functions, Namespaces, and Scopes Exploring Data Storage Options Exploring Python Modules and Packages Gathering and Validating User Input Analyzing Exceptions and Error Management Examining Debugging Methods Course Summary Lab outline Execute Your First Python Program Use the Python Interactive Shell Explore Foundation Python Data Types Explore Complex Python Data Types Use Standard String Operations Use Basic Pattern Matching Reformat MAC Addresses Use the if-else Construct Use for Loops Use while Loops Create and Use Functions Create and Use Classes Use the Python main() Construct Traverse the File Structure Read Data in Comma-Separated Values (CSV) Format Read, Store, and Retrieve Data in XML Format Read, Store, and Retrieve Date in JavaScript Object Notation (JSON) Format Read, Store, and Retrieve Data in a Raw or Unstructured Format Import Modules from the Python Standard Library Import External Libraries Create a Python Module Prompt the User for Input Use Command-Line Arguments Manage Exceptions with the try-except Structure Manage Exceptions with the try-except-finally Structure Use Assertions Use Simple Debugging Methods Use the Python Debugger Code a Practical Debugging Script
Duration 2 Days 12 CPD hours This course is intended for This course benefits individuals responsible for configuring and monitoring devices running the Junos OS. Overview Describe the history and rationale for MPLS, as well as its basic terminology. Explain the MPLS label operations (push, pop, swap) and the concept of label-switched path (LSP). Describe the configuration and verification of MPLS forwarding. Describe the functionalities and operation of RSVP and LDP. Configure and verify RSVP-signaled and LDP-signaled LSPs. Select and configure the appropriate label distribution protocol for a given set of requirements. Describe the default Junos OS MPLS traffic engineering behavior. Explain the Interior Gateway Protocol (IGP) extensions used to build the Traffic Engineering Database (TED). Describe the Constrained Shortest Path First (CSPF) algorithm, its uses, and its path selection process. Describe administrative groups and how they can be used to influence path selection. Describe the default traffic protection behavior of RSVP-signaled LSPs. Explain the use of primary and secondary LSPs. Describe the operation and configuration of fast reroute. Describe the operation and configuration of link and node protection. Describe the operation and configuration of LDP loop-free alternate. Describe the LSP optimization options. Explain LSP priority and preemption. Describe the behavior of fate sharing. Describe how SRLG changes the CSPF algorithm when computing the path of a secondary LSP. Explain how extended admin groups can be used to influence path selection. Explain the purpose of several miscellaneous MPLS features. This two-day course is designed to provide students with a solid foundation on Multiprotocol Label Switching (MPLS). Course Outline Course Introduction MPLS Fundamentals MPLS Foundation Terminology MPLS Configuration MPLS Packet Forwarding Label Distribution Protocols Label Distribution Protocols RSVP LDP Routing Table Integration Mapping Next-Hops to LSPs Route Resolution Example Route Resolution Summary IGP Passive Versus Next-Hop Self for BGP Destinations Constrained Shortest Path First RSVP Behavior Without CSPF CSPF Algorithm CSPF Tie Breaking Administrative Groups Inter-area Traffic Engineered LSPs Traffic Protection and LSP Optimization Default Traffic Protection Behavior Primary and Secondary LSPs Fast Reroute RSVP Link Protection LDP LFA and Link Protection LSP Optimization Fate Sharing Junos OS Fate Sharing SRLG Extended Admin Groups Miscellaneous MPLS Features Forwarding Adjacencies Policy Control over LSP Selection LSP Metrics Automatic Bandwidth Container LSPs TTL Handling Explicit Null Configuration MPLS Pings
Course Overview The Hospitality Management Level 5 course offers a comprehensive insight into the dynamic and fast-paced world of hospitality. Designed to build a strong foundation in management practices, service excellence, and operational efficiency, the course equips learners with the knowledge and leadership skills required for success in the industry. Covering critical areas such as front office operations, food and beverage management, customer satisfaction, and marketing in travel and tourism, it ensures a well-rounded understanding of hospitality business functions. The curriculum also embraces modern developments such as e-hospitality and the use of technology in operations. Upon completion, learners will have developed key competencies in managing service quality, human resources, and financial aspects of hospitality enterprises. This qualification is ideal for those seeking career progression or wishing to enter this vibrant sector, offering valuable insights into creating memorable guest experiences and efficient business practices within hotels, resorts, and related hospitality organisations. Course Description The Hospitality Management Level 5 course delves deeper into the essential principles, operational challenges, and strategic approaches within the hospitality sector. Learners will explore the structure and evolution of the hotel industry, the importance of efficient recruitment and training processes, and the management of core areas including front office, housekeeping, food and beverage, and security operations. In addition, the programme highlights the significance of customer satisfaction, quality service delivery, marketing strategies, and financial management within hospitality environments. Contemporary topics such as e-hospitality and technology adoption are also integrated to reflect current industry trends. Throughout the course, participants will gain valuable knowledge, analytical capabilities, and management techniques that are crucial for sustaining high service standards and fostering business growth. The course structure is designed to cater to a wide range of learners, providing the flexibility to support both career advancement and entry into this dynamic field. Course Modules Module 01: Introduction to Hospitality Management Module 02: An Overview of Hotel Industry Module 03: The Process of Selection and Recruitment in Hospitality Industry Module 04: The Process of Development and Training in Hospitality Industry Module 05: Management of Front Office Operations Module 06: Management of Housekeeping, Engineering and Security Operations Module 07: Management of Food and Beverage Operations Module 08: Management of Service Quality in Hospitality Industry Module 09: Marketing in Travel and Tourism Business Module 10: Accounting in Hospitality Industry Module 11: Customer Satisfaction Module 12: E-Hospitality and Technology (See full curriculum) Who is this course for? Individuals seeking to start a career in hospitality management. Professionals aiming to enhance their expertise in hospitality leadership and operations. Beginners with an interest in the hospitality and tourism industries. Entrepreneurs planning to launch or manage hospitality ventures. Employees wishing to transition into supervisory or management roles within hospitality. Career Path Hotel Manager Front Office Manager Food and Beverage Manager Guest Relations Manager Hospitality Operations Manager Housekeeping Manager Resort Manager Travel and Tourism Consultant Event Coordinator within Hospitality Industry Hospitality and Tourism Marketing Executive
The Facilities Management and Maintenance Mini Bundle brings together the must-haves of smooth workplace management. You’ll get content in Logistics and Transportation, Supply Chain Management, Operations Management, GDPR, and HR—designed to help you keep teams running, goods moving, and data on the right side of legal. It’s ideal for those quietly holding things together behind the scenes. Whether you’re supervising an office move, managing stock, or handling HR emails at 9:01am on a Monday, this bundle gives you the know-how to keep things ticking. The Facilities Management and Maintenance Mini Bundle is for people who make things happen—often with no one noticing. Learning Outcomes: Manage transport and supply processes across different settings. Understand the basics of workplace operations and systems. Learn supply chain flow from order to delivery. Apply GDPR rules in administrative and digital settings. Handle workplace HR tasks and key policy areas. Support facility efficiency with structured planning methods. Who is this Course For: Facilities assistants managing logistics and internal resources. Admin staff working across HR and operations teams. Procurement or supply support workers needing extra clarity. Workplace managers organising stock, teams, or space. Office coordinators managing staff records and purchases. Staff handling GDPR-sensitive admin in workplace settings. Team leaders juggling resources, forms, and schedules. Anyone keeping office chaos (mostly) under control. Career Path: Facilities Administrator – £27,000/year HR Support Officer – £26,500/year Operations Team Assistant – £28,000/year GDPR/Data Admin Support – £25,000/year Supply Chain Coordinator – £29,000/year Workplace Logistics Assistant – £26,500/year
The Facilities Management in the Workplace Mini Bundle is a tidy solution for those managing the moving parts of a busy operation. With training in Logistics and Transportation, Supply Chain Management, Operations Management, Purchasing and Procurement, and Quantity Surveying, it delivers core knowledge for running things behind the scenes—efficiently, and without spreadsheets attacking you in your sleep. Whether you’re already in a support role or eyeing a future one, this bundle helps you grasp how things flow, get bought, stored, moved, and monitored. The Facilities Management in the Workplace Mini Bundle won’t turn you into a wizard overnight, but it will help you get through Monday with fewer surprises. Learning Outcomes: Understand logistics processes in business and workplace settings. Learn how supply chains operate from order to delivery. Apply operational thinking to improve organisational efficiency. Recognise basic principles in purchasing and procurement roles. Understand how quantity surveying fits into project control. Improve awareness of coordination within operational functions. Who is this Course For: Staff working in operations and logistics departments. Professionals overseeing supply or procurement chains. Admins supporting facility or workplace operations. Purchasing teams looking to improve internal processes. Quantity surveying assistants in need of foundational theory. Workplace coordinators juggling resources and delivery planning. New hires in warehouse, facility, or logistics settings. Anyone who’s ever muttered “where did it all go?” Career Path: Facilities Coordinator – £28,000/year Logistics Administrator – £27,500/year Procurement Assistant – £26,500/year Supply Chain Analyst (Junior) – £29,000/year Quantity Surveyor Assistant – £30,000/year Operations Assistant – £26,000/year
Companies want efficiency, compliance, and quality—and they want it yesterday. The Quality Assurance Mini Bundle equips you with key skills employers can’t ignore. Whether it’s quality assurance, quantity surveying, lean manufacturing, business law, or GDPR, this combination is tailor-made for operational and compliance roles across manufacturing, logistics, and business sectors. Quality assurance roles are expanding across industries, especially when bundled with knowledge of quantity surveying, lean manufacturing, business law, and GDPR. These keywords aren’t just buzz—they’re job-winners. Get the bundle before the next hiring wave hits. Description Imagine applying for a role in operations or compliance and being the only candidate with experience in quality assurance, quantity surveying, lean manufacturing, business law, and GDPR. This is what employers crave: a candidate who can optimise production, ensure compliance, handle legal frameworks, and reduce waste—all at once. Quality assurance is a high-priority area in manufacturing and tech, and when paired with quantity surveying, your profile enters project and cost control territory. Lean manufacturing? You’re now process-efficient. Add business law and GDPR, and your value multiplies—you’re not just a cog in the machine; you understand the entire engine. This isn’t just a mini bundle—it’s a value-packed career catalyst. If quality assurance and quantity surveying are the foundations, then lean manufacturing, business law, and GDPR are the walls and roof. The job market loves professionals who can offer full-package insights. And you? You’ll have that on paper. Miss this and risk falling behind the competition. Your future employer could be reading this too—so beat them to it. FAQ Q: Is this bundle only for manufacturing roles? A: Not at all. While lean manufacturing and quality assurance are central, the addition of quantity surveying, business law, and GDPR makes it ideal for finance, logistics, and operations too. Q: Can I apply for compliance roles? A: Definitely. GDPR and business law make you particularly attractive to companies needing regulatory support. Q: What’s the benefit of mixing quantity surveying and lean manufacturing? A: It shows you're cost-conscious and process-driven—two highly valued traits in operations and project roles. Q: Is GDPR really still a big deal? A: Yes—and growing. Data privacy laws make GDPR understanding critical for anyone in a compliance, QA, or administrative role. Q: Why choose this bundle over others? A: Because this one combines five high-impact fields—quality assurance, quantity surveying, lean manufacturing, business law, and GDPR—that cover both operations and legal responsibilities in a single purchase.
ð Unlock Your Potential with the Security Officer Course! ð Are you ready to step into the world of security with confidence and authority? Look no further than our comprehensive Security Officer Course! ð In today's unpredictable world, the need for vigilant and well-trained security officers has never been greater. Whether you're considering a career change or seeking to enhance your existing skills, this course equips you with the knowledge and expertise needed to succeed in the dynamic field of security. ð¼ Why Choose Our Security Officer Course? â Comprehensive Training: Our course covers a wide range of essential topics, from threat assessment and crisis management to security protocols and emergency response strategies. â Expert Instructors: Learn from industry experts with years of experience in security operations, law enforcement, and risk management. Gain insights and practical tips that you won't find in textbooks. â Hands-On Experience: Put your knowledge into action through immersive simulations and practical exercises. Develop the confidence to handle real-world security challenges effectively. â Flexible Learning Options: Whether you prefer to study online at your own pace or participate in interactive classroom sessions, our course offers flexible learning options to suit your schedule and preferences. â Industry Recognition: Our Security Officer Course is recognized and respected by employers across various sectors, giving you a competitive edge in the job market. Who is this for? ð®âï¸ Aspiring Security Professionals: If you're passionate about maintaining safety and security in your community, this course provides the perfect foundation for launching your career in security. ð©âð¼ Career Changers: Whether you're transitioning from a different field or seeking new opportunities, our course equips you with the skills and certifications needed to pursue a rewarding career as a security officer. ð¨âð©âð§âð¦ Community Leaders: Individuals who want to make a positive impact by enhancing security measures within their neighborhoods or organizations will find this course invaluable. Career Path Upon completing our Security Officer Course, you'll be well-prepared to embark on a fulfilling career in security. Here are just a few of the exciting career paths that await you: ð¡ï¸ Security Officer: From corporate offices and retail establishments to educational institutions and government facilities, security officers play a vital role in safeguarding people and property. ð Loss Prevention Specialist: Help businesses minimize losses due to theft, fraud, and other security breaches by implementing effective loss prevention strategies and surveillance techniques. ð¨ Emergency Response Coordinator: Coordinate emergency response efforts and ensure swift and effective action in crisis situations, such as natural disasters, accidents, or security threats. ðµï¸ Private Investigator: Conduct investigations, gather evidence, and uncover valuable insights to support legal proceedings or corporate security initiatives. With the demand for skilled security professionals on the rise, there's never been a better time to invest in your future with our Security Officer Course! Don't wait-enroll today and take the first step toward a rewarding career in security. ð Remember, safety and security are not just professions-they're commitments to protecting what matters most. Join us in making a difference and becoming a trusted guardian in your community! ð Course Curriculum Chapter 01 Introduction to Security Management Chapter 01 Introduction to Security Management 00:00 Chapter 02 Security Risk Analysis and Risk Reduction Chapter 02 Security Risk Analysis and Risk Reduction 00:00 Chapter 03 Managing Security Chapter 03 Managing Security 00:00 Chapter 04 Physical Security Management Chapter 04 Physical Security Management 00:00 Chapter 05 Information Security Management Chapter 05 Information Security Management 00:00 Chapter 06 Cybersecurity Chapter 06 Cybersecurity 00:00 Chapter 07 Organisational Security Management Chapter 07 Organisational Security Management 00:00 Chapter 08 Home Security Management Chapter 08 Home Security Management 00:00
Ready to organise, lead, and support teams? The Project Support Officer: 8-in-1 Premium Online Courses Bundle prepares you for high-functioning admin, management, and operations roles. 📋💼 🧾 Description Including essentials like project management, Lean Six Sigma, team leadership, people management, and documents control, this course prepares you for work in corporate offices, project teams, consultancies, and HR departments. 📌 Career outcomes: Project Support Officer Admin Manager Business Analyst Assistant HR Officer Operations Coordinator 📈 The demand is real. Now’s your moment. ⭐ Compete High has 4.8 on 'Reviews.io' and 4.3 on Trustpilot ❓ FAQ Q: What industries hire project support staff? A: Practically all—from tech and finance to HR and logistics. Q: Does this suit beginners? A: Yes! The bundle covers both foundational and advanced support tools.
Overview This comprehensive course on Logistics Management Training: From Beginner to Advanced will deepen your understanding on this topic. After successful completion of this course you can acquire the required skills in this sector. This Logistics Management Training: From Beginner to Advanced comes with accredited certification from CPD, which will enhance your CV and make you worthy in the job market. So enrol in this course today to fast-track your career ladder. How will I get my certificate? You may have to take a quiz or a written test online during or after the course. After successfully completing the course, you will be eligible for the certificate. Who is This course for? There is no experience or previous qualifications required for enrolment on this Logistics Management Training: From Beginner to Advanced. It is available to all students, of all academic backgrounds. Requirements Our Logistics Management Training: From Beginner to Advanced is fully compatible with PC's, Mac's, Laptop, Tablet and Smartphone devices. This course has been designed to be fully compatible with tablets and smartphones so you can access your course on Wi-Fi, 3G or 4G. There is no time limit for completing this course, it can be studied in your own time at your own pace. Career Path Learning this new skill will help you to advance in your career. It will diversify your job options and help you develop new techniques to keep up with the fast-changing world. This skillset will help you to- Open doors of opportunities Increase your adaptability Keep you relevant Boost confidence And much more! Course Curriculum 17 sections • 75 lectures • 10:48:00 total length •Value Chain Model: 00:06:00 •Logistics Function In An Organisation: 00:09:00 •Logistics and Logistics Functions: 00:09:00 •General Information In Logistics: 00:12:00 •Logistics Functions Explanation: 00:09:00 •Logistic Functions Explanation Continues: 00:09:00 •General Introduction Of Logistics: 00:13:00 •How Logistics Can Be Applied To Business: 00:03:00 •Business EXCELLENCE Through Logistics Management: 00:08:00 •Role Of Outsourcing: 00:07:00 •Logistics Management For Business Excellence: 00:10:00 •Understanding Transportation Strategy: 00:12:00 •Objectives of Transportation: 00:02:00 •Transportation Functionality: 00:07:00 •Factors Influencing Transportation Cos: 00:11:00 •Containerization and Its Role: 00:06:00 •Understanding Role Of Inventory: 00:09:00 •Inventory Functions: 00:05:00 •Cost of Inventory: 00:06:00 •Other Types Of Inventory: 00:11:00 •Basics Of Inventory Management: 00:12:00 •Basics Of Inventory Management Continues: 00:08:00 •KANBAN: 00:02:00 •Inventory Policy Guidelines: 00:05:00 •Warehouse Management Introduction: 00:04:00 •Warehouse And Its Design: 00:05:00 •Warehouse And Its Design Continues: 00:08:00 •Warehouse Operating Principle: 00:05:00 •Strategic Decisions In Warehousing: 00:10:00 •Warehousing Strategies: 00:09:00 •Warehousing Performance Measures: 00:11:00 •Logistics Information System Introduction: 00:04:00 •Need For Logistics Information System: 00:03:00 •Information Functionality: 00:04:00 •Evaluating Logistics Information System: 00:06:00 •Application of Logistics Information System: 00:10:00 •Designing of Logistics Information System: 00:08:00 •Designing of Logistics Information System Continues: 00:07:00 •Benefits of Logistics Outsourcing: 00:18:00 •Types of Logistics Providers: 00:07:00 •Outsourcing Value Proposition: 00:07:00 •Outsourcing Management Selection Criteria: 00:07:00 •Contract Terms and Conditions: 00:04:00 •Material Handling Part 1: 00:07:00 •Material Handling Part 1 Continued: 00:08:00 •Material Handling Part 2: 00:09:00 •Material Handling Part 2 Continued: 00:05:00 •Material Storage Principles: 00:03:00 •Material Storage Methods: 00:10:00 •Material Storage System Unit Load Storage: 00:11:00 •Design of Storage system: 00:09:00 •Storage System Design Continued: 00:05:00 •Scope and Objectives Of Reverse Logistics: 00:15:00 •Design Considerations: 00:13:00 •Automatic Identification Technology: 00:15:00 •EDI standards Application and Benefits: 00:04:00 •Automated Material Handling System: 00:14:00 •Satellite Tracking ERPDRP and AITS: 00:15:00 •Objectives of E-commerce: 00:05:00 •Classes of E-commerce Applications: 00:10:00 •E-logistics In E-commerce: 00:11:00 •E-Logistics Structure and Operations: 00:04:00 •Logistics Performance Measures and Controls: 00:08:00 •Logistics Performance Measures and Controls Continued: 00:14:00 •Characteristics Of A Successful Logistical Organization: 00:14:00 •Evolution Of Logistics And Organization: 00:06:00 •Learning Approaches To Logistical Organization: 00:11:00 •Drivers Of Logistical Organization: 00:09:00 •Drivers Of Logistical Organization Continued: 00:09:00 •Scope and Scale of Global Logi: 00:10:00 •Operational Factors and Challenges in Global Logistics: 00:16:00 •CrossBorder Goods Movement: 00:12:00 •Logistics Competitive Framework: 00:16:00 •Logistics strategies Across The Product Life Cycle: 00:17:00 •Conclusion: 00:05:00