4608 Operations courses in Whetstone delivered Online

Duration 2 Days 12 CPD hours This course is intended for This is an intermediate and beyond level SQL course geared for experienced end users, data scientists, business analysts, application developers and database administrators. Students should have recently attended a basic SQL class or have equivalent experience. Overview This course is approximately 50% hands-on, combining expert lecture, real-world demonstrations and group discussions with machine-based practical labs and exercises. Our engaging instructors and mentors are highly experienced practitioners who bring years of current 'on-the-job' experience into every classroom. Working in a hands-on learning environment led by our expert practitioner, attendees will learn advanced skills needed to: Advanced Query Techniques Manipulating Table Data Using SQL's Data Manipulation Language (DML) User-Defined Functions Stored Procedures Triggers A company?s success hinges on responsible, accurate database management. Organizations rely on highly available data to complete all sorts of tasks, from creating marketing reports and invoicing customers to setting financial goals. Data professionals like analysts, developers and architects are tasked with creating, optimizing, managing and analyzing data from databases ? with little room for error. When databases aren?t built or maintained correctly, it?s easy to mishandle or lose valuable data. Our SQL Programming and Database Training Series provides students with the skills they require to develop, analyze and maintain data and in correctly structured, modern and secure databases. Next Level SQL explores how to identify and use advanced querying techniques to manipulate and index tables. All hands-on work in this course is ANSI SQL compliant and should work with most SQL databases such as Oracle, SQL Server, MySQL, MS Access, Informix, Sybase, or any other ANSI SQL compliant database. Advanced Query Techniques Join inner outer (Left, Right, Full) Subqueries Simple Correlated Using the Exists Operator Tips for Developing Complex Queries Performing Set Operations Aggregating Results Using Group by Creating Temporary Tables Manipulating Table Data Using SQL's Data Manipulation Language (DML) Inserting Data into Tables Updating Existing Data Deleting Records Truncating Tables Implementing Data Integrity with Transactions Beginning Explicit Transactions Committing Transactions Rolling Back Transactions User-Defined Functions Definition and Benefits of Use CREATE FUNCTION Syntax RETURN Clause and the RETURNS Statement Scalar vs. Table Functions Comparison with Stored Procedures Returning Scalar Values and Tables ALTER and DROP FUNCTION Stored Procedures Definition and Benefits of Use CREATE PROCEDURE Syntax Variables and Parameters Control of Program Flow ALTER and DROP PROCEDURE Implementation Differences Triggers Definition and Benefits of Use Alternatives (e.g., Constraints) CREATE TRIGGER Syntax Trigger Types 'Inserted' (or 'NEW') and 'Deleted' (or 'OLD') Tables Event Handling and Trigger Execution ALTER and DROP TRIGGER Additional course details: Nexus Humans Advanced SQL Programming (TTSQL005) 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 Advanced SQL Programming (TTSQL005) 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 comprehensive and practical Apache Spark course. In this course, you will learn and master the art of framing data analysis problems as Spark problems through 20+ hands-on examples, and then scale them up to run on cloud computing services. Explore Spark 3, IntelliJ, Structured Streaming, and a stronger focus on the DataSet API.

