• Professional Development
  • Medicine & Nursing
  • Arts & Crafts
  • Health & Wellbeing
  • Personal Development

12579 Teaching & Training courses in Reigate delivered Online

Product Management & Business Management - 30 CPD Courses Bundle

By NextGen Learning

Get ready for an exceptional online learning experience with the Product Management & Business Management bundle! This carefully curated collection of 30 premium courses is designed to cater to a variety of interests and disciplines. Dive into a sea of knowledge and skills, tailoring your learning journey to suit your unique aspirations. The Product Management & Business Management bundle is a dynamic package, blending the expertise of industry professionals with the flexibility of digital learning. It offers the perfect balance of foundational understanding and advanced insights. Whether you're looking to break into a new field or deepen your existing knowledge, the Product Management package has something for everyone. As part of the Product Management & Business Management package, you will receive complimentary PDF certificates for all courses in this bundle at no extra cost. Equip yourself with the Product Management bundle to confidently navigate your career path or personal development journey. Enrol today and start your career growth! This Bundle Comprises the Following 30 CPD Accredited Courses: Course 01: Product Management Course 02: Product Management for Maximum Sales Course 03: Digital Product Management Course 04: Quality Management Course 05: Branding Fundamentals for New Business Course 06: Business Management Course 07: Fundamentals of Entrepreneurship Course 08: Strategic Planning and Analysis for Marketing Course 09: Marketing Secrets for High Sales Course 10: Complete Online Marketing & Advertising Course Course 11: Sales Skills Course 12: NLP For Sales, Persuasion & Influence Course 13: Increase Your Sales Through a Profitable Pricing Strategy Course 14: Level 3 E-commerce Management Course 15: Digital Marketing Starting an Online E-Commerce Store Course 16: Social Media Marketing Strategy Course 17: Learn to Drive Traffic into Sales through Digital Marketing Course 18: Lead Generation and Attraction Marketing Training Course 19: Retail Management Course 20: Merchandising Course 21: Visual Merchandising Diploma Course 22: Logistic Management Course 23: Import/Export Course 24: Supply Chain Management Course 25: Certificate in Purchasing and Procurement Course 26: Operations Management: Process Mapping & Supply Chain Course 27: Customer Relationship Management Course 28: SAP Controlling (CO) - Product Costing S4HANA Course 29: Xero Accounting and Bookkeeping Training Course 30: Microsoft Excel & Accounting Training What will make you stand out? Upon completion of this online Product Management & Business Management bundle, you will gain the following: CPD QS Accredited Proficiency with this Product Management bundle After successfully completing the Product Management bundle, you will receive a FREE CPD PDF Certificates as evidence of your newly acquired abilities. Lifetime access to the whole collection of learning materials of this Product Management bundle The online test with immediate results You can study and complete the Product Management bundle at your own pace. Study for the Product Management bundle using any internet-connected device, such as a computer, tablet, or mobile device. Each course in this Product Management & Business Management bundle holds a prestigious CPD accreditation, symbolising exceptional quality. The materials, brimming with knowledge, are regularly updated, ensuring their relevance. This bundle promises not just education but an evolving learning experience. Engage with this extraordinary collection, and prepare to enrich your personal and professional development. Embrace the future of learning with Product Management & Business Management, a rich anthology of 30 diverse courses. Each course in the Product Management bundle is handpicked by our experts to ensure a wide spectrum of learning opportunities. This Product Management & Business Management bundle will take you on a unique and enriching educational journey. The bundle encapsulates our mission to provide quality, accessible education for all. Whether you are just starting your career, looking to switch industries, or hoping to enhance your professional skill set, the Product Management & Business Management bundle offers you the flexibility and convenience to learn at your own pace. Make the Product Management package your trusted companion in your lifelong learning journey. CPD 300 CPD hours / points Accredited by CPD Quality Standards Who is this course for? The Product Management bundle is perfect for: Lifelong learners looking to expand their knowledge and skills. Professionals seeking to enhance their career with CPD certification. Individuals wanting to explore new fields and disciplines. Anyone who values flexible, self-paced learning from the comfort of home. Career path Unleash your potential with the Product Management & Business Management bundle. Acquire versatile skills across multiple fields, foster problem-solving abilities, and stay ahead of industry trends. Ideal for those seeking career advancement, a new professional path, or personal growth. Embrace the journey with the Product Management & Business Management bundle package. Certificates CPD Quality Standard Certificate Digital certificate - Included 30 CPD Quality Standard Certificates - Free

Product Management & Business Management - 30 CPD Courses Bundle
Delivered Online On Demand6 days
£199

Travel and Tourism Management Diploma - 30 CPD Courses!

By NextGen Learning

