3114 Management courses in Loughton delivered Live Online

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.

Vectorworks Evening Course face to face One to one

Duration 2 Days 12 CPD hours This course is intended for Operators and application owners who are responsible for deploying and managing policies for multiple Kubernetes clusters across on-premises and public cloud environments. Overview By the end of the course, you should be able to meet the following objectives: Describe the VMware Tanzu Mission Control architecture Configure user and group access Create access, image registry, network, security, quota, and custom policies Connect your on-premises vSphere with Tanzu Supervisor cluster to VMware Tanzu Mission Control Create, manage, and backup Tanzu Kubernetes clusters Perform cluster inspections Monitor and secure Kubernetes environments During this two-day course, you focus on using VMware Tanzu© Mission Control? to provision and manage Kubernetes clusters. The course covers how to apply access, image registry, network, security, quota, and custom policies to Kubernetes environments. For cluster provisioning and management, the course focuses on deploying, upgrading, backing up and monitoring Kubernetes clusters on VMware vSphere© with Tanzu. Given the abstractions of VMware Tanzu Mission Control, the learnings should be transferrable to public cloud. Introducing VMware Tanzu Mission Control VMware Tanzu Mission Control Accessing VMware Tanzu Mission Control VMware Cloud? services access control VMware Tanzu Mission Control architecture Cluster Management Attached clusters Management clusters Provisioned clusters Cluster inspections Data protection VMware Tanzu© Observability? by Wavefront VMware Tanzu© Service Mesh? Policy Management Policy management Access policies Image registry policies Network policies Security policies Quota policies Custom policies Policy insights

Why Choose Rhino Introduction to Intermediate Training Course? Learn: 3D NURBS models. Master: Surfacing modeling. Interface: Rhino's navigation. Rendering Skills: Enhance presentations with Rhino renderings. Check our Website Flexible Scheduling: 1-on-1 training sessions according to your convenience. Choose any hour between 9 a.m. and 7 p.m., Mon to Sat. You can call us at 02077202581 to book over the phone. Duration: 10 hours. Methods: Personalized training either in-person, or live online. Introduction and Navigation Become acquainted with Rhino's interface, menus, and screen layout. Efficiently traverse through Rhino models, ensuring precision in 2D lines, polylines, and NURBS curves. Utilize modeling setup features, incorporating constraints like snap, ortho, and planar for accuracy. Leverage object snaps and Smart Track functionality to enhance precision. Solid and Surface Modeling Develop rapid 3D solids and surfaces, employing Rhino's organized layering system. Utilize coordinates and constraints for meticulous modeling, exploring 3D space and elevations. Create diverse shapes, such as rectangles, circles, arcs, ellipses, and polygon curves. Elevate models with Rhino render and render color, incorporating free-form curves, helix, and spiral curves. Efficiently handle model views with pan, zoom, and view management tools. Implement various editing commands for curve manipulation and transform curves into surfaces and solids. Utilize history tracking for advanced editing and execute general editing actions: move, copy, rotate, mirror, and scale. Create arrays with both polar and rectangular arrangements and employ boolean operations like union, difference, and intersection. Offset curves and surfaces effectively, ensuring meticulous detailing. Intermediate Edit and Surfacing Introduce key NURBS modeling concepts and terminologies. Edit curves and surfaces via control point manipulation and rebuild them for optimal refinement. Employ the nudge modeling aid for precise adjustments and generate deformable shapes. Create curves through projection techniques and split surfaces using curves and surfaces. Blend surfaces seamlessly, utilizing symmetry tools, lighting, and rendering effects. Convert intricate 3D objects into detailed 2D drawings, expertly crafting page layouts. Advanced Surfacing and Solid Modeling Construct model primitives and solid text, employing techniques such as pipe and extrusion. Modify solids efficiently using Boolean tools, expanding your surface modeling capabilities. Employ techniques like extrusion, lofting, and revolving for intricate surfaces. Create sweeps using 1 and 2 rail curves, mastering surface network techniques for complex shapes. Upon completion, you will: Master Rhino Tools: Navigate interfaces, utilize advanced tools for precise modeling, and employ features like object snaps and Smart Track. Expert Solid and Surface Modeling: Develop intricate 3D solids and surfaces, create diverse shapes, and use Rhino render effectively. Advanced Editing Skills: Apply intermediate and advanced editing techniques, including symmetry tools and realistic rendering. Precision Modeling: Utilize coordinates, constraints, and advanced aids for accurate detailing and problem-solving. Professional Project Execution: Create high-quality renderings, 2D drawings, and polished 3D models for real-world design scenarios. Upon completion, you'll be adept at 3D modeling, product design, and architecture, positioning you as a valuable asset in the design industry. Why Choose Our Rhino Courses? Rhino, also known as Rhinoceros, stands as a robust 3D computer graphics and computer-aided design software, utilized extensively in domains like architecture, industrial design, and multimedia. Our Rhino courses are meticulously crafted to empower you in mastering this software. Led by seasoned instructors, our courses provide a comprehensive understanding of Rhino, enabling you to create exceptional designs. Rhino 3D Training: Our Rhino 3D training caters to beginners and those seeking advanced techniques. Course Highlights: Precise 3D Modeling: Master free-form 3D NURBS models with precision. Advanced Functionality: Explore Rhino's features, including advanced surfacing commands. User Interface Mastery: Navigate Rhino's interface and hone skills in curves, surfaces, and solids. Expert Guidance: Acquire expertise in Rhino's modeling environment under expert guidance. Modeling Techniques: Learn free-form and precision modeling techniques. Modeling Aids: Utilize tools for accurate modeling and create basic Rhino renderings. Benefits of our Courses: Expert Guidance: Receive instruction from experienced architects and designers, providing practical, real-world insights for comprehensive learning. Comprehensive Resources: Access bespoke video tutorials for additional learning and reference, enhancing your understanding of the course materials. Digital Reference Material: Receive a digital reference book to support your revision efforts, providing a comprehensive resource for your studies. Ongoing Support: Enjoy free after-support through phone or email even after course completion, ensuring continuous assistance and guidance. Tailored Learning Experience: Customize your learning journey by adapting the syllabus and projects to align with your specific needs and interests, fostering a personalized educational experience. Certificate: Upon completion, earn a certificate from us, validating your achievement and recognizing your expertise in the field.

