2463 Maintenance courses in Cardiff delivered Online

This course delves into the world of solar energy, providing comprehensive knowledge about solar power systems, components, installation, and design. From the fundamentals of PV system construction to advanced concepts like charge controllers and solar water pumping, participants will acquire the skills needed to harness the potential of solar energy for various applications. Learning Outcomes: Understand the basics of solar energy, including solar heating, irradiation, and panel technologies. Analyze the effects of insolation and temperature on the V-I curve of solar panels. Perform PV system installations, short circuit, and open circuit tests using appropriate tools. Master the installation of solar wires, cables, and mounting techniques. Evaluate shading, tilt angles, and their impact on solar energy systems. Comprehend charge controllers' significance and differentiate between PWM and MPPT types. Apply half-cut cell technology and design solar systems using junction boxes and inverters. Design complete solar energy systems, including off-grid and on-grid configurations. Why buy this Solar Energy?  Unlimited access to the course for forever Digital Certificate, Transcript, student ID all included in the price Absolutely no hidden fees Directly receive CPD accredited qualifications after course completion Receive one to one assistance on every weekday from professionals Immediately receive the PDF certificate after passing Receive the original copies of your certificate and transcript on the next working day Easily learn the skills and knowledge from the comfort of your home Certification After studying the course materials of the Solar Energy you will be able to take the MCQ test that will assess your knowledge. 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? This Solar Energy course is ideal for Students pursuing degrees in renewable energy, engineering, or related disciplines. Engineers and technicians seeking to enhance their skills in solar energy systems. Professionals in the construction industry interested in integrating solar solutions. Entrepreneurs looking to venture into the solar energy sector. Prerequisites This Solar Energy 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 Solar Installer: £20,000 - £30,000 Solar Energy Technician: £25,000 - £35,000 Solar System Designer: £30,000 - £40,000 Renewable Energy Engineer: £35,000 - £50,000 Solar Energy Consultant: £40,000 - £60,000. Course Curriculum Unit 1- Basics of Solar Energy System Module 1- Introduction To PV System Construction 00:24:00 Module 2- Solar Heating, Solar Irradiation And Panels 00:38:00 Module 3- Effect of Insolation and Temperature on V-I Curve 00:05:00 Module 4- PV Installation, Short Circuit And Open Circuit Tests Using Avometer 00:15:00 Module 5- Solar Wires And Cables Installation Process 00:22:00 Module 6- Mounting Of PV System 00:04:00 Module 7- Shading and Tilt angle In Solar Energy 00:15:00 Module 8- Half Cut Cell Technology In PV System For Solar Engineering 00:25:00 Module 9- Importance Of Charge Controller In Solar Energy System 00:03:00 Module 10- PWM And MPPT Charge Controllers 00:14:00 Module 11- Understanding More about MPPT Solar Charge Controller For Solar Energy Course 00:24:00 Module 12- Junction Box In Solar Energy System 00:04:00 Module 13- Wiring of Junction Box In Solar Energy System 00:05:00 Module 14- Function, Types And Data Sheet Of Inverter 00:55:00 Module 15- Determining PV Array Maximum System Voltage 00:09:00 Unit 2- Batteries in PV System Module 1- Construction And Types Of Batteries In Solar Energy System 00:09:00 Module 2- Charging Of Lead Acid Batteries And Hydrometer In Solar Energy System 00:07:00 Module 3- Maintenance Of Batteries And Methods Of Charging In Solar Energy System 00:03:00 Module 4- Cycle of Batteries 00:04:00 Unit 3- Components and Design of Off Grid Solar Energy System Module 1- Off-Grid Solar System 00:02:00 Module 2- Advantages of Off-Grid Solar System 00:02:00 Module 3- Equipment of Off-Grid Solar System 00:04:00 Module 4- Selection and Datasheet of the Panel 00:04:00 Module 5- Inverter Selection 00:02:00 Module 6- Example 1 On Designing Off Grid System 00:01:00 Module 7- Determine Power Consumption Demands 00:04:00 Module 8- Size the PV modules 00:05:00 Module 9- Inverter sizing 00:04:00 Module 10- Battery Sizing 00:08:00 Module 11- Solar Charge Controller Sizing 00:05:00 Module 12- MPPT Charge Controller Sizing 00:10:00 Module 13- Example 2 Design of an OFF Grid System 00:20:00 Unit 4- Designing of ON Grid Solar Energy System Module 1- Grid-Tied Solar System 00:03:00 Module 2- Advantages of Grid-Tied Solar System 00:04:00 Module 3- Equipment of Grid-Tied Solar System 00:03:00 Module 4- Example Design of an On Grid System 00:10:00 Module 5- PV Energy According to Area 00:02:00 Unit 5- Design of PV System Using PVSyst Programme Module 1- Design of an Off Grid Solar Energy System Using PVSYST Program 00:28:00 Module 2- Design Of An On Grid Solar Energy System Using PVSyst Program 00:12:00 Module 3- Mega PV System Design Using PVSyst Program For Solar Energy 00:29:00 Unit 6- Solar Water Pumping System Module 1- Introduction To Water Pumping System And Steps Of Design 00:24:00 Module 2- Solved Example On Solar Pumping System Design 00:23:00 Unit 7- Protection of PV System Module 1- Introduction to Protection Of PV System 00:07:00 Module 2- Selection of Fuses and Protection of String 00:13:00 Module 3- Protection of Arrays 00:07:00 Module 4- Protection of Inverter 00:07:00 Module 5- Protection of Transformer 00:07:00 Module 6- Surge Protection Device 00:02:00 Module 7- Grounding of PV System 00:07:00 Module 8- Types of BusBars in PV System and Selection of BusBars 00:12:00 Unit 8- Design Using Excel Sheet Module 1-Design Of Off Grid PV System Using Excel Sheet 00:26:00 Unit 9- Single Line Diagram of PV System Module 1- Single Line Diagram Of PV System And Selection Of Fuses And Breakers 00:45:00 Unit 10- MATLAB and ETAP PV Simulation Module 1- Simulation Of PV Cell In MATLAB And Obtaining V-I Characteristics 00:28:00 Module 2- Get a Complete Grid Connected PV Solar Energy System In MATLAB Simulink 00:25:00 Module 3- PV System Simulation Using ETAP Lesson 00:24:00 Assignment Assignment - Solar Energy 00:00:00

