12540 Courses delivered Online

This SENCO - level 3 course is designed for those interested in or who are currently in a SENCO role in the early years setting. This SENCO - level 3 qualification provides learners with a thorough understanding of the roles and responsibilities of the Special Educational Needs Coordinator in early years setting. Learn about the strategies and techniques for assisting children and their families and gain in-depth knowledge of SEN codes of practice. The purpose of this course is to help learners progress to further and higher education and develop new practical skills in health and social care. Learning Outcomes After completing this SENCO - level 3 course, the learner will be able to: Understand the roles and responsibilities of the Special Educational Needs Coordinator in the early years setting. Understand the strategies and techniques for supporting children and their families. Increase knowledge of SEN codes of practice. Why Choose Special Educational Needs Coordination Course from Us Self-paced course, access available from anywhere. Easy to understand, high-quality study materials. Course developed by industry experts. MCQ quiz after each module to assess your learning. Automated and instant assessment results. 24/7 support via live chat, phone call or email. Free PDF certificate as soon as completing the course. ***Courses are included in this SENCO - level 3 Course*** Course 01: SENCO : SENCO - level 3 Course 02: Level 3 Certificate in Understanding Autism Course 03: Level 4 Child Care and Development Course ***Other Benefits of thisCourse*** Free 3 PDF Certificate Access to Content - Lifetime Exam Fee - Totally Free Free Retake Exam [ Note: Free PDF certificate as soon as completing the course ] Detailed course curriculum Module 1: Roles and Responsibilities of the Special Educational Needs Coordinator in the Early Years Understand the principles, statutory guidance and legislation underpinning practice for children with Special Educational Needs and Disability (SEND) in an early years setting Understand the role of the Early Years Special Educational Needs Coordinator (SENCo) Understand partnership working for the Early Years SENCo Understand early identification and action for children with SEND Module 2: Strategies and Techniques for Supporting Children and Families Understand the graduated approach in an early years setting Understand English as an additional language (EAL) Understand Education, Health and Care (EHC) plans ------------------------- ***Level 3 Certificate in Understanding Autism Course Curriculum Module 1: Autism in Context Module 2: Positive Behavioural Support for Individuals with Autism Module 3: Understand Support and Management of Transitions for Individuals with Autism Module 4: Therapeutic Interventions and Support Available for Individuals with Autism and Co- occurring Conditions Module 5: Communication and Social Interaction with Individuals with Autism Module 6: Safeguarding and Resilience in Autism ------------------------- ***Level 4 Child Care and Development Course Course Curriculum Module 01: Few Basic Things to Keep in Mind Module 02: Caring for newborn Babies Module 03: Feeding Module 04: Nutrition and Health Module 05: Health Concerns Module 06: First Aid and Emergency Module 07: Raising Mentally Healthy Children Module 08: Sex Education Module 09: Common Developmental and Behavioral Challenges Assessment Method After completing each module of the SENCO - level 3, you will find automated MCQ quizzes. To unlock the next module, you need to complete the quiz task and get at least 60% marks. Once you complete all the modules in this manner, you will be qualified to request your certification. Certification After completing the MCQ/Assignment assessment for this SENCO - level 3 course, you will be entitled to a Certificate of Completion from Training Tale. It will act as proof of your extensive professional development. The certificate is in PDF format, which is completely free to download. A printed version is also available upon request. It will also be sent to you through a courier for £13.99. Who is this course for? This SENCO : SENCO - level 3 course is ideal for those already working in a SENCO role as part of their Early Years Practitioner role or interested in doing so. This course is also suitable for childminders. Requirements There are no specific requirements for this SENCO : SENCO - level 3 course because it does not require any advanced knowledge or skills. Students who intend to enrol in this SENCO : SENCO - level 3 course must meet the following requirements: Good command of the English language Must be vivacious and self-driven Basic computer knowledge A minimum of 16 years of age is required Career path This SENCO : SENCO - level 3 course is appropriate for those who want to work in the following fields: Health and social care Childhood studies Community, youth and families Social work Early years Primary teaching Nursing Certificates Certificate of completion Digital certificate - Included

