2680 Maintenance courses in Cardiff delivered Online

Quality Guarantee: Promising training excellence, satisfaction gurantee Accredited by CPD UK & Quality License Scheme Tutor Support Unlimited support via email, till you complete the course Recognised Certification: Accepted by thousands of professional bodies Start Anytime With 1 year access to the course materials Online Learning: Learn from anywhere, whenever you want This Hormone Health & Testosterone Certification Course will help you to promote your as well as others' hormonal balance and overall wellness. With this specialised course, you will become a certified hormone health expert, capable of making a profound impact on the lives of your clients. This course at a glance Accredited by CPD UK Endorsed by Quality Licence Scheme Gain knowledge about the endocrine system and its type Understand the relationship between cholesterol, hormones and heart disease Identify the various types of hormones Know how to check and optimize testosterone levels Learn about diet strategies to boost testosterone and balance hormones Identify the quality of protein, fat, and carb sources Recognise the ideal calorie, protein, fat and carb intake Learn about different workouts that boost testosterone level Know how to design your HIIT workout plan Identify the lifestyle changes and supplements that boost testosterone levels Know how to balance your work and life Customise your diet for weight loss and muscle growth Why Hormone Health & Testosterone Certification Course right for you? This Hormone Health and Testosterone Certification Course is ideal for fitness trainers, health coaches, and for those who want to boost testosterone and regulate their hormones using methods that are supported by science. This course will equip you with skills and knowledge to enhance your testosterone naturally using science-based methods, specialised exercises, and a healthy diet. You will gain a deeper understanding of the various types of hormones and how to keep them in balance. This Hormone Health and Testosterone Certification Course will explain the role of hormones in mental health and help you understand how to monitor your testosterone levels. You will gain knowledge about various workouts, lifestyle changes and supplements that boost testosterone levels. Upon successful completion of this Hormone Health and Testosterone Certification Course, you will gain knowledge about the entire endocrine system and adapt effective nutrition techniques to enhance testosterone levels and balance hormones. Hormone Health & Testosterone Certification Course Details Accredited by CPD certificates are accepted by thousands of professional bodies and government regulators here in the UK and around the world. Many organisations look for employees with CPD requirements, which means, that by doing this course, you would be a potential candidate in your respective field.   The Quality Licence Scheme is a brand of the Skills and Education Group, a leading national awarding organisation for providing high-quality vocational qualifications across a wide range of industries. Course Curriculum Introduction Course Overview & What you will learn The Endocrine System Explained Hormones Introduction The 3 Types Of Hormones The Endocrine System Explained Cholesterol, Hormones And Heart Disease Anabolic Steroids - Why You Should Avoid Them Individual Hormones Explained Overview: Most Important Hormones Insulin Glucagon Adrenaline Cortisol Ghrelin Leptin Thyroid Hormones Estrogen Growth Hormone Testosterone Optimizing Testosterone Levels: Introduction Testosterone Explained Why Testosterone is Also Important for Women How to Check if You Suffer From Low Testosterone Levels Diet Strategies To Boost Testosterone & Balance Hormones Diet Introduction Calories & Testosterone Carbohydrates & Testosterone Fat & Testosterone Protein & Testosterone Meal Timing & Testosterone Setting Up Your Diet Setting Up Your Diet Overview How to Determine Your Calorie Maintenance Level(TDEE) How to Track Calories Ideal Protein Intake2 Ideal Carb Intake Ideal Fat Intake What About The Remaining Calories Determining Meal Structure Quality Protein Foods Quality Carb Foods Adjusting Your Diet for Muscle Gains Cheat Meals & Cheat Days Testosterone Boosting Workout Workout Introduction The Best Gym Exercises to Boost Testosterone Muscle Building Formula Progressive Overload Your Gym Workout Routine Bench Press Squats Military Press Deadlift Lat Pulldown Underhand Grip Row HIIT Explained How to Design Your HIIT Workout How to Progress With HIIT Rest & Sleep Rest & Sleep Introduction Sleeping Correctly 6 Tips to Fall Asleep Faster Supplements for Better Sleep Lifestyle Improvements Lifestyle Improvements Introduction Body language Managing Stress The Right Foods to Reduce Stress Work and Life Balance Cold Showers BPA Sex Alcohol Who should take this course? This Hormone Health and Testosterone Certification Course is primarily aimed at: Fitness trainer Health professionals Anyone who wants to lead a healthy life Anyone who wants to improve their testosterone level Anyone who is interested in learning about hormonal health However, this course is not restricted to any single profession or field of work. This course can also benefit anyone who wants to learn more about hormonal health and testosterone. Entry Requirements There are no academic entry requirements for this Hormone Health and Testosterone Certification Course, and it is open to students of all academic backgrounds. However, you are required to have a laptop/desktop/tablet or smartphone and a good internet connection. Assessment Method This Hormone Health and Testosterone Certification Course assesses learners through multiple-choice questions (MCQs). Upon successful completion of the modules, learners must answer MCQs to complete the assessment procedure. Through the MCQs, it is measured how much a learner could grasp from each section. In the assessment pass mark is 60%. Certification Endorsed Certificate from Quality Licence Scheme After successfully passing the MCQ exam you will be eligible to order the Endorsed Certificate by Quality Licence Scheme. The Quality Licence Scheme is a brand of the Skills and Education Group, a leading national awarding organisation for providing high-quality vocational qualifications across a wide range of industries. It will give you a competitive advantage in your career, making you stand out from all other applicants and employees. There is a Quality Licence Scheme endorsement fee to obtain an endorsed certificate which is £65. Certificate of Achievement from Lead Academy After successfully passing the MCQ exam you will be eligible to order your certificate of achievement as proof of your new skill. The certificate of achievement is an official credential that confirms that you successfully finished a course with Lead Academy. Certificate can be obtained in PDF version at a cost of £12, and there is an additional fee to obtain a printed copy certificate which is £35. FAQs Is CPD a recognised qualification in the UK? CPD is globally recognised by employers, professional organisations and academic intuitions, thus a certificate from CPD Certification Service creates value towards your professional goal and achievement. CPD-certified certificates are accepted by thousands of professional bodies and government regulators here in the UK and around the world. Are QLS courses recognised? Although QLS courses are not subject to Ofqual regulation, they must adhere to an extremely high level that is set and regulated independently across the globe. A course that has been approved by the Quality Licence Scheme simply indicates that it has been examined and evaluated in terms of quality and fulfils the predetermined quality standards. When will I receive my certificate? For CPD accredited PDF certificate it will take 24 hours, however for the hardcopy CPD certificate takes 5-7 business days and for the Quality License Scheme certificate it will take 7-9 business days. Can I pay by invoice? Yes, you can pay via Invoice or Purchase Order, please contact us at info@lead-academy.org for invoice payment. Can I pay via instalment? Yes, you can pay via instalments at checkout. How to take online classes from home? Our platform provides easy and comfortable access for all learners; all you need is a stable internet connection and a device such as a laptop, desktop PC, tablet, or mobile phone. The learning site is accessible 24/7, allowing you to take the course at your own pace while relaxing in the privacy of your home or workplace. Does age matter in online learning? No, there is no age limit for online learning. Online learning is accessible to people of all ages and requires no age-specific criteria to pursue a course of interest. As opposed to degrees pursued at university, online courses are designed to break the barriers of age limitation that aim to limit the learner's ability to learn new things, diversify their skills, and expand their horizons. When I will get the login details for my course? After successfully purchasing the course, you will receive an email within 24 hours with the login details of your course. Kindly check your inbox, junk or spam folder, or you can contact our client success team via info@lead-academy.org