Register on the Personal Trainer / Fitness Instructor Training Course today and build the experience, skills and knowledge you need to enhance your professional development and work towards your dream job. Study this course through online learning and take the first steps towards a long-term career. The course consists of a number of easy to digest, in-depth modules, designed to provide you with a detailed, expert level of knowledge. Learn through a mixture of instructional video lessons and online study materials. Receive online tutor support as you study the course, to ensure you are supported every step of the way. Get a certificate as proof of your course completion. The Personal Trainer / Fitness Instructor Training Course course is incredibly great value and allows you to study at your own pace. Access the course modules from any internet-enabled device, including computers, tablets, and smartphones. The course is designed to increase your employability and equip you with everything you need to be a success. Enrol on the now and start learning instantly! What You Get With The Personal Trainer / Fitness Instructor Training Course course Receive a digital certificate upon successful completion of the course Get taught by experienced, professional instructors Study at a time and pace that suits your learning style Get instant feedback on assessments 24/7 help and advice via email or live chat Get full tutor support on weekdays (Monday to Friday) Course Design The course is delivered through our online learning platform, accessible through any internet-connected device. There are no formal deadlines or teaching schedules, meaning you are free to study the course at your own pace. You are taught through a combination of Video lessons Online study materials Certification After the successful completion of the final assessment, you will receive a CPD-accredited certificate of achievement. The PDF certificate is for £9.99, and it will be sent to you immediately after through e-mail. You can get the hard copy for £15.99, which will reach your doorsteps by post. Who Is This Course For: The course is ideal for those who already work in this sector or are aspiring professionals. This 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 online training is open to all students and has no formal entry requirements. To study the Personal Trainer / Fitness Instructor Training Course course, all you need is a passion for learning, A good understanding of English, numeracy, and IT skills. You must also be over the age of 16. Course Content Introduction Introduction 00:01:00 Roles & Responsibilities Of A Strength Coach 00:02:00 The Major Muscle Groups Explained Most Important Muscle Groups Overview 00:04:00 The Different Types Of Muscle Fibers 00:03:00 Muscle Agonists & Antagonists 00:02:00 Quadriceps Explained 00:01:00 Hamstrings explained 00:01:00 Calf Muscles Explained 00:01:00 Chest Muscles Explained 00:01:00 Back Muscles Explained 00:02:00 Shoulder Muscles Explained 00:01:00 Biceps Explained 00:01:00 Triceps Explained 00:01:00 Abdominal Muscles Explained 00:01:00 Muscle Growth Fundamentals Common Muscle Growth Myths Debunked 00:04:00 Muscle Hypertrophy Explained 00:04:00 Progressive Overload 00:03:00 How Much Muscle Can You Gain in A Week/Month/Year 00:03:00 Client Assessment Client Interview 00:02:00 Estimating 1 Rep Maximum Strength 00:04:00 Workout Design Workout Design Overview 00:01:00 Adherence 00:04:00 The 4 Most Important Exercises For Beginners 00:03:00 How Many Isolation Exercises Should You Do? 00:02:00 Exercise Order 00:01:00 Volume: How Many Sets & Reps? 00:02:00 Intensity: How Heavy Should You Train? 00:02:00 How Often Should You Train? 00:02:00 The Ideal Rest Periods 00:03:00 Time Under Tension Explained 00:02:00 Sample Workouts Sample Workouts Intro 00:01:00 How to Design a Beginner Workout 00:09:00 How To Warm Up Before Lifting Weights 00:03:00 3 Day Beginner Routine 00:06:00 4 Day Routine 00:04:00 5 Day Routine 00:02:00 Exercise Videos Exercise Videos Overview 00:01:00 5 Most Important Aspects Of Correct Lifting Form 00:03:00 Bench Press 00:01:00 Chest Press Machine 00:01:00 Squats 00:01:00 Deadlift 00:01:00 Overhead Press 00:01:00 Dumbbell Overhead Press 00:01:00 Lat Pulldown 00:01:00 Dips 00:01:00 Barbell Row 00:01:00 Barbell Row (Different Grip) 00:01:00 Cable Row 00:01:00 Iso Row Machine 00:01:00 Exercise Videos: Isolation Exercises Hammer Curls 00:01:00 Triceps Rope Pushdown 00:01:00 Calf Raise 00:01:00 Shoulder Front Raise 00:01:00 Shoulder Side Raise 00:01:00 Butterfly / Pec Deck 00:01:00 Dumbbell Flyes 00:01:00 Military Press 00:01:00 Pull-Up 00:01:00 Hammer Rope Curls 00:01:00 Triceps Extensions 00:01:00 Setting Up A Bodybuilding Diet Nutrition Overview 00:01:00 Calories Explained 00:04:00 How to determine your calorie maintenance level (TDEE) 00:03:00 Ideal Protein Intake 00:01:00 Ideal Carb Intake 00:02:00 Ideal Fat Intake 00:01:00 What about the remaining calories 00:02:00 Determining Meal Structure 00:03:00 Quality Protein Foods 00:01:00 Quality Carb Foods 00:01:00 Quality Fat Foods 00:01:00 Adjusting Your Diet For Muscle Gains 00:04:00 Adjusting Your Diet For Weight Loss 00:05:00 The Perfect Pre Workout Meal 00:04:00 The Perfect Post Workout Meal 00:01:00 Supplements Supplements Overview 00:01:00 Top 3 Beginner Supplements 00:04:00 How To Use Protein Powder 00:06:00 How To Use Creatine 00:04:00 Beta Alanine 00:02:00 BCAAs 00:04:00 Rest & Recovery Recovery Overview 00:02:00 Post Workout Recovery Routine 00:04:00 How To Break Through A Strength Plateau 00:06:00 How To Deload Correctly 00:04:00 The importance of sleep 00:04:00 6 Tips To Fall Asleep Faster 00:03:00 FAQ & Misceallenaous Should Men & Women Train Differently? 00:03:00 What Should You Eat Before Bed To Build Muscle? 00:03:00 Does Electric Muscle Stimulation (EMS) Work? 00:02:00 What Should You Train On Your First Day At The Gym? 00:07:00 Exercise Files Exercise Files 00:00: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.

