5096 Courses delivered Online

Facilities Management: Facilities Management Course Online This unique Facilities Management: Facilities Management Course offers a thorough introduction to one of the world's most in-demand specialized professions. Learn about the operations and goals of facilities management at an advanced level, gaining the skills and information you will need to pursue a fulfilling career for the rest of your life. The Facilities Management: Facilities Management Course content teaches numerous interconnected disciplines that create facilities management, with no prior knowledge or expertise required. Facilities Management: Facilities Management Course ensures that an organization has the resources and infrastructure to fulfil its tasks successfully and efficiently, both in the public and private sectors. The Facilities Manager is in charge of everything from building maintenance and renovations to contract management, security, and sustainability. Facilities Management is a dynamic and demanding field, which can also be quite rewarding for successful candidates. To operate as a successful organization, a business model requires effective facilities management. By taking this Facilities Management: Facilities Management Course and taking the required measures, you can gain the skills needed to manage a high-performing facility. Special Offers of this Facilities Management: Facilities Management Course This Facilities Management: Facilities Management Course includes a FREE PDF Certificate. Lifetime access to this Facilities Management: Facilities Management Course Instant access to this Facilities Management: Facilities Management Course Get FREE Tutor Support from Monday to Friday in this Facilities Management: Facilities Management Course Main Course: Level 7 Diploma in Facilities Management Course Free courses included with Facilities Management: Facilities Management Course Course 01: Level 5 Report Writing Course Course 02: Fire Safety Level 2 Course 03: Level 7 Business Management Course [ Note: Free PDF certificate as soon as completing the Facilities Management: Facilities Management Course] Facilities Management: Facilities Management Course Online Industry Experts Designed this Facilities Management: Facilities Management Course into 12 detailed modules. Course Curriculum of Level 7 Diploma in Facilities Management Course Module 01: Introduction to Facilities Management Module 02: Developing a Strategy for Facilities Management Module 03: Facilities Planning Module 04: Managing Office Workspace Module 05: Vendor Management & Outsourcing Module 06: Managing Change Module 07: Managing Human Resources Module 08: Managing Risk Module 09: Facilities Management Service Providers Module 10: Managing Specialist Services Module 11: Public-Private Partnerships and Facilities Management Module 12: Health, Safety, Environment and UK Law Assessment Method of Facilities Management Course After completing each module of the Facilities Management: Facilities Management Course, you will find automated MCQ quizzes. To unlock the next module, you need to complete the quiz task and get at least 60% marks. Once you complete all the modules in this manner, you will be qualified to request your certification. Certification of Facilities Management Course After completing the MCQ/Assignment assessment for this Facilities Management: Facilities Management Course, you will be entitled to a Certificate of Completion from Training Tale. It will act as proof of your extensive professional development. Who is this course for? Facilities Management: Facilities Management Course Online This Facilities Management: Facilities Management Course is perfect for - Students Fresh graduates Job Seekers Anyone interested in business analysis People who are already employed in related fields and wish to improve their knowledge and abilities. Requirements Facilities Management: Facilities Management Course Online Students who intend to enrol in this Facilities Management: Facilities Management Course must meet the following requirements: Facilities Management: Good command of the English language Facilities Management: Must be vivacious and self-driven. Facilities Management: Basic computer knowledge Facilities Management: A minimum of 16 years of age is required. Career path Facilities Management: Facilities Management Course Online The Facilities Management: Facilities Management Course could prove instrumental in taking your career to the next level. Typical job titles and roles that fall within the field of FM include the following: Asset Manager Assistant Property Manager Construction Manager Director, Physical Plant Developer Energy Manager Certificates Certificate of completion Digital certificate - Included

Advanced Level 5 Diploma With Hard Copy QLS Certificate | 11 CPD Courses & Free PDF Certificates | Lifetime Access | Tutor Support

Become a payroll expert with our Payroll Management And Systems Diploma Level 3. Master UK Payroll intricacies, gain practical skills, and earn a recognized CPD certificate. Perfect for beginners and professionals, accessible from any device. Enrol now for a year-long access and elevate your career in payroll management.

