837 Courses delivered On Demand

Pronouns are a fundamental aspect of human communication, and recognizing their importance, especially in the context of gender identity, is essential for creating an inclusive and welcoming workspace. This comprehensive course is designed to foster an understanding of the significance of pronoun inclusivity in today's diverse work environments. Analyze the evolving landscape of gender identities and pronoun usage, shedding light on non-binary, genderqueer, and other identities that may not conform to traditional binary gender norms. Participants will explore the profound impact that pronoun inclusivity can have on teamwork, communication, and overall workplace satisfaction. Learning Objectives Define and explain the concept of pronoun inclusivity and its significance in fostering diversity and inclusion in the workplace.;Comprehend the evolving landscape of gender identities and be familiar with a variety of pronouns beyond the traditional he/him and she/her.;Recognize the importance of pronoun inclusivity in attracting and retaining diverse talent, creating a respectful work environment, and reducing communication breakdowns.;Implement practical strategies to promote pronoun inclusivity within your organization, including introducing pronouns during introductions, updating materials, and encouraging respectful language use.

In this competitive job market, you need to have some specific skills and knowledge to start your career and establish your position. This Landing Page Design and Optimisation will help you understand the current demands, trends and skills in the sector. The course will provide you with the essential skills you need to boost your career growth in no time. The Landing Page Design and Optimisation will give you clear insight and understanding about your roles and responsibilities, job perspective and future opportunities in this field. You will be familiarised with various actionable techniques, career mindset, regulations and how to work efficiently. This course is designed to provide an introduction to Landing Page Design and Optimisation and offers an excellent way to gain the vital skills and confidence to work toward a successful career. It also provides access to proven educational knowledge about the subject and will support those wanting to attain personal goals in this area. Learning Objectives Learn the fundamental skills you require to be an expert Explore different techniques used by professionals Find out the relevant job skills & knowledge to excel in this profession Get a clear understanding of the job market and current demand Update your skills and fill any knowledge gap to compete in the relevant industry CPD accreditation for proof of acquired skills and knowledge Who is this Course for? This Landing Page Design And Optimisation is ideal for aspiring professionals who wish to gain the relevant skills and knowledge to fast track their careers. It is for those who have little or no knowledge of Landing Page Design & Conversion Rate Optimisation or those who are new to the field and want to test their skills and knowledge. There are no entry requirements for this course. However, an eye for detail and a creative mind is essential. Entry Requirement This course is available to all learners of all academic backgrounds. A good understanding of the English language, numeracy, and ICT are required to attend this course. CPD Certificate from Course Gate  At the successful completion of the course, you can obtain your CPD certificate from us. You can order the PDF certificate for £9 and the hard copy for £15. Also, you can order both PDF and hardcopy certificates for £22. Career Path On successfully completing the Landing Page Design And Optimisation, learners can progress to a more advanced program from our course list. Career opportunities in this field include freelancing or working in-house, within a range of professional settings, with the opportunity to earn a high salary. Related professions in this industry include: Digital Marketing Manager Campaign Executive Course Curriculum Module 01: Landing Page Design and Optimisation Fundamentals Download all Section One Slides 00:48:00 Welcome to this course! Let's lay the groundwork for good landing page design 00:13:00 The Myth Of The Perfect Landing Page Conversion Rate 00:12:00 The 3 Main Types of Landing Pages and How To Use Them Effectively 00:19:00 Common Business Models and Understanding Your Conversion Actions 00:19:00 The AIDA Sales Funnel and The Online Decision Making Process 00:17:00 The Awareness Stage of the Funnel: Where It All Begins 00:18:00 The Interest Stage of the Funnel Tell Me More 00:14:00 The Desire Stage of the Funnel I Want What You Sell 00:13:00 The Action Stage of the Funnel I'm Going to Buy What You Sell 00:09:00 The Fogg Behavior Model and how it Applies to Good Landing Page Design 00:20:00 Making Your Landing Page Design Memorable 00:14:00 Module 02: Principles of Good Landing Page Design: Examples, Case Studies & Best Practices Download all Section Two Slides 00:06:00 The Primacy of Product and The Concept of Usability in Landing Page Design 00:15:00 Eschew Obfuscation: Clarity and the Quest for Fewer Question Marks 00:11:00 The 5 Second Usability Test in Landing Page Design (and how you can use it now) 00:31:00 The Art and Science Behind Designing High-Converting Calls To Action (CTA's) 00:19:00 Readability and Visual Hierarchy Landing Page Design 00:20:00 Respecting Web Conventions in Landing Page Design 00:13:00 Using Videos, Graphics and Imagery to Increase Landing Page Conversion Rates 00:20:00 Information Architecture and Accessibility - Landing Page Design Best Practices 00:20:00 Trust, Safety and Credibility (Part 1) Landing Page Design Best Practices 00:16:00 Trust, Safety and Credibility (Part 2) Landing Page Design Best Practices 00:09:00 Dedicated Landing Page Design Best Practices (Part 1) 00:15:00 Dedicated Landing Page Design Best Practices (Part 2) 00:12:00 Module 03: Principles of Persuasion in Landing Page Design Download all Section Three Slides 00:32:00 Using Scarcity to Improve Conversion Rates on Your Landing Pages 00:10:00 Principles of Persuasion - Reciprocal Concessions & Reciprocity in Landing Pages 00:12:00 Principles of Persuasion Anchoring and Cognitive Dissonance Theory 00:19:00 Module 04: Designing and Building a Landing Page Step by Step in Unbounce My Favorite Landing Page Builders and Getting Started With Our Unbounce Page 00:10:00 Getting Familiar With the Unbounce Page Builder and Adding Our Header Section 00:07:00 Creating a Logo in Photoshop and Using the Unbounce Image Uploader Tool 00:16:00 Working With Background Imagery in Landing Pages and Developing Our Hero Section 00:16:00 Creating a Form, Action Block, and Finishing the Hero Section in Unbounce 00:19:00 Discussing Landing Page Design Changes and Creating our Primary Content Section 00:16:00 Finishing Page Content, Adding Icons, Footer and Working With Buttons Unbounce 00:11:00 Publishing Your Unbounce Landing Page on Your Custom Domain 00:04:00 Adding Custom CSS in Unbounce to Create Professional Drop Shadows 00:06:00 Making Your Landing Page Design Work Better With Custom Javascript Snippets 00:08:00 Mobile Site Layout in Unbounce Based on Mobile Landing Page Design Guidelines 00:03:00 Designing Your Form Confirmation Dialogue in Unbounce and Testing Your Live Form 00:03:00 Assigning A/B Testing Variants in Unbounce and Assigning Traffic Weights 00:12:00 Integrating Your Unbounce Form Submissions With Your Mailchimp Account 00:09:00 Module 05: Bonus Goodbye For Now I Will Miss You Dearly 00:03:00 Module 06: Bonus Content: Real-Life Audits - Landing Page Design Best Practices Western Computer Audit Part 1 00:08:00 Western Computer Audit Part 2 00:09:00 Western Computer Audit Part 3 00:15:00 Western Computer Audit Part 4 00:14:00 Certificate and Transcript Order Your Certificates or Transcripts 00:00:00

Overview This comprehensive course on Automated External Defibrillator (AED) - Online Training will deepen your understanding on this topic. After successful completion of this course you can acquire the required skills in this sector. This Automated External Defibrillator (AED) - Online 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 Automated External Defibrillator (AED) - Online Training. It is available to all students, of all academic backgrounds. Requirements Our Automated External Defibrillator (AED) - Online 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 6 sections • 6 lectures • 02:44:00 total length •Introduction to AED: 00:28:00 •Preparation for Using an AED: 00:27:00 •Using an AED: 00:26:00 •Special AED Situations: 00:28:00 •AED Usage, Training and Locations: 00:33:00 •AED Maintenance: 00:22:00

Overview Kickstart a career in the beauty industry by enrolling in our Eyelash Lifting and Tinting Diploma course. Everyone craves defined eyes, and eyelash lifting and tinting is the perfect way to achieve this look. Industry experts designed this Eyelash Lifting and Tinting Diploma course to teach you how to lift and tint eyelashes safely and with confidence. Throughout the course, you will get step-by-step guidance on the whole process of lash and brow tinting to equip you with the skills to become a professional eyelash specialist. So enrol today, build an exciting career and create defined eyes which everyone craves, for you and your clients. 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 Eyelash Lifting and Tinting Diploma. It is available to all students, of all academic backgrounds. Requirements Our Eyelash Lifting and Tinting Diploma 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 2 sections • 8 lectures • 03:55:00 total length •Module 1: Eye Lash Lift & Eyelash Tinting: 00:20:00 •Module 2: Consultation Skills: 01:15:00 •Module 3: How to Maintain a Safe, Secure and Hygienic salon: 01:00:00 •Module 4: Eye and Eyelashes Anatomy: 00:20:00 •Module 5: Contra Indications and Contra Actions: 00:35:00 •Module 6: Product Information And Usage Guidelines: 00:00:00 •Module 7: Lash Lifting Technique: 00:25:00 •Assignment - Eyelash Lifting and Tinting Diploma: 00:00:00

Overview According to the Health and Safety Executive (HSE), improper handling or inadequate equipment is responsible for over 30% of the workplace accidents reported yearly. The PUWER course offers an extensive curriculum that covers everything from the selection and conformity of work equipment to its safe functionality, monitoring, evaluation, maintenance, and training. This in-depth knowledge ensures that professionals are well-equipped to navigate the complexities of work equipment usage, ensuring safety and compliance.But PUWER doesn't stop at safe functionality. It is recognising the dynamic nature of the equipment and the environments. The course dedicates extensive modules to monitoring and evaluating work equipment. In essence, the PUWER course isn't just about regulations-it's about understanding the life cycle of work equipment, the human-machine interface, and the overarching ethos of safety and efficiency in the industrial workspace. 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 'PUWER'. It is available to all students, of all academic backgrounds. Requirements Our 'PUWER' 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 5 sections • 5 lectures • 02:31:00 total length •Provision and Use of Work Equipment Regulations: 00:48:00 •Selection and Conformity of Work Equipment: 00:25:00 •Safe Functionality of Work Equipment: 00:36:00 •Monitoring and Evaluation of Work Equipment: 00:28:00 •Maintenance and Training of Work Equipment: 00:14:00

Overview Raise awareness about Dementia and learn how to support and treat those individuals that have the condition. This Dementia Training course has been designed to teach anyone about the impact of Dementia, and what is needed to cope with it. The course has been written with help from industry experts and explains why Dementia cases are rising. It will provide you with all the necessary abilities and knowledge needed to successfully care for a Dementia patient and the changes that you can expect to see in them. The training also extends to communication techniques and appropriate medication usage. 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 Dementia Training. It is available to all students, of all academic backgrounds. Requirements Our Dementia Training 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 2 sections • 10 lectures • 01:25:00 total length •Module 01: Introduction to Dementia: 00:10:00 •Module 02: Status of Dementia: 00:10:00 •Module 03: Attitudes Toward Dementia: 00:15:00 •Module 04: Awareness and Prevention of Dementia: 00:10:00 •Module 05: Law, Ethics and Safeguard Regarding Dementia: 00:10:00 •Module 06: Strategies for Caring: 00:10:00 •Module 07:The Cost of Dementia: 00:05:00 •Module 08: Drug for Dementia: 00:10:00 •Module 09: Living with Dementia: 00:05:00 •Assignment - Diploma in Dementia Care and Awareness: 00:00:00

Overview This comprehensive course on Uniform System of Accounting for Lodging Industries Part 1 will deepen your understanding on this topic. After successful completion of this course you can acquire the required skills in this sector. This Uniform System of Accounting for Lodging Industries Part 1 comes with accredited certification from CPD, 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? At the end of the course there will be an online written 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 Uniform System of Accounting for Lodging Industries Part 1. It is available to all students, of all academic backgrounds. Requirements Our Uniform System of Accounting for Lodging Industries Part 1 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 Learning this new skill will help you to advance in your career. It will diversify your job options and help you develop new techniques to keep up with the fast-changing world. This skillset will help you to- Open doors of opportunities Increase your adaptability Keep you relevant Boost confidence And much more! Course Curriculum 6 sections • 24 lectures • 03:44:00 total length •Introduction to the Course: 00:02:00 •Introducing Hotel Operating Structure-Profit Centers: 00:03:00 •Introducing Hotel Operating Structure-Support Centers: 00:03:00 •Explaining the main Profit & Loss Statement: 00:09:00 •Room Profit & Loss - Transient Market Segment: 00:10:00 •Rooms - Group Market Segment Explained: 00:09:00 •Rooms Division - Contract Revenue and Other Room Revenue: 00:06:00 •Other Rooms revenue consideration - Packages Barter Loyalty program: 00:09:00 •Structure of Room Departmental Expenses: 00:09:00 •Labour cost Departments and positions: 00:06:00 •Labour Cost Departments and Positions: 00:05:00 •Other Labour cost items for Room Division: 00:11:00 •Room Expenses A-d: 00:17:00 •Room Expenses E-R: 00:23:00 •Room Expenses S-Z: 00:05:00 •Introduction to Section on Room Statistics: 00:01:00 •Ocupancy Statistcis definitions: 00:24:00 •Formulas for Room Statistics: 00:06:00 •Room Statistics Report to help understand P&L: 00:12:00 •Understanding What Variable Expense Are and Fixed Showing P&L Analysis: 00:17:00 •Closure Video for Rooms Module: 00:01:00 •Room Division Definitions of Revenue and Expenses as Per USALI: 00:36:00 •Rooms P&L Sample: 00:00:00 •Assignment - Uniform System of Accounting for Lodging Industries Part 1: 00:00:00

Course Overview: The field of cleaning services in the UK has undergone significant expansion and transformation. To appreciate the depth and magnitude of this sector, consider this: As of 2022, the British cleaning market was valued at £24 billion. This figure underlines the industry's significance and showcases the vast opportunities. The British Cleaning Level 5 Certificate course offers learners a comprehensive dive into the myriad facets of this burgeoning industry. It systematically navigates through the vast spectrum of cleaning tasks, from the intimacy of house cleaning to the complexities of commercial kitchens. Moreover, learners are empowered with management and entrepreneurial tools, ensuring their success in salaried roles and business ventures. Key Features of the Course: This British Cleaning Level 5 Certificate course includes: CPD certified course 24/7 Learning Assistance available Engaging and up-to-date learning materials Designed by industry professionals Who is This Course For? This British Cleaning Level 5 Certificate course is Ideal for individuals looking to delve deeper into the science of cleanliness, those keen to advance in their current cleaning roles, or entrepreneurs looking to establish their own cleaning business. Learning Outcome Completing our British Cleaning Level 5 Certificate course offers you to learn: The foundational aspects of the cleaning job Understanding the broad spectrum of cleaning roles Mastery of various cleaning equipment, products, and clothing Techniques for impeccable house cleaning Procedures for food kitchen and commercial kitchen cleaning Approaches to maintain spotless bathrooms and toilets Expertise in cleaning offices efficiently Methods for cleaning external surfaces and handling non-routine waste Safe usage of chemicals and responsibilities of keyholding Entrepreneurial skills to start and manage a successful cleaning business Why Enrol in This Course: Stay at the cutting edge of the cleaning industry with this top-reviewed, recently updated course. As cleanliness norms evolve, ensure you have the latest skills and knowledge to excel. Requirements: Basic understanding of English and a keen interest in advancing one's cleaning expertise. Career Path: Cleaning Business Owner (£30,000 - £50,000) Residential Cleaning Specialist (£20,000 - £30,000) Commercial Kitchen Sanitation Expert (£22,000 - £35,000) Office Cleaning Manager (£25,000 - £38,000) External Surface Cleaning Specialist (£21,000 - £33,000) Waste Management Specialist (£24,000 - £37,000) Chemical Safety Officer (£28,000 - £42,000) Certification: Upon completing the Completing our British Cleaning Level 5 Certificate course, learners will receive a CPD certificate. Course Curriculum 17 sections • 17 lectures • 06:01:00 total length •An Introduction to the Cleaning Job: 00:19:00 •The Diversity of Cleaning Jobs: 00:26:00 •Cleaning Equipment, Products and Clothing: 00:24:00 •House Cleaning: 00:22:00 •Food Kitchen and Commercial Kitchen Cleaning: 00:23:00 •Bathrooms and Toilets: 00:22:00 •Office Cleaning: 00:19:00 •Cleaning External Surfaces and Areas: 00:18:00 •Dealing with Non-Routine Waste: 00:21:00 •Chemical Safety, Keyholding and Alarm Codes for Cleaners: 00:21:00 •Starting a Cleaning Business and Planning for it: 00:14:00 •Running the Business with Quality Service: 00:22:00 •Customer Satisfaction: 00:23:00 •Management of Staff: 00:22:00 •Marketing, Advertising and Sales: 00:24:00 •Expansion Management: 00:17:00 •Business Insurance, Tax and Additional Equipment: 00:24:00

Overview This comprehensive course on Tutorial For Inkscape - Learn Vector Graphics Design will deepen your understanding on this topic. After successful completion of this course you can acquire the required skills in this sector. This Tutorial For Inkscape - Learn Vector Graphics Design comes with accredited certification from CPD, 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? After successfully completing the course 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 Tutorial For Inkscape - Learn Vector Graphics Design. It is available to all students, of all academic backgrounds. Requirements Our Tutorial For Inkscape - Learn Vector Graphics Design 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 Learning this new skill will help you to advance in your career. It will diversify your job options and help you develop new techniques to keep up with the fast-changing world. This skillset will help you to- Open doors of opportunities Increase your adaptability Keep you relevant Boost confidence And much more! Course Curriculum 7 sections • 37 lectures • 04:00:00 total length •Introduction: 00:02:00 •The user interface: 00:05:00 •Draw your first object: 00:04:00 •Saving your work and exporting: 00:03:00 •Select and transform objects: 00:04:00 •Dealing with multiple objects: 00:07:00 •Let's color it! - the basics of color usage: 00:09:00 •Shape and path: 00:08:00 •Groups and basic drawings: 00:07:00 •Edit path by nodes: 00:12:00 •Another view on colors: 00:06:00 •Gradients: 00:07:00 •Going for the 3D look - gradients and blur: 00:09:00 •Clipping and masking: 00:10:00 •Working with text: 00:11:00 •Layers: 00:05:00 •Guidelines, rulers, align and distribute: 00:06:00 •The spray tool: 00:08:00 •The pencil tool - create custom brushes: 00:08:00 •Sculpt tool: 00:05:00 •Pattern along path: 00:05:00 •Filters and extensions: 00:04:00 •Import photos and tracing: 00:08:00 •How to create patterns: 00:06:00 •Blending modes: 00:06:00 •Create a Christmas card: 00:04:00 •Draw a funny elf character: 00:18:00 •Finish your character and create falling snow: 00:15:00 •Finalize and export your drawing: 00:01:00 •Why Inkscape 0.91 What is new: 00:05:00 •New way to deal with gradients!: 00:04:00 •Powerstroke and the symbol library: 00:05:00 •Change canvas color: 00:04:00 •Use Find and replace to manage multiple objects: 00:06:00 •Tips for creating a good pattern: 00:06:00 •How to create mandala: 00:06:00 •Bonus lecture - check this out!: 00:01:00

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