4897 Courses delivered Live Online

Duration 3 Days 18 CPD hours In this 3 day customized Intermediate SQL course students will learn additional commands and functions using labs/activities/content that correlates with this content. By understanding SQL, you get the knowledge of fundamental queries associated with data management so that you can verify, monitor, and control all the activities operating in the database. Lesson 1 Substring Instr / CharIndex Convert (data types and with Formatting) Replace RowCount / RowNum / Top )n) ÿ(Oracle/SQL Server functions) Case / If Then Else statements Exists Clause Find Duplicates using Group by and have clause (and other tips for analyzing data) Lesson 2 Set operations (UNION, UNION ALL, INTERSECT, MINUS) GROUP BY extensions (ROLLUP, CUBE, and GROUPING SETS) Loops / Cursors Common Table Expressions (CTEs) Lesson 3 Temp Tables / Views Advanced Subqueries Regular Expressions (RegEx) Linked Server Queries Qualified subquery predicates Aggregate functions Optimizing queries SQL Injection Lesson 4 JSON Parsing With Partition By With Over Fuzzy Logic - MDS.mdq.[Similarity]ÿ Additional course details: Nexus Humans Intermediate SQL Custom 3-Day Private Class Outline 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 Intermediate SQL Custom 3-Day Private Class Outline 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 class is designed for email digital marketers who manage the email channel for their organization. Whether you are new to Marketing Cloud or looking for tips on how to improve your existing customer journeys, this class is a great place to start. No prior knowledge of Marketing Cloud is needed. Overview When you complete this course, you will be able to: Explain compliance concepts to ensure optimal deliverability. Use tools within Marketing Cloud to uphold deliverability standards. Utilize Email Design best practices to ensure the best customer experience. Develop effective, relevant messages using Content Builder. Design and test different delivery methods and options when sending an email message. Design and execute customer journeys using automation tools within Marketing Cloud. Differentiate the use cases for different automation activities in Automation Studio and Journey Builder. Define fundamental data management and structure terminology. Use data segmentation tools to create targeted emails. Apply a simple data model concept to a real-world scenario. Define subscriber statuses, unsubscribe methods, and preferences. Analyze marketing campaigns using common KPIs. Solve a common marketing problem using troubleshooting guidance. Prioritize testing methods and tools to ensure quality control. Explain fundamental account and sending administration. Know where to go for more information, guidance, and support. Describe capabilities across the platform. Start your journey to becoming a Marketing Cloud Specialist. In this 5-day, expert-led class, you will learn how to build customer journeys within Marketing Cloud. Our team of Marketing Cloud pros will walk you through best practices related to executing, monitoring, and analyzing your journeys, arming you with the tools and know-how to design personalized journeys and engage with your customers in a whole new way. Course Outline Introduction to Salesforce Marketing Cloud Administration Subscriber and Data Management Email Message Design and Creation Message Testing, Delivery, and Email Marketing Best Practices Marketing Automation Analytics and Troubleshooting Summary

PER (Practical Experience Requirements) or CPD Training Course for Accountancy Students: Overview It is a comprehensive practical accounting training program designed to build the bridge between knowledge and practical aspects of accounting and tax. With these accounting courses, many modules of tax and accounting are covered as well as Computerised Accounting & Payroll. Moreover, After completing the modules you will have the chance to get hands-on experience which will open the door for the lucrative Accounting, Tax & Payroll sector. Certificate of Attendance Advanced Excel Bookkeeping VAT Training - Preparation and Submission Personal Tax Return Company Accounting and Tax Training Sage 50 Accounting Training Content (Level 1) Sage Payroll Training Content(Level 1)

