7471 Courses delivered Online

Advanced Professional Certificate Courses These are short online certificate courses of a more advanced nature designed to help you develop professionally and achieve your career goals, while you earn a professional certificate which qualifies you for the appropriate continuous professional development (CPD). Advanced Professional Certificate in International Trade Law This Advanced professional certificate course covers essential topics relating to international trade and international sales contracts. First, this course explores international trade's legal and regulatory landscape and how this practice can negatively and positively impact economies, societies, and the environment. In addition, the course introduces some fundamental concepts, reflects on relevant market theories, and then presents an in-depth analysis of complex international trade agreements and mechanisms, including GATT and WTO. Second, the course explores the English legal and regulatory landscape of the sales of goods and the principles on which law practitioners draft and negotiate these contracts. The course introduces some fundamental concepts relating to the rights and obligations of buyers and sellers in sales contracts. Moreover, the course will help participants reflect on the scope and provisions of the Vienna Convention for the international sale of goods by introducing fundamental concepts explaining the obligations of the seller and buyer under the agreement and analysing remedies offered to the buyer and seller. The course also introduces fundamental concepts such as the foreign exchange markets and various payment methods in international trade. Course Details After the successful completion of this lecture, you will be able to; Measure the impact of international trade on economies and the environment. Reflect on relevant market theories. Understand the structure, role, and function of the world trade organisation. Understand the construction of contracts of sales of goods and products in English law. Determine the rights and obligations of buyer and seller in international sales contracts. Reflect on the remedies offered to the buyer and seller in case of breach of contract. Understand the different types and effects of incoterms rules. Reflect on the scope and provisions of the Vienna Convention for the international sale of goods. Understand the obligations of the seller and buyer under the CISG. Analyse remedies offered to the buyer and seller under the CISG. Reflect on the economic foundations of international sales contracts. Understand the function of foreign exchange markets. Understand various methods of payment in international trade. Accreditation The content of this course has been independently certified as conforming to universally accepted Continuous Professional Development (CPD) guidelines. Entry Requirements There are no strict entry requirements for this course. Work experience will be added advantage to understanding the content of the course. The certificate is designed to enhance the learner's knowledge in the field. This certificate is for everyone eager to know more and gets updated on current ideas in their respective field. We recommend this certificate for the following audience. Legal advisors. Law practitioners. Contract specialists. Legal officers. Contract managers. Business developers. Trade advisors. Trade compliance officers. Law lecturers. Business lecturers. Legal and business researchers.

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.

This must-attend masterclass will provide a comprehensive understanding of all the key developments in the latest statutory and non-statutory guidance documents from a DSLs perspective, and how they relate to safeguarding provision in schools and colleges.

Secure your place in finance and HR teams with this all-in-one Payroll Administrator: 20-in-1 Premium Online Courses Bundle. Created to reflect what today’s hiring managers value most, this bundle is the go-to career accelerator for anyone aiming to step into payroll coordination, account support, or financial administration. Hiring season never slows in payroll. The question is—will you be ready when the next job drops? Description Payroll administration is a high-responsibility role that touches law, finance, compliance, and reporting. This bundle positions you as a candidate who understands the bigger picture—across Excel, AML, Xero, Sage, VAT, and more. If you're targeting entry-level finance roles or expanding your administrative skills into payroll territory, this comprehensive 20-course collection proves you’re not only organised—but fully capable. From small businesses to large corporate teams, payroll talent is in constant demand—and this certification stack puts you ahead of those with just a single skillset. One purchase. Twenty ways to prove your value. FAQ Q: What roles is this bundle useful for? A: Payroll administrator, finance clerk, accounting assistant, HR coordinator, or junior bookkeeper. Q: Will this help me land interviews? A: Yes. It provides a certification-rich CV that shows practical readiness for payroll positions. Q: Can beginners enrol? A: Absolutely. This bundle is beginner-friendly and also adds credibility for career switchers. Q: Are the certificates recognised? A: Yes—each course offers digital proof of completion, great for CVs, portfolios, and LinkedIn profiles. Q: Does this focus only on finance? A: It covers finance, legal, compliance, and administrative competencies that reflect real job demands. Q: Why should I buy now? A: Multi-certified candidates are getting noticed—waiting could mean falling behind more prepared applicants.

