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

46257 Courses

Oracle 11g PL/SQL Intermediate

4.3(43)

By John Academy

Description The Oracle Database server composes PL/SQL units and stores it in the database. Mainly, PL/SQL functions to hold to hold SQL declaration within its sentence structure. Do you want to know more about SL/SQL function? How does it bring optimal proficiency in 'procedural language'? if so, take a look at the Oracle 11g PL/SQL Intermediate course. It will assist you in understanding all you need to know about Oracle 11g PL/SQL. The course designs to help the learners to know its function incorporation with different strings, numbers, table row record, and error management. The Oracle 11g PL/SQL Intermediate course teaches the fundamental form and structure of the program unit saved within database, creating and managing stored methods, functions, packaged programs, and database prompts. Its contents aim to take you further in your quest to teach the effective methods including variables and cursor expressions. Assessment: This course does not involve any MCQ test. Students need to answer assignment questions to complete the course, the answers will be in the form of written work in pdf or word. Students can write the answers in their own time. Once the answers are submitted, the instructor will check and assess the work. Certification: After completing and passing the course successfully, you will be able to obtain an Accredited Certificate of Achievement. Certificates can be obtained either in hard copy at a cost of £39 or in PDF format at a cost of £24. Who is this Course for? Oracle 11g PL/SQL Intermediate is certified by CPD Qualifications Standards and CiQ. This makes it perfect for anyone trying to learn potential professional skills. As there is no experience and qualification required for this course, it is available for all students from any academic background. Requirements Our Oracle 11g PL/SQL Intermediate is fully compatible with any kind of device. Whether you are using Windows computer, Mac, smartphones or tablets, you will get the same experience while learning. Besides that, you will be able to access the course with any kind of internet connection from anywhere at any time without any kind of limitation. Career Path After completing this course you will be able to build up accurate knowledge and skills with proper confidence to enrich yourself and brighten up your career in the relevant job market. Introduction Introduction FREE 00:03:00 Preparing Your Environment Install Oracle XE 00:11:00 SQL Developer Installation 00:20:00 Workstation Setup 00:12:00 Database Program Units Introducing the Database Program Unit 00:19:00 Working with Stored Procedures and Functions Creating Stored Procedures and Functions 00:19:00 Understanding the Parameter Specification 00:23:00 Executing Procedures and Functions 00:26:00 Calling Functions from within SQL 00:13:00 Handling Compilation Errors 00:08:00 Maintaining Stored Procedures and Functions Recompiling and Dropping Programs 00:16:00 Data Dictionary Storage 00:25:00 Managing Dependencies 00:13:00 Tracking Dependencies 00:08:00 Using the Dependency Tracking Utility 00:09:00 Creating and Maintaining Packages What Is a Package? 00:10:00 Creating a Package 00:19:00 Package Definition Information 00:08:00 Advanced Programming Techniques 00:06:00 Using Persistent Global Objects 00:04:00 Including Initialization Logic 00:15:00 Object Oriented Support within Packages 00:14:00 Package Maintenance 00:18:00 Advanced Cursor Techniques Learning to Use Cursor Variables 00:24:00 Advanced Cursor Techniques Weak Cursor Definitions 00:16:00 REFCURSOR Cursor Definition 00:05:00 Using Cursor Expression 00:14:00 Using System Supplied Packages Using the DBMS OUTPUT() Package 00:12:00 Using the UTL FILE() Package 00:30:00 Creating Database Triggers Understanding the Database Trigger 00:23:00 Statement-Level Triggers 00:23:00 Row-Level Triggers 00:12:00 Row Level Trigger Example 1 00:11:00 Row Level Trigger Example 2 00:07:00 Row Level Trigger Example 3 00:08:00 Working with the INSTEAD OF Trigger 00:11:00 Using Triggers within an Application 00:09:00 Trigger Maintenance Using the CALL Statement 00:09:00 Trigger Maintenance Tasks 00:12:00 Work with Multiple Triggers for a Single Table 00:11:00 Handling Mutating Table Issues 00:22:00 Using the Compound Trigger 00:06:00 Working with System Event Triggers What Is a System Event Trigger 00:05:00 Defining Scope 00:04:00 Identifying Available System Events 00:12:00 Conclusion Conclusion 00:02:00 Order Your Certificate and Transcript Order Your Certificates and Transcripts 00:00:00 Order Your Certificate and Transcript Order Your Certificates and Transcripts 00:00:00

