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

100 Courses delivered Online

Meal Planning For Any Diet

By Xpert Learning

About Course Master the Art of Meal Planning: Transform Mealtimes from Stress to Success Eliminate mealtime overwhelm, conquer dietary choices, and discover the secrets to effortless meal planning with our expert-led course, designed to empower you to create personalized, healthy, and stress-free meal plans for any diet. Whether you're a seasoned home cook or a complete cooking novice, this course will equip you with the tools and strategies you need to transform mealtimes from a source of stress to a source of enjoyment and satisfaction. What You'll Learn: Uncover your culinary identity and preferences: Define your unique cooking style and dietary needs to create meal plans that align with your preferences and goals. Design your ideal kitchen and workspace: Optimize your cooking space for efficiency and creativity, turning your kitchen into a haven for culinary exploration. Gain insights from real-life case studies: Witness the transformative power of meal planning through inspiring case studies that showcase the incredible results achieved by our clients. Explore sample menu plans tailored to your tastes: Discover a variety of adaptable menu plans that can be customized to suit your dietary restrictions, preferences, and lifestyle. Embrace industry best practices for maximized results: Implement expert tips and strategies to streamline your meal planning process, ensuring you make the most of your time and effort. Benefits of Meal Planning Mastery: Enhanced health and well-being: Experience the positive impact of a balanced and organized diet on your overall health, energy levels, and fitness. Developed healthy habits: Cultivate lifelong habits that promote nutritious eating and empower you to make informed food choices. Reduced stress and improved mental health: Eliminate mealtime anxiety and cultivate a sense of calm and control over your food choices, leading to improved mental well-being. Course Overview: Over 1.5 hours of expert-led content: Gain valuable insights and practical guidance from experienced professionals. Suitable for all experience levels: Whether you're a beginner or a seasoned cook, this course caters to every level of culinary expertise. Real-world applications in diverse settings: Learn effective meal planning strategies applicable to various lifestyles, dietary needs, and cooking preferences. Enroll today and embark on a journey toward a life of culinary confidence, effortless meal planning, and a healthier, happier you! What Will You Learn? Maintain a clutter free kitchen and eating area. Build a weekly meal plan including breakfast, lunch, and dinner. Feel confident that they are eating what they want, but not feeling restricted. Stay within a food budget. Course Content Meet Your Instructors Promo Introduction Common Frustrations Samantha's Reasons for Meal Planning Emilio's Reasons for Meal Planning Overview and Getting Started Overview and Getting Started Step ONE: Understand Yourself Is Your Kitchen Ready? Step TWO: Inventory Tools Step THREE: Favourite Meals + Basic Plan Step FOUR: Inventory Food + Grocery List Step FIVE: Sourcing Food + Budget Step SIX: Food Preparation Step SEVEN: Storing Food Step EIGHT: Maintaining the System Step NINE: Enjoy Your Food Examples and Strategies Food To Go Kitchen Tour Decluttering a Professional Organizer's Kitchen Our Meal Plan Sourcing Food at the Grocery Store Sourcing Food at the Farmer's Market After Grocery Shopping Pre Cooking for the Week Preparing Fruit for the Week A course by KW Professional Organizers Organization, Minimalism, Selfcare RequirementsBasic understanding of the kinds of food that you like to eat.No tools are required.An open mind to changing your current behaviour and routines. Audience People looking to reduce stress and decision fatigue around meal time. People learning to cook for themselves. People who choose to get take out because they're not sure what to eat for dinner. People looking to eat within a financial budget. People who would like to eat more intentional, healthy foods. Families who are looking to make meal time simple and easy. This course is not for people looking for meal suggestions or what foods to eat. This course is designed to teach you how to stay organized around meal times. Audience People looking to reduce stress and decision fatigue around meal time. People learning to cook for themselves. People who choose to get take out because they're not sure what to eat for dinner. People looking to eat within a financial budget. People who would like to eat more intentional, healthy foods. Families who are looking to make meal time simple and easy. This course is not for people looking for meal suggestions or what foods to eat. This course is designed to teach you how to stay organized around meal times.

Meal Planning For Any Diet
Delivered Online On Demand
£9.99

Career Coaching Level 3

4.7(160)

By Janets