Get ready for an exceptional online learning experience with the Travel and Tourism Managementbundle! This carefully curated collection of 30 premium courses is designed to cater to a variety of interests and disciplines. Dive into a sea of knowledge and skills, tailoring your learning journey to suit your unique aspirations. The Travel and Tourism Management is a dynamic package, blending the expertise of industry professionals with the flexibility of digital learning. It offers the perfect balance of foundational understanding and advanced insights. Whether you're looking to break into a new field or deepen your existing knowledge, the Travel and Tourism Management package has something for everyone. As part of the Travel and Tourism Management package, you will receive complimentary PDF certificates for all courses in this bundle at no extra cost. Equip yourself with the Travel and Tourism Management bundle to confidently navigate your career path or personal development journey. Enrol today and start your career growth! This Bundle Comprises the Following Travel and Tourism ManagementCPD Accredited Courses: Course 01: Travel and Tourism Management Diploma Course 02: Travel Administrator Course 03: Travel Blogger Course 04: Tour Guide Training Course 05: Leisure Management Course 06: Hospitality Management Level 2 Course 07: Hospitality - Concierge Course 08: Communicate and Work With People From Other Culture Course 09: Restaurant Management Course 10: Catering - Catering Management Course 11: Event Planner Course 12: Digital Photography Diploma Course 13: Facilities Management Diploma Course 14: Airport Management Course Course 15: PR : Public Relation Course 16: Social Media Influencer Course 17: Sales: Psychology of Customers Course 18: Diploma in Customer Relationship Management (CRM) Course 19: Marketing Communication Course 20: Effective Communication with Better Email Course 21: Master Yourself in Talking with Strangers Course 22: Public Speaking Training Course 23: Career Development Plan Fundamentals Course 24: CV Writing and Job Searching Course 25: Learn to Level Up Your Leadership Course 26: Networking Skills for Personal Success Course 27: Ace Your Presentations: Public Speaking Masterclass Course 28: Learn to Make a Fresh Start in Your Life Course 29: Decision Making and Critical Thinking Course 30: Time Management Training - Online Course What will make you stand out? Upon completion of this online Travel and Tourism Management bundle, you will gain the following: CPD QS Accredited Proficiency with this Travel and Tourism Management bundle After successfully completing the Travel and Tourism Management bundle, you will receive a FREE CPD PDF Certificates as evidence of your newly acquired abilities. Lifetime access to the whole collection of learning materials of this Travel and Tourism Management bundle The online test with immediate results You can study and complete the Travel and Tourism Management bundle at your own pace. Study for the Travel and Tourism Management bundle using any internet-connected device, such as a computer, tablet, or mobile device. Each course in this Travel and Tourism Management bundle holds a prestigious CPD accreditation, symbolising exceptional quality. The materials, brimming with knowledge, are regularly updated, ensuring their relevance. This bundle promises not just education but an evolving learning experience. Engage with this extraordinary collection, and prepare to enrich your personal and professional development. Embrace the future of learning with the Travel and Tourism Management, a rich anthology of 30 diverse courses. Each course in the Travel and Tourism Management bundle is handpicked by our experts to ensure a wide spectrum of learning opportunities. ThisTravel and Tourism Management bundle will take you on a unique and enriching educational journey. The bundle encapsulates our mission to provide quality, accessible education for all. Whether you are just starting your career, looking to switch industries, or hoping to enhance your professional skill set, the Travel and Tourism Management bundle offers you the flexibility and convenience to learn at your own pace. Make the Travel and Tourism Management package your trusted companion in your lifelong learning journey. CPD 300 CPD hours / points Accredited by CPD Quality Standards Who is this course for? The Travel and Tourism Management bundle is perfect for: Lifelong learners looking to expand their knowledge and skills. Professionals seeking to enhance their career with CPD certification. Individuals wanting to explore new fields and disciplines. Anyone who values flexible, self-paced learning from the comfort of home. Requirements You are cordially invited to enroll in this Travel and Tourism Management bundle; please note that there are no formal prerequisites or qualifications required. We've designed this curriculum to be accessible to all, irrespective of prior experience or educational background. Career path Unleash your potential with the Travel and Tourism Management bundle. Acquire versatile skills across multiple fields, foster problem-solving abilities, and stay ahead of industry trends. Ideal for those seeking career advancement, a new professional path, or personal growth. Embrace the journey with the Travel and Tourism Managementbundle package. Certificates CPD Quality Standard Certificate Digital certificate - Included 30 CPD Quality Standard Certificates - Free

Travel and Tourism Management Diploma - 30 CPD Courses!
Delivered Online On Demand5 days
£199

Motivating, Team Management and HR Management - Endorsed Training

4.7(47)

By Academy for Health and Fitness