This Level 5 Certificate in Cleaning is Institute of Hospitality endorsed and suitable for anyone looking to become a professional cleaner or establish a cleaning business. It covers theoretical training on cleaning procedures, chemical safety, domestic cleaning, kitchen maintenance, and much more. It also includes essential information on how to market your cleaning services, train staff and deal with clients. Through this course, you will learn how to work safely and correctly with cleaning chemicals, taking you through key procedures and guidelines for cleaning offices, new-build homes, pubs, leisure premises, hospitals, hotels, and commercial kitchens. You will also learn about cleaning contracts and employment opportunities, covering key topics such as working hours, business insurance, tax and quality of service. Topics Covered in this Course Cleaning Jobs in the UK Cleaning Techniques Cleaning Equipment Cleaning Windows, Bathroom, External Surfaces, and Office Chemical Hazard in Cleaning Waste Management Cleaning Business in the UK Free Courses Course 01: Housekeeping Course 02: Health and Safety at Workplace Course 03: Personal Hygiene Key Features Institute of Hospitality Endorsed Instant PDF certificate Fully online, interactive course with audio voiceover Developed by qualified professionals in the field If you're looking to set up a cleaning business from scratch, then this course is packed with tips and strategies for training staff, growing your client list, marketing your business online, and crafting the perfect business plan. Gain essential skills needed to fast-track your career and earn a certificate to stand out to clients and prospective employers. Course Curriculum: Level 5 Certificate in Cleaning Module 01: An Introduction to the Cleaning Job Module 02: The Diversity of Cleaning Jobs Module 03: Cleaning Equipment, Products and Clothing Module 04: House Cleaning Module 05: Food Kitchen and Commercial Kitchen Cleaning Module 06: Bathrooms and Toilets Module 07: Office Cleaning Module 08: Cleaning External Surfaces and Areas Module 09: Dealing with Non-Routine Waste Module 10: Chemical Safety, Keyholding and Alarm Codes for Cleaners Module 11: Starting a Cleaning Business and Planning for it Module 12: Running the Business with Quality Service Module 13: Customer Satisfaction Module 14: Management of Staff Module 15: Marketing, Advertising and Sales Module 16: Expansion Management Module 17: Business Insurance, Tax and Additional Equipment Housekeeping Module 01: Introduction to Hospitality Management Module 02: An Overview of Hotel Industry Module 03: Management of Housekeeping, Engineering and Security Operations Module 04: Management of Service Quality in the Hospitality Industry Module 05: Customer Satisfaction Module 06: E-Hospitality and Technology Health and Safety at Workplace Module 01: Manual Handling Hazards and Injuries Module 02: Incident Management at Work Module 03: Dealing with Minor Injuries at Workplace Module 04: Electrical Incidents Module 05: Measures of Fire Safety Module 06: Understanding Fires Module 07: Fire Emergency: Evacuation Procedures Module 08: The Fire Plan and Safety Arrangements Module 09: Controlling and Reducing the Risks Module 10: Personal Emergency Evacuation Plans (PEEP) Module: 11: Call for an Emergency Module 12: Health and Safety at Work and the Laws Personal Hygiene Course Module 01: Introduction to Personal Hygiene and a Brief History Module 02: Looking Clean, Smelling Clean Module 03: Improving and Maintaining Oral Health Module 04: Care of the Eyes Module 05: Ear Care Secrets Module 06: Foot & Nail Care in Personal Hygiene Module 07: Hair Care: Hygienic Ways Module 08: Hygienic Approach to Skin Care Module 09: Maintain Good Toilet Hygiene Module 10: Potential Hygiene Guidelines Module 11: Personal Hygiene During Coronavirus Pandemic Certification Once you've successfully completed your course, you will immediately be sent a digital certificate. Also, you can have your printed certificate delivered by post (shipping cost £3.99). CPD 10 CPD hours / points Accredited by CPD Quality Standards Who is this course for? Anyone with a knack for learning new skills can take this course. While this comprehensive training is popular for preparing people for job opportunities in the relevant fields, it also helps to advance your career for promotions. Domestic Cleaner Cleaning Supervisor Hotel Cleaner Office Cleaner School Cleaner Hospital Cleaner Career path Carpet Cleaner Domestic Cleaner Office Cleaner Sweeper Certificates Certificate of completion Digital certificate - Included Certificate of completion Hard copy certificate - Included You will get the hard copy certificates for Free! The delivery charge of the hard copy certificate inside the UK is £3.99 each.

