12279 Teaching & Training courses in Huntingdon delivered Online

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

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.

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

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.

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

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

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

Duration 2.75 Days 16.5 CPD hours This course is intended for Complete beginners who have never programmed before to experienced developers coming from another programming language. Overview You will learn how to leverage the power of Python to solve tasks. You will build games and programs that use Python libraries. You will be able to use Python for your own work problems or personal projects. You will create a portfolio of Python based projects you can share. Learn to use Python professionally, learning both Python 2 and Python 3! Create games with Python, like Tic Tac Toe and Blackjack! Learn advanced Python features, like the collections module and how to work with timestamps! Learn to use Object Oriented Programming with classes! Understand complex topics, like decorators. Understand how to use both the Jupyter Notebook and create .py files Get an understanding of how to create GUIs in the Jupyter Notebook system! Build a complete understanding of Python from the ground up! Our Introduction to Python course is designed to take complete beginners or experienced developers up to speed on Python?s capabilities, setting up students for success in using Python for their specific field of expertise. Whether you have never programmed before, already know basic syntax, or want to learn about the advanced features of Python, this course is for you! In this course we will teach you Python 3. Learn how to use Python for real-world tasks, such as working with PDF Files, sending emails, reading Excel files, scraping websites for information, working with image files, and much more! This course will teach you Python in a practical manner and provides a full coding screencast and a corresponding code notebook to review the concepts and exercises conducted in class. Please note, this course is able to be offered in either 3 full day sessions or 5 partial day sessions. See the schedule below. This course includes 6-months access to the full course content in on-demand format to support post-class reference and review. Command Line Basics Python System Setup Jupyter Notebooks Python Data Types Key Data Structures Logic and Control Flow Functions Debugging Modules Object Oriented Programming File I/O Testing Decorators Generators Automation of Tasks Web Scraping Graphical User Interfaces Additional course details: Nexus Humans Introduction to Python training program is a workshop that presents an invigorating mix of sessions, lessons, and masterclasses meticulously crafted to propel your learning expedition forward. This immersive bootcamp-style experience boasts interactive lectures, hands-on labs, and collaborative hackathons, all strategically designed to fortify fundamental concepts. Guided by seasoned coaches, each session offers priceless insights and practical skills crucial for honing your expertise. Whether you're stepping into the realm of professional skills or a seasoned professional, this comprehensive course ensures you're equipped with the knowledge and prowess necessary for success. While we feel this is the best course for the Introduction to Python course and one of our Top 10 we encourage you to read the course outline to make sure it is the right content for you. Additionally, private sessions, closed classes or dedicated events are available both live online and at our training centres in Dublin and London, as well as at your offices anywhere in the UK, Ireland or across EMEA.