All you need to know about Banking, Finance and Budgeting Are you looking to solve your personal banking issue? Having trouble with finance and budgeting? Then look no further as this course will get rid of your worries. To get an overview, Personal bankers are sometimes referred to as securities, commodities, and financial services sales agents. They are responsible for performing banking duties and overseeing the financial activities for personal accounts. Finance and Budgeting is a plan including a budgeted balance sheet, which shows the effects of planned operations and capital investments on assets, liabilities, and equities. It also includes a cash budget, which forecasts the flow of cash and other funds in the business. In this course, you will get tips and tools to create a budget that is suitable for your lifestyle, and you will know how to stick to it so that you can reach your financial goals. You will be able to understand the basics of credit, bank fees and fix your credit status. Course Highlights Certified Course in Personal Banking, Finance & Budgeting is an award winning and the best selling course that has been given the CPD Certification & IAO accreditation. It is the most suitable course anyone looking to work in this or relevant sector. It is considered one of the perfect courses in the UK that can help students/learners to get familiar with the topic and gain necessary skills to perform well in this field. We have packed Certified Course in Personal Banking, Finance & Budgeting into several modules for teaching you everything you need to become successful in this profession. To provide you ease of access, this course is designed for both part-time and full-time students. You can become accredited in just 20/30 hours and it is also possible to study at your own pace. We have experienced tutors who will help you throughout the comprehensive syllabus of this course and answer all your queries through email. For further clarification, you will be able to recognize your qualification by checking the validity from our dedicated website. Why You Should Choose Certified Course in Personal Banking, Finance & Budgeting Lifetime access to the course No hidden fees or exam charges CPD Accredited certification on successful completion Full Tutor support on weekdays (Monday - Friday) Efficient exam system, assessment and instant results Download Printable PDF certificate immediately after completion Obtain the original print copy of your certificate, dispatch the next working day for as little as £9. Improve your chance of gaining professional skills and better earning potential. Who is this Course for? Certified Course in Personal Banking, Finance & Budgeting is CPD certified and IAO accredited. This makes it perfect for anyone trying to learn potential professional skills. As there is no experience and qualification required for this course, it is available for all students from any academic backgrounds. Requirements Our Certified Course in Personal Banking, Finance & Budgeting is fully compatible with any kind of device. Whether you are using Windows computer, Mac, smartphones or tablets, you will get the same experience while learning. Besides that, you will be able to access the course with any kind of internet connection from anywhere at any time without any kind of limitation. Career Path You will be ready to enter the relevant job market after completing this course. You will be able to gain necessary knowledge and skills required to succeed in this sector. All our Diplomas' are CPD and IAO accredited so you will be able to stand out in the crowd by adding our qualifications to your CV and Resume. 4 Tips For Understanding The Basic Banking Processes 01:00:00 5 Great Tips On Understanding Your Credit 00:30:00 4 Great Tips On Understanding Bank Fees 00:30:00 3 Great Tips On Setting Up And Maintaining A Budget 00:15:00 4 Great Tips On Reaching Your Savings Goals 01:00:00 4 Great Tips On Dealing With Errors And ID Theft 00:30:00 5 Great Tips On Fixing Your Credit Report 00:15:00 3 Great Tips On Choosing A Credit Card 00:30:00 3 Great Tips On Choosing An Installment Loan 00:30:00 3 Great Tips On Buying A Home 00:30:00 Mock Exam Mock Exam- Certified Course in Personal Banking, Finance & Budgeting 00:20:00 Final Exam Final Exam- Certified Course in Personal Banking, Finance & Budgeting 00:20:00

