2998 Development courses in Sheffield delivered Live Online

Face to face training customised and bespoke. Online or Face to Face

Duration 3 Days 18 CPD hours This course is intended for CxO?s IT Managers/ Directors Senior Project Officers Project & Program Coordinator/Managers Operations Managers Quality Managers Business Analysts Engineering Managers IT Infrastructure Managers Internal Consultants Professional Consultants Overview Change and the individual Change and the organization Communication and stakeholder engagement Change practice Dealing with change and more importantly, the impact of change is a high priority for all organisations. The Change Management Certification has been developed by APMG in partnership with the Change Management Institute (CMI), an independent, global professional association of change managers. Together they have developed a professional ?body of knowledge? for the discipline of change management. This body of knowledge now provides an independent benchmark for the professional knowledge expected of an effective change manager. APMG?s refreshed Change Management certification is fully aligned with the change management body of knowledge. Prerequisites There is no prerequisite to attending this foundation course, although it is recommended that candidates should have a good understanding of business practices. 1 - Change and the Organization Drivers for change Developing a vision Culture and climate Emergent change and lifecycle Organizational metaphors Models of change Roles required for change 2 - Stakeholders Principles Identification Analysis Influencing and listening Emotion and demonstration Communications Cognitive biases Remaining people focused Improving Communications Communications channels Collaboration Communications Planning Larger workshops 2 - Change Impact Assessing impact McKinsey 7 S Stakeholder impact assessment Assessing change readiness Large change ? how to staff Building a change team Preparing for resistance Building team effectiveness 4 - Individual Change Learning theory Motivation Change Curve Personality differences

We are excited to announce the Online version of the Step by Step Course. It will include live demonstrations of the process that you will then follow. Unique opportunity to be guided step by step and experience meditative practice of icon painting.

Learn AutoCAD Evening Training Course. Clickhere for info This Autodesk AutoCAD 2D Introduction Evening Course is ideal for students who are completely new to the software and for those looking to produce advanced 2D plans, elevations and sections, as well as understanding all key tools in AutoCAD 2D. Call 02077202581 or WhatsApp 07970325184. Duration: 10 hrs. Method: 1-on-1, Personalized attention Schedule: Tailor your own slots, available from Mon to Sat between 9 am and 7 pm. Flexible Evening Sessions: Learn at your pace with evening classes. Comprehensive Skill Development: Master 2D Plans, Sections and Elevations. Industry-Standard Knowledge: Gain proficiency sought by employers. Practical Application: Apply skills to real-world design scenarios. Recorded Lessons for Review: Revisit course material anytime. Lifetime Email Support: Get ongoing assistance even after course completion. Course Duration: 10 hours Course Overview: AutoCAD 2D Training Course Designed for beginners, this course teaches the fundamentals of AutoCAD 2D software. Participants will learn essential tools and features to create, edit, and annotate 2D drawings. By course completion, students will confidently produce their own 2D drawings using AutoCAD. Introduction to AutoCAD 2D Overview of AutoCAD 2D software Understanding the user interface Navigating the drawing area Setting up drawing units and limits Creating basic shapes and lines Drawing Tools Utilizing Line, Circle, and Arc tools Implementing Polyline and Spline tools Adding dimensions and annotations Understanding layers and object properties Creating and inserting blocks into drawings Editing Tools Using Erase, Move, and Copy tools Implementing Rotate and Scale tools Understanding grips and grip editing Utilizing Trim and Extend tools Exploring fillets and chamfers Advanced Drawing Tools Utilizing Offset and Mirror tools Implementing Array and Divide tools Understanding hatching and gradient fills Adding text and multiline text Incorporating tables and fields into drawings Final Project Completing a final project using all learned tools and features Instructor-guided process to create a personal 2D drawing with AutoCAD Q&A and review of course material Assessment: Submission of the final project Active participation in class exercises and discussions Requirements: AutoCAD 2D software installed on the student's computer Basic computer skills and familiarity with the Windows operating system A laptop or desktop computer with a minimum of 4GB RAM and a 64-bit operating system.

Unconscious bias from a fresh new perspective for anyone who interacts with, or makes decisions about, people; whether you work with customers, supervise staff or work in collaboration, this session will enhance your insight and interactions.