Mechanic Training Bundle course teaches you everything on the Mechanic Training Bundle topic thoroughly from scratch so you can achieve a certificate for free to showcase your achievement in professional life. This Mechanic Training Bundle course is a comprehensive course designed to provide a detailed understanding of the nature of the Mechanic Training Bundle related sector and your key roles within it. The training materials of this Mechanic Training Bundle course are available online for you to learn at your own pace and fast-track your career with ease. Key Features of Mechanic Training Bundle CPD Accredited Mechanic Training Bundle Course Instant PDF certificate Fully online, interactive Mechanic Training Bundlecourse Self-paced learning and laptop, tablet, smartphone-friendly 24/7 Learning Assistance Discounts on bulk purchases Enrol now in this Mechanic Training Bundle course to excel! To become successful in your profession, you must have a specific set of Mechanic Training Bundle skills to succeed in today's competitive world. In this in-depth Mechanic Training Bundletraining course, you will develop the most in-demand Mechanic Training Bundle skills to kickstart your career, as well as upgrade your existing knowledge & skills. Mechanic Training Bundle Curriculum Course 01: Mechanic Training Course 02: Mechanical Engineering Course 03: HGV Training Accreditation This Mechanic Training Bundle courses are CPD accredited, providing you with up-to-date skills and knowledge and helping you to become more competent and effective in your chosen field. Certification Once you've successfully completed your Mechanic Training Bundle course, you will immediately be sent a digital certificate. Also, you can have your printed certificate delivered by post (shipping cost £3.99). CPD 25 CPD hours / points Accredited by CPD Quality Standards Who is this course for? This course is ideal for all employees or anyone who genuinely wishes to learn more about Mechanic Training Bundle basics. Requirements No prior degree or experience is required to enrol in this course. Career path This Mechanic Training Bundle Course will help you to explore avariety of career paths in the related industry. Certificates Digital certificate Digital certificate - Included Hardcopy Certificate Hard copy certificate - Included Hardcopy Certificate (UK Delivery): For those who wish to have a physical token of their achievement, we offer a high-quality, printed certificate. This hardcopy certificate is also provided free of charge. However, please note that delivery fees apply. If your shipping address is within the United Kingdom, the delivery fee will be only £3.99. Hardcopy Certificate (International Delivery): For all international addresses outside of the United Kingdom, the delivery fee for a hardcopy certificate will be only £10.