Duration 2 Days 12 CPD hours This course is intended for This course is designed for developers who want to learn about Git and GitHub. Overview Upon completion of this course, participants will be able to: ? Install and run Git ? Describe basic concepts of Git version control ? Work on multiple branches ? Optimize merging and fixing merge conflicts ? Create and manage GitHub repositories ? Collaborate using GitHub This hands-on course teaches participants how to integrate Git and GitHub into their daily command-line workflow. Git operations, customizations of Git functionality, and how to connect to Git via Eclipse are covered as well. Introduction Introduction to Version Control Systems The Birth of Git and Why Git? What is GitHub? GitHub Repository Concepts Getting Started With Git Installing and Running Git The Git command Line Configuration Files Creating your First Git Repository Staging Area Git Commit Viewing History Creating Aliases and Shortcuts Hands-on Lab Session Getting Started with GitHub Creating and Configuring a Repository in GitHub Uploading your Repository to GitHub Understand Repository?s Main Page Using the README Hands-on Lab Session File Management in Git Locally The Index File Classifications in Git Rename a File Delete a File Ignore Files using .gitignore File Hands-on Lab Session Collaboration on Pull Requests Cloning and Forking Repositories Creating a Pull Request Collaborating a Pull Request Merging on a Pull Request Working with Branches Hands-on Lab Session Integrating GitHub with Eclipse Introducing EGit Plugin Configuring GitHub in Eclipse Working with Eclipse Hands-on Lab Session Reviewing and Configuring a Project on GitHub Configuring a Repository Adding Collaborators Creating Organizations Managing Teams Introducing Issues Merging, Rebasing and Resolving Conflicts Merging Branches Git diff and Commit Ranges Working with Merge Conflicts Merge Strategies Introduction to Rebasing Rebasing Branches Reverting and Fixing Bad Commits Hands-on Lab Session Additional course details: Nexus Humans Learning Git and GitHub 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 Learning Git and GitHub 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.

