4647 Operations courses in Widnes 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.

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.

Recognised Accreditation This course is accredited by continuing professional development (CPD). CPD UK is globally recognised by employers, professional organisations, and academic institutions, thus a certificate from CPD Certification Service creates value towards your professional goal and achievement. The Quality Licence Scheme is a brand of the Skills and Education Group, a leading national awarding organisation for providing high-quality vocational qualifications across a wide range of industries. What is CPD? Employers, professional organisations, and academic institutions all recognise CPD, therefore a credential from CPD Certification Service adds value to your professional goals and achievements. Benefits of CPD Improve your employment prospects Boost your job satisfaction Promotes career advancement Enhances your CV Provides you with a competitive edge in the job market Demonstrate your dedication Showcases your professional capabilities What is IPHM? The IPHM is an Accreditation Board that provides Training Providers with international and global accreditation. The Practitioners of Holistic Medicine (IPHM) accreditation is a guarantee of quality and skill. Benefits of IPHM It will help you establish a positive reputation in your chosen field You can join a network and community of successful therapists that are dedicated to providing excellent care to their client You can flaunt this accreditation in your CV It is a worldwide recognised accreditation What is Quality Licence Scheme? This course is endorsed by the Quality Licence Scheme for its high-quality, non-regulated provision and training programmes. The Quality Licence Scheme is a brand of the Skills and Education Group, a leading national awarding organisation for providing high-quality vocational qualifications across a wide range of industries. Benefits of Quality License Scheme Certificate is valuable Provides a competitive edge in your career It will make your CV stand out Course Curriculum Photoshop Orientation & Essentials Photoshop Course Promo & Outline 00:02:00 The Power of Photoshop! 00:01:00 Photoshop Course Resources & best learning experience 00:01:00 Creating Photoshop Documents 00:03:00 Photoshop's Workspaces & Orientation 00:08:00 Navigation in Photoshop 00:09:00 Cropping Images & different photoshop's cropping ratios 00:07:00 Color Modes in Photoshop 00:09:00 Resolution concept & enlarging images while preserving quality 00:08:00 Save files in photoshop in different format (psd,jpeg,psb,tiff,png) 00:09:00 Cloud Documents ( Photoshop CC 2020 ) 00:03:00 Photoshop CC 2020 Close others new feature 00:01:00 Layers in Photoshop Layers concept in Photoshop & Handling them 00:10:00 Photoshop's Layer Panel 00:15:00 Unleash creativity with Blend modes in Photoshop 00:13:00 Photoshop 2020 New Layers Navigation 00:01:00 Layer styles 00:10:00 Transformation & Perspective tweaking in Photoshop Transformation Modes & Tricks 00:13:00 Puppet warp in photoshop 00:06:00 Perspective warp in photoshop 00:04:00 Design & Work Precisely in Photoshop Align & Distribute in photoshop 00:04:00 Mastering Precision in photoshop (guides, grids, rulers, snap) 00:12:00 Brushes & Digital Painting in Photoshop Brush basics, the color panel & symmetrical drawing in photoshop 00:15:00 brushes panel & Getting cool photoshop brushes 00:06:00 Creating Photoshop brushes & brush settings 00:12:00 Digital painting Essentials, mixer brush & color replacement brush tools 00:10:00 Digital painting essentials tutorial in Photoshop 00:09:00 Updated Presets (photoshop 2020) 00:03:00 Drawing & Vector Shapes in Photoshop Vector shapes tools & essentials in Photoshop 00:10:00 Unified Transformation (Photoshop CC 2020) 00:02:00 Live shapes & Path operations in photoshop 00:06:00 Selection & Masking in Photoshop Photoshop's Selection concept & basics pt1 00:12:00 Photoshop's Selection concept & basics (part 2) 00:03:00 Photoshop's Selection tools (part 1) 00:13:00 Photoshop's Selection tools (part 2) 00:05:00 Object selection tool (photoshop 2020) 00:04:00 Photoshop Masking & Non destructive editing 00:21:00 Focus range combined with Photoshop's selection tools 00:07:00 Color range selection & photo manipulation techniques 00:11:00 Soft Edges selection tricks in Photoshop 00:07:00 Pen tools & curvature tool & vector masks in Photoshop 00:14:00 Smart Objects in Photoshop Raster smart objects in Photoshop 00:05:00 Vector smart objects & Photoshop's linked files 00:11:00 Smart Objects To Layers (Photoshop CC 2020) 00:01:00 Photoshop's smart Filters 00:13:00 Adjustments Layers in Photoshop Photoshop Adjustment Layers Fundamentals 00:06:00 Color Adjustment layers in Photoshop 00:17:00 Exposure in Photography explained 00:02:00 Tonal & contrast Adjustment layers in Photoshop 00:16:00 Image Retouching & Manipulation in Photoshop Photoshop Liquify Filter 00:11:00 Spot healing brushes & Patch tool (Photoshop Retouching tools) 00:08:00 Content Aware fill (Photoshop CC) 00:05:00 Content Aware fill update (Photoshop 2020) 00:01:00 Content Aware Scaling (Enlarging images without distortion in Photoshop) 00:11:00 Content-Aware: move-extend tool (Photoshop CC) 00:05:00 Clone Stamp tools & smudge tool (Photoshop) 00:16:00 Dodge, burn & sponge tools (Photoshop) 00:06:00 Photoshop Retouching project pt1 (Editing (Camera Raw settings)) 00:10:00 Photoshop Retouching project pt2 (body,Skin,hair,shadows highlights) 00:16:00 Photoshop Retouching project pt3 (eyes) 00:12:00 Photoshop Retouching project 4 (Final blending touch) 00:01:00 fix & whiten Teeth in Photoshop (Natural look) 00:06:00 Photoshop Project: Repairing damaged images & coloring them pt1 (fixing) 00:20:00 Photoshop Project: Repairing damaged images pt2 (coloring) 00:08:00 Creating Mockups using Vanishing point 00:07:00 Clone stamp in Vanishing point 00:06:00 Enhanced Filters (Photoshop CC 2020) 00:04:00 Typography in Photoshop Font Selection & filtering in Photoshop 00:06:00 Photoshop Character control panel 00:05:00 Photoshop Paragraph Control Panel 00:09:00 Text Improvements (Photoshop CC 2020) 00:03:00 Photoshop Character & Paragraph Styles Panel 00:08:00 3D Neon Type effect (Nike Ad) 00:15:00 Photoshop Advanced Type details 00:10:00 Text warp & typing on a path in Photoshop 00:11:00 Animated Gifs & Video editing in Photoshop Creative Typography design ideas 00:07:00 Creating Animated Gifs & Videos in Photoshop 00:13:00 Save As gifs (Photoshop CC 2020) 00:01:00 Video editing in photoshop (complete video project) 00:19:00 Finalizing & Exporting Files from photoshop Preparing our files for printing & creating pdf files from photoshop 00:10:00 Image Optimization & Save for web 00:08:00 Import from device (Photoshop CC 2020) 00:01:00 3D in Photoshop Turning images 2D into 3D in Photoshop 00:08:00 3D Layers & moving cameras & elements in Photoshop 3D Mode 00:16:00 Adding materials & saving 3D views in Photoshop 00:07:00 Lights in 3d & exporting from photoshop 00:11:00 Creating 3D Animation in Photoshop 00:03:00 Assessment Assessment - Photoshop CC - Beginners To Advanced 00:10:00 Certificate of Achievement Certificate of Achievement 00:00:00 Get Your Insurance Now Get Your Insurance Now 00:00:00 Feedback Feedback 00:00:00

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.

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.

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.

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.

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.