12061 Teaching & Training courses in Mayfield delivered On Demand

Sales Overview: Online Soap Making Course Are you ready to embark on a creative journey into the world of soap making? Welcome to our comprehensive 'Online Soap Making Course,' where you'll discover the art and science behind crafting luxurious, custom-made soaps from the comfort of your own home.   Module 1: Introduction to Soap Making and Basic Soap Making Techniques In this introductory module, you'll delve into the fascinating history of soap making and learn about the essential ingredients and equipment needed to get started. From understanding the chemistry of saponification to mastering basic soap making techniques, you'll gain the foundational knowledge necessary to create your first batch of handmade soap with confidence. Module 2: Troubleshooting Soap Making Problems and Creating Custom Soap Recipes Encounter common challenges in soap making? Fear not! In this module, you'll learn how to troubleshoot issues such as lye calculations, seizing, and accelerating trace. Moreover, you'll explore the art of formulating custom soap recipes tailored to your preferences, including adjustments for fragrance, color, and skin type considerations. Module 3: Adding Fragrance and Color to Your Soap and Molding and Cutting Your Soap Elevate your soap making skills as you discover the secrets of adding delightful fragrances and vibrant colors to your creations. From essential oils to natural pigments, you'll learn how to incorporate various additives while ensuring optimal scent retention and color stability. Additionally, master the art of molding and cutting your soap into beautiful shapes and designs that will impress friends and family alike. Module 4: Storing and Using Your Soap and The Benefits of Soap Making Congratulations on completing your soap making journey! In this final module, you'll uncover best practices for storing and curing your handmade soaps to ensure longevity and quality. Moreover, explore the numerous benefits of soap making, from environmental sustainability to personalized skincare solutions, and discover how this ancient craft can enrich your life in meaningful ways.   Why Choose Our Online Soap Making Course? Comprehensive Curriculum: Our course offers a structured learning experience covering every aspect of soap making, from fundamentals to advanced techniques. Expert Guidance: Learn from experienced soap makers who are passionate about sharing their knowledge and empowering aspiring artisans. Convenience and Flexibility: Access course materials anytime, anywhere, and progress at your own pace to accommodate your busy schedule. Community Support: Join a vibrant community of fellow soap enthusiasts, where you can exchange ideas, seek advice, and celebrate your soap making successes together.   Ready to Transform Ordinary Ingredients Into Extraordinary Soaps? Enroll in Our Online Soap Making Course Today! Course Curriculum Module 1: Introduction to Soap Making and Basic Soap Making Techniques Introduction to Soap Making and Basic Soap Making Techniques 00:00 Module 2: Troubleshooting Soap Making Problems and Creating Custom Soap Recipes Troubleshooting Soap Making Problems and Creating Custom Soap Recipes 00:00 Module 3: Adding Fragrance and Color to Your Soap and Molding and Cutting Your Soap Adding Fragrance and Color to Your Soap and Molding and Cutting Your Soap 00:00 Module 4: Storing and Using Your Soap and The Benefits of Soap Making Storing and Using Your Soap and The Benefits of Soap Making 00:00

