37277 Courses

Overview This Microsoft Excel Course for Everyone - Complete Excel Course is your passport to spreadsheet mastery.Explore Excel in detail and improve your abilities with practical activities that go beyond boring lectures. Take on spreadsheets like an expert, from data entry to difficult formulas and eye-catching graphics. But the magic doesn't end there! After finishing successfully, you'll not only impress with your proficiency with Excel, but you'll also obtain a respected CPD certification to enhance your CV and make a statement in the job market. Consider it your golden ticket to go up in your job!Enrol right away to see how your confidence and chances rise! Don't wait! How will I get my certificate? You may have to take a quiz or a written test online during or after the course. After successfully completing the course, you will be eligible for the certificate. Who is This course for? There is no experience or previous qualifications required for enrolment on this Microsoft Excel Course for Everyone - Complete Excel Course. It is available to all students, of all academic backgrounds. Requirements Compatible with a wide range of gadgets, including smartphones, tablets, laptops, Macs, and PCs. Particularly designed to be easily accessed with an internet connection on tablets and smartphones. No strict deadlines; learn whenever it's convenient for you. Individuals with basic English proficiency. Career Path After completing this course, it will increase the value of your CV and open you up to multiple sectors, such as : Data Analyst: £25,000 - £50,000 per year Financial Analyst: £30,000 - £60,000 per year Operations Manager: £35,000 - £70,000 per year Accountant: £25,000 - £50,000 per year Business Intelligence Analyst: £35,000 - £65,000 per year These salary ranges can vary based on factors such as experience, location, and the specific industry of the business. Course Curriculum 15 sections • 80 lectures • 06:51:00 total length •Introduction: 00:03:00 •Course Curriculum: 00:04:00 •Getting started on Windows, macOS, Android, and IOS: 00:01:00 •How to ask great questions: 00:02:00 •FAQ's: 00:01:00 •Starting Excel: 00:04:00 •Introduction: 00:02:00 •Worksheet basics: 00:22:00 •Entering values and formulas: 00:12:00 •Data formats: 00:10:00 •Data handling basics - cut copy and paste: 00:07:00 •Save and print in excel: 00:10:00 •Excel Ranges: 00:05:00 •Introduction: 00:01:00 •Basic formula operations: 00:06:00 •Mathematical functions level 1: 00:20:00 •Mathematical functions level 2: 00:12:00 •Text functions level 1: 00:09:00 •Text functions level 2: 00:13:00 •Logical functions: 00:11:00 •Date time functions: 00:06:00 •V Lookup formula: 00:12:00 •HLookup formula: 00:04:00 •HLookup + Match formula: 00:09:00 •Match + Index formula: 00:05:00 •Introduction: 00:02:00 •XLookup: 00:08:00 •Handling #NA and Approximates match in XLookup: 00:11:00 •Wildcard matching in XLookup: 00:06:00 •Introduction: 00:02:00 •Split text into columns: 00:07:00 •Flash Fill: 00:07:00 •Remove Duplicates: 00:08:00 •Data Validation: 00:07:00 •Get- import Data from Text: 00:06:00 •Get - import Data from CSV: 00:03:00 •Introduction: 00:01:00 •Formatting Font: 00:04:00 •Formatting Alignment: 00:06:00 •Formatting Number: 00:05:00 •Formatting Date: 00:03:00 •Formatting tables: 00:05:00 •Introduction: 00:01:00 •Creating Pivot Table: 00:07:00 •Value field settings: 00:04:00 •Number format: 00:02:00 •Pivot Table Design: 00:03:00 •Excel Exercise: 00:01:00 •Solution for Excel Exercise: 00:02:00 •Introduction: 00:01:00 •Excel Charts - Categories: 00:03:00 •Elements of a chart: 00:04:00 •Easy way to create charts: 00:02:00 •Column or Bar charts: 00:04:00 •Formatting charts: 00:04:00 •Line charts: 00:02:00 •Area charts: 00:02:00 •Pie and Doughnut charts: 00:04:00 •Format AreaPlot or XY chart: 00:08:00 •Scatter or bubble charts: 00:02:00 •Introduction: 00:01:00 •Frequency Distribution and Histograms: 00:04:00 •Waterfall charts: 00:02:00 •Hierarchy charts: sunburst and tree map: 00:03:00 •Combination charts: 00:02:00 •Sparklines: 00:05:00 •Pivot charts: 00:02:00 •Maps chart: 00:04:00 •3D Maps chart: 00:03:00 •Introduction: 00:01:00 •Stock charts: 00:02:00 •Radar charts: 00:02:00 •Surface charts: 00:02:00 •Heat maps: 00:04:00 •Named ranges: 00:05:00 •Indirect Name range Function: 00:06:00 •Import Data table from PDF file - Excel 2021: 00:04:00 •Import Data from Website - Excel 2019 above: 00:09:00 •Project: Sales forecast tracker: 00:07:00 •Product Sale Tax invoice: Tax Calculations: 00:05:00