Building Surveying Training: Building Surveying Course Online Would you like to begin acquiring valuable knowledge that will help you differentiate yourself from your rivals? If so, then our special building surveying course could be your perfect choice! This building surveying course covers construction technology, building pathology, regulations, and inspection. Also, the building surveying course includes maintenance, heritage conservation, BIM, and health and safety. Moreover, the building surveying course describes professional ethics, project management, sustainability, and communication. Students in this building surveying course gain skills in defect recognition, risk evaluation, maintenance planning, and client communication. What are you waiting for, then? Enrol in this building surveying course on building surveys right away. Special Offers of this Building Surveying: Building Surveying Course: This Building Surveying: Building Surveying Course includes a FREE PDF Certificate. Lifetime access to this Building Surveying: Building Surveying Course Instant access to this Building Surveying: Building Surveying Course 24/7 Support Available to this Building Surveying: Building Surveying Course Main Course: Building Surveying Course [ Note: Free PDF certificate as soon as completing Building Surveying Training: Building Surveying Course] Building Surveying Training: Building Surveying Course Online This Building Surveying Training: Building Surveying Course consists of 09 modules. Unlock your potential with our Building Surveying course! Dive deep into Building Surveying principles, practices, and techniques. Master Building Surveying skills that set you apart in the industry. Our Building Surveying course offers hands-on experience and expert guidance in Building Surveying, preparing you for a successful career in Building Surveying. Enroll today! Who is this course for? Building Surveying Training: Building Surveying Course Online Anyone interested in earning a diploma in this field can take this building surveying course. Requirements Building Surveying Training: Building Surveying Course Online To enrol in this Building Surveying Training: Building Surveying Course, students must fulfil the following requirements: Building Surveying: Good Command over English language is mandatory to enrol in our Building Surveying Course. Building Surveying: Be energetic and self-motivated to complete our Building Surveying Course. Building Surveying: Basic computer Skill is required to complete our Building Surveying Course. Building Surveying: If you want to enrol in our Building Surveying Course, you must be at least 15 years old. Career path Building Surveying Training: Building Surveying Course Online This building surveying course provides an exceptional chance to grow professionally and acquire useful skills.