Working with young people is no walk in the park — it takes patience, skill, and a good sense of humour. The Level 2 Youth Work Certificate Course is designed to give learners a solid grounding in the key knowledge and approaches used by youth workers in today’s communities. Whether you're supporting teens in schools, clubs, or community groups, this course helps you understand what makes them tick — and how to actually get through to them. From communication techniques to safeguarding responsibilities, you'll explore a variety of essential topics relevant to youth engagement. This course is ideal for those looking to enter the youth sector or sharpen their understanding of how to connect with and support young people in meaningful ways. It’s all online, self-paced, and available wherever you are — so you can study without rearranging your entire life. Learning Outcomes: Understand the role and methods of a youth worker Identify legal responsibilities in youth work Explore the social influences on young people Understand the relationship between youth work and mental health Analyse the connection between youth work and criminal justice Explore career options in social work Meet the Accreditation CPD Quality Standards (CPD QS) accreditation assure the Level 2 Youth Work Certificate course training and learning activities are relevant, reliable, and upto date. Expert Support Dedicated tutor support and 24/7 customer support are available to all students with this premium quality course. Key Benefits Free PDF Certificate 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) Please note: This course only gives you the theoretical knowledge you need to excel in this field. This Level 2 Youth Work Certificate training course doesn't entitle you to practise as a professional in this specific field. This course is designed by industry experts and will give you an in-depth understanding of this topic. The Level 2 Youth Work Certificate course features easy-to-digest modules that break down each topic and ensure all our students receive an unrivalled and thorough learning experience. Enjoy a pleasant and professional 100% online learning experience and enrol the course today and take control of your career! Course Assessment To simplify the procedure of evaluation and accreditation for learners, we provide an automated assessment system. Upon completion of an online module, you will immediately be given access to a specifically crafted MCQ test. The results will be evaluated instantly, and the score will be displayed for your perusal. For each test, the pass mark will be set to 60%. When all tests have been successfully passed, you will be able to order a certificate endorsed by the Quality Licence Scheme. 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). CPD 10 CPD hours / points Accredited by CPD Quality Standards Who is this course for? Individuals interested in pursuing a career in youth work Individuals passionate about social justice and empowering young people Individuals who want to make a difference in the lives of young people Requirements This Level 2 Youth Work Certificate course is open to all, with no formal entry requirements. Career path After completing the Course, learners will be fit with many essential skills and have the opportunity to grab, such as: Youth Worker - £20,000 to £32,000 per annum Social Worker - £24,000 to £40,000 per annum Counsellor - £20,000 to £40,000 per annum Probation Officer - £23,000 to £36,000 per annum Family Support Worker - £18,000 to £28,000 per annum Outreach Worker - £18,000 to £28,000 per annum

Looking to bring your AI knowledge to life in a visually powerful way? Our Hands-on Machine Learning Project – Auto Image Captioning for Social Media Course takes you deep into the fascinating world of machine-generated descriptions. With social media driving more engagement through visuals than ever, this course helps you grasp how AI can generate captions that not only describe but also engage, contextualise, and communicate effectively. The focus is sharply tuned to image captioning technology and its role in today’s media-driven, attention-tight landscape. Expect to work your way through a structured learning journey where you’ll explore the building blocks of machine learning and how these elements are applied in automated image captioning. Whether you're aiming to polish your ML project portfolio or understand how AI is quietly shaping the way content is created and consumed online, this course gives you just the right amount of edge — no gimmicks, no fluff, just what matters. All content is delivered fully online, making it a flexible and accessible way to deepen your understanding of AI-powered communication tools used across social media platforms. Learning Outcomes: Develop an auto image captioning system using machine learning. Preprocess image and caption data. Define and evaluate the model. Deploy your machine learning app on AWS EC2 instance.Gain real-world experience in machine learning app development. The Hands-on Machine Learning Project - Auto Image Captioning for Social Media Platform course is designed to give you a comprehensive understanding of how to develop an auto image captioning system using machine learning. The course covers topics such as importing libraries, preprocessing text and image data, defining and evaluating the model, and deploying your machine learning app on AWS EC2 instance. You'll have access to the caption dataset and image dataset for training and test purposes, providing you with hands-on experience in machine learning app development. This course is perfect for aspiring data scientists, machine learning engineers, and developers who want to gain real-world experience in machine learning app development. With the skills and knowledge gained from this course, you'll be able to create your own auto image captioning system and start a career in the exciting field of machine learning. Hands on Machine Learning Project - Auto Image Captioning for Social Media Course Curriculum Section 01: Introduction Introduction to Course Section 02: Building the Auto Image Captioning Import the Libraries Accessing the Caption Dataset for Training Accessing the Image DataSet for Training Preprocessing the Text Data Pre-Process and Load Captions Data Loading the Captions for Training and Test Data Preprocessing of Image Data Loading Features for Train and Test Dataset Text Tokenization and Sequence Text Data Generators Define the Model Evaluation of Model Test the Model Section 03: Deployment of Machine Learning App Create Streamlit App Streamlit Prediction Test Streamlit App Deploy Streamlit on AWS EC2 Instance How is the course assessed? Upon completing an online module, you will immediately be given access to a specifically crafted MCQ test. For each test, the pass mark will be set to 60%. 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 __ GBP. £9 for PDF Certificate and £15 for the Hardcopy Certificate within the UK ( An additional £10 postal charge will be applicable for international delivery). CPD 10 CPD hours / points Accredited by CPD Quality Standards Who is this course for? Aspiring data scientists. Machine learning engineers. Developers interested in machine learning app development. Anyone interested in the field of machine learning. Professionals looking to upskill in the latest technology. Requirements There are no formal entry requirements for the course, with enrollment open to anyone! Career path Data Scientist: £40,000 to £80,000 per year. Machine Learning Engineer: £55,000 to £90,000 per year. Software Developer: £30,000 to £60,000 per year. Artificial Intelligence Developer: £40,000 to £80,000 per year. Computer Vision Engineer: £45,000 to £85,000 per year. Certificates Certificate of completion Digital certificate - £9 You can apply for a CPD Accredited PDF Certificate at the cost of £9. Certificate of completion Hard copy certificate - £15 Hard copy can be sent to you via post at the expense of £15.