Oracle 11g PL/SQL Intermediate
Delivered Online On Demand10 hours 7 minutes
£18

Social Work Practice - CPD Certified

4.7(26)

By Academy for Health and Fitness

***24 Hour Limited Time Flash Sale*** Social Work Practice Admission Gifts FREE PDF & Hard Copy Certificate| PDF Transcripts| FREE Student ID| Assessment| Lifetime Access| Enrolment Letter Are you a professional feeling stuck in your career, struggling to keep up with the ever-changing demands of the industry? Or perhaps you're a beginner, unsure of where to start or how to break into your desired field. Whichever stage you're in, our exclusive Social Work Practice Bundle provides unique insights and tools that can help you achieve your goals. Designed to cater to the needs of both seasoned professionals and aspiring newcomers, our Social Work Practice bundle is a comprehensive program that will equip you with the essential skills and knowledge you need to succeed. Whether you're looking to advance in your current role or embark on a new career journey, this bundle has everything you need to take your professional life to the next level. But that's not all. When you enrol in Social Work Practice Online Training, you'll receive 25 CPD-Accredited PDF Certificates, Hard Copy Certificates, and our exclusive student ID card, all absolutely free. Courses Are Included In this Social Work Practice Career Bundle: Course 01: Diploma in Social Work Studies - Level 3 Course 02: Preparing to Work in Adult Social Care Course 03: Health and Social Care Level 3 Diploma Course 04: Family Law Course 05: Domestic Violence and Abuse Awareness Diploma Course 06: Marriage and Family Therapy Course 07: Vulnerability, Abuse & Safeguarding Course 08: Safeguarding Adults Level 1 Course 09: Safeguarding Children Course Course 10: Youth Work Diploma Course 11: UK Health and Care Course 12: Healthcare GDPR Training Course 13: Legal Secretary Course 14: Life Coaching Advanced Diploma Course 15: Mental Health Support Worker Course 16: Anti-Social Behaviour Course Course 17: Assertiveness Communication Skills using Positive Psychology Course 18: Risk Assessment in Health & Social Care Course 19: Communication & Information Handling in Care Course 20: Emotional Intelligence and Human Behaviour Course 21: Counselling Skills Training Course 22: Compassion Focused Therapy Course 23: Cognitive Behavioural Therapy Course Course 24: Effective Methods of Public Speaking and Presentation Skill Course 25: Developing Interpersonal Skills Course With Social Work Practice, you'll embark on an immersive learning experience that combines interactive lessons with voice-over audio, ensuring that you can learn from anywhere in the world, at your own pace. And with 24/7 tutor support, you'll never feel alone in your journey, whether you're a seasoned professional or a beginner. Don't let this opportunity pass you by. Enrol in Social Work Practice today and take the first step towards achieving your goals and dreams. Why buy this Social Work Practice? Free CPD Accredited Certificate upon completion of Social Work Practice Get a free student ID card with Social Work Practice Lifetime access to the Social Work Practice course materials Get instant access to this Social Work Practice course Learn Social Work Practice from anywhere in the world 24/7 tutor support with the Social Work Practice course. Start your learning journey straightaway with our Social Work Practice Training! The Social Work Practice premium bundle consists of 25 precisely chosen courses on a wide range of topics essential for anyone looking to excel in this field. Each segment of Social Work Practice is meticulously designed to maximize learning and engagement, blending interactive content and audio-visual modules for a truly immersive experience. Certification You have to complete the assignment given at the end of the Social Work Practice course. After passing the Social Work Practice exam You will be entitled to claim a PDF & Hardcopy certificate accredited by CPD Quality standards completely free. CPD 250 CPD hours / points Accredited by CPD Quality Standards Who is this course for? This Social Work Practice course is ideal for: Students Seeking Mastery in Social Work Practice Professionals seeking to enhance Social Work Practice skills Individuals looking for a Social Work Practice-related career. Anyone passionate about Social Work Practice Requirements This Social Work Practice doesn't require prior experience and is suitable for diverse learners. Career path This Social Work Practice bundle will allow you to kickstart or take your career in the related sector to the next stage. Certificates CPD Accredited Digital certificate Digital certificate - Included CPD Accredited Hard copy certificate Hard copy certificate - Included If you are an international student, then you have to pay an additional 10 GBP for each certificate as an international delivery charge.

