44238 Courses

SQL for Data Science, Data Analytics and Data Visualization Course Overview: This course offers a comprehensive introduction to SQL, designed for those looking to enhance their skills in data science, data analytics, and data visualisation. Learners will develop the ability to work with SQL databases, efficiently query and manage data, and apply these techniques for data analysis in both SQL Server and Azure Data Studio. By mastering SQL statements, aggregation, filtering, and advanced commands, learners will be equipped with the technical skills required to manage large datasets and extract meaningful insights. The course provides a solid foundation in data structures, user management, and working with multiple tables, culminating in the ability to perform complex data analysis and visualisation tasks. Course Description: This course covers a broad range of topics essential for anyone working with data in a professional capacity. From setting up SQL servers to mastering database management tools like SQL Server Management Studio (SSMS) and SQL Azure Data Studio, the course provides a thorough grounding in SQL. Learners will gain expertise in data structure statements, filtering data, and applying aggregate functions, as well as building complex SQL queries for data analysis. The course also includes instruction on SQL user management, group by statements, and JOINs for multi-table analysis. Key topics such as SQL constraints, views, stored procedures, and database backup and restore are also explored. The course incorporates SQL visualisation tools in Azure Data Studio, empowering learners to visualise data effectively. By the end of the course, learners will be proficient in SQL queries, data manipulation, and using Azure for data analysis. SQL for Data Science, Data Analytics and Data Visualization Curriculum: Module 01: Getting Started Module 02: SQL Server Setting Up Module 03: SQL Azure Data Studio Module 04: SQL Database Basic SSMS Module 05: SQL Statements for DATA Module 06: SQL Data Structure Statements Module 07: SQL User Management Module 08: SQL Statement Basic Module 09: Filtering Data Rows Module 10: Aggregate Functions Module 11: SQL Query Statements Module 12: SQL Group By Statement Module 13: JOINS for Multiple Table Data Analysis Module 14: SQL Constraints Module 15: Views Module 16: Advanced SQL Commands Module 17: SQL Stored Procedures Module 18: Azure Data Studio Visualisation Module 19: Azure Studio SQL for Data Analysis Module 20: Import & Export Data Module 21: Backup and Restore Database (See full curriculum) Who is this course for? Individuals seeking to enhance their data management and analysis skills. Professionals aiming to progress in data science, data analytics, or database administration. Beginners with an interest in data analysis and SQL databases. Anyone looking to gain expertise in SQL for Azure and SQL Server environments. Career Path: Data Analyst Data Scientist Database Administrator SQL Developer Business Intelligence Analyst Data Visualisation Specialist

Course Description Get instant knowledge from this bite-sized Nanny Care Worker Part - 2 course. This course is very short and you can complete it within a very short time. In this Nanny Care Worker Part - 2 course you will get fundamental ideas of nanny care workers, the key understanding of nanny's job profile, time management for nannies and so on. Enrol in this course today and start your instant first step towards learning about early years provision. Learn faster for instant implementation. Learning Outcome Familiarise with early years provision Understand nanny's job profile Know how to establish a nanny's career Understand the time management for nannies Learn about establishing relationships and routines How Much Do Nanny Care Workers Earn? Senior - £29,000 (Apprx.) Average - £27,000 (Apprx.) Starting - £25,000 (Apprx.) Requirement Our Nanny Care Worker Part - 2 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. Nanny Care Worker Part - 2 Module 01: Early Years Provision 00:19:00 Module 02: Establishing Relationship and Routines 00:16:00 Module 03: Time Management for Nannies 00:18:00 Module 04: Nanny's Job Profile 00:30:00 Module 05: Establishing a Nanny's Career 00:20:00 Assignment Assignment - Nanny Care Worker Part - 2 00:00:00

Embark on a transformative journey with our Science-Based Bodyweight Workout course. Unleash your potential, sculpt muscles, and redefine fitness without the constraints of a gym.

