40073 Learning courses in Manchester delivered On Demand

Everywhere, from tiny businesses to major corporations, needs people skilled in SQL. In light of this, our online training course has been developed to help you succeed by equipping you with all the necessary skills. The importance of mastering SQL increases if you're looking for your first job in the data industry. You will learn about topics such as SQL fundamentals, data wrangling, SQL analysis, AB testing, distributed computing with Apache Spark, Delta Lake, and more through four increasingly more challenging SQL projects with data science applications. These subjects will equip you with the skills necessary to use SQL creatively for data analysis and exploration, write queries quickly, produce datasets for data analysis, conduct feature engineering, integrate SQL with other data analysis and machine learning toolsets, and work with unstructured data. This Specialisation is designed for a learner with little or no prior coding expertise who wants to become proficient with SQL queries. Experts have meticulously planned out the curriculum for the SQL Skills Training course with years of expertise. As a result, you will find it simple to learn the course material. Learning outcome After finishing the course, you'll Learn to utilise the tools for view creation Become familiar with updating columns and indexed views Be able to test and debug Be able to search a database using SQL Become more familiar with inline table-valued functions Learn the fundamentals of transactions and multiple statements Why Prefer US? Opportunity to earn a certificate accredited by CPD after completing this course Student ID card with amazing discounts - completely for FREE! (£10 postal charges will be applicable for international delivery) Standards-aligned lesson planning Innovative and engaging content and activities Assessments that measure higher-level thinking and skills Complete the program in your own time, at your own pace Each of our students gets full 24/7 tutor support *** Course Curriculum *** SQL Programming Course Module 01: Course Introduction Introduction Course Curriculum Overview Overview of Databases Module 02: SQL Environment Setup MySQL Installation MySQL Workbench Installation Connecting to MySQL using Console Module 03: SQL Statement Basics Overview of Challenges SQL Statement Basic SELECT Statement SELECT DISTINCT Column AS Statement COUNT built-in Method usage SELECT WHERE Clause - Part One SELECT WHERE Clause - Part Two Statement Basic Limit Clause Statement Using BETWEEN with Same Column Data How to Apply IN Operator Wildcard Characters with LIKE and ILIKE Module 04: GROUP BY Statements Overview of GROUP BY Aggregation function SUM() Aggregation MIN() and MAX() GROUP BY - One GROUP BY - Two HAVING Clause Module 05: JOINS Overview of JOINS Introduction to JOINS AS Statement table INNER Joins FULL Outer Join LEFT Outer JOIN RIGHT JOIN Union Module 06: Advanced SQL Commands / Statements Timestamps EXTRACT from timestamp Mathematical Functions String Functions SUBQUERY Module 07: Creating Database and Tables Basic of Database and Tables Data Types Primary key and Foreign key Create Table in SQL Script Insert Update Delete Alter Table Drop-Table NOT NULL Constraint UNIQUE Constraint Module 08: Databases and Tables Creating a Database backup 10a Overview of Databases and Tables 10c Restoring a Database CPD 10 CPD hours / points Accredited by CPD Quality Standards Who is this course for? The course can be helpful for anyone working in the SQL fields, whether self-employed or employed, regardless of their career level. Requirements You will not need any prior background or expertise to enrol in this course. Career path The vocation of SQL Skills Training moves very quickly but pays well. This position provides unparalleled satisfaction. This is your opportunity to learn more and start changing things. Query Language Developer Server Database Manager Python Developer Technical Consultant Project Implementation Manager Software Developer (SQL) Certificates Certificate of completion Digital certificate - £10

Awarded by ATHE + Ofqual Regulated + Tutor Support + Fully Online + Job Placement Assistance

The Learning College Group offers this Teaching Assistant qualification that is fully Regulated and accepted in all schools across the UK. It enables you to work with children between the ages of 5-18 years. This Level 3 Teaching Assistant course is a recognised (RQF) qualification that can be studied in your own time from home. 1-2-1 Tutor support is provided with this Teaching Assistant course. OFSTED accepted and regulated by OFQUAL this qualification will be the required course to secure your job as a Teaching Assistant.

