12364 Teaching & Training courses delivered Online

Level 2 Certificate in Employability Skills Course Online This Level 2 Certificate in Employability Skills course is designed for students who want to improve their employability skills and prepare for the world of work. This Level 2 Certificate in Employability Skills course aims to help learners develop and improve skills required for the workplace and increase learners' confidence and communication skills to prepare them for employment or a change in employment. This Level 2 Certificate in Employability Skills course will make you more aware of what employers are currently looking for when hiring new employees and how you can make the most of your technical qualifications, skills, experience, and personal qualifications when applying for jobs. Apart from technical qualifications, the Level 2 Certificate in Employability Skills course considers a variety of generic skills and capabilities that employers look for. Special Offers of this Level 2 Certificate in Employability Skills Course This Level 2 Certificate in Employability Skills Course includes a FREE PDF Certificate. Lifetime access to this Level 2 Certificate in Employability Skills Course Instant access to this Level 2 Certificate in Employability Skills Course Get FREE Tutor Support from Monday to Friday in this Level 2 Certificate in Employability Skills Course Courses are included in this Level 2 Certificate in Employability Skills Course Course 01: Level 2 Certificate in Employability Skills Course 02: Self Esteem & Assertiveness Skill Course Course 03: Level 2 Award in Job Search and Interview Skills Other Benefits of this Level 2 Certificate in Employability Skills Course Free 3 PDF Certificate Lifetime Access Free Retake Exam Tutor Support [ Note: Free PDF certificate as soon as completing the Level 2 Certificate in Employability Skills Course] Level 2 Certificate in Employability Skills Course Online Industry Experts Designed this Level 2 Certificate in Employability Skills Course into 12 detailed modules. Detailed course curriculum of the Level 2 Certificate in Employability Skills Course Module 01: Understanding Mindset Module 02: Dealing with Your First Days at Work Module 03: Understanding Motivation Module 04: Setting Your Targets Module 05: Managing Your Time Module 06: Presenting Yourself Module 07: Problem Solving in a Place of Work Module 08: Creative Thinking Module 09: Understanding Risk Module 10: Working in a Team Module 11: Dealing with Conflict Module 12: Health, Safety and Security in the Place of Work Assessment Method of Level 2 Certificate in Employability Skills Course After completing each module of the Level 2 Certificate in Employability Skills Course, 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 of Level 2 Certificate in Employability Skills Course After completing the MCQ/Assignment assessment for this Level 2 Certificate in Employability Skills 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? Level 2 Certificate in Employability Skills Course Online This Level 2 Certificate in Employability Skills Course is ideal for people looking for employment or a change in employment. Requirements Level 2 Certificate in Employability Skills Course Online Students who intend to enrol in this Level 2 Certificate in Employability Skills Course must meet the following requirements: Employability Skills: Good command of the English language. Employability Skills: Must be vivacious and self-driven Employability Skills: Basic computer knowledge. Employability Skills: A minimum of 16 years of age is required Career path Level 2 Certificate in Employability Skills Course Online Certificates Certificate of completion Digital certificate - Included

The Caring for Challenging Behaviour of Young People Course is pivotal in today's world, especially for clinical training and nursing professionals. With modules focusing on understanding challenging behavior in young people with learning disabilities, organizing effective care, and implementing risk assessment and reactive strategies, this course equips individuals with essential skills. In an era where mental health issues among youth are increasingly prevalent, mastering techniques to address challenging behaviors is crucial. Employers in the UK highly value such expertise, offering lucrative job opportunities in various healthcare settings. Nurses and care professionalswith this certification can expect salaries ranging from £25,000 to £35,000 annually, depending on experience and location. The advantages of this course are abundant, as the demand for skilled professionals in this sector is rising steadily. In fact, the healthcare industry has witnessed a notable increase in demand, with job opportunities projected to grow by 12% over the next decade. Therefore, investing in the Caring for Challenging Behaviour of Young People Course not only enhances individual skill sets but also opens doors to rewarding career prospects in the UK healthcare sector. Key Features: CPD Certified Challenging Behaviour Course Free Certificate from Reed CIQ Approved Challenging Behaviour Course Developed by Specialist Lifetime Access Course Curriculum: Module 01: Challenging behaviour and learning disabilities Module 02: Key priorities for implementation Module 03: Children, young people and adults Module 04: Organising Effective Care Module 05: Risk assessment Module 06: Reactive strategies Learning Outcomes: Identify challenging behaviours in young people with learning disabilities. Implement key priorities for managing challenging behaviour effectively. Apply strategies for organising care for children, young people, and adults. Conduct risk assessments to mitigate potential harm in care settings. Employ reactive strategies to de-escalate challenging situations effectively. CPD 10 CPD hours / points Accredited by CPD Quality Standards Caring for Challenging Behaviour of Young People 1:07:57 1: Module 01: Challenging behaviour and learning disabilities Preview 07:40 2: Module 02: Key priorities for implementation 09:38 3: Module 03: Children, young people and adults 10:49 4: Module 04: Organising Effective Care 12:32 5: Module 05: Risk assessment 13:55 6: Module 06: Reactive strategies 11:23 7: CPD Certificate - Free 01:00 8: Leave A Review 01:00 Who is this course for? This Caring for Challenging Behaviour of Young People course is accessible to anyone eager to learn more about this topic. Through this course, you'll gain a solid understanding of Caring for Challenging Behaviour of Young People. Moreover, this course is ideal for: Teachers and educational support staff Social workers and youth workers Healthcare professionals working with young people Family support workers and counsellors Care home staff and residential support workers Requirements There are no requirements needed to enrol into this Caring for Challenging Behaviour of Young People course. We welcome individuals from all backgrounds and levels of experience to enrol into this Caring for Challenging Behaviour of Young People course. Career path After finishing this Caring for Challenging Behaviour of Young People course you will have multiple job opportunities waiting for you: Youth Support Worker - £18K to 25K/year. Behavioural Support Assistant - £18K to 30K/year. Child and Adolescent Mental Health Worker - £24K to 40K/year. Special Educational Needs Coordinator (SENCO) - £30K to 45K/year. Family Support Worker - £20K to 30K/year. Certificates Digital certificate Digital certificate - Included Reed Courses Certificate of Completion Digital certificate - Included Will be downloadable when all lectures have been completed.

