34059 Courses in Cardiff delivered On Demand

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

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

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

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: 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

Unlock the secrets of optimal health with our Nutrition Practitioner Diploma. Dive into comprehensive coursework covering essential principles of nutrition, personalized dietary planning, and evidence-based practices. Equip yourself with the knowledge and skills to guide individuals towards a balanced and nourishing lifestyle. Join us on a transformative journey in the field of nutrition and embark on a rewarding career as a certified Nutrition Practitioner. Enroll now and pave the way to a healthier future!

Unlock a rewarding career in human resources with our comprehensive Diploma in HR and Payroll Management. Gain expertise in strategic HR planning, payroll administration, and employee relations. Enroll now to acquire essential skills for effective workforce management and excel in the dynamic field of human resources.

Overcoming Overwhelm: A jam-packed 60 minute masterclass covering how to identify your energy leaks so you can create more success and impact in your career, without burnout.

Elevate your gardening expertise with our comprehensive Gardening Diploma Level 3 program. Unlock advanced horticultural skills, master landscape design, and cultivate a deep understanding of plant biology. Enroll now to sow the seeds of your botanical success and harvest a flourishing career in the world of gardening.