🌟 Course Overview 🌟 Unlock your potential and embark on a rewarding career in the field of physiotherapy, sports massage, and reflexology with our comprehensive Counselling Course - Physiotherapy, Sports Massage and Reflexology Complete Bundle. This all-inclusive program is designed to provide you with a deep understanding of the human body, effective therapeutic techniques, and the necessary skills to excel in these specialised fields. Did you know that the demand for physiotherapists, sports massage therapists, and reflexologists is rising? According to recent statistics, the UK healthcare industry is projected to experience a staggering 10% growth by 2028. This presents a significant opportunity for individuals seeking a stable and fulfilling career path. As renowned author John F. Kennedy once said, "Physical fitness is not only one of the most important keys to a healthy body, but also the basis of dynamic and creative intellectual activity." With our Counselling Course, you will become an integral part of this dynamic industry, helping individuals overcome physical challenges and achieve optimal well-being. 💡 Key Features of the Course 💡 CPD Certification: Upon successful completion, you will receive a Continuing Professional Development (CPD) certificate, recognised and respected by employers and professional bodies. 24/7 Learning Assistance: Our dedicated support team is available round the clock to provide guidance and assistance, ensuring you have a seamless learning experience. 🎯 Who is This Course For? 🎯 This Physiotherapy, Sports Massage and Reflexology Complete Bundle is ideal for aspiring physiotherapists, sports massage therapists, and reflexologists eager to acquire the fundamental knowledge and valuable skills required for success in these fields. Whether you are a newcomer or an experienced professional looking to enhance your expertise, this course will provide you with a solid foundation to thrive in the industry. 📚 What Will You Learn? 📚 You will gain a holistic understanding of physiotherapy, sports massage, and reflexology through a comprehensive range of modules. Here's a glimpse of what you will explore: In the Physiotherapy section, you will delve into topics such as the history of physiotherapy, skeletal muscle structure, neuromuscular system, injury prevention, sports physiotherapy, and more. You will learn essential techniques, treatment methods, and even specialised approaches for musculoskeletal conditions and Motor Neuron Disease (MND) patients. The Sports Massage segment will equip you with in-depth knowledge of anatomy, injury phases, athlete history assessment, treatment modification, and various specific treatments. You will understand the crucial role of sports massage in enhancing performance, preventing injuries, and aiding in recovery. Finally, in the Reflexology portion, you will explore the principles and techniques of this ancient practice. From understanding the human foot map to conducting reflexology treatments, you will develop the skills needed to provide holistic care and promote relaxation and well-being. 🌟 Why Enrol in This Course? 🌟 Enrolling in our Physiotherapy, Sports Massage and Reflexology Complete Bundle- Physiotherapy, Sports Massage, and Reflexology Complete Bundle Diploma offers numerous benefits: Top Reviewed Course: This course has received rave reviews from previous learners, who have praised its comprehensive content and applicable relevance. Recently Updated Material: The course content has been carefully curated and updated to ensure you receive the most relevant and up-to-date information in the field. Trending Career Opportunities: By completing this course, you will open doors to exciting and lucrative career opportunities in physiotherapy clinics, sports organisations, wellness centres, and even as a self-employed professional. 🔑 Requirements 🔑 To embark on this journey, you only need a passion for helping others and a willingness to learn. No prior experience or qualifications are necessary, making this course accessible to anyone with a keen interest in these fields. 🚀 Career Path 🚀 Upon completion of this comprehensive physiotherapy, Sports Massage and Reflexology Complete Bundle, you will be well-equipped to pursue various career paths, including: Physiotherapist (£26,000 - £48,000 per annum) Sports Massage Therapist (£18,000 - £35,000 per annum) Reflexologist (£20,000 - £30,000 per annum) Physiotherapy Support Worker (£17,000 - £23,000 per annum) Wellness Centre Practitioner (£20,000 - £40,000 per annum) Fitness Instructor (£15,000 - £30,000 per annum) Rehabilitation Specialist (£25,000 - £45,000 per annum) 🎓 Certification 🎓 Upon successful completion of the Physiotherapy, Sports Massage and Reflexology Complete Bundle - Physiotherapy, Sports Massage, and Reflexology Complete Bundle Diploma, you will receive a CPD certificate. This widely recognised certification will validate your newly acquired skills and knowledge, enhancing your professional credibility in the industry. Course Curriculum 4 sections • 35 lectures • 16:32:00 total length •What is Physiotherapy?: 00:30:00 •What do Physiotherapists do?: 00:15:00 •History of Physiotherapy: 00:15:00 •Skeletal Muscle Structure: 00:15:00 •Neuromuscular System: 00:15:00 •Injury Prevention: 00:15:00 •What is Sports Physiotherapy?: 00:15:00 •Osteoporosis: 00:15:00 •Back Pain & Critical Care: 00:15:00 •Aquatherapy & Hydrotherapy: 00:15:00 •Different Therapy Techniques: 00:30:00 •Treatment Method: 01:00:00 •Physiotherapy For MND Patient: 00:30:00 •Musculoskeletal Physiotherapy (MSK): 00:15:00 •TENS Machines: 00:30:00 •What is Therapeutic Ultrasound?: 00:15:00 •Becoming a Physiotherapist: 00:15:00 •Recommended Reading : Physiotherapy Support Worker Training: 00:00:00 •Introduction to Sports Massage: 01:00:00 •Working as Sports Massage: 00:30:00 •Understanding Anatomy: 00:30:00 •Phases of Injury: 00:30:00 •Athlete History: 01:00:00 •Treatment Modification: 01:00:00 •Specific Treatments: 00:15:00 •Further Education: 00:15:00 •Introduction to Reflexology: 00:15:00 •Historical Roots: 01:00:00 •benefits of reflexology: 00:02:00 •Theories & Effect of Reflexology: 01:00:00 •Foot Reflexology: 01:00:00 •Reflexology Techniques: 00:30:00 •Reflexology Aftercare: 00:15:00 •Hand Reflexology: 00:30:00 •Special Reflexology Treatments: 01:00:00

