• Professional Development
  • Medicine & Nursing
  • Arts & Crafts
  • Health & Wellbeing
  • Personal Development

45451 PE courses

SQL Querying Fundamentals - Part 2

By Nexus Human

Duration 1 Days 6 CPD hours This course is intended for Students should have basic computer skills, SQL skills, and be familiar with concepts related to database structure and terminology. Overview Upon successful completion of this course, students will be able to: - Use subqueries to generate query output. - Manipulate table data by inserting, updating, and deleting records in a table. - Manipulate the table structure. - Create views, manipulate data through views, modify the view structure, and drop views. - Create indices on table columns and drop inefficient indices. - Mark the beginning of a transaction, create a savepoint within a transaction, rollback a transaction, and commit a transaction. In this course, students will work with advanced queries to manipulate and index tables. Students will also create transactions so that you can choose to save or cancel data entry process. Prerequisites SQL Querying Fundamentals - Part 1 1 - Using Subqueries to Perform Advanced Querying Search Based on Unknown Values Compare a Value with Unknown Values Search Based on the Existence of Records Generate Output Using Correlated Subqueries Filter Grouped Data Within Subqueries Perform Multiple-Level Subqueries 2 - Manipulating Table Data Insert Data Modify and Delete Data 3 - Manipulating the Table Structure Create a Simple Table Create a Table with Constraints Add or Drop Table Columns Add or Drop Constraints Modify the Column Definition Back Up Tables Delete Tables 4 - Working with Views Create a View Manipulate Data in Views Create Aliases Modify and Drop Views 5 - Indexing Data Create Indices Drop Indices 6 - Managing Transactions Create Transactions Commit Transactions

SQL Querying Fundamentals - Part 2
Delivered OnlineFlexible Dates
£495

Level 4 Award Learning Coaching

By Panda Education and Training Ltd

Learning Coach Qualification – is it right for me? A Learning Coach plays a vital role in guiding and supporting young people in their educational journey, helping them develop a range of skills and attributes that contribute to successful learning, personal growth, and future success. Pursuing a qualification to become a qualified Learning Coach is beneficial for enhancing skills, credibility, and effectiveness in supporting learners’ development. It provides a foundation of knowledge and expertise that contributes to successful coaching experiences. This qualification consists of three units (two mandatory, 1 optional). Please see the Agored Cymru website for full course information, where you can choose the units to suit the needs of your staff. It will cover the following: Young People’s Development: Factors influencing learning, motivation, and barriers to learning. Learning Styles and Inclusive Planning: Learning styles vs. Universal Design for Learning (UDL), planning for inclusive learning. Reflective Practice: Comparison of reflection models, engaging in reflective practice. Coaching for Learning: Communication and coaching skills, coaching models, functions of Learning Coaching Assessing Young People: Interview skills, communication styles, assessing achievements and barriers to learning. Developing Learning Pathways: Coordinating individualised learning pathways, engaging young people in goal-setting Further Information This course spans six months and covers various aspects of Learning Coaching, including understanding learning processes, personal and emotional factors affecting learning, coaching techniques, reflective practice, communication skills, inclusive planning, assessment, and the coordination of individualised learning pathways. Students will engage in assignments, reflective journals, case studies, and portfolio building to demonstrate their understanding and application of the concepts and skills covered in the course. Learning Outcomes Professional Competence: A formal qualification ensures that Learning Coaches have a solid understanding of best practices, theories, and methodologies in the field of education and coaching. It provides them with the necessary knowledge and skills to effectively support learners in their development. Credibility: Having a recognised qualification enhances the Learning Coach’s credibility and reputation. It demonstrates their commitment to their role and their ability to provide high-quality guidance and support. Improved Effectiveness: Learning Coaches who have undergone formal training are better equipped to assess learners’ needs, design personalised learning plans, and provide targeted support. This leads to more effective coaching outcomes. Personal Growth: Going through a qualification process often involves self-reflection, skill development, and continuous learning. This contributes to the personal growth and professional development of the Learning Coach. Network and Community: Enrolling in a qualification program provides Learning Coaches with the opportunity to connect with other professionals in the field. This network can offer support, resources, and collaboration opportunities.

Level 4 Award Learning Coaching
Delivered Online & In-PersonFlexible Dates
£550

Emergency First Response Instructor (First Aid / CPR / AED)

