20485 Other courses

CRM: Customer Relationship Management Online Are you excited to start a job as front desh executive or the job which have direct interaction with customers? Then our comprehensive CRM Course (Customer Relationship Management) is perfect for you. This CRM Course (Customer Relationship Management) delves into customer-centric strategies and emphasizing the use of CRM tools for enhanced customer interactions. The CRM Course (Customer Relationship Management) participants gain insights into customer data analysis, segmentation and effective communication techniques. The CRM Course (Customer Relationship Management) fosters skills in CRM system implementation and aligning sales. Moreover, the CRM Course (Customer Relationship Management) involves marketing and service functions. The CRM Course (Customer Relationship Management) helps in optimizing overall business performance through strengthened customer relationships. As the CRM Course (Customer Relationship Management) is a great method to progress your profession the what are you waiting? Sign up for this CRM Course (Customer Relationship Management) immediately! Main Course: CRM: Customer Relationship Management Courses you will get along with this CRM: Customer Relationship Management Course: CRM Course Offers free Close Protection Course CRM Course Offers free Security Management Course Others benefit Included with CRM: Customer Relationship Management Course. Free 03 PDF Certificate Access to Content - Lifetime Exam Fee - Totally Free Free Retake Exam [ Note: Free PDF certificate as soon as completing the CRM: Customer Relationship Management Course] CRM: Customer Relationship Management Online Course Curriculum of CRM: Customer Relationship Management Module 01: Introduction to Customer Relationship Management (CRM) Module 02: CRM Fundamentals Module 03: CRM Strategies Module 04: Data Analysis in CRM Module 05: CRM Databases Module 06: Deepening Customer Relationship Module 07: Handling Customer Complaints Module 08: Future of CRM Assessment Method of CRM: Customer Relationship Management After completing CRM: Customer Relationship Management Course, you will get quizzes to assess your learning. You will do the later modules upon getting 60% marks on the quiz test. Apart from this, you do not need to sit for any other assessments. Certification of CRM: Customer Relationship Management After completing the CRM: Customer Relationship Management Course, you can instantly download your certificate for FREE. The hard copy of the certification will also be delivered to your doorstep via post, which will cost £13.99. Who is this course for? CRM: Customer Relationship Management Anyone can take this CRM Course (Customer Relationship Management). Requirements CRM: Customer Relationship Management To enroll in this CRM: Customer Relationship Management Course, students must fulfil the following requirements: Good Command over English language is mandatory to enrol in our CRM: Customer Relationship Management Course. Be energetic and self-motivated to complete our CRM: Customer Relationship Management Course. Basic computer Skill is required to complete our CRM: Customer Relationship Management Course. If you want to enrol in our CRM: Customer Relationship Management Course, you must be at least 15 years old. Career path CRM: Customer Relationship Management After completing this CRM Course (Customer Relationship Management), you can work as a manager, customer service manager, CRM analyst, and many other positions!

Practice Nurse: Practice Nurse Online Unlock the Power of Practice Nurse: Practice Nurse: Enrol Now! Nursing practice is a rapidly growing field in the healthcare industry, with nurses working in a variety of settings as members of multidisciplinary health care teams. The responsibilities of a practice nurse: practice nurse range from administration to medical treatment. This Practice Nurse: Practice Nurse Course will guide you through the healthcare framework and provide you with the knowledge you need to succeed. This exclusive Practice Nurse: Practice Nurse Course will provide you with a thorough overview of practice nursing. Through this Practice Nurse: Practice Nurse course, you will understand the roles and responsibilities of a practicing nurse. The Practice Nurse: Practice Nurse Course will teach you how to collect medical information, provide first aid, and perform other nursing duties. You will also understand the importance and role of nursing in a variety of social settings. Main Course: Practice Nurse Free Courses included with Practice Nurse: Practice Nurse Course: Along with Practice Nurse you will get free Nursing Assistant Along with Practice Nurse you will get free Adult Nursing Along with Practice Nurse you will get free Forensic Nursing Special Offers of this Practice Nurse: Practice Nurse Course; This Practice Nurse: Practice Nurse Course includes a FREE PDF Certificate. Lifetime access to this Practice Nurse: Practice Nurse Course Instant access to this Practice Nurse: Practice Nurse Course 24/7 Support Available to this Practice Nurse: Practice Nurse Course Practice Nurse: Practice Nurse Online The Practice Nurse: Practice Nurse Course is an exclusive course that provides a comprehensive understanding of the practice of nursing. This Practice Nurse: Practice Nurse course is designed to teach you about the various roles and responsibilities of a practicing nurse. You will learn how to gather medical information, administer first aid, and carry out other nursing duties. Additionally, the Practice Nurse: Practice Nurse Course will help you understand the significance of nursing and its role in various social contexts. Who is this course for? Practice Nurse: Practice Nurse Online This Practice Nurse: Practice Nurse course is suitable for those interested in nursing or those already working in the relevant fields and want to polish their knowledge and skill. Requirements Practice Nurse: Practice Nurse Online To enrol in this Practice Nurse: Practice Nurse Course, students must fulfil the following requirements: Good Command over English language is mandatory to enrol in our Practice Nurse: Practice Nurse Course. Be energetic and self-motivated to complete our Practice Nurse: Practice Nurse Course. Basic computer Skill is required to complete our Practice Nurse: Practice Nurse Course. If you want to enrol in our Practice Nurse: Practice Nurse Course, you must be at least 15 years old. Career path Practice Nurse: Practice Nurse Online The knowledge you will gain through this Practice Nurse: Practice Nurse course may lead you to a variety of career opportunities. Such as: - Nursing Assistant, Nursing Administrator, Nursing Home Manager, Nurse Midwife, Practice Nurse: Practice Nurse.