Course Overview: The demand for bookkeepers is growing rapidly, with a projected 10% increase in job openings by 2029. As businesses of all sizes increasingly rely on cloud-based accounting software, the need for skilled QuickBooks Online bookkeepers is becoming even more critical. The Advanced Diploma in QuickBooks Online Bookkeeping course is perfect if you want to take your bookkeeping career to the next level. With the Advanced Diploma in QuickBooks Online Bookkeeping, you can gain the expertise to effectively manage financial transactions, streamline processes, and make informed decisions. This comprehensive course will equip you with the necessary skills and knowledge to excel in online bookkeeping. Enrol in the Advanced Diploma in QuickBooks Online Bookkeeping today and start your journey to a successful career in bookkeeping! Key Features of the Course: CPD Certification: You will receive a prestigious CPD certificate upon successful completion. 24/7 Learning Assistance: Our expert support team is available round the clock to provide guidance and resolve any queries you may have during your learning journey. Engaging Learning Materials: Enjoy a range of multimedia resources, including interactive quizzes, video tutorials, and downloadable study materials, making your learning experience dynamic and captivating. Who is This Course For? This Advanced Diploma in Quickbooks Online Bookkeeping is tailored for aspiring bookkeepers, finance professionals, small business owners, and individuals seeking to enhance their bookkeeping skills. No prior experience is required, making it accessible to beginners and professionals. What You Will Learn: In the first set of modules, you will familiarise yourself with the fundamental aspects of setting up a new company file, entering opening balances, and managing accruals and prepayments. As you progress, you will explore advanced features such as reporting journals, nominal ledger amendments, and generating comprehensive reports listing nominal ledgers. Furthermore, the Advanced Diploma in Quickbooks Online Bookkeeping course will equip you with the skills to handle customer and supplier data effectively. You will learn to enter customer and supplier information, manage invoices and credit notes, and generate reports on customer activity and aged debtors. Understanding the intricacies of managing these vital aspects will enable you to maintain healthy customer relationships and efficiently manage supplier transactions. Additionally, you will delve into crucial areas such as reconciling bank accounts, processing petty cash transactions, managing cash payments, and conducting VAT returns. These modules will equip you with the tools and knowledge necessary to ensure accurate financial records, effective payment processing, and adherence to tax obligations. Why Enrol in This Course: By enrolling in the Advanced Diploma in QuickBooks Online Bookkeeping, you are investing in your future success. Here's why this course stands out: Top Reviewed Course: Our course has received rave reviews from learners, praising its realistic approach and relevance to real-world scenarios. Recently Updated: The course content is regularly reviewed and updated to align with the latest industry standards and best practices. Trending Skill: QuickBooks Online Bookkeeping is in high demand, making this course a valuable asset to boost your employability and career prospects. Requirements: No specific prerequisites are necessary to join this Advanced Diploma in Quickbooks Online Bookkeeping course. A basic understanding of financial concepts and computer literacy will be advantageous but not essential. Career Path: Upon completing this Advanced Diploma in Quickbooks Online Bookkeeping course, you'll have the skills and knowledge for various lucrative career paths in the financial sector. Bookkeeper - £25,000 to £35,000 per annum Accounting Assistant - £18,000 to £25,000 per annum Finance Administrator - £20,000 to £30,000 per annum Payroll Officer - £25,000 to £35,000 per annum Accounts Payable Clerk - £18,000 to £25,000 per annum Accounts Receivable Clerk - £18,000 to £25,000 per annum Financial Controller - £45,000 to £75,000 per annum Certification: Upon completing the Advanced Diploma in Quickbooks Online Bookkeeping course, you will receive a CPD certificate, validating your achievement and demonstrating your expertise in QuickBooks Online Bookkeeping. This certification will significantly enhance your professional profile and open doors to exciting career opportunities. Enrol in the Advanced Diploma in QuickBooks Online Bookkeeping today and embark on a transformative journey to financial excellence!" Course Curriculum 17 sections • 43 lectures • 03:30:00 total length •The structure of the course - first things first!: 00:05:00 •Set up free trial: 00:03:00 •Starting A New Company File: 00:11:00 •Enter opening balances: 00:02:00 •Reverse opening balances - accruals and prepayments: 00:06:00 •Report Journal: 00:05:00 •Amend The Nominal Ledger: 00:07:00 •Report listing the nominal ledgers: 00:02:00 •Enter customers: 00:09:00 •Report on customer contact information: 00:01:00 •Enter Suppliers: 00:05:00 •Supplier Contact List: 00:02:00 •Enter Invoices: 00:09:00 •Invoice Entering: 00:03:00 •Invoice batch: 00:06:00 •Post Sales Credit Notes: 00:08:00 •Report showing Customer Activity: 00:03:00 •Aged Debtors: 00:02:00 •Post Supplier Invoices: 00:03:00 •Entering a Batch of Supplier Bills: 00:09:00 •Credit Notes Suppliers: 00:05:00 •Reclassify Supplier Bills - Flash Bulbs Purchased: 00:04:00 •Supplier Account Activity Report: 00:04:00 •Post Cheques: 00:07:00 •Reports showing supplier payments : 00:01:00 •Receipts from customers: 00:07:00 •Report showing customer receipts: 00:02:00 •Post Petty Cash Transactions and Report: 00:04:00 •Post cash payments to ledgers: 00:02:00 •Enter petty cash items: 00:14:00 •Report on Petty Cash Payments Proper: 00:05:00 •Post Sundry Payments: 00:05:00 •Report Bank Payments: 00:03:00 •VAT Return: 00:03:00 •Reconcile The Bank: 00:10:00 •Provide A Report Showing Any Unreconnciled Transaction: 00:02:00 •Post the Wages Journal: 00:08:00 •Posting Journal Adjustments: 00:02:00 •Month end adjustments: 00:03:00 •Month end reports: 00:06:00 •Task- Crearing the accounts: 00:06:00 •Task - Customer report: 00:01:00 •Assignment - Advanced Diploma in Quickbooks Online Bookkeeping: 00:05:00