Child Sexual Exploitation Child Sexual Exploitation (CSE) and Child Criminal Exploitation (CCE) are serious issues that anyone who works with children, young people, or families should be aware of. Our Child Sexual Exploitation course helps practitioners understand the complexities of child exploitation issues, such as who is most at risk, how children become involved, signs of exploitation, and why young people respond the way they do. The Child Sexual Exploitation course also covers best practices for responding to concerns and making referrals to social care. Courses are including in this Child Sexual Exploitation course: Course 01: Child Sexual Exploitation & Child Criminal Exploitation (CSE & CCE) Course 02: Level 2 Certificate in Understanding Domestic Abuse Course 03: Level 2 Certificate in Understanding Safeguarding and Prevent Course 04: Diploma in Counselling and Psychology Course 05: Level 2 Certificate in Understanding Mental Health in the Early Years [Note: Free PDF certificate will provide as soon as completing the Child Sexual Exploitation course] Course Curriculum ofChild Sexual Exploitation Module 01: An Overview of CSE and CCE Module 02: CSE: Risk Factors, Warning Signs, and Consequences Module 03: A Closer Look to CCE Module 04: Best Practice for Responding to Concerns Assessment Method of Child Sexual Exploitation After completing each module of the Child Sexual Exploitation Course, you will find automated MCQ quizzes. To unlock the next module, you need to complete the quiz task and get at least 60% marks. Certification of Child Sexual Exploitation After completing the MCQ/Assignment assessment for this Child Sexual Exploitation course, you will be entitled to a Certificate of Completion from Training Tale. 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? Child Sexual Exploitation This Child Sexual Exploitation course is ideal for anyone who works with children, young people and/or families. Requirements Child Sexual Exploitation There are no specific requirements for Child Sexual Exploitation course because it does not require any advanced knowledge or skills. Certificates Certificate of completion Digital certificate - Included