Intermediate Level Course for Microsoft Infopath Designing your own customized form has never been easier using Microsoft Infopath. Using this software to its full potential is something very few can people can actually do. But don't worry, this course will allow you to use Microsoft Infopath to its full extent. Use infopath to write your own expense report with offline support, increased accuracy and higher efficiency. Fill out your own insurance claim, permit application and other forms at your own convenience. Other benefits include inventory management and market research. Use this software to design, distribute, and to fill and submit electronic forms containing structured data. This intermediate level course consists of units designed to teach you to use infopath at its highest capacity. This course can teach people want to learn how to design their own forms for professional purposes. At the end of the course you will be tested on your knowledge on infopath. On completion of all the units you will be an expert at infopath. Course Highlights Certified Microsoft InfoPath Intermediate Level is an award winning and the best selling course that has been given the CPD Certification & IAO accreditation. It is the most suitable course anyone looking to work in this or relevant sector. It is considered one of the perfect courses in the UK that can help students/learners to get familiar with the topic and gain necessary skills to perform well in this field. We have packed Certified Microsoft InfoPath Intermediate Level into several modules for teaching you everything you need to become successful in this profession. To provide you ease of access, this course is designed for both part-time and full-time students. You can become accredited in just 20/30 hours and it is also possible to study at your own pace. We have experienced tutors who will help you throughout the comprehensive syllabus of this course and answer all your queries through email. For further clarification, you will be able to recognize your qualification by checking the validity from our dedicated website. Why You Should Choose Certified Microsoft InfoPath Intermediate Level Lifetime access to the course No hidden fees or exam charges CPD Accredited certification on successful completion Full Tutor support on weekdays (Monday - Friday) Efficient exam system, assessment and instant results Download Printable PDF certificate immediately after completion Obtain the original print copy of your certificate, dispatch the next working day for as little as £9. Improve your chance of gaining professional skills and better earning potential. Who is this Course for? Certified Microsoft InfoPath Intermediate Level is CPD certified and IAO accredited. This makes it perfect for anyone trying to learn potential professional skills. As there is no experience and qualification required for this course, it is available for all students from any academic backgrounds. Requirements Our Certified Microsoft InfoPath Intermediate Level is fully compatible with any kind of device. Whether you are using Windows computer, Mac, smartphones or tablets, you will get the same experience while learning. Besides that, you will be able to access the course with any kind of internet connection from anywhere at any time without any kind of limitation. Career Path You will be ready to enter the relevant job market after completing this course. You will be able to gain necessary knowledge and skills required to succeed in this sector. All our Diplomas' are CPD and IAO accredited so you will be able to stand out in the crowd by adding our qualifications to your CV and Resume. Module One - Getting Started 00:30:00 Module Two - Working with the InfoPath Environment 01:00:00 Module Three - Working with Digital Signatures 01:00:00 Module Four - Doing More with Controls 01:00:00 Module Five - Working with Control Properties, Part 1 01:00:00 Module Six - Working with Control Properties, Part 2 01:00:00 Module Seven - Using Commands and Switches 01:00:00 Module Eight - Using Formulas and Functions 01:00:00 Module Nine - Using Action Rules 01:00:00 Module Ten - Using More Action Rules 01:00:00 Module Eleven - Using Queries and Data Submission 01:00:00 Module Twelve - Wrapping Up 00:30:00 Activities - Microsoft Info Path Intermediate Level 00:00:00 Mock Exam Mock Exam- Microsoft Info Path Intermediate Level 00:20:00 Final Exam Final Exam- Microsoft Info Path Intermediate Level 00:20:00

Our “Personal Finance” course will help you reach your financial goals and maintain your best credit.

Planned changes to the Construction Skills Certification Scheme mean that from September 2017, Construction Related Occupation (CRO) cards will be phased out. Without registration on an accepted course, or an industry-recognised qualification for your trade, you will not be able to apply for a CSCS card, unless you apply for the CSCS Labourer Card, to access construction sites. An IOSH Working Safely Certificate, along with a CITB Health & Safety Certificate, allows you to apply for a Labourer Card. Therefore, from September 2017, without a CSCS card, you won't get on site. The Labourer Card may be the only way you can get on site.

