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

20 Courses delivered Online

Advertising Complete Course

4.3(43)

By John Academy

Learn to advertise on all platforms and sell your products faster than a speeding bullet Bose, the headphone company, spends 90% of their budget on advertising. As a result, they are one of the most recognizable and successful brands out there. What you should take away from this is that marketing is an amazing tool if you can utilize it the right way, and if your business is going through hard times, marketing definitely might be able to help you reach a better status. Don't worry though, because this course is definitely going to help you, as it teaches you to market on multiple different platforms. First, you will be introduced to advertising and the different advertising concepts, like USP and AIDA. If you follow the course closely enough you may even pick up some branding tips as well. Following that you will take a step-by-step journey through the process of beginning affiliate marketing, selecting a product to promote, setting up a basic website blog and promoting your site. That's not all; you will also learn how to advertise on smartphones -the new wonder of the modern era. So stop wasting time, and get this amazing course right now. 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 a cost of £39 or in PDF format at a 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 recognised accredited qualification; Access to course content on mobile, tablet or desktop from anywhere anytime; The benefit of career advancement opportunities; 24/7 student support via email. Creating Advertisement What is Advertising? 01:00:00 Emphasize Benefits, Not Features 00:30:00 Push Their Emotional Hot Buttons 01:00:00 Incorporating Proof and Believability 01:00:00 The Unique Selling Proposition (USP) 01:00:00 The Headline 00:30:00 The More You Tell, The More You Sell 00:30:00 Write To Be Scanned 00:30:00 The Structure of AIDA 00:30:00 Use Takeaway Selling to Increase the Urgency 01:00:00 Conclusion 00:15:00 Internet Advertising INTRODUCTION: WHAT IS AFFILIATE MARKETING? 00:30:00 WHY AFFILIATE MARKETING IS AWESOME 00:30:00 FINDING A PROFITABLE NICHE 01:00:00 CHOOSING AN AFFILIATE PRODUCT 00:15:00 THE ADVANTAGES OF CLICK BANK 00:30:00 ANALYZING THE CLICK BANK MARKETPLACE 00:30:00 CREATING YOUR HOP LINK 00:30:00 CREATING A FREE BLOG 01:00:00 PERFORMING EFFECTIVE KEYWORD RESEARCH 00:30:00 CREATING AN OPTIMIZED POST 00:30:00 POSTING TO YOUR BLOG 00:15:00 PROMOTING YOUR BLOG: AN OVERVIEW 00:30:00 PROMOTION: ARTICLE MARKETING 00:30:00 PROMOTION: SOCIAL BOOKMARKING 01:00:00 PROMOTION: BLOG COMMENTING 00:30:00 ADDITIONAL PROMOTION TIPS 00:15:00 CREATING YOUR OWN WEBSITE 01:00:00 Smartphone Advertising INTRODUCTION 00:15:00 HOW NEXT GENERATION PHONES ARE GREAT ADVERTISING TOOLS 00:30:00 THE NEW GENERATION OF WIRELESS DEVICES 02:00:00 BUSINESS SECTOR USERS AND THEIR WIRELESS DEVICES 00:30:00 THE BEST PROCESS OF APPLICATION TO YOUR ADVERTISING ADVANTAGE 01:30:00 CREATING YOUR OWN APPLICATIONS 01:00:00 CONCLUSION 00:15:00 Mobile Marketing Introduction 00:30:00 Dominate Local Market with Mobile Marketing 00:30:00 Mobile Marketing Is Going Web 02:00:00 Effective Mobile Advertising 00:30:00 List Building with Mobile Marketing 02:00:00 The Surefire Success Mobile Marketing Campaign 00:30:00 Mock Exam Mock Exam- Advertising Complete Course 00:30:00 Final Exam Final Exam- Advertising Complete Course 00:30:00 Certificate and Transcript Order Your Certificates and Transcripts 00:00:00

Advertising Complete Course
Delivered Online On Demand30 hours
£25

Understanding Forgiveness

By Compete High