💻 Unlock the Power of Information: Information Management Course! 🌐 Ready to harness the full potential of information for organizational success? Enroll in our Information Management Course, a comprehensive program designed to empower you with the skills and knowledge needed to become a proficient information manager. Join us on a transformative journey where data meets strategy, and turn your passion for organized information into a dynamic career. 🌟 Module 1: Introduction to Information Management Embark on your information journey with Module 1, offering a comprehensive introduction to the dynamic world of information management. Explore the fundamental principles, practices, and the critical role information plays in organizational success. Lay the foundation for your career as an information management expert. 📜 Module 2: Information Governance Navigate the complex landscape of information governance with Module 2. Learn to establish policies, standards, and procedures that ensure the effective and secure use of information. Explore compliance, risk management, and ethical considerations, laying the groundwork for robust information governance practices. 🏰 Module 3: Information Architecture Build the foundation of organized information with Module 3, dedicated to information architecture. Explore the design and organization of information structures, ensuring accessibility, usability, and findability. Learn to create taxonomies, metadata frameworks, and user-centered information architectures for efficient data retrieval. 📊 Module 4: Data Management Master the art of data with Module 4, focusing on data management. Explore the lifecycle of data, from acquisition and storage to processing and analysis. Learn database management, data quality assurance, and the implementation of effective data governance practices. 📚 Module 5: Knowledge Management Transform information into organizational wisdom with Module 5, dedicated to knowledge management. Explore strategies for capturing, storing, and sharing organizational knowledge. Learn to foster a knowledge-sharing culture, leverage technology for collaboration, and enhance decision-making processes. 🌟 Why Choose Our Information Management Course? Industry-Experienced Instructors: Learn from seasoned information management professionals with a wealth of hands-on experience. Practical Learning: Engage in real-world projects, case studies, and simulations to apply your knowledge in a practical setting. Cutting-Edge Technologies: Familiarize yourself with the latest information management tools and technologies used in the industry. Career-Ready Skills: Graduate with skills that align with the demands of the evolving information management landscape. Don't miss the opportunity to become a steward of information excellence! Enroll now in the Information Management Course and position yourself for success in a field where your organizational skills and strategic thinking will shine. Your journey into the world of information management brilliance begins here! 💻✨🎓 Course Curriculum Module 1_ Introduction to Information Management. Introduction to Information Management. 00:00 Module 2_ Information Governance. Information Governance. 00:00 Module 3_ Information Architecture. Information Architecture. 00:00 Module 4_ Data Management. Data Management. 00:00 Module 5_ Knowledge Management. Knowledge Management. 00:00

Overview With the ever-increasing demand for Animation in personal & professional settings, this online training aims at educating, nurturing, and upskilling individuals to stay ahead of the curve - whatever their level of expertise in Animation may be. Learning about Animation or keeping up to date on it can be confusing at times, and maybe even daunting! But that's not the case with this course from Compete High. We understand the different requirements coming with a wide variety of demographics looking to get skilled in Animation . That's why we've developed this online training in a way that caters to learners with different goals in mind. The course materials are prepared with consultation from the experts of this field and all the information on Animation is kept up to date on a regular basis so that learners don't get left behind on the current trends/updates. The self-paced online learning methodology by compete high in this Animation course helps you learn whenever or however you wish, keeping in mind the busy schedule or possible inconveniences that come with physical classes. The easy-to-grasp, bite-sized lessons are proven to be most effective in memorising and learning the lessons by heart. On top of that, you have the opportunity to receive a certificate after successfully completing the course! Instead of searching for hours, enrol right away on this Animation course from Compete High and accelerate your career in the right path with expert-outlined lessons and a guarantee of success in the long run. Who is this course for? While we refrain from discouraging anyone wanting to do this Animation course or impose any sort of restrictions on doing this online training, people meeting any of the following criteria will benefit the most from it: Anyone looking for the basics of Animation , Jobseekers in the relevant domains, Anyone with a ground knowledge/intermediate expertise in Animation , Anyone looking for a certificate of completion on doing an online training on this topic, Students of Animation , or anyone with an academic knowledge gap to bridge, Anyone with a general interest/curiosity Career Path This Animation course smoothens the way up your career ladder with all the relevant information, skills, and online certificate of achievements. After successfully completing the course, you can expect to move one significant step closer to achieving your professional goals - whether it's securing that job you desire, getting the promotion you deserve, or setting up that business of your dreams.  Course Curriculum 16168 Chapter 1 The Baby Boomers Chapter 1 The Baby Boomers 00:00 Chapter 2 Baby Boomer Trends Chapter 2 Baby Boomer Trends 00:00 Chapter 3 Market Demands of the Boomers Chapter 3 Market Demands of the Boomers 00:00 Chapter 4 Health and Wellness in the Network Marketing Industry Chapter 4 Health and Wellness in the Network Marketing Industry 00:00 Chapter 5 Network Marketing Trends and Phrases Chapter 5 Network Marketing Trends and Phrases 00:00 Chapter 6 Building Your Own Product Awareness Chapter 6 Building Your Own Product Awareness 00:00 Module 5 Compliance and Ethics Module 5 Compliance and Ethics 00:00 Module 6 Risk and Types of Risk Module 6 Risk and Types of Risk 00:00 Module 7 Introduction to Risk Management Module 7 Introduction to Risk Management 00:00 Module 8 Risk Management Process Module 8 Risk Management Process 00:00 Module 1 Introduction to Compliance Module 1 Introduction to Compliance 00:00 Module 2 Five Basic Elements of Compliance Module 2 Five Basic Elements of Compliance 00:00 Module 4 Compliance Audit Module 4 Compliance Audit 00:00 Chapter 13 Dealing with Customer Objections Chapter 13 Dealing with Customer Objections 00:00 Chapter 14 Closing Techniques Chapter 14 Closing Techniques 00:00 Chapter 15 Connecting Sales and Persistence Chapter 15 Connecting Sales and Persistence 00:00 Chapter 16 Sales Management Chapter 16 Sales Management 00:00 Chapter 17 Sales Communications and Exhibitions Chapter 17 Sales Communications and Exhibitions 00:00 Chapter 18 Networking Success by Associations Chapter 18 Networking Success by Associations 00:00