***24 Hour Limited Time Flash Sale*** Motivating, Team Management and HR Management - Endorsed Training Admission Gifts FREE PDF & Hard Copy Certificate| PDF Transcripts| FREE Student ID| Assessment| Lifetime Access| Enrolment Letter Unlock the secrets of effective leadership with our Motivating, Team Management, and HR Management - Endorsed Training bundle! This power-packed collection of eight courses is designed to propel your career to new heights and equip you with the knowledge and skills necessary to excel in the dynamic world of people management. With three QLS-endorsed courses at its core, this bundle offers you the opportunity to dive deep into the intricacies of Motivating, Performance Managing, and Maintaining Team Culture in a Remote Team. But that's not all! Our bundle also includes five CPD QS accredited courses that perfectly complement your QLS-endorsed training. From Recruitment Consultant Level 5 to Employment Law, Certificate in HR Audit, Safer Recruitment Training, and Leadership Training, these courses cover a wide range of essential topics in the field of HR management. Expand your knowledge and stay ahead of the curve with these valuable additions to your professional repertoire. Key Features of the Motivating, Team Management and HR Management - Endorsed Training Bundle: 3 QLS-Endorsed Courses: We proudly offer 3 QLS-endorsed courses within our Motivating, Team Management and HR Management - Endorsed Training bundle, providing you with industry-recognized qualifications. Plus, you'll receive a free hardcopy certificate for each of these courses. QLS Course 01: Motivating, Performance Managing and Maintaining Team Culture in a Remote Team QLS Course 02: Team Management QLS Course 03: HR Management 5 CPD QS Accredited Courses: Additionally, our bundle includes 5 relevant CPD QS accredited courses, ensuring that you stay up-to-date with the latest industry standards and practices. Course 01: Recruitment Consultant Level 5 Course 02: Employment Law Course 03: Certificate in HR Audit Course 04: Safer Recruitment Training Course 05: Leadership Training In Addition, you'll get Five Career Boosting Courses absolutely FREE with this Bundle. Course 01: Professional CV Writing Course 02: Job Search Skills Course 03: Self-Esteem & Confidence Building Course 04: Professional Diploma in Stress Management Course 05: Complete Communication Skills Master Class Convenient Online Learning: Our Motivating, Team Management and HR Management - Endorsed Training courses are accessible online, allowing you to learn at your own pace and from the comfort of your own home. Learning Outcomes: Master the art of motivating individuals and teams to achieve peak performance. Develop advanced techniques for managing and maintaining team culture, even in remote work settings. Gain a comprehensive understanding of the principles and practices of HR management. Acquire in-depth knowledge of recruitment consultancy and employment law. Enhance your skills in HR auditing and ensuring compliance. Learn effective strategies for safer recruitment practices. Cultivate strong leadership qualities and inspire others to excel. Immerse yourself in the world of people management with our Motivating, Team Management, and HR Management - Endorsed Training bundle. This comprehensive collection of eight courses combines three QLS-endorsed courses and five CPD QS accredited courses to provide you with a well-rounded education in the art of effective leadership. From understanding the intricacies of motivating individuals and teams to mastering HR management practices, this bundle covers it all. Unlock your potential, broaden your skillset, and propel your career to new heights with this invaluable training opportunity. CPD 250 CPD hours / points Accredited by CPD Quality Standards Who is this course for? HR professionals seeking to enhance their knowledge and skills Managers and team leaders aiming to improve their leadership abilities Individuals aspiring to enter the field of HR management Professionals looking to advance their careers in people management Career path HR Manager: £30,000 - £70,000 per annum Recruitment Consultant: £25,000 - £40,000 per annum Team Leader: £25,000 - £50,000 per annum Training and Development Manager: £35,000 - £65,000 per annum HR Consultant: £30,000 - £60,000 per annum Operations Manager: £35,000 - £80,000 per annum Certificates Digital certificate Digital certificate - Included Hard copy certificate Hard copy certificate - Included

Motivating, Team Management and HR Management - Endorsed Training
Delivered Online On Demand46 hours
£309

Geology, Ecology & Environmental Law - 3 Endorsed Certificate

4.7(47)

By Academy for Health and Fitness