Duration 5 Days 30 CPD hours This course is intended for Senior Red Hat Enterprise Linux system administrators responsible for the management of multiple servers Overview - Verify a Red Hat Satellite 6.6 installation. - Regulate Red Hat Satellite with organizations, locations, users, and roles. - Manage software with Red Hat Satellite environments and content views. - Use Red Hat Satellite to configure hosts with Ansible playbooks and roles. - Provision hosts with integrated software and configuration management. - Implement Metal-as-a-Service (MaaS) with Satellite discovery and provisioning of unprovisioned hosts. Red Hat Satellite 6 Administration (RH403) is a lab-based course that explores the concepts and methods necessary for successful large-scale management of Red Hat© Enterprise Linux© systems. You will learn how to configure Red Hat Satellite 6 on a server and populate it with software packages. You will use Red Hat Satellite to manage the software development life cycle of a subscribed host and its configuration, and learn how to provision hosts integrated with software and Ansible© configuration management upon deployment. This course is based on Red Hat Enterprise Linux 8 and Red Hat Satellite 6.6. 1 - Plan and deploy Red Hat Satellite Plan and deploy Red Hat Satellite Plan a Red Hat Satellite deployment, then perform installation and initial configuration of Red Hat Satellite servers. 2 - Manage software life cycles Create and manage Red Hat software deployment life cycle environments. 3 - Register hosts Register and configure your Red Hat Enterprise Linux systems to use Red Hat Satellite, then organize those systems into groups for easier management. 4 - Deploy software to hosts Manage software deployment to registered hosts of your Red Hat Satellite infrastructure and practice managing environment paths, life cycle environments, and content views. 5 - Deploy custom software Create, manage, and deploy custom software products and repositories. 6 - Deploy Satellite capsule servers Perform installation and initial configuration of Red Hat Satellite capsule servers as components of a deployment plan. 7 - Run remote execution commands Configure the ability to run ad hoc and scheduled tasks on managed hosts using a variety of configuration management tools. 8 - Provision hosts Configure Satellite server for host deployment and perform host provisioning. 9 - Manage Red Hat Satellite using the API Integrate Red Hat Satellite functionality with custom scripts or external applications that access the API over HTTP. 10 - Plan a Red Hat Satellite deployment on a cloud platform Plan a Red Hat Satellite deployment, installation, and initial configuration on a cloud platform. 11 - Perform Red Hat Satellite server maintenance Manage Red Hat Satellite for security, recoverability, and growth. 12 - Comprehensive review Install and configure Red Hat Satellite Server, then provision content hosts. Additional course details: Nexus Humans Red Hat Satellite 6 Administration (RH403) 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 Red Hat Satellite 6 Administration (RH403) 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.

Course Overview: The "Oral Health Care" course is designed to provide a comprehensive understanding of the essential concepts and practices in maintaining optimal oral health. Learners will explore a wide range of topics, from the basics of oral hygiene to the management of common oral health issues and preventive strategies. The course equips learners with the knowledge necessary to support dental care practices effectively. By the end of the course, participants will have developed a solid understanding of oral health, preventive care, and the importance of ongoing maintenance. This course offers valuable insights for those looking to advance their knowledge in dental care or enhance their qualifications in the health sector. Course Description: This course covers a range of topics designed to enhance learners' understanding of oral health care. Modules will guide participants through the fundamentals of oral health, common issues like tooth decay and gum disease, and preventive dentistry techniques. Emphasis is placed on promoting oral health, particularly in children and special populations. Learners will gain insights into the relationship between diet and oral health, as well as the importance of ongoing maintenance to prevent future complications. By completing this course, learners will be prepared to contribute to effective oral health care strategies and will acquire valuable knowledge to apply in various healthcare and dental settings. Course Modules: Module 01: Introduction to Oral Health Care Module 02: Fundamentals of Oral Health Module 03: Common Oral Health Issues Module 04: Preventive Dentistry Module 05: Oral Health Promotion in Children Module 06: Oral Health Care for Special Populations Module 07: Dental Care Procedures Module 08: Oral Health and Nutrition Module 09: Oral Health Maintenance and Beyond (See full curriculum) Who is this course for? Individuals seeking to improve their knowledge of oral health care. Professionals aiming to enhance their understanding of dental health. Beginners with an interest in pursuing a career in health and dental care. Anyone looking to gain a deeper understanding of oral health issues and prevention. Career Path Dental Care Assistant Oral Health Educator Community Health Worker Public Health Specialist Dental Practice Manager

Dive into the enriching world of Gardening and Horticulture. From landscaping design to hydroponics, plant nutrition, and pest management, this course offers comprehensive knowledge and practical skills. Unearth opportunities for a career in this green and growing field.