If you are considering a career in child care then this Entry Level 2 Extended Award in Skills for working in Child Care course is perfect for you. It could also help you re-engage with learning and remove barriers to entering the childcare workforce. The L2 Extended Award in Skills for Working in Child Care Industries course provides a thorough understanding of the knowledge and skills required to care for young children. It includes the growth, learning, and development of children. The course also covers developing assertiveness, relationships and behaviour in the workplace. Learning Outcomes After completing this L2 Extended Award in Skills for Working in Child Care Industries course, learner will be able to: Gain a solid understanding of food & nutrition for children Know how to prepare food for children Understand child development using toys/plays materials Gain in-depth knowledge about human growth & development Understand developing assertiveness Understand relationships & behaviour in the workplace Why Choose Entry Level 2 Extended Award in Skills for Working in Child Care Industries Course from Us Self-paced course, access available from anywhere. Easy to understand, high-quality study materials. Course developed by industry experts. MCQ quiz after each module to assess your learning. Automated and instant assessment results. 24/7 support via live chat, phone call or email. Free PDF certificate as soon as completing the course. ***Others Benefits of this Course Free One PDF Certificate Lifetime Access Unlimited Retake Exam Tutor Support [ Note: Free PDF certificate as soon as completing the course ] Detailed Course Curriculum of this Module 1: Food & Nutrition For Children Know about food and nutrition for babies and children An example of suitable food for a new-born babyAn example of suitable food for a child 1-2 yearsAn example of unsuitable food for babies and children Module 2: Prepare Food For Children Be able to prepare food safely and hygienically Be able to prepare food for children Module 3: Child Development Using Toys/Plays Materials Know about the physical development of children from 0-3 years Know about toys/play materials which support a child's physical development Module 4: Human Growth & Development Know about key changes from birth to old age Know about factors affecting growth Module 5: Developing Assertiveness Know about the benefits of assertiveness Know about ways of being assertive Module 6: Relationships & Behaviour In The Workplace Know about different roles in a workplace Know about equal opportunities in the workplace Assessment Method After completing each module of the L2 Extended Award in Skills for Working in Child Care Industries, you will find automated MCQ quizzes. To unlock the next module, you need to complete the quiz task and get at least 60% marks. Once you complete all the modules in this manner, you will be qualified to request your certification. Certification After completing the MCQ/Assignment assessment for this L2 Extended Award in Skills for Working in Child Care Industries course, you will be entitled to a Certificate of Completion from Training Tale. It will act as proof of your extensive professional development. The certificate is in PDF format, which is completely free to download. A printed version is also available upon request. It will also be sent to you through a courier for £13.99. Who is this course for? This L2 Extended Award in Skills for Working in Child Care Industriescourse is ideal for anyone interested in learning about working in Child Care and Education or assisting with the development of young children in a nursery, child care, or primary school setting. Requirements There are no specific requirements for this course because it does not require any advanced knowledge or skills. Students who intend to enrol in this course must meet the following requirements: Good command of the English language Must be vivacious and self-driven Basic computer knowledge A minimum of 16 years of age is required Career path This course may lead you to a variety of career opportunities in the childcare industry. Such as: Nursery Childcare and Education Early Years Education Certificates Certificate of completion Digital certificate - Included