Are you ready to take your professional game to the next level? 🚀 Introducing our comprehensive course: 'Workplace Professionalism'! Whether you're a seasoned professional looking to refine your skills or a newcomer eager to make a lasting impression in the corporate world, this course is designed to equip you with the essential tools and mindset for success.   👔 Unlock Your Potential: In today's competitive job market, professionalism isn't just a desirable trait - it's a necessity. Our course delves into the core principles of workplace professionalism, empowering you to navigate the intricacies of professional environments with confidence and finesse. From effective communication to ethical decision-making, you'll gain invaluable insights that will set you apart from the crowd.   📚 Comprehensive Curriculum: Our expertly crafted curriculum covers a wide range of topics essential for thriving in any professional setting. Learn how to cultivate a positive attitude, master the art of time management, and develop strong interpersonal skills that foster collaboration and teamwork. With engaging lectures, interactive exercises, and real-world case studies, you'll acquire practical knowledge that you can apply immediately in your professional life.   🎓 Who is this for?: This course is ideal for professionals at all stages of their careers, including recent graduates entering the workforce, mid-level managers aiming for advancement, and seasoned executives seeking to refine their leadership skills. Whether you work in corporate, nonprofit, government, or entrepreneurial sectors, the principles of workplace professionalism are universally applicable.   🌟 Benefits of Taking the Course: Enhance your professional image and credibility Build strong relationships with colleagues, clients, and stakeholders Improve your productivity and efficiency in the workplace Navigate workplace conflicts and challenges with grace and diplomacy Position yourself for career advancement and leadership opportunities   💼 Career Path: The skills and knowledge gained from our 'Workplace Professionalism' course can open doors to a variety of exciting career paths. Whether you aspire to climb the corporate ladder, launch your own business, or make a meaningful impact in your community, professionalism is the cornerstone of success in any endeavor. From entry-level positions to executive leadership roles, employers value professionals who exemplify integrity, professionalism, and a commitment to excellence.   🔍 Invest in Your Future: In today's dynamic and fast-paced work environments, investing in your professional development is more important than ever. By enrolling in our 'Workplace Professionalism' course, you're not just investing in yourself - you're investing in your future success and fulfillment. Join thousands of professionals around the world who have transformed their careers with our proven curriculum.   Don't let opportunities pass you by - elevate your professional presence and unlock your full potential with our 'Workplace Professionalism' course. Enroll today and take the first step toward a brighter, more prosperous future! 🌟 Course Curriculum Module 1 Introduction to Workplace Professionalism Introduction to Workplace Professionalism 00:00 Module 2 Communication Skills Communication Skills 00:00 Module 3 Ethics and Integrity in the Workplace Ethics and Integrity in the Workplace 00:00 Module 4 Teamwork in the Workplace Teamwork in the Workplace 00:00 Module 5 Time Management and Productivity in the Workplace Time Management and Productivity in the Workplace 00:00 Module 6 Communication and Interpersonal Skills in the Workplace Communication and Interpersonal Skills in the Workplace 00:00 Module 7 Professional Development and Career Growth in the Workplace Professional Development and Career Growth in the Workplace 00:00 Module 8 Leadership in the Workplace Leadership in the Workplace 00:00 Module 9 Collaboration in the Workplace Collaboration in the Workplace 00:00 Module 10 Time Management and Productivity in the Workplace Time Management and Productivity in the Workplace 00:00

The Microsoft Certified Fundamentals, Associate, and Expert is a new breed of Microsoft certification. It is referred to as a ‘role-based certification’. According to Microsoft, role-based certifications show that individuals that possess them are keeping pace with today’s technical roles and requirements. They allow a learner to skill up and prove their expertise to employers and peers, plus get the recognition and opportunities they’ve earned