Sigma six lean is a collaborative team effort process to develop performance by removing waste and reducing variations to increase company profits. If you want to learn more about this field, the Level 3 Diploma in Six Sigma & Lean Process course will assist you further in your quest. The course introduces you with the basic introduction of sigma process along with its history. It teaches you basic fourteen Toyota principals dividing into four parts such as people and partner, process, problem-solving, and philosophy. The course further teaches you the five principles of lean business. The course enhances your efficiency to increase your company profit in a sound bite. Who is the course for? Professionals who want to know how six sigma works Businessmen interested in improving their work process by reducing waste to increase profitability Entry Requirement This course is available to all learners, of all academic backgrounds. Learners should be aged 16 or over to undertake the qualification. Good understanding of English language, numeracy and ICT are required to attend this course. CPD Certificate from Course Gate  At the successful completion of the course, you can obtain your CPD certificate from us. You can order the PDF certificate for £9 and the hard copy for £15. Also, you can order both PDF and hardcopy certificates for £22. Career path This course opens a new door for you to enter the relevant job market and also gives you the opportunity to acquire extensive knowledge along with required skills to become successful. You will be able to add our qualification to your CV/resume which will help you to stand out in the competitive job industry. Course Curriculum Lean Process Module One - Getting Started 00:30:00 Module Two - Understanding Lean 01:00:00 Module Three - Liker's Toyota Way 01:00:00 Module Four - The TPS House 01:00:00 Module Five - The Five Principles of Lean Business 01:00:00 Module Six - The First Improvement Concept (Value) 01:00:00 Module Seven - The Second Improvement Concept (Waste) 01:00:00 Module Eight - The Third Improvement Concept (Variation) 01:00:00 Module Nine - The Fourth Improvement Concept (Complexity) 01:00:00 Module Ten - The Fifth Improvement Concept (Continuous Improvement) 01:00:00 Module Eleven - The Improvement Toolkit 00:30:00 Module Twelve - Wrapping Up 01:30:00 Six Sigma Six Sigma Basics 00:15:00 Improvement Tools 00:30:00 Management Tools for Generating Ideas 00:15:00 Continuous Improvement 00:30:00 Customer Relationships 00:30:00 Mock Exam Mock Exam- Level 3 Diploma in Six Sigma & Lean Process 00:20:00 Final Exam Final Exam- Level 3 Diploma in Six Sigma & Lean Process 00:20:00 Certificate and Transcript Order Your Certificates or Transcripts 00:00:00

The Charity Accounting Mini Bundle is tailored for those ready to step into the financial and regulatory side of nonprofit and charitable organisations. With a focus on accounting, financial analysis, business management, AML, and problem solving, this bundle is designed to get you hired in a sector where transparency and accountability are everything. If you're eyeing a career where purpose meets performance, this bundle delivers both. Description Charities operate like businesses—but with tighter scrutiny. That’s why roles in this sector increasingly require core competencies in accounting, financial analysis, business management, AML compliance, and problem solving. The Charity Accounting Mini Bundle gives you the credibility you need to stand out in charitable foundations, NGOs, and nonprofit finance departments. Employers in the third sector value candidates who can handle accounting responsibilities with the rigour of business management and the insight of financial analysis. AML procedures are no longer optional—they’re essential. Add in strong problem solving skills, and you're exactly the kind of reliable, detail-driven hire charities are seeking. Positions in nonprofit accounting and financial support don’t wait. With accounting, financial analysis, business management, AML, and problem solving under your belt, you're ready to move from application to appointment. FAQ Who should take this bundle? Anyone aiming to work in charity finance, nonprofit admin, or grant auditing roles. Is AML really that important in the charity sector? Yes—AML ensures donations and financial operations remain compliant and trustworthy. What kinds of roles does this support? Charity accountant, finance assistant, trust officer, nonprofit auditor, compliance coordinator, and donor finance liaison. How does business management tie in with accounting? Charities still need structured budgeting and operations—business management skills are increasingly essential. Is this suitable for someone transitioning from private sector roles? Absolutely—especially with experience in accounting, financial analysis, AML, and problem solving. Why enrol now? Charity roles are rising—but competition is tight. Demonstrate readiness with accounting, financial analysis, business management, AML, and problem solving expertise today.

The Insurance Mini Bundle is crafted for those looking to secure careers within the complex and competitive insurance sector. With training across payroll, accounting, property law, compliance, and contracts law, this bundle makes your CV irresistibly attractive to insurers, brokers, and legal-financial firms. Don’t just apply—apply with credibility. Description In insurance, knowledge of contracts law, property law, payroll, compliance, and accounting is not optional—it’s essential. Employers in general, life, and property insurance roles seek professionals with practical skills that support both operational and legal frameworks. That’s exactly what this bundle delivers. With payroll and accounting providing the financial backbone, and property law and contracts law offering legal insight, this bundle ensures you're perceived as balanced and job-ready. Add in compliance—one of the industry's most important areas—and you have a rare skill profile. Whether you’re entering as an administrator or progressing toward underwriting and risk roles, this bundle brings visibility to your CV. Recruiters move quickly in this sector. Demonstrate your edge in payroll, accounting, property law, compliance, and contracts law before someone else does. FAQ Who should consider this course bundle? Jobseekers aiming for employment in the insurance, financial, legal, or administrative sectors. Is this useful for entry-level insurance jobs? Absolutely. It covers key employer expectations across compliance, contracts law, accounting, payroll, and property law. Can I use this for remote or hybrid roles? Yes—skills in payroll, compliance, and accounting are highly sought after in remote operations. What makes this bundle different? It combines legal, financial, and procedural knowledge—key for insurance hiring managers. Are there legal elements in demand right now? Very much so—property law and contracts law are core to modern insurance operations. Why should I enrol now? The insurance industry is always recruiting—but they hire fast. Secure your knowledge in payroll, accounting, property law, compliance, and contracts law today—before you’re left behind.

