17038 Other courses in Alloa delivered Online

Our course empowers you to handle workplace issues effectively and fairly. Learn best practices, procedures, and communication skills to maintain a harmonious and compliant workplace. Course overview Duration: 1 day (6.5 hours) This course will enable participants to manage disciplinary and grievance issues effectively. The emphasis is on the use of a structured approach where positive action and problem-solving is highlighted as a priority. The course will build knowledge, skill and confidence in handling these areas objectively, fairly and appropriately in line with policies/procedures, best practice and legal requirements. Objectives  By the end of the course you will be able to: Describe the purpose of disciplinary and grievance procedures and how these relate to relevant laws and other procedures Know your role as managers in fairly and consistently applying the procedures at the informal and formal stages Explain the grounds for disciplinary or grievance action and the need to collect, assess and present evidence Describe the structure and roles of disciplinary meetings Explain of the basis for reaching fair and reasonable decisions and possible remedies and penalties Describe the grounds and procedure for appeals Content Disciplinary Procedures Employment Contract – what an employee and employer expect and how to manage when broken. Natural Justice – ensuring ‘fair play’. Misconduct v Capability - what is the difference and which process should be used to manage both. Informal v Formal Action – understanding the processes for both informal and formal disciplinary actions. Suspensions – when, why and how to suspend an employee. Investigations – how to undertake a robust investigation and what to include in the report. Disciplinary Meeting – how to conduct the meeting, the different roles involved. Appeals – understanding how people can appeal and the process to appeal. Grievance Procedures What the law requires – what are the legal requirements for handling a grievance. Informal v Formal Action – understanding the processes for both informal and formal grievance procedures. Conducting the hearing – how to undertake a robust hearing and who should be involved. Appeals - how can people appeal and what is the process.

Leading with Emotional Intelligence

