17299 Other courses in Ware delivered Online

Discover the fundamental principles of Interpretative Phenomenological Analysis (IPA) in this comprehensive course, specifically designed to help individuals understand the key concepts behind this qualitative research method. IPA focuses on exploring how people make sense of their personal and social worlds, offering a deep dive into interpreting individual lived experiences. This course equips learners with the necessary tools and techniques to analyse data with precision, guiding you through the process of examining people's perceptions and meanings in a structured, insightful manner. Throughout this course, you will gain a clear understanding of the philosophical foundations of IPA, its core assumptions, and how it differs from other qualitative research methods. From learning how to collect and analyse rich, detailed data, to interpreting complex themes within your research, this course provides an engaging and accessible pathway for those keen to develop a strong foundation in IPA. With an emphasis on applying theory to practice, you'll be prepared to integrate IPA into your future research projects with confidence and skill. Key Features CPD Accredited FREE PDF + Hardcopy certificate Fully online, interactive course Self-paced learning and laptop, tablet and smartphone-friendly 24/7 Learning Assistance Discounts on bulk purchases Course Curriculum Module 01: Introduction to Interpretative Phenomenological Analysis (IPA) Module 02: IPA and the Theory Module 03: Planning an IPA Research Study Module 04: Collecting Data Module 05: Analysis Module 06: Writing Module 07: Advanced Designs and Innovative Approaches Learning Outcomes Recognise core principles and fundamentals of Interpretative Phenomenological Analysis (IPA). Link IPA concepts with underlying theoretical foundations and relevant literature. Formulate a comprehensive plan for an IPA-based research study. Implement strategies for effective data collection within IPA guidelines. Apply rigorous analysis techniques to interpret collected qualitative data. Demonstrate proficiency in articulating research findings through structured writing. Accreditation This course is CPD Quality Standards (CPD QS) accredited, providing you with up-to-date skills and knowledge and helping you to become more competent and effective in your chosen field. Certificate After completing this course, you will get a FREE Digital Certificate from Training Express. CPD 10 CPD hours / points Accredited by CPD Quality Standards Who is this course for? Researchers aiming to deepen qualitative analysis skills. Academics exploring IPA's relevance to their disciplines. Students seeking a robust understanding of IPA methodology. Professionals considering IPA in future research endeavours. Individuals keen on understanding phenomenological research nuances. Career path Research Analyst in Social Sciences. Academic Researcher in Qualitative Studies. Qualitative Data Consultant. Research Coordinator for Qualitative Projects. Ethnographic Research Specialist. Qualitative Methodology Advisor. Certificates Digital certificate Digital certificate - Included Once you've successfully completed your course, you will immediately be sent a FREE digital certificate. Hard copy certificate Hard copy certificate - Included Also, you can have your FREE printed certificate delivered by post (shipping cost £3.99 in the UK). For all international addresses outside of the United Kingdom, the delivery fee for a hardcopy certificate will be only £10. Our certifications have no expiry dates, although we do recommend that you renew them every 12 months.

