44172 Courses

Embark on a thrilling archaeological journey with our Masterclass: Unearthing the Secrets of the Past. Learn fieldwork techniques, excavation methods, and artefact analysis. Dive into the world of modern technology in archaeology. Join us to unlock the mysteries of ancient civilizations and gain hands-on skills for uncovering and preserving our shared human history.

Unlock the secrets of perfumery and transform your passion into a thriving online business with our comprehensive course. From mastering fragrance creation and evaluating scents to navigating safety regulations and launching your own perfume brand, this aromatic journey blends art and entrepreneurship. Enroll now to discover the art of perfumery and the keys to building a successful online perfume business. Elevate your creativity, skills, and business acumen in the captivating world of scents!

Explore the multifaceted world of schizophrenia with our comprehensive course, 'Schizophrenia Awareness: Understanding the Journey & Building Empathy.' Gain insights into symptoms, causes, diagnosis, and treatment while learning to create supportive environments and improve quality of life. Join us on a journey to foster empathy, reduce stigma, and contribute to a more compassionate understanding of mental health.

Explore the complexities of grief and gain essential counseling skills in our "Grief and Bereavement Counselling Course: Navigating Loss and Healing." Understand the nuances of mourning, from the impact of sudden death to specialized approaches for children and adults. Navigate ethical considerations and address complicated grief reactions. Join us on a transformative journey to become a compassionate guide through the healing process. Enrich your skills, support those in grief, and make a meaningful impact on the journey from loss to resolution.

Master the essentials of workplace confidentiality with our comprehensive training course. Learn about business etiquettes, UK legislation, and international standards to safeguard sensitive information. Ideal for professionals committed to maintaining a trusted and secure work environment.

A downloadable 16 page guide in 'Starting your Meditation Journey'.

Data speaks volumes—if you know how to listen. This course offers a clever route into the world of MySQL, showing you how structured data can turn into smart decisions. Whether you're sifting through figures, building dashboards, or deciphering patterns, understanding SQL isn’t just helpful—it’s essential. You’ll be guided through the foundations of MySQL with clarity and precision, making sense of tables, queries, joins, and more—all without the fluff or confusion. Designed with the analytical mind in focus, this course shines a light on how MySQL powers insights behind the scenes in data science and analytics. It's tailored for learners who prefer clarity over jargon and structure over noise. If you're curious about how databases work and how data fuels smart outcomes, this course is your ideal stepping stone—organised, engaging and purposefully built for those who appreciate logic and clean learning paths. Expert Support Dedicated tutor support and 24/7 customer support are available to all students with this premium quality course. Key Benefits Learning materials of the Design course contain engaging voiceover and visual elements for your comfort. Get 24/7 access to all content for a full year. Each of our students gets full tutor support on weekdays (Monday to Friday) Course Curriculum: Section 01: Getting Started Introduction How to get course requirements Getting started on Windows, Linux or Mac How to ask great questions FAQ's What is Source Code? Section 02: SQL Server setting up Section Introduction MySQL Server Installation Connect MySQL Server Instance MySQL Workbench overview Download and Restore Sample Database Section 03: SQL Database basics Section Introduction Overview of Databases Creating Database SQL Data Types Column Data Types on Workbench Creating Table Overview of Primary and Foreign Key Primary Key Foreign Key Creating Temporary tables EER - Enhanced Entity Relationship Diagrams Section 04: SQL DML (Data Manipulation Language) Section Introduction Insert statement Update statement Delete statement Section 05: SQL DDL (Data Definition Language) Section Introduction CREATE table statement DROP statement ALTER statement TRUNCATE statement COMMENT in query RENAME table Section 06: SQL DCL (Data Control Language) Create Database user GRANT permissions REVOKE permissions Section 07: SQL Statement Basic Section Introduction SQL Statement basic SELECT Statement SELECT DISTINCT SELECT with column headings Column AS statement DASHBOARD Analytics Section 08: Filtering Data rows SELECT WHERE Clause - theory SELECT WHERE Clause - practical Section 09: Aggregate functions for Data Analysis Sum() Min()-Max() Section 10: SQL Data Analyticstatements Order By statement SELECT TOP 3 records BETWEEN command IN operator Search Data usingLIKE cards Section 11: SQL Group by statement Section Introduction Group by - theory Data Analytics with Group By HAVING statement Section 12: JOINS Overview of Joins What are Joins Inner join Left outer join Right outer join Union CERTESIAN Product or Cross Join Query Exercise Solution for Query Exercise Section 13: SQL Constraints Section introduction Check constraint NOT NULL constraint UNIQUE constraint Section 14: Views Creating Views Data Analytic Viewsfrom multiple tables Section 15: Advanced SQL Functions Section Introduction Timestamp Extract from timestamp Mathematical scalar functions String functions Advanced functions Sub Queries SELECT with calculations Section 16: SQL Stored procedures Create stored procedure Stored procedure with parameter Drop Procedure Section 17: Import & Export data Section Introduction Import .csv file Export Data to .csv file Section 18: Backup and Restore Database Section Introduction Creating Database backup Restoring Database backup Exam & Retakes: It is to inform our learners that the initial exam for this online course is provided at no additional cost. In the event of needing a retake, a nominal fee of £9.99 will be applicable. Certification Upon successful completion of the assessment procedure, learners can obtain their certification by placing an order and remitting a fee of £9 for PDF Certificate and £15 for the Hardcopy Certificate within the UK ( An additional £10 postal charge will be applicable for international delivery). Who is this course for? This Learn MySQL from Scratch for Data Science and Analytics course is designed to enhance your expertise and boost your CV. Learn key skills and gain a certificate of achievement to prove your newly-acquired knowledge. Requirements This Learn MySQL from Scratch for Data Science and Analytics course is open to all, with no formal entry requirements. Career path Upon successful completion of The Learn MySQL from Scratch for Data Science and Analytics Course, learners will be equipped with many indispensable skills and have the opportunity to grab.