Duration 5 Days 30 CPD hours This course is intended for Red Hat Certified System Administrator (RHCSA) who wants to learn how to provision and configure IdM technologies across both Linux and Windows applications Identity management specialist or engineer Access management specialist or engineer Web application developer DevOps specialist Overview As a result of attending this course, you will gain an understanding of the architecture of an identity management realm and trusted relationships using both Red Hat Enterprise Linux Identity Management and Microsoft Active Directory. You will be able to create, manage, and troubleshoot user management structures, security policies, local and remote secure access methods, and implementation technologies such as Kerberos, PKI, and certificates. You should be able to demonstrate these skills: Create and manage a scalable, resilient Identity Management realm, including both Linux and Microsoft Windows clients and servers. Create and manage secure access configurations, including managing and troubleshooting Kerberos, certificate servers, and access control policies. Integrate IdM as the back end for other major enterprise tools in the Red Hat portfolio, including Satellite Server and Tower. This course will empower you with the skills to configure and manage IdM, the comprehensive Identity Management solution bundled with Red Hat© Enterprise Linux.You will master these skills on the most requested Red Hat Identity Management (IdM) capabilities, including Active Directory trusts, multi-product federation, configuration management with Ansible, integrated certificate management, single sign-on, one-time passwords, and cybersecurity policy conformance. This course covers the same material as RH362, but includes the Red Hat Certified Specialist in Identity Management exam (EX362). Install Red Hat Identity Management Describe and install Red Hat Identity Management (IdM). Centralize Identity Management Explain the IdM server services, explore IdM clients access methods, and install an IdM client. Authenticate identities with Kerberos Define the Kerberos protocol and configure services for Kerberos authentication. Integrate IdM with Active Directory Create a trust relationship with Active Directory. Control user access Configure users for authorized access to services and resources. Manage a public key infrastructure Manage certificate authorities, certificates, and storing secrets. Maintain IdM operations Troubleshoot and recover Identity Management. Integrate Red Hat products with IdM Configure major services to share the IdM authentication database. Install scalable IdM Construct a resilient and scalable Identity Management topology.