Office Skills & Administration (Office Management) Training for Receptionist & Executive PA Enhance your communication, time management, and problem solving skills with our Office Skills & Administration (Office Management) Training for Receptionist & PA Certificate course! Are you willing to lead the managerial function in an organisation? Our Office Skills & Administration (Office Management) Training for Receptionist & PA Certificate course is a comprehensive program for you to enhance your knowledge and skills in this field. The Office Skills & Administration (Office Management) Training for Receptionist & PA Certificate course is divided into 13 modules, each of which focuses on a distinct management topic. The Foundations of Office Administration and the Basics of Microsoft Office Skills are covered in order in the Office Skills & Administration (Office Management) Training for Receptionist & PA Certificate course. You will learn about mail services, shipment information, and quality maintenance from our Office Skills & Administration (Office Management) Training for Receptionist & PA Certificate course. This Office Skills & Administration (Office Management) Training for Receptionist & PA Certificate course module will show you how to manage risks and challenges that you may encounter in your professional life. You will also learn business strategy, etiquette rule-making, and marketing technology in this Office Skills & Administration (Office Management) Training for Receptionist & PA Certificate course. You could look into a variety of job options after completing the Office Skills & Administration (Office Management) Training for Receptionist & PA Certificate course. Don't pass up this chance to make an investment in your future. Enroll in the Office Management and Administration course right away to begin your successful learning journey. Learning Outcomes Know about the fundamentals of Office Administration. Recognize the opportunities in Office Administration. Learn about the requirements, duties and responsibilities of Office Administration. Get knowledge about how to develop effective skills for office management and administration and how to become a great office administrator. Get an overview of shipping and mail services in the UK. Learn about royal mail services and the alternatives to royal mail. Understand the ways to create effective plans and schedules and Work Breakdown Structure (WBS)in project management. Get the ultimate guide to project planning. Recognize the importance and processes of risk management. Acknowledge effective techniques and skills to develop business writing skills. Know about business document structure, meaning and the importance of editing and Proofreading. Get an overview of time management. Learn about the basics of Microsoft Office Skills and the key benefits of using Microsoft Office Skills. Main Course: Level 5 Office Management and Administration Free Courses are including with this Office Skills & Administration (Office Management) Training for Receptionist & PA Course Along with The Level 5 Office Management and Administration Course, We Offer a free Diploma in Medical Receptionist and Secretary Course Along with The Level 5 Office Management and Administration Course, We Offer a free Executive Secretary & PA Training Course Special Offers of this Office Skills & Administration (Office Management) Training for Receptionist & PA Course This Office Skills & Administration (Office Management) Training for Receptionist & PA Course includes a FREE PDF Certificate. Lifetime access to this Office Skills & Administration (Office Management) Training for Receptionist & PA Course Instant access to this Office Skills & Administration (Office Management) Training for Receptionist & PA Course Get FREE Tutor Support to this Office Skills & Administration (Office Management) Training for Receptionist & PA Course Office Skills & Administration (Office Management) Training for Receptionist & Executive PA The Office Skills & Administration (Office Management) Training for Receptionist & PA Certificate course will help you better understand Job Search and Interview Skills and other important topics. You will have learned all of the necessary skills and knowledge to be successful in this sector after completing the Office Administration and Management course. The office management and administration course will help you better understand Job Search and Interview Skills and its key areas. You will have achieved all of the necessary skills and knowledge to be successful in this industry by completing an Office Skills & Administration (Office Management) Training for Receptionist & PA Certificate course. Who is this course for? Office Skills & Administration (Office Management) Training for Receptionist & Executive PA For individuals hoping to get a head start or who want to become future professionals in this Office Management and Administration field, the Office Management and Administration course is perfect. This Office Management and Administration course has been created to strengthen your CV and increase your competence. Requirements Office Skills & Administration (Office Management) Training for Receptionist & Executive PA To enrol in this Office Skills & Administration (Office Management) Training for Receptionist & PA Certificate Course, students must fulfil the following requirements. To join in our Course, you must have a strong command of the English language. To successfully complete our Course, you must be vivacious and self driven. To complete our Course, you must have a basic understanding of computers. A minimum age limit of 15 is required to enrol in this Course. Career path Office Skills & Administration (Office Management) Training for Receptionist & Executive PA You will be able to grasp your abilities for a career in the appropriate employment field, such as: Office Management Assistant, Officer, or Office Management and Administration, after completing the Office Management and Administration course.