Buy Big. Save Big! Save now: £1233! Offer Ends Soon; Hurry Up! The construction industry is one of the most hazardous in the UK, with a disproportionately high number of accidents and fatalities. In 2021/22, there were 37 fatal injuries to workers in the construction industry in Great Britain. This Diploma in Construction Safety at QLS Level 5 course is endorsed by the Quality Licence Scheme and accredited by CPD (with 170 CPD points) to make your skill development and career progression related to construction safety substantial and easier than ever! This comprehensive Construction Safety Training course bundle addresses this critical concern. Through twelve meticulously designed modules, it equips learners with essential knowledge and skills to manage health and safety effectively on construction sites. It emphasises risk assessment, legal compliance, accident reporting, and site-specific safety issues, ensuring participants are well-versed in current best practises and safety standards. By completing the Construction Safety Training course, learners not only enhance their understanding of construction safety but also position themselves as valuable assets to any construction team. Invest in your safety and the safety of others. Enrol in our Construction Safety Training bundle today! Learning Outcomes of Construction Safety Training Understand and manage health and safety on construction sites effectively. Conduct thorough risk assessments and identify common construction risks. Comprehend and apply health and safety laws in the workplace. Accurately report accidents and implement preventive measures. Address general site issues including equipment and personnel safety. Mitigate risks in working at heights, excavation, and confined spaces. Why Choose Our Construction Safety Training Course? The opportunity to earn a certificate endorsed by the Quality Licence Scheme Get a free student ID card with Construction Safety Training Training Get instant access to this Construction Safety Training course. Learn Construction Safety Training from anywhere in the world The Construction Safety Training is affordable and simple to understand The Construction Safety Training is an entirely online, interactive lesson with voiceover audio Lifetime access to the Construction Safety Training course materials The Construction Safety Training comes with 24/7 tutor support Start your learning journey right away with this Construction Safety Training course! *** Course Curriculum *** Here is the curriculum breakdown of this Construction Safety course. Module 1: Managing Health and Safety Module 2: Risk Assessment and Common Risks Module 3: Health and Safety at Work and the Laws Module 4: Reporting Accidents at Work Module 5: General Site Issues Module 6: Working at Height Module 7: Excavation Work and Confined Spaces Module 8: Work Equipment Module 9: Manual and Mechanical Handling Module 10: Chemical and Biological Health Hazards and Control Module 11: Electrical Hazards and Control Module 12: Fire Hazards and Control Assessment Process of Construction Safety Training We offer an integrated assessment framework to make the process of evaluation and accreditation for learners easier. You have to complete the assignment questions given at the end of the course and score a minimum of 60% to pass each exam. Our expert trainers will assess your assignment and give you feedback after you submit it. You will be entitled to claim a certificate endorsed by the Quality Licence Scheme and a CPD-accredited certificate after you have completed all the exams. Show off Your New Skills with a Certificate of Completion Endorsed Certificate of Achievement from the Quality Licence Scheme After successfully completing the Construction Safety course, you can order an original hardcopy certificate of achievement endorsed by the Quality Licence Scheme. The certificate will be home-delivered, with a pricing scheme of 119 GBP inside the UK 129 GBP (including postal fees) for international delivery CPD 170 CPD hours / points Accredited by CPD Quality Standards Who is this course for? This Construction Safety Training course is ideal for: Construction professionals Site managers Safety officers Project supervisors Aspiring builders Compliance officers Requirements You will not need any prior background or expertise in this Construction Safety Training course. Career path This Construction Safety Training course will allow you to kickstart or take your career to the next stage in the related sector such as: Health and Safety Manager Construction Safety Tutor Health and Safety Advisor Construction Safety Officer Health and Safety Manager Construction Manager Construction Safety Specialist

