2535 Courses

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 the art of hypnosis, delve into the subconscious mind, and discover techniques for healing and personal transformation. Enrol now to embark on a journey of self-discovery and empowerment.

Learn essential skills for maintaining a clean kitchen with our Dishwashing, Waste Management, and Kitchen Cleaning Training. Master dishwashing techniques, waste management, and kitchen hygiene.

Embark on your journey to learn French with our comprehensive beginner course. Master basic vocabulary, grammar, and conversational skills. Perfect for beginners and those seeking to start from scratch.

Master cash flow management with Microsoft Excel in our comprehensive course. Learn internal controls, cash receipts and disbursements management, bank reconciliations, petty cash handling, and more. Ideal for professionals seeking to enhance their financial management skills using Excel.

Learn advanced nail and skin care techniques with our Beauty Technician: Manicure & Pedicure course. Become skilled in addressing issues like cracking and infections, and earn your CPD certificate. Open up career opportunities as a Nail Technician, Nail Artist, Beauty Therapist, or Salon Manager. Begin your journey to professional success today!

CPD Accredited | Career Oriented Learning Modules | 24x7 Tutor Support | Lifetime Access

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.