As humanitarians, helping others is both rewarding and challenging as it takes a toll on our wellbeing and mental health. Whether you are providing humanitarian response to current events in Israel and Gaza, the protracted crises in Syria, civil war in Yemen, earthquake in Nepal, or flooding in Dominican Republic (just to name a few), a focus on your wellbeing and mental health is just as important as those you help.  Partnering with The KonTerra Group, an expert in wellbeing and resilience, we created videos in English, Hebrew, Arabic, French, Spanish, Ukrainian, Polish, and Russianon the topics below. They are available on the DisasterReady YouTube channel making them easily available for you and those you are helping.  Coping with Grief and LossCoping with an Insecure EnvironmentUnderstanding and Coping with Vicarious TraumaMaintaining Wellbeing During DisplacementWays to Stay Calm in an EmergencyUnderstanding and Coping with BurnoutWhat Is Counseling and How Can it Help Me?10 Tips for Supporting Staff After a Traumatic EventSupporting Staff During Evacuation, Displacement and Shelter in Place Take a few minutes to invest in your wellbeing by watching one or more of the videos and forward the YouTube link to co-workers, family, and the crisis-affected communities you are walking alongside. Together we can help each other strengthen our wellbeing and mental health during these difficult times. As humanitarians, helping others is both rewarding and challenging as it takes a toll on our wellbeing and mental health. Whether you are providing humanitarian response to current events in Israel and Gaza, the protracted crises in Syria, civil war in Yemen, earthquake in Nepal, or flooding in Dominican Republic (just to name a few), a focus on your wellbeing and mental health is just as important as those you help.  Partnering with The KonTerra Group, an expert in wellbeing and resilience, we created videos in English, Hebrew, Arabic, French, Spanish, Ukrainian, Polish, and Russianon the topics below. They are available on the DisasterReady YouTube channel making them easily available for you and those you are helping.  Coping with Grief and LossCoping with an Insecure EnvironmentUnderstanding and Coping with Vicarious TraumaMaintaining Wellbeing During DisplacementWays to Stay Calm in an EmergencyUnderstanding and Coping with BurnoutWhat Is Counseling and How Can it Help Me?10 Tips for Supporting Staff After a Traumatic EventSupporting Staff During Evacuation, Displacement and Shelter in Place Take a few minutes to invest in your wellbeing by watching one or more of the videos and forward the YouTube link to co-workers, family, and the crisis-affected communities you are walking alongside. Together we can help each other strengthen our wellbeing and mental health during these difficult times. As humanitarians, helping others is both rewarding and challenging as it takes a toll on our wellbeing and mental health. Whether you are providing humanitarian response to current events in Israel and Gaza, the protracted crises in Syria, civil war in Yemen, earthquake in Nepal, or flooding in Dominican Republic (just to name a few), a focus on your wellbeing and mental health is just as important as those you help.  Partnering with The KonTerra Group, an expert in wellbeing and resilience, we created videos in English, Hebrew, Arabic, French, Spanish, Ukrainian, Polish, and Russianon the topics below. They are available on the DisasterReady YouTube channel making them easily available for you and those you are helping.  Coping with Grief and LossCoping with an Insecure EnvironmentUnderstanding and Coping with Vicarious TraumaMaintaining Wellbeing During DisplacementWays to Stay Calm in an EmergencyUnderstanding and Coping with BurnoutWhat Is Counseling and How Can it Help Me?10 Tips for Supporting Staff After a Traumatic EventSupporting Staff During Evacuation, Displacement and Shelter in Place Take a few minutes to invest in your wellbeing by watching one or more of the videos and forward the YouTube link to co-workers, family, and the crisis-affected communities you are walking alongside. Together we can help each other strengthen our wellbeing and mental health during these difficult times. As humanitarians, helping others is both rewarding and challenging as it takes a toll on our wellbeing and mental health. Whether you are providing humanitarian response to current events in Israel and Gaza, the protracted crises in Syria, civil war in Yemen, earthquake in Nepal, or flooding in Dominican Republic (just to name a few), a focus on your wellbeing and mental health is just as important as those you help.  Partnering with The KonTerra Group, an expert in wellbeing and resilience, we created videos in English, Hebrew, Arabic, French, Spanish, Ukrainian, Polish, and Russianon the topics below. They are available on the DisasterReady YouTube channel making them easily available for you and those you are helping.  Coping with Grief and LossCoping with an Insecure EnvironmentUnderstanding and Coping with Vicarious TraumaMaintaining Wellbeing During DisplacementWays to Stay Calm in an EmergencyUnderstanding and Coping with BurnoutWhat Is Counseling and How Can it Help Me?10 Tips for Supporting Staff After a Traumatic EventSupporting Staff During Evacuation, Displacement and Shelter in Place Take a few minutes to invest in your wellbeing by watching one or more of the videos and forward the YouTube link to co-workers, family, and the crisis-affected communities you are walking alongside. Together we can help each other strengthen our wellbeing and mental health during these difficult times. As humanitarians, helping others is both rewarding and challenging as it takes a toll on our wellbeing and mental health. Whether you are providing humanitarian response to current events in Israel and Gaza, the protracted crises in Syria, civil war in Yemen, earthquake in Nepal, or flooding in Dominican Republic (just to name a few), a focus on your wellbeing and mental health is just as important as those you help.  Partnering with The KonTerra Group, an expert in wellbeing and resilience, we created videos in English, Hebrew, Arabic, French, Spanish, Ukrainian, Polish, and Russianon the topics below. They are available on the DisasterReady YouTube channel making them easily available for you and those you are helping.  Coping with Grief and LossCoping with an Insecure EnvironmentUnderstanding and Coping with Vicarious TraumaMaintaining Wellbeing During DisplacementWays to Stay Calm in an EmergencyUnderstanding and Coping with BurnoutWhat Is Counseling and How Can it Help Me?10 Tips for Supporting Staff After a Traumatic EventSupporting Staff During Evacuation, Displacement and Shelter in Place Take a few minutes to invest in your wellbeing by watching one or more of the videos and forward the YouTube link to co-workers, family, and the crisis-affected communities you are walking alongside. Together we can help each other strengthen our wellbeing and mental health during these difficult times. As humanitarians, helping others is both rewarding and challenging as it takes a toll on our wellbeing and mental health. Whether you are providing humanitarian response to current events in Israel and Gaza, the protracted crises in Syria, civil war in Yemen, earthquake in Nepal, or flooding in Dominican Republic (just to name a few), a focus on your wellbeing and mental health is just as important as those you help.  Partnering with The KonTerra Group, an expert in wellbeing and resilience, we created videos in English, Hebrew, Arabic, French, Spanish, Ukrainian, Polish, and Russianon the topics below. They are available on the DisasterReady YouTube channel making them easily available for you and those you are helping.  Coping with Grief and LossCoping with an Insecure EnvironmentUnderstanding and Coping with Vicarious TraumaMaintaining Wellbeing During DisplacementWays to Stay Calm in an EmergencyUnderstanding and Coping with BurnoutWhat Is Counseling and How Can it Help Me?10 Tips for Supporting Staff After a Traumatic EventSupporting Staff During Evacuation, Displacement and Shelter in Place Take a few minutes to invest in your wellbeing by watching one or more of the videos and forward the YouTube link to co-workers, family, and the crisis-affected communities you are walking alongside. Together we can help each other strengthen our wellbeing and mental health during these difficult times.