Commercial Law Course Online Are you want to expand your understanding of business law? If the response is affirmative, then you are on the right page. Your ability to operate more productively and efficiently will be enhanced by taking our commercial law course. In this commercial law course, a foundation in commercial law will be provided. Contracts and other relevant topics are covered in this commercial law course as well. You may get a deeper understanding of the concepts in corporate law, international trade law, and intellectual property law with this commercial law course. The legal ramifications of e-commerce will also be covered in this commercial law course. You might lower the legal risk associated with business transactions by enrolling in this commercial law course. Enroll in The Commercial Law: Commercial Law Course if you want to be successful and get the knowledge required to comprehend commercial law. Main Course: Commercial Law Course Free Courses Course 01: Level 4 Diploma in Paralegal Studies Course 02: Business Law Course [ Note: Free PDF certificate as soon as completing the Commercial Law: Commercial Law Course course] Commercial Law Course Online This Commercial Law: Commercial Law Course consists of 07 modules. Course Curriculum of Commercial Law Module 1: Introduction to Commercial Law Module 2: The Law of Contracts Module 3: Company Law Module 4: Intellectual Property Law Module 5: International Trade Law Module 6: Legal Aspects of E-commerce Module 7: Legal Risk Management in Commercial Transactions Assessment Method of Commercial Law Course After completing Commercial Law: Commercial Law Course, you will get quizzes to assess your learning. You will do the later modules upon getting 60% marks on the quiz test. Apart from this, you do not need to sit for any other assessments. Certification of Commercial Law Course After completing the Commercial Law: Commercial Law course, you can instantly download your certificate for FREE. The hard copy of the certification will also be delivered to your doorstep via post, which will cost £13.99. Who is this course for? Commercial Law Course Online The Commercial Law: Commercial Law course might be advantageous for aspiring professionals who want to study the knowledge and put their abilities to use in order to pursue a career in commercial law. Requirements Commercial Law Course Online To enroll in this Commercial Law: Commercial Law Course, students must fulfil the following requirements: Good Command over English language is mandatory to enroll in our Commercial Law Course. Be energetic and self-motivated to complete our Commercial Law Course. Basic computer Skill is required to complete our Commercial Law Course. If you want to enroll in our Commercial Law: Commercial Law Course, you must be at least 15 years old. Career path Commercial Law Course Online Taking the Commercial Law: Commercial Law course will help you find work as a corporate lawyer, legal advisor, compliance officer, or contract specialist.