The Workplace First Aid Level 3 Course is an essential qualification for anyone looking to become a vital member of their workplace safety team. Whether you’re working in an office, factory, or any other environment, having first aid knowledge is invaluable. This course ensures you are well-equipped to deal with emergencies, offering clear, concise, and life-saving information that anyone can understand. With a straightforward structure and simple guidance, this course will help you confidently respond to incidents, knowing exactly what to do in critical moments. In today's fast-paced work environments, ensuring the safety and well-being of your colleagues is more important than ever. This Level 3 course is designed to help you navigate a variety of first aid scenarios—from dealing with burns, fractures, and bleeding to handling heart attacks and strokes. By gaining this qualification, you not only become an asset to your team but also help foster a safer, more confident workplace. With easy-to-follow content, you'll be prepared to handle emergencies calmly, knowing you have the knowledge to make a real difference when it matters most. Key Features Accredited by CPD Instant e-certificate Fully online, interactive Workplace First Aid Level 3 course with audio voiceover Self-paced learning and laptop, tablet, smartphone-friendly 24/7 Learning Assistance Discounts on bulk purchases Free Gifts Life Coaching Course Enrol now in this Workplace First Aid Level 3 course to excel! To become successful in your profession, you must have a specific set of skills to succeed in today's competitive world. In this in-depth Workplace First Aid Level 3 training course, you will develop the most in-demand skills to kickstart your career, as well as upgrade your existing knowledge & skills. The curriculum of the Workplace First Aid Level 3 course has been designed by experts with years of experience behind them which is extremely dynamic and well-paced to help you understand the subject matter with ease. Accreditation This Workplace First Aid Level 3 is CPD Quality Standards (CPD QS) Accredited, providing you with up-to-date skills and knowledge and helping you to become more competent and effective in your chosen field. Certification Once you've successfully completed your Workplace First Aid Level 3 course, you will immediately be sent a digital certificate. Also, you can have your printed certificate delivered by post (shipping cost £3.99). CPD 10 CPD hours / points Accredited by The CPD Quality Standards Who is this course for? This course is ideal for all employees or anyone who genuinely wishes to learn more about Workplace First Aid Level 3 basics. Requirements No prior degree or experience is required to enrol in this course. Certificates Certificate of completion Digital certificate - Included Certificate of completion Hard copy certificate - Included You will get the hard copy certificates for Free! The delivery charge of the hard copy certificate inside the UK is £3.99 each.

Forensic Anthropology is the fascinating field where science meets criminal investigation, providing crucial insights into human remains and aiding law enforcement in solving mysteries. This course offers a deep dive into the methods and techniques used to determine the identity, cause of death, and time of death of human remains, all through the lens of anthropology. You'll explore how forensic anthropologists help authorities in cases involving unidentified bodies and mass fatalities, making their work critical in modern investigations. In this online course, you’ll explore various elements, from osteology to trauma analysis, learning how to read skeletal remains like a book. You'll also gain an understanding of how forensic anthropologists collaborate with other specialists, such as forensic pathologists and law enforcement, in solving cases. This course is designed for those curious about the science behind criminal investigations and the important role forensic anthropology plays in bringing justice. Whether you’re looking to explore a new field or enhance your knowledge, this course will help you understand the science behind forensic anthropology in an engaging, straightforward way. Key Features CPD Accredited FREE PDF + Hardcopy certificate Fully online, interactive course Self-paced learning and laptop, tablet and smartphone-friendly 24/7 Learning Assistance Discounts on bulk purchases Course Curriculum Module 1: Introduction to Forensic Anthropology Module 2: Human Osteology Module 3: Forensic Taphonomy Module 4: Trauma and Injury Analysis Module 5: Forensic Archaeology Module 6: Skeletal Identification Module 7: Human Rights and Mass Disasters Module 8: Expert Testimony and Courtroom Presentation Module 9: Forensic Anthropology and Forensic Science Integration Learning Outcomes: Analyse skeletal remains for trauma and injury identification. Apply forensic taphonomy principles to crime scene investigation. Demonstrate expertise in human rights and mass disaster contexts. Execute effective courtroom presentations as a forensic anthropology expert. Integrate forensic anthropology knowledge with broader forensic science practices. Contribute to the field through advanced skills in skeletal identification. Accreditation This course is CPD Quality Standards (CPD QS) accredited, providing you with up-to-date skills and knowledge and helping you to become more competent and effective in your chosen field. Certificate After completing this course, you will get a FREE Digital Certificate from Training Express. CPD 10 CPD hours / points Accredited by CPD Quality Standards Who is this course for? Aspiring Forensic Scientists Anthropology Enthusiasts Crime Scene Investigators Legal Professionals Archaeology Enthusiasts Human Rights Advocates Emergency Response Personnel Those Seeking In-Depth Scientific Knowledge Career path Forensic Anthropologist Archaeological Consultant Crime Scene Investigator Human Rights Advocate Forensic Scientist Emergency Response Specialist Certificates Digital certificate Digital certificate - Included Once you've successfully completed your course, you will immediately be sent a FREE digital certificate. Hard copy certificate Hard copy certificate - Included Also, you can have your FREE printed certificate delivered by post (shipping cost £3.99 in the UK). For all international addresses outside of the United Kingdom, the delivery fee for a hardcopy certificate will be only £10. Our certifications have no expiry dates, although we do recommend that you renew them every 12 months.