Understand the Mental Toughness model and look at how to improve your mental toughness with the 4c’s. Course overview Duration: 1 day (6.5 hours) Mental toughness is the ability to resist, manage and overcome doubts, worries, concerns and circumstances that prevent you from succeeding, or excelling at a task or towards an objective or a performance outcome that you set out to achieve. Our one day programme can help you to achieve this by using tools and techniques to help you perform under pressure and ensure your wellbeing. Objectives  By the end of the course you will to: Identify the causes of stress and how to prevent them Assess your mental toughness using the MTQ48 measure Use tools and techniques to develop your mental toughness Content Understanding Stress, Pressure and Challenge The causes of stress How stress can manifest itself Threat response The Stress performance curve Stress, challenge and pressure Positive stress Mental Toughness, Stress Management and Resilience Defining stress management, resilience and mental toughness How they differ and how they affect each other Mental Toughness Understanding mental toughness The importance of mental toughness The benefits of developing your mental toughness The 4 Cs of Mental Toughness How we approach Challenge Control our emotions Develop Confidence Create Commitment MTQ48 Profile Understanding your MTQ48 profile Looking at your mental toughness Areas for development Developing Mental Toughness Managing physical energy to deal with stress Developing healthy habits for managing stress Multitasking and the ability to focus Identifying unhelpful thought patterns Positive and pragmatic thinking approaches Managing your approach to change and challenge Ways of developing mental toughness

