21102 Courses

Explore comprehensive child protection and safeguarding training tailored for educators, covering UK legislation, reporting procedures, handling staff allegations, and promoting good practice in education and sports settings. Gain essential skills to create safe environments and respond effectively to safeguarding concerns.

Vegetarian Cookery and Cookery Course Online Are you prepared to study the fundamentals of Vegetarian Cookery and set off on an exciting educational journey? our Vegetarian Cookery course will provide the fundamental know-how and abilities required to succeed in Vegetarian Cookery and beyond. Our Vegetarian Cookery course provides all the knowledge of vegetarian cuisine and essential cooking techniques. Also, the Vegetarian Cookery course explains flavour profiling with herbs and spices. Moreover, the Vegetarian Cookery course includes plant-based protein sources, salad making, soups and stews. This Vegetarian Cookery course teaches how to prepare grain dishes and vegetable-centric main courses. By using Vegetarian Cookery ideas you can bake and make desserts. This Vegetarian Cookery course also describes menu planning and presentation with nutritional considerations. Join our Vegetarian Cookery course to receive a strong foundation in vegetarian cooking essentials tailored to your specific learning needs. Learning Outcome of Vegetarian Cookery After completing the Vegetarian Cookery course, you will know about: The Vegetarian cuisine and essential cooking techniques. Flavour profiling with herbs and spices and plant-based protein sources is included in the Vegetarian Cookery course. Creative salad-making, soups, stews and grain dish-making techniques are included in this Vegetarian Cookery course. This Vegetarian Cookery course describes how to make vegetable-centric main courses. Global vegetarian delights, baking and desserts sans animal products are all elaborated in the Vegetarian Cookery lessons. This Vegetarian Cookery course teaches how to plan and present a healthy menu. Main Course: Vegetarian Cookery Course Free Courses are including with this Vegetarian Cookery and Cookery Course Vegetarian Cookery and Cookery Course, We Offer a free Level 2 HACCP Training For Catering & Retail Course Vegetarian Cookery and Cookery Course, We Offer a free Level 3 HACCP Training Course Vegetarian Cookery and Cookery Course, We Offer a free Level 2 Food Hygiene and Safety Course Special Offers of this Vegetarian Cookery and Cookery Course This Vegetarian Cookery and Cookery Course includes a FREE PDF Certificate. Lifetime access to this Vegetarian Cookery and Cookery Course Instant access to this Vegetarian Cookery and Cookery Course Get FREE Tutor Support to this Vegetarian Cookery and Cookery Course Vegetarian Cookery and Cookery Course Online We cover all of the fundamental vegetarian cooking methods and information in our Vegetarian Cookery: Vegetarian Cookery Course. Using herbs and spices to create flavor profiles is another topic covered in the Vegetarian Cookery course. The Vegetarian Cookery course also covers salad dressings, soups, stews, and plant-based protein sources. You will learn how to make main courses that are primarily made of grains and vegetables in this vegetarian cooking course. You could bake and make desserts with the aid of vegetarian cooking concepts. This vegetarian cooking course covers menu planning and presentation as well as nutritional issues. Who is this course for? Vegetarian Cookery and Cookery Course Online Students at different phases of their vegetarian cooking journeys might benefit from taking the Vegetarian Cookery Essentials course. Requirements Vegetarian Cookery and Cookery Course Online To enrol in this Vegetarian Cookery and Cookery Course, students must fulfil the following requirements. To join in our Vegetarian Cookery and Cookery Course, you must have a strong command of the English language. To successfully complete our Vegetarian Cookery and Cookery Course, you must be vivacious and self driven. To complete our Vegetarian Cookery and Cookery Course, you must have a basic understanding of computers. A minimum age limit of 15 is required to enrol in this Vegetarian Cookery and Cookery Course. Career path Vegetarian Cookery and Cookery Course Online Successful completion of the Vegetarian Cookery Essentials course can lead to fascinating job options in a variety of Vegetarian Cookery-related industries. Like this: Vegetarian Cookery Specialist Vegetarian Cookery Researcher Vegetarian Cookery Educator