Driving others to achieve their goals is no easy task, and in today's fast-paced world, many professionals are looking for specialist help to gain a competitive edge in the job market. If your dream is to help others to reach their full potential and build their success story, then you might want to consider becoming a Career Coach.  A Career Coach helps clients to attract success in their professional lives, through various concepts, techniques, models and approaches. It requires excellent communication skills and interpersonal skills, as well as the right mindset. In this Career Coaching Course - Level 3 course, you will learn expert strategies and techniques for coaching clients from all industries and academic backgrounds. Career coaching comes with many rewards and challenges. If you think you have what it takes to motivate others and direct them on the path to prosperity in their professional life, then enrol in this expertly designed course and gain the credentials you need to make a real difference to people's lives. Learning outcomes Understand your role and professional responsibilities as a Career Coach Learn best practices for communicating with clients and motivating individuals Familiarise with the coaching process and key coaching and mentoring concepts Deepen your knowledge of mentoring in the context of an organisation Have an excellent understanding of different coaching and mentoring models Gain the skills to support clients in achieving their goals and work on their weaknesses Know how to maintain client confidentiality and understanding the ethics of coaching Develop essential communication, active listening and motivational skills Description  The Career Coaching Level 3 training course is delivered through Janets' online learning platform. Access the Career Coaching Level 3 content from any internet-enabled device whenever or wherever you want to. The Career Coaching Level 3 course has no formal teaching deadlines, meaning you are free to complete the course at your own pace. Method of Assessment  To successfully complete the Career Coaching Level 3 course, students will have to take an automated multiple-choice exam. This exam will be online and you will need to score 60% or above to pass the Career Coaching Level 3 course. After successfully passing the Career Coaching Level 3 course exam, you will be able to apply for a CPD-accredited certificate as proof of your Career Coaching Level 3 qualification. Certification All students who successfully complete the Career Coaching Level 3 course can instantly download their digital certificate. You can also purchase a hard copy of the Career Coaching Level 3 course certificate, which will be delivered by post for £9.99. Who is this Course for This Career Coaching Course is ideal for aspiring professionals and those who are new to the field who wish to develop their coaching and mentoring skills. There are no specific entry requirements for this course, however, those who have completed the Level 1 and 2 courses will have a significant advantage of successful completion.  Requirements The Career Coaching Level 3 is open to all students and has no formal entry requirements. To study the Career Coaching Level 3 course, all your need is a passion for learning, a good understanding of English, numeracy, and IT skills. You must also be over the age of 16. Career Path By course completion, learners will be equipped with a range of skills required to work in the field of coaching and mentoring. They will have a solid understanding of industry best practices and will be able to apply their knowledge to explore opportunities in the following professions: Career Coach Career Counsellor Mentor Life Coach Inspirational Speaker Course Content Module 01: Introduction to Career Coaching Introduction to Career Coaching 00:24:00 Module 02: The Career Seeker The Career Seeker 00:21:00 Module 03: Ethical Aspects of Coaching and Mentoring Ethical Aspects of Coaching and Mentoring 00:31:00 Module 04: Coaching and Mentoring Models Coaching and Mentoring Models 01:02:00 Module 05: Motivating Your Clients Motivating Your Clients 00:17:00 Module 06: The Coach/Client Relationship The Coach/Client Relationship 00:19:00 Module 07: Effective Communication Skills Effective Communication Skills 00:22:00 Module 08: Personal Skills Personal Skills 00:21:00 Module 09: Management Skills Management Skills 00:21:00 Module 10: Functional Skills Functional Skills 00:26:00 Module 11: Essential UK Employment Law Essential UK Employment Law 00:35:00 Frequently Asked Questions Are there any prerequisites for taking the course? There are no specific prerequisites for this course, nor are there any formal entry requirements. All you need is an internet connection, a good understanding of English and a passion for learning for this course. Can I access the course at any time, or is there a set schedule? You have the flexibility to access the course at any time that suits your schedule. Our courses are self-paced, allowing you to study at your own pace and convenience. How long will I have access to the course? For this course, you will have access to the course materials for 1 year only. This means you can review the content as often as you like within the year, even after you've completed the course. However, if you buy Lifetime Access for the course, you will be able to access the course for a lifetime. Is there a certificate of completion provided after completing the course? Yes, upon successfully completing the course, you will receive a certificate of completion. This certificate can be a valuable addition to your professional portfolio and can be shared on your various social networks. Can I switch courses or get a refund if I'm not satisfied with the course? We want you to have a positive learning experience. If you're not satisfied with the course, you can request a course transfer or refund within 14 days of the initial purchase. How do I track my progress in the course? Our platform provides tracking tools and progress indicators for each course. You can monitor your progress, completed lessons, and assessments through your learner dashboard for the course. What if I have technical issues or difficulties with the course? If you encounter technical issues or content-related difficulties with the course, our support team is available to assist you. You can reach out to them for prompt resolution.

Career Coaching Level 3
Delivered Online On Demand4 hours 59 minutes
£25

CertNexus Certified Ethical Emerging Technologist (CEET) v1.0

By Nexus Human