Step into leadership with confidence. The Manager Training: 20-in-1 Premium Online Courses Bundle equips aspiring and current managers with a suite of strategic, interpersonal, and operational skills essential for today’s job market. Whether you aim to climb the ladder in corporate management, team leadership, or project coordination, this bundle places you a cut above the rest. Description In a saturated job market, generic qualifications no longer stand out. This all-in-one bundle gives you a targeted advantage—ideal for professionals pursuing roles in operations, compliance, HR, project delivery, or team leadership. From crisis management to communication finesse, every course is selected to sharpen skills that employers actively seek. If you're aiming to break into management or earn that next promotion, this collection is built for you. With 20 courses bundled together, it's a fraction of the cost you'd pay elsewhere—without compromising quality or relevance. Think of it as your career accelerator, wrapped into one expertly curated package. Don't let this opportunity pass you by while others advance. FAQ Q: Who is this bundle ideal for? A: Team leads, supervisors, project coordinators, HR staff, and anyone looking to transition into or grow in a management role. Q: What industries does this apply to? A: Corporate offices, healthcare, construction, IT, government, education, logistics, and virtually any sector that values leadership and operational excellence. Q: Will I receive a certificate for each course? A: Yes, each course is individually certified, making your CV shine across 20 competencies. Q: How long will I have access? A: You’ll enjoy full, unrestricted access. Learn at your own pace—no pressure. Q: Is this beginner-friendly? A: Absolutely. Whether you’re a new manager or brushing up old skills, this bundle is designed to meet you where you are.

Payroll expertise is a must-have across virtually every sector—from corporate finance to SME administration. The Payroll: 20-in-1 Premium Online Courses Bundle gives you the multidisciplinary credentials needed to stand out in payroll, accounts, and financial operations roles. Want to move up the shortlist or transition into a stable, numbers-driven career? This bundle puts the right certifications in your corner—without delay or excess cost. Description Modern payroll professionals need to offer more than number-crunching. Employers are seeking team players with technical fluency, software adaptability, and a grip on regulatory essentials. This bundle covers a broad spectrum—from accounting software like Sage and Xero to VAT, AML, and business law. Whether you're applying for roles in finance departments, accountancy firms, HR teams, or administrative support, this 20-course package tells employers one thing: you’re ready to contribute from day one. If you’re serious about being hired in payroll—or serious about getting promoted—don’t miss the chance to certify your edge while demand is high. FAQ Q: Who is this bundle designed for? A: Ideal for aspiring payroll officers, finance assistants, bookkeeping staff, or administrative professionals with finance duties. Q: Will I become more hireable? A: Yes—this bundle demonstrates your capacity to manage payroll with precision and compliance awareness. Q: Do I need accounting experience first? A: Not necessary. This bundle supports both beginners and those looking to level up. Q: What industries is this relevant to? A: Finance, HR, healthcare, retail, consultancy, education, and any payroll-heavy organisation. Q: Are certificates included? A: Yes—each of the 20 courses comes with a verifiable certificate upon completion. Q: Why enrol now? A: Employers need well-rounded payroll candidates now more than ever. This bundle offers full-stack value—for a fraction of the cost elsewhere.

In care, education, mental health, and beyond—understanding human behaviour is no longer optional. The Psychology: 20-in-1 Premium Online Courses Bundle gives you the multi-dimensional credentials employers expect from today’s compassionate professionals. Whether you're entering the field or enriching your current role, this bundle proves you're built for people-first work. Description Professionals in social work, mental health, education, or support roles are increasingly expected to bring a working knowledge of behavioural science, counselling basics, and emotional intelligence. This bundle delivers 20 certifications to help your CV reflect modern psychological awareness—while setting you apart in the hiring process. From autism support to brain disorders, from CBT to self-esteem, this collection shows employers you're not just qualified—you’re holistically prepared. It also adds value for those in education, HR, social care, or even customer-facing corporate roles. Psychology opens doors. This bundle gives you the keys—before the vacancies are gone. FAQ Q: Is this only for psychologists or therapists? A: Not at all. It suits anyone working in education, care, support services, coaching, or people-focused careers. Q: What jobs can this help me get? A: Mental health assistant, support worker, SEN teaching assistant, care coordinator, or HR wellbeing lead. Q: Can I add these certificates to my job applications? A: Yes—each course provides certification to enhance your portfolio and CV. Q: Is this suitable for beginners? A: Absolutely. No prior experience in psychology is required to benefit from this bundle. Q: Does it include personal development skills? A: Yes. Courses also cover self-organisation, communication, negotiation, and problem-solving. Q: Why buy now? A: Demand for emotionally intelligent professionals is rising—this bundle helps you respond, not react.