Begin your journey towards a rewarding and successful career by enrolling in our all-inclusive bundle of 8 Geology, Ecology & Environmental Law-3 Endorsed Certificate courses. At UKHF Online, we have carefully selected and combined these courses to equip you with the vital skills and knowledge necessary to thrive in Geology, Ecology & Environmental Law: A 3-Endorsed Certificate. Whether you're a student, recent graduate, or job seeker, our Geology, Ecology & Environmental Law: 3-Endorsed Certificate bundle is designed to enhance your CV, impress potential employers, and set you apart from the competition. Key Features of the Geology, Ecology & Environmental Law 3-Endorsed Certificate Bundle: 3 QLS-Endorsed Courses: We proudly offer 3 QLS-endorsed courses within our Geology, Ecology & Environmental Law (3-Endorsed Certificate) bundle, providing you with industry-recognized qualifications. Plus, you'll receive a free hardcopy certificate for each of these courses. QLS Course 01: Geology QLS Course 02: Ecology QLS Course 03: Environmental Law 5 CPD QS Accredited Courses: Additionally, our bundle includes 5 relevant CPD QS accredited courses, ensuring that you stay up-to-date with the latest industry standards and practises. Course 01: Conservation Diploma Course Course 02: Marine Biology Course-Online Diploma Course 03: Environmental Law 2023 Course 04: Meteorology Course 05: DNA and Genealogy In addition, you'll get five career-boosting courses absolutely free with this bundle. Course 01: Professional CV Writing Course 02: Job Search Skills Course 03: Self-Esteem and Confidence Building Course 04: Professional Diploma in Stress Management Course 05: Complete Communication Skills Master Class Convenient Online Learning: Our Geology, Ecology & Environmental Law 3-Endorsed Certificate courses are accessible online, allowing you to learn at your own pace and from the comfort of your own home. Learning Outcomes of Geology, Ecology & Environmental Law: 3 Endorsed Certificate Bundles: Master the foundational principles and techniques of Geology, Ecology & Environmental Law with the 3-endorsed Endorsed Certificate. Develop advanced proficiency in Geology, Ecology & Environmental Law-3-Endorsed Certificate methodologies and strategies. Acquire in-depth knowledge of the latest trends and advancements in Geology, Ecology & Environmental Law with the 3-endorsed Endorsed Certificate. Enhance your problem-solving and critical thinking abilities within the context of Geology, Ecology & Environmental Law: A 3-Endorsed Certificate. Cultivate strong communication and collaboration skills essential for success in Geology, Ecology & Environmental Law (Endorsed Certificate). The Geology, Ecology & Environmental Law: 3 Endorsed Certificate Bundle is a comprehensive collection of courses that have been meticulously designed to provide you with a well-rounded education in Geology, Ecology & Environmental Law: 3 Endorsed Certificate. With a combination of 3 QLS-endorsed courses and 5 CPD QS-accredited courses, this bundle offers you the perfect balance of essential knowledge and valuable skills. What's more, we are proud to offer free hardcopy certificates for each course within the Geology, Ecology & Environmental Law-3 Endorsed Certificates bundle, giving you the recognition you deserve. CPD 250 CPD hours / points Accredited by CPD Quality Standards Who is this course for? Individuals interested in science and the natural world Professionals seeking to expand their knowledge and skills in environmental science. Those looking to explore careers in ecology, genetics, or geology Students interested in pursuing further studies in these fields Career path This bundle will be beneficial to anybody planning to start a career as: Environmental Scientist Geneticist Geologist Marine Biologist Meteorologist Environmental Lawyer Certificates Digital certificate Digital certificate - Included Hard copy certificate Hard copy certificate - Included

Geology, Ecology & Environmental Law - 3 Endorsed Certificate
Delivered Online On Demand44 hours
£309

Train the Trainer Online - Mega Bundle

By Lead Academy