Duration 5 Days 30 CPD hours This course is intended for This course is designed for technology leaders, solution developers, project managers, organizational decision makers, and other individuals seeking to demonstrate a vendor-neutral, cross-industry understanding of ethics in emerging data-driven technologies, such as AI, robotics, IoT, and data science. This course is also designed for professionals who want to pursue the CertNexus Certification Exam CET-110: Certified Ethical Emerging Technologies. Overview In this course, you will incorporate ethics into data-driven technologies such as AI, IoT, and data science. You will: Describe general concepts, theories, and challenges related to ethics and emerging technologies. Identify ethical risks. Practice ethical reasoning. Identify and mitigate safety and security risks. Identify and mitigate privacy risks. Identify and mitigate fairness and bias risks. Identify and mitigate transparency and explainability risks. Identify and mitigate accountability risks. Build an ethical organization. Develop ethical systems in technology-focused organizations. Mutually reinforcing innovations in computing and engineering are catapulting advances in technological production. From blockchain and artificial intelligence (AI) to gene editing and the Internet of Things (IoT), these advances come with tremendous opportunities for improvement in productivity, efficiency, and human well-being. But as scandals increasingly demonstrate, these advances also introduce new and serious risks of conflict and harm.Technology professionals now face growing demands to identify and mitigate ethical risks to human rights and the environment, as well as to navigate ethical tradeoffs between qualities such as privacy and accuracy, fairness and utility, and safety and accountability. This course provides the tools to identify and manage common ethical risks in the development of emerging data-driven technologies. It distills ethical theory, public regulations, and industry best practices into concrete skills and guidelines needed for the responsible development of digital products and services. By following the course's practical, problems-based approach, learners will become adept at applying theories, principles, frameworks, and techniques in their own roles and organizations. Introduction to Ethics of Emerging Technologies Topic A: What?s at Stake Topic B: Ethics and Why It Matters Topic C: Ethical Decision-Making in Practice Topic D: Causes of Ethical Failures Identifying Ethical Risks Topic A: Ethical Reasons Topic B: Stumbling Blocks for Ethical Reasoning Topic C: Identify Ethical Risks in Product Development Topic D: Tools for Identifying Ethical Risks Topic E: Use Regulations, Standards, and Human Rights to Identify Ethical Risks Ethical Reasoning in Practice Topic A: Ethical Theories Topic B: Use Ethical Decision-Making Frameworks Topic C: Select Options for Action Topic D: Avoid Problems in Ethical Decision-Making Identifying and Mitigating Security Risks Topic A: What Is Security? Topic B: Identify Security Risks Topic C: Security Tradeoffs Topic D: Mitigate Security Risks Identifying and Mitigating Privacy Risks Topic A: What Is Privacy? Topic B: Identify Privacy Risks Topic C: Privacy Tradeoffs Topic D: Mitigate Privacy Risks Identifying and Mitigating Fairness and Bias Risks Topic A: What Are Fairness and Bias? Topic B: Identify Bias Risks Topic C: Fairness Tradeoffs Topic D: Mitigate Bias Risks Identifying and Mitigating Transparency and Explainability Risks Topic A: What Are Transparency and Explainability? Topic B: Identify Transparency and Explainability Risks Topic C: Transparency and Explainability Tradeoffs Topic D: Mitigate Transparency and Explainability Risks Identifying and Mitigating Accountability Risks Topic A: What Is Accountability? Topic B: Identify Accountability Risks Topic C: Accountability Tradeoffs Topic D: Mitigate Accountability Risks Building an Ethical Organization Topic A: What Are Ethical Organizations? Topic B: Organizational Purpose Topic C: Ethics Awareness Topic D: Develop Professional Ethics within Organizations Developing Ethical Systems in Technology-Focused Organizations Topic A: Policy and Compliance Topic B: Metrics and Monitoring Topic C: Communication and Stakeholder Engagement Topic D: Ethical Leadership

CertNexus Certified Ethical Emerging Technologist (CEET) v1.0
Delivered OnlineFlexible Dates
Price on Enquiry

CSS Bootcamp: Master CSS (Including CSS Grid/Flexbox)

By Packt

Work through real-world projects and learn how to create modern, responsive websites using CSS Grid and Flexbox

CSS Bootcamp: Master CSS (Including CSS Grid/Flexbox)
Delivered Online On Demand11 hours 30 minutes
£93.99

Engineering & Work Practice Controls

4.3(43)

By John Academy

Explore the world of occupational safety with our comprehensive course, 'Engineering & Work Practice Controls.' Gain expertise in identifying and evaluating hazards, implementing effective engineering and work practice controls, and ensuring regulatory compliance. Discover sustainable practices, industry best practices, and real-world case studies. Elevate your skills in creating a safer and healthier work environment. Join us for a transformative learning experience in safety management, risk assessment, and environmental sustainability. Enroll today for a future where workplace well-being meets engineering excellence.

Engineering & Work Practice Controls
Delivered Online On Demand1 hour 30 minutes
£23.99

Vehicle Wrapping Course

5.0(1)

By Course Gate