Step into the world of strategic leadership with the Business Management: 20-in-1 Premium Online Courses Bundle—your complete toolkit for high-impact performance in today’s fast-moving economy. Whether you’re eyeing roles in operations, corporate services, or SME management, this collection helps you build a job-ready profile from the inside out. With credentials covering everything from crisis management to etiquette, this bundle turns you into the candidate employers want before you even walk in the door. Description Business success hinges on the people who can lead under pressure, communicate across teams, and ensure everything runs on time—and on budget. This 20-course bundle is ideal for professionals aiming for business analyst, office manager, HR coordinator, or operations lead roles in corporate, retail, nonprofit, public sector, and entrepreneurial environments. From soft skills to structural essentials, this bundle is designed to be practical, portable, and highly persuasive to hiring managers across the board. 📊 Multi-role preparation: Suitable for dozens of job functions. 🔥 Act fast—20 courses for less than the cost of one traditional certification. 🎯 Job-market gold: Showcase skills that translate across industries. FAQ Q: Who benefits from this bundle? A: Professionals and jobseekers in operations, HR, administration, customer service, project coordination, and team leadership. Q: Is it beginner-friendly? A: Yes—this bundle caters to both aspiring and established business professionals. Q: Which industries value this kind of training? A: Finance, retail, IT, public services, hospitality, and SME sectors, to name a few. Q: Are the courses accredited? A: While not formally accredited, the certificates demonstrate practical training and commitment. Q: Do I need to complete the courses in order? A: No—learn in any order that suits your needs. Q: Is this a limited-time offer? A: Yes. The current price is part of a time-sensitive promotion.

In today’s competitive job market, leaders are hired for more than just experience—they’re hired for mindset, adaptability, and the ability to manage people through uncertainty. The Leadership and People Management: 20-in-1 Premium Online Courses Bundle gives you the well-rounded credibility you need to move into team leadership, operations, or HR management. Packed with 20 essential courses, this all-in-one professional upgrade was designed to help you stand out and get hired faster. Description Employers across industries—finance, healthcare, education, tech, logistics—are all on the lookout for leaders who understand people. This bundle helps you prove that you do. From communication to crisis management, conflict resolution to remote team handling, these certifications show you’re not just a manager—you’re a people-first strategist. It’s ideal for professionals eyeing a promotion, graduates transitioning into team roles, or freelancers moving into organisational leadership. With hiring managers prioritising emotional intelligence, productivity strategy, and team cohesion, now is the time to boost your credentials. This 20-course bundle offers enormous value—and serious career leverage. But like all strategic windows, it’s limited. If you're ready to step forward into leadership, don’t let this opportunity slip past. FAQ What jobs does this bundle support? Team leader, operations manager, HR coordinator, project lead, and departmental supervisor. Do I need to be in a leadership role already? No—this is perfect for aspiring leaders or those transitioning into management. Is this suitable for remote work careers? Yes, especially with included topics like online meeting and remote team management. Do I receive certificates? Yes—each course includes a downloadable certificate for your CV and LinkedIn. How flexible is the training? Fully online, 24/7 access. Learn at your pace. Is this a permanent offer? No—this bundle is available only for a short time.

PACE was developed by Dr Dan Hughes (a clinical psychologist specialising in childhood trauma) more than 20 years ago as a central part of attachment-focused family therapy. It was created with the aim of supporting adults to build safe, trusting and meaningful relationships with children and young people who have experienced trauma. The approach focuses on building trusting relationships, emotional connections, containment of emotions and a sense of security.  PACE is a way of thinking, feeling, communicating and behaving that aims to make the child feel safe. Its four principles of communication – Playfulness, Acceptance, Curiosity and Empathy – facilitate the building of healthy, secure attachments between caregiver and child. PACE parenting is especially effective for supporting children that lack secure emotional bases. It is ideal for anyone working or living with children, especially those children in the care system Who is this course for? Anyone working with or living with children and young people. Like foster carers, adopting parents, residential carers, social workers but would also benefit parents experiencing difficulties. What will it cost? This is being developed as a video course – please contact us for prices. Face2face courses are £750.00 plus vat per session, plus travel. How will I benefit from this course? You will benefit by building safe, trusting and meaningful relationships with children and young people. What is the course content? Learn about the four principles of the model… communication- Play, Acceptance, Curiosity and Empathy with the add on of Like to make PLACE model and how to implement it…. The therapeutic needs of the children you care for… The fight flight freeze & fawn response Attachment Trauma & effects on the brain Transference/counter transference… Dysfunctional thoughts, beliefs and alternative ways of thinking… Self-help & support How are the courses delivered? Although this is being converted to a video course, it is available face2face for groups of around 15 people Is this course recognised? Yes, it is fully CPD accredited