Duration 4 Days 24 CPD hours This course is intended for Experienced system administrators, system engineers, and system integrators Overview By the end of the course, you should be able to meet the following objectives: Describe the architecture of VMware Cloud on AWS Prepare and deploy VMware Cloud on AWS SDDC Configure the scale-up and scale-down of a VMware Cloud on AWS SDDC Access a VMware vCenter configuration in VMware Cloud on AWS Configure internal, external, and inter-SDDC networking Configure storage integrations and solutions for VMware Cloud on AWS Configure a connection between an on-premises vSphere SDDC and a VMware Cloud on AWS SDDC Migrate VMs between on-premises vSphere and VMware Cloud on AWS SDDCs Describe lifecycle management, troubleshooting scenarios, and disaster recovery solutions for a VMware Cloud on AWS SDDC Describe how VMware add-on solutions support a VMware Cloud on AWS SDDC This four-day, hands-on training course provides you with the knowledge, skills, and tools for deploying and managing a VMware Cloud? on AWS infrastructure. You will explore the common use cases of the VMware Cloud on AWS infrastructure that allows you to modernize, protect, and scale applications based on VMware vSphere© that leverage AWS.In this course, you are introduced to various rapid and easy migration options for workloads based on vSphere to VMware Cloud on AWS. In addition, you are presented with VMware Cloud Disaster Recovery?, which is a Disaster Recovery as-a-service (DRaaS) solution, with fast recovery capabilities, that can be used to cost-effectively protect a broad set of your virtualized applications. Course Introduction Introductions and course logistics Course objectives Introduction to VMware Cloud on AWS Choosing VMware Cloud on AWS Management and operational structure VMware Cloud on AWS Platform and SDDC Deployment Preparation Getting started with VMware Cloud on AWS Preparing AWS infrastructure for a VMware Cloud on AWS deployment Setting up a VMware on Cloud AWS account Billing and pricing on VMware Cloud services Deploying and Scaling and SDDC Deploying and examining SDDC configurations Sizing the SDDC SDDC cluster management SDDC host management Optimizing and maintaining SDDC Cluster using Elastic DRS for VMware Cloud on AWS Accessing and Analyzing vCenter Configurations Accessing vCenter Server in the Cloud SDDC Analyzing resource management settings in the SDDC Exploring vSphere permissions on VMware Cloud on AWS VMware Tanzu? for VMC on AWS Networking in VMware Cloud on AWS Internal SDDC network Networking and security options SDDC Network Administration with NSX Manager Creating virtual machines in the Cloud SDDC Inter-SDDC networking Storage on VMware Cloud on AWS vSAN storage in VMware Cloud on AWS Attaching external storage to a VM running on an SDDC Working with On-Premises vSphere Hybrid-linked mode Migration solutions for VMware Cloud on AWS VM migration with VMware HCX© Maintaining and Troubleshooting VMware Cloud on AWS Accessing API with VMware Cloud on AWS Maintenance and support Common troubleshooting steps Disaster Recovery Solution Site Recovery add-on service VMware Cloud Disaster Recovery? Using Other VMware Products with the SDDC VMware Aria? Operations for Logs (formerly vRealize Log Insight) VMware Horizon© with VMware Cloud on AWS VMware Aria Automation add-on (formerly vRealize Automation) Using VMware Aria Operations with VMware Cloud on AWS Using VMware Aria Operations for Networks (formerly vRealize Network Insight) with VMware Cloud on AWS Additional course details:Notes Delivery by TDSynex, Exit Certified and New Horizons an VMware Authorised Training Centre (VATC) Nexus Humans VMware Cloud on AWS: Design, Configure, Manage 2023 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 VMware Cloud on AWS: Design, Configure, Manage 2023 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.

In the modern business landscape, effective facilities management is the cornerstone of smooth operations and enhanced productivity. This course offers a structured approach to mastering the essential elements that keep buildings and their systems running efficiently. It covers everything from maintenance and safety standards to managing energy usage and ensuring the overall functionality of physical spaces. Facilities managers play a vital role in creating environments that support an organisation’s objectives, and this course will equip you with the insights to understand those responsibilities with clarity and confidence. Throughout the course, you will explore key concepts in facilities management, including sustainability, risk assessment, and space planning, all designed to keep organisational infrastructure running without a hitch. By engaging with the material, you’ll gain a solid grasp of the systems that help organisations deliver on their objectives and maintain a safe, functional, and cost-effective environment. Whether you are seeking to enter the field or improve your existing knowledge, this course is an essential resource for anyone looking to understand the backbone of efficient facility management. Key Features of Facilities Management Bundle CPD Accredited Course Instant PDF certificate Fully online, interactive course Self-paced learning and laptop, tablet, smartphone-friendly 24/7 Learning Assistance Discounts on bulk purchases To become successful in your profession, you must have a specific set of Facilities Management skills to succeed in today's competitive world. In this in-depth Facilities Management training course, you will develop the most in-demand skills to kickstart your career, as well as upgrade your existing knowledge & skills. Facilities Management Curriculum Course 01: Facilities Management Diploma Course 02: Change Management Course 03: Strategic Planning and Implementation Skills Course 04: Leadership and People Management Diploma Course 05: Administrative Assistant and Organizational Skills Course 06: Compliance and Risk Management Course 07: Six Sigma Course 08: Operations Management Course 09: Line Management Course 10: Risk Management Course 11: Communication Skills Course 12: Public Relations Course 13: KYC: Customer Service Agent Course 14: Equality, Diversity and Discrimination Course 15: Cross-Cultural Awareness Training Course 16: Corporate Risk And Crisis Management Course 17: Performance Management Course 18: Time Management in The Workplace Course 19: Team Management Course 20: Positive Psychology Accreditation This bundle courses are CPD accredited, providing you with up-to-date skills and knowledge and helping you to become more competent and effective in your chosen field. 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 200 CPD hours / points Accredited by CPD Quality Standards Who is this course for? This course is ideal for all employees or anyone who genuinely wishes to learn more about Facilities Management basics. Requirements No prior degree or experience is required to enrol in this course. Career path This Facilities Management Course will help you to explore avariety of career paths in the related industry. Certificates Digital certificate Digital certificate - Included Hardcopy Certificate Hard copy certificate - Included Hardcopy Certificate (UK Delivery): For those who wish to have a physical token of their achievement, we offer a high-quality, printed certificate. This hardcopy certificate is also provided free of charge. However, please note that delivery fees apply. If your shipping address is within the United Kingdom, the delivery fee will be only £3.99. Hardcopy Certificate (International Delivery): For all international addresses outside of the United Kingdom, the delivery fee for a hardcopy certificate will be only £10.