Course Overview: Geology, the study of Earth's structure, history, and processes, is a field of immense significance and awe-inspiring discoveries. If you're seeking a comprehensive understanding of our planet's fascinating geologic features and want to explore the secrets hidden beneath its surface, the Ultimate Geology Course is your pathway to mastery. With an extensive curriculum meticulously designed by experts in the field, this course will take you on an enlightening journey through the captivating realms of geology. Geology is not just an academic pursuit; it's a subject that holds immense practical importance. According to recent data, the demand for skilled geologists is rising, with a projected job growth of 14% in the next decade. By delving into the Ultimate Geology Course, you will equip yourself with the knowledge and skills necessary to unlock a world of opportunities in various industries. Key Features of the Course: CPD certificate 24/7 Learning Assistance Interesting learning materials Who is This Course For? The Ultimate Geology Course is ideal for aspiring geologists, students, professionals seeking a career change, or anyone interested in understanding the Earth's dynamic processes. No prior knowledge or experience in geology is required, making this course accessible to beginners and enthusiasts alike. What You Will Learn: In this Ultimate Geology Course course, you will embark on an incredible journey through many aspects of geology. From the solar system's formation to the geological processes shaping our landscapes, you will gain a comprehensive understanding of the Earth's internal structure, plate tectonics, erosion, sedimentation, volcanoes, and much more. After studying the scientific method and the principles of relative and numerical dating, you will unlock the secrets of Earth's vast history, exploring the evolution of life through fossils and the geologic time scale. Moreover, you will gain valuable skills in mineral identification, rock classification, and geological mapping, empowering you to analyse and interpret Earth's complex features. Why Enrol in This Course: Geology is a highly sought-after field, and by acquiring comprehensive knowledge in this domain, you will enhance employability and open doors to diverse career paths. This Ultimate Geology Course has garnered rave reviews worldwide. Benefit from our instructors' collective wisdom and expertise, ensuring an enriching learning experience. The course content is regularly updated to incorporate the latest advancements and discoveries in geology. Requirements: There are no specific prerequisites to enrol in the Ultimate Geology Course. A passion for understanding the Earth's mysteries and a curious mindset are all you need to embark on this transformative learning journey. Career Path: Completing the Ultimate Geology Course is helpful for many exciting career opportunities. Here are seven course-related professions, along with their average annual salaries in the UK: Geologist - £45,000 Environmental Consultant - £35,000 Geotechnical Engineer - £40,000 Hydrologist - £42,000 Mining Engineer - £50,000 Palaeontology - £38,000 Volcanologist - £47,000 Certification: Upon completing the Ultimate Geology Course, you will receive a CPD certificate, recognised and respected globally. This certificate will validate your newfound expertise in geology and enhance your professional credibility in the field. Course Curriculum 17 sections • 80 lectures • 09:35:00 total length •Course Promo: 00:03:00 •Geology: 00:02:00 •Importance: 00:04:00 •Development: 00:09:00 •The Scientific Method: 00:05:00 •Solar System - OverView: 00:06:00 •The Sun: 00:07:00 •The Moon: 00:06:00 •Terrestrial Planets: 00:10:00 •Jovian Planets: 00:12:00 •Other Solar Bodies: 00:05:00 •Geologic Time - OverView: 00:02:00 •Relative Dating: 00:11:00 •Numerical Dating: 00:07:00 •Fossils: 00:11:00 •The Geologic Time Scale: 00:05:00 •Earth's Internal Structure: 00:11:00 •Exploration: 00:16:00 •Continental Drift: 00:10:00 •Modern Evidence: 00:11:00 •Earth's Major Plates: 00:13:00 •Motion Drivers: 00:05:00 •Motion Measurement: 00:04:00 •Continental Margins: 00:05:00 •Ocean Floor Features: 00:05:00 •Oceanic Crust Layers: 00:02:00 •Destruction of Oceanic Crust: 00:02:00 •Features of Subduction Zones: 00:03:00 •Mountains: 00:07:00 •Topography: 00:07:00 •Weathering - OverView: 00:04:00 •Mechanical Weathering: 00:08:00 •Chemical Weathering: 00:07:00 •Spheroidal Weathering: 00:02:00 •Soil: 00:11:00 •Deserts: 00:08:00 •Wind Erosion: 00:05:00 •Wind as a Transporter: 00:05:00 •Wind Deposits: 00:08:00 •Atom: 00:06:00 •Periodic Table: 00:05:00 •Bond-s: 00:07:00 •Minerals: 00:03:00 •Formation: 00:03:00 •Mineral Identification: 00:09:00 •Crystalline Habits: 00:35:00 •Sedimentary Rocks - OverView: 00:04:00 •Detrital Sedimentary Rocks: 00:03:00 •Grain History: 00:07:00 •Chemical Sedimentary Rocks: 00:04:00 •Coal: 00:06:00 •Sedimentary Rocks Identification Table: 00:05:00 •Sediments to Sedimentary Rocks: 00:05:00 •Sedimentary Structures: 00:06:00 •Metamorphism: 00:08:00 •Metamorphic Rocks: 00:04:00 •Metamorphic Drivers: 00:06:00 •Metamorphic Texture: 00:08:00 •Magma: 00:12:00 •Igneous Texture: 00:09:00 •Deformation: 00:09:00 •Deformation Stages: 00:08:00 •Folds: 00:08:00 •Faults & Joints: 00:14:00 •Volcanoes - OverView: 00:04:00 •Volcanic Eruptions: 00:07:00 •Extruded Material: 00:14:00 •Volcanic Landforms: 00:09:00 •Volcanic Hazards: 00:08:00 •Mass Wasting - OverView: 00:05:00 •Types: 00:07:00 •Triggers: 00:04:00 •Surface Water - Overview: 00:05:00 •Hydrologic Cycle: 00:08:00 •Running Water: 00:12:00 •Flow: 00:08:00 •Channels: 00:10:00 •Depositional Landforms: 00:07:00 •Floods: 00:09:00 •Resource - Ultimate Geology Course: 00:00:00