Are you interested in learning Vehicle Wrapping, and have you been thinking 'Where can I find a Vehicle Wrapping Course near me?'. Well, you are at the right place. You can now learn all the basics of Vehicle Wrapping and its best practices from your home. Welcome to our comprehensive vehicle wrapping course solely dedicated to enthusiasts, beginners, and professionals who share a desire to transform automobiles into works of art. This course is designed to provide the skills and information you need to improve your car customisation game. Whether you are a DIY enthusiast or an aspiring professional, this training will meet your learning goals. Each session will gradually increase your knowledge of everything from fundamental automobile preparation to advanced vinyl wrapping techniques. Through this course, you will learn the fundamentals of vehicle care and the art of washing; car detailing essentials and the details of vinyl wrapping a hood; the art of wrapping different car panels, including doors, fenders, and rear quarters; Inlays, emblem, and badge removal techniques for a seamless finish; and Wrapping additional components such as trunks, side skirts, bumpers, and even side mirrors. In addition, you also learn invaluable tips and tricks, such as adding a buffer to the squeegee, cutting edges with precision, and utilising specialised tools like Knifeless Tape. These insights ensure you learn the techniques and adopt industry best practices. By the end of this course, you will be a knowledgeable automotive detailing and automobile wrapping expert. With competence in handling every panel, corner, and logo, you will be confident in transforming any car from ordinary to eye-catching. What are you waiting for? Dive deep into the vinyl wrapping course to unleash your imagination and let your creativity flow. Prepare to dazzle with your newly gained skills in automotive customising as you redefine vehicle aesthetics! What you will learn from this Vehicle Wrapping Course Fundamentals of vehicle care and washing techniques. Car detailing and preparation processes for effective wrapping. Proper usage of tools, including adding a buffer to the squeegee, cutting edges with precision, and utilising Knifeless Tape. Wrapping techniques for various automotive parts, including the hood, fenders, doors, rear quarter panels, trunks, side skirts, bumpers, front bumper, and mirrors. Removal and application techniques for various components, such as bumpers, headlights, door handles, emblems, and badges. Inlay creation and its appropriate use in vinyl wrapping. Tips for efficient material usage and cutting to save resources. Entry Requirement Anyone interested in learning more about this subject should take this Vehicle Wrapping Course. This course will help you grasp the basic concepts as well as develop a thorough understanding of the subject. The course is open to students from any academic background, as there is no prerequisites to enrol on this course. The course materials are accessible from an internet enabled device at anytime of the day. CPD Certificate from Course Gate At the successful completion of the course, you can obtain your CPD certificate from us. You can order the PDF certificate for £9 and the hard copy for £15. Also, you can order both PDF and hardcopy certificates for £22. Career path The Vehicle Wrapping Course will help you to enhance your knowledge and skill in this sector. After accomplishing this course, you will enrich and improve yourself and brighten up your career in the relevant job market. Course Curriculum Vehicle Wrapping Course Module 01: Vehicle Wash 00:04:00 Module 02: Car Detailing & Preparation of the vehicle 00:05:00 Module 03: How To Use The Squeegee 00:08:00 Module 04: How To Vinyl Wrap A Hood With Air Vents 00:04:00 Module 05: How To Remove Bumpers & Headlights 00:05:00 Module 06: How To Vinyl Wrap A Fender 00:07:00 Module 07: How To Cut The Vinyl Wrap Material For Each Panel To Save Material 00:05:00 Module 08: How To Remove The Door Handles 00:08:00 Module 09: How To Vinyl Wrap The Doors for Vehicle Wrapping 00:06:00 Module 10: Door Handle Vinyl Wrap for Vehicle Wrapping 00:08:00 Module 11: How To Wrap the Rear Quarter Panel for Vehicle Wrapping 00:08:00 Module 12: How To Make an Inlay and When To Use an Inlay for Vehicle Wrapping 00:05:00 Module 13: Trunk Vinyl Wrap for Vehicle Wrapping 00:07:00 Module 14: Side Skirts Vinyl Wrap for Vehicle Wrapping 00:09:00 Module 15: How to Remove the Roof Antenna for Vehicle Wrapping 00:10:00 Module 16: How To Vinyl Wrap the Roof for Vehicle Wrapping 00:06:00 Module 17: How To Vinyl Wrap The Rear Bumper for Vehicle Wrapping 00:08:00 Module 18: How To Vinyl Wrap The Front Bumper for Vehicle Wrapping 00:10:00 Module 19: Side Mirrors Vinyl Wrap for Vehicle Wrapping 00:11:00 Module 20: How to install the Emblems the correct way 00:09:00 Certificate and Transcript Order Your Certificates or Transcripts 00:00:00

Vehicle Wrapping Course
Delivered Online On Demand2 hours 23 minutes
£11.99

SQL Programming Masterclass

5.0(10)

By Apex Learning