🤝 Embrace Healing and Harmony: Understanding Forgiveness Course! 🕊️ Are you ready to embark on a transformative journey towards understanding forgiveness and its profound impact on our lives? Enroll in our Understanding Forgiveness course, a comprehensive exploration meticulously crafted to guide you through the intricate pathways of forgiveness. Join us on a profound exploration where healing meets enlightenment, empowering you to cultivate compassion and foster reconciliation in every aspect of your life. 🌟 Module 1: Introduction to Forgiveness Embark on your journey with Module 1, offering a profound introduction to the essence of forgiveness. Delve into the core principles and transformative power of forgiveness, laying the groundwork for your exploration. 💔 Module 2: The Nature of Hurt and Offense Explore the depths of hurt and offense in Module 2. Uncover the underlying causes and consequences of emotional pain, gaining insights into the complexities of human relationships and the wounds they may inflict. 🧠Module 3: Psychological Processes of Forgiveness Navigate the psychological pathways of forgiveness in Module 3. Explore the cognitive and emotional processes involved in letting go of resentment and embracing forgiveness, fostering inner peace and liberation. 🤲 Module 4: The Role of Empathy and Compassion Discover the transformative power of empathy and compassion in Module 4. Learn to cultivate a heart-centered approach to forgiveness, fostering understanding, empathy, and connection with oneself and others. 🤝 Module 5: Reconciliation vs. Acceptance Distinguish between reconciliation and acceptance in Module 5. Explore the nuanced differences between these paths to forgiveness, empowering you to make informed choices that align with your values and intentions. 💑 Module 6: Forgiveness in Relationships Deepen your understanding of forgiveness within the context of relationships in Module 6. Explore strategies for fostering forgiveness, rebuilding trust, and nurturing healthy, resilient connections with loved ones. 🏢 Module 7: Forgiveness in the Workplace and Community Extend the principles of forgiveness into the broader context of the workplace and community in Module 7. Discover how forgiveness can foster harmony, collaboration, and conflict resolution in professional and communal settings. 🌊 Module 8: The Challenges of Forgiveness Confront the challenges and obstacles on the path to forgiveness in Module 8. Learn strategies for overcoming resistance, navigating complexity, and embracing forgiveness as a profound catalyst for personal growth and collective healing. 🚀 Why Choose Our Understanding Forgiveness Course? Expert-Led Guidance: Learn from experienced instructors and forgiveness experts dedicated to guiding you on your journey. Holistic Approach: Explore forgiveness from multiple perspectives, incorporating psychological, emotional, and relational dimensions. Practical Applications: Engage in reflective exercises, journaling prompts, and interactive discussions to integrate forgiveness principles into your daily life. Transformative Insights: Gain profound insights and practical tools to navigate forgiveness challenges, fostering inner peace, and healing. 🎓 Who Should Enroll? Individuals Seeking Personal Growth and Healing Therapists, Counselors, and Mental Health Professionals Leaders, Managers, and Community Builders Anyone Interested in Cultivating Compassion and Reconciliation 🌐 Embrace Forgiveness, Embrace Freedom! Join us on a journey of self-discovery, healing, and transformation. Enroll now in the Understanding Forgiveness Course and unlock the transformative power of forgiveness in your life and the world around you. Your journey to healing and harmony begins here! 🌈🌟🕊️ Course Curriculum Module 1 Introduction to Forgiveness. Introduction to Forgiveness. 00:00 Module 2 The Nature of Hurt and Offense. The Nature of Hurt and Offense. 00:00 Module 3 Psychological Processes of Forgiveness. Psychological Processes of Forgiveness. 00:00 Module 4 The Role of Empathy and Compassion. The Role of Empathy and Compassion. 00:00 Module 5 Reconciliation vs. Acceptance. Reconciliation vs. Acceptance. 00:00 Module 6 Forgiveness in Relationships. Module 6 Forgiveness in Relationships. 00:00 Module 7 Forgiveness in the Workplace and Community. Forgiveness in the Workplace and Community. 00:00 Module 8 The Challenges of Forgiveness. The Challenges of Forgiveness. 00:00

Understanding Forgiveness
Delivered Online On Demand8 hours
£25

Extended Diploma in Creative Advertising

By iStudy UK