Key Objectives for the Training provision Effective listening to a client's needs and requirements during various stages of the sales process. Engage in meaningful communication with clients, learn to identify challenges and opportunities that relate to the prospects. Overcome the identified challenge. Build long term rapport and establish trust with the prospect throughout the sales process, Ensure continued customer satisfaction that can turn into repeat business. Be able to build rapport with customers or clients. Know the right questions to ask to fully understand the customer or client’s needs without putting on any pressure. Be able to check you have the right information from the customer or client. Be able to match products and services to the customer or client using the information you have gathered. Be able to influence effectively. Know how to stand out from your competitors. Stage 1 – Research the Company’s ‘Value Propositions’ and USP Analysis  Conducting 30 min confidential interviews with a cross-section of the eligible Attendees & the Stakeholders, in order to gain an objective understanding of the various scenarios and clients that the Participants work with. the Company’s ‘Value Propositions’ Unique Selling Points The Customers’ journey(s) The Competition’s offers for analysis and comparisons. From these findings, a carefully calibrated bespoke Programme will be designed and delivered.  Stage 2 - Design the Bespoke 2 x day Course  nd Stage 3 - Delivery of the Course Programme This Programme can be delivered in 2 x consecutive days, or split between 2 – 3 weeks, to make it more ‘work-friendly’ – if required. It is very practical and commercially focussed in approach, with lots of interactive exercises designed to draw out the learning applications via the debriefings. The ‘Real Play’ scenarios on day 2 will be based on specific case studies drawn from the Research findings so that they are authentic to optimise the learning. Individual Action Plans will be captured at the end of each day to be debriefed by the Participants’ respective Line Managers.  Template Programme Day One – Foundation – Strategic Approach Section One – The Principles of Consultative Selling Defining ‘Consultative Selling’ The Company’s ‘Unique Selling Points’ & Value Proposition The Consultative Selling model – the five stages Avoiding appearing ‘pushy’, ‘pressurising’ or ‘talking through the sale’ Section Two –Strategy & Preparation  ‘Buy-Class’ Matrix Strategic plan Template – matching services/products to identified needs & opportunities. Preparing a range of objectives Constants and variables – USP’s Researching key Client/Decision Makers’ priorities, profile & background (LinkedIn etc.) Preparing for potential & likely Objections Section Three – Email etiquette & ‘influencing’ email correspondence.  Email etiquette A.B.S.U.R.D model Clarity and tone – discovery of clients’ needs & motivational factors. Techniques to influence and ‘nudge’. Ensuring the data and content have a ‘gentle’ motivational & appealing message. Top Tips Day Two – Practical Application Section Four – Rapport Building & Effective Communication skills ‘Behaviour Labelling’ techniques – setting a positive tone. Asking Open Questions – gaining a full understanding of the clients’ priorities & expectations. EQ - Inviting opinions; perspectives; experiences – winning confidence. Active Listening – focus and commitment to understand. ‘Reading the room’ – adapting to responses and reactions. Maintaining focus on relevant topics that the Client cares about; carefully consider the opportunities to influence. But NO PRESSURE! Building a ‘bond of trust’ with commitments and authentic, shared values. Section Five – Explaining the Benefits – aligned to the Customers’ Priorities Understanding ‘Why do People Buy?’ Research data analysis. Open questions that lead to understanding the key issues and Clients’ priorities. Avoiding the danger of ‘pressurising’ the Client. Responding to objections effectively, with confidence and sensitivity. Explaining the benefits that are aligned to the Clients’ stated requirements. Making the Data ‘sing’ – memorable takeaways for the Client. Augmented benefits – Brand confidence; Case studies; Warranty; Service; Range; Flexibility etc. in alignment with their stated preferences/requirements Differentials compared to Competitors Section Six – Winning Commitment Inviting commitment – with confidence Consultative Selling Closing techniques (e.g. Alternative Close/Assumptive Close et al) Avoiding ‘talking through the sale’ – knowing when to ‘Shut UP!’ Confirming agreement – ensuring Clients’ motivation for repeat business Section Seven – Practical Application ‘Real Play’ From the Research findings, carefully devised scenarios can be generated to provide the most valuable learning opportunities to underpin all the skills & techniques covered in the Programme.  Potential Real Play scenarios: A well-established customer has indicated that they are soon to be opening up additional new offices – this presents an opportunity to arrange for the Company to support them with their upcoming needs. After some very positive feedback and with the upcoming contract renewal imminent – how can the Company give the Customer more high-quality support in other areas of their business? A Competitor has been to see the client and they have prompted some concerns about ‘value for money’ & ‘quality of service’. How Real Play works… The group is split the group into 2 sub-groups, one with our Professional Actor (option available); the other with the Trainer or a willing Participant. Each group has a brief and has to instruct their Trainer/Actor/Participant on how to approach the scenario supplied. The Actor and Trainer (or willing Participant) perform the role play(s) as instructed by their respective teams; however, during the action they can be paused for further recommendations or direction. The outcome is the responsibility of the team(s) – not the performers. Debrief the full Programme Individual Action Plans - to be followed through. ‘Best Practices’ for application into the business Options for Exercises within the Programme  Sample Exercise – Red & White  There is a specific time managed agenda and itinerary, which puts the group under pressure.  The key challenge is for the sub-groups to maximise the commercial value from the task, however there is always a great danger that the individuals attempt to gain financial progress at the expense of the other group! Debriefing points: Persuasive communication and influence across barriers Gaining buy-in when others are sceptical Strategic planning accounting for others’ behaviours Sample Exercise – Communication Challenge Each Participant has different pieces of information, but are not allowed to share it visually. They are only allowed to communicate to work out the solution hidden among the large amount of data. Debrief: Structured approach Maintaining focus through distractions/interference Active Listening Controlled communication Sample Exercise – Persuasive emails Sample emails are shared to be critiqued and improved upon to be debriefed: Tone & impact Making the Data ‘sing’ Influential & motivational language Customer centric message. Sample Exercise –Juggling   Each Participant has to pass the ‘Customers’ (Juggling balls) carefully through the system with all the other Participants to reach a profitable conclusion  Debrief: EQ to read the room and effectively communicate, when the pressure is on Customer focus and adapting to challenges Devising a plan that wins buy-in Overcoming competing ideas to get to ‘best practice’ Consistent commitment, communication and motivational drivers that influenced performance. Sample Exercise –Critical Path  The group are provided with 30 x discs and some ‘post-it’ notes. (no pens or pencils are allowed) Their brief is to create a grid shape with the 30 x discs, which will act as ‘stepping stones’ for the ‘Critical Path’ But they have to follow the correct order through the grid from the start to finish, which they will have to work out through ‘trial & error’ All of the team must pass through the ‘Critical Path’ worked out on the grid, observing the constraints, within the time limit. No talking is permitted once they start using the materials Debrief: - Clear communication focussing on the ‘client’s journey’ Planning for challenges Identifying risks and mitigating them Role allocations & support Quality control and disciplines  Sample Exercise –Back to Back  Each Participant is positioned back-to-back with a partner. They have to work out precisely what the ‘statement’ given to the other person is without looking around. Each person has a different brief. Debrief: - Asking Open Questions Active Listening Accuracy in identifying the objective.