The Buying Mini Bundle is built for aspiring professionals in procurement, purchasing, and commercial buying environments. Featuring targeted training in retail management, quantity survey, procurement and purchasing, telephone etiquette, and Excel, this bundle helps you become the candidate that retail, supply chain, and construction businesses want to hire. Don’t just meet expectations—surpass them with this all-in-one buyer-focused package. Description Companies in retail, logistics, and construction demand professionals who can manage procurement, analyse spend data in Excel, communicate effectively by telephone, and make cost-efficient purchasing decisions. The Buying Mini Bundle combines these high-impact skills—retail management, quantity survey, procurement and purchasing, telephone etiquette, and Excel—into a bundle that shows you’re not just job-ready, you’re operations-ready. Whether you're entering the field or looking to step up into a buyer role, this bundle ensures your CV reflects the competencies today's employers are searching for. From high-street retailers to construction consultancies, your ability to bridge quantity survey principles with procurement and retail management can set you apart. FAQ Who should take this course bundle? Those looking to enter or progress in retail management, procurement and purchasing, quantity survey, or Excel-driven commercial roles. Can this help me get a job in buying or procurement? Definitely—it demonstrates capability in procurement and purchasing, telephone etiquette, Excel, retail management, and quantity survey. What types of jobs does this support? Buyer, procurement assistant, supply chain coordinator, retail operations specialist, quantity survey support, and merchandise planner. Is prior experience necessary? Not at all. This bundle suits career starters and professionals switching industries. What makes this bundle unique? Its focus on real-world relevance across procurement, retail, construction, and supply chain—using quantity survey and Excel knowledge to add measurable value. Why now? The market is moving fast. Set yourself apart in procurement and purchasing, quantity survey, telephone etiquette, Excel, and retail management before the best jobs are gone.

Step confidently into the world of finance with the Payroll Accountant Mini Bundle, designed to boost your hireability in accounting, payroll, and data-driven roles. This bundle highlights your capabilities in payroll, financial analysis, accounting, data analysis, and VAT — skills that every finance team values highly. If you want to stand out in a competitive job market, this bundle is your pathway to becoming an indispensable payroll accountant. With demand soaring for professionals skilled in payroll and accounting, combined with expertise in financial analysis, data analysis, and VAT, your career prospects just got brighter. Don’t miss the chance to secure your future today. Description This bundle integrates critical business functions—payroll management, financial analysis evaluation, core accounting principles, precise data analysis, and comprehensive VAT knowledge—that employers actively seek. The skills in payroll, financial analysis, accounting, data analysis, and VAT signal your readiness to manage complex payroll accounts and ensure compliance with tax regulations. Industries from corporate finance to small business accounting rely on professionals fluent in payroll operations and accounting standards, with sharp financial analysis and data analysis skills to interpret numbers accurately. Plus, VAT expertise is a must-have for smooth fiscal operations. This bundle prepares you to meet those exact demands, making you a highly hireable candidate. FAQ Q: Who benefits from this bundle? A: Aspiring payroll accountants, finance assistants, and those targeting accounting departments. Q: Are these skills in demand? A: Yes, employers constantly seek proficiency in payroll, accounting, financial analysis, data analysis, and VAT. Q: Will this help with VAT compliance roles? A: Absolutely. VAT is a vital part of modern accounting and tax functions. Q: Can I apply these skills immediately? A: Yes. This bundle equips you with practical, job-ready knowledge. Q: Is prior experience required? A: No. It’s designed for newcomers and those improving existing skills. Q: Why enroll now? A: Finance and payroll jobs grow steadily; the earlier you train, the better your prospects.