Phonics, Early Years, Nursery Nurse, Speech & Language Therapy with SEN - CPD Certified Are you worried about teaching children to read and write using phonics? We have designed a Phonics Teaching Course for you to make you understand this section. This Phonics Teaching : Phonics Teaching Course explains all the basics including the significance of early phonics instruction to higher-level phonics instruction. Also, the Phonics Teaching : Phonics Teaching Course explains the career of a phonics teacher. Teaching techniques, awareness and engagement are described in this Phonics Teaching : Phonics Teaching Course. Moreover, how to keep records and meet individual needs is explained in the Phonics Teaching : Phonics Teaching Course. Enrol in the Phonics Teaching : Phonics Teaching Course to get all the knowledge you need to teach phonics, from the fundamentals to the more complex concepts. Learning Outcome of Phonics Teaching Course After completing the Phonics Teaching Course, learners will know about: Phonics introduction and overview. Significance of early phonics instruction from the Phonics Teaching Course. The Phonics Teaching Course explains the career of a phonics teacher. Teaching phonics, jolly phonics and how to involve parents and carers are all explained in the Phonics Teaching Course. This Phonics Teaching Course includes how to speak and raise phonological awareness. Systematic assessment and record-keeping techniques are explained in the Phonics Teaching Course. Meeting individual needs, cognitive approaches in dyslexia and phonics for deaf children are learning modules of this Phonics Teaching Course. You can learn high-level phonics instruction from this Phonics Teaching Course. Main Course: Phonics Teaching Free Courses are including with this Reflexology Training Course Along with The Phonics: Phonics Teaching Course, We Offer a free Early Years course Along with The Phonics: Phonics Teaching Course, We Offer a free Nursery Nurse Course Along with The Phonics: Phonics Teaching Course, We Offer a free Speech & Language Therapy Course Along with The Phonics: Phonics Teaching Course, We Offer a free SEN Course Special Offers of this Phonics Teaching : Phonics Teaching Course This Phonics Teaching : Phonics Teaching Course includes a FREE PDF Certificate. Lifetime access to this Phonics Teaching : Phonics Teaching Course Instant access to this Phonics Teaching : Phonics Teaching Course Get FREE Tutor Support to this Phonics Teaching : Phonics Teaching Course Phonics, Early Years, Nursery Nurse, Speech & Language Therapy with SEN - CPD Certified This Phonics Teaching: Phonics Teaching Course covers all the basics and emphasizes the value of early phonics instruction in preparation for later, more complex phonics instruction. The duties of a phonics teacher are also explained in the Phonics Teaching Course. This course on teaching phonics discusses awareness, involvement, and instructional techniques. The Phonics Teaching Course also covers how to keep records and meet specific requirements. Who is this course for? Phonics, Early Years, Nursery Nurse, Speech & Language Therapy with SEN - CPD Certified This Phonics Teaching Course is ideal for anyone including teachers, teaching assistants, parents or anyone who works with children. Requirements Phonics, Early Years, Nursery Nurse, Speech & Language Therapy with SEN - CPD Certified To enrol in this Phonics Teaching : Phonics Teaching Course, students must fulfil the following requirements. To join in our Phonics Teaching : Phonics Teaching Course, you must have a strong command of the English language. To successfully complete our Phonics Teaching : Phonics Teaching Course, you must be vivacious and self driven. To complete our Phonics Teaching : Phonics Teaching Course, you must have a basic understanding of computers. A minimum age limit of 15 is required to enrol in this Phonics Teaching : Phonics Teaching Course. Career path Phonics, Early Years, Nursery Nurse, Speech & Language Therapy with SEN - CPD Certified After finishing the Phonics Teaching Course, you can get opportunities as: Phonics Teacher Primary School Teacher

Flash Sale! | 11-in-1 Bundle| 110 CPD Points| Gifts: Hardcopy + PDF Certificate + SID - Worth £180

