Duration 3 Days 18 CPD hours This course is intended for This is an introductory level SQL course, appropriate for anyone needing to interface with an Oracle database or those needing a general understanding of Oracle database functionality. That would include end users, business analysts, application developers and database administrators. Overview Working in a hands on learning environment led by our expert practitioner, attendees will explore: Basic RDBMS Principles The SQL Language and Tools Using SQL Developer SQL Query Basics WHERE and ORDER BY Functions ANSI 92 Joins ANSI 99 Joins Subqueries Regular Expressions Analytics A company?s success hinges on responsible, accurate database management. Organizations rely on highly available data to complete all sorts of tasks, from creating marketing reports and invoicing customers to setting financial goals. Data professionals like analysts, developers and architects are tasked with creating, optimizing, managing and analyzing data from databases ? with little room for error. When databases aren?t built or maintained correctly, it?s easy to mishandle or lose valuable data. Our SQL Programming and Database Training Series provides students with the skills they require to develop, analyze and maintain data and in correctly structured, modern and secure databases. A full presentation of the basics of relational databases and their use are also covered. Basic RDBMS Principles Relational design principles Accessing data through a structured query language Entity relationship diagrams Data Domains Null values Indexes Views Denormalization Data Model Review The SQL Language and Tools Using SQL*Plus Why Use SQL*Plus When Other Tools Are Available? Starting SQL*Plus EZConnect SQL Commands PL/SQL Commands SQL*Plus Commands The COLUMN Command The HEADING Clause The FORMAT Clause The NOPRINT Clause The NULL Clause The CLEAR Clause Predefined define variables LOGIN.SQL Command history Copy and paste in SQL*Plus Entering SQL commands Entering PL/SQL commands Entering SQL*Plus commands Default output from SQL*Plus Entering Queries What about PL/SQL? Using SQL Developer Choosing a SQL Developer version Configuring connections Creating A Basic Connection Creating A TNS Connection Connecting Configuring preferences Using SQL Developer The Columns Tab The Data Tab The Constraints Tab The Grants Tab The Statistics Tab Other Tabs Queries In SQL Developer Query Builder Accessing Objects Owned By Other Users The Actions Pulldown Menu Differences between SQL Developer and SQL*Plus Reporting Commands Missing In SQL Developer General Commands Missing In SQL Developer Data Dictionary report User Defined reports Using scripts in SQL Developer WHERE and ORDER BY WHERE clause basics Comparison operators Literals and Constants in SQL Simple pattern matching Logical operations The DUAL table Arithmetic operations Expressions in SQL Character operators Pseudo columns Order by clause basics Ordering Nulls Accent and case sensitive sorts Sampling data WHERE and ORDER BY in SQL Developer All, Any, Some Functions The basics of Oracle functions Number functions Character functions Date functions Conversion functions Other functions Large object functions Error functions The RR format mode; Leveraging your knowledge ANSI 92 JOINS Basics of ANSI 92 Joins Using Query Builder with multiple tables Table Aliases Outer joins Outer Joins In Query Builder Set operators Self-referential joins Non-Equijoins ANSI 99 Joins Changes with ANSI99 CROSS Join NATURAL Join JOIN USING JOIN ON LEFT / RIGHT OUTER JOIN FULL OUTER JOIN Subqueries Why use subqueries? WHERE clause subqueries FROM clause subqueries HAVING clause subqueries CORRELATED subqueries SCALAR subqueries DML and subqueries EXISTS subqueries Hierarchical queries TOP N AND BOTTOM N queries Creating subqueries using Query Builder Regular Expressions Available Regular Expressions Regular Expression Operators Character Classes Pattern matching options REGEX_LIKE REGEXP_SUBSTR REGEXP_INSTR REGEXP_REPLACE REGEXP_COUNT Analytics The WITH clause Reporting aggregate functions Analytical functions User-Defined bucket histograms The MODEL clause PIVOT and UNPIVOT Temporal validity More Analytics RANKING functions RANK DENSE_RANK CUME_DIST PERCENT_RANK ROW_NUMBER Windowing aggregate functions RATIO_TO_REPORT LAG / LEAD Linear Regression functions Inverse Percentile functions Hypothetical ranking functions Pattern Matching Additional course details: Nexus Humans Introduction to SQL Programming Basics (TTSQL002) 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 Introduction to SQL Programming Basics (TTSQL002) course and one of our Top 10 we encourage you to read the course outline to make sure it is the right content for you. Additionally, private sessions, closed classes or dedicated events are available both live online and at our training centres in Dublin and London, as well as at your offices anywhere in the UK, Ireland or across EMEA.
Duration 2 Days 12 CPD hours Overview What's New in This Guide? Automatic Payment Reminders for open customer invoices Ability to automatically include the PO# (purchase order number) to Invoice Emails Able to combine multiple emails which allows you to attach multiple sales or purchasing documents to a single email Quickly locate a company file using the new company file search feature Smart Help is an improved search experience that includes access to live experts through messaging and call back options This course covers all features that are in QuickBooks Pro and Premier 2020 and prepares you for the QuickBooks Certified User exam. This course combines all topics in the two 1 day courses ?Get Started with QuickBooks 2021 for Windows? and ?Keep Going with QuickBooks 2021 for Windows?. First-time QuickBooks users will learn the basic features of the software. Experienced QuickBooks users will quickly learn the new features and functionality of QuickBooks 2021. Getting Started Starting QuickBooks Setting QuickBooks Preferences Components of the QuickBooks Operating Environment Using QuickBooks Help Identifying Common Business Terms Exiting QuickBooks Setting Up a Company Creating a QuickBooks Company Using the Chart of Accounts Working with Lists Creating Company Lists Working with the Customers & Jobs List Working with the Employees List Working with the Vendors List Working with the Item List Working with Other Lists Managing Lists Setting Up Inventory Entering Inventory Ordering Inventory Receiving Inventory Paying for Inventory Manually Adjusting Inventory Selling Your Product Creating Product Invoices Applying Credit to Invoices Emailing Invoices Setting Price Levels Creating Sales Receipts Invoicing for Services Setting Up a Service Item Changing the Invoice Format Creating a Service Invoice Editing an Invoice Voiding an Invoice Deleting an Invoice Entering Statement Charges Creating Billing Statements Processing Payments Displaying the Open Invoices Report Using the Income Tracker Receiving Payments for Invoices Making Deposits Handling Bounced Checks Working with Bank Accounts Writing a QuickBooks Check Voiding a QuickBooks Check Using Bank Account Registers Entering a Handwritten Check Transferring Funds Between Accounts Reconciling Checking Accounts Entering and Paying Bills Handling Expenses Using QuickBooks for Accounts Payable Using the Bill Tracker Entering Bills Paying Bills Entering Vendor Credit Memorizing Transactions Entering a New Memorized Transaction Editing a Memorized Transaction Deleting a Memorized Transaction Grouping Memorized Transactions Using a Memorized Transaction Printing the Memorized Transaction List Customizing Forms Creating a Custom Template Modifying a Template Printing Forms Using Other QuickBooks Accounts Other QuickBooks Account Types Working with Credit Card Transactions Working with Fixed Assets Working with Long-Term Liability Accounts Using the Loan Manager Creating Reports Working with QuickReports Working with Preset Reports Sharing Reports Exporting Reports to Microsoft Excel Printing Reports Creating Graphs Creating QuickInsight Graphs Using QuickZoom with Graphs Working with the Sales Graph Customizing Graphs Printing Graphs Tracking and Paying Sales Tax Using Sales Tax in QuickBooks Setting Up Tax Rates and Agencies Indicating Who and What Gets Taxed Applying Tax to Each Sale Determining What You Owe Paying Your Tax Agencies Preparing Payroll with QuickBooks Using Payroll Tracking Setting Up for Payroll Setting Up Employee Payroll Information Setting Up a Payroll Schedule Writing a Payroll Check Printing Paycheck Stubs Tracking Your Tax Liabilities Paying Payroll Taxes Preparing Payroll Tax Forms Using the EasyStep Interview Using the EasyStep Interview Using Online Banking Setting Up an Internet Connection Setting Up Bank Feeds for Accounts Viewing, Downloading, and Adding Online Transactions Creating Online Payments Transferring Funds Online Canceling Online Payments Managing Company Files Using QuickBooks in Multi-user Mode Setting Up Users and Passwords Setting a Closing Date Sharing Files with an Accountant Updating QuickBooks Backing Up and Restoring a Company File Condensing a Company File Estimating, Time Tracking, and Job Costing Creating Job Estimates Creating an Invoice from an Estimate Displaying Reports for Estimates Updating the Job Status Tracking Time Displaying Reports for Time Tracking Tracking Vehicle Mileage Displaying Vehicle Mileage Reports Displaying Other Job Reports Writing Letters Using the Letters and Envelopes Wizard Customizing Letter Templates Additional course details: Nexus Humans Get Smart With QuickBooks 2021 for Windows 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 Get Smart With QuickBooks 2021 for Windows 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.
Overview of Child Playwork Join our Child Playwork course and discover your hidden skills, setting you on a path to success in this area. Get ready to improve your skills and achieve your biggest goals. The Child Playwork course has everything you need to get a great start in this sector. Improving and moving forward is key to getting ahead personally. The Child Playwork course is designed to teach you the important stuff quickly and well, helping you to get off to a great start in the field. So, what are you looking for? Enrol now! Get a quick look at the course content: This Child Playwork Course will help you to learn: Learn strategies to boost your workplace efficiency. Hone your skills to help you advance your career. Acquire a comprehensive understanding of various topics and tips. Learn in-demand skills that are in high demand among UK employers This course covers the topic you must know to stand against the tough competition. The future is truly yours to seize with this Child Playwork. Enrol today and complete the course to achieve a certificate that can change your career forever. Details Perks of Learning with IOMH One-To-One Support from a Dedicated Tutor Throughout Your Course. Study Online - Whenever and Wherever You Want. Instant Digital/ PDF Certificate. 100% Money Back Guarantee. 12 Months Access. Process of Evaluation After studying the course, an MCQ exam or assignment will test your skills and knowledge. You have to get a score of 60% to pass the test and get your certificate. Certificate of Achievement Certificate of Completion - Digital / PDF Certificate After completing the Child Playwork course, you can order your CPD Accredited Digital / PDF Certificate for £5.99. Certificate of Completion - Hard copy Certificate You can get the CPD Accredited Hard Copy Certificate for £12.99. Shipping Charges: Inside the UK: £3.99 International: £10.99 Who Is This Course for? This Child Playwork is suitable for anyone aspiring to start a career in relevant field; even if you are new to this and have no prior knowledge, this course is going to be very easy for you to understand. On the other hand, if you are already working in this sector, this course will be a great source of knowledge for you to improve your existing skills and take them to the next level. This course has been developed with maximum flexibility and accessibility, making it ideal for people who don't have the time to devote to traditional education. Requirements You don't need any educational qualification or experience to enrol in the Child Playwork course. Do note: you must be at least 16 years old to enrol. Any internet-connected device, such as a computer, tablet, or smartphone, can access this online course. Career Path The certification and skills you get from this Child Playwork Course can help you advance your career and gain expertise in several fields, allowing you to apply for high-paying jobs in related sectors. Course Curriculum Module 01: Introduction to Child Playwork Introduction to Child Playwork 00:40:00 Module 02: Playwork Theory, Principles and Practices Playwork Theory, Principles and Practices 01:10:00 Module 03: The Educational and Learning Benefits of Playwork The Education and Learning Benefits of Playwork 00:40:00 Module 04: Play and Playwork in a Health and Well-Being Context Play and Playwork in a Health and Well-Being Context 01:00:00 Module 05: The Economic and Social Benefits of Playwork The Economic and Social Benefits of Playwork 01:00:00 Module 06: The Developmental Benefits of Playwork The Developmental and Behavioural Benefits of Playwork 00:45:00 Module 07: The Negative Results of Play Deprivation The Negative Results of Play Deprivation 00:10:00 Module 08: Inclusive Play and Play Environment Inclusive Play and Challenging Play Environment 00:35:00 Module 09: Designing Play Spaces Designing Play Spaces 01:10:00 Module 10: The Administrative Context of a Playwork Provision The Administrative Context of a Playwork Provision 01:10:00 Module 11: Legislation for Safeguarding Children and Child Playwork Legislation for Safeguarding Children and Child Playwork 00:40:00 Module 12: Reflective Playwork Practice Reflective Playwork Practice 00:40:00 Assignment Assignment - Child Playwork 00:00:00
Learn to build and deploy a RESTful API using ASP.Net Core, Entity framework, and enterprise-grade practices for a scalable as well as future-proofed web API solution along with understanding the folder structure and files. You will also implement various support tools for logging, documentation, security, and error handling.
Overview The CPR/BLS and AED for Dental Nurse/Assistant Course Level 3 provides dental healthcare professionals with essential knowledge and skills in responding to medical emergencies. It covers topics such as anaphylaxis, its treatment and everyday management, basic life support (BLS), cardiopulmonary resuscitation (CPR), the role of an automated external defibrillator (AED), choking, and recovery position and first aid techniques. Learning Outcomes: Understand the nature of anaphylaxis, its triggers, and symptoms, and learn appropriate treatment methods. Acquire the skills necessary to effectively manage anaphylaxis in everyday dental practice, including prevention and emergency response. Develop proficiency in basic life support (BLS) techniques, including chest compressions, rescue breaths, and recognizing signs of cardiac arrest. Gain competence in performing cardiopulmonary resuscitation (CPR) on patients experiencing cardiac arrest. Understand the role and operation of automated external defibrillators (AEDs) and learn how to use them effectively in emergency situations. Learn techniques for managing choking incidents, including both conscious and unconscious patients. Familiarize oneself with the recovery position and other first aid techniques to ensure patient safety and comfort in emergencies. Why buy this CPR/BLS and AED for Dental Nurse / Assistant Course Level 3? 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 CPR/BLS and AED for Dental Nurse / Assistant Course Level 3 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? This CPR/BLS and AED for Dental Nurse / Assistant Course Level 3 course is ideal for Students Recent graduates Job Seekers Anyone interested in this topic People already working in the relevant fields and want to polish their knowledge and skill. Prerequisites This CPR/BLS and AED for Dental Nurse / Assistant Course Level 3 does not require you to have any prior qualifications or experience. You can just enrol and start learning.This CPR/BLS and AED for Dental Nurse / Assistant Course Level 3 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 As this course comes with multiple courses included as bonus, you will be able to pursue multiple occupations. This CPR/BLS and AED for Dental Nurse / Assistant Course Level 3 is a great way for you to gain multiple skills from the comfort of your home. Course Curriculum Module 01: What Is Anaphylaxis? What is Anaphylaxis 00:16:00 Module 02: Treatment for Anaphylaxis Treatment for Anaphylaxis 00:15:00 Module 03: Everyday Management of Anaphylaxis Everyday Management of Anaphylaxis 00:15:00 Module 04: An Introduction to Basic Life Support (BLS) An Introduction to Basic Life Support (BLS) 00:20:00 Module 05: Cardiopulmonary Resuscitation (CPR) Cardiopulmonary Resuscitation (CPR) 00:17:00 Module 06: The Role of an Automated External Defibrillator (AED) The Role of an Automated External Defibrillator (AED) 00:17:00 Module 07: Choking Choking 00:19:00 Module 08: Recovery Position and First Aid Techniques Recovery Position and First Aid Techniques 00:17:00 Assignment Assignment - CPR/BLS and AED for Dental Nurse / Assistant Course Level 3 00:00:00
Overview ' Car mechanic near me ' is one of most searched topics in the UK in recent years. There are 32.7 million passenger cars in the UK. As a result, quality can mechanics are always in high demand. If you are a car enthusiast and currently looking for a secure job, the car maintenance industry can be your call. So, without any delay, start preparing yourself for a thriving career with the Car Mechanic and Repair Training course. This course is designed to teach you how to keep cars in their best shape. Here, you will receive detailed lessons on general maintenance. The course will help you develop a clear understanding of the engine, cooling system, fuel system and much more. In addition, you learn how the brakes work and get introduced to the vehicle warning lights. Along with that, the course will show you how to keep the tyres and wheels functioning smoothly. At the end of the course, you will receive a CPD-accredited certificate, which will help you justify your abilities in this area. So join now and boost your skills! Why Enrol in the Car Mechanic and Repair Training Course? Unlimited access to the course for a lifetime Digital Certificate, Transcript, and student ID are all included in the price Absolutely no hidden fees Directly receive CPD-accredited qualifications after course completion Receive one-to-one assistance 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 The Car Mechanic and Repair Training course includes an assessment through which you will be able to get feedback on your progress. You have to complete a written assignment and submit it during or after completing the course. When you pass the assignment, you can apply for your certificate. The PDF will be sent to you via email for free and the original hard copy will require an additional cost of £8. Who is this Car Mechanic and Repair Training course for? This course is suitable for Individuals interested to learn more about cars Professionals working in the relevant fields and want to enhance their skills Aspiring professional looking for a promising career in the relevant sectors Car owners who want to keep their cars in top shape Prerequisites There are no prerequisites to enrol in this course. Anyone from any background can take the course and start learning immediately. Students can access the course anytime from anywhere they want from PC, laptops, tabs or any other smart device with an internet connection. Career path This course will help you explore career opportunities in the following fields: Trainee Mechanic: £15,000 - £20,000 Per Annum Certified Car Mechanic: £20,000 - £30,000 Per Annum Specialist Mechanic: £25,000 - £40,000 Per Annum MOT Tester: £22,000 - £35,000 Per Annum Automotive Service Manager: £30,000 - £50,000 Per Annum Automotive Engineer: £28,000 - £60,000 Per Annum Course Curriculum Module 01: Introduction to Safety and Maintenance Introduction to Safety and Maintenance 00:12:00 Module 02: General Maintenance for Car Mechanics General Maintenance for Car Mechanics 00:38:00 Module 03: Vehicle Warning Lights Vehicle Warning Lights 00:31:00 Module 04: Tyres and Wheels Tyres and Wheels 00:40:00 Module 05: The Engine The Engine 00:36:00 Module 06: The Cooling System The Cooling System 00:29:00 Module 07: The Fuel System The Fuel System 00:09:00 Module 08: The Electrical System The Electrical System 00:31:00 Module 09: The Drivetrain The Drivetrain 00:33:00 Module 10: The Braking System The Braking System 00:29:00
Embark on a culinary journey like no other with our 'French Cooking Delights: Mastering the Art of French Cuisine' course. Delve into the heart of French gastronomy and let your passion for cooking flourish. Whether you're an aspiring chef or simply a food enthusiast, this course is your gateway to unlocking the secrets of French culinary excellence. Our meticulously crafted curriculum, spanning ten modules, covers everything from the basics of French cooking to advanced techniques, ensuring you become a maestro in the kitchen. Unveil the magic of French breakfasts, craft classic French sauces with finesse, and master the art of preparing delectable appetizers and soups. Elevate your culinary repertoire with exquisite French main dishes and sumptuous desserts. Delight in the world of French cheese and wine pairing, and challenge your skills with advanced cooking methods. Dive into the art of French baking, and explore a variety of fish recipes that will leave your taste buds longing for more. Learning Outcomes Master the foundational principles of French cooking. Create a delightful French breakfast spread. Craft classic French sauces to perfection. Prepare an array of appetizers, soups, and main dishes. Develop expertise in French desserts, cheese, wine, and advanced cooking techniques. Why buy this French Cooking Delights: Mastering the Art of French Cuisine? 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 French Cooking Delights: Mastering the Art of French Cuisine 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 French Cooking Delights: Mastering the Art of French Cuisine for? Aspiring chefs and culinary enthusiasts. Home cooks eager to elevate their skills. Food bloggers and writers seeking culinary knowledge. Professionals in the food and hospitality industry. Anyone with a passion for French cuisine.. Prerequisites This French Cooking Delights: Mastering the Art of French Cuisine does not require you to have any prior qualifications or experience. You can just enrol and start learning.This French Cooking Delights: Mastering the Art of French Cuisine 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 Sous Chef: £25,000 - £35,000 per annum Pastry Chef: £22,000 - £30,000 per annum Food Critic: £25,000 - £45,000 per annum Restaurant Manager: £25,000 - £40,000 per annum Catering and Event Coordinator: £20,000 - £30,000 per annum Food Writer and Blogger: £18,000 - £35,000 per annum Course Curriculum Module 01: Introduction to French Cooking Introduction to French Cooking 00:09:00 Module 02: French Breakfast French Breakfast 00:18:00 Module 03: Classic French Sauces Classic French Sauces 00:12:00 Module 04: French Appetisers and Soups French Appetisers and Soups 00:12:00 Module 05: French Main Dishes French Main Dishes 00:14:00 Module 06: French Desserts French Desserts 00:14:00 Module 07: French Cheese and Wine French Cheese and Wine 00:06:00 Module 08: Advanced French Cooking Advanced French Cooking 00:10:00 Module 09: French Baking French Baking 00:14:00 Module 10: Various Fish Recipes Various Fish Recipes 00:10:00
Level 4, 5 & 7 QLS Endorsed Diploma | QLS Hard Copy Certificate Included | Plus 10 CPD Courses | Lifetime Access
3 QLS Endorsed Diploma | QLS Hard Copy Certificate Included | 10 CPD Courses | Lifetime Access | 24/7 Tutor Support
Are you someone who wants to do home improvements and repairs yourself but you still feel you are lacking? Worry no more! This course will surely help you with your needs. Description: Do you have what it takes to do remodelling yourself at home? Or are you scared that you might mess it up because only professionals can do that? Or are you someone who has an interest in home improvement and can't afford to hire a professional to do the work? If yes, then you should be eager to benefit from this course since it will teach you comprehensive lessons on Home improvements & repairs and how these are done properly. In this course, you will learn the important elements of improving things by yourself at home. You will also be able to know the essential tools which you need and which a professional handyman use. This course will give you important tips for installing a leak-proof shower, bathroom and kitchen remodelling which includes all basic stuff such fixing sinks which are clogged or adding cabinets. Other than that, this course also includes adding a bedroom or replacing doors, TV stand ideas, etc. At the end of this course, you will also be taught how to judge a good contractor if needed. Who is the course for? Beginners who want to help people in their repairs and maintenance concern. People who have the interest to learn how to repair things themselves at home. Entry Requirement: This course is available to all learners, of all academic backgrounds. Learners should be aged 16 or over to undertake the qualification. Good understanding of English language, numeracy and ICT are required to attend this course. Assessment: At the end of the course, you will be required to sit an online multiple-choice test. Your test will be assessed automatically and immediately so that you will instantly know whether you have been successful. Before sitting for your final exam you will have the opportunity to test your proficiency with a mock exam. Certification: After you have successfully passed the test, you will be able to obtain an Accredited Certificate of Achievement. You can however also obtain a Course Completion Certificate following the course completion without sitting for the test. Certificates can be obtained either in hard copy at a cost of £39 or in PDF format at a cost of £24. PDF certificate's turnaround time is 24 hours and for the hardcopy certificate, it is 3-9 working Why choose us? Affordable, engaging & high-quality e-learning study materials; Tutorial videos/materials from the industry leading experts; Study in a user-friendly, advanced online learning platform; Efficient exam systems for the assessment and instant result; The UK & internationally recognised accredited qualification; Access to course content on mobile, tablet or desktop from anywhere anytime; The benefit of career advancement opportunities; 24/7 student support via email. Career Path: This course would be beneficial for the following careers: Handyman Repairs and Maintenance Manager Guidance Counsellors Technicians Mentors. Module 01 Choosing A Contractor 01:00:00 Pollution and Remodeling 00:30:00 Do It Yourself Bathroom Remodeling 00:30:00 Tips for Installing Leak-proof Showers 00:30:00 Do It Yourself Kitchen Remodeling 00:30:00 Installing Kitchen Cabinets 00:30:00 Module 02 Choosing Countertops 00:30:00 Adding A Bedroom 00:30:00 Basement Problems Turned Around 00:30:00 Options for Lighting Your Home 00:30:00 How To Lay Indoor-Outdoor Carpet 00:30:00 Tips for Installing A Tile Floor 00:30:00 Module 03 How To Prepare to Install Moulding 01:00:00 TV Stand Design Ideas 00:30:00 Home Air Conditioning Maintenance Made Easy 01:00:00 How To Diagnose Central Heating Systems 00:30:00 Insulation 00:30:00 Fixing Your Sink 00:30:00 Module 04 Fixing Clogged Pipes and Drains 00:30:00 Replacing Screens 00:30:00 Replacing Doors 01:00:00 Six Tips For Decks Built to Last 00:30:00 Three Steps To Refinish Your Decks 00:30:00 Installing Your Hot Tub 00:30:00 Module 05 Low Hassle Exterior Painting 00:30:00 Low Hassle Roof Repair 00:30:00 Gardens for Profit and Beauty 01:00:00 Judging Construction 00:15:00 Judging Construction - Ground and Walls 00:30:00 Choosing An Alarm System, Hardware AND People 00:30:00 Mock Exam Mock Exam-DIY Home Improvements & Repair 00:20:00 Final Exam Final Exam-DIY Home Improvements & Repair 00:20:00 Certificate and Transcript Order Your Certificates and Transcripts 00:00:00