Duration 3 Days 18 CPD hours This course is intended for This course is intended for information workers and data science professionals who seek to use database reporting and analysis tools such as Microsoft SQL Server Reporting Services, Excel, Power BI, R, SAS and other business intelligence tools, and wish to use TSQL queries to efficiently retrieve data sets from Microsoft SQL Server relational databases for use with these tools. Overview After completing this course, students will be able to: - Identify independent and dependent variables and measurement levels in their own analytical work scenarios. - Identify variables of interest in relational database tables. - Choose a data aggregation level and data set design appropriate for the intended analysis and tool. - Use TSQL SELECT queries to produce ready-to-use data sets for analysis in tools such as PowerBI, SQL Server Reporting Services, Excel, R, SAS, SPSS, and others. - Create stored procedures, views, and functions to modularize data retrieval code. This course is about writing TSQL queries for the purpose of database reporting, analysis, and business intelligence. 1 - INTRODUCTION TO TSQL FOR BUSINESS INTELLIGENCE Two Approaches to SQL Programming TSQL Data Retrieval in an Analytics / Business Intelligence Environment The Database Engine SQL Server Management Studio and the CarDeal Sample Database Identifying Variables in Tables SQL is a Declarative Language Introduction to the SELECT Query Lab 1: Introduction to TSQL for Business Intelligence 2 - TURNING TABLE COLUMNS INTO VARIABLES FOR ANALYSIS: SELECT LIST EXPRESSIONS, WHERE, AND ORDER BY Turning Columns into Variables for Analysis Column Expressions, Data Types, and Built-in Functions Column aliases Data type conversions Built-in Scalar Functions Table Aliases The WHERE clause ORDER BY Lab 1: Write queries 3 - COMBINING COLUMNS FROM MULTIPLE TABLES INTO A SINGLE DATASET: THE JOIN OPERATORS Primary Keys, Foreign Keys, and Joins Understanding Joins, Part 1: CROSS JOIN and the Full Cartesian Product Understanding Joins, Part 2: The INNER JOIN Understanding Joins, Part 3: The OUTER JOINS Understanding Joins, Part 4: Joining more than two tables Understanding Joins, Part 5: Combining INNER and OUTER JOINs Combining JOIN Operations with WHERE and ORDER BY Lab 1: Write SELECT queries 4 - CREATING AN APPROPRIATE AGGREGATION LEVEL USING GROUP BY Identifying required aggregation level and granularity Aggregate Functions GROUP BY HAVING Order of operations in SELECT queries Lab 1: Write queries 5 - SUBQUERIES, DERIVED TABLES AND COMMON TABLE EXPRESSIONS Non-correlated and correlated subqueries Derived tables Common table expressions Lab 1: Write queries 6 - ENCAPSULATING DATA RETRIEVAL LOGIC Views Table-valued functions Stored procedures Creating objects for read-access users Creating database accounts for analytical client tools Lab 1: Encapsulating Data Retrieval Logic 7 - GETTING YOUR DATASET TO THE CLIENT Connecting to SQL Server and Submitting Queries from Client Tools Connecting and running SELECT queries from: Excel PowerBI RStudio Exporting datasets to files using Results pane from SSMS The bcp utility The Import/Export Wizard Lab 1: Getting Your Dataset to the Client Additional course details: Nexus Humans 55232 Writing Analytical Queries for Business Intelligence 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 55232 Writing Analytical Queries for Business Intelligence 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.

Immerse yourself in a comprehensive one-day virtual update course dedicated to diabetes, tailored for healthcare professionals already actively engaged in this field.  This engaging program is open to all registered healthcare practitioners, encompassing General Practitioners, Pharmacists, Paramedics, Practice Nurses, Nurse Practitioners, Advanced Nurse Practitioners, and Nursing Assistants. Upon completion of this enlightening day, participants will emerge with heightened confidence in their ability to practice with up-to-the-minute proficiency in managing diabetes. This course covers the latest trends in diabetes management, encompassing a thorough understanding of cutting-edge pharmacological interventions utilised in diabetes care. Agenda (Please note that this outline provides a general overview and may experience minor adjustments.) 09:15 - Coffee and Registration 09:30 - Introduction and Course Objectives 09:45 - Comprehensive Update on Diabetes Classifications 10:00 - Key Statistical Insights 10:15 - Unraveling Metabolic Syndrome 11:00 - Coffee Break 11:20 - Navigating Diabetes Prevention 12:00 - Unpacking Diagnostic Criteria 12:45 - Lunch Break 13:30 - Guideline Refinements in Diabetes Management 14:15 - Effective Support for Lifestyle Modifications 14:30 - Exploring Pharmacological Approaches 15:30 - In-depth Study of Insulin and Continuous Glucose Monitoring (CGM) 16:00 - A Holistic View of Hypoglycemia and its Management 16:15 - Real-world Case Studies 16:30 - Session Conclusion   Anticipated Learning Outcomes   · Revitalize and reinforce your comprehension of diabetes. · Scrutinize novel and ongoing trends in diabetes management. · Stay current with the latest pharmacological advances in diabetes care. · Foster open dialogues addressing practical challenges and their remedies. · Recognize the significance of continuous professional development and the apt handling of concerns. Elevate your expertise and proficiency in diabetes management with this immersive update course, designed to empower healthcare professionals in the realm of primary care.