Youth Work: Youth Work Certificate Course Online Introducing Youth Work: Youth Work Certificate Course "Empowering the Next Generation" Online course! Are you passionate about making a positive impact on young lives? Do you want to contribute to the development and growth of the next generation? If so, our online course Youth Work: Youth Work Certificate Course is tailored just for you! Our comprehensive Youth Work: Youth Work Certificate Course is designed to equip you with the knowledge, skills, and tools necessary to excel in the field of youth work. Whether you are a seasoned professional or someone looking to embark on a fulfilling career, this extensive Youth Work: Youth Work Certificate Course will provide you with valuable insights and practical strategies to effectively engage and empower young people. Join our Youth Work: Youth Work Certificate Course today and unlock your potential to make a lasting impact on young lives. Together, let's create a brighter future for the next generation! Enroll in our Youth Work: Youth Work Certificate Course now and be part of the change! Main Course: Level 2 Youth Work certificate Course Included Youth Work Certificate Course Along with Youth Work Certificate course, Learner will get free Level 5 Mental Health First Aid Certification Along with Youth Work Certificate course, Learner will get free Social Worker: Social Work Diploma Along with Youth Work Certificate course, Learner will get free Level 3 Designated Safeguarding Lead Training Along with Youth Work Certificate course, Learner will get free Level 3 Diploma for the Children and Young People's Workforce [Note: Free PDF certificate as soon as completing the Youth Work: Youth Work Certificate Course] Youth Work: Youth Work Certificate Course Online This Youth Work: Youth Work Certificate Course consists of 11 modules. Course Curriculum of Youth Work: Youth Work Certificate Course Module 01: Overview to Youth Work Module 02: Youth Workers: Who Are They? Module 03: Role and Approaches of Youth Worker Module 04: Ethical Conduct and Principles in Youth Work Module 05: Career as a Youth Worker (Social Work) Module 06: Social Influences on Youth Worker Module 07: The National Youth Agency (NYA) Module 08: The EU on Youth Work Module 09: Mental Health of Youth Worker Module 10: Dealing with Stress Module 11: Youth Justice and Social Work Assessment Method of Youth Work: Youth Work Certificate After completing each module of Youth Work: Youth Work Certificate course, you will find automated MCQ quizzes. To unlock the next module, you need to complete the quiz task and get at least 60% marks. Certification of Youth Work: Youth Work Certificate After completing the MCQ/Assignment assessment for this Youth Work: Youth Work Certificate course, you will be entitled to a Certificate of Completion from Training Tale which is completely free to download. Who is this course for? Youth Work: Youth Work Certificate Course Online This Youth Work: Youth Work Certificate Course is offered to students from all walks of life. Individuals working in similar fields can also register in this Youth Work: Youth Work Certificate Course to update or develop their abilities. Requirements Youth Work: Youth Work Certificate Course Online To enrol in this Youth Work: Youth Work Certificate Course, students must fulfil the following requirements: Youth Work: Youth Work Good command of the English language Youth Work: Youth Work Must be vivacious and self-driven Youth Work: Youth Work Basic computer knowledge Youth Work: Youth Work A minimum of 16 years of age is required Career path Youth Work: Youth Work Certificate Course Online Enrol in the Youth Work: Youth Work Certificate Course today to learn the skills and knowledge required to work with young people and organise youth activities. 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

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

Unlock the secrets of the maritime world with our comprehensive programme designed to transform your understanding of ports and their pivotal role in global trade. Dive deep into the rich tapestry of the UK's port industry, exploring everything from the fundamentals of port operations to advanced strategies in port management. Our meticulously crafted curriculum takes you on a journey through the intricacies of port planning, financial services, and the latest technological advancements that drive efficiency and innovation in this dynamic sector. Key Features: CPD Certified Free Certificate from Reed CIQ Approved Developed by Specialist Lifetime Access Discover the vital elements that contribute to the success of the world's leading ports, and gain insights into the safety protocols and security measures that safeguard maritime operations. With a focus on both historical contexts and contemporary developments, this programme offers a holistic view of the factors influencing port growth and evolution. Engage with the critical aspects of maritime policy and port pricing, and equip yourself with the knowledge to navigate the complexities of port administration and ownership. Enhance your proficiency with industry-specific terminology and cutting-edge software solutions, ensuring you stay ahead in the ever-evolving landscape of port management. Embark on this educational voyage and chart a course towards mastery in the port industry. Course Curriculum Module 01: UK Ports Overview Module 02: Fundamentals of Ports Module 03: Different Types of Port Module 04: Understanding Port and Terminal Management Module 05: Planning & Design Module 06: Financial & Professional Services Module 07: Port Management Module 08: Safety & Security Module 09: Port Equipment Module 10: Software & Solutions Module 11: Introduction to Port Development Module 12: Growth of the World's Leading Ports Module 13: Developments in Terminal Operation Module 14: Introduction to Ship Module 15: Effect of Port Time on Ship Speed Module 16: Types of Port Ownership and Administration Module 17: Organisations Concerning Ports Module 18: The Rise and Fall of Ports Module 19: Information Technology in Logistics Module 20: Safety Module 21: Maritime Policy Module 22: Port Policy Module 23: Port Pricing Module 24: Glossary & Shipping Terms Learning Outcomes: Grasp key concepts and fundamentals of UK ports and their operations. Understand various port types and their unique management requirements. Develop insights into port planning, design, and development strategies. Explore financial services and economic aspects related to port management. Learn about port equipment, software solutions, and terminal operations. Comprehend safety, security, and policy issues within port management. CPD 10 CPD hours / points Accredited by CPD Quality Standards Diploma on Port Management 4:06:13 1: Module 01: UK Ports Overview 12:50 2: Module 02: Different Types of Port 13:57 3: Module 03: Understanding Port and Terminal Management 11:06 4: Module 04: Planning & Design 07:18 5: Module 05: Financial & Professional Services 12:56 6: Module 06: Port Management 06:05 7: Module 07: Safety & Security 06:44 8: Module 08: Port Equipment 07:27 9: Module 09: Software & Solutions 09:23 10: Module 10: Introduction to Port Development 14:01 11: Module 11: Growth of the World's Leading Ports 11:16 12: Module 12: Developments in Terminal Operation 17:03 13: Module 13: Introduction to Ship 07:24 14: Module 14: Effect of Port Time on Ship Speed 06:51 15: Module 15: Types of Port Ownership and Administration 14:04 16: Module 16: Organisations Concerning Ports 07:47 17: Module 17: The Rise and Fall of Ports 07:41 18: Module 18: Information Technology in Logistics 10:08 19: Module 19: Safety 05:28 20: Module 20: Maritime Policy 05:33 21: Module 21: Port Policy 10:12 22: Module 22: Port Pricing 07:08 23: Module 23: Glossary & Shipping Terms 32:51 24: CPD Certificate - Free 01:00 Who is this course for? Aspiring port managers and administrators Maritime industry professionals Logistics and supply chain specialists Infrastructure planners and designers Individuals interested in port operations and policies Career path Port Manager Terminal Operations Supervisor Maritime Policy Analyst Port Development Planner Logistics Coordinator Port Equipment Specialist Certificates Digital certificate Digital certificate - Included Reed Courses Certificate of Completion Digital certificate - Included Will be downloadable when all lectures have been completed.

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