This SENCO - Special Educational Needs Coordination course is designed for those interested in or who are currently in a Special Educational Needs Coordination role in the early years setting. This SENCO qualification provides learners with a thorough understanding of the roles and responsibilities of the Special Educational Needs Coordinator in early years setting. Learn about the strategies and techniques for assisting children and their families and gain in-depth knowledge of SEN codes of practice. The purpose of thiscourse is to help learners progress to further and higher education and develop new practical skills in health and social care. Learning Outcomes After completing this Special Educational Needs Coordination course, the learner will be able to: Understand the roles and responsibilities of the Special Educational Needs Coordinator in the early years setting. Understand the strategies and techniques for supporting children and their families. Increase knowledge of SEN codes of practice. Why Choose SENCO Course from Us Self-paced course, access available from anywhere. Easy to understand, high-quality study materials. Course developed by industry experts. MCQ quiz after each module to assess your learning. Automated and instant assessment results. 24/7 support via live chat, phone call or email. Free PDF certificate as soon as completing the course. ***Courses are included in this SENCO - Special Educational Needs Coordination Course*** Course 01: SENCO - Special Educational Needs Coordination Course 02: Level 2 Certificate in Understanding Common Childhood Illnesses Affecting Children Course 03: Care and support for Vulnerable Children ***Other Benefits of this Course*** Free 3 PDF Certificate Access to Content - Lifetime Exam Fee - Totally Free Free Retake Exam [ Note: Free PDF certificate as soon as completing the course ] Course Curriculum Module 1: Roles and Responsibilities of the Special Educational Needs Coordinator in the Early Years Understand the principles, statutory guidance and legislation underpinning practice for children with Special Educational Needs and Disability (SEND) in an early years setting Understand the role of the Early Years Special Educational Needs Coordinator (SENCo) Understand partnership working for the Early Years SENCo Understand early identification and action for children with SEND Module 2: Strategies and Techniques for Supporting Children and Families Understand the graduated approach in an early years setting Understand English as an additional language (EAL) Understand Education, Health and Care (EHC) plans ------------------------- ***Level 2 Certificate in Understanding Common Childhood Illnesses Affecting Children Course Curriculum Module 1: Understand How to Provide a Safe and Healthy Environment for Babies and Young Children Module 2: Understand Common Childhood Illnesses Module 3: Understand Health Emergencies and Specific Health Conditions in an Early Years Setting ------------------------- ***Care and support for Vulnerable Children Course Curriculum Module 01: Introduction Module 02: The Rights of Children Module 03: Understanding the Distinction Between Vulnerability and Risk Module 04: Child in Crisis Module 05: Controlling The Issues Module 06: Available Services Module 07: History and Future Developments Assessment Method After completing each module of the Special Educational Needs Coordination, you will find automated MCQ quizzes. To unlock the next module, you need to complete the quiz task and get at least 60% marks. Once you complete all the modules in this manner, you will be qualified to request your certification. Certification After completing the MCQ/Assignment assessment for this SENCO course, you will be entitled to a Certificate of Completion from Training Tale. It will act as proof of your extensive professional development. The certificate is in PDF format, which is completely free to download. A printed version is also available upon request. It will also be sent to you through a courier for £13.99. Who is this course for? This SENCO - Special Educational Needs Coordination course is ideal for those already working in a SENCO - Special Educational Needs Coordination role as part of their Early Years Practitioner role or interested in doing so. This course is also suitable for childminders. Requirements There are no specific requirements for this Special Educational Needs Coordination course because it does not require any advanced knowledge or skills. Students who intend to enrol in this course must meet the following requirements: Good command of the English language Must be vivacious and self-driven Basic computer knowledge A minimum of 16 years of age is required Career path This SENCO course is appropriate for those who want to work in the following fields: Health and social care Childhood studies Community, youth and families Social work Early years Primary teaching Nursing Certificates Certificate of completion Digital certificate - Included