Duration 5 Days 30 CPD hours This course is intended for This course is intended for individuals who are Application designers and database developers, database administrators and web server administrators. Overview Upon successful completion of this course, students will be able to work with Oracle database programming using the PL/SQL programming language. They will learn the syntax, structure and features of the language. In this course, students will learn the foundation for the programming series and the use of database-resident stored program units for Oracle 12c. Selection & Setup of the Database Interface Considering Available Tools Selecting the Appropriate Tool Oracle Net Database Connections Oracle PAAS Database Connections Setup SQL Developer Setup SQL*Plus Setup Jdeveloper About Bind & Substitution Variables Using SQL Developer Using SQL*Plus Choosing a Database Programming Language What is Database Programming? PL?SQL Performance Advantages Integration wth Other Languages PL/SQL Language Fundamentals PL/SQL Program Structure LANGUAGE SYNTAX RULES EMBEDDING SQL WRITING READABLE CODE GENERATING DATABASE OUTPUT SQL*PLUS INPUT OF A PROGRAM BLOCK Declare Section About the Declare Section DECLARE PRIMITIVE TYPES DECLARATION OPTIONS NOT NULL CONSTANT DATA DICTIONARY INTEGRATION %TYPE DECLARE SIMPLE USER---DEFINED TYPES TYPE... TABLE TYPE... RECORD EXTENDED USER---DEFINED TYPES Begin Section About the Begin Section Manipulating Program Data Logic Control & Branching GOTO LOOP IF-THEN-ELSE CASE Exception Section ABOUT THE EXCEPTION SECTION ISOLATING THE SPECIFIC EXCEPTION PRAGMA EXCEPTION_INIT SQLCODE &SQLERRM Example SQL%ROWCOUNT &SELECT...INTO Beyond the Basics: Explicit Cursors ABOUT EXPLICIT CURSORS EXTENDED CURSOR TECHNIQUES FOR UPDATE OF Clause WHERE CURRENT OF Clause Using FOR?LOOP Cursors Beyond the Basics: Nested BlocksBeyond the Basics: Declared Subprograms USING DECLARED SUBPROGRAMS DECLARED PROCEDURE DECLARED FUNCTION Introducing Databse-Resident Program Units ABOUT DATABASE---RESIDENT PROGRAMS PHYSICAL STORAGE & EXECUTION TYPES OF STORED PROGRAM UNITS STORED PROGRAM UNIT ADVANTAGES MODULAR DESIGN PRINCIPLES Creating Stored Procedures & Functions STORED PROCEDURES & FUNCTIONS CREATE PROCEDURE / CREATE FUNCTION CREATING PROCEDURES & FUNCTIONS RAISE_SALARY() Procedure SALARY_VALID() Function THE PARAMETER SPECIFICATION DEFAULT Clause SYSTEM & OBJECT PRIVILEGES USING THE DEVELOPMENT TOOLS Executing Stored Procedures & Functions CALLING PROCEDURES & FUNCTIONS UNIT TESTING WITH EXECUTE ANONYMOUS BLOCK UNIT TESTING SPECIFYING A PARAMETER NOTATION SQL WORKSHEET UNIT TESTING CALLING FUNCTIONS FROM SQL Maintaining Stored Program Units RECOMPILING PROGRAMS Mass Recompilation Using UTL_RECOMP() DROPPING PROCEDURES & FUNCTIONS DROP PROCEDURE / FUNCTION DATA DICTIONARY METADATA Using USER_OBJECTS Using USER_SOURCE Using USER_ERRORS Using USER_OBJECT_SIZE Using USER_DEPENDENCIES Managing Dependencies DEPENDENCY INTERNALS TRACKING DEPENDENCIES THE DEPENDENCY TRACKING UTILITY SQL DEVELOPER DEPENDENCY INFO DEPENDENCY STRATEGY CHECKLISTS Creating & Maintaining Packages ABOUT PACKAGES CREATING PACKAGES MAINTAINING PACKAGES PERFORMANCE CONSIDERATIONS Advanced Package Capabilities DEFINER & INVOKER RIGHTS WHITE LITS & ACCESSIBLE BY PERSISTENT GLOBAL OBJECTS DEFINING INITIALIZATION LOGIC OBJECT ORIENTATION SUPPORT Advanced Cursor Techniques USING CUSROS VARIABLES USING SYS_REFCURSOR USING CURSOR EXPRESSIONS Using System-Supplied Package DBMS_OUTPUT() UTL_FILE() FOPEN() EXAMPLE Database Trigger Concepts ABOUT DATABASE TRIGGERS DML EVENT TRIGGER SUB---TYPES DATABASE TRIGGER SCENARIO TRIGGER EXECUTION MECHANISMS TRIGGERS WITHIN SQL WORKSHEET Creating Database Triggers STATEMENT-LEVEL TRIGGERS Using RAISE_APPLICATION_ERROR() ROW---LEVEL TRIGGERS EXAMPLES OF TRIGGERS EMPLOYEE_SALARY_CHECK Example EMPLOYEE_JOURNAL Example BUDGET_EVENT Example INSTEAD OF TRIGGERS TRIGGERS WITHIN AN APPLICATION Maintaining Database Triggers CALL SYNTAX TRIGGER MAINTENANCE TASKS SHOW ERRORS TRIGGER DROP TRIGGER ALTER TRIGGER MULTIPLE TRIGGERS FOR A TABLE HANDLING MUTATING TABLE ISSUES Implementing System Event Triggers WHAT ARE SYSTEM EVENT TRIGGERS? DEFININGTHE SCOPE AVAILABLE SYSTEM EVENTS SYSTEM EVENT ATTRIBUTES Additional course details: Nexus Humans Oracle 12c PL/SQL Fundamentals training program is a workshop that presents an invigorating mix of sessions, lessons, and masterclasses meticulously crafted to propel your learning expedition forward. This immersive bootcamp-style experience boasts interactive lectures, hands-on labs, and collaborative hackathons, all strategically designed to fortify fundamental concepts. Guided by seasoned coaches, each session offers priceless insights and practical skills crucial for honing your expertise. Whether you're stepping into the realm of professional skills or a seasoned professional, this comprehensive course ensures you're equipped with the knowledge and prowess necessary for success. While we feel this is the best course for the Oracle 12c PL/SQL Fundamentals course and one of our Top 10 we encourage you to read the course outline to make sure it is the right content for you. Additionally, private sessions, closed classes or dedicated events are available both live online and at our training centres in Dublin and London, as well as at your offices anywhere in the UK, Ireland or across EMEA.