Social Work Practice - CPD Certified
Delivered Online On Demand4 days
£149

Intermediate Adobe InDesign Online

By Platform Training

During this 1 day Intermediate level InDesign course you will explore powerful layout and typographical controls, working with layers, creating multipage documents, using clipping paths and preparing for print. This course is ideal for anybody who already uses InDesign and wishes to progress to a professional level. Comprehensive colour management, typography and advanced graphics and effects are also covered.

Intermediate Adobe InDesign Online
Delivered OnlineFlexible Dates
£192

Time Management and Productivity: Virtual In-House Training

By IIL Europe Ltd

Time Management and Productivity: Virtual In-House Training Effective time management reduces stress and helps you better adhere to commitments. This course is designed to help you identify personal and organizational priorities and gain better control of where you focus your attention. You will explore the importance of planning and organizing, and you will practice sorting through and setting priorities. You will also learn how to set better time boundaries and manage the demands of others. Working with a time management framework, you will use a set of practical techniques to organize and manage your work to better deliver on your commitments. Techniques for overcoming procrastination will be addressed, as well as strategies for dealing with information overload. What you Will Learn Plan and prioritize each day's activities in a more efficient, productive manner Establish strategies to execute priorities and overcome procrastination Understand how to make trade-offs when faced with fire drills How to set and communicate boundary conditions Getting Started Introductions Course orientation Participants' expectations Foundation Concepts Exercise: A day in your life Resources to implement change Mind-set Tool-set Skill-set What is your time really worth? The dynamics of procrastination The myth of multi-tasking Brain Rules - how to optimize your efficiency Organization and Prioritization Time management best practices Goal setting Exercise: Identifying your priorities The importance of organization Time management framework Prioritizing time Time Management Techniques Tips for managing time Nine ways to overcome procrastination The STING technique Managing your time o Handling unplanned urgencies o Dealing with information overload Delegation and managing others' time Creating your personal action plan Summary Course summary and next steps Applying what you have learned

Time Management and Productivity: Virtual In-House Training
Delivered OnlineFlexible Dates
£450

Time Management and Productivity: In-House Training

By IIL Europe Ltd

What you Will Learn Plan and prioritize each day's activities in a more efficient, productive manner Establish strategies to execute priorities and overcome procrastination Understand how to make trade-offs when faced with fire drills How to set and communicate boundary conditions Getting Started Introductions Course orientation Participants' expectations Foundation Concepts Exercise: A day in your life Resources to implement change Mind-set Tool-set Skill-set What is your time really worth? The dynamics of procrastination The myth of multi-tasking Brain Rules - how to optimize your efficiency Organization and Prioritization Time management best practices Goal setting Exercise: Identifying your priorities The importance of organization Time management framework Prioritizing time Time Management Techniques Tips for managing time Nine ways to overcome procrastination The STING technique Managing your time o Handling unplanned urgencies o Dealing with information overload Delegation and managing others' time Creating your personal action plan Summary Course summary and next steps Applying what you have learned

Time Management and Productivity: In-House Training
Delivered in London or UK Wide or OnlineFlexible Dates
£450

HVAC: Heating, Ventilation & Air Conditioning (HVAC) Technician - CPD Certified

5.0(10)

By Apex Learning