In today’s interconnected world, effective conflict resolution is crucial, especially in professional and personal relationships. This Mediation Basics for Conflict Resolution course offers a thorough understanding of how mediation works as a neutral process to resolve disputes and bring about mutual agreements. Learners will delve into the essential principles of mediation, gaining insight into the structure and methods employed by mediators. This course is designed for individuals interested in resolving conflicts amicably, whether in workplaces, communities, or other areas of life, without requiring direct confrontation. By the end of the course, participants will be equipped with the knowledge to facilitate peaceful negotiations and become proficient in resolving disagreements. The course covers the necessary tools and techniques that contribute to effective mediation, such as active listening, creating common ground, and promoting fairness. Whether you’re a manager, HR professional, or simply someone wanting to improve their conflict resolution skills, this course offers valuable information that is easy to grasp and apply. Join us and learn how to handle conflicts in a constructive, positive manner while ensuring lasting solutions are achieved. Key Features CPD Accredited FREE PDF + Hardcopy certificate Fully online, interactive course Self-paced learning and laptop, tablet and smartphone-friendly 24/7 Learning Assistance Discounts on bulk purchases Course Curriculum Module 01: Introduction to Mediation Module 02: Essential Skills for Mediators Module 03: The Mediation Process Module 04: Mediation Ethics and Professional Standards Module 05: Special Considerations in Mediation Learning Outcomes: Navigate mediation intricacies with foundational knowledge. Demonstrate essential skills crucial for effective conflict resolution. Execute the mediation process with precision and finesse. Uphold ethical standards and professional conduct in mediation. Address special considerations with expertise and sensitivity. Master conflict resolution for a fulfilling career in mediation. Accreditation This course is CPD Quality Standards (CPD QS) accredited, providing you with up-to-date skills and knowledge and helping you to become more competent and effective in your chosen field. Certificate After completing this course, you will get a FREE Digital Certificate from Training Express. CPD 10 CPD hours / points Accredited by CPD Quality Standards Who is this course for? Professionals in conflict management roles. Individuals seeking a career in mediation. Human resources practitioners. Legal professionals enhancing dispute resolution skills. Managers and team leaders in diverse industries. Counsellors and social workers interested in conflict resolution. Business owners managing internal disputes. Anyone passionate about effective conflict resolution. Career path Mediation Consultant Conflict Resolution Specialist Human Resources Mediator Legal Dispute Resolution Officer Workplace Mediation Coordinator Family Mediation Practitioner Certificates Digital certificate Digital certificate - Included Once you've successfully completed your course, you will immediately be sent a FREE digital certificate. Hard copy certificate Hard copy certificate - Included Also, you can have your FREE printed certificate delivered by post (shipping cost £3.99 in the UK). For all international addresses outside of the United Kingdom, the delivery fee for a hardcopy certificate will be only £10. Our certifications have no expiry dates, although we do recommend that you renew them every 12 months.

Train to become a skilled Private Investigator (PI) with our comprehensive diploma. Learn essential investigative techniques, from surveillance to business setup, and start your career with confidence. Enrol today!

