2281 Courses delivered Online

Overview Acquire the language of databases with this SQL Programming Complete Bundlecourse. In this data-driven world, data is used to make strategies, find solutions and do a thousand other tasks. Businesses across the world are using big and related data, which makes a basic knowledge of SQL a remarkable skill not only for data scientists but for everyone. This SQL Programming Complete Bundlecourse will teach you the language of databases, SQL, and help you gain proficiency in SQL tools. How will I get my certificate? At the end of the course there will be a written assignment test which you can take either during or after the course. After successfully completing the test you will be able to order your certificate, these are included in the price. Who is this course for? There is no experience or previous qualifications required for enrolment on this SQL Programming Complete Bundle. It is available to all students, of all academic backgrounds. Requirements Our SQL Programming Complete Bundle is fully compatible with PC's, Mac's, Laptop, Tablet and Smartphone devices. This course has been designed to be fully compatible on tablets and smartphones so you can access your course on wifi, 3G or 4G. There is no time limit for completing this course, it can be studied in your own time at your own pace. Career path Having these various qualifications will increase the value in your CV and open you up to multiple sectors such as Business & Management , Admin, Accountancy & Finance, Secretarial & PA, Teaching & Mentoring etc. Course Curriculum 9 sections • 53 lectures • 07:50:00 total length •Introduction: 00:04:00 •Course Curriculum Overview: 00:05:00 •Overview of Databases: 00:10:00 •MySQL Installation: 00:16:00 •MySQL Workbench Installation: 00:09:00 •Connecting to MySQL using Console: 00:09:00 •Overview of Challenges: 00:04:00 •SQL Statement Basic: 00:16:00 •SELECT Statement: 00:09:00 •SELECT DISTINCT: 00:05:00 •Column AS Statement: 00:12:00 •COUNT built-in Method usage: 00:11:00 •SELECT WHERE Clause - Part One: 00:05:00 •SELECT WHERE Clause - Part Two: 00:11:00 •SQL Statement Basic: 00:16:00 •SQL Limit Clause Statement: 00:09:00 •SQL Using BETWEEN with Same Column Data: 00:11:00 •How to Apply IN Operator: 00:11:00 •Wildcard Characters with LIKE and ILIKE: 00:11:00 •Overview of GROUP BY: 00:06:00 •Aggregation function SUM(): 00:09:00 •Aggregation MIN() and MAX(): 00:05:00 •GROUP BY - One: 00:09:00 •GROUP BY - Two: 00:12:00 •HAVING Clause: 00:05:00 •Overview of JOINS: 00:04:00 •Introduction to JOINS: 00:04:00 •AS Statement table: 00:03:00 •INNER Joins: 00:14:00 •FULL Outer Join: 00:11:00 •LEFT Outer JOIN: 00:08:00 •RIGHT JOIN: 00:08:00 •Union: 00:07:00 •Timestamps: 00:12:00 •EXTRACT from timestamp: 00:10:00 •Mathematical Functions: 00:12:00 •String Functions: 00:22:00 •SUBQUERY: 00:13:00 •Basic of Database and Tables: 00:06:00 •DataTypes: 00:10:00 •Primarykey and Foreignkey: 00:06:00 •Create Table in SQL Script: 00:13:00 •Insert: 00:11:00 •Update: 00:07:00 •Delete: 00:04:00 •Alter Table: 00:09:00 •Drop Table: 00:05:00 •NOT NULL Constraint: 00:08:00 •UNIQUE Constraint: 00:09:00 •Creating a Database backup: 00:12:00 •10a Overview of Databases and Tables: 00:05:00 •10c Restoring a Database: 00:07:00 •Assignment - SQL Programming Complete Bundle: 00:00:00