We use it everyday but there are so many additional tools to save you time and make your work in Outlook more efficient and less stressful. Course overview Duration: 4 hours People tend to think they know how to use Outlook however there are so many lesser known features that can make working in Outlook so much more efficient. Simply understanding the layouts, how to turn things on and off and customising the environment to your preferences can save time and frustration. You then have search features, things such as conversation clean up and quick steps that can help to tidy up and organise what you do. Objectives  By the end of the course you will be able to: Customise Outlook to your preferences Manage email conversations Setup and use Quick Steps Create folders and organise information Setup rules Search for information Work effectively with calendars Content Customising the user interface Using the Navigation Pane and “To-do Bar” Setting folder pane options Adding favourites Peak preview Customising the quick access bar Setting reading pane and message preview Customizing email mail views Using the field chooser Email options Email conversations Conversation clean up Using Quick Steps Creating folders and organising information Setting email options Setting up rules Searching for information Using the Search bar Setting what to search for Setting where to search Searching for categories Adding more search options Working with calendars Setting what to view Using Schedule View Setting calendar options Weather bar Adding different time zones Adding meetings and appointments Setting up and using categories Opening other people’s calendars Setting calendar permissions Calendar groups Working with Tasks Lists Setting task options Adding and amending tasks Setting dates, deadlines and reminders Adding attachments to tasks Assigning tasks to others Flagging tasks Using and setting Quick Click Recurring tasks Flagging emails to appear on your task list Converting emails to tasks Converting tasks to calendar appointments

This course defines behavioural safety and explains the origins of the concept. It covers how it can be implemented in the workplace and some of the potential benefits. It includes analysis of some examples of 'at risk behaviours' and some examples of ways you can measure how well your organisation is doing when it comes to safety. Finally it touches on some of the key laws regarding health and safety in the workplace and how to ensure positive workforce attitudes.

Java Front-ends for desktop and mobile With Java FX Programming Java Front-ends for desktop and mobile With Java FX In this course we create attractive, functional Front-ends using JavaFX. Prerequisites: Delegates already have basic Java Skills. Duration: 2 consecutive days, the first date shows as the booking date Where: Online with Gotomeeting.com Download: Download Java JDK and Eclipse IDE. London classroom: on request locations, bring you own device Location: Online Interactive Instructor-led Webinar. Our Style: This is a very practical course giving you hands-on practice. Included: Course exercises, notes, examples, computers, evaluations Certification: PCWorkshops JavaFX Qualification Java Intermediate and Front-end Course Description Database Concepts Revision: DataBase SQL, database principles and JDBC GUI's with Java FX Building Java FX GUI's Course Contents: GUI's with JavaFX Building Java GUI's. Create a front-end form interface for an application. Working with nodes, labels, inputboxes, prgress bars, etc. Formatting your front-end. Import a Java package to interact with the front-end. Interact with a database via the front-end. Practical Examine the Java SE event model. What is an event. What is event handling. Develop event handlers. Develop Lambda-style event handlers. Practical Create a quotation app. Create a movie booking app. How to create your installer and upload your app Webservices Java Web services What are Web Services? Why Java Web Services? Web Services - Characteristics Web Services - Architecture Web Services - Examples and exercises What is included PCWorkshops Course Certificate on completion Java Course Notes Java Code Examples Practical Java Course exercises, Java Course Revision work After the course: 1-Hour personalised online revision session Book the Java Intermediate and Front-end Course Powered by Eventbrite About us Our experienced trainers are award winners. More about us FAQ's Client Comments

