Duration 1 Days 6 CPD hours This course is intended for This course is for employees of Sun Life who want to learn how to use HUE when working with SQL databases. Overview Upon successful completion of this course, students will be able to operate HUE when interacting with SQL databases. In this course, students will learn how to operate HUE when interacting with SQL databases. Executing a Simple Query Connect to the SQL Database Query a Database Save a Query Modify and Execute a Saved Query Performing a Conditional Search Search Using One or More Conditions Search for a Range of Values and NULL Values Search Data Based on Patterns Working with Functions Perform Date Calculations Calculate Data Using Aggregate Functions Manipulate String Values Organizing Data Sort Data Rank Data Group Data Filter Grouped Data Summarize Grouped Data Use PIVOT and UNPIVOT Operators Retrieving Data from Multiple Tables Combine the Results of Two Queries Compare the Results of Two Queries Retrieve Data by Joining Tables Exporting Query Results Generate a Text File Generate an XML File Additional course details: Nexus Humans SQL Querying Fundamentals with HUE - Part 1 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 SQL Querying Fundamentals with HUE - Part 1 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 2 Days 12 CPD hours This course is intended for Applications consultants Overview This course will prepare you to: Explain the architecture of the SAP S/4HANA Financials component Configure and use new functionalities in SAP S/4HANA Use the standard SAP Fiori applications designed for SAP S/4HANA Explain the SAP Central Finance deployment option of SAP S/4HANA Finance The course provides an overview of the Financial Accounting capabilities that are new or different in SAP S/4 HANA compared to SAP ERP. Course Outline Introduction to SAP HANA and S4/HANA Overview of Financials for SAP S/4HANA Analysis of the new Architecture of Accounting Overview of SAP Fiori Short overview of the process of Financials Migration to SAP S/4HANA Configuration and use new functionalities in General Ledger Accounting Use the Accruals Management Use the app 'Monitor GR/IR Account Reconciliation' Use new functionalities in Asset Accounting Analysis of the Reporting Options for SAP S/4HANA Define a Financial Statement Version using the Global Accounting Hierarchy Overview of the Basic Cash Management in SAP S/4HANA Additional course details: Nexus Humans Financial Accounting in SAP S/4HANA for SAP ERP FI Professionals 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 Financial Accounting in SAP S/4HANA for SAP ERP FI Professionals 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.
This is a quickstart Adobe Express Training course held online in Janury 2025. Ideal for business owners or freelancers looking to get to grips with social media design and designing for social media marketing.
This one-day workshop is designed to give participants an understanding of the fundamentals of Microsoft Word and its commands, with quick ways to enter text, control formatting and edit paragraphs. This course will help participants: Create, manage and save documents, files and folders Create paragraph lists, bulleted and numbered paragraphs Edit, modify and format paragraphs Create and format tables Use shortcuts to navigate documents Format the layout of documents Manage page headers and footers Insert and managing pictures and diagrams within a document Learn time saving tips and tricks to obtain a professional finish to documents Use printing options 1 Creating documents Getting help Creating and saving documents Accessing recently used documents Managing files and folders 2 Entering and editing text Inserting and editing paragraph text Cutting, copying and pasting text Using tool tips to manage content Applying and removing text formatting Correcting spelling and grammar 3 Creating paragraph lists Creating bulleted paragraphs Creating numbered paragraphs Managing bulleted and numbered lists 4 Modifying paragraphs Changing paragraph alignment Indenting a paragraph Adding borders and shading to paragraphs Formatting paragraphs using styles 5 Navigating documents Using shortcuts for navigating documents Using 'Go To' to navigate documents Finding and replacing text Changing to read view 6 Document layout Inserting page breaks Changing page orientation Adjusting page margins Adding borders to pages 7 Page headers and footers Inserting page headers and footers Using header and footer commands Inserting page numbers Using different first page 8 Inserting pictures and diagrams Inserting pictures from your computer Inserting online pictures Flowing text around a picture Changing a picture Inserting SmartArt diagrams Entering text into SmartArt 9 Inserting tables Using tabs to create tables Resizing and repositioning tables Inserting and deleting rows and columns Using a table's commands Changing a tables text direction Formatting tables 10 Printing documents Previewing and printing documents Using the printing tools Printing parts of a document
Duration 1 Days 6 CPD hours This course is intended for This course is intended for anyone who wants to develop a toolbox of personal stress management skills. Overview Upon successful completion of this course, students will be able to identify the best approach to handle a stressful situation; understand what lifestyle elements, routines and relaxation techniques can help reduce stress. In this course, students will apply a three-option method to address any stressful situation. Module One: Getting Started Workshop Objectives Pre-Assignment Pre-Test Action Plan Form Evaluation Form Module Two: Understanding Stress What is Stress? What is Eustress? Understanding the Triple ?A? Approach Practical Illustration Module Two Review Questions Module Three: Creating a Stress-Reducing Lifestyle Eating Properly Exercising Regularly Sleeping Well Practical Illustration Module Three Review Questions Module Four: Altering the Situation The First A Identifying Appropriate Situations Creating Effective Actions Practical Illustration Module Four Review Questions Module Five: Avoiding the Situation The Second A Identifying Appropriate Situations Creating Effective Actions Practical Illustration Module Five Review Questions Module Six: Accepting the Situation The Third A Identifying Appropriate Situations Creating Effective Actions Practical Illustration Module Six Review Questions Module Seven: Using Routines to Reduce Stress Planning Meals Organizing Chores Using a To-Do List Practical Illustration Module Seven: Review Questions Module Eight: Environmental Relaxation Techniques Finding a Sanctuary Using Music Seeing the Humor Practical Illustration Module Eight: Review Questions Module Nine: Physical Relaxation Techniques Soothing Stretches Deep Breathing Tensing and Relaxing1 Meditation1 Practical Illustration Module Nine: Review Questions Module Ten: Coping with Major Events Establishing a Support System Creating a Plan Knowing When to Seek Help Practical Illustration Module Ten: Review Questions Module Eleven: Our Challenge to You Creating a Stress Log Week One: Recording Events1 Week Two: Identifying Stressors and Creating a Plan1 Week Three: Creating New Habits Reviewing and Evaluating Practical Illustration Module Eleven: Review Questions Module Twelve: Wrapping Up Words from the Wise Lessons Learned
Duration 5 Days 30 CPD hours This course is intended for Administrators, implementers and managers who are responsible for implementing, configuring and administering Service Manager 9.30. Overview At the end of the course, you will be able to:? Describe Service Manager environment andarchitecture? Install the various components of Service Manager? Learn the various implementation options (i.e.default ports, load balancing, components)? Perform tasks and set-up activities that are generallyperformed prior to moving the system to Production.? Perform daily administrative tasks such asperforming backups and monitoring log files,background processor activity, email activity, andschedule record activity.? Perform weekly administrative tasks such asarchiving and purging data? Perform monthly administrative tasks such ascleaning up the audit record, monitoring serverperformance statistics? Perform quarterly and annual administrative taskssuch as regenerating the work and holiday schedulerecords.? Additional administrative tasks, such as importing orexporting records.RECOMMENDED This class is targeted at system administrators responsible for the day to day management of the Service Manager application. The course focuses on the daily, weekly, monthly, quarterly, and annual tasks required to keep the system running efficiently. This class is targeted at system administrators responsible for the day to day management of the Service Manager application. The course focuses on the daily, weekly, monthly, quarterly, and annual tasks required to keep the system running efficiently. Additional course details: Nexus Humans SM320 - Service Manager 9.x Administration 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 SM320 - Service Manager 9.x Administration 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 PostgreSQL is a powerful, open-source, object-relational database system known for being reliable, secure, and flexible. For administrators, learning PostgreSQL equips you with the skills needed to handle complex and high-performance databases in our data-driven world. Big-name companies like Apple, Cisco, Fujitsu, and IBM trust PostgreSQL for their critical applications, which highlights its significance and broad industry adoption. By getting the hang of PostgreSQL, administrators can boost their career opportunities and play a key role in the success of data-focused businesses. PostgreSQL Server Administration is a three-day hands-on course geared for administrators seeking to sharpen their skills and elevate their database management capabilities. Throughout the course you?ll explore a wide range of essential topics, from server architecture and user accounts to monitoring and routine maintenance. Throughout the course, you'll gain invaluable insights and practical techniques that will empower you to optimize, secure, and manage your PostgreSQL environment effectively. As you navigate through server configuration, database reporting, backup and restore procedures and more, you'll have the opportunity to apply your newfound knowledge to real-world scenarios. By the end of the course, you'll be equipped with the confidence and skillset required to tackle a wide array of administrative challenges and to effectively manage your PostgreSQL databases. Additional course details: Nexus Humans PostgreSQL Server Administration (TTDB7020) 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 PostgreSQL Server Administration (TTDB7020) 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 4 Days 24 CPD hours This course is intended for This course is recommended for:OperatorsDevelopersAdministrators Overview After completing this course, you should be able to:Run and manage automated workflows using HP Operations Orchestration (OO) 10.xPerform a wide range of system administration, monitoring, and management tasks using OO CentralAuthor, maintain, document, and package new automated workflows using the OO Studio applicationTest and debug the flows locally and remotelyWork with Looping and Iteration operationsApply parallel processing methods to your flows in HP Operations Orchestration (OO)Use responses, rules, and transitions to control flow runUse XML operations and XML filters for processing XML content in OOWork with JavaScript Object Notation (JSON) operationsUse the file system content in the OO libraryAdd email notifications to your flowsExecute scriptlet methods in OO to manage flow data and flow executionInstall, configure, and update OO This four-day course introduces students to the essential concepts and usage, as well as to more advanced features of the HP Operations Orchestration (OO) software. OO is part of HP Cloud Automation solutions. This four-day course introduces students to the essential concepts and usage, as well as to more advanced features of the HP Operations Orchestration (OO) software. OO is part of HP Cloud Automation solutions. Additional course details: Nexus Humans OO220 - Operations Orchestration 10.x Flow Development 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 OO220 - Operations Orchestration 10.x Flow Development 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 Customers: Administrators, developers, web developers, and managers who are managing the Asset Manager 9.x product- Channel Partners and HP C&I Personnel: Consultants, system architects, integrators, and planners who help customers with Asset Manager 9.x implementations- HP Engineers: HP personnel who provide pre-sales and post-sales support for Asset Manager 9.x Overview At the end of the course, you should be able to:? Describe an evolutionary approach to assetmanagement? Explain the capabilities provided by AssetManager's core modules? Use the clients to navigate within Asset Manager'score tables? Create a database? Create and manage portfolio items? Reconcile software installations with softwarelicenses? Write scripts to extend Asset Manager'sfunctionality? Create queries and views to filter data? Configure Asset Manager security and controldatabase access? Import and export data using Asset Manager? Schedule automatic processes This five-day instructor-led training course is designed to provide the essential skills and knowledge needed to configure, deploy, and use Asset Manager 9.40 to successfully implement an asset management solution. This five-day instructor-led training course is designed to provide the essential skills and knowledge needed to configure, deploy, and use Asset Manager 9.40 to successfully implement an asset management solution. Additional course details: Nexus Humans AM120 - Asset Manager 9.x Software - Essentials 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 AM120 - Asset Manager 9.x Software - Essentials 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 4 Days 24 CPD hours This course is intended for Storage and system administrators using HP Data Protector software, System Engineers, Consultants, Project Managers, Professional Services, and Sales. Overview Upon successful completion of this course, you should be able to:Install and distribute HP Data Protector software in your environmentConfigure the HP Data Protector software productConfigure your tape and disk-based backup solutions for use with HP Data Protector softwareUse HP Data Protector software to run backups and restores, and monitor these sessions from both the Data Protector GUI and command lineManage the HP Data Protector software Internal Database (IDB)Create custom reports and notification proceduresSecure your installation by configuring user access and adding security to the Cell Manager and DP client systemsPrepare your client to recover from a disaster situationUnderstand the Data Protector processes and perform basic troubleshooting of your installation The hands-on lab exercises reinforce the theory sessions to ensure a thorough understanding of backup and recovery concepts, the functionality of the software and its application to typical storage implementations. The hands-on lab exercises reinforce the theory sessions to ensure a thorough understanding of backup and recovery concepts, the functionality of the software and its application to typical storage implementations. Additional course details: Nexus Humans DP120 Data Protector 9.x Essentials 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 DP120 Data Protector 9.x Essentials 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.