Overview This comprehensive course on Property Negotiator Training will deepen your understanding on this topic. After successful completion of this course you can acquire the required skills in this sector. This Property Negotiator Training comes with accredited certification, which will enhance your CV and make you worthy in the job market. So enrol in this course today to fast track your career ladder. 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 Property Negotiator Training. It is available to all students, of all academic backgrounds. Requirements Our Property Negotiator Training is fully compatible with PC's, Mac's, Laptop, Tablet and Smartphone devices. This course has been designed to be fully compatible with tablets and smartphones so you can access your course on Wi-Fi, 3G or 4G. There is no time limit for completing this course, it can be studied in your own time at your own pace. Career Path Having these various qualifications will increase the value in your CV and open you up to multiple sectors such as Business & Management, Admin, Accountancy & Finance, Secretarial & PA, Teaching & Mentoring etc. Course Curriculum 5 sections • 43 lectures • 18:48:00 total length •Introduction to Estate Agents: 00:20:00 •Different Types of Estate Agents: 00:15:00 •Getting Started on the Job: 00:15:00 •Listing Property Finding the Sellers: 00:22:00 •Valuation Process: 00:20:00 •Negotiating as an Estate Agent: 00:13:00 •Selling Property - Finding the Buyers: 00:22:00 •Letting Property: 00:31:00 •Technology for Estate Agents: 00:22:00 •Regulation of Estate Agents: 00:13:00 •Module 1: Who is an Estate Agent?: 00:15:00 •Module 2: Requirements for the Job: 00:20:00 •Module 3: History of the Estate Agent: 00:20:00 •Module 4: The Real Estate Industry: 00:15:00 •Module 5: Different Types of Estate Agents: 00:15:00 •Module 6: Online Estate Agents: 00:20:00 •Module 7: Estate agent Fees and Contracts: 00:30:00 •Module 8: Pros and Cons of Hiring an Estate Agent: 00:20:00 •Module 9: Getting to Know Your Clients: 00:20:00 •Module 10: A Day in the Life of an Estate Agent: 00:15:00 •Module 11: Selling Property with an Estate Agent: 00:15:00 •Module 12: Property Marketing: 00:15:00 •Module 13: The Regulations for Estate Agent Boards and Why It is Important: 00:10:00 •Module 14: Valuation: 00:20:00 •Module 15: Performing Viewings: 00:15:00 •Module 16: Negotiating: 00:30:00 •Module 17: Buying with an Estate Agent: 00:20:00 •Module 18: Sales Progression: 00:30:00 •Module 19: Technology: 00:25:00 •Module 20: Investment Property: 00:40:00 •Module 21: About Letting Agents: 00:25:00 •Module 22: Property Management: 00:15:00 •Module 23: Laws and Regulations: 00:30:00 •Module 24: How to Set Up an Estate Agency: 00:15:00 •Module 25: Property Development and the Process: 00:35:00 •Module 26: Main Actors and Economic Context: 01:20:00 •Module 27: Land for Development: 02:00:00 •Module 28: Making Decisions: 00:20:00 •Module 29: Sorting Out Your Finances: 00:30:00 •Module 30: Establishing Your Business: 00:20:00 •Module 31: Market Research: 01:15:00 •Module 32: Promotion and Selling: 01:00:00 •Assignment - Property Negotiator Training: 00:00:00

Learn essential food safety and hygiene practices with our comprehensive Food Hygiene Level 2 course. Perfect for catering staff, food handlers, and hospitality professionals, this course covers everything from preventing foodborne illnesses to effective waste disposal and pest management

Gain essential training skills and earn a CPD Certified Diploma with our Train the Trainer course. Learn effective communication, engagement techniques, and how to establish credibility with your audience. Perfect for aspiring trainers or professionals looking to enhance their training abilities. Enrol now for expert guidance and a recognised certification.

Obtain your Gel Manicure and Nail Technician Diploma and kickstart your career in the nail care industry. Learn essential techniques, from manicure and pedicure to nail art and gel application, with our comprehensive diploma course.

This Know Your Customer (KYC) Training course provides a comprehensive overview of KYC concepts and compliance. It will define KYC, explain its importance, and provide key insights into customer due diligence, anti-money laundering regulations, and data privacy.

Gain essential first aid skills and knowledge with our Emergency First Aid at Work Course. Learn how to manage incidents effectively, provide first aid, and respond to various injuries and medical conditions. Suitable for individuals in various workplaces and those interested in workplace safety.

With our Child Psychology Diploma Level 3 course, you'll gain knowledge about the challenges faced during infancy, childhood, and adolescence. By the course's end, you'll have a comprehensive understanding of child psychology and receive a certificate to demonstrate your competency in this field.

This COSHH Training course is designed for anyone who works with or around hazardous substances, such as chemicals, dust, fumes, vapours, gases, biological agents, and more. Whether you are a health and safety professional, a manager, an employee, or just someone who wants to improve your COSHH knowledge, this course is for you.

Unlock the healing potential of aromatherapy with our Level 3 Diploma course. Learn the principles, history, and safe use of essential oils for physical, emotional, and mental well-being. Acquire expertise in blending oils, explore various techniques, and stay updated on the latest trends.