Sexual Harassment in the Workplace Course Overview This sexual harassment in the workplace 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. Sexual harassment is unwanted conduct of a sexual nature. Experiencing sexual harassment can be one of the most difficult situations a worker can face, however it should not be happening and all workers are protected by law from sexual harassment. Handling accusations of sexual harassment can be difficult, and if not done correctly can lead to the company being held liable along with the perpetrator of the harassment. This sexual harassment in the workplace course will start by defining sexual harassment and explaining how protection comes from both employment law and criminal law. You'll see from workplace statistics how widespread and serious the problem is, and how the management response to concerns raised is often poor or non-existent. It also addresses how allegations should be handled, explains the importance of having clear and robust policies and the role line managers tend to take when it comes to dealing with these situations. The sexual harassment in the workplace course also coves investigation from the employer's perspective, the role of employment tribunals, and concludes with some case studies that will give further insight into what constitutes harassment and the outcome of cases where the businesses did not act appropriately to deal with this behaviour. Who should take this course? This comprehensive sexual harassment in the workplace course is suitable for anyone looking to improve their job prospects or aspiring to accelerate their career in this sector and want to gain in-depth knowledge of sexual harassment in the workplace. This sexual harassment in the workplace course is felicitous for those, who want to be the best in their jobs. Whether you are completely new to the field or are an aspiring professional, the sexual harassment in the workplace course will help open doors to a wide range of professions within your chosen field, helping you to stand out to employers with up-to-date skills that can be used to enhance your CV. Entry Requirement There are no academic entry requirements for this sexual harassment in the workplace course, and it is open to students of all academic backgrounds. Course Curriculum Module 1: What Is Sexual Harassment Module 2: Examples and Research Module 3: Dealing With A Complaint Module 4: Policies and The Role of The Line Manager Module 5: Handling Sexual Harassment in the Workplace Module 6: The Law and Sexual Harassment Module 7: Case Studies 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. Quality Licence Scheme Endorsed The Quality Licence Scheme is a brand of the Skills and Education Group, a leading national awarding organisation for providing high-quality vocational qualifications across a wide range of industries. It will give you a competitive advantage in your career, making you stand out from all other applicants and employees.     Certificate of Achievement Endorsed Certificate from Quality Licence Scheme After successfully passing the MCQ exam you will be eligible to order the Endorsed Certificate by Quality Licence Scheme. The Quality Licence Scheme is a brand of the Skills and Education Group, a leading national awarding organisation for providing high-quality vocational qualifications across a wide range of industries. It will give you a competitive advantage in your career, making you stand out from all other applicants and employees. There is a Quality Licence Scheme endorsement fee to obtain an endorsed certificate which is £65. Certificate of Achievement from Lead Academy After successfully passing the MCQ exam you will be eligible to order your certificate of achievement as proof of your new skill. The certificate of achievement is an official credential that confirms that you successfully finished a course with Lead Academy. Certificate can be obtained in PDF version at a cost of £12, and there is an additional fee to obtain a printed copy certificate which is £35. 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

Duration 1 Days 6 CPD hours This course is intended for Everyone dealing with day to day work environment Overview Wherever two or more people come together, there is bound to be conflict. This course will give participants a seven-step conflict resolution process that they can use and modify to resolve conflict disputes of any size. Participants will also learn crucial conflict management skills, including dealing with anger and using the Agreement Frame. Participants will learn crucial conflict management skills, including dealing with anger and using the Agreement Frame. If left unchecked or not resolved it can lead to lost production, absences, attrition, and even law suits. Getting Started Icebreaker Housekeeping Items The Parking Lot Workshop Objectives An Introduction to Conflict Resolution What is Conflict? What is Conflict Resolution? Understanding the Conflict Resolution Process The Thomas-Kilmann Instrument Collaborating Competing Compromising Accommodating Avoiding Creating an Effective Atmosphere Neutralizing Emotions Setting Ground Rules Choosing the Time and Place Creating Mutual Understanding What do I Want? What Do They Want? What Do We Want? Focusing on Individual Needs Finding Common Ground Building Positive Energy and Goodwill Strengthening Your Partnership Getting to the Root Cause Examining Root Causes Creating a Cause and Effect Diagram The Importance of Forgiveness Identifying the Benefits of Resolution Generating Options Generate, Don't Evaluate Creating Mutual Gain Options and Multiple Option Solutions Digging Deeper into Your Options Building a Solution Creating Criteria Creating a Shortlist Choosing a Solution Building a Plan The Short Version of the Process Evaluating the Situation Choosing Your Steps Creating an Action Plan Using Individual Process Steps Additional Tools Stress and Anger Management Techniques The Agreement Frame Asking Open Questions Wrapping Up Words from the Wise Review of Parking Lot Lessons Learned Completion of Action Plans