Course Overview Learn how you can generate more leads and boost sales with creative advertising! These days, if you want to sell a product you have to be creative. Consumers are getting smarter and smarter and they're not easily impressed. Old marketing strategies do not work anymore.  This Extended Diploma in Creative Advertising will help you level up your advertising game. It'll teach you the secrets of creating ads that'll sell your products and how you can become an amazing advertiser.  In the course, you'll learn what advertising is, what you should emphasise on in your ads, what headlines you should use and how you can trigger an emotional response in your customers with your ads that'll compel them to buy your products. You'll also learn how you can advertise the Unique Selling Proposition (USP) of your product and use it to achieve your advertising goals. Remember, advertising is how you attract your customers. So, you better make sure you nail your advertising. Enrol today! What You Will Learn This is one of the top courses on creative advertising you'll find and it'll teach you everything that you need to know about this amazing topic. What is Advertising? What to emphasise on in your ads How to trigger an emotional response in your customers How to create ads that your customers will believe How to advertise The Unique Selling Proposition (USP) of your product What headline you should use How your writing should be The Structure of AIDA and many more Why You Should Choose This Course From iStudy Study at your own pace Full Tutor support on weekdays (Monday - Friday) Fully compatible with any device Free Printable PDF Certificate immediately after completion No prior qualifications are needed to take this course No hidden fees or exam charges CPD Qualification Standards and IAO accredited Efficient exam system, assessment, and instant results Our customer support team is always ready to help you Gain professional skills and better earning potential Certification After completing the course you'll receive a free printable CPD accredited PDF certificate. Hard Copy certificate is also available, and you can get one for just £9! Accreditation This course is accredited by Continuing Professional Development (CPD). It is a recognised independent accreditation service. Enrol today and learn something new with iStudy. You'll find a full breakdown of the course curriculum down below, take a look and see just how much this course offers. We're sure you'll be satisfied with this course. Extended Diploma in Creative Advertising What is Advertising? FREE 01:00:00 Emphasize Benefits, Not Features FREE 00:30:00 Push Their Emotional Hot Buttons 01:00:00 Incorporating Proof and Believability 01:00:00 The Unique Selling Proposition (USP) 01:00:00 The Headline 00:30:00 The More You Tell, The More You Sell 00:30:00 Write To Be Scanned 00:30:00 The Structure of AIDA 00:30:00 Use Takeaway Selling to Increase the Urgency 01:00:00 Conclusion 00:15:00 Mock Exam Mock Exam- Extended Diploma in Creative Advertising 00:20:00 Final Exam Final Exam- Extended Diploma in Creative Advertising 00:20:00

Extended Diploma in Creative Advertising
Delivered Online On Demand8 hours 25 minutes
£25

Accredited Complete Course in Advertising

By iStudy UK