Our ISO 9001:2015 QMS Clauses Awareness course is a comprehensive program covering all ten clauses of the standard.

Course Overview: Are you ready to embark on a journey into SQL Programming? Unlock the power of data manipulation and database management with the SQL Programming Masterclass. This comprehensive course is meticulously designed throughout this masterclass to provide you with an in-depth understanding of SQL, starting from the basics and progressing to advanced topics. You will explore SQL data types, filtering and sorting data, working with functions, handle NULL values, and even diving into complex SQL concepts like joins, unions, etc. With a course duration of carefully crafted lessons, this Masterclass ensures you grasp SQL's nuances and develop the proficiency to apply these skills effectively.By the end of the SQL Programming Masterclass, you will be prepared to navigate the world of databases confidently. Enrol in this course today and start your journey! Key Features of the Course: CPD certificate upon completion 24/7 learning assistance and support Who is This Course For? This course is perfect for individuals seeking to enhance their data management and analysis skills. Whether you're a data analyst, database administrator, software developer, or professional looking to upskill, this course will empower you to harness the power of SQL programming. Prior programming experience is not mandatory, making it accessible to beginners and intermediate learners. What You Will Learn: Foundations of SQL programming: Learn the basics of SQL, database management systems, and the tools used in this course, such as PostgreSQL and SQLectron. Data manipulation: Master the art of extracting, filtering, and sorting data based on specific requirements using various SQL keywords and operators. Advanced querying techniques: Dive deeper into SQL programming by exploring functions, grouping and aggregating data, and using advanced query techniques. Data conversion and manipulation: Discover how to convert data types, concatenate strings, manipulate characters and numbers, and utilise case statements for more sophisticated queries. Joining tables: Understand the different types of joins and how to combine data from multiple tables using join operations effectively. Data modification: Learn how to insert, update, and delete records in a database, as well as manage table structures and constraints.Joining tables: Understand the different types of joins and how to combine data from multiple tables using join operations effectively. Views and schemas: Explore the concepts of views and schemas, and learn how to create and use them to organise and present data effectively. Why Enrol in This Course: Top-reviewed course: Join thousands of satisfied learners who have praised this course for its clear explanations, comprehensive content, and examples. Recently updated curriculum: Benefit from the most up-to-date information and industry best practices in SQL programming. In-demand skills: SQL programming is a highly sought-after skill in today's job market, opening up numerous career opportunities across industries. Requirements: No prior programming experience is required. All you need is a computer with an internet connection and a willingness to learn. Career Path: Upon completing the SQL Programming Masterclass, you'll have the knowledge and skills for various career paths, including: Data Analyst - Average UK salary: £35,000 per year Database Administrator - Average UK salary: £40,000 per year Business Intelligence Analyst - Average UK salary: £45,000 per year SQL Developer - Average UK salary: £40,000 per year Data Engineer - Average UK salary: £55,000 per year Software Developer - Average UK salary: £45,000 per year Data Scientist - Average UK salary: £60,000 per year Certification: Upon completing the Hygiene and Infection Control CPD Level 4 course, you will receive a CPD certificate. It demonstrates your commitment to maintaining the highest standards of hygiene and infection control. Course Curriculum 17 sections • 117 lectures • 10:47:00 total length •Introduction: 00:01:00 •Tools Used in This Course: 00:01:00 •Download PostgreSQL: 00:02:00 •Install PostgreSQL: 00:03:00 •Download SQLectron: 00:02:00 •Install SQLectron: 00:01:00 •Connect to PostgreSQL - Credentials: 00:01:00 •Connect to PostgreSQL Using SQLectron: 00:02:00 •Import Course Data Using SQLectron: 00:02:00 •FOR WINDOWS 32-BIT USERS: Download, Install, Configure & Import Data: 00:08:00 •Check Imported Data: 00:06:00 •What is a Database?: 00:01:00 •SQL Data Types: 00:02:00 •Finally Some Fun! Extracting Data Based on Requirements: 00:01:00 •Filtering Data using WHERE Keyword: 00:08:00 •Filter Data by Range Using BETWEEN: 00:03:00 •Filter Data by Set of Values Using IN: 00:03:00 •Filter Data by Date: 00:05:00 •More Filtering by Date: 00:03:00 •Another Query Filtering by Date: 00:01:00 •Filter Data by Strings: 00:04:00 •More Filtering by Strings: 00:05:00 •More Filtering by Strings 2: 00:10:00 •More Filtering by Strings 3: 00:02:00 •How to Ignore Caps when Filtering by String: 00:04:00 •AND Operator: 00:10:00 •OR Operator: 00:12:00 •NOT Operator: 00:09:00 •AND, OR & NOT Operators: Which Has the Highest Priority?: 00:06:00 •Basic Math Operations: 00:06:00 •Modulo Operator: 00:04:00 •Calculate The Net Salary for Employees: 00:06:00 •Filter Data with Math Equations: 00:03:00 •Concatenate Strings with '||' Operator: 00:06:00 •Concatenate Strings with Numbers: 00:02:00 •Give Your Report Fields A Cool Name: 00:04:00 •A Report for Payroll: 00:07:00 •Order Records by Column: 00:06:00 •Order Records by Multiple Columns: 00:12:00 •How Alias Names Cannot Be Used with WHERE: 00:02:00 •LIMIT Record Count Fetched by Your Query: 00:08:00 •Fetch A Field's Unique Values Using DISTINCT: 00:03:00 •Using DISTINCT Keyword with Multiple Columns: 00:06:00 •What is a NULL Value Anyway?: 00:05:00 •Build More Sophisticated Queries with CASE Statements: 00:10:00 •Your Knowledge So Far Under A Great Test: 00:09:00 •Let Me Introduce You to Functions: 00:04:00 •SUM Function: 00:04:00 •AVG (Average) Function: 00:04:00 •COUNT Function: 00:07:00 •MIN & MAX Functions: 00:04:00 •How To Count Your Field's Unique Values: 00:04:00 •GROUP BY Clause: Use Functions with Dimensions: 00:06:00 •GROUP BY More Than One Dimension: 00:05:00 •Now For Some Tough Workout: 00:09:00 •Filter By Aggregate Functions with HAVING Clause: 00:08:00 •Character Functions - UPPER, LOWER & INITCAP: 00:08:00 •Character Functions - CONCAT & LENGTH: 00:10:00 •Character Functions - LPAD & RPAD: 00:13:00 •Character Functions - TRIM: 00:04:00 •Character Functions - REPLACE: 00:09:00 •Character Functions - SUBSTR: 00:10:00 •Number Functions - MOD & ROUND: 00:11:00 •Number Functions - TRUNC: 00:07:00 •Selectception: A Select Query inside another Select Query!: 00:06:00 •Auto Data Conversion in SQL: 00:11:00 •Cast Date to Character: 00:10:00 •Cast Number to Character: 00:09:00 •Cast Timestamp to Character: 00:07:00 •Cast Character to Number: 00:08:00 •Cast Character to Date & Timestamp: 00:09:00 •UNION: 00:03:00 •UNION ALL: 00:02:00 •Important Note about Combining Queries: 00:02:00 •INTERSECT: 00:01:00 •EXCEPT: 00:01:00 •Employees & Departments Tables Revised: 00:03:00 •Entity Relationship Diagram (ERD): 00:09:00 •Cartesian Join: 00:09:00 •Table Aliases with Joins: 00:07:00 •Why I Don't Recommend Cartesian Joins: 00:08:00 •Inner Join: 00:06:00 •In-Depth Look into Join Types in SQL: 00:03:00 •Outer Join - Right, Left & Full: 00:08:00 •INSERT a New Record to a Table: 00:09:00 •Insert Without Specifying Column Names: 00:09:00 •UPDATE a Record's Field Values: 00:07:00 •CAUTION! How an UPDATE Query Can Go Wrong: 00:04:00 •Update a Record Using Single-Row Functions: 00:04:00 •A Good Exercise: Extract Employee's Email Address: 00:02:00 •Solution: Extract Employee's Email Address: 00:13:00 •DELETE a Table's Record: 00:06:00 •Insert Records with Nested Select Queries: 00:06:00 •SQL Data Types Revised: 00:13:00 •Bookstore Data Set: Let's Move It to Database: 00:04:00 •Create Your First Table!: 00:08:00 •Insert Data to Your New Table: 00:08:00 •Change Column Data Type: 00:07:00 •Rename Column: 00:04:00 •Add a New Column to Table: 00:04:00 •Constraints in SQL: 00:01:00 •Primary Keys: 00:14:00 •NOT NULL Constraint: 00:05:00 •UNIQUE Constraint: 00:04:00 •DEFAULT Constraint: 00:04:00 •Foreign Keys: 00:08:00 •Use Foreign Keys with Joins - Books & Publishers: 00:06:00 •Foreign Keys - Properties: 00:06:00 •Drop Column: 00:01:00 •DROP Table: 00:01:00 •Create a New Table with Select Statement: 00:05:00 •A Trick to Create an Empty Table with Select Statement: 00:03:00 •Insert New Records Using Select Statement: 00:06:00 •Views: 00:03:00 •Schemas: 00:02:00 •Create & Use Schemas: 00:04:00 •Resources - SQL Programming Masterclass: 00:00:00