Are you looking to enhance your Enhancing Customer Experiences skills? If yes, then you have come to the right place. Our comprehensive course on Enhancing Customer Experiences will assist you in producing the best possible outcome by mastering the Enhancing Customer Experiences skills. The Enhancing Customer Experiences is for those who want to be successful. In the Enhancing Customer Experiences, you will learn the essential knowledge needed to become well versed in Enhancing Customer Experiences. Our Enhancing Customer Experiences starts with the basics of Enhancing Customer Experiences and gradually progresses towards advanced topics. Therefore, each lesson of this Enhancing Customer Experiences is intuitive and easy to understand. Why would you choose the Enhancing Customer Experiences from Compliance Central: Lifetime access to Enhancing Customer Experiences materials Full tutor support is available from Monday to Friday with the Enhancing Customer Experiences Learn Enhancing Customer Experiences skills at your own pace from the comfort of your home Gain a complete understanding of Enhancing Customer Experiences Accessible, informative Enhancing Customer Experiences learning modules designed by expert instructors Get 24/7 help or advice from our email and live chat teams with the Enhancing Customer Experiences bundle Study Enhancing Customer Experiences in your own time through your computer, tablet or mobile device. A 100% learning satisfaction guarantee with your Enhancing Customer Experiences Improve your chance of gaining in demand skills and better earning potential by completing the Enhancing Customer Experiences Learn at your own pace from the comfort of your home, as the rich learning materials of this course are accessible from any place at any time. The curriculums are divided into tiny bite-sized modules by industry specialists. And you will get answers to all your queries from our experts. Enhancing Customer Experiences Curriculum Summary: Importance of Enhancing Customer Experiences Service Assistant Providing 'Concierge' Level Of Service The 5 Tenets Of Total Quality Management How To Boost Customer Satisfaction How To Avoid The 10 Deadly Sins Of Enhancing Customer Experiences! More Money - Through Customer Retention Dealing With Difficult Customers CPD 10 CPD hours / points Accredited by CPD Quality Standards Who is this course for? The Enhancing Customer Experiences helps aspiring professionals who want to obtain the knowledge and familiarise themselves with the skillsets to pursue a career in Enhancing Customer Experiences. It is also great for professionals who are already working in Enhancing Customer Experiences and want to get promoted at work. Requirements To enrol in this Enhancing Customer Experiences, all you need is a basic understanding of the English Language and an internet connection. Career path The Enhancing Customer Experiences will enhance your knowledge and improve your confidence in exploring opportunities in various sectors related to Enhancing Customer Experiences. Certificates CPD Accredited Certificate of Completion Free Digital certificate - Included CPD Accredited PDF Certificate CPD Accredited Certificate of Completion Free Hard copy certificate - £10.79 CPD Accredited Hard Copy Certificate Delivery Charge: Inside the UK: Free Outside of the UK: £9.99 each

Are you looking to enhance your Learning Support Assistant (LSA) skills? If yes, then you have come to the right place. Our comprehensive course on Learning Support Assistant (LSA) will assist you in producing the best possible outcome by mastering the Learning Support Assistant (LSA) skills. The Learning Support Assistant (LSA) course is for those who want to be successful. In the Learning Support Assistant (LSA) course, you will learn the essential knowledge needed to become well versed in Learning Support Assistant (LSA). Our Learning Support Assistant (LSA) course starts with the basics of Learning Support Assistant (LSA) and gradually progresses towards advanced topics. Therefore, each lesson of this Learning Support Assistant (LSA) course is intuitive and easy to understand. Why would you choose the Learning Support Assistant (LSA) course from Compliance Central: Lifetime access to Learning Support Assistant (LSA) course materials Full tutor support is available from Monday to Friday with the Learning Support Assistant (LSA) course Learn Learning Support Assistant (LSA) skills at your own pace from the comfort of your home Gain a complete understanding of Learning Support Assistant (LSA) course Accessible, informative Learning Support Assistant (LSA) learning modules designed by experts Get 24/7 help or advice from our email and live chat teams with the Learning Support Assistant (LSA) Study Learning Support Assistant (LSA) in your own time through your computer, tablet or mobile device A 100% learning satisfaction guarantee with your Learning Support Assistant (LSA) Course Learning Support Assistant (LSA) Curriculum Breakdown of the Learning Support Assistant (LSA) Course Module 01: The Roles of a Learning Support Assistant (LSA) Module 02: Working with Children in a School Module 03: Assessing Students Module 04: Skills of a Learning Support Assistant Module 05: Providing for All Children Module 06: Safeguarding and Wellbeing of Children and Young People Module 07: Dealing with Emergencies Module 08: Special Educational Needs (SEN) Module 09: Professional Development Module 10: Time and Stress Management CPD 10 CPD hours / points Accredited by CPD Quality Standards Who is this course for? The Learning Support Assistant (LSA) course helps aspiring professionals who want to obtain the knowledge and familiarise themselves with the skillsets to pursue a career in Learning Support Assistant (LSA). It is also great for professionals who are already working in Learning Support Assistant (LSA) and want to get promoted at work. Requirements To enrol in this Learning Support Assistant (LSA) course, all you need is a basic understanding of the English Language and an internet connection. Career path The Learning Support Assistant (LSA) course will enhance your knowledge and improve your confidence in exploring opportunities in various sectors related to Learning Support Assistant (LSA). Learning Support Assistant (LSA): £17,000 to £22,000 per year Special Educational Needs (SEN) Teaching Assistant: £16,000 to £25,000 per year Certificates CPD Accredited PDF Certificate Digital certificate - Included CPD Accredited PDF Certificate CPD Accredited Hard Copy Certificate Hard copy certificate - £10.79 CPD Accredited Hard Copy Certificate Delivery Charge: Inside the UK: Free Outside of the UK: £9.99 each