Learn how to Improve your Advertising skills for better sales Do you feel your product is of genuine quality but isn't getting the sales it deserves? That's because you need to improve your advertising skills. But lucky for you, this course will help you achieve just that. Advertising is the action of calling public attention to something, especially by paid announcements. Advertising came into existence because of the needs of trade. But once established it has been found to be of value, among a huge variety of roles, in the recruitment of staff, in fundraising for charities and in the dissemination of government information. Its value in the building of brands has been well-documented. More recently, it's become increasingly clear how advertising does not just help build brands but helps sustain them. Now that you have an idea on how important advertisement is, in order to build up a reputation of a product or a brand, don't waste any time and get started with this Accredited Complete Course in Advertising. Course Highlights Accredited Complete Course in Advertising is an award winning and the best selling course that has been given the CPD Certification & IAO accreditation. It is the most suitable course anyone looking to work in this or relevant sector. It is considered one of the perfect courses in the UK that can help students/learners to get familiar with the topic and gain necessary skills to perform well in this field. We have packed Accredited Complete Course in Advertising into several modules for teaching you everything you need to become successful in this profession. To provide you ease of access, this course is designed for both part-time and full-time students. You can become accredited in just 20/30 hours and it is also possible to study at your own pace. We have experienced tutors who will help you throughout the comprehensive syllabus of this course and answer all your queries through email. For further clarification, you will be able to recognize your qualification by checking the validity from our dedicated website. Why You Should Choose Accredited Complete Course in Advertising Lifetime access to the course No hidden fees or exam charges CPD Accredited certification on successful completion Full Tutor support on weekdays (Monday - Friday) Efficient exam system, assessment and instant results Download Printable PDF certificate immediately after completion Obtain the original print copy of your certificate, dispatch the next working day for as little as £9. Improve your chance of gaining professional skills and better earning potential. Who is this Course for? Accredited Complete Course in Advertising is CPD certified and IAO accredited. 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 backgrounds. Requirements Our Accredited Complete Course in Advertising 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 You will be ready to enter the relevant job market after completing this course. You will be able to gain necessary knowledge and skills required to succeed in this sector. All our Diplomas' are CPD and IAO accredited so you will be able to stand out in the crowd by adding our qualifications to your CV and Resume. Creating Advertisement What is Advertising? FREE 01:00:00 Emphasize Benefits, Not Features FREE 00:30:00 Push Their Emotional Hot Buttons 01:00:00 Incorporating Proof and Believability 01:00:00 The Unique Selling Proposition (USP) 01:00:00 The Headline 00:30:00 The More You Tell, The More You Sell 00:30:00 Write To Be Scanned 00:30:00 The Structure of AIDA 00:30:00 Use Takeaway Selling to Increase the Urgency 01:00:00 Conclusion 00:15:00 Internet Advertising INTRODUCTION: WHAT IS AFFILIATE MARKETING? 01:00:00 WHY AFFILIATE MARKETING IS AWESOME 00:30:00 FINDING A PROFITABLE NICHE 00:30:00 CHOOSING AN AFFILIATE PRODUCT 00:30:00 THE ADVANTAGES OF CLICK BANK 00:30:00 ANALYZING THE CLICK BANK MARKETPLACE 00:30:00 CREATING YOUR HOP LINK 00:30:00 CREATING A FREE BLOG 00:30:00 PERFORMING EFFECTIVE KEYWORD RESEARCH 00:30:00 CREATING AN OPTIMIZED POST 01:00:00 POSTING TO YOUR BLOG 00:30:00 PROMOTING YOUR BLOG: AN OVERVIEW 00:30:00 PROMOTION: ARTICLE MARKETING 00:30:00 PROMOTION: SOCIAL BOOKMARKING 00:30:00 PROMOTION: BLOG COMMENTING 00:30:00 ADDITIONAL PROMOTION TIPS 00:30:00 CREATING YOUR OWN WEBSITE 00:30:00 Smartphone Advertising INTRODUCTION 00:15:00 HOW NEXT GENERATION PHONES ARE GREAT ADVERTISING TOOLS 00:30:00 THE NEW GENERATION OF WIRELESS DEVICES 02:00:00 BUSINESS SECTOR USERS AND THEIR WIRELESS DEVICES 01:00:00 THE BEST PROCESS OF APPLICATION TO YOUR ADVERTISING ADVANTAGE 02:00:00 CREATING YOUR OWN APPLICATIONS 01:00:00 CONCLUSION 00:30:00 Mobile Marketing Introduction FREE 00:30:00 Dominate Local Market with Mobile Marketing FREE 00:30:00 Mobile Marketing Is Going Web 02:00:00 Effective Mobile Advertising 00:30:00 List Building with Mobile Marketing  02:00:00 The Surefire Success Mobile Marketing Campaign 00:30:00 Mock Exam Mock Exam- Accredited Complete Course in Advertising 00:30:00 Final Exam Final Exam- Accredited Complete Course in Advertising 00:30:00

Accredited Complete Course in Advertising
Delivered Online On Demand31 hours
£25

Play Therapy Diploma Level 3

5.0(1)

By Course Gate

Gain insights into the principles, techniques, and applications of play therapy, and discover how it can address emotional and psychological issues in children. Ideal for aspiring play therapists, child psychologists, and mental health professionals, this course offers valuable skills and knowledge to make a positive impact in children's lives.

Play Therapy Diploma Level 3
Delivered Online On Demand4 hours 12 minutes
£11.99

Entrepreneurship

4.5(3)

By Studyhub UK