Duration 3 Days 18 CPD hours This course is intended for Experienced system administrators and network administrators Customers, cloud architects, systems engineers, data center administrators Network administrators with experience in managed services or managing a Telco Cloud environment Overview By the end of the course, you should be able to meet the following objectives: Deploy VMware Telco Cloud Service Assurance Manage VMware Telco Cloud Service Assurance to satisfy Telco cloud provider needs Discuss configurable options for VMware Telco Cloud Service Assurance Identify and configure different data sources which are used with VMware Telco Cloud Service Assurance Configure different collectors in VMware Telco Cloud Service Assurance Identify the Root Cause Analysis options with VMware Telco Cloud Service Assurance Discuss data collection in VMware Telco Cloud Service Assurance Explain root cause analysis in VMware Telco Cloud Service Assurance Navigate through the logs for troubleshooting This three-day, hands-on training course provides the knowledge, skills, and tools to achieve competency in installing, configuring, and managing the VMware Telco Cloud Service Assurance environment. In this course, you are introduced to the installation methods of VMware Telco Cloud Service Assurance? across various supported platforms and troubleshooting tools that help you install, manage, and troubleshoot your VMware Telco Cloud Service Assurance environment. In addition, you are presented with various types of configuration options, which you will identify, analyze, and navigate through as you explore the UI and configurable options of the product. Course Introduction Introduction and course logistics Course objectives Introduction to VMware Telco Cloud Service Assurance Describe the features of VMware Telco Cloud Service Assurance List the capabilities of VMware Telco Cloud Service Assurance Discuss the use cases of VMware Telco Cloud Service Assurance Describe the role played by VMware Telco Cloud Service Assurance components in delivering service assurance Deploying VMware Telco Cloud Service Assurance Explain different deployment options of VMware Telco Cloud Service Assurance Identify different deployment methods of VMware Telco Cloud Service Assurance Discuss different phases in deploying VMware Telco Cloud Service Assurance Identify different footprints available for HA based and non-HA based installation of VMware Telco Cloud Service Assurance Describe the SMARTs components of VMware Telco Cloud Service Assurance Deploy VMware Telco Cloud Service Assurance User Access Control Describe the features Role-based Access Control (RBAC) Outline the role of Keycloak in implementing RBAC in VMware Telco Cloud Service Assurance Configure user federation in Keycloak Use the VMware Telco Cloud Service Assurance UI to manage RBAC Create policies in VMware Telco Cloud Service Assurance that align with job roles Services and User Interface Configurations Describe the architecture of logical switching Describe the core services on a TCSA cluster Discuss the Global Manager or Service Assurance Manager (SAM), IP Domain Manager, Server Manager (ESM) Discuss VMware Telco Cloud Service Assurance UI Overview Explain Working with Notifications Elaborate Configuring Summary's Describe Accessing Notification Details Explain Viewing and configuring Topologies List Customizing Topologies Describe Topology Explorer Explain Collecting Troubleshooting Information Discuss Custom models Describe how compute resources are provided to VMware Telco Cloud Service Assurance Describe how storage is provided to VMware Telco Cloud Service Assurance Configure and manage VMware Telco Cloud Service Assurance Discuss configurable options for VMware Telco Cloud Service Assurance Day 1 and Day 2 Operations Review the architecture of logical routing and NSX Edge nodes Identify different data sources to be used with VMware Telco Cloud Service Assurance Configure different collectors with VMware Telco Cloud Service Assurance Describe Alarms and Thresholds Demonstrate how to configure alarms with VMware Telco Cloud Service Assurance Explain how to setup thresholds and timelines in VMware Telco Cloud Service Assurance Define Catalog management and sharing catalogs inside and between organizations. Identify the steps to import or upload data into catalogs. Explain the purpose of catalogs and How to Create a catalog organization. Describe the Purpose and Usage of Open Virtualization Format (OVA) and Custom vApp or VM Properties. Discuss vApp Templates Logs and Troubleshooting Review the architecture of the Distributed Firewall Discuss VMware Telco Cloud Service Assurance installations logs List Smarts installation logs Explain backup and restore options of VMware Telco Cloud Service Assurance Identify the approach for troubleshooting containerized services Discuss monitoring services