Cyber Security Training Course Overview This cyber security course is accredited by the CPD UK. CPD is globally recognised by employers, professional organisations and academic intuitions, thus a certificate from CPD Certification Service creates value towards your professional goal and achievement. CPD certified certificates are accepted by thousands of professional bodies and government regulators here in the UK and around the world. Employees, managers and directors should all have a good understanding of the threat posed by cyber-attacks and the importance of guarding against data breaches. This cyber security short course will explain why cyber attacks and data breaches happen and provide practical advice on how to set up effective defences. First, the course will identify potential 'cyber threat actors' who initiate cybercrime, along with looking at the main motivations behind cyber-attacks on individuals and organisations. On a more practical level, you'll learn how to recognise and deal effectively with phishing attempts. The cyber security course will highlight the importance of keeping passwords secure and cover security for devices, such as smartphones, laptops, tablets or desktop computers. You'll learn how to report a suspected cyber attack, and what to do if you genuinely make a mistake. Finally, we'll underline the importance of cooperation and show how working closely together helps overcome a wide range of cybersecurity issues. Who should take this course? The cyber security course is aimed at employees at all levels of an organisation as it provides an overview of some of the most common cyber security threats encountered in business. Entry Requirement There are no academic entry requirements for this cyber security course, and it is open to students of all academic backgrounds. Advantages Training staff in cyber security is vital to protect your business from these ever present online threats. CPD approval means that this course can be used by those that need to prove they are continually developing themselves. Online training is flexible, efficient and cost effective meaning the candidate can progress through the modules at their own pace and in their own time, so they can fit the training in around their work and personal life. Course Curriculum Module 1: Cyber Security - An Overview Module 2: Combating Cyber Attacks Recognised Accreditation CPD Certification Service This course is accredited by continuing professional development (CPD). CPD UK is globally recognised by employers, professional organisations, and academic institutions, thus a certificate from CPD Certification Service creates value towards your professional goal and achievement. CPD certificates are accepted by thousands of professional bodies and government regulators here in the UK and around the world. Many organisations look for employees with CPD requirements, which means, that by doing this course, you would be a potential candidate in your respective field. Certificate of Achievement Valuable Certification On completion of the course, you will be eligible to download CPD and IIRSM accredited and by the Institute of Hospitality endorsed free electronic certificate instantly. There is a minimal shipping charge applicable to get the hardcopy course completion certificate which is: Shipment Inside the UK = £5.99 International Shipment = £16.99 Overview Cyber Security Training Course Overview This cyber security course is accredited by the CPD UK. CPD is globally recognised by employers, professional organisations and academic intuitions, thus a certificate from CPD Certification Service creates value towards your professional goal and achievement. CPD certified certificates are accepted by thousands of professional bodies and government regulators here in the UK and around the world. Employees, managers and directors should all have a good understanding of the threat posed by cyber-attacks and the importance of guarding against data breaches. This cyber security short course will explain why cyber attacks and data breaches happen and provide practical advice on how to set up effective defences. First, the course will identify potential 'cyber threat actors' who initiate cybercrime, along with looking at the main motivations behind cyber-attacks on individuals and organisations. On a more practical level, you'll learn how to recognise and deal effectively with phishing attempts. The cyber security course will highlight the importance of keeping passwords secure and cover security for devices, such as smartphones, laptops, tablets or desktop computers. You'll learn how to report a suspected cyber attack, and what to do if you genuinely make a mistake. Finally, we'll underline the importance of cooperation and show how working closely together helps overcome a wide range of cybersecurity issues. Who should take this course? The cyber security course is aimed at employees at all levels of an organisation as it provides an overview of some of the most common cyber security threats encountered in business. Entry Requirement There are no academic entry requirements for this cyber security course, and it is open to students of all academic backgrounds. Advantages Training staff in cyber security is vital to protect your business from these ever present online threats. CPD approval means that this course can be used by those that need to prove they are continually developing themselves. Online training is flexible, efficient and cost effective meaning the candidate can progress through the modules at their own pace and in their own time, so they can fit the training in around their work and personal life. Course Curriculum Module 1: Cyber Security - An Overview Module 2: Combating Cyber Attacks Recognised Accreditation CPD Certification Service This course is accredited by continuing professional development (CPD). CPD UK is globally recognised by employers, professional organisations, and academic institutions, thus a certificate from CPD Certification Service creates value towards your professional goal and achievement. CPD certificates are accepted by thousands of professional bodies and government regulators here in the UK and around the world. Many organisations look for employees with CPD requirements, which means, that by doing this course, you would be a potential candidate in your respective field. Certificate of Achievement Valuable Certification On completion of the course, you will be eligible to download CPD and IIRSM accredited and by the Institute of Hospitality endorsed free electronic certificate instantly. There is a minimal shipping charge applicable to get the hardcopy course completion certificate which is: Shipment Inside the UK = £5.99 International Shipment = £16.99 FAQ Is CPD a recognised qualification in the UK? CPD is globally recognised by employers, professional organisations and academic intuitions, thus a certificate from CPD Certification Service creates value towards your professional goal and achievement. CPD-certified certificates are accepted by thousands of professional bodies and government regulators here in the UK and around the world. Are QLS courses recognised? Although QLS courses are not subject to Ofqual regulation, they must adhere to an extremely high level that is set and regulated independently across the globe. A course that has been approved by the Quality Licence Scheme simply indicates that it has been examined and evaluated in terms of quality and fulfils the predetermined quality standards. When will I receive my certificate? For CPD accredited PDF certificate it will take 24 hours, however for the hardcopy CPD certificate takes 5-7 business days and for the Quality License Scheme certificate it will take 7-9 business days. Can I pay by invoice? Yes, you can pay via Invoice or Purchase Order, please contact us at info@lead-academy.org for invoice payment. Can I pay via instalment? Yes, you can pay via instalments at checkout. How to take online classes from home? Our platform provides easy and comfortable access for all learners; all you need is a stable internet connection and a device such as a laptop, desktop PC, tablet, or mobile phone. The learning site is accessible 24/7, allowing you to take the course at your own pace while relaxing in the privacy of your home or workplace. Does age matter in online learning? No, there is no age limit for online learning. Online learning is accessible to people of all ages and requires no age-specific criteria to pursue a course of interest. As opposed to degrees pursued at university, online courses are designed to break the barriers of age limitation that aim to limit the learner's ability to learn new things, diversify their skills, and expand their horizons. When I will get the login details for my course? After successfully purchasing the course, you will receive an email within 24 hours with the login details of your course. Kindly check your inbox, junk or spam folder, or you can contact our client success team via info@lead-academy.org Course Fee £25 £60 58% OFF 👉 CPD UK Accredited PDF Certificate Included 4 interest-free payments of £6.25 Cyber Security Training quantity ENROL NOW Duration: * Hours Instant Access Get In Touch Today Live CHAT WITH US CALL ON - 0300 124 5585 Certificate of Achievement Valuable Certification On completion of the course, you will be eligible to download CPD and IIRSM accredited and by the Institute of Hospitality endorsed free electronic certificate instantly. There is a minimal shipping charge applicable to get the hardcopy course completion certificate which is: Shipment Inside the UK = £5.99 International Shipment = £16.99 FAQs Is CPD a recognised qualification in the UK? CPD is globally recognised by employers, professional organisations and academic intuitions, thus a certificate from CPD Certification Service creates value towards your professional goal and achievement. CPD-certified certificates are accepted by thousands of professional bodies and government regulators here in the UK and around the world. Are QLS courses recognised? Although QLS courses are not subject to Ofqual regulation, they must adhere to an extremely high level that is set and regulated independently across the globe. A course that has been approved by the Quality Licence Scheme simply indicates that it has been examined and evaluated in terms of quality and fulfils the predetermined quality standards. When will I receive my certificate? For CPD accredited PDF certificate it will take 24 hours, however for the hardcopy CPD certificate takes 5-7 business days and for the Quality License Scheme certificate it will take 7-9 business days. Can I pay by invoice? Yes, you can pay via Invoice or Purchase Order, please contact us at info@lead-academy.org for invoice payment. Can I pay via instalment? Yes, you can pay via instalments at checkout. How to take online classes from home? Our platform provides easy and comfortable access for all learners; all you need is a stable internet connection and a device such as a laptop, desktop PC, tablet, or mobile phone. The learning site is accessible 24/7, allowing you to take the course at your own pace while relaxing in the privacy of your home or workplace. Does age matter in online learning? No, there is no age limit for online learning. Online learning is accessible to people of all ages and requires no age-specific criteria to pursue a course of interest. As opposed to degrees pursued at university, online courses are designed to break the barriers of age limitation that aim to limit the learner's ability to learn new things, diversify their skills, and expand their horizons. When I will get the login details for my course? After successfully purchasing the course, you will receive an email within 24 hours with the login details of your course. Kindly check your inbox, junk or spam folder, or you can contact our client success team via info@lead-academy.org

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