Package Details: Number of Courses: 30 Courses Accreditation: CPD Quality Standards Free Certificates:PDF: 30Hardcopy: 30 (Charge Applicable) Courses Access: Lifetime Instalment Payment Available HVAC and Home Appliance Training Course 01: Level 3 Heating, Ventilation & Air Conditioning (HVAC) Technician Course 02: Heat Exchanger Course 03: PAT Level 4 Course 04: Smart Meter Installer Training Course 05: Domestic Appliance Repairing Course Course 06: Electronic & Electrical Devices Maintenance HVAC and Home Appliance Training Course 07: Electrician Electrical Engineering Course 01: Digital Electric Circuits & Intelligent Electrical Devices Course 02: Electric Power Metering for Single and Three Phase Systems Course 03: Light Current Systems for Electrical Engineering Course 04: Basic AC Circuit Analysis Course 05: Electrical 3 Phase Power Transformers Fundamentals Course 06: Electrical Power System and High Voltage Engineering Course 07: Electrical Engineering for Electrical Substations Course 08: Electrician Skills Complete Bundle Course 09: Energy Saving in Electric Motors Course 10: MATLAB Simulink for Electrical Power Engineering Course 11: Power Electronics for Electrical Engineering Course 12: Solar Energy Electrical & Workplace Safety Course 01: Protection and Control of High Voltage Power Circuits Course 02: Distribution Station & Feeder Protection Course 03: Electrical and Fire Safety Training - Level 2 Course 04: Advanced Electrical Safety Course 05: Workplace Safety Course Course 06: First Aid at Work Course 07: Manual Handling Level 2 Course 08: PUWER Course 09: Working at Height Awareness Diploma Course 10: Lone Worker Safety Course Course 11: Working in Confined Spaces Benefits you'll get from choosing Apex Learning for this training: Pay once and get lifetime access Free e-Learning App for engaging reading materials & helpful assistance Certificates, student ID included in a one-time fee Free up your time - don't waste time and money travelling for classes Accessible, informative modules designed by expert instructors Learn anytime, from anywhere Study from your computer, tablet or mobile device CPD accredited course - improve the chance of gaining professional skills CPD 315 CPD hours / points Accredited by CPD Quality Standards

HVAC: Heating, Ventilation & Air Conditioning (HVAC) Technician - CPD Certified
Delivered Online On Demand
£150

Recruitment Interviewing

5.0(50)

By First Safety Training Services

For all staff members involved in the recruitment and interviewing process.

Recruitment Interviewing
Delivered In-PersonFlexible Dates
£140

Beginners Guide to Computers

By iStudy UK