Duration 2 Days 12 CPD hours Overview Install and initialize WEM and integrate into Citrix Virtual Apps and Desktops and Citrix DaaS. Configure WEM features to improve the end user environment and virtual resource consumption. Migrate an on-premises WEM deployment to WEM service Designed for experienced IT professionals, you will discover why WEM is the go-to system optimization and logon optimization solution for a Citrix deployment's app and desktop workloads. You will learn how to plan, build, rollout, and manage on-premises WEM or WEM service and how to integrate it into Citrix Virtual Apps and Desktops or Citrix DaaS. You will leave this course with a good understanding of how to manage additional solutions and features in your Citrix Virtual Apps and Desktop or Citrix DaaS site Module 1: Introduction to Workspace Environment Management (WEM) WEM Features and Benefits Module 2: Planning ? WEM Architecture and Component Communications WEM On-Premises Components and Deployments WEM Service Components and Deployments WEM Component Communication Workflows Module 3: Planning - WEM On-Premises Deployment Installation On-Premises WEM: Leading Practice Installation Prerequisites and Steps On-Premises WEM: ADMX Template Configuration Choosing a Security Principal to run the WEM Infrastructure Service Creating the WEM Database Running the WEM Infrastructure Service Configuration Utility On-Premises WEM: Agent Installation Module 4: Planning ? WEM Service Deployment Installation WEM On-Premises vs WEM Service WEM Service: Leading Practice Installation Prerequisites and Steps WEM Service: ADMX Template Configuration WEM Service: Agent Installation Module 5: Planning ? WEM Consoles and Initial Setup On-Premises WEM and WEM Service Consoles WEM Initial Setup Migrating GPO settings to WEM Module 6: Planning ? WEM System and Log On Optimization WEM System Optimization Overview WEM CPU Management WEM Memory Management Additional System Optimization Features WEM Log On Optimization Overview WEM Assigned Actions WEM Environmental Settings Citrix Profile Management In WEM Module 7: Planning ? WEM Security and Lockdown Features WEM Security Management Features Privilege Elevation and Process Hierarchy Control WEM Transformer Module 8: Planning - The WEM Agent WEM Settings Processing and WEM Agent Caches WEM Agent Integration with Citrix Virtual Apps and Desktops and Citrix DaaS Module 9: Planning ? WEM Monitoring, Reporting, and Troubleshooting WEM Monitoring and Reporting WEM Agent Troubleshooting WEM Service Troubleshooting Module 10: Planning ? Upgrading WEM and Migration to WEM Service Upgrading Workspace Environment Management WEM On-Premises Migration to WEM Service Module 11: Rolling Out a WEM Deployment WEM Agent User Options on Windows Desktops Module 12: Managing a WEM Deployment Measuring WEM Success Additional course details: Nexus Humans CWS-220 Citrix Workspace Environment Management Deployment and Administration training program is a workshop that presents an invigorating mix of sessions, lessons, and masterclasses meticulously crafted to propel your learning expedition forward. This immersive bootcamp-style experience boasts interactive lectures, hands-on labs, and collaborative hackathons, all strategically designed to fortify fundamental concepts. Guided by seasoned coaches, each session offers priceless insights and practical skills crucial for honing your expertise. Whether you're stepping into the realm of professional skills or a seasoned professional, this comprehensive course ensures you're equipped with the knowledge and prowess necessary for success. While we feel this is the best course for the CWS-220 Citrix Workspace Environment Management Deployment and Administration course and one of our Top 10 we encourage you to read the course outline to make sure it is the right content for you. Additionally, private sessions, closed classes or dedicated events are available both live online and at our training centres in Dublin and London, as well as at your offices anywhere in the UK, Ireland or across EMEA.