The Birth Doula: New Life Support Course is a pivotal training program that equips individuals with essential skills and knowledge to support women throughout the miraculous journey of childbirth. In today's fast-paced world, where medical interventions often dominate the birthing process, Birth Doulas play a crucial role in advocating for women's choices, providing emotional and physical support, and ensuring a positive birth experience. Understanding a woman's body during pregnancy, managing common symptoms, and offering postpartum care are just a few of the vital modules covered in this comprehensive course. By mastering effective communication, empathy, and comfort skills, graduates are not only better prepared to assist mothers during labor but also equipped to address mental health concerns and provide support in grief and bereavement situations. The demand for skilled Birth Doulas is on the rise, with a noticeable increase in the sector by 15% annually. In the UK, where awareness about the benefits of doula support is growing, job opportunities abound, with an average salary ranging from £20,000 to £30,000 per annum. Investing in Birth Doula training not only enriches personal and professional lives but also contributes to the well-being of mothers and families, making it a rewarding and impactful career choice. Key Features: CPD Certified Birth Doula Course Free Certificate Developed by Specialist Lifetime Access Course Curriculum: Module 01: Introduction to Birth Doula Module 02: A Woman's Body in Pregnancy Module 03: Antenatal Care during Pregnancy Module 04: Management of Common Symptoms of Pregnancy Module 05: Clinical Examination of Pregnant Women Module 06: Care of a Woman during Labour Module 07: Postpartum Care Module 08: Screening Newborn Baby Module 09: Infant Care Module 10: Mental Health of the Mother Module 11: Grief and Bereavement Module 12: Contraception and Family Planning Module 13: Effective Communication Module 14: Empathy and Comfort Skills Module 15: Ethics in Doula Learning Outcomes: Apply knowledge of a woman's body during pregnancy for holistic care. Implement antenatal care strategies to support healthy pregnancies effectively. Manage common pregnancy symptoms, ensuring comfort and well-being. Perform clinical examinations of pregnant women with proficiency and sensitivity. Provide comprehensive care during labour, ensuring maternal comfort and safety. Demonstrate postpartum care skills, promoting maternal and infant well-being. CPD 10 CPD hours / points Accredited by CPD Quality Standards Who is this course for? This Birth Doula: New Life Support course is accessible to anyone eager to learn more about this topic. Through this course, you'll gain a solid understanding of Birth Doula: New Life Support. Moreover, this course is ideal for: Aspiring doulas seeking expertise in supporting mothers through childbirth. Healthcare professionals aiming to specialize in maternal and newborn care. Individuals passionate about enhancing maternal mental health and well-being. Those interested in grief and bereavement support in a doula role. Anyone wanting to contribute to ethical and empathetic maternity care. Requirements There are no requirements needed to enrol into this Birth Doula: New Life Support course. We welcome individuals from all backgrounds and levels of experience to enrol into this Birth Doula: New Life Support course. Career path After finishing this Birth Doula: New Life Support course you will have multiple job opportunities waiting for you. Some of the following Job sectors of Birth Doula: New Life Support are: Maternity Support Worker - £18K to £25K/year Midwife - £24K to £40K/year Childbirth Educator - £22K to £30K/year Infant Feeding Specialist - £20K to £35K/year Maternal Mental Health Advocate - £25K to £35K/year Certificates Digital certificate Digital certificate - Included Certificate of Completion Digital certificate - Included Will be downloadable when all lectures have been completed.