Microsoft Server 2012 R2 - Hands-on Training for Beginners Course Overview Are you looking to begin your Microsoft Server 2012 R2 career or want to develop more advanced skills in Microsoft Server 2012 R2? Then this Microsoft Server 2012 R2 - hands-on training for beginners course will set you up with a solid foundation to become a confident Windows Server 2012 administrator and help you to develop your expertise in Microsoft Server 2012 R2. This Microsoft Server 2012 R2 - hands-on training for beginners course is accredited by the CPD UK & IPHM. CPD is globally recognised by employers, professional organisations and academic intuitions, thus a certificate from CPD Certification Service creates value towards your professional goal and achievement. CPD certified certificates are accepted by thousands of professional bodies and government regulators here in the UK and around the world. Whether you are self-taught and you want to fill in the gaps for better efficiency and productivity, this Microsoft Server 2012 R2 - hands-on training for beginners course will set you up with a solid foundation to become a confident Windows Server 2012 administrator and develop more advanced skills. Gain the essential skills and knowledge you need to propel your career forward as a Windows Server 2012 administrator. The Microsoft Server 2012 R2 - hands-on training for beginners course will set you up with the appropriate skills and experience needed for the job and is ideal for both beginners and those currently working as a Windows Server 2012 administrator. This comprehensive Microsoft Server 2012 R2 - hands-on training for beginners course is the perfect way to kickstart your career in the field of Microsoft Server 2012 R2. This Microsoft Server 2012 R2 - hands-on training for beginners course will give you a competitive advantage in your career, making you stand out from all other applicants and employees. If you're interested in working as a Windows Server 2012 administrator or want to learn more skills on Microsoft Server 2012 R2 but unsure of where to start, then this Microsoft Server 2012 R2 - hands-on training for beginners course will set you up with a solid foundation to become a confident Windows Server 2012 administrator and develop more advanced skills. As one of the leading course providers and most renowned e-learning specialists online, we're dedicated to giving you the best educational experience possible. This Microsoft Server 2012 R2 - hands-on training for beginners course is crafted by industry expert, to enable you to learn quickly and efficiently, and at your own pace and convenience. Who is this Microsoft Server 2012 R2 - hands-on training for beginners course for? This comprehensive Microsoft Server 2012 R2 - hands-on training for beginners course is suitable for anyone looking to improve their job prospects or aspiring to accelerate their career in this sector and want to gain in-depth knowledge of Microsoft Server 2012 R2. Entry Requirement There are no academic entry requirements for this Microsoft Server 2012 R2 - hands-on training for beginners course, and it is open to students of all academic backgrounds. As long as you are aged seventeen or over and have a basic grasp of English, numeracy and ICT, you will be eligible to enrol. Assessment Method This Microsoft server 2012 r2 - hands-on training for beginners course assesses learners through multiple-choice questions (MCQs). Upon successful completion of the modules, learners must answer MCQs to complete the assessment procedure. Through the MCQs, it is measured how much a learner can grasp from each section. In the assessment pass mark is 60%. Course Curriculum Course Overview Movie - Course Overview Building Your Virtual Lab Environment Video - Downloading ISO and OVA Fles for VirtualBox Video and Lab - Creating Virtual Install of Server 2012r2 Video and Lab - Creating Virtual Install of Windows 10 Pro Using VirtualBox Video - Taking a Snapshot Of Your Current Configuration Installing and Configuring Active Directory Preparing Your Network for Active Directory Video and Lab - Preparing Server 2012 r2 for Promotion to a Domain Controller Video and Lab - Join Server 2012 R2 Core to an Existing Domain Video and Lab - Join a Windows 10 Workstation to a Microsoft Domain Video and Lab - Promote Server Core to a Domain Controller Video and Lab- Creating a Server 2012 r2 RODC Domain Naming System (DNS) Video - Create a secondary or backup DNS server Video and Lab - Create a DNS Reverse Lookup Zone Video and Lab - Create a GlobalNames zone * (Requires ADDS being present) Video - Create a New DNS Host Record Video - Create a host Record for a New Website in Microsoft DNS Video - Creating a DNS MX record Dynamic Host Configuration Protocol (DHCP) Video and Lab - Install and Configure DHCP on Server 2012 Video - Install the DHCP Role Using PowerShell Video - How to authorize/Unauthorize a DHCP server Video - How to Edit the Default Gateway Settings in DHCP Video - Edit DNS Server List In DHCP Video and Lab - Configuring a DHCP SuperScope Video and Lab - Manage DHCP Failover in Server 2012 R2 Video - Edit a DHCP Scope Video - Backup and restore the DHCP database Group Policy Video - Creating a Group Policy Object Video and Lab - Fine-Grained Password Policy in Windows Server 2012 Video and Lab - Configure Folder Redirection in Window Server 2012 R2 Video and Lab - Creating a Mapped Drive Using Group Policy Video and Lab - Managing User Desktops Using Group Policy Video - Prevent automatic logoff due to inactivity Video - How to Edit Group Policy Objects to Affect a User ideo - How to Edit a Group Policy Object to Affect a Computer Video - Backup and restore Group Policy objects in Active Directory Video - Force Screensaver and Timeouts Using Group Policy Video - Change Users Desktop Background Using Group Policy Disk Management Video - How to shrink or extend a volume in Windows Server 2012 Video - How to format a volume with ReFS in Windows Server 2019 Video - How to Format a Volume With FAT32 in Windows Server 2019 626 Print Services Video - TCP/IP Printing Overview Video and Lab - Installing Print Services on Server 2012 R2 Video and Lab - Installing a Network Printer onto a Windows Client Video and Lab - Adding a Printer to the Network Using TCP/IP Video - Printer Pooling Active Directory Maintenance Video and Lab - Creating a Custom Microsoft Management Console (MMC) Video and Lab - Creating and Managing Objects in Active Directory Video and Lab - Performing a Full Backup and Recovery of Server 2012 R2 Video - Rearm the 180-day Evaluation Period for Wondows Server Video - Rearm the 30-day Evaluation for Windows 10 Video and Lab - Disable the Internet Explorer Enhanced Security Video and Lab - Performing an Offline Defragmentation of the Directory Database Video - Creating a mapped drive in Server 2012r2 Video - Create a Heads-up Display Using BgInfo Troubleshooting Video - Allow PING Packets through for Server 2012, 2016 and 2019 Video and Lab - Troubleshooting Internet Connectivity Video - NSLookup Video - Windows Reliability Monitor (RELI) Video - Overview of Windows Sysinternal Tools Order Your Certificate Now Order Your Certificate Now Feedback Feedback Recognised Accreditation CPD Certification Service This course is accredited by continuing professional development (CPD). CPD UK is globally recognised by employers, professional organisations, and academic institutions, thus a certificate from CPD Certification Service creates value towards your professional goal and achievement. CPD certificates are accepted by thousands of professional bodies and government regulators here in the UK and around the world. Many organisations look for employees with CPD requirements, which means, that by doing this course, you would be a potential candidate in your respective field. Certificate of Achievement Certificate of Achievement from Lead Academy After successfully passing the MCQ exam you will be eligible to order your certificate of achievement as proof of your new skill. The certificate of achievement is an official credential that confirms that you successfully finished a course with Lead Academy. Certificate can be obtained in PDF version at a cost of £12, and there is an additional fee to obtain a printed copy certificate which is £35. Overview Microsoft Server 2012 R2 - Hands-on Training for Beginners Course Overview Are you looking to begin your Microsoft Server 2012 R2 career or want to develop more advanced skills in Microsoft Server 2012 R2? Then this Microsoft Server 2012 R2 - hands-on training for beginners course will set you up with a solid foundation to become a confident Windows Server 2012 administrator and help you to develop your expertise in Microsoft Server 2012 R2. This Microsoft Server 2012 R2 - hands-on training for beginners course is accredited by the CPD UK & IPHM. CPD is globally recognised by employers, professional organisations and academic intuitions, thus a certificate from CPD Certification Service creates value towards your professional goal and achievement. CPD certified certificates are accepted by thousands of professional bodies and government regulators here in the UK and around the world. Whether you are self-taught and you want to fill in the gaps for better efficiency and productivity, this Microsoft Server 2012 R2 - hands-on training for beginners course will set you up with a solid foundation to become a confident Windows Server 2012 administrator and develop more advanced skills. Gain the essential skills and knowledge you need to propel your career forward as a Windows Server 2012 administrator. The Microsoft Server 2012 R2 - hands-on training for beginners course will set you up with the appropriate skills and experience needed for the job and is ideal for both beginners and those currently working as a Windows Server 2012 administrator. This comprehensive Microsoft Server 2012 R2 - hands-on training for beginners course is the perfect way to kickstart your career in the field of Microsoft Server 2012 R2. This Microsoft Server 2012 R2 - hands-on training for beginners course will give you a competitive advantage in your career, making you stand out from all other applicants and employees. If you're interested in working as a Windows Server 2012 administrator or want to learn more skills on Microsoft Server 2012 R2 but unsure of where to start, then this Microsoft Server 2012 R2 - hands-on training for beginners course will set you up with a solid foundation to become a confident Windows Server 2012 administrator and develop more advanced skills. As one of the leading course providers and most renowned e-learning specialists online, we're dedicated to giving you the best educational experience possible. This Microsoft Server 2012 R2 - hands-on training for beginners course is crafted by industry expert, to enable you to learn quickly and efficiently, and at your own pace and convenience. Who is this Microsoft Server 2012 R2 - hands-on training for beginners course for? This comprehensive Microsoft Server 2012 R2 - hands-on training for beginners course is suitable for anyone looking to improve their job prospects or aspiring to accelerate their career in this sector and want to gain in-depth knowledge of Microsoft Server 2012 R2. Entry Requirement There are no academic entry requirements for this Microsoft Server 2012 R2 - hands-on training for beginners course, and it is open to students of all academic backgrounds. As long as you are aged seventeen or over and have a basic grasp of English, numeracy and ICT, you will be eligible to enrol. Assessment Method This Microsoft server 2012 r2 - hands-on training for beginners course assesses learners through multiple-choice questions (MCQs). Upon successful completion of the modules, learners must answer MCQs to complete the assessment procedure. Through the MCQs, it is measured how much a learner can grasp from each section. In the assessment pass mark is 60%. Course Curriculum Course Overview Movie - Course Overview Building Your Virtual Lab Environment Video - Downloading ISO and OVA Fles for VirtualBox Video and Lab - Creating Virtual Install of Server 2012r2 Video and Lab - Creating Virtual Install of Windows 10 Pro Using VirtualBox Video - Taking a Snapshot Of Your Current Configuration Installing and Configuring Active Directory Preparing Your Network for Active Directory Video and Lab - Preparing Server 2012 r2 for Promotion to a Domain Controller Video and Lab - Join Server 2012 R2 Core to an Existing Domain Video and Lab - Join a Windows 10 Workstation to a Microsoft Domain Video and Lab - Promote Server Core to a Domain Controller Video and Lab- Creating a Server 2012 r2 RODC Domain Naming System (DNS) Video - Create a secondary or backup DNS server Video and Lab - Create a DNS Reverse Lookup Zone Video and Lab - Create a GlobalNames zone * (Requires ADDS being present) Video - Create a New DNS Host Record Video - Create a host Record for a New Website in Microsoft DNS Video - Creating a DNS MX record Dynamic Host Configuration Protocol (DHCP) Video and Lab - Install and Configure DHCP on Server 2012 Video - Install the DHCP Role Using PowerShell Video - How to authorize/Unauthorize a DHCP server Video - How to Edit the Default Gateway Settings in DHCP Video - Edit DNS Server List In DHCP Video and Lab - Configuring a DHCP SuperScope Video and Lab - Manage DHCP Failover in Server 2012 R2 Video - Edit a DHCP Scope Video - Backup and restore the DHCP database Group Policy Video - Creating a Group Policy Object Video and Lab - Fine-Grained Password Policy in Windows Server 2012 Video and Lab - Configure Folder Redirection in Window Server 2012 R2 Video and Lab - Creating a Mapped Drive Using Group Policy Video and Lab - Managing User Desktops Using Group Policy Video - Prevent automatic logoff due to inactivity Video - How to Edit Group Policy Objects to Affect a User ideo - How to Edit a Group Policy Object to Affect a Computer Video - Backup and restore Group Policy objects in Active Directory Video - Force Screensaver and Timeouts Using Group Policy Video - Change Users Desktop Background Using Group Policy Disk Management Video - How to shrink or extend a volume in Windows Server 2012 Video - How to format a volume with ReFS in Windows Server 2019 Video - How to Format a Volume With FAT32 in Windows Server 2019 626 Print Services Video - TCP/IP Printing Overview Video and Lab - Installing Print Services on Server 2012 R2 Video and Lab - Installing a Network Printer onto a Windows Client Video and Lab - Adding a Printer to the Network Using TCP/IP Video - Printer Pooling Active Directory Maintenance Video and Lab - Creating a Custom Microsoft Management Console (MMC) Video and Lab - Creating and Managing Objects in Active Directory Video and Lab - Performing a Full Backup and Recovery of Server 2012 R2 Video - Rearm the 180-day Evaluation Period for Wondows Server Video - Rearm the 30-day Evaluation for Windows 10 Video and Lab - Disable the Internet Explorer Enhanced Security Video and Lab - Performing an Offline Defragmentation of the Directory Database Video - Creating a mapped drive in Server 2012r2 Video - Create a Heads-up Display Using BgInfo Troubleshooting Video - Allow PING Packets through for Server 2012, 2016 and 2019 Video and Lab - Troubleshooting Internet Connectivity Video - NSLookup Video - Windows Reliability Monitor (RELI) Video - Overview of Windows Sysinternal Tools Order Your Certificate Now Order Your Certificate Now Feedback Feedback Recognised Accreditation CPD Certification Service This course is accredited by continuing professional development (CPD). CPD UK is globally recognised by employers, professional organisations, and academic institutions, thus a certificate from CPD Certification Service creates value towards your professional goal and achievement. CPD certificates are accepted by thousands of professional bodies and government regulators here in the UK and around the world. Many organisations look for employees with CPD requirements, which means, that by doing this course, you would be a potential candidate in your respective field. Certificate of Achievement Certificate of Achievement from Lead Academy After successfully passing the MCQ exam you will be eligible to order your certificate of achievement as proof of your new skill. The certificate of achievement is an official credential that confirms that you successfully finished a course with Lead Academy. Certificate can be obtained in PDF version at a cost of £12, and there is an additional fee to obtain a printed copy certificate which is £35. FAQ Is CPD a recognised qualification in the UK? CPD is globally recognised by employers, professional organisations and academic intuitions, thus a certificate from CPD Certification Service creates value towards your professional goal and achievement. CPD-certified certificates are accepted by thousands of professional bodies and government regulators here in the UK and around the world. Are QLS courses recognised? Although QLS courses are not subject to Ofqual regulation, they must adhere to an extremely high level that is set and regulated independently across the globe. A course that has been approved by the Quality Licence Scheme simply indicates that it has been examined and evaluated in terms of quality and fulfils the predetermined quality standards. When will I receive my certificate? For CPD accredited PDF certificate it will take 24 hours, however for the hardcopy CPD certificate takes 5-7 business days and for the Quality License Scheme certificate it will take 7-9 business days. Can I pay by invoice? Yes, you can pay via Invoice or Purchase Order, please contact us at info@lead-academy.org for invoice payment. Can I pay via instalment? Yes, you can pay via instalments at checkout. How to take online classes from home? Our platform provides easy and comfortable access for all learners; all you need is a stable internet connection and a device such as a laptop, desktop PC, tablet, or mobile phone. The learning site is accessible 24/7, allowing you to take the course at your own pace while relaxing in the privacy of your home or workplace. Does age matter in online learning? No, there is no age limit for online learning. Online learning is accessible to people of all ages and requires no age-specific criteria to pursue a course of interest. As opposed to degrees pursued at university, online courses are designed to break the barriers of age limitation that aim to limit the learner's ability to learn new things, diversify their skills, and expand their horizons. Course Fee £25 £125 80% OFF 👉 CPD UK Accredited PDF Certificate Included 4 interest-free payments of £6.25 Microsoft Server 2012 R2 - Hands-on Training for Beginners quantity ENROL NOW Duration: * Hours Instant Access Get In Touch Today Live CHAT WITH US CALL ON - 0300 124 5585 Certificate of Achievement Certificate of Achievement from Lead Academy After successfully passing the MCQ exam you will be eligible to order your certificate of achievement as proof of your new skill. The certificate of achievement is an official credential that confirms that you successfully finished a course with Lead Academy. Certificate can be obtained in PDF version at a cost of £12, and there is an additional fee to obtain a printed copy certificate which is £35.