🌟 Take Safety Home: Preventing Off-Job Injuries Online Training 🌟   Welcome to a groundbreaking online training course designed to empower individuals with the knowledge and skills to create a safer and healthier lifestyle beyond the workplace. The 'Take Safety Home' program is a comprehensive guide to preventing off-job injuries, ensuring the well-being of individuals in their personal lives. Here's a snapshot of the modules that make this course invaluable: Module 1: Introduction to Off Job Injuries Uncover the hidden risks and common types of off-job injuries with a detailed exploration of their causes. Understand the importance of being proactive in maintaining personal safety. Module 2: Creating a Safe Home Environment Learn practical strategies for cultivating a safe home environment, emphasizing physical fitness and exercise safety. Discover how simple adjustments can significantly reduce the risk of injuries within the comfort of your own home. Module 3: Safe Driving Practices Navigate the road with confidence by mastering safe driving practices. Explore the connection between maintaining a safe and healthy lifestyle outside of work and minimizing the risk of accidents on the road. Module 4: Emergency Preparedness Prepare for the unexpected with insights into emergency preparedness. From basic first aid to crisis management, this module equips you with the skills needed to handle unforeseen situations effectively. Module 5: Safety Culture Delve into the importance of fostering a safety culture in your daily life. Understand how sustaining safety for the future involves creating habits and mindsets that prioritize well-being both at home and at work. Module 6: Safety Integration in Daily Activities Integrate safety seamlessly into your daily routine. This module provides practical guidance on how to make safety a natural part of your everyday life. Complete the course with a personalized action plan for continuous improvement.   ✨ Key Benefits: Enhance personal safety awareness Reduce the risk of off-job injuries Develop a safety-oriented mindset Foster a healthier and happier lifestyle Create a safer home environment Improve driving practices and habits   💡 Who Should Enroll: Individuals seeking a holistic approach to safety Families looking to establish a safe home environment Professionals aiming for a healthier work-life balance Anyone committed to preventing off-job injuries   Join us in transforming your approach to safety and well-being. Enroll in the 'Take Safety Home' course today and embark on a journey toward a safer, healthier future both inside and outside the workplace! Course Curriculum Module 1- Introduction to Off Job Injuries and Common Types of Off Job Injuries Introduction to Off Job Injuries and Common Types of Off Job Injuries 00:00 Module 2- Creating a Safe Home Environment Physical Fitness and Exercise Safety Creating a Safe Home Environment Physical Fitness and Exercise Safety 00:00 Module 3- Safe Driving Practices and Maintaining a Safe and Healthy Lifestyle Outside of Work Safe Driving Practices and Maintaining a Safe and Healthy Lifestyle Outside of Work 00:00 Module 4- Emergency Preparedness and Ongoing Safety Awareness Emergency Preparedness and Ongoing Safety Awareness 00:00 Module 5- Safety Culture and Sustaining Safety for the Future Module 5- Safety Culture and Sustaining Safety for the Future 00:00 Module 6- Safety Integration in Daily Activities Review and Action Planning Safety Integration in Daily Activities Review and Action Planning 00:00