14 CPD UK & IPHM Accredited Courses Bundle | Recognised Certificate | MCQ based Exam and Tutor Support Included | Lifetime Access | Instant Result | Interactive Video Training Are you looking to begin your teaching career or want to develop more advanced skills in teaching? Then this train the trainer course will set you up with a solid foundation to become a confident teacher or trainer and help you to develop your expertise in teaching. This bundle course has been designed with 14 CPD UK & IPHM accredited courses to provide the ultimate learning experience for our learners to further develop their expertise in their chosen field. Gain the essentials skills and knowledge you need to propel your career forward as a teacher or trainer. This Bundle Package Includes: The following courses of the train the trainer course will set you up with a solid foundation in the teaching industry and give you the essential skills you need to succeed! Teacher Training at QLS Level 3 Early Years SEN Teaching at QLS Level 5 Train The Trainer - All Levels at QLS Level 5 Instructional Design at QLS Level 5 EYFS Teaching Diploma Paediatric First Aid Training Applied Behavioural Analysis (ABA) Children with Autism - Early Intervention School Shadow Support Teacher Psycho-Physical Activity for Kid (PPA) Child Counsellor at QLS Level 3 Safeguarding ADHD - Study Skills PowerPoint Presentation Skills For Teachers If you're interested in working as a teacher or trainer or want to learn more skills in teaching but unsure of where to start, then this train the trainer course will set you up with a solid foundation to become a confident teacher or trainer and develop more advanced skills. The train the trainer course will set you up with the appropriate skills and experience needed for the job and is ideal for both beginners and those currently working as a teacher or trainer. The train the trainer courses bundle will help learners to fully enhance their skill set in team leading and active monitoring. By combining these related courses, learners will be equipped with a wide range of desirable skills to fast track their career. This comprehensive train the trainer course is the perfect way to kickstart your career in the field of teaching. This train the trainer course will give you a competitive advantage in your career, making you stand out from all other applicants and employees. This train the trainer course supports learners of all skill levels. Whether you're an intermediate or advanced learner looking to brush up on your skills or a beginner wanting to start a new career or learn something new, our dedicated team of expert tutors are on hand to guide you through your learning every step of the way from enrolment to course completion. As one of the leading course providers and most renowned e-learning specialists online, we're dedicated to giving you the best educational experience possible. This train the trainer course is crafted by industry expert, to enable you to learn quickly and efficiently, and at your own pace and convenience. Why Choose this Train The Trainer Course: 14 Courses Bundle in your desired field Boost your skills in teaching Endorsed by The Quality Licence Scheme Accredited by The CPD UK and International Practitioners of Holistic Medicine (IPHM) MCQ Based Exam & Industry Expert Support Included Dual (CPD UK and IPHM) recognised accredited certificate in 1 course Learn from industry experts Lifetime Access High-quality e-learning study materials Self-paced, no fixed schedules 24/7 customer support through email Available to students anywhere in the world Study in a user-friendly, advanced online learning platform Who is this train the trainer course for? This comprehensive train the trainer bundle course are suitable for anyone looking to improve their job prospects or aspiring to accelerate their career in this sector and want to gain in-depth knowledge of teaching. Entry Requirement There are no academic entry requirements for this course, and it is open to students of all academic backgrounds. Course Curriculum Teacher Training at QLS Level 3 Early Years SEN Teaching at QLS Level 5 Train the Trainer - All Levels at QLS Level 5 Instructional Design at QLS Level 5 EYFS Teaching Diploma Paediatric First Aid Training Applied Behavioural Analysis (ABA) Children with Autism - Early Intervention School Shadow Support Teacher Psycho-Physical Activity for Kid (PPA) Child Counsellor at QLS Level 3 Safeguarding ADHD - Study Skills PowerPoint Presentation Skills for Teachers Recognised Accreditation CPD Certification Service This course is accredited by continuing professional development (CPD). CPD UK is globally recognised by employers, professional organisations, and academic institutions, thus a certificate from CPD Certification Service creates value towards your professional goal and achievement. CPD certificates are accepted by thousands of professional bodies and government regulators here in the UK and around the world. Many organisations look for employees with CPD requirements, which means, that by doing this course, you would be a potential candidate in your respective field. Quality Licence Scheme Endorsed The Quality Licence Scheme is a brand of the Skills and Education Group, a leading national awarding organisation for providing high-quality vocational qualifications across a wide range of industries. It will give you a competitive advantage in your career, making you stand out from all other applicants and employees.     Certificate of Achievement Endorsed Certificate from Quality Licence Scheme After successfully passing the MCQ exam you will be eligible to obtain the Endorsed Certificate by Quality Licence Scheme. The Quality Licence Scheme is a brand of the Skills and Education Group, a leading national awarding organization for providing high-quality vocational qualifications across a wide range of industries. It will give you a competitive advantage in your career, making you stand out from all other applicants and employees. There is a Quality Licence Scheme endorsement fee to obtain an endorsed certificate which is £65 and will be charged separately for each course. Certificate of Achievement from Lead Academy After successfully passing the MCQ exam, you will be eligible to order your certificate of achievement as proof of your new skill. The certificate of achievement is an official credential that confirms that you successfully finished a course with Lead Academy. You/your employer can verify your certificate through our website. Certificate can be obtained in PDF version and will be charged separately for each course, at a cost of £12, and there is an additional fee to obtain a printed copy certificate which is £35. FAQs Is CPD a recognised qualification in the UK? CPD is globally recognised by employers, professional organisations and academic intuitions, thus a certificate from CPD Certification Service creates value towards your professional goal and achievement. CPD-certified certificates are accepted by thousands of professional bodies and government regulators here in the UK and around the world. Are QLS courses recognised? Although QLS courses are not subject to Ofqual regulation, they must adhere to an extremely high level that is set and regulated independently across the globe. A course that has been approved by the Quality Licence Scheme simply indicates that it has been examined and evaluated in terms of quality and fulfils the predetermined quality standards. When will I receive my certificate? For CPD accredited PDF certificate it will take 24 hours, however for the hardcopy CPD certificate takes 5-7 business days and for the Quality License Scheme certificate it will take 7-9 business days. Can I pay by invoice? Yes, you can pay via Invoice or Purchase Order, please contact us at info@lead-academy.org for invoice payment. Can I pay via instalment? Yes, you can pay via instalments at checkout. How to take online classes from home? Our platform provides easy and comfortable access for all learners; all you need is a stable internet connection and a device such as a laptop, desktop PC, tablet, or mobile phone. The learning site is accessible 24/7, allowing you to take the course at your own pace while relaxing in the privacy of your home or workplace. Does age matter in online learning? No, there is no age limit for online learning. Online learning is accessible to people of all ages and requires no age-specific criteria to pursue a course of interest. As opposed to degrees pursued at university, online courses are designed to break the barriers of age limitation that aim to limit the learner's ability to learn new things, diversify their skills, and expand their horizons. When I will get the login details for my course? After successfully purchasing the course, you will receive an email within 24 hours with the login details of your course. Kindly check your inbox, junk or spam folder, or you can contact our client success team via info@lead-academy.org

Train the Trainer Online - Mega Bundle
Delivered Online On Demand
£79

DP-080T00 Querying Data with Microsoft Transact-SQL

By Nexus Human