Content Management System is now the most popular computer software that is used to create and modify digital contents. This course has been illustrated to educate you on how it functions. It discusses the fundamental aspects of CMS. Hit the course to enter into the digital world. Start learning Content Management System Training that will give you enough knowledge and skills to build your dream career. About this course This Content Management System Training helps to grow your skills faster through the power of relevant content and world-class tutors. In this industry-leading bite-sized course, you will learn up-to-date knowledge in the relevant field within a few hours and get certified immediately. The modules of this course are very easy to understand and all of the topics are split into different sections. You will easily grasp and use the knowledge gained from this course in your career and go one step ahead of your competitors. The course is designed to improve your employability and provide you with the tools you need to succeed. Enrol today and start learning your essential skills. Why choose this course Earn a digital Certificate upon successful completion. Accessible, informative modules taught by expert instructors Study in your own time, at your own pace, through your computer tablet or mobile device Get 24/7 help or advice from our email and live chat teams Get full tutor support on weekdays (Monday to Friday) Course Design The Content Management System Training is delivered through our online learning platform, accessible through any internet-connected device. There are no formal deadlines or teaching schedules, meaning you are free to study the course at your own pace. You are taught through a combination of Video lessons Online study materials Who Is This Course For:​ This Content Management System Training is ideal for those who want to be skilled in this field or who wish to learn a new skill to build their dream career. If you want to gain extensive knowledge, potential experience, and be an expert in the related field then this is a great course for you to grow your career. Requirements This course is for anyone who would like to learn Content Management System Training related skills to aid his/her career path. No formal entry prerequisites are required Certification Upon successful completion of the course, you will be able to obtain your course completion e-certificate. Print copy by post is also available at an additional cost of £9.99 and PDF Certificate at £4.99. Course Content Module 1: Content Management Basics Module 2: Introduction to Content Management System (CMS) Module 3: Fundamentals of Content Management System Course Content Content Management Basics Module 1: Content Management Basics 00:18:00 Module 2: Introduction to Content Management System (CMS) 00:09:00 Module 3: Fundamentals of Content Management System 00:17:00 Order your Certificates & Transcripts Order your Certificates & Transcripts 00:00:00 Frequently Asked Questions Are there any prerequisites for taking the course? There are no specific prerequisites for this course, nor are there any formal entry requirements. All you need is an internet connection, a good understanding of English and a passion for learning for this course. Can I access the course at any time, or is there a set schedule? You have the flexibility to access the course at any time that suits your schedule. Our courses are self-paced, allowing you to study at your own pace and convenience. How long will I have access to the course? For this course, you will have access to the course materials for 1 year only. This means you can review the content as often as you like within the year, even after you've completed the course. However, if you buy Lifetime Access for the course, you will be able to access the course for a lifetime. Is there a certificate of completion provided after completing the course? Yes, upon successfully completing the course, you will receive a certificate of completion. This certificate can be a valuable addition to your professional portfolio and can be shared on your various social networks. Can I switch courses or get a refund if I'm not satisfied with the course? We want you to have a positive learning experience. If you're not satisfied with the course, you can request a course transfer or refund within 14 days of the initial purchase. How do I track my progress in the course? Our platform provides tracking tools and progress indicators for each course. You can monitor your progress, completed lessons, and assessments through your learner dashboard for the course. What if I have technical issues or difficulties with the course? If you encounter technical issues or content-related difficulties with the course, our support team is available to assist you. You can reach out to them for prompt resolution.