Course Overview: Are you ready to embark on a journey into SQL Programming? Unlock the power of data manipulation and database management with the SQL Programming Masterclass. This comprehensive course is meticulously designed throughout this masterclass to provide you with an in-depth understanding of SQL, starting from the basics and progressing to advanced topics. You will explore SQL data types, filtering and sorting data, working with functions, handle NULL values, and even diving into complex SQL concepts like joins, unions, etc. With a course duration of carefully crafted lessons, this Masterclass ensures you grasp SQL's nuances and develop the proficiency to apply these skills effectively.By the end of the SQL Programming Masterclass, you will be prepared to navigate the world of databases confidently. Enrol in this course today and start your journey! Key Features of the Course: CPD certificate upon completion 24/7 learning assistance and support Who is This Course For? This course is perfect for individuals seeking to enhance their data management and analysis skills. Whether you're a data analyst, database administrator, software developer, or professional looking to upskill, this course will empower you to harness the power of SQL programming. Prior programming experience is not mandatory, making it accessible to beginners and intermediate learners. What You Will Learn: Foundations of SQL programming: Learn the basics of SQL, database management systems, and the tools used in this course, such as PostgreSQL and SQLectron. Data manipulation: Master the art of extracting, filtering, and sorting data based on specific requirements using various SQL keywords and operators. Advanced querying techniques: Dive deeper into SQL programming by exploring functions, grouping and aggregating data, and using advanced query techniques. Data conversion and manipulation: Discover how to convert data types, concatenate strings, manipulate characters and numbers, and utilise case statements for more sophisticated queries. Joining tables: Understand the different types of joins and how to combine data from multiple tables using join operations effectively. Data modification: Learn how to insert, update, and delete records in a database, as well as manage table structures and constraints.Joining tables: Understand the different types of joins and how to combine data from multiple tables using join operations effectively. Views and schemas: Explore the concepts of views and schemas, and learn how to create and use them to organise and present data effectively. Why Enrol in This Course: Top-reviewed course: Join thousands of satisfied learners who have praised this course for its clear explanations, comprehensive content, and examples. Recently updated curriculum: Benefit from the most up-to-date information and industry best practices in SQL programming. In-demand skills: SQL programming is a highly sought-after skill in today's job market, opening up numerous career opportunities across industries. Requirements: No prior programming experience is required. All you need is a computer with an internet connection and a willingness to learn. Career Path: Upon completing the SQL Programming Masterclass, you'll have the knowledge and skills for various career paths, including: Data Analyst - Average UK salary: £35,000 per year Database Administrator - Average UK salary: £40,000 per year Business Intelligence Analyst - Average UK salary: £45,000 per year SQL Developer - Average UK salary: £40,000 per year Data Engineer - Average UK salary: £55,000 per year Software Developer - Average UK salary: £45,000 per year Data Scientist - Average UK salary: £60,000 per year Certification: Upon completing the Hygiene and Infection Control CPD Level 4 course, you will receive a CPD certificate. It demonstrates your commitment to maintaining the highest standards of hygiene and infection control. Course Curriculum 17 sections • 117 lectures • 10:47:00 total length •Introduction: 00:01:00 •Tools Used in This Course: 00:01:00 •Download PostgreSQL: 00:02:00 •Install PostgreSQL: 00:03:00 •Download SQLectron: 00:02:00 •Install SQLectron: 00:01:00 •Connect to PostgreSQL - Credentials: 00:01:00 •Connect to PostgreSQL Using SQLectron: 00:02:00 •Import Course Data Using SQLectron: 00:02:00 •FOR WINDOWS 32-BIT USERS: Download, Install, Configure & Import Data: 00:08:00 •Check Imported Data: 00:06:00 •What is a Database?: 00:01:00 •SQL Data Types: 00:02:00 •Finally Some Fun! Extracting Data Based on Requirements: 00:01:00 •Filtering Data using WHERE Keyword: 00:08:00 •Filter Data by Range Using BETWEEN: 00:03:00 •Filter Data by Set of Values Using IN: 00:03:00 •Filter Data by Date: 00:05:00 •More Filtering by Date: 00:03:00 •Another Query Filtering by Date: 00:01:00 •Filter Data by Strings: 00:04:00 •More Filtering by Strings: 00:05:00 •More Filtering by Strings 2: 00:10:00 •More Filtering by Strings 3: 00:02:00 •How to Ignore Caps when Filtering by String: 00:04:00 •AND Operator: 00:10:00 •OR Operator: 00:12:00 •NOT Operator: 00:09:00 •AND, OR & NOT Operators: Which Has the Highest Priority?: 00:06:00 •Basic Math Operations: 00:06:00 •Modulo Operator: 00:04:00 •Calculate The Net Salary for Employees: 00:06:00 •Filter Data with Math Equations: 00:03:00 •Concatenate Strings with '||' Operator: 00:06:00 •Concatenate Strings with Numbers: 00:02:00 •Give Your Report Fields A Cool Name: 00:04:00 •A Report for Payroll: 00:07:00 •Order Records by Column: 00:06:00 •Order Records by Multiple Columns: 00:12:00 •How Alias Names Cannot Be Used with WHERE: 00:02:00 •LIMIT Record Count Fetched by Your Query: 00:08:00 •Fetch A Field's Unique Values Using DISTINCT: 00:03:00 •Using DISTINCT Keyword with Multiple Columns: 00:06:00 •What is a NULL Value Anyway?: 00:05:00 •Build More Sophisticated Queries with CASE Statements: 00:10:00 •Your Knowledge So Far Under A Great Test: 00:09:00 •Let Me Introduce You to Functions: 00:04:00 •SUM Function: 00:04:00 •AVG (Average) Function: 00:04:00 •COUNT Function: 00:07:00 •MIN & MAX Functions: 00:04:00 •How To Count Your Field's Unique Values: 00:04:00 •GROUP BY Clause: Use Functions with Dimensions: 00:06:00 •GROUP BY More Than One Dimension: 00:05:00 •Now For Some Tough Workout: 00:09:00 •Filter By Aggregate Functions with HAVING Clause: 00:08:00 •Character Functions - UPPER, LOWER & INITCAP: 00:08:00 •Character Functions - CONCAT & LENGTH: 00:10:00 •Character Functions - LPAD & RPAD: 00:13:00 •Character Functions - TRIM: 00:04:00 •Character Functions - REPLACE: 00:09:00 •Character Functions - SUBSTR: 00:10:00 •Number Functions - MOD & ROUND: 00:11:00 •Number Functions - TRUNC: 00:07:00 •Selectception: A Select Query inside another Select Query!: 00:06:00 •Auto Data Conversion in SQL: 00:11:00 •Cast Date to Character: 00:10:00 •Cast Number to Character: 00:09:00 •Cast Timestamp to Character: 00:07:00 •Cast Character to Number: 00:08:00 •Cast Character to Date & Timestamp: 00:09:00 •UNION: 00:03:00 •UNION ALL: 00:02:00 •Important Note about Combining Queries: 00:02:00 •INTERSECT: 00:01:00 •EXCEPT: 00:01:00 •Employees & Departments Tables Revised: 00:03:00 •Entity Relationship Diagram (ERD): 00:09:00 •Cartesian Join: 00:09:00 •Table Aliases with Joins: 00:07:00 •Why I Don't Recommend Cartesian Joins: 00:08:00 •Inner Join: 00:06:00 •In-Depth Look into Join Types in SQL: 00:03:00 •Outer Join - Right, Left & Full: 00:08:00 •INSERT a New Record to a Table: 00:09:00 •Insert Without Specifying Column Names: 00:09:00 •UPDATE a Record's Field Values: 00:07:00 •CAUTION! How an UPDATE Query Can Go Wrong: 00:04:00 •Update a Record Using Single-Row Functions: 00:04:00 •A Good Exercise: Extract Employee's Email Address: 00:02:00 •Solution: Extract Employee's Email Address: 00:13:00 •DELETE a Table's Record: 00:06:00 •Insert Records with Nested Select Queries: 00:06:00 •SQL Data Types Revised: 00:13:00 •Bookstore Data Set: Let's Move It to Database: 00:04:00 •Create Your First Table!: 00:08:00 •Insert Data to Your New Table: 00:08:00 •Change Column Data Type: 00:07:00 •Rename Column: 00:04:00 •Add a New Column to Table: 00:04:00 •Constraints in SQL: 00:01:00 •Primary Keys: 00:14:00 •NOT NULL Constraint: 00:05:00 •UNIQUE Constraint: 00:04:00 •DEFAULT Constraint: 00:04:00 •Foreign Keys: 00:08:00 •Use Foreign Keys with Joins - Books & Publishers: 00:06:00 •Foreign Keys - Properties: 00:06:00 •Drop Column: 00:01:00 •DROP Table: 00:01:00 •Create a New Table with Select Statement: 00:05:00 •A Trick to Create an Empty Table with Select Statement: 00:03:00 •Insert New Records Using Select Statement: 00:06:00 •Views: 00:03:00 •Schemas: 00:02:00 •Create & Use Schemas: 00:04:00 •Resources - SQL Programming Masterclass: 00:00:00