SQL programming is the programming that manages data in the Relational Database Management System. The Mastering SQL Programming course aims to teach you how to optimise the accessibility and maintenance of data with the Structured Query Language SQL programming language, and gain a solid foundation for building, querying, and manipulating databases. This SQL Programming course will provide you the standard language, but also identifies deviations from the standard in two widely-used database products, Oracle and Microsoft SQL Server. You will understand SQL functions, join techniques, database objects and constraints, and will be able to write useful SELECT, INSERT, UPDATE and DELETE statements. Learn what SQL is and how to create, manipulate, and create reports from database tables from the best SQL courses. Important concepts associated with relational databases will be covered. You will run SQL commands to create database tables and define data element types. Enrol Now to start boosting your SQL skills! Key topics to be covered Stored Procedures Returning Data Testing and Debugging SQL CLR Code Dynamic SQL Column sets Learning Outcomes Know the tools for creating views with examples, columns and indexed views, creating stored procedures, testing and debugging. Learn how to create triggers, execute with result sets, use inline table valued functions, and use the multi statement function. Learn about transaction concepts, explicit transactions, and structured error handling. Understanding of different functions, data tools, database management, comparing database schemas, offline database management and much more. Master partitioning, managing partitions, querying partitions, complex querying, table expressions, efficient queries and complex queries. Why Choose this Course Earn a digital Certificate upon successful completion. Accessible, informative modules taught by expert instructors Study in your own time, at your own pace, through your computer tablet or mobile device Benefit from instant feedback through mock exams and multiple-choice assessments Get 24/7 help or advice from our email and live chat teams Full Tutor Support on Weekdays Course Design The course is delivered through our online learning platform, accessible through any internet-connected device. There are no formal deadlines or teaching schedules, meaning you are free to study the course at your own pace. You are taught through a combination of- Video lessons Online study supplies Mock tests Multiple-choice evaluation Assignment Certificate of Achievement Endorsed Certificate of Achievement from the Quality Licence Scheme Once the course has been completed and the assessment has been passed, all students are entitled to receive an endorsed certificate. This will provide proof that you have completed your training objectives, and each endorsed certificate can be ordered and delivered to your address for only £119. Please note that overseas students may be charged an additional £10 for postage. CPD Certificate of Achievement from Janets Upon successful completion of the course, you will be able to obtain your course completion e-certificate. Print copy by post is also available at an additional cost of £9.99 and PDF Certificate at £4.99. Endorsement This course and/or training programme has been endorsed by the Quality Licence Scheme for its high-quality, non-regulated provision and training programmes. This course and/or training programme is not regulated by Ofqual and is not an accredited qualification. Your training provider will be able to advise you on any further recognition, for example progression routes into further and/or higher education. For further information please visit the Learner FAQs on the Quality Licence Scheme website. Method of Assessment To successfully complete the 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 course. After successfully passing the exam, you will be able to apply for Quality Licence Scheme endorsed certificate of achievement. To verify your enhanced skills in the subject, we recommend that you also complete the assignment questions. These can be completed at any time which is convenient for yourself and will be assessed by our in-house specialised tutors. Full feedback will then be given on your current performance, along with any further advice or support. Who is this course for? Anyone who wants to gain extensive knowledge, potential experience and expert skills in SQL programming. Those who have an interest in production planning. Students from any academic backgrounds