This course will help you support students having SEN in their early years, child abuse, and the legal framework for child safeguarding. You will comprehend the teaching style that is required to teach students aged 0-5, and understand the legal and updated frameworks of EYFS, the EYFS cycle and safeguarding. This Course At A Glance Accredited by CPD UK Endorsed by Quality Licence Scheme Know how to start your role as a teaching assistant Know how to create a supportive learning environment Master the art of teaching and learn ways to design an effective portfolio Demonstrate the statutory and legal framework for SEN, safeguarding and EYFS Understand the teaching strategies and methods to teach children with SEN as well as children aged 0-5 Know how to develop an inclusive education for children with SEN Understand how to support children with SEN and children aged 0-5 Learn the principles, theories benefits, exemptions and cycle of EYFS Identify the children in need and know how to report concerns related to child safeguarding Recognise child abuse and understand the child safeguarding standards Gain knowledge about key organisations and tips on child safeguarding Know how to design an effective assessment for children in need Complete Teaching Assistant Diploma (TA, SEN, EYFS and Child Safeguarding) Course Overview This Complete Diploma in Teaching Assistant Course is suitable for teaching assistants who teach children with SEN as well as those who do not or for those who want to start and advance their careers as competent teaching assistants and EYFS instructors. This course will help you gain an overall understanding and knowledge to teach children of all ages and kinds. You will understand how to start your role as a teaching assistant and create a supportive learning environment for all students. Along with a variety of teaching strategies, approaches, and techniques for children with special educational needs, you'll learn how to develop inclusive whole-school policies and procedures for SEN. This course will guide you in designing your portfolio to apply for any teaching job, and understand the SEN frameworks and function of the board of management. In the end, you will acquire knowledge about key organisations and tips on child safeguarding, as well as how to report concerns associated with child safeguarding. Upon successful completion of this Complete Diploma in Teaching Assistant Course, you will be able to teach children of all ages and types and gain the complete knowledge and skills required to drive a successful career in the teaching field. Who should take this course? This Complete Diploma in Teaching Assistant Course is primarily aimed at: SENco Parents SEN tutor SEN teaching assistant Teaching Staff / School Staff Teaching Assistant Aspiring Teaching Assistant Childcare Provider Staff Mental Health Professionals Healthcare Assistant Social Care Workers Learning Support Assistant Teachers responsible for teaching children ages 0-5 This course is not, however, limited to a single industry or profession. Anyone who desires to thoroughly understand each element and teaching method can also take this course. Entry Requirements There are no academic entry requirements for this Complete Diploma in Teaching Assistant Course, and it is open to students of all academic backgrounds. However, you are required to have a laptop/desktop/tablet or smartphone and a good internet connection. Assessment Method This Complete Diploma in Teaching Assistant Course assesses learners through multiple-choice questions (MCQs). Upon successful completion of the modules, learners must answer MCQs to complete the assessment procedure. Through the MCQs, it is measured how much a learner could grasp from each section. In the assessment pass mark is 60%. Course Curriculum Introduction to Complete Teaching Assistant Diploma Course (TA SEN EYFS and Child Safeguarding) Introduction to Complete Teaching Assistant Diploma Course (TA SEN EYFS and Child Safeguarding) Starting Your Role As A Teaching Assistant Starting Your Role As A Teaching Assistant Becoming A Part Of The School Becoming A Part Of The School A Supportive Learning System A Supportive Learning System The Art Of Teaching The Art Of Teaching Culturing Your Presence Culturing Your Presence The School Curriculums The School Curriculums Understanding The Pupils Understanding The Pupils Your Portfolio As A Teaching Assistant Your Portfolio As A Teaching Assistant Improving Yourself Further Improving Yourself Further Communication Interaction Difficulties in Children with SEN Communication Interaction Difficulties in Children with SEN Cognition Learning Difficulties Cognition Learning Difficulties Social, Behavioural and Emotional Health Difficulties Social, Behavioural and Emotional Health Difficulties Sensory and Physical Needs Sensory and Physical Needs Legislation and Principles Legislation and Principles Information, Advice and Support Information, Advice and Support Working Together Working Together Early Years Providers Early Years Providers EYFS EYFS Primary Secondary Education Primary Secondary Education Further Education Further Education Preparation For Adulthood Preparation For Adulthood EHC Assessments and Plans EHC Assessments and Plans Equality, Diversity Inclusion Equality, Diversity Inclusion SEN Children Young People in Specific Circumstances SEN Children Young People in Specific Circumstances Disagreement Resolutions Disagreement Resolutions Education Planning for Individual Students Education Planning for Individual Students EYFS Statutory Framework EYFS Statutory Framework Working as an EYFS Teacher in the UK Working as an EYFS Teacher in the UK EYFS Teaching Methods EYFS Teaching Methods Principles and Theories of EYFS Principles and Theories of EYFS The EYFS Cycle The EYFS Cycle How to Support Children having Special Education Needs in Early Years How to Support Children having Special Education Needs in Early Years Safeguarding Child Welfare & Safety in the EYFS Safeguarding Child Welfare & Safety in the EYFS Adults Role in Early Years Foundation Stage Adults Role in Early Years Foundation Stage The EYFS and Educational Philosophies, Benefits and Exemptions The EYFS and Educational Philosophies, Benefits and Exemptions Early Years Ofsted Inspection and Quality Enhancement Early Years Ofsted Inspection and Quality Enhancement The New Version of the EYFS Framework The New Version of the EYFS Framework Understanding Child Safeguarding Understanding Child Safeguarding Child Abuse Child Abuse Legal Framework for Child Safeguarding Legal Framework for Child Safeguarding Recognition of Children in Need Recognition of Children in Need Effective Assessment of Children in Need Effective Assessment of Children in Need Safeguarding Arrangements Safeguarding Arrangements Child Safeguarding Standards Child Safeguarding Standards Key Organisations and Tips for Child Safeguarding Key Organisations and Tips for Child Safeguarding Recording Information Recording Information Conclution to Complete Teaching Assistant Diploma Course (TA SEN EYFS and Child Safeguarding) Conclution to Complete Teaching Assistant Diploma Course (TA SEN EYFS and Child Safeguarding) 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. Quality Licence Scheme Endorsed The Quality Licence Scheme is a brand of the Skills and Education Group, a leading national awarding organisation for providing high-quality vocational qualifications across a wide range of industries. It will give you a competitive advantage in your career, making you stand out from all other applicants and employees.     Certificate of Achievement Endorsed Certificate from Quality Licence Scheme After successfully passing the MCQ exam you will be eligible to order the Endorsed Certificate by Quality Licence Scheme. The Quality Licence Scheme is a brand of the Skills and Education Group, a leading national awarding organisation for providing high-quality vocational qualifications across a wide range of industries. It will give you a competitive advantage in your career, making you stand out from all other applicants and employees. There is a Quality Licence Scheme endorsement fee to obtain an endorsed certificate which is £65. Certificate of Achievement from Lead Academy After successfully passing the MCQ exam you will be eligible to order your certificate of achievement as proof of your new skill. The certificate of achievement is an official credential that confirms that you successfully finished a course with Lead Academy. Certificate can be obtained in PDF version at a cost of £12, and there is an additional fee to obtain a printed copy certificate which is £35. 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 Description Get instant knowledge from this bite-sized Domiciliary Care Support Worker: Part 2 course. This course is very short and you can complete it within a very short time. In this Domiciliary Care Support Worker: Part 2 course you will get fundamental ideas of domiciliary care, the key understanding of CSTF information governance and so on. Enrol in this course today and start your instant first step towards learning about medication management and administration. Learn faster for instant implementation. Learning outcome  Familiarise with medication management and administration Understand CSTF information governance Gain in-depth knowledge of CSTF conflict resolution Learn about mental health care How Much Do Domiciliary Care Workers Earn? Senior - £23,000(Appx.) Average - £18,000(Appx.) Starting - £17,000(Appx.) Requirement Our Domiciliary Care Support Worker: Part 2 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. Domiciliary Care Support Worker: Part 2 Module 01: Medication Management and Administration 00:18:00 Module 02: CSTF Information Governance 00:25:00 Module 03: CSTF Conflict Resolution 00:20:00 Module 04: Mental Health Care 00:23:00 Assignment Assignment - Domiciliary Care Support Worker: Part 2 00:00:00