Commercial Law: Commercial Law Course Online Are you want to expand your understanding of business law? If the response is affirmative, then you are on the right page. Your ability to operate more productively and efficiently will be enhanced by taking our commercial law course. In this commercial law course, a foundation in commercial law will be provided. Contracts and other relevant topics are covered in this commercial law course as well. You may get a deeper understanding of the concepts in corporate law, international trade law, and intellectual property law with this commercial law course. The legal ramifications of e-commerce will also be covered in this commercial law course. You might lower the legal risk associated with business transactions by enrolling in this commercial law course. Enroll in The Commercial Law: Commercial Law Course if you want to be successful and get the knowledge required to comprehend commercial law. Main Course: Commercial Law Course Free Courses included with Commercial Law: Commercial Law Course: Along with Commercial Law Course you will get free Level 4 Diploma in Paralegal Studies Along with Commercial Law Course you will get free Business Law Course Special Offers of this Commercial Law: Commercial Law Course: This Commercial Law: Commercial Law Course includes a FREE PDF Certificate. Lifetime access to this Commercial Law: Commercial Law Course Instant access to this Commercial Law: Commercial Law Course 24/7 Support Available to this Commercial Law: Commercial Law Course Commercial Law: Commercial Law Course Online This Commercial Law: Commercial Law Course will provide a basic overview of commercial law. Also, including information on its contracts and other relevant topics, in this commercial law course. You can also broaden your understanding of the concepts in corporate law, international trade law, and intellectual property law through this commercial law Commercial Law: Commercial Law Course. Aspects of e-commerce's legality will also be covered in this Commercial Law: Commercial Law Course. You can control the legal risk in business transactions by taking this commercial law course. Who is this course for? Commercial Law: Commercial Law Course Online The Commercial Law: Commercial Law course might be advantageous for aspiring professionals who want to study the knowledge and put their abilities to use in order to pursue a career in commercial law. Requirements Commercial Law: Commercial Law Course Online To enroll in this Commercial Law: Commercial Law Course, students must fulfil the following requirements: Good Command over English language is mandatory to enroll in our Commercial Law Course. Be energetic and self-motivated to complete our Commercial Law Course. Basic computer Skill is required to complete our Commercial Law Course. If you want to enroll in our Commercial Law: Commercial Law Course, you must be at least 15 years old. Career path Commercial Law: Commercial Law Course Online Taking the Commercial Law: Commercial Law course will help you find work as a corporate lawyer, legal advisor, compliance officer, or contract specialist.

Airport Management: Airport Management Course Online Airport Management: Airport Management Course are critical components of any airport, as they are responsible for the upkeep of terminals, runways, and other buildings, as well as ensuring that everything within the airport is in good working order. The role of an airport manager is extensive, and airport managers are in high demand. This Airport Management: Airport Management Course will teach you everything you need to know to become a successful airport manager. You will learn about the most recent international and national aviation laws and regulations as part of this Airport Management: Airport Management Course. The Airport Management: Airport Management Course will teach you how to meet the unique and dynamic requirements of today's global airport management: airport management environment. This Airport Management: Airport Management Course covers a variety of topics such as airline management, planning and development, route planning, marketing, and safety management. You can add this Airport Management: Airport Management Course in your resume this will increase your weight. Main Course: Airport Management Course Free courses included with Airport Management: Airport Management Course Course 01: Level 5 Personal Development Course 02: Anger Management Course 03: Negotiation Skills Course 04: Communication Skills Course 05: Networking Skills Course 06: Dealing with Difficult People Course 07: Level 2 Award in Babysitting Course 08: Level 5 Photography Course 09: Asbestos Awareness [ Note: Free PDF certificate as soon as completing the Airport Management: Airport Management Course] Airport Management: Airport Management Course Online This Airport Management: Airport Management Course consists of 20 modules. Assessment Method of Airport Management: Airport Management Course After completing Airport Management: Airport Management Course, you will get quizzes to assess your learning. You will do the later modules upon getting 60% marks on the quiz test. Apart from this, you do not need to sit for any other assessments. Certification of Airport Management: Airport Management Course After completing the Airport Management: Airport Management Course, you can instantly download your certificate for FREE. The hard copy of the certification will also be delivered to your doorstep via post, which will cost £13.99. Who is this course for? Airport Management: Airport Management Course Online This Airport Management: Airport Management Course is appropriate for those newbies who are passionate about building their career in airport management: airport management. Requirements Airport Management: Airport Management Course Online To enrol in this Airport Management: Airport Management Course, students must fulfil the following requirements: Good Command over English language is mandatory to enrol in our Airport Management: Airport Management Course. Be energetic and self-motivated to complete our Airport Management: Airport Management Course. Basic computer Skill is required to complete our Airport Management: Airport Management Course. If you want to enrol in our Airport Management: Airport Management Course, you must be at least 15 years old. Career path Airport Management: Airport Management Course Online After completing this Airport Management: Airport Management Course, you may be able to pursue a career.