Level 7 QLS Endorsed Diploma | 180 CPD Points | +Gifts: QLS Certificate + PDF Certificate | 24/7 Learner Support

Building Surveying: Building Surveying Would you like to begin acquiring valuable knowledge that will help you differentiate yourself from your rivals? If so, then our special building surveying course could be your perfect choice! This building surveying course covers construction technology, building pathology, regulations, and inspection. Also, the building surveying: building surveying course includes maintenance, heritage conservation, BIM, and health and safety. Moreover, the building surveying: building surveying course describes professional ethics, project management, sustainability, and communication. Students in this building surveying: building surveying course gain skills in defect recognition, risk evaluation, maintenance planning, and client communication. What are you waiting for, then? Enrol in this building surveying course on building surveys right away. Main Course: Building Surveying course Free Course Included Building Surveying: Building Surveying Course Course 01: Construction Management Course 02: Construction Site Management Special Offers of this Building Surveying: Building Surveying Course: This Building Surveying: Building Surveying Course includes a FREE PDF Certificate. Lifetime access to this Building Surveying: Building Surveying Course Instant access to this Building Surveying: Building Surveying Course 24/7 Support Available to this Building Surveying: Building Surveying Course [Note: Free PDF certificate as soon as completing the Building Surveying: Building Surveying Course] Building Surveying: Building Surveying If you want to learn more about the exciting topic of building surveys, sign up for our course. Discover the principles, methods, and best practices of building surveying: building surveying from professionals in the field. Gain knowledge about building surveying: building surveying rules and procedures. Get started now on the path to a fulfilling career in building surveying: building surveying! Certificate of Completion You will receive a course completion certificate for free as soon as you complete the Building Surveying: Building Surveying Course. Who is this course for? Building Surveying: Building Surveying Anyone interested in earning a diploma in this field can take this building surveying: building surveying course. Requirements Building Surveying: Building Surveying To enrol in this Building Surveying: Building Surveying Course, students must fulfil the following requirements: Good Command over English language is mandatory to enrol in our Building Surveying: Building Surveying Course. Be energetic and self-motivated to complete our Building Surveying: Building Surveying Course. Basic computer Skill is required to complete our Building Surveying: Building Surveying Course. If you want to enrol in our Building Surveying: Building Surveying Course, you must be at least 15 years old. Career path Building Surveying: Building Surveying This building surveying: building surveying course provides an exceptional chance to grow professionally and acquire useful skills.