5.0(11)

By Trainmetodo

First aid, CPR, AED, Cardio Pulmonary Resuscitation

Emergency First Response Instructor (First Aid / CPR / AED)
Delivered In-PersonFlexible Dates
£420 to £470

Emotional Intelligence as a Leader Course

5.0(1)

By Generation Leader

The most comprehensive, concise and impactful 6 weeks online course available. Fully accredited. Start immediately. Gain 18 CPD Credits and an exclusive Chartered Management Institute Certificate of Recognition Duration: 6 weeks starting immediately Who is this course for? All levels of seniority Language: English Effort: 16 hours of self-paced online learning Award: 18 CPD Credits & CMI Certificate of Recognition  Accreditors: CMI, FMLM, CPD Certification Service  Content format: Videos with optional reading  Assessment Method: Multiple choice, instant result. Retake if required. In total there are 22 video courses to watch. This includes 9 CPD accredited courses that require you to complete a multiple choice assessment to confirm your understanding of the topic. A pass mark of 70% is required and this can be re-taken as many times as required. Optional reading and audio book resources are provided to enable you to explore a topic deeper if required. The content of the course is of the highest global standard and has been created by MIT Sloan Management Review. Our learning platform, called Skillsoft Percipio, provides a stunning learning experience. Key learning areas: Benefits of being an emotionally intelligent leader Leading individuals and teams Critical thinking Managing stress Managing pressure to optimise performance Effective leadership Breaking bad news Decision making On completion of this course, you will receive: A certificate stating 18 CPD Credits- Awarded by the CPD Certification Service A Certificate of Recognition from the prestigious Chartered Management Institute (CMI) Chartered Management Institute Affiliate membership for 1 year A digital badge to share on LinkedIn and add to your resume Your official CPD Certificate Your official CMI Certificate You will also be awarded the following additional benefits: Chartered Management Institute alumni network access for 1 year Access to Chartered Management Institute networking and learning events for 1 year World leading content supported by cutting edge technology. Made for healthcare professionals.    Did you know this course can be covered by the NHS study budget?   The study budget covers: Courses and education activities to support you achieving the curriculum Courses to help you prepare for postgraduate exams Discretionary courses that add value to you individually and support the wider system To access the study budget you should discuss this with your educational supervisor or line manager. To help you with this process, view our example study budget application letter here. 

Emotional Intelligence as a Leader Course
Delivered Online On Demand
£620

Training of Trainers

4.9(9)

By Sterling Training

Most trainers are self-taught or have attended short courses and don't have the time to take their skills to the next level. Give staff the skills to understand how and what to train, and to use our special learner-centred techniques to boost the effectiveness and impact of their training courses.. This course includes: Assessing your learners’ skills and abilities Understanding how people learn Learning and training theories Planning and timing an effective session Essential training techniques Assessment and evaluation of learning

Training of Trainers
Delivered OnlineFlexible Dates
£450

Epilepsy Train the Trainer

4.9(1007)

By Caring For Care

About this event Definition of epilepsy Various types of seizures Classification and management of seizures Ethical and legal responsibilities Recognising triggers and precipitants Person centred care Documentation and record keeping The impact of rescue medication and anti-epileptic drug therapy Rescue medications: what it is, it’s uses for epilepsy and side effects Emergency care plan and when to call an ambulance Risk assessment/promotion of safeguarding and dignity Epilepsy medication demonstration

Epilepsy Train the Trainer
Delivered OnlineFlexible Dates
£450

Medication Train the Trainer

4.9(1007)

By Caring For Care

The course is run over 2 days you will learn about and how to teach and assess the following key areas: Policies. Legislation. CQC The course is run over 2 days you will learn about and how to teach and assess the following key areas: Policies. Legislation. CQC Medication. Routes. Formulation. Types. Absorption. MDT. Roles and Responsibilities. Levels of support. Boundaries and agreed ways of working. Order. Receive. Store. Record. Transfer. Dispose. 7 R’s. Sources of info. Practical session including MAR charts. Risk assessments. Person Centred Care. Review. Covert. Consent. Refuse. Errors and action. Infection Control and Technique.

Medication Train the Trainer
Delivered OnlineFlexible Dates
£450

Safeguarding Train the Trainer

4.9(1007)

By Caring For Care