Course Overview   - Target Audience: General practice clinicians, including nurses and allied healthcare professionals. - Cost: £150 per place + VAT. - Duration: 1 days, with one day dedicated to issues surrounding men's health - Delivery Format: Virtual via Zoom This day is most suited to Nurse Associates, Practice Nurses, NP's, ENP's, Paramedics and Pharmacists. Dr Tamara Cunningham is an experienced GP Trainer and will be teaching these interactive, online days. Men's Health Update Day  Learning Objectives:   1. Understand the Latest Guidelines and Best Practices in Erectile Dysfunction (ED) Management: Participants will gain an in-depth understanding of the current guidelines and effective treatment strategies for ED, including pharmacological and non-pharmacological options. 2. Expertise in Diagnosing and Treating Premature Ejaculation and Sexual Health Issues: This outcome focuses on equipping attendees with the skills to diagnose premature ejaculation accurately, understand its psychological impact, and explore various treatment methods. 3. Interpretation and Application of NICE Guidelines for Prostate Health: Participants will learn how to interpret and apply the latest NICE guidelines for the management of prostate-related conditions, emphasizing evidence-based practices. 4. Comprehensive Understanding of Lower Urinary Tract Symptoms (LUTS) in Men: The training will provide knowledge about the etiology, diagnosis, and management of LUTS, including differentiating between various underlying causes. 5. Integrating Mental Health in Men's Health Care: This outcome focuses on understanding the intersection of mental health and men's physical health, recognizing common mental health issues in men, and integrating mental health assessment and referral pathways in primary care settings. 6. Effective Communication Skills for Discussing Sensitive Men's Health Issues: Enhance communication skills for healthcare professionals to engage effectively and sensitively with male patients about their health concerns, particularly in areas of sexual health and mental well-being. 7. Case Studies and Real-world Application: Through interactive case studies, participants will apply their knowledge in real-world scenarios, enhancing their practical skills in managing men's health issues. 8. Updates on Research and Emerging Trends in Men's Health: Attendees will be briefed on the latest research developments and emerging trends in men's health, preparing them to stay informed about future advancements. 9. Network and Share Best Practices: An opportunity for attendees to network with peers, share best practices, and discuss challenges and solutions in men's health care. 10. Reflective Practice and Continuous Professional Development: Encourage participants to reflect on their current practice, identify areas for improvement, and understand the role of continuous learning in providing high-quality men's health care.

This highly interactive program focuses on building the business focus on value to be achieved from initiatives. The practices in this program apply equally to projects and programs. Participants will gain insight into the capabilities needed to develop the culture, processes, and tools behind validation, what true initiatives' success looks like, which can be closely linked to achieving value. They will learn and experiment with a variety of value definition and management techniques. Working in small groups, they will collaborate with others to brainstorm, share experiences, and apply concepts to the ongoing value confirmation goal. Participants will also discover the importance of designing metrics around value and addressing blind spots that could happen when the focus is on the wrong metrics and how that could lead to the wrong behaviors being practiced. Participants will also gain insights into key skills for leading and working in the future. Hands-on experimentation activities enhance the theoretical learning, grounding it in real life and giving opportunities to practice creativity in capturing value.

Join the Historical Association and the Royal Geographical Society at this special online twilight forum event specifically for primary teachers of history and geography. The theme this time will be climate education and how primary teachers can develop this through their history and geography lessons. With a keynote speaker and workshop sessions from Ailsa Fidler and Emma Espley, plus an opportunity to network and share ideas, this event will support primary teachers to better understand how history and geography can feed into the responsibility of every curriculum subject to educate our young people about the climate crisis and sustainable futures.