The Negative Thought Pattern Interrupt does exactly what it says Course curriculum Welcome to the course! Welcome from Simon Lee Maryan, Course Creator What is the Somato-Limbic Metacognitive Process (SLM Process)? CPD Accreditation About the Course Creator How to Navigate this course What Are Your Initial Outcomes SLM Process Course Learning Outcomes Individual Change Readiness Assessment 2 Part 1 - Theory Part 1 - Introduction Video 3 Bonus Module 1: Psychological and Physiological Effects of Stress Lesson BM1.1: Stress and Work Lesson BM1.2: Types of Stress and Causes Lesson BM1.3: Physical Effects of Stress - Musculoskeletal Lesson BM1.4: Physical Effects of Stress - Respiratory Lesson BM 1.5: Physical Effects of Stress - Cardiovascular Lesson BM 1.6: Physical Effects of Stress - Endocrine Lesson BM 1.7: Physical Effects of Stress - Gastrointestinal Lesson BM 1.8: Physical Effects of Stress - Nervous Lesson BM1.9 - Psychological Effects of Stress 4 Bonus Module 2: Psychological and Physiological Effects of Fatigue Lesson BM2.1: Definition of Fatigue Lesson BM2.2: Types of fatigue and Causes Lesson BM2.3: Psychological Effects of Fatigue Lesson BM2.4: Methods to Manage Stress and Fatigue 5 Module 1: Foundation Theory Lesson 1.1: The Principles for Success Lesson 1.2: Creating Outcomes with Positive Effect Lesson 1.3: Setting a Coaching Intervention Up For Success Lesson 1.4: Cause and Effect Lesson 1.5: The Mind-Body Connection Lesson 1.6: Neurological Connections Lesson 1.7: The Presuppositions for Life Module 1 Assessment 6 Module 2: Communication Principles and Skills Module 2: Introduction Video Lesson 2.1: A Communication Model Lesson 2.2: Observing Body Language and Non-Verbal Communication Lesson 2.2.1: Behavioural Profiling Aide Memoire Lesson 2.2.2: Basic Behavioural Profiling Exercises Lesson 2.3: Rapport - What is it, how do we build and maintain it? Lesson 2.4: Our Senses and Language Lesson 2.4.1: Exercise - Sensory Preference Lesson 2.4.1 - Exercise Worksheet Lesson 2.5: Predicate Language Module 2 Assessment 7 Module 3: Eye Movement Patterns Module 3 Introduction Video Lesson 3.1: Eye Movement Pattern Cues Lesson 3.2: How to Elicit Eye Patterns Lesson 3.3: Eye Tracking Exercise Lesson 3.3.1 Eye Tracking Exercise Sheet - PDF Lesson 3.4: Synesthesia Module 3 Assessment 8 Module 4: Submodalities Module 4 Introduction Video Lesson 4.1: Modalities and Submodalities Lesson 4.2: Possible uses for Changing Submodalities and How to Elicit Them Lesson 4.3: Using Submodalities for Change Lesson 4.3.1: Exercise - Submodality Change Video: How to use the Submodality Checklist Lesson 4.3.2: Submodality Checklist PDF Module 4 Assessment 9 Module 5: The Limbic System, Memory and Brain Activity Module 5: Introduction Video Lesson 5.1: How the Limbic System Affects Memory Lesson 5.1.1: Memory Graphics - Downloads Lesson 5.2: Perceptual Blindness and Conscious Overload Lesson 5.3: Brain Activity and Brain Waves Lesson 5.4: Circadian Rhythm Lesson 5.4.1: Exercise Worksheet - Sleep Diary Lesson 5.5:Ultradian Rhythm Module 5 Assessment 10 Module 6: Influences on Your State of Mind, Emotions, Beliefs and Decisions Module 6: Introduction Video Lesson 6.1: Influences on Your State of Mind Lesson 6.2: Emotional Response vs Decisions Lesson 6.3: Beliefs Lesson 6.4: Identifying Limiting Beliefs Lesson 6.4.1: Exercise Worksheet - Identify Your Limiting Beliefs Lesson 6.5: Limiting Beliefs - Framing Principle, Frame of Reference Lesson 6.5.1: Reframing, Schemas, Meaning Lesson 6.5.2 - Exercise Worksheet - Identify Your Frames of Reference, Schemas and Meaning Lesson 6.6: Values Lesson 6.6.1: Values Exercise Video Explanation Lesson 6.6.1 - Values Exercise WorkSheet Lesson 6.6.2: Beliefs Behind Your Values Video Explanation Lesson 6.6.2 - Exercise Worksheet 2 - Beliefs Behind Your Values Module 6 Assessment 11 Module 7:The Logical Levels Model for Personal Change Module 7: Introduction Video Lesson 7.1: An Introduction to the Logical Levels Model Lesson 7.2: Logical Levels - Environment Lesson 7.3: The logical Levels - Behaviour Lesson 7.4: The Logical Levels - Capability Lesson 7.5: The Logical Levels Model - Beliefs and Values Lesson 7.6: The Logical Levels Model - Identity Lesson 7.7: The Logical Levels Model - Purpose Video Explanation of Personal Exploration Exercise Lesson 7.8: Personal Exploration Exercise - PDF Module 7 Assessment 12 Module 8: Behavioural Change Module 8: Introduction Video Lesson 8.1: The Behavioural Change Learning Cycle Behavioural Change Learning Cycle - Video Explanation Behavioural Change Learning Cycle PDF Lesson 8.2: The Intentional Change Model Lesson 8.2.1: Reflective Exercise - Who Helped Me and Who Tried Lesson 8.3: The Intentional Change Model Cont. Module 8 Assessment 13 Part 2 - Techniques Part 2 - Techniques Introduction 14 Module 9: Negative Thought Pattern Interrupt Lesson 9.1: Negative Thought Pattern Interrupt - What Is It? Lesson 9.2: NTPI - The Process Overview Lesson 9.3: NTPI - The Process in Detail Lesson 9.4: NTPI - Live Video Demo with Client Lesson 9.5: NTPI Assignment 15 Module 10: The Whole Brain State Lesson 10.1: The Whole Brain State (WBS) - Description Lesson 10.2: WBS - The Process Lesson 10.3: The Whole Brain State - Live Video Demo with Client Lesson 10.4: Whole Brain State Assignment 16 Module 11: Anchoring Lesson 11.1: Brief History of Anchoring Lesson 11.2: Uses of Anchoring Lesson 11.3: 5 Keys to Anchoring - ITURN Lesson 11.4: The Anchoring Process Lesson 11.4.1: Icarus Anchoring Process - PDF Download Lesson 11.5: Anchoring - Live Video Demo with Client Lesson 11.6: Anchoring Assignment Lesson 11.7: How to Bring all Three Techniques Together 17 Bonus Module 3: Personal Needs Lesson B3.1: How are Your Personal Needs Being Fulfilled? Lesson B3.2 - Exercise Worksheet - Hierarchy of Needs 18 Module 12: Purpose Lesson 12.1: Purpose Lesson 12.2: Your Purpose Statement - Exercise Worksheet 19 Module 13: Case Studies Assignment Lesson 13.1 - Case Study Assignment Sample Case Studies and Informed Consent Form 20 Next steps Congratulations, you're Almost Done!! Here's What's Next Before you go...Please leave us your thoughts on your experience of this course.

If you want to achieve a Level-3 Ofqual UK-Government Regulated TESOL certification in the most effective, time-saving and enjoyable way, embark on a thrilling learning adventure in TEFL Wonderland. Unlike the click-and-read TEFL courses, this play-and-practice expedition will engage all your senses and keep you motivated to achieve your learning mission.

Enjoy this RYA Day Skipper theory course. A comprehensive introduction to chart work, navigation, meteorology, and the basics of seamanship. This RYA online course is delivered in video and text format, to give you flexibility and control over your learning. Made up of 15 modules with interactive activities and knowledge checks to get the most out of your distance learning experience.

Online Asset Management Course eCert+ our fully featured eLearning Asset Management Course, this course includes recorded webinars and additional offline activities and guidance. Get certified today.