🌟 Unlock the Secrets to Hospitality Brilliance for Airbnb Success! 🌟 Are you ready to elevate your Airbnb hosting game and set new standards in hospitality excellence? Welcome to 'Hospitality Brilliance for Airbnb' - the ultimate online course designed to empower hosts like you to achieve unparalleled success in the world of short-term rentals!   🏡 Transform Your Space into a 5-Star Haven: Learn the insider secrets to curating a welcoming ambiance that guests can't resist. From decor tips to space optimization, discover how to create an unforgettable experience for your guests from the moment they step in.   🔑 Master the Art of Guest Experience: Craft exceptional guest experiences that garner rave reviews! Delve into communication strategies, anticipate guest needs, and exceed expectations every step of the way to ensure unforgettable stays.   💡 Marketing Magic for Maximum Bookings: Unlock the power of effective marketing! Harness social media, optimize your listing, and implement strategies to skyrocket your bookings and occupancy rates effortlessly.   📈 Boost Your Revenue & Ratings: Maximize your earnings while skyrocketing your Airbnb ratings! Gain insights into pricing strategies, guest satisfaction, and handling challenging situations with finesse.   🤝 Build a Stellar Reputation & Stand Out: Create a stellar reputation that sets you apart from the competition. Learn how to turn guests into loyal advocates who can't wait to return, spreading the word about your exceptional hosting.   🎓 What You'll Get: ️ Engaging video modules filled with actionable tips and techniques ️ Downloadable resources and templates for easy implementation ️ Exclusive access to a supportive community of like-minded hosts ️ Personalized feedback and guidance from industry experts   Join thousands of successful hosts who have transformed their Airbnb game with 'Hospitality Brilliance for Airbnb'! Ready to become a hospitality superstar and unlock the full potential of your Airbnb? Enroll now and embark on your journey to becoming a sought-after host in the realm of short-term rentals! Course Curriculum

🌟 Unlock Your Creative Potential with Camtasia 2 Essentials - Video Editing for the Posh! 🌟 Elevate your video editing game to new heights and create stunning, professional-quality videos effortlessly with our comprehensive online course - Camtasia 2 Essentials! Are you ready to:   ✨ Learn the ropes of video editing in the most sophisticated and stylish way possible? ✨ Craft videos that exude elegance and professionalism, setting you apart from the crowd? ✨ Master Camtasia 2's powerful tools and features to create visually captivating content?   Look no further! Our course is designed exclusively for individuals seeking to add a touch of sophistication to their video editing skills. With step-by-step guidance and hands-on tutorials, you'll: 🎬 Dive deep into Camtasia 2's interface and functionalities, mastering every tool for seamless editing. 🎬 Harness advanced techniques to transform your footage into polished, posh masterpieces. 🎬 Discover insider tips and tricks to make your videos stand out in a competitive landscape. What sets Camtasia 2 Essentials apart?   🌟 Tailored for the Stylish Creator: Perfect for those aiming for a polished and refined aesthetic in their videos. 🌟 Expert Guidance: Led by seasoned professionals with years of experience in video editing and content creation. 🌟 Interactive Learning: Engaging modules, practical exercises, and quizzes to reinforce your skills.   Whether you're a content creator, marketer, educator, or enthusiast, this course empowers you to unleash your creativity and create videos that radiate sophistication.   Enroll now and join the league of posh video editors! Elevate your content and captivate your audience with the elegance they deserve. 🚀✨ Course Curriculum

