3015 Dele courses

This OCN London accredited three-day course is unit one of the National Certificate in Workplace Mediation™. Essentials of Mediation™ covers the key areas to develop the core competencies required to undertake mediation casework within the workplace. The programme trains individuals to the highest standards in mediation best practice (via the FAIR mediation model), active listening, non-violent communication (NVC) and problem-solving.

PYTHON BOOTCAMP: This 12-week Python Data Analytics Data Boot Camp is designed to give you a complete skill set required by data analysts . You will be fully fluent and confident as a Python data analyst, with full understanding of Python Programming. From Data, databases, datasets, importing, cleaning, transforming, analysing to visualisation and creating awesome dashboards The course is a practical, instructor-lead program.

Tableau is an intuitive and simple tool to learn. This Tableau training course is a jumpstart to getting report writers and analysts who are self-taught or have no previous knowledge to being productive. It covers everything from connecting to data, through to creating interactive dashboards with a range of visualisations in three days. Having a quick turnaround from starting to use Tableau, to getting real, actionable insights means that you get a swift return on your investment. At the end of this course, you will be able to communicate insights more effectively, enabling your organisation to make better decisions, quickly. This accelerated approach is key to getting engagement from within your organisation so everyone can immediately see and feel the impact of the data and insights you create. Our Tableau Desktop Fast Track course combines all of our Foundation (Fundamentals) and Analyst (Intermediate) content into a 3 day live online course with added access to online bonus content of 3 additional modules. Gathering Requirements, Bring Your Own Data and Engaging Users. What do you get? This course is delivered live virtually and has all material provided through our online portal, together with email support and live coaching sessions. The full program includes all of the following elements: 3 days of live and interactive instructor-led sessions delivered by an expert Tableau Trainer 6 weeks access to our live coaching program delivered by expert Tableau coaches 50+ practical exercises to practice what you learn 12 months access to video’s that walk you through the theory and exercise solutions Practical advice, tools and resources for using Tableau in the real world The three additional online modules provide:Clarity on the approach to gathering dashboard requirements in a way that can be translated into dashboard designs.An agile and iterative development process that delivers products that meet user needs more quickly and effectively.An understanding of how end users will interact with dashboards to ensure that designers deliver actionable results. THE SYLLABUS PHASE 1: DESIGN MODULE 1: UNDERSTAND TABLEAU What is possible How does Tableau deal with data Know your way around Review of Type Conversions How do we format charts Dashboard basics – My first Dashboard MODULE 2: TRANSFORM DATA Connecting to and setting up data in Tableau Modifying data attributes How Do I Structure my Data – Groups & Hierarchies, Visual Groups How Tableau Deals with Dates – Using Discrete and Continuous Dates, Custom Dates How do I create calculated fields and why? – Creating Calculated Fields, Types of calculated fields, Row Level v Aggregations, Aggregating dimensions in calculations, Changing the Level of Detail (LOD) of calculations – What, Why, How MODULE 3: GATHER REQUIREMENTS(ONLINE CONTENT ONLY) Brainstorm and assess possible priorities Pitfalls to avoid Gather requirements PHASE 2: DEVELOP MODULE 4: CREATE CHARTS Charts that Compare Multiple Measures – Measure Names and Measure Values, Shared Axis Charts, Dual Axis Charts, Scatter Plots Showing progress over time Creating Tables – Creating Tables, Highlight Tables, Heat Maps Showing Relational & Proportional Data – Pie Charts, Donut Charts, Tree Maps Making things dynamic with parameters MODULE 5: COMBINE DATA Relationships Joining Tables – Join Types, Joining tables within the same database, cross database joins, join calculations Blending – How to create a blend with common fields, Custom defined Field relationships and mismatched element names, Calculated fields in blended data sources Unions – Manual Unions and mismatched columns, Wildcard unions Data Extracts – Creating & Editing Data extracts MODULE 6: ANALYSE INFORMATION Table Calculations Sets, Reference Lines, Trends and Forecasting Answering spatial questions – Mapping, Creating a choropleth (filled) map, Using your own images for spatial analysis, Mapping with spatial files Advanced charts Bar in Bar charts Bullet graphs Creating Bins and Histograms Creating a Box & Whisker plot Viz in Tooltips PHASE 3: DESIGN MODULE 7: BUILD DASHBOARDS Using the Dashboard Interface Device layouts Dashboard Actions – Set actions, Parameter actions Viz in Tooltips for Dashboards Dashboard containers – Horizontal & Vertical containers, Hidden containers Navigate between dashboards Telling data driven stories MODULE 8: BRING YOUR OWN DATA Design Best Practices & Resources Wireframe templates Questions Process Start building and testing MODULE 9: EMPOWER STAKEHOLDERS What is Tableau Server Publishing & permissions How can your users engage with content The Tableau ecosystem Review your progress Your next steps HOW MUCH OF YOUR TIME WILL THIS TAKE? Delegates are also provided 6 weeks access to our Tableau Coaching. We run Live Q&A sessions from 4pm-5pm on a Monday (Connecting to Data and Calculated Fields), 2pm-3pm Friday (Creating Charts) & 4pm-5pm Friday (Dashboard Design). The coaching helps delegates to transition from the theory of using Tableau to its practical use. We’d be expecting them to apply the exercises you’ll be doing during the course, onto your own data after the course. In our experience, this is the best way to increase both understanding and long term memory retention. The live coaching also acts as a troubleshooting platform for any practical issues that delegates need to overcome in the real world. Delegates also have 12 months access to all of the training material covered in the course in the form of an online portal (this includes theory videos, exercise solution videos, exercise materials and even quizzes). We have a growing LinkedIn community that delegates are encouraged to join and participate in. We regularly post useful blog posts and additional training that will enhance the Tableau journey and understanding. We help teams using Tableau to transform in the following ways : From a disjointed understanding of Tableau – To being familiar with Tableau terminology and capability From ad-hoc data uploads and error prone calculations – To reusable data connections and robust metrics From disjointed stakeholder questions – To clear and concise requirements that lead to decision making From being unsure how difficult Tableau will be to learn – To being able to develop standard charts and tables in Tableau with dynamic reporting capabilities From manually combining data for each analytical task – To dynamically combining data from multiple tables for analysis From being unsure how to answer analytical questions and what options there are – To being equipped with multiple actionable, dynamic, analytical use cases From not knowing Why, When and How to create Dashboards or Story’s – To being able to combine analysis to answer complex questions and tell data driven stories From using demo data theory – To Delivering value [Answering questions] on their own data From spending lots of time answering colleagues ad-hoc (data) questions – To empowering stakeholders in answering ad-hoc queries and reducing the time to analyse and steer the business

  The CIPT is the first and only certification of its kind worldwide. It was launched by the IAPP in 2014 and updated in early 2023 to meet the growing need that only tech pros can fill-securing data privacy at all stages of IT product and service lifecycles.  Whether you work in the public or private sector, data privacy skills are quickly becoming a must-have-and that's a great opportunity for you.  The CIPT certification also holds accreditation under ISO 17024: 2012 About This Course   What will you learn?   Critical data protection concepts and practices that impact IT Consumer data protection expectations and responsibility How to bake privacy into early stages of IT products and services for cost control, accuracy and speed-to-market How to establish data protection practices for data collection and transfer How to pre-empt data protection issues in the Internet of Things How to factor data protection into data classification and emerging tech such as cloud computing, facial recognition and surveillance How to communicate data protection issues with partners such as management, development, marketing and legal.   This course has two programmatic modules, the first four areas focus on the fundamentals of data protection. The second module takes the fundamentals and puts it into practice.   MODULE 1: Fundamentals of Information Privacy   Unit 1: Common Principles and Approaches to Privacy This unit includes a brief discussion of the modern history of privacy, an introduction to types of information, an overview of information risk management and a summary of modern privacy principles.   Unit 2: Jurisdiction and Industries This unit introduces the major privacy models employed around the globe and provides an overview of privacy and data protection regulation by jurisdictions and industry sectors.   Unit 3: Information Security: Safeguarding Personal Information This unit presents introductions to information security, including definitions, elements, standards and threats/vulnerabilities, as well as introductions to information security management and governance, including frameworks, controls, cryptography and identity and access management (IAM).   Unit 4: Online Privacy: Using Personal Information on Websites and with Other Internet-related Technologies This unit examines the web as a platform, as well as privacy considerations for sensitive online information, including policies and notices, access, security, authentication and data collection. Additional topics include children's online privacy, email, searches, online marketing and advertising, social media, online assurance, cloud computing and mobile devices.    MODULE 2: Privacy in Technology   Unit 1: Understanding the Need for Privacy in the IT Environment This unit highlights the impact that regulatory activities, security threats, advances in technology and the increasing proliferation of social networks have on IT departments.   Unit 2: Core Privacy Concepts This unit reveals how privacy compliance becomes more attainable through developing information lifecycle plans, data identification and classification systems and data flow diagrams.   Unit 3: Regulations and Standards Impacting Privacy in IT This unit introduces privacy laws, regulations and standards that can help IT professionals design better privacy programmes and systems to handle personal information throughout the data lifecycle.   Unit 4: Privacy in Systems and Applications This unit develops an understanding of the risks inherent in the IT environment and how to address them.   Unit 5: Online Privacy Issues This unit presents information about online threats, threat prevention and the role of IT professionals in ensuring proper handling of user data.   Unit 6: De-identifying and Anonymizing Personally Identifiable Information This unit reveals the importance of personally identifiable information and methods for ensuring its protection.   Unit 7: Cloud Computing This unit evaluates privacy and security concerns associated with cloud services, and standards that exist to advise on their use. Prerequisites   There are no prerequisites for this course but attendees would benefit from a review of the materials on the IAPP site. What's Included?   1 years membership of the IAPP  Refreshments & Lunch (Classroom courses only) Participant Guide Official Study Guides Official Practice Exam Official Q&A The Exam Fees Who Should Attend?   The CIPT credential shows you've got the knowledge to build your organisation's data protection structures from the ground up. With regulators worldwide calling for tech professionals to factor data protection into their products and services, the job market for privacy-trained IT pros has never been stronger. As a result, the CIPT is targeted towards; Data Protection Officers IT Managers and Administrators Records Managers System Developers IT Security specialists Accreditation Our Guarantee   We are an approved IAPP Training Partner. You can learn wherever and whenever you want with our robust classroom and interactive online training courses. Our courses are taught by qualified practitioners with a minimum of 25 years commercial experience. We strive to give our delegates the hands-on experience. Our courses are all-inclusive with no hidden extras.  The one-off cost covers the training, all course materials, and exam voucher. Our aim: To achieve a 100% first time pass rate on all our instructor-led courses. Our Promise: Pass first time or 'train' again for FREE. *FREE training offered for retakes - come back within a year and only pay for the exam.