Join our Workplace Health and Safety Advanced Diploma course and discover your hidden skills, setting you on a path to success in this area. Get ready to improve your skills and achieve your biggest goals. The Workplace Health and Safety Advanced Diploma course has everything you need to get a great start in this sector. Improving and moving forward is key to getting ahead personally. The Workplace Health and Safety Advanced Diploma course is designed to teach you the important stuff quickly and well, helping you to get off to a great start in the field. So, what are you looking for? Enrol now! You will Learn The Following Things: Learn strategies to boost your workplace efficiency. Hone your skills to help you advance your career. Acquire a comprehensive understanding of various topics and tips. Learn in-demand skills that are in high demand among UK employers This course covers the topic you must know to stand against the tough competition. The future is truly yours to seize with this Workplace Health and Safety Advanced Diploma. Enrol today and complete the course to achieve a certificate that can change your career forever. Details Perks of Learning with IOMH One-to-one support from a dedicated tutor throughout your course. Study online - whenever and wherever you want. Instant Digital/ PDF certificate 100% money back guarantee 12 months access Process of Evaluation After studying the course, an MCQ exam or assignment will test your skills and knowledge. You have to get a score of 60% to pass the test and get your certificate. Certificate of Achievement After completing the Workplace Health and Safety Advanced Diploma course, you will receive your CPD-accredited Digital/PDF Certificate for £5.99. To get the hardcopy certificate for £12.99, you must also pay the shipping charge of just £3.99 (UK) and £10.99 (International). Who Is This Course for? This Workplace Health and Safety Advanced Diploma is suitable for anyone aspiring to start a career in relevant field; even if you are new to this and have no prior knowledge, this course is going to be very easy for you to understand.  On the other hand, if you are already working in this sector, this course will be a great source of knowledge for you to improve your existing skills and take them to the next level.  This course has been developed with maximum flexibility and accessibility, making it ideal for people who don't have the time to devote to traditional education. Requirements There is no prerequisite to enrol in this course. You don't need any educational qualification or experience to enrol in the Workplace Health and Safety Advanced Diploma course. Do note: you must be at least 16 years old to enrol. Any internet-connected device, such as a computer, tablet, or smartphone, can access this online course. Career Path The certification and skills you get from this Workplace Health and Safety Advanced Diploma Course can help you advance your career and gain expertise in several fields, allowing you to apply for high-paying jobs in related sectors. Course Curriculum Health and Safety at Workplace Introduction 00:15:00 Health and Safety Related Accidents and ill-health 00:30:00 Legal Responsibilities and Requirements 00:30:00 Managing health and safety in Workplace 01:00:00 Health and Safety in The workplace 01:00:00 Workplace Hazards, Slips and Trips 01:00:00 General fire safety 00:30:00 Work at height 01:00:00 Building work 01:00:00 Machinery safety 01:00:00 Plant and equipment maintenance 01:00:00 Workplace transport 01:00:00 Lifting and handling 01:00:00 Noise, Vibration 01:00:00 Electricity 01:00:00 Harmful substances 01:00:00 Flammable and explosive substances 01:00:00 Managing health, Stress and Emergency Procedures 01:00:00 Role of Employer or Managers and PPE 01:00:00 Importance of Workplace Safety Why Workplace Health & Safety are Important? 01:00:00 It Takes Team Effort! 01:00:00 Some Rules are Compulsory 00:30:00 Rewarding Compliance 00:30:00 You Need a Backup Plan Always 01:00:00 Dealing with Issues and Concerns 00:30:00 How to Deal with Noncompliance? 00:15:00 Remember What the Workplace is for 01:00:00 Make Your Workplace a Good Place 00:30:00 Conflict Resolution 00:30:00 Are Dress Codes Appropriate? 00:30:00 Minimising Distractions 01:00:00 People Who Work After Hours 01:00:00 Your Fire Safety Plan 01:00:00 Being Organised 00:30:00 Plan for Emergencies 00:30:00 Promoting a Safe Environment 00:30:00 Do You Need Security Guards? 00:15:00 Special Situations: The Handicapped 00:15:00 Health and Safety at Workplace (for USA) Module One - Getting Started 00:30:00 Module Two - An Overview 00:30:00 Module Three - Types of Hazards 00:30:00 Module Four - Managers Role 00:30:00 Module Five - Training 01:00:00 Module Six - Stress Management 01:00:00 Module Seven - Workplace Violence 00:30:00 Module Eight - Identifying Your Company Hazards 00:30:00 Module Nine - Drug & Alcohol Abuse 01:00:00 Module Ten - Writing the Safety Plan 00:30:00 Module Eleven - Implement the Plan 01:00:00 Module Twelve - Wrapping Up 00:30:00 Recommended Reading Recommended Reading: Advanced Diploma in Health and Safety 00:00:00 Mock Exam Mock Exam- Workplace Health and Safety Advanced Diploma 00:30:00 Final Exam Final Exam- Advanced Diploma in Health and Safety 00:30:00 Refer a Friend Refer a Friend and Claim One Course for FREE 00:00:00