Level 2 Health & Care Do you want to pursue a career in health and social skills to support others in achieving success in daily life? If so, enrolling in this Level 2 Health & Care course could help you build the knowledge and skills necessary to advance your career. In this Level 2 Health & Care course, concepts and responsibilities connected to health and social care are discussed briefly. You can manage risk in social care and learn how to protect the weak from harm by taking Level 2 Health & Care. In addition, this Level 2 Health & Care course explains the duties, laws, and ethics. The Level 2 Health & Care course also covers diversity, patient rights, and other pertinent areas of healthcare and social work. You will have the knowledge and skills required for managerial and care-related jobs after completing this Level 2 Health & Care. Why then wait? Enrol right away in the Level 2 Health & Care course! Learning Outcome of Level 2 Health & Care Course After completing this Level 2 Health & Care course, you will learn about: A brief idea about the Safety in the Workplace from this Level 2 Health & Care course. The Level 2 Health & Care course explains broadly about hazards. You will learn about rectifying hazards with the help of this Level 2 Health & Care course. The Level 2 Health & Care course helps to implement proactive measures. How to prepare and undertake a safety plan is also a part of the Level 2 Health & Care course. Level 2 Health & Care Course This Health & Care: Health & Care Course includes a FREE PDF Certificate. Lifetime access to this Health & Care: Health & Care Course Instant access to this Health & Care: Health & Care Course Get FREE Tutor Support to this Health & Care: Health & Care Course Level 2 Health & Care Unlock a fulfilling career with our Health & Care: Health & Care Level 2 course! Gain the essential skills and knowledge to support others in daily life through Health & Care: Health & Care training. Learn key concepts and responsibilities in Health & Care: Health & Care, including risk management, protecting the vulnerable, and understanding laws and ethics. This Health & Care: Health & Care course also covers diversity, patient rights, and critical aspects of social work. Prepare for managerial and care-related roles with Health & Care: Health & Care expertise. Don’t wait—enroll now in Health & Care: Health & Care! Who is this course for? Level 2 Health & Care This Level 2 Health & Care course is suitable for anyone aspiring to start a career in the relevant field. Requirements Level 2 Health & Care To enrol in this Level 2 Health & Care Course, students must fulfil the following requirements: Good Command over English language is mandatory to enrol in our Health & Care: Health & Care Course. Be energetic and self-motivated to complete our Health & Care: Health & Care Course. Basic computer Skill is required to complete our Health & Care: Health & Care Course. If you want to enrol in our Health & Care: Health & Care Course, you must be at least 15 years old. Career path Level 2 Health & Care This Level 2 Health & Care course will lead you to many different career opportunities, here are a few prospects: Child Support Worker Healthcare Assistant Social Worker Care Worker

Health and safety: Health and safety Course Do you want to learn more about health and safety so that you can protect yourself and others? Employees who complete this health and safety: health and safety Course program will become more aware of their own safety as well as the safety of clients and other members of the public. Several modules in our health and safety: health and safety Course training are designed to educate students about the law, risk assessment, and maintaining workplace safety. Through this health and safety: health and safety Course, you will also learn about preserving workplace welfare. You will learn how to handle and use screen equipment in this health and safety: health and safety Course. Working at Height and Hazardous Substances are also covered in this health and safety: health and safety Course material. You will correctly maintain noise, vibration, and vehicle safety once you have completed this health and safety: health and safety Course. Learn more about workplace safety by enrolling in our health and safety: health and safety Course. Main Course: Level 2 Health and Safety in the Workplace Free Courses are including with this health and safety: health and safety Course Course 01: First Aid at Work Course 02: Level 1 Health and Safety in a Construction Environment Special Offers of this health and safety: health and safety Course This health and safety: health and safety Course includes a FREE PDF Certificate. Lifetime access to this health and safety: health and safety Course Instant access to this health and safety: health and safety Course Get FREE Tutor Support to this health and safety: health and safety Course health and safety: health and safety Course Those who want to assume more responsibility are the target audience for this Health and Safety: Health and Safety at Workcourse on Managing Health and Safety at Work. The most important workplace health and safety guidelines should be understood by managers, team leaders, business owners, and workers at all levels. It is strongly advised that everyone, from beginners to seasoned pros, go over critical health and safety issues on a regular basis. Who is this course for? Health and safety: Health and safety Course All employees, regardless of level, should take advantage of this health and safety: health and safety Course. Requirements Health and safety: Health and safety Course To enrol in this health and safety: health and safety Course, students must fulfil the following requirements. To join in our health and safety: health and safety Course, you must have a strong command of the English language. To successfully complete our health and safety: health and safety Course, you must be vivacious and self driven. To complete our health and safety: health and safety Course, you must have a basic understanding of computers. A minimum age limit of 15 is required to enrol in this health and safety: health and safety Course Career path Health and safety: Health and safety Course Your Resume will stand out from the crowd and be better prepared for subsequent courses if you take this health and safety: health and safety Course