SQL Programming Masterclass
Delivered Online On Demand10 hours 47 minutes
£12

Maintenance and Reliability Best Practices - Aligned with SMRP* Best Practices and the CMRP Certification

By EnergyEdge - Training for a Sustainable Energy Future

About this Training Course This 4 full-day Maintenance and Reliability Masterclass course will provide Maintenance and Reliability personnel with a full explanation of the Award-winning Model of Excellence for maintenance. This is top tier training that has also been designed to equip participants with practical skills to take back to work. The course enables participants to develop a strategy to achieve outstanding maintenance and reliability performance for their own workplace. This course is aligned with SMRP* best practices and the CMRP exam. It provides an opportunity for participants to sit for an examination+ on the final day of the course. Your facilitator for this course is a fully qualified CMRP professional, an approved SMRP Proctor, authorised to conduct CMRP exams and a globally respected maintenance consultant and best practice trainer. +Exam fees are not inclusive in the course fees. *SMRP refers to Society of Maintenance and Reliability Professionals. PetroEdge is not affiliated with SMRP. Training Objectives By the end of this course, participants will be able to: Appreciate the content and underlying principles of our maintenance Model of Excellence o How to develop a strategy for outstanding maintenance and reliability performance o Developing reliability methodologies and programmes to drive performance o Options and tools to improve reliability at equipment level o Leadership skills and improving organisation and human performance o Work with management with an overview of the latest practice in planning scheduling and control Describe how maintenance can become a more strategic and influential function Use the Carcharodon model of excellence and class leading methodologies for improving maintenance and reliability Target Audience This course will benefit: Maintenance managers Reliability professionals Experienced supervisors Planners Project engineers Operations managers Functional specialists Course Level Basic or Foundation Training Methods Course methodology of this training course: Other than world-class visuals and slides, this course will include a high level of interaction between the facilitator and participants and group discussion among the participants themselves. There will be a number of case studies to demonstrate key points and also a minimum of one workshop exercise each day to give participants the chance to apply learning and appreciate key aspects of best practice. Participants will also have the chance to share examples from their own experience, discuss real problems they are facing and develop actions for improvement when they return to work. Examples of the exercises that are used in this course are as follows: Exercise: Understanding the challenges and seeing the opportunities Exercise: Developing a strategy Group Exercise: Selecting maintenance plans Group exercise: Case study failure Group exercise: Planning work Trainer Your expert course leader is an award-winning consultant and trainer with 30 years' experience in maintenance and reliability improvement. He has worked across five continents, in a wide variety of environments from the world's largest oil refinery to a small drinks production line. He has 10 years of maintenance management experience in the process industry, so he brings a very practical approach to training. He moved into consulting with ABB Eutech as their global maintenance specialist where he led maintenance and reliability best practice panels, delivered a wide range of maintenance improvement projects and trained other consultants. He is a fully qualified CMRP professional, an approved SMRP* Proctor, authorised to conduct CMRP exams and a globally respected maintenance consultant and best practice trainer. He founded his consultancy and training business in 2002 to focus on maintenance and reliability improvement. As part of this, he developed a range of maintenance 'models of excellence' with inputs from authors, international lecturers and some of the world's leading consultants and operators. His work has been recognised as being at the leading edge of industry best practice, winning independent awards such as the UK Chemical Industries Association 'Excellence in Engineering' award. He remains close to the industry as a respected specialist helping operating companies to achieve changes in performance. This ongoing field work enables him to continue to refine and extend best practice and the learning from this is continually fed into his training. His unique experience of facilitating two major turnarounds when the Coronavirus escalated into lockdown have given him a unique insight into how events of this type can disrupt maintenance. Moreover, his involvement in developing management processes and leading a Coronavirus response on a major industrial asset means he can talk with direct experience about how to cope and innovate in this global pandemic. He is also the expert course leader for the following courses offered by PetroEdge: Preventive and Predictive Maintenance Effective Plant Turnaround Management POST TRAINING COACHING SUPPORT (OPTIONAL) To further optimise your learning experience from our courses, we also offer individualized 'One to One' coaching support for 2 hours post training. We can help improve your competence in your chosen area of interest, based on your learning needs and available hours. This is a great opportunity to improve your capability and confidence in a particular area of expertise. It will be delivered over a secure video conference call by one of our senior trainers. They will work with you to create a tailor-made coaching program that will help you achieve your goals faster. Request for further information post training support and fees applicable Accreditions And Affliations