Duration 2 Days 12 CPD hours This course is intended for This course can be valuable for anyone who needs to write basic SQL or Transact-SQL queries. This includes anyone working with data as a data analyst, a data engineer, a data scientist, a database administrator or a database developer. It can also be useful for others peripherally involved with data, or wanting to learn more about working with data such as solution architects, students and technology managers. This course will teach the basics of Microsoft's dialect of the standard SQL language: Transact-SQL. Topics include both querying and modifying data in relational databases that are hosted in Microsoft SQL Server-based database systems, including: Microsoft SQL Server, Azure SQL Database and, Azure Synapse Analytics. 1 - Introduction to Transact-SQL Work with schemas Explore the structure of SQL statements Examine the SELECT statement Work with data types Handle NULLs 2 - Sort and filter results in T-SQL Sort your results Limit the sorted results Page results Remove duplicates Filter data with predicates 3 - Combine multiple tables with JOINs in T-SQL Understand joins concepts and syntax Use inner joins Use outer joins Use cross joins Use self joins 4 - Write Subqueries in T-SQL Understand subqueries Use scalar or multi-valued subqueries Use self-contained or correlated subqueries 5 - Use built-in functions and GROUP BY in Transact-SQL Categorize built-in functions Use scalar functions Use ranking and rowset functions Use aggregate functions Summarize data with GROUP BY Filter groups with HAVING 6 - Modify data with T-SQL Insert data Generate automatic values Update data Delete data Merge data based on multiple tables Additional course details: Nexus Humans DP-080T00 Querying Data with Microsoft Transact-SQL 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 DP-080T00 Querying Data with Microsoft Transact-SQL 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.

DP-080T00 Querying Data with Microsoft Transact-SQL
Delivered OnlineFlexible Dates
£1,190

Teaching English Level 5

4.9(27)

By Apex Learning

Boost Your Career with Apex Learning and Get Noticed By Recruiters in this Hiring Season! Save Up To £4,169 and get Hard Copy + PDF Certificates + Transcript + Student ID Card worth £160 as a Gift - Enrol Now With a single payment you will gain access to Teaching English Level 5 including 10 Career development courses, original hardcopy certificate, transcript and a student ID card which will allow you to get discounts on things like music, food, travel and clothes etc. Prove that you are committed to Social Care and Community Welfare by training for your mandatory Care Certificate. This course provides all the principles, knowledge, and skills that you will need to absorb, to carry out exemplary Social Care. The Teaching English Level 5 course has been written with the help of industry professionals and lays out all of the EU/UK standards for delivering care to the community. You will be taught how to safeguard the vulnerable, provide appropriate nutrition, respect privacy and dignity, support those with challenges and disabilities, and ensure hygiene and cleanliness. Understand your responsibilities in the Social Sector today. Take this course anywhere and at any time. Don't let your lifestyle limit your learning or your potential. Teaching English Level 5 will provide you with the CPD certificate that you'll need to succeed. Gain experience online and interact with experts. This can prove to be the perfect way to get noticed by a prospective employer and stand out from the crowd. Teaching English Level 5 has been rated and reviewed highly by our learners and professionals alike. We have a passion for teaching, and it shows. All of our courses have interactive online modules that allow studying to take place where and when you want it to. The only thing you need to take Teaching English Level 5 is Wi-Fi and a screen. You'll never be late for class again. Experienced tutors and mentors will be there for you whenever you need them, and solve all your queries through email and chat boxes. Benefits you'll get choosing Apex Learning for this Teaching English Level 5: One payment, but lifetime access to 11 CPD courses Certificates, student ID for the title course included in a one-time fee Full tutor support available from Monday to Friday Free up your time - don't waste time and money travelling for classes Accessible, informative modules taught by expert instructors Learn at your ease - anytime, from anywhere Study the course from your computer, tablet or mobile device CPD accredited course - improve the chance of gaining professional skills What other courses are included with this Teaching English Level 5? Level 2 Microsoft Office Essentials Microsoft Teams Leadership & Management Diploma Working from Home Essentials Mental Health and Working from Home Online Meeting Management Effective Communication Skills Time Management Report Writing Emotional Intelligence and Human Behaviour Curriculum ***Teaching English Level 5*** Introduction to Teaching English Linguistics Basics Working With a Variety of Approaches Teaching Speaking Teaching Listening Teaching Reading Teaching Writing Planning Pedagogy Planning Lessons Managing Classrooms Getting a job How will I get my Certificate? After successfully completing the course you will be able to order your CPD Accredited Certificates (PDF + Hard Copy) as proof of your achievement. PDF Certificate: Free (Previously it was £10 * 11 = £110) Hard Copy Certificate: Free (For The Title Course) If you want to get hardcopy certificates for other courses, generally you have to pay £20 for each. But this Fall, Apex Learning is offering a Flat 50% discount on hard copy certificates, and you can get each for just £10! P.S. The delivery charge inside the U.K. is £3.99 and the international students have to pay £9.99. CPD 10 CPD hours / points Accredited by CPD Quality Standards Who is this course for? There is no experience or previous qualifications required for enrolment on this Teaching English Level 5. It is available to all students, of all academic backgrounds. Requirements Our Teaching English Level 5 is fully compatible with PC's, Mac's, Laptop, Tablet and Smartphone devices. This course has been designed to be fully compatible on tablets and smartphones so you can access your course on wifi, 3G or 4G. There is no time limit for completing this course, it can be studied in your own time at your own pace. Career path Having these various CPD certificate will increase the value in your CV and open you up to multiple sectors such as Business & Management, Admin, Accountancy & Finance, Secretarial & PA, Teaching & Mentoring etc. Certificates Certificate of completion Digital certificate - Included Certificate of completion Hard copy certificate - Included You will get the Hard Copy certificate for the title course absolutely Free! Other Hard Copy certificates are available for £10 each. Please Note: The delivery charge inside the UK is £3.99, and the international students must pay a £9.99 shipping cost.