Definition of Safeguarding Legislation & agreed ways of working Definition of Safeguarding Legislation & agreed ways of working Every child matters guidance Myths and statistics Effects on young people Leadership/worker skills Common indicators of abuse Reporting of abuse and potential abuse Barriers to reporting abuse Understanding the types of abuse Recognising acts, signs and symptoms of abuse Who is vulnerable / at risk The role of dignity in safeguarding Legislation and policies and procedure What to do should you have a concern Overview of prevent How to respond to an individual should they disclose a concern

Safeguarding Train the Trainer
Delivered OnlineFlexible Dates
£450

C&G 2921-31 EV Charge Point Installer

5.0(9)

By Optima Electrical Training

This Level 4 City and Guilds 2396-01 Design and Verification of Electrical Installations course has been designed to help develop the skills and up date the knowledge of the requirements to enable you to professionally design, erect and then verify an electrical installation. This course is aimed at those who will have responsibility for designing, supervising, installing and testing electrical installations. Further information can be found here: C&G 2396 Electrical Design Course — Optima Electrical Training (optima-ect.com)

C&G 2921-31 EV Charge Point Installer
Delivered In-Person in London + 2 more or UK WideFlexible Dates
£435

AutoCAD 3D Basics-Advanced Training

By London Design Training Courses

Why Learn AutoCAD 3D Basics-Advanced Training Course? Course Link Learn 3D modeling, materials, lighting, and rendering, and parametric models. Learn real-world Architecture, products, mechanics. Enroll for in-person or online sessions to master AutoCAD 3D. Duration: 16 hrs Method: 1-on-1 Schedule: Tailor your own schedule by pre-booking a convenient hour of your choice, available from Mon to Sat between 9 am and 7 pm. "Dial 02077202581 or WhatsApp 07970325184 to reserve your preferred dates and times.  AutoCAD 3D Basics-Advanced Level 1-2-1 Training Course: Comprehensive coverage from basics to advanced techniques. Suitable for beginners and those advancing their 3D modeling skills. Personalized attention in a private learning environment. Experienced instructors with expertise in 3D modeling. Hands-on practice for confident 3D modeling. Flexible scheduling and lifetime email support. Certificate upon course completion for career advancement AutoCAD 3D Basics-Advanced Level 1-2-1 Training Course: Comprehensive coverage from basics to advanced techniques. Suitable for beginners and those advancing their 3D modeling skills. Personalized attention in a private learning environment. Experienced instructors with expertise in 3D modeling. Hands-on practice for confident 3D modeling. Flexible scheduling and lifetime email support. Certificate upon course completion for career advancement AutoCAD 3D Basics to Advanced Level Training Course Outline (10 hours): Session 1: Introduction to 3D Modeling (2 hours) Understanding 3D modeling concepts Working in the 3D Modeling Workspace Drawing 3D objects with Solid tools Extruding 2D polylines to create 3D objects Session 2: Advanced 3D Features and UCS (2 hours) Setting up AutoCAD for advanced 3D modeling Mastering the User Coordinate System (UCS) Using viewports to aid in 3D drawing Efficient modeling with Array tools Session 3: Rendering and Visualization (2 hours) Testing rendering techniques Creating a quick study rendering Simulating natural lighting and the sun Enhancing 3D models with materials and lights Session 4: Editing 3D Solids and Mesh Modeling (2 hours) Understanding solid modeling principles Creating and editing basic solid forms Editing 3D solids and streamlining 2D drawing process Exploring 3D mesh modeling and editing The AutoCAD 3D training course provides a comprehensive understanding of 3D modeling, visualization, and rendering. Participants will learn to create complex 3D models, render realistic visuals, and efficiently customize the AutoCAD interface for improved productivity. Master 3D Modeling: From basics to advanced techniques. Realistic Rendering: Achieve lifelike visualizations. Professional Presentations: Dynamic walkthroughs and showcases. Enhanced Career Opportunities: Stronger prospects in design fields. Personalized Learning: One-to-one attention for focused training. Practical Hands-On Practice: Building confidence in 3D modeling. Lifetime Email Support: Ongoing assistance beyond the course. Certification: Proof of proficiency in AutoCAD 3D modeling.

AutoCAD 3D Basics-Advanced Training
Delivered in London or OnlineFlexible Dates
£580