Maintenance and Reliability Best Practices - Aligned with SMRP* Best Practices and the CMRP Certification
Delivered in Internationally or OnlineFlexible Dates
£3,009 to £3,499

Complete Minute Taking Training - CPD Accredited

By Wise Campus

Minute Taking : Minute Taking Do you want to learn more about minute taking or develop your existing skills? The goal of the Minute Taking : Minute Taking course was to give participants a thorough grasp of minute taking, with a focus on minute taking legal ideas, minute taking industry best practices, and minute taking underlying expertise. You will get knowledge of the duties and responsibilities of a Minute-Taker in this Minute Taking : Minute Taking course. This Minute Taking : Minute Taking contains detailed directions for meeting preparation,problem handling and meeting wrap up. Minute Taking also involves creating clear, structured meeting minutes. Moreover, Minute Taking : Minute Taking will teach you how to succinctly summarise a meeting's conclusions. This Minute Taking : Minute Taking training also offers tactics for enhancing your professional image and confidence. Also this Minute Taking : Minute Taking course pointers and guidance on how to ensure that all issues that arise during a meeting are resolved successfully. So why are you still waiting? Enrol right away to learn how our effective Minute Taking : Minute Taking may increase the productivity and success of business meetings. Main Course: Minute Taking 3 Exclusive Free Courses included with this Minute Taking Course: Along with Minute Taking Course We Offer a free HR & Payroll Management Course Along with Minute Taking Course, We Offer a free PA Training Course Along with Minute Taking Course, We Offer a free Office Management Course Special Offers of this Minute Taking : Minute Taking Course This Minute Taking : Minute Taking Course includes a FREE PDF Certificate. Instant Free Certificate to this Minute Taking : Minute Taking Course. Lifetime access to this Minute Taking : Minute Taking Course Instant access to this Minute Taking : Minute Taking Course Get FREE Tutor Support to this Minute Taking : Minute Taking Course Minute Taking : Minute Taking Are you eager to expand your knowledge of Minute Taking : Minute Taking or enhance your current abilities? The objective of the Minute Taking : Minute Taking course is to provide participants with a comprehensive understanding of minute taking, emphasizing legal principles, industry best practices, and fundamental expertise in Minute Taking : Minute Taking. Who is this course for? Minute Taking : Minute Taking Anyone from many backgrounds will benefit from our Minute Taking : Minute Taking course, but it is especially suitable for Administrative Assistant Personal Assistant Executive Personal Assistant Requirements Minute Taking : Minute Taking To enrol in this Minute Taking : Minute Taking Course, students must fulfil the following requirements. To join in our Minute Taking : Minute Taking Training Course, you must have a strong command of the English language. To successfully complete our Minute Taking : Minute Taking Training Course, you must be vivacious and self driven. To complete our Minute Taking : Minute Taking Training Course, you must have a basic understanding of computers. A minimum age limit of 15 is required to enrol in this Minute Taking : Minute Taking Training Course. Career path Minute Taking : Minute Taking You will have a variety of job options after taking this Minute Taking : Minute Taking course.