Autism: Autism Course Online Would you like to know more about the complicated developmental diseases known as autism? You may learn all there is to know about mental health and wellbeing with the help of this Level 3 Certificate in Understanding Autism. You will discover the traits of autism and how to diagnose it throughout this Level 3 Certificate in Understanding Autism Course. Also, this Level 3 Certificate in Understanding Autism training addresses autism resiliency and safeguarding. In the Level 3 Certificate in Understanding Autism, it is covered how autism affects social and emotional growth as well as how to support those who have autism. Also, Level 3 Certificate in Understanding Autism will help you to acquire vital communication abilities that are perfect for people who work in special education. You will have a thorough understanding of autism awareness by the end of the Level 3 Certificate in Understanding Autism course. If you want to advance in the health and social care industry, enrol in the Level 3 Certificate in Understanding Autism course. Learning Objectives After completing this Level 3 Certificate in Understanding Autism course, you will be able to: Understand how to communicate with people who have autism and how to interact with them socially. Know how to assist and manage transitions for people with autism. Know how to provide positive behavioural support to people with autism. Understand the therapeutic approaches and resources available to people with autism and co-occurring disorders. Main Course: Autism: Level 3 Certificate in Understanding Autism Course Free Courses are including with this Autism: Autism Course Course 01: Early Years Level 4 Course 02: SEN Teaching Assistant Special Offers of this Autism: Autism Course This Autism: Autism Course includes a FREE PDF Certificate. Lifetime access to this Autism: Autism Course Instant access to this Autism: Autism Course Get FREE Tutor Support to this Autism: Autism Course Autism: Autism Course Online You will learn about autism's characteristics, diagnosis techniques, social interactions and communication with autistic people, autism resilience and safety, and much more in this Level 3 Certificate in Understanding Autism course. By the time the course ends, you will have a firm grasp of autism awareness and the abilities required to manage and cope with autism. Who is this course for? Autism: Autism Course Online Everyone interested in learning more about autism and how to support others in society is welcome to enrol in the Autism: Autism Course. Requirements Autism: Autism Course Online To enrol in this Autism: Autism Course, students must fulfil the following requirements. To join in our Autism: Autism Course, you must have a strong command of the English language. To successfully complete our Autism: Autism Course, you must be vivacious and self driven. To complete our Autism: Autism Course, you must have a basic understanding of computers. A minimum age limit of 15 is required to enrol in this Autism: Autism Course Career path Autism: Autism Course Online Your Autism: Autism Course will be helpful for your training as a teacher, teaching assistant, in health and social care, in customer service, and in many other areas.