Teaching English Level 5
Delivered Online On Demand
£39

Educational Psychology Diploma - CPD Accredited

4.9(27)

By Apex Learning

Give a compliment to your career and take it to the next level. This Educational Psychology bundle will provide you with the essential knowledge to shine in your professional career. Whether you want to develop skills for your next job or elevate your skills for your next promotion, this Educational Psychology bundle will help you stay ahead of the pack. Throughout the Educational Psychology programme, it stresses how to improve your competency as a person in your chosen field while also outlining essential career insights in the relevant job sector. Along with this Educational Psychology course, you will get 10 premium courses, an original hardcopy, 11 PDF certificates (Main Course + Additional Courses) Student ID card as gifts. This Educational Psychology Bundle Consists of the following Premium courses: Course 01: Educational Psychology and Development Course 02: Child Psychology Course 03: EYFS Teaching - Level 3 Course 04: Education and Pedagogy Course 05: Phonics Teaching Assistant Course 06: Learning Disability Awareness Course 07: SEN Teaching Diploma Course 08: British Sign Language (BSL) Level 1 & 2 with Bonus Module Course 09: Parenting Skills Training Course 10: Lesson Planning for Teaching Course 11: Effective Communication Skills Key features of this Educational Psychology course: This Educational Psychology bundle is CPD QS Accredited Learn from anywhere in the world Lifetime access Our Educational Psychology is entirely online 24/7 Learner support The Educational Psychology bundle incorporates basic to advanced level skills to shed some light on your way and boost your career. Hence, you can strengthen your Educational Psychology expertise and essential knowledge, which will assist you in reaching your goal. Moreover, you can learn Educational Psychology from any place in your own time without travelling for classes. Enrol now in Educational Psychology to advance your career, and use the premium study materials from Apex Learning. The Educational Psychology bundle incorporates basic to advanced level skills to shed some light on your way and boost your career. Hence, you can strengthen your Educational Psychology expertise and essential knowledge, which will assist you in reaching your goal. Moreover, you can learn from any place in your own time without travelling for classes. Curriculum: Educational Psychology and Development An Overview Educational Psychology and its History Behavioural Views of Learning Cognitive Development Social, Moral and Emotional Development Constructivism and Motivation Dyslexia and Learning Difficulties Applying Educational Psychology to Teaching Effective Instruction and Technology in Education Opportunities and Careers in Educational Psychology ------------ 10 more Educational Psychology related courses------------- How will I get my Educational Psychology Certificate? After successfully completing the Educational Psychology course, you will be able to order your CPD Accredited Certificates (PDF + Hard Copy) as proof of your achievement. PDF Certificate: Free (Previously it was £6*11 = £66) Hard Copy Certificate: Free (For The Title Course: Previously it was £10) PS The delivery charge inside the UK is £3.99, and the international students have to pay £9.99. CPD 110 CPD hours / points Accredited by CPD Quality Standards Who is this course for? Aspiring educators seeking a comprehensive foundation in educational psychology Early Years practitioners aiming to enhance their skills and knowledge in EYFS teaching Teachers seeking to deepen their understanding of child development and learning disabilities Parents and individuals passionate about understanding and supporting children's learning Requirements This Educational Psychology course has been designed to be fully compatible with tablets and smartphones. Career path Having this Educational Psychology expertise will increase the value of your CV and open you up to multiple job sectors: Teacher: £25,714 - £40,042 Early Years Educator: £24,000 - £35,000 Special Educational Needs (SEN) Practitioner: £24,000 - £35,000 Teaching Assistant: £18,000 - £25,000 Educational Psychologist: £30,000 - £50,000 Educational Researcher: £25,000 - £40,000 Certificates CPDQS Accredited e-Certificate Digital certificate - Included CPDQS Accredited Hard-Copy Certificate Hard copy certificate - Included You will get the Hard Copy certificate for the title course (Educational Psychology and Development) absolutely Free! Other hard-copy certificates are available for £10 each. Please Note: The delivery charge inside the UK is £3.99, and the international students must pay a £9.99 shipping cost.

Educational Psychology Diploma - CPD Accredited
Delivered Online On Demand
£39

Copywriting, Content Writing & Proofreading QLS Endorsed Diploma

By Compliance Central