Whether you're leading a team or managing relationships across departments, the Managing & Influencing Stakeholders Mini Bundle equips you with the practical skills to thrive. Designed for career climbers, this bundle focuses on what employers want in team players and emerging leaders: credibility, communication, and clarity. With a powerful mix of Team Leader, Problem Solving, Report Writing, MS Word, and HR, this is your fast-track to influence and impact in the workplace. Description Success in stakeholder management isn’t just about communication — it’s about control, clarity, and leadership. This bundle is your shortcut to gaining that edge. With focused training in Team Leader, Problem Solving, Report Writing, MS Word, and HR, you’ll build a profile that speaks directly to hiring managers in professional, public, and private sectors. Report Writing and MS Word remain essential for documentation, briefings, and cross-team collaboration. Pair that with strong Team Leader skills and a foundation in Problem Solving, and you’ve got the blueprint for influencing internal and external stakeholders. Add HR to the mix, and you demonstrate a full-spectrum understanding of team dynamics, compliance, and workplace systems. This bundle is ideal for those targeting leadership assistant roles, HR support, operations coordinators, executive support, or stakeholder liaisons. And as industries tighten hiring criteria, having a clear package like this gives you an undeniable advantage. FAQ Q: What types of jobs align with this bundle? A: Stakeholder coordinator, admin lead, HR officer, operations assistant, junior project manager, and internal communications roles. Q: Will this bundle help with promotions or stepping into leadership roles? A: Yes. The combination of Team Leader, Problem Solving, Report Writing, MS Word, and HR prepares you for mid-level and senior support responsibilities. Q: Is this suitable for people who work in HR or admin already? A: Perfectly. It reinforces your core skills and adds strategic communication and stakeholder confidence. Q: What makes this different from a general admin bundle? A: This bundle is centered around influence and clarity in communication — key elements in managing stakeholders — not just admin tasks.

Master the critical skills that define modern leadership with the Essentials of Stakeholder Management Training Mini Bundle — a results-driven collection built to help you stand out in high-pressure, team-facing roles. Whether you work in operations, project management, public services, or leadership, this bundle is about one thing: making you hireable in demanding, real-world roles. Courses in Team Leader, Problem Solving, Negotiation Skills, Crisis Management, and Disaster Management build a high-trust profile for decision-makers and future leaders. Description In today’s fast-moving workplace, soft skills are power skills — and employers know it. That’s why this bundle focuses on five critical areas: Team Leader, Problem Solving, Negotiation Skills, Crisis Management, and Disaster Management. These aren’t just keywords — they’re the backbone of leadership roles across corporate teams, government agencies, logistics, finance, non-profits, and more. When companies look for rising leaders, they want candidates who demonstrate strength under pressure, negotiation expertise, and effective decision-making — all covered within this bundle. Whether you're hoping to lead teams, manage projects, work with stakeholders, or de-escalate complex challenges, this bundle shows that you’re more than qualified — you're equipped. If you're aiming for managerial roles or senior responsibility, delay is costly. The Essentials of Stakeholder Management Training Mini Bundle offers a smart, value-packed way to boost your credibility — and get noticed before others do. FAQ Q: Who should take this bundle? A: Anyone looking to step into or grow within leadership, operations, stakeholder communication, or project management roles. Q: Will this help me stand out to employers? A: Yes. Team Leader, Problem Solving, Negotiation Skills, Crisis Management, and Disaster Management are all highly valued across industries. Q: Is this useful for public service or emergency management roles? A: Definitely. These areas are vital in public sector, government, healthcare, and emergency services. Q: What industries hire for these skills? A: Corporate leadership, NGOs, logistics, HR, disaster response, local government, and any stakeholder-facing role.

Elevate your expertise in the dynamic world of retail banking with our comprehensive course. Gain valuable insights into banking services, customer relations, risk management, and ethical considerations. Master essential skills such as cash handling, fraud prevention, and mathematics for bank tellers. Enroll now to advance your career in finance and unlock a wealth of knowledge tailored for success in the retail banking sector.