Description: Computer operation can be difficult if you have no idea how to do it. However, it only takes a complete beginner course on the computer to learn how. You need to learn the basics, operation systems and how healthy computing works which this course provides. If you think you are ready to start your journey in learning all about the computer, then you don't have to wait for. Start learning now and understand why the computer is considered as a necessity in this modern age. Who is the course for? Beginner to advanced level users can benefit from the lessons we provide People who have an interest in learning about computer and computer maintenance Entry Requirement: This course is available to all learners, of all academic backgrounds. Learners should be aged 16 or over to undertake the qualification. Good understanding of English language, numeracy and ICT are required to attend this course. Assessment: At the end of the course, you will be required to sit an online multiple-choice test. Your test will be assessed automatically and immediately so that you will instantly know whether you have been successful. Before sitting for your final exam, you will have the opportunity to test your proficiency with a mock exam. Certification: After you have successfully passed the test, you will be able to obtain an Accredited Certificate of Achievement. You can however also obtain a Course Completion Certificate following the course completion without sitting for the test. Certificates can be obtained either in hard copy at the cost of £39 or in PDF format at the cost of £24. PDF certificate's turnaround time is 24 hours, and for the hardcopy certificate, it is 3-9 working days. Why choose us? Affordable, engaging & high-quality e-learning study materials; Tutorial videos/materials from the industry leading experts; Study in a user-friendly, advanced online learning platform; Efficient exam systems for the assessment and instant result; The UK & internationally recognized accredited qualification; Access to course content on mobile, tablet or desktop from anywhere anytime; The benefit of applying for NUS Extra Discount Card; 24/7 student support via email. Career Path: The Beginners Guide to Computers is a very useful qualification to possess, and will be very helpful to have especially for these careers: Computer Maintenance Staff IT Department Manager Computer Engineer Computer Specialist Computer Technician. Computer Basics Introduction FREE 00:15:00 Understanding The Components Of A PC FREE 01:30:00 Do You Need To Upgrade Your PC? 01:00:00 Essential Softwares You Must Have On Your PC 01:00:00 Installing And Organizing Your PC 01:00:00 Troubleshooting Guidelines 01:00:00 How To Speak To A Technician 00:30:00 Summary 00:30:00 Operating Systems Introduction 00:15:00 What is an Operating System? 00:30:00 History of Operating System 00:30:00 What an Operating System Does 01:00:00 Microsoft Windows 01:00:00 MAC OS 01:00:00 UNIX 00:30:00 LINUX 00:30:00 GNU 00:30:00 Other Operating Systems 01:00:00 Installing an Operating System 01:00:00 Defining The Processes 01:00:00 Conclusion 00:15:00 Healthy Computing Introduction 01:00:00 Body Position 01:00:00 Monitors 01:00:00 Keyboards 01:00:00 Mouse or Pointer 02:00:00 Document Holders and Desk 01:00:00 Chairs 02:00:00 Telephones 00:30:00 What Have We Learned 01:00:00 Work Process and Recognition 01:00:00 Lighting 01:00:00 Ventilation 00:30:00 Awkward Postures 02:00:00 Musculoskeletal Disorders (MSD) 02:00:00 4 Steps to Setting Up The Computer Workstation 01:00:00 Exercises and Breaks 01:00:00 Conclusion 00:15:00 Mock Exam Final Exam

Beginners Guide to Computers
Delivered Online On Demand35 hours
£25

Spill Management Training

5.0(10)

By Apex Learning

Overview This comprehensive course on Spill Management Training will deepen your understanding on this topic. After successful completion of this course you can acquire the required skills in this sector. This Spill Management Training comes with accredited certification which will enhance your CV and make you worthy in the job market. So enrol in this course today to fast track your career ladder. How will I get my certificate? At the end of the course there will be an online written test which you can take either during or after the course. After successfully completing the test you will be able to order your certificate, these are included in the price. Who is this course for? There is no experience or previous qualifications required for enrolment on this Spill Management Training . It is available to all students, of all academic backgrounds. Requirements Our Spill Management Training  is fully compatible with PC's, Mac's, Laptop, Tablet and Smartphone devices. This course has been designed to be fully compatible on tablets and smartphones so you can access your course on wifi, 3G or 4G. There is no time limit for completing this course, it can be studied in your own time at your own pace. Career path Having these various qualifications will increase the value in your CV and open you up to multiple sectors such as Business & Management, Admin, Accountancy & Finance, Secretarial & PA, Teaching & Mentoring etc. Course Curriculum 11 sections • 11 lectures • 03:08:00 total length •Introduction to Spill Management: 00:24:00 •Hazardous Substances: 00:23:00 •Pollution Incident Response Planning: 00:11:00 •Managing a Spill: 00:38:00 •Spill Clean-Up Guideline: 00:17:00 •Spills on a Road or Highway: 00:14:00 •Diesel Spillages An Overview: 00:22:00 •Site-Specific Pollution Control Options: 00:12:00 •Spill Prevention & Control Checklist: 00:14:00 •Ways to Encourage Best Practice: 00:13:00 •Assignment - Spill Management Training: 00:00:00

Spill Management Training
Delivered Online On Demand3 hours 8 minutes
£12

Module 10 Part 2 working with children and young adults

5.0(22)

By The Northern College Of Clinical Hypnotherapy

Discover effective strategies for using hypnotherapy with children experiencing common disorders and challenges in our comprehensive workshop. We blend Western medical insights with holistic approaches to provide a well-rounded understanding and practical tools for supporting children's holistic development.

Module 10 Part 2 working with children and young adults
Delivered Online On Demand15 hours
£149