This comprehensive one-day course is designed to empower registered healthcare professionals (HCPs) practicing in primary care with the latest advancements and insights in the field of asthma care. Building on the participants' existing expertise, this update day aims to enhance their proficiency in managing asthma effectively and providing the highest level of patient care. Target Audience: Exclusively tailored for registered healthcare professionals already experienced in asthma care within the primary care setting, this course is a unique opportunity for these practitioners to stay current with the latest developments in the field. Course Benefits: This Asthma Update Day is a prime opportunity for seasoned primary care healthcare professionals to deepen their expertise in asthma care. By staying current with the latest developments, practitioners can enhance their ability to provide high-quality, up-to-date patient care. The course encourages interactive learning, networking, and problem-solving, fostering a dynamic and collaborative learning environment. Prerequisites: This course is exclusively designed for registered healthcare professionals already actively practicing in the field of asthma care within the primary care setting. Outcome: Participants will leave the course armed with new insights, strategies, and approaches to further elevate their asthma care practice, ultimately improving patient outcomes and contributing to the advancement of respiratory healthcare within primary care. Asthma Update Day - Learning Objectives · Understanding Asthma Diagnosis Essentials o Gain insight into the latest diagnostic criteria and techniques for asthma. o Discuss the challenges and methods in accurately diagnosing asthma in children.   · Investigative Tests and Guideline Exploration o Review the range of investigative tests available for diagnosing and managing asthma. o Examine the current BTS/NICE & GINA Guidelines and their application in clinical practice.   · Pharmacological Treatments and Inhaler Techniques o Update knowledge on the pharmacology of asthma treatments. o Develop practical skills in various inhaler techniques and understand their importance in patient care.   · Personalised Asthma Management o Understand the factors influencing the choice of inhalers. o Learn to develop and implement Personalised Asthma Action Plans (PAAPs). o Explore SMART/MART therapy and its role in managing asthma.   ·  Managing Asthma Exacerbations o Identify and manage asthma exacerbations effectively. o Discuss strategies for preventing and managing severe asthma episodes.   · Application Through Case Studies o Engage in interactive case studies to apply learning in real-world scenarios. o Encourage the sharing of experiences and best practices among participants.   ·  Conclusion and Future Directions o Summarise key takeaways from the day's sessions. o Discuss future trends and areas for continued professional development in asthma care.   Through the "Asthma Update Day" course, clinicians will leave with an elevated level of confidence and competence, empowered to provide enhanced asthma care and positively influence patient outcomes within the primary care setting.

Overview This is a 2 day course to learn ALM tools to achieve strong and market-resilient, actuarially-resilient Solvency 2 (S2) ratios at Group consolidated level and at key cash-remitting entities to ensure dividend stability. For those not fully familiar with Solvency 2, this course is best taken in conjunction with “Solvency 2” Who the course is for Capital management / ALM / risk management staff within insurance company Investors in insurance company securities – equity, subordinated bonds, insurance-linked securities Salespeople covering insurance companies Course Content To learn more about the day by day course content please click here To learn more about schedule, pricing & delivery options, book a meeting with a course specialist now

Join us at our Sustainability Summit for SMEs to learn how to build thriving businesses and resilient supply chains in a fun and interactive Refund Policy Contact the organiser to request a refund.Eventbrite's fee is nonrefundable. About this event Event lasts 5 hours 30 minutes Sustainability Summit for SMEs: Thriving Businesses and Strong Supply Chains! Welcome to the Sustainability Summit 2024, a 1-day online event focused on sustainability for founders and senior decision makers in small and medium enterprises (SMEs), including those in the supply chains of larger organisations! In today’s dynamic business landscape, sustainability isn't just a buzzword; it's a necessity. Small and medium size enterprises must go beyond policy statements and adopt cohesive, actionable strategies to thrive. WHEN Date: Tuesday, 22 October 2024 Time: 10:00 AM – 3:15 PM (BST) Where: online (virtual event) This online Sustainability Summit will cover essential topics such as: Marketing, HR (skills and talent development), Low-carbon digital assets, Procurement, Finance and ESG. It will feature Guest Speakers, dynamic panel discussions and real-world case studies. Designed with small and medium enterprises at the centre, this learning event promises to be inspiring and thought provoking. Speakers will provide practical, actionable insights for immediate implementation as well as share effective ways to enable you to be more adaptable in the medium to long-term. Book now to participate from the comfort of your workplace [or your home office]. Our lineup of speakers include: Prof. Dave Spicer, Director of Business & Community Engagement, Univ. of Bradford Richard Clarke, Founder and Managing Director of Highland Carbon Tracy Cartwright, SHEQ Consultant and Director of Applaud Business Consultancy Antony Gutsa, Founder & CEO of Ecoswap and Banking Professional Giles Metcalfe, Ethical Marketer at Giles Metcalfe Digital Carolyn McGarry Williams, Co-Founder of 4 My Card and Director of Marketing Trevor Gibbs, Web Accessibility Specialist Amelia Banful, Head of Business Strategy, Enviro Electronics Dr Veronica Broomes, Founder of Sustainability Support Service & Sustainability Expert David Conner, Founder at 2030hub & Global Goals Week Organiser BENEFITS: reasons why you should attend Expert Insights: Hear from Guest Speakers and Panellists about the latest trends in sustainability and forthcoming changes in policies and legislation. Real-world case studies: Discover success stories from other SMEs that integrated multiple facets of sustainability for business benefits. Innovative Strategies: Learn actionable approaches to embed sustainability in your business and how to showcase this to win new business and talent for the future. Future-proof your business: Get inspired by new processes and up-skilling opportunities. Equip yourself with the knowledge to adapt and thrive. Networking: Connect with attendees during an interactive and fun 'lunchtime' session. PRICE: from £97.00 PLUS BONUSES: YOUR SWAG BAG GIFTS: *Personalised digital business card: discounted price for 1 year subscription for attendees. [Usual price: £65 or US$70] *Eco-friendly gift card: 10% OFF *Sustainability Calendar 2025: 40% OFF for attendees [You save £27 or US$29] DONATION TO CHARITY Our commitment to People, Planet and Communities (business, geographic, places) is ongoing. For this 2024 Sustainability Summit [online], we will donate 1% of ticket price (ex. VAT) to The Rotary Foundation, our global charity of choice. WHO SHOULD ATTEND This Sustainability Summit is ideal for: • Business Founders and Senior Leaders: Gain strategic insights and learn practical actions to embed sustainability in your organisation’s DNA. • SMEs in Supply Chains: Understand how to meet the sustainability expectations of larger organisations and enhance your competitiveness. • Procurement and HR Professionals: Update your knowledge and gain useful insights about varied road maps to evidence sustainability -multiple pillars: planet, people for high social impact, ESG. Don’t miss this chance to learn more about how your business can be at the forefront and boost competitiveness with embedding sustainability for environmental, social and economic benefits. BOOK YOUR PLACE NOW https://www.eventbrite.co.uk/e/sustainability-summit-for-smes-thriving-businesses-and-strong-supply-chains-tickets-993387768557 DON'T MISS OUT Don't miss this opportunity to learn in a dynamic virtual meeting, network with business leaders and founders in a professional environment and gain the knowledge you need to take your business to the next level with capable and resilient supply chains! #sustainabilitysummit, #onlinesustainabilityevent, #sustainabilitytraining, #CSR, #sustainabilityforSMEs, #businesssustainability #summit, #greenbusiness, #online, #supplychains, #planet #forpurpose #betterbusiness, #netzero, #conference