Wave goodbye to stress and say hello to a healthy body, mind and soul with the Complete Online Pilates Mat Course. This pilates training course is the ultimate instructor-led program for mastering the practice of pilates online. In this course, you will be taught a wide range of pilates mat exercises, with instruction on how to position your body to achieve the correct form and improve your flexibility. This course is for learners of all levels and includes practical video tutorials to guide you every step of the way.  Whether you're a beginner with no experience, want to improve your technique, or wish to become a certified Pilates instructor, our comprehensive course is your stepping stone to a healthier, stronger you. Your Learning Goals: Improve your posture, flexibility and balance with our step-by-step training guide Strengthen your core and tone up in no time with effective pilate workout techniques Learn a wide range of beginner to advanced pilates exercises for learners of all levels Get step-by-step guidance on how to perform pilates poses correctly for maximum effect Elevate your mind body and soul through calming breathing exercises Take steps to become a fully certified Pilates instructor Understand the mental and physical health benefits of Pilates exercises Modify each pose to tailor each routine to your physical capabilities Improve your overall wellbeing and start your fitness journey today! Who is this Course for? Complete Online Pilates Mat Course is perfect for anyone trying to learn potential professional skills. As there is no experience and qualification required for this course, it is available for all students from any academic background. Entry Requirement: This course is available to all learners, of all academic backgrounds. Learners should be aged 16 or over to undertake the qualification. Good understanding of English language, numeracy and ICT are required to attend this course. CPD Certificate from Course Gate  At the successful completion of the course, you can obtain your CPD certificate from us. You can order the PDF certificate for £9 and the hard copy for £15. Also, you can order both PDF and hardcopy certificates for £22. Career path This course opens a new door for you to enter the relevant job market and also gives you the opportunity to acquire extensive knowledge along with required skills to become successful. You will be able to add our qualification to your CV/resume which will help you to stand out in the competitive job industry. Course Curriculum Introduction Introduction 00:03:00 The history of Pilates 00:04:00 The principles of Pilates 00:04:00 Before Starting to your course Safety Guidelines 00:02:00 Body Positions in Pilates 00:08:00 Pelvic Stability Exercises 00:12:00 Neutral Position 00:02:00 Alignment 00:03:00 Breathing 00:03:00 Pre-Pilates exercises 00:19:00 Beginner Level Course Beginner Lesson 1 - Hundred, Roll up, Rolling like a ball 00:19:00 Beginner Lesson 2 - Spine stretch forward, Spine stretch side, Saw 00:12:00 Beginner Lesson 3 - Spine stretch forward, Spine stretch side, Saw 00:11:00 Beginner Lesson 4 - Swan, Single leg kick, Side leg lift, Side leg circle 00:12:00 Beginner Lesson 5 - Push ups 00:08:00 Release work and stretching 00:09:00 Beginner Level - complete workout 00:40:00 Intermediate Level Course Intermediate Lesson 1 - Double leg stretch, Single/Double straight leg stretch 00:25:00 Intermediate Lesson 2 - Criss cross, Open leg rocker, Spine twist 00:13:00 Intermediate Lesson 3 - Swimming, Double leg kick 00:11:00 Intermediate Lesson 4 - Side leg kick, Banana, Teaser(preparation) 00:11:00 Intermediate Lesson 5 - Corkscrew(modified), Leg pull down, Shoulder bridge 00:10:00 Intermediate level - complete workout 00:42:00 Advanced Level Course Advanced Level Lesson 1 - Teaser1, Teaser2, Teaser3 00:13:00 Advanced Level Lesson 2 - Hip circles, Roll over, Corkscrew 00:16:00 Advanced Level Lesson 3 - Leg pull up, Jackknife, Kneeling side kicks 00:15:00 Advanced Level Lesson 4 - Seated twist, Side bend twist, Side bend mermaid 00:12:00 Advanced Level Lesson 5 - Scissors, Bicycle, Boomerang 00:14:00 Advanced Level - complete workout 00:39:00 How to create your own work out? Self practice guide 00:02:00 Certificate and Transcript Order Your Certificates or Transcripts 00:00:00