A Complete Guide for Effective LinkedIn Ads' is a comprehensive course that covers the fundamentals of setting up and managing successful LinkedIn Ads campaigns. Participants will learn to drive website traffic, utilize sponsored messages, generate leads, and effectively manage billing centers on the platform. Learning Outcomes: Understand the basics of LinkedIn Ads and their role in digital marketing. Learn how to set up LinkedIn Ads to drive targeted website traffic. Discover techniques for leveraging sponsored messages to engage with the audience. Acquire the skills to create and optimize LinkedIn Ads for lead generation. Gain proficiency in managing the billing center for efficient campaign budgeting and monitoring. Why buy this Excel VBA/Macros Foundations? Unlimited access to the course for forever Digital Certificate, Transcript, student ID all included in the price Absolutely no hidden fees Directly receive CPD accredited qualifications after course completion Receive one to one assistance on every weekday from professionals Immediately receive the PDF certificate after passing Receive the original copies of your certificate and transcript on the next working day Easily learn the skills and knowledge from the comfort of your home Certification After studying the course materials of the Excel VBA/Macros Foundations there will be a written assignment test which you can take either during or at the end of the course. After successfully passing the test you will be able to claim the pdf certificate for £5.99. Original Hard Copy certificates need to be ordered at an additional cost of £9.60. Who is this course for? This Excel VBA/Macros Foundations course is ideal for Students Recent graduates Job Seekers Anyone interested in this topic People already working in the relevant fields and want to polish their knowledge and skill. Prerequisites This Excel VBA/Macros Foundations does not require you to have any prior qualifications or experience. You can just enrol and start learning.This Excel VBA/Macros Foundations was made by professionals and it is compatible with all PC's, Mac's, tablets and smartphones. You will be able to access the course from anywhere at any time as long as you have a good enough internet connection. Career path As this course comes with multiple courses included as bonus, you will be able to pursue multiple occupations. This Excel VBA/Macros Foundations is a great way for you to gain multiple skills from the comfort of your home. Course Curriculum Section 01: Introduction Recording Macros vs Writing VBA 00:04:00 Understanding Objects in Excel VBA 00:07:00 Understanding VBA Syntax and Parts of Speech 00:10:00 Activating the Developer tab 00:01:00 Recording a basic Macro 00:05:00 Absolute vs Relative Macro recording 00:04:00 Section 02: Exploring the Visual Basic Environment Introduction to the Visual Basic Environment 00:02:00 The Project Explorer 00:02:00 The Properties Window 00:02:00 The Code Window 00:04:00 Immediate, Locals and Watch Window 00:03:00 Dealing with Modules 00:03:00 Comments in Excel VBA 00:01:00 Section 03: The Range Object Introduction and Changing Cell Values 00:10:00 Adding a text to a cell 00:01:00 Dealing with Named Ranges 00:03:00 Value vs Text Property 00:04:00 Row and Column properties 00:02:00 The Select Method 00:02:00 The Count Property 00:04:00 The Address Property 00:09:00 The Formula Property 00:03:00 The Number Format Property 00:07:00 The Font Property 00:08:00 Section 04: Understanding the Cells Collection Object What is the cells object? 00:06:00 Using the Cells collection to affect cells positionally within a range 00:05:00 Affecting all cells within a sheet 00:02:00 Combining Range and cells objects 00:03:00 Section 05: Working with Sheets/Worksheets Selecting Sheets 00:06:00 Adding Sheets 00:11:00 Sheets vs Worksheets 00:04:00 Copying Sheets 00:05:00 Moving Sheets 00:01:00 Deleting Sheets 00:04:00 Section 06: Understanding Variables in Excel VBA Introduction to Variables 00:06:00 Variable Data Types 00:09:00 Declaring Variables 00:14:00 Object Variables 00:08:00 Calling a procedure from Another Procedure & Variable Scope 00:03:00 Public and Private Variables 00:07:00 Declaring Constants 00:04:00 Exercises-Variables 00:06:00 Section 07: Dealing with Workbooks Referring to Workbooks-Different ways 00:04:00 Closing Workbooks 00:03:00 Adding and Saving Workbooks Part 1 - Save method 00:04:00 Adding and Saving Workbooks Part 2 - Save as method 00:10:00 Opening Workbooks 00:06:00 Section 08: Must Know Excel VBA Logic Finding the Last row 00:09:00 Finding the Last Column 00:04:00 Finding the next row 00:04:00 The WITH Statement 00:04:00 Comparison operators in Excel VBA 00:01:00 IF Statements- Simple IF Statements 00:07:00 IF THEN ELSE Structure 00:03:00 IF THEN ELSEIF Structure 00:07:00 Nested IFs 00:04:00 OR - AND logical operators 00:07:00 NOT Logical operator 00:03:00 CASE Statements Part 1 - Single Case Statements 00:09:00 CASE Statements Part 2 - Nested Case Statements 00:06:00 Case Statements-Exercise 00:01:00 GOTO and Labels 00:03:00 Section 09: Looping in Excel VBA Loops-Introduction 00:01:00 FOR NEXT Loop 00:11:00 Exit For 00:09:00 Exercise - For Next loop 00:01:00 FOR EACH Loop - Intro 00:07:00 FOR EACH Loops - More examples 00:05:00 Do Loop - Introduction 00:04:00 Do Loop Example 00:01:00 Do Until 00:02:00 Do While 00:02:00 Do while vs Do until - Movies Example 00:04:00 Exit Do Statement 00:05:00 Exercise - Do Loop 00:01:00 Section 10: Interacting with Your Users The Messagebox - Introduction 00:03:00 Messagebox -Inputs 00:07:00 Messagebox - Capturing the User's input 00:05:00 Adding a new line to your VBA Strings 00:02:00 The Inputbox - introduction 00:04:00 Inputbox - Example1 - Capturing a user's name 00:05:00 Inputbox -Employee Database Example Part 1 00:05:00 Inputbox -Employee Database Example Part 2 00:04:00 Exercise - InputBox 00:02:00 Section 11: Error Handling in Excel VBA Error Handling - Introduction 00:09:00 Different Error types in action 00:04:00 On Error Goto statement 00:04:00 Resetting the error handling Status with On Error Goto 00:02:00 The Err Object 00:07:00 Setting a Breakpoint 00:02:00 Section 12: Triggering Code with Events! Worksheet Events -Selection change 00:08:00 Worksheet Events - Worksheet Activate event 00:03:00 Worksheet Events - Deactivate event 00:02:00 Worksheet Events - Before Delete Event 00:02:00 Worksheet Events - Before Double click event 00:08:00 Worksheet Events - Before Right Click event 00:03:00 Worksheet Events - Calculate event 00:03:00 Enabling and Disabling Events 00:03:00 Worksheet events - Worksheet change event 00:11:00 Workbook Events - Follow Hyperlink event 00:02:00 Worksheet events -Exercise 00:01:00 Workbook Events - Workbook open event 00:05:00 Workbook Events - Workbook Activate event 00:02:00 Workbook Events - Workbook Before save event 00:06:00 Workbook Events - Workbook Aftersave event 00:04:00 Workbook Events - Workbook Beforeclose event 00:09:00 Workbook Events - Workbook BeforePrint event 00:03:00 Workbook Events -Workbook De-activate events 00:02:00 Workbook Events - New Chart event 00:08:00 Workbook Events -New sheet event 00:03:00 Workbook Events - Sheet calculate event 00:03:00 Workbook Events - Sheet De-activate event 00:06:00 Workbook Events - Follow Hyperlink event 00:02:00 Workbook Events - Workbook Window Activate event 00:06:00 Workbook Events - Workbook Window De-Activate event 00:02:00 Workbook Events - Window Resize event 00:02:00 Exercise- Workbook Events 00:01:00 Resources Resources - Excel VBA/Macros Foundations 00:00:00 Assignment Assignment - Excel VBA/Macros Foundations 00:00:00