Overview Thrive in your workplace by gaining essential leadership & management skills through our all-inclusive Leadership & Management Diploma course. This comprehensive program is designed to equip you with the knowledge and expertise necessary to become a qualified leader, proficient in effective management practices. You will explore the fundamental differences between leadership and management, understand their significance, and learn how to navigate the complexities of organizational dynamics. Throughout the Leadership & Management Diploma course, you will delve into crucial topics such as conflict management and the various responsibilities that come with effective leadership & management. By engaging with practical scenarios and real-world applications, you'll develop advanced interpersonal communication skills that enable you to align your strategies and address management challenges swiftly and effectively. Enhance your career prospects by enrolling in the Leadership & Management Diploma today! This Leadership & Management Diploma course will provide you with the tools to excel in any leadership role and make a significant impact within your organization. Don't miss the opportunity to elevate your career in leadership & management. Key Features of the Course: FREE Leadership & Management Diploma CPD-accredited certificate Get a free student ID card with Leadership & Management Diploma training (£10 applicable for international delivery) Lifetime access to the Leadership & Management Diploma course materials The Leadership & Management Diploma program comes with 24/7 tutor support Get instant access to this Leadership & Management Diploma course Learn Leadership & Management Diploma training from anywhere in the world The Leadership & Management Diploma training is affordable and simple to understand The Leadership & Management Diploma training is entirely online How will I get my certificate? You may have to take a quiz or a written test online during or after the Leadership & Management Diploma course. After successfully completing the course, you will be eligible for the certificate. Who is this course for? There is no experience or previous qualifications required for enrolment on this Leadership & Management Diploma. It is available to all students, of all academic backgrounds. Requirements Our Leadership & Management Diploma is fully compatible with PC's, Mac's, Laptop, Tablet and Smartphone devices. This course has been designed to be fully compatible on tablets and smartphones so you can access your course on wifi, 3G or 4G.There is no time limit for completing this course, it can be studied in your own time at your own pace. Career path With the Leadership & Management Diploma, you can explore a variety of rewarding career opportunities, including: Team Leader: £25,000 - £40,000 Project Manager: £30,000 - £50,000 Operations Manager: £35,000 - £60,000 Department Manager: £30,000 - £55,000 HR Manager: £35,000 - £60,000 General Manager: £40,000 - £70,000 Course Curriculum 1 sections • 20 lectures • 08:39:00 total length •Understanding Management and Leadership: 00:40:00 •Leadership Theories: 00:25:00 •Improving Management and Leadership Performance: 00:15:00 •High Performance Teams: 00:32:00 •Motivating Employees: 00:26:00 •Organisational Skills: 00:26:00 •Talent Management: 00:37:00 •Succession Planning: 00:24:00 •Business Process Management: 00:28:00 •Communication Skills: 00:27:00 •Negotiation Techniques: 00:15:00 •Managing Meetings and Giving Feedback: 00:21:00 •Managing Change: 00:22:00 •Time Management: 00:37:00 •Stress Management: 00:15:00 •Emotional Intelligence in Leadership: 00:32:00 •Managing Conflict: 00:14:00 •Dealing with Office Politics: 00:34:00 •Risk Management: 00:35:00 •Corporate Responsibility and Ethics: 00:14:00

Overview of Forensic Engineering Investigator Join our Forensic Engineering Investigator 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 Forensic Engineering Investigator course has everything you need to get a great start in this sector. Improving and moving forward is key to getting ahead personally. The Forensic Engineering Investigator 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! This Forensic Engineering Investigator Course will help you to learn: 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 Forensic Engineering Investigator. 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 Certificate of Completion – Digital / PDF Certificate After completing the Forensic Engineering Investigator course, you can order your CPD Accredited Digital/ PDF Certificate for £5.99. Certificate of Completion – Hard copy Certificate You can get the CPD Accredited Hard Copy Certificate for £12.99. Shipping Charges: Inside the UK: £3.99 International: £10.99 Who Is This Course for? This Forensic Engineering Investigator 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 You don’t need any educational qualification or experience to enrol in the Forensic Engineering Investigator 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 Forensic Engineering Investigator 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 Unit 01: Brief Overview Introduction and Definition of Forensic Engineering 00:01:00 Components of Forensic Engineering 00:03:00 Application of Forensic Engineering 00:02:00 Unit 02: Standard Operating Procedure & Various Stages of an Engineering Product SOP 00:03:00 Stages of Engineering Product - Stage I 00:03:00 Stage - II 00:01:00 Stage - III and IV 00:02:00 Unit 03: Steps in Forensic Engineering Investigation Various Steps in Forensic Engineering 00:06:00 Unit 04: Contemporary Methods and techniques used in Forensic Engineering investigation Methods Used 00:11:00 Unit 05: Report Writing and Case Studies Report Writing 00:05:00 Real Case Study 00:03:00 Unit 06: Resources and Reference Materials Reference materials & Bonus 00:00:00 Thank you! 00:01:00