One of the most effective ways to increase customer reach is through content marketing. Gain the skills to develop a solid content strategy for your business to yield concrete outcomes with the Diploma in Content Creation Strategies Course. This Diploma in Content Creation Strategies Course outlines the methods for creating a winning content strategy for your business. The course educates you on the escape and arrival method and mind mapping techniques. In addition, it will discuss how to create meaningful connections with your audience. Finally, you'll determine the factors for targeting an attractive market to improve brand awareness and audience experiences. Upon successful completion, you will know how to create content that supports your business goals and take your business to new heights. Learning Objectives Understand what content strategy is and why your business needs it Familiarise yourself with the best content creation tools and resources Know the process of creating resonance with content and product Broaden your understanding of attractive marketing segment Learn to create contents that support your goals Be able to create meaningful content to attract target customers Who is this Course for? This Diploma in Content Creation Strategies Course is ideal for aspiring professionals who wish to gain the relevant skills and knowledge to fast track their careers. It is for those who have little or no knowledge of content creation tactics or those who are new to the field and want to test their skills and knowledge. There are no entry requirements for this course. However, an eye for detail and a creative mind is essential. Entry Requirement Anyone interested in learning more about this subject should take this Diploma in Content Creation Strategies course. This course will help you grasp the basic concepts as well as develop a thorough understanding of the subject. The course is open to students from any academic background, as there is no prerequisites to enrol on this course. The course materials are accessible from an internet enabled device at anytime of the day. CPD Certificate from Course Gate At the successful completion of the course, you can obtain your CPD certificate from us. You can order the PDF certificate for £4.99 and the hard copy for £9.99. Also, you can order both PDF and hardcopy certificates for £12.99. Career path On successfully completing the Diploma in Content Creation Strategies Course, learners can progress to a more advanced program from our course list. Career opportunities in this field include freelancing or working in-house, within a range of professional settings, with the opportunity to earn a high salary. Related professions in this industry include: Copywriter Content Manager Head of Content Marketing Search Manager Social Media Executive Course Curriculum Module 01: Foundations Introduction 00:04:00 Framework 00:03:00 Message 00:10:00 Module 02: Creating Your Unique Methodology Methodology 00:05:00 Escape and Arrival Method 00:16:00 Mind Mapping Method of Creating Your System 00:05:00 Note of Warning on Methodology 00:03:00 Module 03: Creating Resonance with Content & Product Importance of Meaning 00:05:00 Using Problem Statements to Create Meaning 00:03:00 Creating Meaningful Connections 00:06:00 Module 04: Market Selection for Attractive Marketing Market 00:09:00 Markers 00:08:00 Module 05: Choosing Your Modes of Delivery 6 Modes of Delivery 00:02:00 Authoring 00:03:00 Mentoring 00:03:00 Coaching 00:04:00 Speaking 00:03:00 Training 00:05:00 Facilitating 00:04:00 Something to Note 00:06:00 Module 06: Inviting Visual & Mental Participation Introduction to Models 00:07:00 Coming Up with a Model 00:07:00 Metaphors Introduction 00:06:00 4 Classes of Metaphors 00:09:00 Sourcing for Metaphors 00:06:00 Examples & Your Course Task 00:05:00 Module 07: Creating a Content Based Movement Movement 00:08:00 Module 08: Product & Content Creation Tools Content Creation Tools 00:09:00 Certificate and Transcript Order Your Certificates or Transcripts 00:00:00

CSS is a popular and efficient scripting language for designing web pages. Every professional in the web development sector must have adequate CSS skills to establish their presence in the industry. If you are also aspiring to become a successful web developer or web designer, the CSS Fundamentals Course can help you build your competence in CSS. In the CSS Fundamentals Course, you will learn about the fundamentals of CSS. The course will show you what you can and can't do in CSS. Through the highly informative modules, you will pick up the skills to style, size and colour HTML elements with CSS. This comprehensive course will also provide detailed lessons on advanced positioning and positioning HTML elements with Float. By the end of the CSS Fundamentals Course, you will be able to build a solid foundation in CSS and receive a certificate of achievement. This certificate will enrich your resume and help you stand out from the competition. Enrol now! Learning Objectives Learn about the primary use of CSS Know the features of CSS Understand how to add CSS to a website Develop the skills to style, size and colour HTML elements with CSS Grasp the techniques of advanced positioning with CSS Know the steps of positioning HTML elements with Float Who is this Course for? Whether you are a beginner or an existing practitioner, our CPD accredited CSS Fundamentals Course is perfect for you to gain extensive knowledge about different aspects of the relevant industry to hone your skill further. It is also great for working professionals who have acquired practical experience but require theoretical knowledge with a credential to support their skill, as we offer CPD accredited certification to boost up your resume and promotion prospects. Entry Requirement Anyone interested in learning more about this subject should take this CSS Fundamentals Course. This course will help you grasp the basic concepts as well as develop a thorough understanding of the subject. The course is open to students from any academic background, as there is no prerequisites to enrol on this course. The course materials are accessible from an internet enabled device at anytime of the day. CPD Certificate from Course Gate At the successful completion of the course, you can obtain your CPD certificate from us. You can order the PDF certificate for £4.99 and the hard copy for £9.99. Also, you can order both PDF and hardcopy certificates for £12.99. Career path On successfully completing the CSS Fundamentals Course, learners can progress to a more advanced program from our course list. Career opportunities in this field include freelancing or working in-house, within a range of professional settings, with the opportunity to earn a high salary. Related professions in this industry include: Web Engineers Web Developers Web Designers IT professionals Course Curriculum Module 01: CSS in Context What Was CSS Originally Intended To Do? 00:07:00 DEMO: The Most Basic CSS Usage 00:07:00 Responsive Design 00:02:00 Chapter Summary 00:02:00 Module 02: Overview of CSS What is CSS? 00:04:00 Where Can You Find CSS? 00:03:00 What CSS Can and Can't Do 00:02:00 Optional Demo - Serving an HTML Application 00:05:00 How Do we Add CSS to a Website? 00:04:00 Demo - Adding CSS to a Website 00:06:00 CSS Selectors 00:03:00 Using CSS Selectors 00:05:00 Module Summary 00:01:00 Module 03: Styling HTML Elements with CSS Why do We Style CSS Elements? 00:03:00 CSS and Fonts 00:03:00 DEMO: Styling Text with CSS 00:07:00 Sizing HTML Elements with CSS 00:06:00 DEMO: Sizing HTML Elements with CSS 00:08:00 Colorizing HTML Elements with CSS 00:05:00 DEMO: Colorizing HTML Elements with CSS 00:07:00 Summary of this Chapter 00:01:00 Module 04: Arranging Elements with CSS Introduction 00:01:00 Adding Margin with CSS 00:01:00 Advanced Positioning with CSS 00:04:00 DEMO: Positioning Elements Absolutely and Relatively 00:07:00 Positioning HTML Elements with Float 00:02:00 DEMO: Positioning HTML Elements with Float 00:07:00 Summary of this Course 00:04:00 Certificate and Transcript Order Your Certificates or Transcripts 00:00:00