Duration 5 Days 30 CPD hours This course is intended for Linux system administrators, virtualization administrators, and hybrid infrastructure engineers interested in deploying large-scale virtualization solutions and managing virtual servers in their datacenters, based on the Red Hat Virtualization open virtualization management platform. Overview Configure Red Hat Virtualization Configure networking and storage for use with Red Hat Virtualization Manage user accounts and access to the Red Hat Virtualization environment Install and manage virtual machines in Red Hat Virtualization Use templates for rapid virtual machine deployment Manage virtual machine snapshots and images Migrate virtual machines and explore high-availability options Deploy, configure, manage, and migrate virtual environments Red Hat Virtualization (RH318) teaches you the skills needed to deploy, administer, and operate virtual machines in your organization using Red Hat© Virtualization. Through numerous hands-on exercises, you will demonstrate the ability to deploy and configure the Red Hat Virtualization infrastructure and use it to provision and manage virtual machines. This offering also prepares you for the Red Hat Certified Specialist in Virtualization exam. This course is based on Red Hat Enterprise Virtualization 4.3 and Red Hat Enterprise Linux© 7.6 and 8, as well as Red Hat Hyperconverged Infrastructure for Virtualization 1.6. 1 - Red Hat Virtualization overview Explain the purpose and architecture of Red Hat Virtualization. 2 - Install and configure Red Hat Virtualization Install a minimal Red Hat Virtualization environment and use it to create a virtual machine. 3 - Create and manage datacenters and clusters Organize hypervisors into groups using datacenters and clusters. 4 - Manage user accounts and roles Configure user accounts using a central directory service, then use roles to assign access to resources based on job responsibilities. 5 - Adding physical hosts Add additional Red Hat Virtualization hosts automatically, and move and remove hosts from datacenters as needed. 6 - Scale Red Hat Virtualization infrastructure Add Red Hat Virtualization hosts automatically, configure Red Hat Enterprise Linux hosts when appropriate, and move and remove hosts from data centers as needed. 7 - Manage Red Hat Virtualization networks Separate network traffic into multiple networks on one or more interfaces to improve the performance and security of Red Hat Virtualization. 8 - Manage Red Hat Virtualization storage Create and manage data and ISO storage domains. 9 - Deploy and manage virtual machines Operate virtual machines in the Red Hat Virtualization environment. 10 - Migrate virtual machines Migrate and control automatic migration of virtual machines. 11 - Manage virtual machine images Manage virtual machine snapshots and disk images. 12 - Automating virtual machine deployment Automate deployment of virtual machines by using templates and cloud-init. 13 - Back up and upgrade Red Hat Virtualization Back up, restore, and upgrade the software in a Red Hat Virtualization environment. 14 - Explore high-availability practices Explain procedures to improve the resilience and reliability of Red Hat Virtualization by removing single points of failure and implementing high-availability features. 15 - Perform comprehensive review Demonstrate skills learned in this course by installing and configuring Red Hat Virtualization; using the platform to create and manage virtual machines; and backing up and updating components of Red Hat Virtualization. Additional course details: Nexus Humans Red Hat Virtualization (RH318) 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 Virtualization (RH318) 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 1 Days 6 CPD hours This course is intended for The ProxySG 6.6 Diagnostics and Troubleshooting course is intended for students who wish to gain familiarity with ProxySG troubleshooting techniques and tools. Overview By the completion of this course, you will be able to:Describe the troubleshooting methodology as recommended by Symantec.Diagnose and solve a variety of access and performance issues using tools such as sysinfo files, packet captures, and policy traces. The ProxySG 6.6 Diagnostics and Troubleshooting course provides a structured approach to diagnosing and solving common troubleshooting issues related to ProxySG deployments. The course will emphasize hands-on experience, with extensive opportunities to build competency in the use of the powerful diagnostic tools available on the ProxySG. ProxySG Secure Web Gateway? Overview of Typical Troubleshooting Issues Overview of common issues related to internal resources, external dependencies, SSL interception, and policy efficiency. Introduction to how to use sysinfo files to gain useful troubleshooting information. Troubleshooting Issues Related to External Dependencies Methods for diagnosing and solving authentication issues. Methods for diagnosing and solving DNS issues. Troubleshooting SSL Interception Issues Methods for diagnosing and solving issues related to SSL interception. Troubleshooting Performance Issues Related to Policy Efficiency Methods for optimizing performance through tips for creating more efficient policies.

Duration 5 Days 30 CPD hours This course is intended for Network Engineers, Network Administrators, Network Security Engineers, and NOC Administrators Overview Successful completion of this five-day, instructor-led course will help enhance your understanding of how to design, implement, and effectively operate a Prisma SDWAN solution. You will get hands-on experience configuring Prisma SD-WAN with a branch and datacenter, configure policies, and use Prisma SD-WAN services. The Prisma SD-WAN Design and Operation (EDU-238) course describes the next generation Prisma SD-WAN solution, the capability and value it provides over legacy WAN and SD-WAN implementations, and how to configure, operate, and troubleshoot the solution.This course is intended for people who must configure, maintain, and use wide area networks, from data centers, to branches, to the cloud. This class is powered by Cloud Harmonics. Course Outline Module 1 - Solution Overview Module 2 - Branch Design Module 3 - Routing Module 4 - Policy Module #1 - Application Path and QoS Policy Module 5 - Policy Module #2 - NAT, ZBFW and Security Module 6 - Event Policy Management Services Module 7 - DNS and DHCP Services Module 8 - Operations and Troubleshooting Module 9 - CloudBlades Module 10 - Integrating Prisma SD-WAN and Prisma Access for SASE Implementation Module 11 - DevOps Module 12 - Next Steps