Company Accounting - tax return, Annual accounts and Annual return Training Course If you want to work in a Finance or Tax department of a business or as an accountant in well-known accountancy firms it is vital that you know how to prepare accounts for the company and submit them to the right places. This UK Tax accounting course will upgrade your skills to higher level. Completing this course will enable you learn more about the procedures involved in submitting Corporate Tax Return. Once you are skilled on this, you can offer this as a service to potential business clients and earn £££. If you are running a business you can process your own Business Tax return and Accounts, instead of paying someone else to do it. It will save a lot of money (£££) every year. You will stay ahead of the competition if you are looking for a job in the Accounting or Tax Industry once you are skilled Business Accounting and Tax procedures. Identifying requirements to set up a UK Company Identifying Statutory Requirements for Companies Introduction to Confirmation Statement processing Identifying Types of Companies based on size Identifying Types and requirements of various Submissions available Identifying minimum requirements in a Balance Sheet and Profit & Loss Account Identifying Tax Return periods and deadlines Identifying Penalties for Late filing Identifying Closing Down Procedures for Companies Introduction to the Filing Company accounts procedure Company house forms and correspondences Understanding of IXBRL requirements Understanding submission procedures using HMRC Online CT600 (Webfiling) Using one Business(SME/Micro Entity) case to understand the procedures on Annual Submission for Company Tax Return and Accounts submission

Duration 5 Days 30 CPD hours This course is intended for This class is ideal for merchants, marketers, and content managers who want to learn more about using B2C Commerce Cloud Business Manager to manage end-to-end business operations for a Commerce Cloud storefront. This course is also useful for developers preparing for the B2C Commerce Developer certification, providing information on working with a B2C site and data management using Business Manager. Overview Organize a storefront using catalogs, categories, products, pricing, and search refinements. Improve results in search engines using SEO best practices. Improve on-site search using the search index, Einstein Search dictionaries, and sorting rules. Entice and target online shoppers using customer groups, qualifiers, campaigns, and promotions. Create shopper experiences using content slots, Page Designer, and Einstein Recommendations. Leverage analytics and reports to determine success. Create A/B tests to make decisions on storefront experiences. Discover how to present products in a compelling way on a B2C Commerce Cloud storefront so you can turn customers into repeat customers. In this 5-day extended* class, you?ll learn how to improve conversion rates and increase the average order size of shoppers. Our B2C Commerce Cloud experts will walk you through how to organize an existing site, use best practices in search and online marketing, enhance the shopper experience, and leverage analytics to understand what products are selling best and why. NOTE: This course does not include site creation, programming, or site design. This class is taught using the SFRA reference architecture site and not the client?s specific site. Client specific site is used during the Launch Readiness Bootcamp conducted by Services. Getting Started Introductions Housekeeping B2C Commerce Overview Shop Organization Explain How Catalogs Work Create Categories Manage Products Manage Pricing & Inventory Configure Search Refinements Search & Sort Manage Search Engine Optimization Implement Searchandizing Strategies Online Marketing Use Qualifiers (coupon codes, source codes, customer groups) Create Promotions Create and Manage Campaigns Refine Campaigns Shopper Experience Identify Content Management Basics Create and Manage Content Slots Create a Page Using Page Designer Identify Einstein Recommender Types and Related Strategies Analysis and Optimization View Production Reports Create an A/B Test