Start Your Happiness Journey with Our Free Bonus Course Today! Join our Happiness Bonus Course and discover scientifically backed practices to cultivate joy, resilience, and well-being. Dive into modules covering neurotransmitters, mindfulness, gratitude, self-compassion, ACT, and more. Create your personalized happiness plan and balance peace, play, and purpose in your life. Don't wait for one day, start today! #HappinessCourse #Mindfulness #WellBeing #SelfCompassion #Resilience #Gratitude #ACT #Joy #MentalHealth #FreeCourse

Follow your dreams by enrolling on the Dog Grooming and Cleaning course today and develop the experience, skills and knowledge you need to enhance your professional development. Dog Grooming and Cleaning will help you arm yourself with the qualities you need to work towards your dream job. Study the Dog Grooming and Cleaning training course online with Janets through our online learning platform and take the first steps towards a successful long-term career. The Dog Grooming and Cleaning course will allow you to enhance your CV, impress potential employers, and stand out from the crowd.  This Dog Grooming and Cleaning course consists of a number of easy to digest, in-depth modules, designed to provide you with a detailed, expert level of knowledge.  Receive online tutor support as you study the Dog Grooming and Cleaning course, to ensure you are supported every step of the way. Get a digital certificate as proof of your Dog Grooming and Cleaning course completion. Janets is one of the top online training course providers in the UK, and we want to make education accessible to everyone! Learn the essential skills you need to succeed and build a better future for yourself with the Dog Grooming and Cleaning course. The Dog Grooming and Cleaning course is designed by industry experts and is tailored to help you learn new skills with ease.  The Dog Grooming and Cleaning is incredibly great value and allows you to study at your own pace. With full course access for one year, you can complete the Dog Grooming and Cleaning when it suits you. Access the Dog Grooming and Cleaning course modules from any internet-enabled device, including computers, tablets, and smartphones. The Dog Grooming and Cleaning course is designed to increase your employability and equip you with everything you need to be a success. Enrol on the Dog Grooming and Cleaning now and start learning instantly! What You Get Out Of Studying Dog Grooming and Cleaning With Janets Free PDF certificate upon successful completion of the Dog Grooming and Cleaning Full one-year access to Dog Grooming and Cleaning Course materials Instant assessment results with the Dog Grooming and Cleaning No hidden fees with the Dog Grooming and Cleaning Full tutor support available from Monday to Friday with the Dog Grooming and Cleaning Study the Dog Grooming and Cleaning at your own pace Benefit from instant feedback through mock exams and multiple-choice assessments Gain a complete understanding of Dog Grooming and Cleaning Accessible, informative modules taught by expert instructors Get 24/7 help or advice from our email and live chat teams with the Dog Grooming and Cleaning Study the Dog Grooming and Cleaning in your own time through your computer, tablet or mobile device Improve your chance of gaining professional skills and better earning potential by completing the Dog Grooming and Cleaning Description The Dog Grooming and Cleaning training course is delivered through Janets' online learning platform. Access the Dog Grooming and Cleaning content from any internet-enabled device whenever or wherever you want to. The Dog Grooming and Cleaning course has no formal teaching deadlines, meaning you are free to complete the course at your own pace. Method of Assessment  To successfully complete the Dog Grooming and Cleaning course, students will have to take an automated multiple-choice exam. This exam will be online and you will need to score 60% or above to pass the Dog Grooming and Cleaning course. After successfully passing the Dog Grooming and Cleaning course exam, you will be able to apply for a CPD-accredited certificate as proof of your Dog Grooming and Cleaning qualification. Certification All students who successfully complete the Dog Grooming and Cleaning course can instantly download their digital certificate. You can also purchase a hard copy of the Dog Grooming and Cleaning course certificate, which will be delivered by post for £9.99. Who Is This Course For: The Dog Grooming and Cleaning is ideal for those who already work in this sector or are an aspiring professional. This Dog Grooming and Cleaning course is designed to enhance your expertise and boost your CV. Learn key skills and gain a professional qualification to prove your newly-acquired knowledge. Requirements: The Dog Grooming and Cleaning is open to all students and has no formal entry requirements. To study the Dog Grooming and Cleaning course, all your need is a passion for learning, a good understanding of English, numeracy, and IT skills. You must also be over the age of 16. Career Path: The Dog Grooming and Cleaning is ideal for anyone who wants to pursue their dream career in a relevant industry. Learn the skills you need to boost your CV and go after the job you want. Complete the Dog Grooming and Cleaning and gain an industry-recognised qualification that will help you excel in finding your ideal job. Course Content Dog Grooming and Cleaning The History of Dog Grooming 00:15:00 Why Do We Groom? 00:15:00 Anatomy 00:15:00 Breed Groups and Coat Types 00:15:00 Equipment and Techniques 01:00:00 Keep Your Dog Healthy and Clean 01:00:00 Things to Look for Before you Groom a Dog 00:15:00 Pre-grooming and General Care 00:30:00 Preparation 00:30:00 Skin Conditions 01:00:00 How to Bathe Your Dog 00:15:00 How to Get Your Dog to Love Bath Time 00:15:00 Drying Your Dog After a Bath 00:15:00 Bathing and Drying: General Considerations 00:15:00 Grooming Details (Clipping, Scissors, Ears, Teeth, Feet, Bottoms) 00:30:00 Basic First Aid 01:00:00 Mock Exam Mock Exam - Dog Grooming and Cleaning 00:20:00 Final Exam Final Exam - Dog Grooming and Cleaning 00:20:00 Frequently Asked Questions Are there any prerequisites for taking the course? There are no specific prerequisites for this course, nor are there any formal entry requirements. All you need is an internet connection, a good understanding of English and a passion for learning for this course. Can I access the course at any time, or is there a set schedule? You have the flexibility to access the course at any time that suits your schedule. Our courses are self-paced, allowing you to study at your own pace and convenience. How long will I have access to the course? For this course, you will have access to the course materials for 1 year only. This means you can review the content as often as you like within the year, even after you've completed the course. However, if you buy Lifetime Access for the course, you will be able to access the course for a lifetime. Is there a certificate of completion provided after completing the course? Yes, upon successfully completing the course, you will receive a certificate of completion. This certificate can be a valuable addition to your professional portfolio and can be shared on your various social networks. Can I switch courses or get a refund if I'm not satisfied with the course? We want you to have a positive learning experience. If you're not satisfied with the course, you can request a course transfer or refund within 14 days of the initial purchase. How do I track my progress in the course? Our platform provides tracking tools and progress indicators for each course. You can monitor your progress, completed lessons, and assessments through your learner dashboard for the course. What if I have technical issues or difficulties with the course? If you encounter technical issues or content-related difficulties with the course, our support team is available to assist you. You can reach out to them for prompt resolution.

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