Unlock the secrets to landing your dream mechanical engineering job. Our Crack Your Mechanical Engineer Interview course equips you with the essential knowledge and interview techniques to impress employers. From fundamental mechanical engineering principles to in-demand industry specialisations, gain the confidence to ace your interview and launch a fulfilling career. Learning Outcomes: Master foundational mechanical engineering concepts. Explore diverse fields like manufacturing and material science. Gain a solid understanding of strength of materials and theory of machines. Delve into automotive engineering and fluid mechanics. Solidify your grasp of thermodynamics, RAC & HMT. Why buy this Crack Your Mechanical Engineer Interview course? Unlimited access to the course for a lifetime. Opportunity to earn a certificate accredited by the CPD Quality Standards and CIQ after completing this course. Structured lesson planning in line with industry standards. Immerse yourself in innovative and captivating course materials and activities. Assessments designed to evaluate advanced cognitive abilities and skill proficiency. Flexibility to complete the Course at your own pace, on your own schedule. Receive full tutor support throughout the week, from Monday to Friday, to enhance your learning experience. Unlock career resources for CV improvement, interview readiness, and job success. Certification After studying the course materials of the Crack Your Mechanical Engineer Interview there will be a written assignment test which you can take either during or at the end of the course. After successfully passing the test you will be able to claim the pdf certificate for £5.99. Original Hard Copy certificates need to be ordered at an additional cost of £9.60. Who is this course for? Individuals seeking mechanical engineer jobs. Graduates with a mechanical engineering degree. Professionals aiming to transition into mechanical engineering. Aspiring engineers seeking a strong foundation in the field. Anyone interested in understanding mechanical engineering concepts. Prerequisites This Crack Your Mechanical Engineer Interview does not require you to have any prior qualifications or experience. You can just enrol and start learning.This Crack Your Mechanical Engineer Interview was made by professionals and it is compatible with all PC's, Mac's, tablets and smartphones. You will be able to access the course from anywhere at any time as long as you have a good enough internet connection. Career path Mechanical Engineer: £30,000 - £60,000 Per Annum Design Engineer: £35,000 - £70,000 Per Annum Production Engineer: £32,000 - £58,000 Per Annum Maintenance Engineer: £30,000 - £55,000 Per Annum Project Engineer: £40,000 - £80,000 Per Annum Manufacturing Engineer: £38,000 - £65,000 Per Annum Course Curriculum Section 01: Introduction Scope of the course 00:03:00 Section 02: Basic Mechanical Engineering (BME) Introduction to Basic Mechanical Engineering 00:02:00 Explain the term torque 00:03:00 State Archimedes Principle 00:02:00 What is the importance of tolerance in engineering? 00:04:00 Explain different types of fits 00:03:00 Section 03: Manufacturing & Material Science Introduction to Manufacturing & Material Science 00:01:00 Define pitting 00:03:00 Distinguish Between A Jig And Fixture 00:03:00 Explain knurling 00:03:00 Why is heat treatment of steel metal crucial? 00:03:00 What is extruded aluminium? 00:02:00 What do you mean by annealing? 00:04:00 How is martensite structure formed in steel? 00:04:00 Section 04: Strength Of Material (SOM) Introduction to Strength Of Material 00:01:00 Define a uniformly distributed load 00:04:00 Define Buckling Factor 00:02:00 Is it the stress that produces strain or vice-versa 00:04:00 What is the value of modulus of elasticity of steel? 00:03:00 What is Stress Concentration? 00:03:00 Section 05: Theory Of Machine (TOM) Introduction to Theory Of Machine 00:01:00 What is gear ratio? 00:01:00 What do you mean by cotter joint 00:04:00 What are the advantages of Gear drive? 00:04:00 What are the benefits of cycloidal gears? 00:03:00 Section 06: Automobile Engineering Introduction to automobile engineering 00:01:00 What are the various types of brakes? 00:03:00 Differentiate between scavenging and supercharging 00:03:00 In IC engine, which part is known as column? 00:03:00 What causes white smoke in two-stroke locomotive engines? 00:03:00 What is the difference between turbochargers and superchargers? 00:02:00 Section 07: Fluid Mechanics (FM) Introduction to Fluid Mechanics 00:01:00 Explain The Difference Between Rotational And Irrotational Flow? 00:03:00 Navier Stokes Equation Represents The Conservation Of Which Quantity? 00:03:00 What are major and minor head losses in a fluid flow system? 00:03:00 What is a Newtonian fluid? 00:05:00 What are the differences between elbows and bends? Which has greater head losses? 00:05:00 What is the ratio of the thickness of TBL to the thickness of HBL? 00:03:00 Section 08: Thermodynamics Introduction to Thermodynamics 00:01:00 What is the second law of thermodynamics? 00:04:00 What is the difference between the heat engine & heat pump? 00:05:00 Section 09: RAC & HMT Introduction to RAC & HMT 00:01:00 What is Refrigeration? What is the unit of refrigeration? 00:03:00 Which Cycle is used in Air Refrigeration System? 00:02:00 What do you mean by emissive power? 00:02:00 What is Under-cooling or Sub-cooling of refrigeration system? 00:03:00 Explain mechanical refrigeration 00:02:00 What is heat transfer co-efficient? 00:01:00 Section 10: Miscellaneous What is the advantage of using pneumatic? 00:03:00 Define least count and how to calculate for vernier callipers? 00:02:00 Why do you need a biological shield in nuclear plants? 00:03:00 What Is The Value Of Coefficient Of Friction For Ball Bearing? 00:02:00