Duration 5 Days 30 CPD hours This course is intended for Application DevelopersWeb AdministratorDeveloperProject ManagerSystem AdministratorTechnical AdministratorTechnical ConsultantTeam Leader Overview Write Java code that uses variables, arrays, conditional and loop constructsManipulate primitive numeric data and string data using Java operatorsCreate Java classes and use object referencesAccess the fields and methods of an objectManipulate text data using the methods of the String and StringBuilder classesUse casting without losing precision or causing errorsDeclare, override, and invoke methodsAccess and create static fields and methodsUse classes from the java.time and java.time.format packages to format and print the local date and timeEncapsulate a class using access modifiers and overloaded constructorsDefine and implement a simple class hierarchyDemonstrate polymorphism by implementing a Java InterfaceUse a Predicate Lambda expression as the argument to a methodHandle a checked exception in a Java application This Java SE 8 Fundamentals training introduces you to object-oriented programming using the Java language. Through hands-on exercises, you'll begin to build a baseline of knowledge to propel your career in development. This Java SE 8 Fundamentals training introduces you to object-oriented programming using the Java language. Through hands-on exercises, you'll begin to build a baseline of knowledge to propel your career in development. Additional course details: Nexus Humans Java SE 8 Fundamentals 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 Java SE 8 Fundamentals 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 course is aimed at developers who want to build web applications using ASP.NET Core or developers who want to make a career building web applications using Microsoft technology. In the web world, the ability to build robust web applications is key. With the knowledge about ASP.NET Core MVC (that makes use of the Model-View-Controller architecture) that you will take away from this course, you will be prepared to meet this need. In today's age, it's important for you as a developer to possess the ability to separate the programming and business logic. This course covering ASP.NET Core 2 will help you develop this skillset. Setting the Stage Introduction to Web Applications Creating ASP.NET Core application Controllers Role of the Controller in ASP.NET MVC Applications Introduction to Routing Our First Controller Implementing our own IActionResult Adding Views Adding Models Passing Data from the Controller to the View Filters Writing a Custom Filter Views The View Engine and the Razor View Engine Working with Layout Generating HTML Partial View View Components Tag Helpers Models Introduction to Models Model Binding The Entity Framework Using the Entity Framework in ASP.NET MVC applications Database Migration Validation Introduction to Validation Client-Side and Server-Side Validation Server-side Validation Client-side Validation Implementation Routing Convention-Based Routing Attribute-Based Routing Route Attribute at the Controller Level Passing Routing Values in HTTP Action Verbs in the Controller Route Constraints Rest Buy Designing Rest Buy Creating the Entities for the Application Creating EF Context and Migration Adding Features, Testing, and Deployment Adding the Registration Feature Creating a Unit Test Upgrading Our Application to Bootstrap 4 Deploying Rest Buy to Azure Additional course details: Nexus Humans Beginning ASP.NET 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 Beginning ASP.NET 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 individuals who are Java programmers and have worked with databases and with object-oriented programming techniques, who are now ready to create more complex and advanced programs using Java SE 7. Overview Upon successful completion of this course, students will be able to: - create and manage custom classes. - control program flow by writing code to respond to specific criteria. - implement object-oriented programming techniques to create reusable and reliable programs. - work with Java utility class libraries. - use the capabilities of the Java I/O package to read and write data to external files or media. - use collection APIs in Java to manage data. - use generics to enforce compile-time type checking. - use multi-threaded programs to help handle multiple tasks concurrently. - manage Java applications for memory efficiency and create distributable versions of a Java application. Students will work with advanced features of Java. Working with Classes Create Classes Create Variables Write an Expression Work with Arrays Work with Static Class Members Define Methods Use Enumerated Data Types Controlling Program Flow Work with Conditional Statements Work with Looping Statements Handle Exceptions Handle Chained Exceptions Write and Enable Assertions Implementing Object-Oriented Programming Concepts Extend a Class Overload and Override Methods Work with Interfaces Create Inner Classes Examine Object-Oriented Design Concepts Working with Java Utility Class Libraries Work with Strings Format and Parse Strings Work with Dates, Numbers, and Currencies Using the Java I/O Package Work with the File Class Work with Byte Streams Work with Character Streams Read Files Write to a File Manipulate I/O Objects Using Collections Work with the Collection Interface Work with the Set Collection Work with List Collections Work with Queues Work with the Map Collection Work with Collection Utilities Working with Generics Declare Generics Implement Generics Using Multi-Threaded Programs Create a Multi-Threaded Program Synchronize Threads Managing Java Applications Implement Garbage Collection Deploy a Java Application Additional course details: Nexus Humans Java Programming (Java SE 7) 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 Java Programming (Java SE 7) 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.