🌟 Unlock Your Full Leadership Potential with the Executive Leadership Mastery Program! 🌟 Are you ready to elevate your career to new heights and become the leader you were born to be? Introducing our exclusive online course - the Executive Leadership Mastery Program! Designed for ambitious professionals like you, this comprehensive program will equip you with the skills, strategies, and mindset necessary to thrive in the fast-paced world of executive leadership.   🚀 What You'll Master: 🌐 Introduction: Get ready to embark on a transformational journey! We'll lay the foundation for success by exploring the principles of effective executive leadership, setting the stage for your personal and professional growth. 🔥 Module 1: Leadership Skills Training Dive deep into the core of leadership excellence. Learn how to inspire and motivate your team, navigate challenges with resilience, and make strategic decisions that drive success. Uncover the secrets of renowned leaders and apply their proven techniques to your own leadership style. 🛠️ Module 2: Management Skills Training Discover the art of effective management. From project planning to resource allocation, you'll gain practical skills to streamline operations and boost productivity. Learn how to lead with confidence, ensuring that your team is not just meeting, but exceeding, organizational goals. 🌟 Module 3: Creating A Great Culture Explore the critical role of organizational culture in achieving sustained success. Discover how to foster a positive work environment that encourages innovation, collaboration, and employee satisfaction. Transform your workplace into a hub of creativity and excellence. 🤝 Module 4: Teamwork - Create High-Performance Teams Master the art of teamwork and collaboration. Learn strategies to build and lead high-performance teams that deliver outstanding results. From effective communication to conflict resolution, this module will empower you to cultivate a dynamic team that consistently achieves and surpasses expectations.   🎓 Why Choose Our Program: ✨ Expert Guidance: Learn from industry experts and thought leaders with a wealth of real-world experience. ✨ Flexibility: Access the course anytime, anywhere, and at your own pace, fitting seamlessly into your busy schedule. ✨ Practical Application: Our curriculum is designed for immediate application, ensuring you see results in your leadership style and team dynamics. ✨ Networking Opportunities: Connect with a community of like-minded professionals, fostering valuable relationships for your career advancement.   🚀 Elevate your leadership journey today! Don't miss this opportunity to join the ranks of successful executives who have transformed their careers with the Executive Leadership Mastery Program.   👉 Enroll Now and take the first step towards becoming the exceptional leader you are destined to be! 👈 Course Curriculum Introduction Introduction 00:00 Module 1: Leadership Skills Training Module 1: Leadership Skills Training 00:00 Module 2: Management Skills Training Module 2: Management Skills Training 00:00 Module 3: Creating A Great Culture Module 3: Creating A Great Culture 00:00 Module 4: Teamwork - Create High Performance Teams Module 4: Teamwork - Create High Performance Teams 00:00

🌐 Security Guard Online Course - Empowering Protectors of Safety!   Welcome to the Security Guard Online Course, your gateway to a fulfilling and impactful career in the field of security. Designed to equip you with the essential skills and knowledge needed in today's dynamic security landscape, this comprehensive course covers five crucial modules, ensuring you emerge as a proficient and confident security professional.   📚 Module 1: Introduction to Security Guard Training Embark on your security journey with a solid foundation. Module 1 introduces you to the fundamental principles of security guard training. Gain insights into the role, responsibilities, and ethical considerations of a security guard. Understand the importance of maintaining a professional demeanor and establishing a positive presence.   🎙️ Module 2: Communication Skills for Security Guards Effective communication is the cornerstone of successful security operations. Module 2 hones your verbal and written communication skills, empowering you to interact confidently with both colleagues and the public. Learn to de-escalate situations, gather information efficiently, and document incidents accurately.   🚨 Module 3: Access Control and Patrolling Master the art of access control and patrolling in Module 3. Explore techniques for securing premises, monitoring access points, and conducting thorough patrols. Acquire the skills to detect and respond to potential security threats, ensuring a safe and secure environment for all.   🚑 Module 4: Emergency Response Procedures Preparedness is key in the security field. Module 4 delves into emergency response procedures, equipping you with the knowledge to handle various crises effectively. From medical emergencies to security breaches, learn the protocols to safeguard lives and property with composure and efficiency.   🔒 Module 5: Security Technology Stay ahead of the curve with Module 5, where you'll explore the latest advancements in security technology. From CCTV systems to access control tools, understand how technology enhances security measures. Gain hands-on experience with cutting-edge tools and platforms to elevate your capabilities as a security professional.   🌟 Why Choose Our Course? Flexible Learning: Access modules at your convenience, allowing you to balance your training with other commitments. Expert Instructors: Learn from industry experts with years of practical experience in security operations. Interactive Content: Engaging videos, simulations, and real-world scenarios make learning both enjoyable and effective. Career Advancement: Position yourself for career growth with a recognized certification in security guard training. 🛡️ Enroll Now and Step into a Secure Future! Invest in your future as a guardian of safety. Enroll in the Security Guard Online Course today and embark on a journey towards a rewarding and impactful career. Secure your spot now, and let's build a safer world together! Course Curriculum Module 1_ Introduction to Security Guard Training Introduction to Security Guard Training 00:00 Module 2_ Communication Skills for Security Guards Communication Skills for Security Guards 00:00 Module 3_ Access Control and Patrolling Access Control and Patrolling 00:00 Module 4_ Emergency Response Procedures Emergency Response Procedures 00:00 Module 5_ Security Technology Security Technology 00:00

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

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