This Level 7: Business Management course is appropriate for both eager novices and seasoned professionals. Through this course, you will learn everything you need to know to start or progress your career in Business Management at the highest possible level. It will help you develop technical abilities as well as a deep understanding of business management. The course will educate you on operational management, risk management, succession planning, project management, and others. You can also learn about numerous strategic techniques and business management preparation in this Training Tale Level 7: Business Management course. Additionally, this step-by-step online course will teach you how to respond to issues that arise during running a business, helping you make well-informed management decisions. Enrol today and take the next step toward achieving your personal and professional goals. Learning Outcomes At the end of the Level 7: Business Management course, the learner will be able to: Provide a brief idea about Business Management and its importance. Discuss all the terms related to Business Management. Clarify the differences between a leader and a manager. Describe the theory of leadership and management to encourage organisational direction. Determine the personal and technical skills needed to attain strategic objectives. Develop a personal improvement plan. Describe the concepts of strategic business management. Understand the UK law and regulations related to business. Develop an action plan for an organisation. Why Choose Level 7: Business Management Course from Us Self-paced course, access available from anywhere. Easy to understand, high-quality study materials. Course developed by industry experts. MCQ quiz after each module to assess your learning. Automated and instant assessment results. 24/7 support via live chat, phone call or email. Free PDF certificate as soon as completing the course. 10 COURSES BUNDLE INFO Main Course : Level 7 Business Management Course *** Additional Courses*** Course 01: HR and Payroll Management Course 02: Level 5 Retail Management Course Course 03: Level 5 Diploma in Risk Management Course Course 04: Level 4 Time Management Course Course 05: Level 7 Diploma in Facilities Management Course 06: Level 5 Report Writing Course Course 07: Property Management Course 08: Level 2 Customer Service Course 09: Childcare and Nutrition ***Others Included*** Free 7 PDF Certificate Access to Content - Lifetime Exam Fee - Totally Free Free Retake Exam [ Note: Free PDF certificate will provide as soon as completing the Business Management Course] Course Curriculum *** Level 7: Business Management *** Module 01: Introduction Module 02: Financial Resource and Investment Management Module 03: Succession Planning Module 04: Risk Management Module 05: Supply Chain Management Module 06: Human Resource Management Module 07: Leadership and Management Module 08: Change Management Module 09: Conflict Management Module 10: Project Management Module 11: Communication Techniques for Business Management Module 12: Entrepreneurship and Small Business Management Module 13: UK Business Law >-----------------------< Assessment Method After you have finished Level 7: Business Management Course, you will need to take an electronic multiple-choice exam or Assignment to see if you have grasped everything. To pass the exam and be eligible for the pending certificates, you must achieve at least 60%. As soon as you pass the examination, you will be qualified to request your certification. Certification After completing the MCQ/Assignment assessment for this course, you will be entitled to a Certificate of Completion from Training Tale. It will act as proof of your extensive professional development. The certificate is in PDF format, which is completely free to download. A printed version is also available upon request. It will also be sent to you through a courier for £13.99. Who is this course for? This Level 7: Business Management course is highly recommended for: Entrepreneurs. Small business owners. Existing business professionals. Program Manager. Facility Manager. Program Administrator. Students Recent graduates. Requirements There are no specific requirements for this course because it does not require any advanced knowledge or skills. Students who intend to enrol in this Level 7: Business Management course must meet the following requirements: Good command of the English language Must be vivacious and self-driven Basic computer knowledge A minimum of 16 years of age is required Career path The Level 7: Business ManagementCourse is designed to give you the skills and knowledge you need to land your dream job, advance at work, go self-employed, or start your own business. Certificates Certificate of completion Digital certificate - Included