Recent studies show a growing demand for professionals adept in Copywriting, Content Writing & Proofreading, reflecting the evolving landscape of communication in the digital era. With the rise of online content consumption, businesses are seeking skilled individuals who can craft compelling narratives, ensure linguistic precision, and maintain brand integrity. Our comprehensive Copywriting, Content Writing & Proofreading QLS Endorsed Diploma bundle encapsulates a diverse array of theoretical knowledge and practical applications, equipping learners with the expertise needed to excel in these crucial domains. In today's fast-paced digital world, effective communication is paramount. Harnessing the power of words, whether in marketing copy, engaging content, or meticulous proofreading, can significantly impact audience engagement and organisational success. This Copywriting, Content Writing & Proofreading bundle not only delves deep into the intricacies of copywriting, content creation, and proofreading but also provides valuable insights into related fields such as creative writing, email etiquette, and career development. Encompassing a blend of theoretical concepts and hands-on exercises, this Copywriting, Content Writing & Proofreading course bundle offers a holistic learning experience designed to elevate your proficiency in Copywriting, Content Writing & Proofreading to new heights. Bundle Include includes: QLS Endorsed Courses: Course 01: Diploma in Copywriting at QLS Level 4 Course 02: Diploma in Content Writing at QLS Level 4 Course 03: Diploma in Proofreading & Copy Editing at QLS Level 5 CPD QS Accredited Courses: Course 04: Creative Writing Course - Fiction Course 05: Screenwriting & Scriptwriting Course 06: Email Writing: Styles and Templates Course 07: English: Spelling, Punctuation, and Grammar Course 08: Touch Typing Essentials Course 09: Document Control Course 10: 120 hours TEFL (TESOL) Masterclass Course 11: 200 Common English Idioms and Phrases Take your career to the next level with our bundle that includes technical courses and five guided courses focused on personal development and career growth. Course 12: Career Development Plan Fundamentals Course 13: CV Writing and Job Searching Course 14: Networking Skills for Personal Success Course 15: Ace Your Presentations: Public Speaking Masterclass Course 16: Decision Making and Critical Thinking Seize this opportunity to elevate your career with our comprehensive bundle, endorsed by the prestigious QLS and accredited by CPD.Copywriting, Content Writing & Proofreading QLS Endorsed Diploma. Learning Outcomes: Develop a comprehensive understanding of Copywriting, Content Writing & Proofreading principles. Acquire proficiency in crafting persuasive copy and engaging content tailored to specific audiences through Copywriting, Content Writing & Proofreading course. Master the art of proofreading and copy editing to ensure accuracy and clarity in written communication. Expand creative writing skills through exploration of fiction and screenwriting techniques. Enhance language proficiency in spelling, punctuation, and grammar by Copywriting, Content Writing & Proofreading course. Gain insights into effective email writing, document control, and touch typing essentials. Course Description: Embark on a journey of linguistic mastery with our Copywriting, Content Writing & Proofreading bundle encompassing the fundamental pillars of effective communication. Dive into the world of Copywriting, Content Writing & Proofreading, exploring the nuances of crafting compelling narratives, refining language mechanics, and ensuring precision in every word. Through a series of meticulously curated modules, learners will unravel the secrets behind captivating content creation, delve into the art of linguistic finesse, and hone their proofreading prowess to perfection. Discover the art of storytelling through creative writing, delve into the intricacies of scriptwriting, and unlock the keys to seamless email communication. With a focus on practical application and theoretical comprehension, this Copywriting, Content Writing & Proofreading course bundle empowers learners to navigate the complexities of written communication with confidence and finesse. Whether you aspire to pursue a career in marketing, journalism, or creative writing, this Copywriting, Content Writing & Proofreading bundle serves as a comprehensive guide to mastering the art of effective communication in the digital age. CPD 160 CPD hours / points Accredited by CPD Quality Standards Who is this course for? This Copywriting, Content Writing & Proofreading course is ideal for: Aspiring copywriters seeking to enhance their writing skills. Content creators aiming to produce compelling and engaging material. Professionals looking to refine their proofreading and editing abilities. Individuals interested in exploring the realms of creative writing and scriptwriting. Anyone seeking to improve their language proficiency and communication skills. Job seekers preparing to enhance their CV writing and networking abilities. Requirements You are warmly invited to register for this bundle. Please be aware that there are no formal entry requirements or qualifications necessary. This curriculum has been crafted to be open to everyone, regardless of previous experience or educational attainment. Career path Upon completion of the Copywriting, Content Writing & Proofreading courses, you will be able to: Copywriter Content Creator Proofreader/Copy Editor Creative Writer Marketing Specialist Communications Manager Journalist Certificates 13 CPD Quality Standard Certificates Digital certificate - Included 3 QLS Endorsed Certificates Hard copy certificate - Included

Copywriting, Content Writing & Proofreading QLS Endorsed Diploma
Delivered Online On Demand4 days
£310

IATP - Non-Licensable Work With Asbestos Including NNLW

By Airborne Environmental Consultants Ltd

This course provides the delegate with the theoretical and practical skills to undertake non-licensed works with ACM's. Persons requiring this type of training would include trade operatives undertaking tasks with ACM's as defined in HSG210 and in accordance with CAR 2012 Reg 3(2). In addition to the Asbestos Awareness, those employees whose work will knowingly disturb ACMs, and which is defined as non-licensable work or NNLW, should receive additional task-specific information, instruction and training.

IATP - Non-Licensable Work With Asbestos Including NNLW
Delivered in Manchester + 1 more or OnlineFlexible Dates
£175