Quality Guarantee: Promising training excellence, satisfaction gurantee Accredited by: CPD UK & Quality License Scheme Tutor Support: Unlimited support via email, till you complete the course Recognised Certification: Accepted by thousands of professional bodies Start Anytime: With 1 year access to the course materials Online Learning: Learn from anywhere, whenever you want Why Autobiography Writing Course right for you? Whether you are self-taught and you want to fill in the gaps for better efficiency and productivity, this Autobiography Writing course will set you up with a solid foundation to become a confident autobiography writer and develop more advanced skills.This comprehensive Autobiography Writing course is the perfect way to kickstart your career in the field of autobiography writing. This course will give you a competitive advantage in your career, making you stand out from all other applicants and employees.As one of the leading course providers and most renowned e-learning specialists online, we're dedicated to giving you the best educational experience possible. This course is crafted by industry expert, to enable you to learn quickly and efficiently, and at your own pace and convenience. Autobiography Writing Course Details Accredited by CPD certificates are accepted by thousands of professional bodies and government regulators here in the UK and around the world. Many organisations look for employees with CPD requirements, which means, that by doing this course, you would be a potential candidate in your respective field.   The Quality Licence Scheme is a brand of the Skills and Education Group, a leading national awarding organisation for providing high-quality vocational qualifications across a wide range of industries. Course Curriculum Module 01: Remembering Your Life Module 01: Remembering Your Life Module 02: Structure and Content Module 02: Structure and Content Module 03: Writing Your Autobiography Module 03: Writing Your Autobiography Module 04: Where to Now Module 04: Where to Now Who should take this course? This comprehensive Autobiography Writing course is suitable for anyone looking to improve their job prospects or aspiring to accelerate their career in this sector and want to gain in-depth knowledge of autobiography writing. Entry Requirements There are no academic entry requirements for this Autobiography Writing course, and it is open to students of all academic backgrounds. As long as you are aged seventeen or over and have a basic grasp of English, numeracy and ICT, you will be eligible to enrol. Assessment Method On successful completion of the course, you will be required to sit an online multiple-choice assessment. The assessment will be evaluated automatically and the results will be given to you immediately. Certification Endorsed Certificate from Quality Licence Scheme After successfully passing the MCQ exam you will be eligible to order the Endorsed Certificate by Quality Licence Scheme. The Quality Licence Scheme is a brand of the Skills and Education Group, a leading national awarding organisation for providing high-quality vocational qualifications across a wide range of industries. It will give you a competitive advantage in your career, making you stand out from all other applicants and employees. There is a Quality Licence Scheme endorsement fee to obtain an endorsed certificate which is £65. Certificate of Achievement from Lead Academy After successfully passing the MCQ exam you will be eligible to order your certificate of achievement as proof of your new skill. The certificate of achievement is an official credential that confirms that you successfully finished a course with Lead Academy. Certificate can be obtained in PDF version at a cost of £12, and there is an additional fee to obtain a printed copy certificate which is £35. FAQs Is CPD a recognised qualification in the UK? CPD is globally recognised by employers, professional organisations and academic intuitions, thus a certificate from CPD Certification Service creates value towards your professional goal and achievement. CPD-certified certificates are accepted by thousands of professional bodies and government regulators here in the UK and around the world. Are QLS courses recognised? Although QLS courses are not subject to Ofqual regulation, they must adhere to an extremely high level that is set and regulated independently across the globe. A course that has been approved by the Quality Licence Scheme simply indicates that it has been examined and evaluated in terms of quality and fulfils the predetermined quality standards. When will I receive my certificate? For CPD accredited PDF certificate it will take 24 hours, however for the hardcopy CPD certificate takes 5-7 business days and for the Quality License Scheme certificate it will take 7-9 business days. Can I pay by invoice? Yes, you can pay via Invoice or Purchase Order, please contact us at info@lead-academy.org for invoice payment. Can I pay via instalment? Yes, you can pay via instalments at checkout. How to take online classes from home? Our platform provides easy and comfortable access for all learners; all you need is a stable internet connection and a device such as a laptop, desktop PC, tablet, or mobile phone. The learning site is accessible 24/7, allowing you to take the course at your own pace while relaxing in the privacy of your home or workplace. Does age matter in online learning? No, there is no age limit for online learning. Online learning is accessible to people of all ages and requires no age-specific criteria to pursue a course of interest. As opposed to degrees pursued at university, online courses are designed to break the barriers of age limitation that aim to limit the learner's ability to learn new things, diversify their skills, and expand their horizons. When I will get the login details for my course? After successfully purchasing the course, you will receive an email within 24 hours with the login details of your course. Kindly check your inbox, junk or spam folder, or you can contact our client success team via info@lead-academy.org