Complete Minute Taking Training - CPD Accredited
Delivered Online On Demand1 hour 18 minutes
£12

Preventive and Predictive Maintenance

By EnergyEdge - Training for a Sustainable Energy Future

About this Virtual Instructor Led Training (VILT) Preventive and Predictive maintenance are not new concepts. Both have been used across industry all over the world and when done properly, can yield impressive results (cost reductions of 20% or greater and a leap forward in equipment reliability and performance are very achievable). However, for every company using these concepts effectively, there are many others who are not. This 8 half-day Virtual Instructor Led Training (VILT) course has been derived from the Plant Performance Improvement Road Map developed by practitioners that guarantee the reliability of your operations. The VILT training focuses on how to improve profitability of any business by identifying the right maintenance strategy for any equipment. The aim of the VILT training is to help practitioners run programmes that will deliver real benefits as fast as possible with minimum zero wasted effort. The VILT training will also cover the core principles of Reliability Centred Maintenance, Total Productive Maintenance and Six Sigma and the increasingly important role of operations in achieving optimised asset performance. This is a certified course with the option of sitting for a short exam on the final day of the course to give participants the opportunity to gain a Certificate from petroEDGE and the Carcharodon Maintenance Academy. Training Objectives Master the critical skills by acquiring the following: An understanding of how maintenance can add profit The ability to develop improvement programmes that deliver maximum benefit in the shortest time A fundamental understanding of the principles of Preventive, Predictive and other maintenance types A practical understanding of the latest methods of solving problems at root cause level An appreciation of maintenance methodologies such as Reliability Centred Maintenance Strategies for ensuring your company gets value for money from your Contractors How to use the Maintenance Model of Excellence and Plant Performance Improvement Road Map Target Audience This VILT course has been designed for maintenance managers and engineers, reliability professionals, planners, project engineers, operations team members, and functional specialists. Training Methods The VILT course will be delivered online in 8 half-day sessions comprising 4 hours per day, with 2 breaks of 10 minutes per day. Course Duration: 8 half-day sessions, 4 hours per session (32 hours in total). Trainer Your expert course leader is an award-winning consultant and trainer with 30 years' experience in maintenance and reliability improvement. He has worked across five continents, in a wide variety of environments from the world's largest oil refinery to a small drinks production line. He has 10 years of maintenance management experience in the process industry, so he brings a very practical approach to training. He moved into consulting with ABB Eutech as their global maintenance specialist where he led maintenance and reliability best practice panels, delivered a wide range of maintenance improvement projects and trained other consultants. He is a fully qualified CMRP professional, an approved SMRP* Proctor, authorised to conduct CMRP exams and a globally respected maintenance consultant and best practice trainer. He founded his consultancy and training business in 2002 to focus on maintenance and reliability improvement. As part of this, he developed a range of maintenance 'models of excellence' with inputs from authors, international lecturers and some of the world's leading consultants and operators. His work has been recognised as being at the leading edge of industry best practice, winning independent awards such as the UK Chemical Industries Association 'Excellence in Engineering' award. He remains close to the industry as a respected specialist helping operating companies to achieve changes in performance. This ongoing field work enables him to continue to refine and extend best practice and the learning from this is continually fed into his training. His unique experience of facilitating two major turnarounds when the Coronavirus escalated into lockdown have given him a unique insight into how events of this type can disrupt maintenance. Moreover, his involvement in developing management processes and leading a Coronavirus response on a major industrial asset means he can talk with direct experience about how to cope and innovate in this global pandemic. *SMRP refers to Society of Maintenance and Reliability Professionals. PetroEdge is not affiliated with SMRP POST TRAINING COACHING SUPPORT (OPTIONAL) To further optimise your learning experience from our courses, we also offer individualized 'One to One' coaching support for 2 hours post training. We can help improve your competence in your chosen area of interest, based on your learning needs and available hours. This is a great opportunity to improve your capability and confidence in a particular area of expertise. It will be delivered over a secure video conference call by one of our senior trainers. They will work with you to create a tailor-made coaching program that will help you achieve your goals faster. Request for further information about post training coaching support and fees applicable for this. Accreditions And Affliations

Preventive and Predictive Maintenance
Delivered in Internationally or OnlineFlexible Dates
£1,642 to £3,099