Immerse yourself in the realm of database administration with the SQL Database Administrator at QLS Level 5 course. Gain mastery over SQL environment setup, statement fundamentals, advanced commands, and database creation. From optimizing queries to managing databases and tables, this course equips you with the skills to excel as a proficient SQL Database Administrator. Learning Outcomes Establish a strong foundation in SQL database administration, covering setup and configuration. Master SQL statement basics, including querying, filtering, and sorting data effectively. Utilize GROUP BY statements for data aggregation and summarization. Navigate the intricacies of table joins to extract meaningful insights from complex datasets. Demonstrate proficiency in advanced SQL commands and statements for enhanced database management. Why choose this SQL Database Administrator at QLS Level 5 course? Unlimited access to the course for a lifetime. Opportunity to earn a certificate accredited by the CPD Quality Standards after completing this course. Structured lesson planning in line with industry standards. Immerse yourself in innovative and captivating course materials and activities. Assessments are designed to evaluate advanced cognitive abilities and skill proficiency. Flexibility to complete the course at your own pace, on your own schedule. Receive full tutor support throughout the week, from Monday to Friday, to enhance your learning experience. Who is this SQL Database Administrator at QLS Level 5 course for? Aspiring Database Administrators and SQL Professionals. Software Developers Seeking to Expand Their Database Management Skills. IT Professionals Interested in Database Administration. Data Analysts and Data Engineers Looking to Enhance Their SQL Knowledge Career path SQL Database Administrator - $60,000 to $110,000/year. Database Developer - $70,000 to $120,000/year. Data Engineer - $80,000 to $130,000/year. Database Manager - $90,000 to $150,000/year. Database Architect - $100,000 to $160,000/year Prerequisites This SQL Database Administrator at QLS Level 5 does not require you to have any prior qualifications or experience. You can just enrol and start learning. This course was made by professionals and it is compatible with all PC's, Mac's, tablets and smartphones. You will be able to access the course from anywhere at any time as long as you have a good enough internet connection. Certification After studying the course materials, there will be a written assignment test which you can take at the end of the course. After successfully passing the test you will be able to claim the pdf certificate for £4.99 Original Hard Copy certificates need to be ordered at an additional cost of £8. Endorsed Certificate of Achievement from the Quality Licence Scheme Learners will be able to achieve an endorsed certificate after completing the course as proof of their achievement. You can order the endorsed certificate for only £115 to be delivered to your home by post. For international students, there is an additional postage charge of £10. Endorsement The Quality Licence Scheme (QLS) has endorsed this course for its high-quality, non-regulated provision and training programmes. The QLS is a UK-based organisation that sets standards for non-regulated training and learning. This endorsement means that the course has been reviewed and approved by the QLS and meets the highest quality standards. Please Note: Studyhub is a Compliance Central approved resale partner for Quality Licence Scheme Endorsed courses. Course Curriculum Course Introduction Introduction 00:04:00 Course Curriculum Overview 00:05:00 Overview of Databases 00:10:00 SQL Environment Setup MySQL Installation 00:16:00 MySQL Workbench Installation 00:09:00 Connecting to MySQL using Console 00:09:00 SQL Statement Basics 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 GROUP BY Statements 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 JOINS 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 Advanced SQL Commands / Statements Timestamps 00:12:00 EXTRACT from timestamp 00:10:00 Mathematical Functions 00:12:00 String Functions 00:22:00 SUBQUERY 00:13:00 Creating Database and Tables 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 Databases and Tables Creating a Database backup 00:12:00 10a Overview of Databases and Tables 00:05:00 10c Restoring a Database 00:07:00 Assignment Assignment - SQL Database Administrator at QLS Level 5 04:00:00 Order your QLS Endorsed Certificate Order your QLS Endorsed Certificate 00:00:00

This webinar is part of a series of free, hands-on practical webinars hosted by Cademy on how to get yourself set up to sell spaces, coordinate ticket sales and build online content.  This is the first webinar in the series and the focus will be on:  How to create an educator profile on Cademy How to list your workshops How to manage bookings How to configure payments with Stripe and Cademy There’s no commitment to sign up to anything, and it’s free to join in. So please share with anyone you think might be interested. We're really looking forward to meeting you.