Driving a train isn’t just about pressing forward—it’s about handling pressure, thinking fast, and working with others who keep things on track. This mini bundle neatly combines core skills from communication to team leadership, with support in car maintenance to help lay the foundations of vehicle knowledge. Whether you're rail-minded or eyeing transport-related roles, this bundle offers accessible learning that leans into workplace know-how without drifting into overly technical waters. It’s a no-nonsense mix for those interested in roles tied to rail, travel, and team coordination—minus the grease and the guesswork. Learning Outcomes: Learn maintenance basics for understanding vehicle-related operations. Improve how you communicate clearly in high-stress situations. Handle group dynamics with stronger leadership techniques. Approach challenges with confident, logical problem-solving. Understand operational rules and expectations within rail services. Gain useful workplace habits through structured team-based scenarios. Who Is This Course For: Anyone exploring a role in rail operations or support. People interested in basic transport-related knowledge. Beginners aiming to understand driving-related environments. Staff members moving into team supervision roles. Those who want better group communication strategies. Learners seeking structured coordination and task focus. Individuals looking to support vehicle operation teams. New entrants curious about structured transport systems. Career Path (UK Average Salaries): Train Driver – £58,000/year Rail Operations Assistant – £26,000/year Transport Scheduler – £30,500/year Depot Team Leader – £34,000/year Transport Administrator – £25,000/year Passenger Services Officer – £24,500/year