A fabric manipulation and constructed textiles workshop, for Teachers of GCSE & A Level Textiles, for both Art & Design and Design & Technology.

Beginner-Intermediate practical small animal abdominal ultrasound workshop

This course examines the ability to plan and control the allocation of work within team members in order to maximise resources. Good delegation is based on clear objectives, regular reviews and sound feedback. It shows how delegation can provide a sound basis on which to improve productivity, engender ownership and responsibility whilst fostering individual growth and development.

Online Asset Management Course eLearning designed for experienced delegates looking to sit the IAM Certificate qualification and fill in some knowledge gaps

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.

UK Sedation & Mellow Dental Presents: The New Starter Sedation Course for Dentists and Dental Nurses With Dr Roy Bennett and Dr Robert Endicott Are you a dentist or Dental Nurse looking to expand your skills and provide a more comfortable experience for your patients? If so, we’ve got the perfect opportunity for you. Introducing our brand-new, comprehensive New Starter Sedation Course. This innovative course is brought to you by two leading names in dental education – UK Sedation and Mellow Dental. Our commitment is to empower you with the skills and confidence to provide effective sedation in your practice. The Starter Sedation Course spans two days, offering a blend of online and face-to-face learning for the best educational experience: 🌐 Day 1 – Online Learning: Dive into the theory of dental sedation from the comfort of your own home. Our expert instructors will guide you through comprehensive video tutorials, live webinars, and interactive quizzes, making learning both easy and engaging! 👥 Day 2 – Face-to-Face Workshop: Put your newfound knowledge into action with a hands-on, practical workshop held at one of our state-of-the-art training facilities. Here, you’ll learn directly from experienced professionals in a safe, supportive environment. Once those two parts are complete, you have all the theory training required to enter the mentoring phase of your training. 🌐 Post course – Exclusive access to our online mentoring and logging programme. You need to carry out at least 20 mentored cases in practice after the course and our programme helps you accomplish this once you have sourced a mentor. We can help you find a mentor with our extensive list, including some of the team at UKSedation.  Once at least 20 cases are completed mentored, you are then free to carry out IV Sedation independently. THE FEES WILL BE £1100 FOR DENTISTS AND £550 FOR DENTAL NURSES, INCLUDING ALL RESOURCE MATERIALS. IF BOOKING DENTIST AND NURSE TOGETHER USE PRODUCT CODE “UKSEDATION250” TO GET A £250 DISCOUNT ON THE NURSES TICKET. New course also delegates get access to exclusive offers from dental sedation equipment providers Once mentoring is completed, there is an additional fee of £150 for final certification. Key features of the course: Comprehensive Curriculum: Covering everything from patient assessment, sedation techniques, monitoring, and emergency protocols, our course gives you all the tools you need to safely administer dental sedation. Expert Instruction: Our instructors are experienced sedation practitioners who are passionate about sharing their knowledge. CPD Certified: The course is fully accredited for Continuing Professional Development, providing 14 verifiable sedation CPD hours upon completion. Post-course Support: We’re committed to your ongoing development, offering post-course support and resources to help you apply your new skills confidently in your practice. Mentoring – at UkSedation we can provide the mentors to visit your practice to help you with your required 20 cases (charged separately). We will train you in how to find the patients who would benefit from sedation and to have that discussion with them. Whether you’re a newly qualified dentist or nurse or a seasoned practitioner looking to expand your services, our New Starter Sedation Course is the perfect stepping stone to elevate your practice and help many more patients visit the dentist. Don’t miss out on this fantastic opportunity to enhance your professional skills, deliver better patient care, and grow your practice. Limited spaces are available, so sign up today and take the next step in your dental career with the UK Sedation & Mellow Dental’s New Starter Sedation Course. Course Includes 24 Lessons 14 Quizzes Course Certificate About Instructor Rob Endicott Roy Bennett Dr Roy Bennett is the director of Mellow Dental Training, IACSD accredited trainer and mentor and former director of Portmans Dental Care. Dr Rob Endicott is an IACSD accredited trainer and mentor and is the ViceChair of the ADAS (Association of Dental Anaesthetists and Sedationists)