The 'Entrepreneurship' course is designed to equip aspiring entrepreneurs with essential abilities, skills, and tools required to succeed in the business world. It covers various aspects of entrepreneurship, including identifying unique abilities, setting goals, conducting SWOT analysis, and exploring opportunities and threats. Learning Outcomes: Develop a comprehensive understanding of the key abilities and skills required to be a successful entrepreneur. Identify and analyze personal strengths, weaknesses, opportunities, and threats through SWOT analysis. Discover and nurture unique abilities and passion to create a strong foundation for entrepreneurial endeavors. Set clear goals and create a vision for personal and business growth. Utilize SWOT analysis to identify potential opportunities and challenges in the business environment. Acquire the necessary techniques and strategies to leverage strengths and overcome weaknesses. Gain insights into the importance and benefits of SWOT analysis in making informed business decisions. Build a robust entrepreneurial mindset, incorporating purpose, passion, and a vision for the future. What skills you will gain: Expertise in the traits and skills of an entrepreneur. Be skilled in creative thinking and collaborating. Proficiency in developing a business or product idea. Thorough understanding of financial statements. A clear idea of building a marketing and sales strategy. Aligning your entrepreneurial purpose with your passion. Familiarity with your unique ability as an entrepreneurial leader. Comprehensive knowledge of business ethics and etiquette. Step-by-step guidance on SWOT analysis. Why buy this Entrepreneurship? Unlimited access to the course for a lifetime. Opportunity to earn a certificate accredited by the CPD Quality Standards and CIQ after completing this course. Structured lesson planning in line with industry standards. Immerse yourself in innovative and captivating course materials and activities. Assessments designed to evaluate advanced cognitive abilities and skill proficiency. Flexibility to complete the Course at your own pace, on your own schedule. Receive full tutor support throughout the week, from Monday to Friday, to enhance your learning experience. Unlock career resources for CV improvement, interview readiness, and job success. Certification After studying the course materials of the Entrepreneurship there will be a written assignment test which you can take either during or at the end of the course. After successfully passing the test you will be able to claim the pdf certificate for £5.99. Original Hard Copy certificates need to be ordered at an additional cost of £9.60. Who is this course for? Aspiring entrepreneurs eager to launch their own business ventures. Business students seeking a comprehensive understanding of entrepreneurship. Professionals aiming to innovate within existing companies or industries. Individuals interested in understanding the dynamics of startup ecosystems. Social innovators focused on creating ventures with societal impact. Prerequisites This Entrepreneurship does not require you to have any prior qualifications or experience. You can just enrol and start learning.This Entrepreneurship was made by professionals and it is compatible with all PC's, Mac's, tablets and smartphones. You will be able to access the course from anywhere at any time as long as you have a good enough internet connection. Career path Startup Founder: £50,000 - £100,000 Per Annum Business Development Manager: £35,000 - £70,000 Per Annum Innovation Consultant: £40,000 - £80,000 Per Annum Venture Capital Analyst: £45,000 - £90,000 Per Annum Product Manager: £45,000 - £85,000 Per Annum Social Enterprise Director: £40,000 - £75,000 Per Annum Course Curriculum Section 1 Entrepreneur 1-3 abilities 00:07:00 Entrepreneur 4-6 abilities 00:08:00 Entrepreneur 7-8 abilities 00:05:00 Entrepreneur 9-10 abilities 00:04:00 Entrepreneurial skills assessment activity 00:05:00 Entrepreneur purpose passion 00:07:00 Entrepreneur uniq ability vision goals 00:06:00 Section 2 Entrepreneur unique ability introduction 00:05:00 Reference document on unique ability importance 00:05:00 Entrepreneur unique ability part 1 00:06:00 Questions to ask to find unique ability 00:05:00 Entrepreneur unique ability parts 2 3 4 00:08:00 List down activities unique ability part 2 00:05:00 Activity document unique ability part 3 & 4 00:10:00 Section 3 SWOT analysis benefits 00:03:00 SWOT analysis importance 00:04:00 Video SWOT strengths and weaknesses 00:08:00 Activity personal SWOT - Strengths 00:00:00 Activity personal SWOT - Weaknesses 00:05:00 SWOT opportunities and threats 00:08:00 Activity personal SWOT - opportunities threats 00:05:00 SWOT 2 techniques 00:05:00 SWOT my example 00:08:00 Assignment Assignment - Entrepreneurship 00:00:00