With the global financial markets in such turmoil, many people are looking for security in ways they may not have considered previously. This Start Up and Grow Your Own Business course is designed for students who want to learn the skills and knowledge required to develop a business start-up. It is crucial that you create an effective plan that will allow you to test your product or service and make any necessary changes and improvements. It all starts with developing a successful business idea. This Start Up and Grow Your Own Business course comprises several modules that will look into a different aspects of this subject. It will provide learners with an understanding of the initial processes and requirements of a Start Up, as well as knowledge of the first steps in Start Up, including marketing, legal, and financial requirements, as well as an understanding of how to write a business plan. Learning Outcomes After completing this Start Up and Grow Your Own Business course, you will be able to: Understand the steps for a business start-up. Understand what is required of you to start your own business. Polish your business idea. Build your competitive advantages. Increase self-awareness and aid personal development. Develop a Start-up Business Plan. Why Choose Business START UP 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. Other courses are included with Start Up and Grow Your Own Business Bundle Course Course 01: Start Up and Grow Your Own Business Course 02: Level 7 Diploma in Operations Management Course 03: Level 7 Diploma in Facilities Management Course Course 04: Level 5 Diploma in Business Analysis Course 05: Level 5 Diploma in Risk Management Course Course 06: Level 2 Diploma in Business Administration Course 07: Level 7 Diploma in Leadership and Management Course ***Others Included in this Bundle Course Free 7 PDF Certificate Access to Content - Lifetime Exam Fee - Totally Free Free Retake Exam [ Note: Free PDF certificate as soon as completing the course ] ***Start Up and Grow Your Own Business*** Detailed course curriculum Module 1: Fundamental Steps for a Business Start-up Basic Requirements of an Entrepreneur Identify the Type and Field of Business that is More Suitable for You Identify Your Skills and Creativity Related to New Business Opportunities Analyse the Commercial Potential of a Business Opportunity Module 2: Strategic Thinking about New Business Solving a Problem Beating the Deadlines Finding Products in Short Supply Opportunities Created by News or Events Investigating the Internet Thinking Start-to-finish Niche Strategies Demographic Trends Rethink Assumptions Module 3: The Best Business Ideas for You Case Study Screen Your Ideas List Field Study SWOT Analysis Module 4: Developing a Start-up Business Plan Introduction of Start-up Business Plan Executive Summary Company Description Products & Services Marketing Plan Operational Plan Management & Organisation Startup Expenses & Capitalization Financial Plan -------------- ***Level 5 Diploma in Business Analysis*** Module 01: What is a Business Analyst? Module 02: What Makes a Good Business Analyst? Module 03: Roles of the Business Analyst Module 04: The Business Analyst and the Solution Team Module 05: Define the Problem Module 06: Vision Phase Module 07: Process Phase - Gather The Information Module 08: Process Phase - Determine the Solution Module 09: Process Phase - Write the Solution Document Module 10: Production Phase - Producing the Product Module 11: Production Phase - Monitor the Product Module 12: Confirmation Stage -------------- ***Level 7 Diploma in Facilities Management Course*** Module 01: Introduction to Facilities Management Module 02: Developing a Strategy for Facilities Management Module 03: Facilities Planning Module 04: Managing Office WorkSpace Module 05: Vendor Management & Outsourcing Module 06: Managing Change Module 07: Managing Human Resources Module 08: Managing Risk Module 09: Facilities Management Service Providers Module 10: Managing Specialist Services Module 11: Public-Private Partnerships and Facilities Management Module 12: Health, Safety, Environment and UK Law -------------- ***Level 7 Diploma in Operations Management*** Module 01: Understanding Operations Management Module 02: Understanding Process Management Module 03: Understanding Supply Chain Management Module 04: Understanding Planning & Sourcing Operations Module 05: Understanding Talent Management Module 06: Understanding Procurement Operations Module 07: Understanding Manufacturing and Service Operations Module 08: Understanding Succession Planning Module 09: Understanding Project Management Module 10: Understanding Quality Control Module 11: Understanding Product and Service Innovation Module 12: Understanding Communication Skills Module 13: Understanding Negotiation Techniques Module 14: Understanding Change Management Module 15: Understanding Maintenance Management Module 16: Understanding Conflict Management Module 17: Understanding Stress Management Module 18: Understanding Business Ethics for the Office Module 19: Understanding Business Etiquette Module 20: Understanding Risk Management -------------- ***Level 5 Diploma in Risk Management Course*** Module 01: A Quick Overview of Risk Management Module 02: Risk and its Types Module 03: Others Types of Risks and its Sources Module 04: Risk Management Standards Module 05: Enterprise Risk Management Module 06: Process of the Risk Management Module 07: Risk Assessment Module 08: Risk Analysis Module 09: Financial Risk Management Module 10: The Basics of Managing Operational Risks Module 11: Technology Risk Management Module 12: Project Risk Management Module 13: Legal Risk Management Module 14: Managing Social and Market Risk Module 15: Workplace Risk Assessment Module 16: Risk Control Techniques Module 17: Ins and Outs of Risk Management Plan -------------- ***Level 2 Diploma in Business Administration*** Module 01: Communication in a Business Environment Module 02: Principles of Providing Administrative Services Module 03: Principles of Business Document Production and Information Management Module 04: Understand Employer Organisations Module 05: Manage Personal Performance and Development Module 06: Develop Working Relationships with Colleagues Module 07: Manage Diary Systems Module 08: Produce Business Documents Module 09: Health and Safety in a Business Environment Module 10: Handle Mail Module 11: Principles of Digital Marketing Module 12: Administer Finance Module 13: Understand Working in a Customer Service Environment Module 14: Principles of Team Leading Module 15: Principles of Equality and Diversity in the Workplace Module 16: Exploring Social Media Module 17: Understand the Safe Use of Online and Social Media Platforms -------------- ***Level 7 Diploma in Leadership and Management Course*** Module 1: Understanding Management and Leadership Module 2: Leadership over Yourself Module 3: Creativity and Innovation Module 4: Leadership and Teambuilding Module 5: Motivation and People Management Module 6: Communication and Leadership Module 7: Presentation, One-to-one Interview and Meeting Management Module 8: Talent Management Module 09: Strategic Leadership Module 10: Stress Management -------------- Assessment Method After completing each module of the Start Up and Grow Your Own Business, you will find automated MCQ quizzes. To unlock the next module, you need to complete the quiz task and get at least 60% marks. Once you complete all the modules in this manner, 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? Start Up and Grow Your Own Business This course is ideal for anyone who wants to start up his own business. Requirements Start Up and Grow Your Own Business There are no specific requirements for this Start Up and Grow Your Own Business course because it does not require any advanced knowledge or skills. Students who intend to enrol in this 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 Start Up and Grow Your Own Business Upon successful completion of this course, you may choose to become a: Business Owner Entrepreneur Business Analyst Business and Enterprise Advisor Business Development Executive Certificates Certificate of completion Digital certificate - Included

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