Duration 4 Days 24 CPD hours This course is intended for This course is appropriate for anyone who wants to create applications or modules to automate and simplify common tasks with Perl. Overview Working within in an engaging, hands-on learning environment, guided by our expert web development, PHP practitioner, students will learn to: Create a working script that gets input from the command line, the keyboard, or a file Use arrays to store and process data from files Create formatted reports Use regular expressions Use the appropriate types of variables and data structures Refactor duplicate code into subroutines and modules What is available in the standard library Use shortcuts and defaults, and what they replace Introduction to Perl Programming Essentials is an Introductory-level practical, hands-on Perl scripting training course that guides the students from the basics of writing and running Perl scripts to using more advanced features such as file operations, report writing, the use of regular expressions, working with binary data files, and using the extensive functionality of the standard Perl library. Students will immediately be able to use Perl to complete tasks in the real world. Session: An Overview of Perl What is Perl? Perl is compiled and interpreted Perl Advantages and Disadvantages Downloading and Installing Perl Which version of Perl Getting Help Session: Creating and running Perl Programs Structure of a Perl program Running a Perl script Checking syntax and warnings Execution of scripts under Unix and Windows Session: Basic Data and I/O Numeric and Text literals Math operators and expressions Scalar variables Default values Writing to standard output Command line arguments Reading from the standard input Session: Logic and Loops About flow control The if statement and Boolean values Using unless and elsif Statement modifiers warn() and die() The conditional construct Using while loop and its variants Using the for loop Exiting from loops Session: Lists and Arrays The list data type Accessing array elements Creating arrays List interpolation Arrays and memory Counting elements Iterating through an array List evaluation Slices and ranges Session: Reading and writing text files File I/O Overview Opening a file Reading text files Writing to a text file Arrays and file I/O Using the <> operator Session: List functions Growing and shrinking arrays The split() function Splitting on whitespace Assigning to literal lists The join() function The sort() function Alternate sort keys Reversing an array Session: Formatting output Using sprintf() and printf() Report formatting overview Defining report formats The write() function Advanced filehandle magic Session: Hashes Hash overview Creating hashes Hash attributes Traversing a hash Testing for existence of elements Deleting hash elements Session: References What is a reference? The two ways to create references References to existing data References to anonymous data Dereferencing scalar, array, and ash references Dereferencing elements of arrays and hashes Multidimensional arrays and other data structures Session: Text and Regular Expressions String length The substr() function The index() and rindex() functions String replication Pattern matching and substitution Regular expressions Session: Raw file and data access Opening and closing raw (binary) files Reading raw data Using seek() and tell() Writing raw data Raw data manipulation with pack() and unpack() Session: Subroutines and variable scope Understanding packages Package and Lexical variables Localizing builtin variables Declaring and calling subroutines Calling subroutines Passing parameters and returning values Session: Working with the operating system Determining current OS Environment variables Running external programs User identification Trapping signals File test operators Working with files Time of day Session: Shortcuts and defaults Understanding $_ shift() with no array specified Text file processing Using grep() and Using map() Command-line options for file processing Session: Data wrangling Quoting in Perl Evaluating arrays Understanding qw( ) Getting more out of the <> operator Read ranges of lines Using m//g in scalar context The /o modifier Working with embedded newlines Making REs more readable Perl data conversion Session: Using the Perl Library The Perl library Old-style library files Perl modules Modules bundled with Perl A selection of modules Getting modules from ActiveState Getting modules from CPAN Using Getopt::Long Session: Some Useful Tools Sending and receiving files with Net::FTP Using File::Find to search for files and directories Grabbing a Web page Some good places to find scripts Perl man pages for more information Zipping and unzipping files

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 Additional course details: Nexus Humans Oracle 12c PL/SQL Fundamentals 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 Oracle 12c PL/SQL Fundamentals 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.