Are you ready to unlock the secrets of fine chocolate? Whether you're a chocolate lover or just starting your journey into the world of craft chocolate, this beginner-friendly course is your gateway to understanding, appreciating, and distinguishing finely crafted, fine-flavour chocolate from regular chocolate. This self-paced, on-demand video course is designed to guide you through the fascinating journey of chocolate—from its origins to the art of tasting like a professional.

For us, working out is about one thing: EMPOWERMENT. Exercise improves every aspect of our life. Join us for HIIT followed by cool down Yoga.

Gestalt therapy is a method of psychotherapy that helps you to focus on the present and realise what is really happening in your life right now, rather than only emphasising on past experiences. Instead of simply talking about past conditions, gestalt therapy encourages you to experience them through re-enactment. Janets introduces the gestalt therapy training course for anyone aspiring to or already working in this sector. It's also for anyone who is already working in this field and looking to brush up their knowledge and boost their career with a recognised certification. After taking the course, you'll have the skills and knowledge to perform effectively in this profession. Moreover, you will be introduced to Gestalt Therapy theory, including various techniques and beliefs of Gestalt. You will learn to use this therapy in sessions in the most effective manner, with practical guidance. This online Gestalt training course comprises 31 units that you can complete within 4 hours. Moreover, it is accompanied by instructional videos, practical illustrations, how-to instructions and advice. Also, you'll have 1-year access to this course that enables you to study at your speed from any corner of your choice. Why Choose this Course? Upon successful completion of this gestalt therapy course, you'll be able to:  Achieve certification (e-certificate upon successful completion) Get access to educational modules instructed by the experts Schedule a flexible study time, learn at your own pace, using your preferred device (computer, tablet, mobile, etc.) Receive instant feedback through mock tests and multiple-choice assessments Contact 24/7 help desk available via our email and live chat teams Find Teacher Support during weekdays Ascertain gestalt therapy principles and exercises Learn the gestalt therapy techniques Course Design The gestalt therapy training is delivered through our e-learning platform and accessible with any internet-connected device like computer, laptop, or smartphone. No formal deadlines or teaching schedules are included, ensuring a flexible study plan.  The experts will teach you via the following: Video tutoring Online study supplies Mock tests Multiple-choice evaluation Certification After completing the gestalt therapy training course successfully, you'll get an e-certificate. But, if you desire a print copy of the certificate, we can send it to you by post. For this, you will need to pay a minute amount of additional cost, which is £9.99 and PDF Certificate is available at £4.99. Who is this course for? Anyone wanting to gain comprehensive knowledge and inherent experience in this industry are suitable for this level 2 course. Therefore, no additional qualification is compulsory for the course. Besides, professionals from this field have designed this course that ensures its high quality. This makes the course an excellent opportunity for all enthusiasts from any backgrounds to attain in-depth knowledge of this profession.