Facilitating Effective Meetings (Virtual) Billions of dollars and exorbitant amounts of time are wasted annually across the globe because of organizations' meeting practices. This contributes to serious performance problems for both organizations and employees, and it has a serious impact on culture and morale. But despite the costs and consequences, every-day people in any role have the ability to change that. They can reduce cost, improve productivity, and enhance their workplace cultures by improving their meeting facilitation skills. And that is because facilitation skills start in the planning stage, not in the live meeting stage. In this course, participants will learn that their responsibility as a facilitator is to be a steward of time, money, relationships, and performance. To do that, they will learn to estimate costs of meetings and practice a variety of strategic thinking and analysis tasks to effectively plan results-aligned meetings. They will also apply several techniques and strategies to proactively prevent and deal with conflict in meetings, as well as give objective, constructive feedback to others in order to create behavior change during meetings. Participants must bring laptops with them and have internet access during the course (both virtual classroom and traditional classroom). The laptops are needed for specific activities. Also note that this course pairs well with IIL's Conflict Resolution Skills and Decision Making and Problem Solving courses, which go much deeper into related skills and tools that support effective meeting facilitation. What you will Learn At the end of this program, you will be able to: Estimate the financial and time costs of attendance for real-world meetings Use a performance formula to define the purpose of meetings Describe the responsibilities and qualities of an effective facilitator Analyze situations to determine when a meeting is necessary Articulate performance-driven meeting goals and results Align meeting goals and results Strategize to invite, involve, and exclude appropriate attendees Explain research-based best practices for meeting decisions and agenda development Create an effective agenda for a results-driven meeting Apply proactive tools and strategies for relationship-building dealing with meeting conflict Give constructive behavioral feedback using the Situation-Behavior-Impact® technique Getting Started The Business Case for Effective Facilitation Embracing the research on meetings Estimating the real costs of meetings Determining a meeting's performance value Clarifying the meeting facilitator's role Facilitating the Meeting Plan Determining if a meeting is necessary Aligning meeting goals with meeting types Identifying the right attendees Creating a strategically effective agenda Facilitating the Live Meeting Building relationships from the start Dealing with conflict proactively Giving feedback on unproductive behavior Summary and Next Steps