Entrepreneurship
Delivered Online On Demand2 hours 12 minutes
£10.99

Behavioural Finance

5.0(1)

By LearnDrive UK

Delve into the fascinating world of Behavioral Finance with this comprehensive course. Learn how cognitive biases and emotional factors influence financial decisions. Designed to equip you with actionable insights, this course is your roadmap to understanding and navigating the complex interplay of psychology and finance.

Behavioural Finance
Delivered Online On Demand1 hour
£5

Child Playwork

By St. Paul's College

Play is more than just a pastime for children; it's a crucial element in their development. The Child Playwork course delves into the scientific principles and theories that underpin playwork, exploring its profound impact on children's physical, emotional, and cognitive growth.

Child Playwork
Delivered Online On Demand2 hours
£11.99

Oracle 19c PL/SQL Fundamentals (TTOR12019)

By Nexus Human

Duration 3 Days 18 CPD hours This course is intended for This course is geared for anyone needing to interface with an Oracle database such as end users, business analysts, application developers and database administrators / DBAs. Overview Working within in a hands-on learning environment, guided by our expert team, attendees will develop a practical approach to Oracle Database Technology. Throughout the course participants will explore: Using PL/SQL programming language for database applications and development incorporating PL/SQL modules within the application architecture from the initial design and planning phase The essentials of building executable PL/SQL program units Each of the major segments of a working program and how these interact with each other during program execution Important error or exception handling capabilities of the language. How database-resident program units can be used as part of the overall database application architecture Applying these new skills to the development of PL/SQL packages. Advanced database programming capabilities and benefits How database triggers can be used as part of an advanced database application design Oracle 19c PL/SQL Fundamentals is a three-day, hands-on course that introduces Oracle database programming using the PL/SQL programming language. Throughout the course students will explore the core syntax, structure and features of the language. This course will also lay the foundation for the entire Oracle PL/SQL programming series, allowing one to progress from introductory topics to advanced application design and programming and finally onto writing complex high-performance applications. The course also explores applying the newly learned skills to the development of database applications. Participants will learn how to use database-resident stored program units such as procedures, functions, packages and database triggers. Students will also learn about the latest features in Oracle 19c. 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 and Substitution Variables Using SQL Developer Using SQL *Plus Choosing a Database Programming Language What is Database Programming PL/SQL Programming PL/SQL Performance Advantages Integration with Other Languages PL/SQL Language Essentials PL/SQL Program Structure Language Syntax Rules Embedding SQL Writing Readable Code Generating Readable Code Generating Database Output SQL * Plus Input of 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 & Braching 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 Extend Cursor Techniques For Update of Clause Where Current of Clause Using for ? Loop Cursors Introduction Database Resident Programming Units About Database ? Resident Programs Physical Storage & Execution Types of Stored Program Units Stored Program Unit Advantages Modular Design Principles Creating Stored Procedures and 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 and 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 Programming Units Recompiling Programs Mass Recompilation Using UTL_RECOMP() Dropping Procedures & Functions Drop 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 About Packages Creating Packages Maintaining Packages Performance Considerations Advanced Package Capabilities Definer & Invoker Rights White Lists & Accessible By Persistent Global Objects Defining Initilization Logic Object Orientation Support Advanced Cursor Techniques Using Cursor Variables Using SYS_REFCURSOR Using Cursor Expressions Using System Supplied Packages DBMS_OUTPUT() UTL_FILE() FOPEN() Example Database Trigger Concepts About Database Triggers DML Event Trigger Sub-Types Database Trigger Scenario Trigger Exhaustion Mechanisms Trigger 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 and 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 Defining the Scope Available System Events System Event Attributes

Oracle 19c PL/SQL Fundamentals (TTOR12019)
Delivered OnlineFlexible Dates
Price on Enquiry

UK's Best Free Plagiarism Checker: Safeguard Your Academic Integrity

By Adam Thomas

Plagiarism checkers are essential tools that help ensure originality in your work by detecting unoriginal content. It covers how these tools work, their key features, and the differences between free and paid versions.

UK's Best Free Plagiarism Checker: Safeguard Your Academic Integrity
Delivered Online On Demand12 hours
FREE

Educators matching "incorporating props"

Show all 23