Duration 5 Days 30 CPD hours This course is intended for This course is intended for individuals who are Application designers and database developers, database administrators and web server administrators. Overview Upon successful completion of this course, students will be able to work with Oracle database programming using the PL/SQL programming language. They will learn the syntax, structure and features of the language. In this course, students will learn the foundation for the programming series and the use of database-resident stored program units for Oracle 12c. Selection & Setup of the Database Interface Considering Available Tools Selecting the Appropriate Tool Oracle Net Database Connections Oracle PAAS Database Connections Setup SQL Developer Setup SQL*Plus Setup Jdeveloper About Bind & Substitution Variables Using SQL Developer Using SQL*Plus Choosing a Database Programming Language What is Database Programming? PL?SQL Performance Advantages Integration wth Other Languages PL/SQL Language Fundamentals PL/SQL Program Structure LANGUAGE SYNTAX RULES EMBEDDING SQL WRITING READABLE CODE GENERATING DATABASE OUTPUT SQL*PLUS INPUT OF A PROGRAM BLOCK Declare Section About the Declare Section DECLARE PRIMITIVE TYPES DECLARATION OPTIONS NOT NULL CONSTANT DATA DICTIONARY INTEGRATION %TYPE DECLARE SIMPLE USER---DEFINED TYPES TYPE... TABLE TYPE... RECORD EXTENDED USER---DEFINED TYPES Begin Section About the Begin Section Manipulating Program Data Logic Control & Branching GOTO LOOP IF-THEN-ELSE CASE Exception Section ABOUT THE EXCEPTION SECTION ISOLATING THE SPECIFIC EXCEPTION PRAGMA EXCEPTION_INIT SQLCODE &SQLERRM Example SQL%ROWCOUNT &SELECT...INTO Beyond the Basics: Explicit Cursors ABOUT EXPLICIT CURSORS EXTENDED CURSOR TECHNIQUES FOR UPDATE OF Clause WHERE CURRENT OF Clause Using FOR?LOOP Cursors Beyond the Basics: Nested BlocksBeyond the Basics: Declared Subprograms USING DECLARED SUBPROGRAMS DECLARED PROCEDURE DECLARED FUNCTION Introducing Databse-Resident Program Units ABOUT DATABASE---RESIDENT PROGRAMS PHYSICAL STORAGE & EXECUTION TYPES OF STORED PROGRAM UNITS STORED PROGRAM UNIT ADVANTAGES MODULAR DESIGN PRINCIPLES Creating Stored Procedures & Functions STORED PROCEDURES & FUNCTIONS CREATE PROCEDURE / CREATE FUNCTION CREATING PROCEDURES & FUNCTIONS RAISE_SALARY() Procedure SALARY_VALID() Function THE PARAMETER SPECIFICATION DEFAULT Clause SYSTEM & OBJECT PRIVILEGES USING THE DEVELOPMENT TOOLS Executing Stored Procedures & Functions CALLING PROCEDURES & FUNCTIONS UNIT TESTING WITH EXECUTE ANONYMOUS BLOCK UNIT TESTING SPECIFYING A PARAMETER NOTATION SQL WORKSHEET UNIT TESTING CALLING FUNCTIONS FROM SQL Maintaining Stored Program Units RECOMPILING PROGRAMS Mass Recompilation Using UTL_RECOMP() DROPPING PROCEDURES & FUNCTIONS DROP PROCEDURE / FUNCTION DATA DICTIONARY METADATA Using USER_OBJECTS Using USER_SOURCE Using USER_ERRORS Using USER_OBJECT_SIZE Using USER_DEPENDENCIES Managing Dependencies DEPENDENCY INTERNALS TRACKING DEPENDENCIES THE DEPENDENCY TRACKING UTILITY SQL DEVELOPER DEPENDENCY INFO DEPENDENCY STRATEGY CHECKLISTS Creating & Maintaining Packages ABOUT PACKAGES CREATING PACKAGES MAINTAINING PACKAGES PERFORMANCE CONSIDERATIONS Advanced Package Capabilities DEFINER & INVOKER RIGHTS WHITE LITS & ACCESSIBLE BY PERSISTENT GLOBAL OBJECTS DEFINING INITIALIZATION LOGIC OBJECT ORIENTATION SUPPORT Advanced Cursor Techniques USING CUSROS VARIABLES USING SYS_REFCURSOR USING CURSOR EXPRESSIONS Using System-Supplied Package DBMS_OUTPUT() UTL_FILE() FOPEN() EXAMPLE Database Trigger Concepts ABOUT DATABASE TRIGGERS DML EVENT TRIGGER SUB---TYPES DATABASE TRIGGER SCENARIO TRIGGER EXECUTION MECHANISMS TRIGGERS WITHIN SQL WORKSHEET Creating Database Triggers STATEMENT-LEVEL TRIGGERS Using RAISE_APPLICATION_ERROR() ROW---LEVEL TRIGGERS EXAMPLES OF TRIGGERS EMPLOYEE_SALARY_CHECK Example EMPLOYEE_JOURNAL Example BUDGET_EVENT Example INSTEAD OF TRIGGERS TRIGGERS WITHIN AN APPLICATION Maintaining Database Triggers CALL SYNTAX TRIGGER MAINTENANCE TASKS SHOW ERRORS TRIGGER DROP TRIGGER ALTER TRIGGER MULTIPLE TRIGGERS FOR A TABLE HANDLING MUTATING TABLE ISSUES Implementing System Event Triggers WHAT ARE SYSTEM EVENT TRIGGERS? DEFININGTHE SCOPE AVAILABLE SYSTEM EVENTS SYSTEM EVENT ATTRIBUTES