Duration 0.25 Days 1.5 CPD hours This course is intended for This course is intended for individuals who want to learn how to stay safe online. Overview Upon successful completion of this course, students will be able to understand how to avoid social engineering and stay safe online. In this course, students will learn how to use the internet safely, and learn traps to avoid. The need for security Compliance Recognize social engineering and other attacks Secure Devices Passwords Identify viruses and malware Use the Internet safely Browsing the web Email Social media Cloud services Additional course details: Nexus Humans CyberSAFE: Staying Safe in a Digital World training program is a workshop that presents an invigorating mix of sessions, lessons, and masterclasses meticulously crafted to propel your learning expedition forward. This immersive bootcamp-style experience boasts interactive lectures, hands-on labs, and collaborative hackathons, all strategically designed to fortify fundamental concepts. Guided by seasoned coaches, each session offers priceless insights and practical skills crucial for honing your expertise. Whether you're stepping into the realm of professional skills or a seasoned professional, this comprehensive course ensures you're equipped with the knowledge and prowess necessary for success. While we feel this is the best course for the CyberSAFE: Staying Safe in a Digital World course and one of our Top 10 we encourage you to read the course outline to make sure it is the right content for you. Additionally, private sessions, closed classes or dedicated events are available both live online and at our training centres in Dublin and London, as well as at your offices anywhere in the UK, Ireland or across EMEA.

Duration 5 Days 30 CPD hours This course is intended for This is an intermediate course for system administrators, database administrators, and other technical individuals, who manage and implement DB2 10 for z/OS. Administrators of DB2 11 for z/OS can acquire a view of the architecture and fundamental processes required to manage a DB2 11 for z/OS subsystem. Course Outline Start and stop the DB2 subsystem Explain the allocation CLIST used at logon for DB2 data sets Use Set SYSPARM command Locate the Command recognition character for the DB2 subsystem Query the system log to gain knowledge about the IPL process and information in the system log when DB2 is initialized or stopped Explore DB2 Address Spaces information Select the DB2 functions that best satisfy your site requirements Explain the use of RACF for DB2 connection security Explain the use of Roles and Trusted Context Implement security procedures for a DB2 environment Describe the components and address space structure of a DB2 subsystem Explain DB2 Program Flow for all environments Invoke and use DB2 TSO Facilities Use the DB2 Catalog to monitor authorizations Increase the size of the Active Log data sets Explain DB2 Logging Use SET LOG SUSPEND and SET LOG RESUME Use DSNJU004 to Print Log Map Interpret the output of the Print Log Map Utility DSNJU004 Use DSNJU003 to rename DB2 data sets Plan for recovery of a BSDS failure Monitor and control DB2 Explain transaction flow in IMS and CICS Describe the CICS and DB2 environment Make use and implement the extended 10-byte RBA and LRSN

Duration 4 Days 24 CPD hours This course is intended for This is an intermediate course for experienced DBAs and technical individuals, with experience on other relational database platforms, who plan, implement, and maintain Db2 11.1 for Linux, UNIX, and Windows databases. These skills can also be utilize to support cloud based databases using Db2 on Cloud or Db2 Hosted environments. Overview Please refer to course overview This course teaches you to perform, basic and advanced, database administrative tasks using Db2 11.1. These tasks include creating and populating databases and implementing a logical design to support recovery requirements. The access strategies selected by the Db2 Optimizer will be examined using the Db2 Explain tools. Various diagnostic methods will be presented, including using various db2pd command options. Students will learn how to implement automatic archival for database logs and how to plan a redirected database restore to relocate either selected table spaces or an entire database. The REBUILD option of RESTORE, which can build a database copy with a subset of the tablespaces, will be discussed. We will also cover using the TRANSPORT option of RESTORE to copy schemas of objects between two Db2 databases. The selection of indexes to improve application performance and the use of SQL statements to track database performance and health will be covered. This course provides a quick start to Db2 database administration skills for experienced relational Database Administrators (DBA). Overview of Db2 11Command Line Processor (CLP) and GUI UsageThe Db2 EnvironmentCreating Databases and Data PlacementCreating Database ObjectsMoving DataBackup and RecoveryLocks and ConcurrencyDatabase Maintenance, Monitoring and Problem DeterminationSecurityDatabase Rebuild SupportDb2 Database and Table Space RelocationUsing Explain ToolsUsing Indexes for PerformanceAdvanced Monitoring

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