7128 Courses

Overview With the ever-increasing demand for SQL 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 SQL may be. Learning about SQL 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 SQL . 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 SQL 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 SQL 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 SQL 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 SQL 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 SQL , Jobseekers in the relevant domains, Anyone with a ground knowledge/intermediate expertise in SQL , Anyone looking for a certificate of completion on doing an online training on this topic, Students of SQL , or anyone with an academic knowledge gap to bridge, Anyone with a general interest/curiosity Career Path This SQL 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 Module 1- Introduction to SQL Introduction to SQL 00:00 Module 2 - SQL Installation SQL Installation 00:00 Module 3 - Beginner SQL Beginner SQL 00:00 Module 4 - Queries Queries 00:00 Module 5 - Intermediate SQL Intermediate SQL 00:00 Module 6 - Advanced SQL Operators Advanced SQL Operators 00:00

Course Objectives At the end of this course you will be able to: Work with advanced lookup and reference functions Create macros to automate common tasks Use advanced techniques to analyse data Create PivotTables and PivotCharts Work with data validation tools Import and export data ' Customer Feedback Best Training Ever! Just finished a bespoke 1-1 training course in Excel Advanced, Macros & VBA. Pedro is an excellent trainer, imparting his skills and knowledge in the best way - appropriately to audience skills, knowledge and ability. Pedro is always approachable, encouraging and supportive, giving delegates the optimum learning environment. I would not hesitate to recommend Pedro as a trainer, whatever your level of ability. Amanda Morris - Treasury & Systems Accountant at Reall - Real Equity for All The course was very interesting and engaging and will definitely be put to use. The trainer was very helpful and charismatic. Marving Lopez - AM Best Europe Pedro was excellent. Very knowledgeable, clear and great rapport with class. Darren Barkey - Direct Wines Great content and learnt a lot. Really enjoyable :) Kristie-Lee Ryan - Stirling Ackroyd 1 year email support service Take a closer look at the consistent excellent feedback from our growing corporate clients visiting our site ms-officetraining co uk With more than 20 years experience, we deliver courses on all levels of the Desktop version of Microsoft Office and Office 365; ranging from Beginner, Intermediate, Advanced to the VBA level. Our trainers are Microsoft certified professionals with a proven track record with several years experience in delivering public, one to one, tailored and bespoke courses. Our competitive rates start from £550.00 per day of training Tailored training courses: You can choose to run the course exactly as they are outlined by us or we can customise it so that it meets your specific needs. A tailored or bespoke course will follow the standard outline but may be adapted to your specific organisational needs. Please visit our site (ms-officetraining co uk) to get a feel of the excellent feedback our courses have had and look at other courses you might be interested in. Advanced Functions COUNT, COUNTA, COUNTIF, COUNTBLANK, SUMIF, SUBTOTAL IF, OR, AND, IFERROR VLOOKUP to lookup Exact Values and Approximate values MATCH, INDIRECT, ROW/COLUMN, INDEX, OFFSET Analysing Data PMT function to calculate a monthly payment of a loan What If Analysis using Goal Seek Use scenarios to consider many different variables Using Solver Add-in to optimize variables PivotTables Create a PivotTable to analyse worksheet data Add or remove fields in a PivotTable Change the data source for a PivotTable Working with external data sources Using different Statistical Functions Calculate a Running Total, % of Grant Total, Difference From… Using the Slicer and Timeline to filter the PivotTable Using Filters in a PivotTable Group by Date, Auto Group by ranges of values, Custom Group Create a PivotChart The GETPIVOTDATA function Formula auditing Precedents and dependents Error checking Watch a formula and its result by using the Watch Window Evaluate a nested formula one step at a time Data Validation Number Validation Data List Validation Message Prompts and Alerts Conditional Data Validation Data Validation Errors Consolidation Consolidate data by position Consolidate data by category Use a formula to consolidate data Outline (group) data in a worksheet Create an outline of rows Create an outline of columns Copy outlined data Hide or remove an outline Connect external data to your workbook Using the Power Query Editor to import data From Text and CSV, From Access, From Web, From another Workbook Using the Power Query Editor to; Transform your data by Selecting which fields to import, by Splitting Columns, Changing Data Type and more. Deleting Applied Steps Refreshing your data Working with Form Controls; Buttons, Option Buttons and Scroll Bars Introduction to Macros Change Macro Security settings How to Record a macro Some Macro Examples Delete a macro Edit the macro to view the VBA code Copy part of a macro to create another macro Assign a macro to a button Who is this course for? Who is this course for? This course is intended to end users who want to develop their skills so they can use advanced techniques to analyse extensive and complex datasets in Excel and to automate simple tasks with the use of Macros. Requirements Requirements Preferably, delegates should have attended the Excel Intermediate course. Career path Career path Excel know-how can instantly increase your job prospects as well as your salary. 80 percent of job openings require spreadsheet and word-processing software skills Certificates Certificates Certificate of completion Digital certificate - Included

students learn a variety of different brow tattooing techniques, so we will spend two days learning the shaded brow effects possible with a digital device and three days focused on our most-requested Hairstroke Brows.

This is an exclusive handcrafted macramé Angel. It is the best gift for Christmases occasion for your loved once. Be a proud maker of your gift item.

This is an exclusive handcrafted macramé Angel. It is the best gift for Christmases occasion for your loved once. Be a proud maker of your gift item.

This is an exclusive handcrafted macramé Angel. It is the best gift for Christmases occasion for your loved once. Be a proud maker of your gift item.

10AM - 3PM AT OUR PECKHAM HQ £50 A DAY/£200 A WEEK INCLUDES SKATEBOARD LESSONS SKATE GAMES ART WORKSHOPS SKATE CINEMA MIXED ABILITY PLEASE BRING YOUR OWN LUNCH! FROM AGE 6 UP

In this exciting, educational and intriguing full day sea glass course, you will be shown how to make your own solid silver jewellery pieces incorporating sea glass and take away your own unique pieces to wear and treasure or as gifts for loved ones.

Are you tired of watching makeup tutorials and still feeling lost when it comes to applying make-up? Do you want to pursue a career in the beauty industry but don't know where to start? Look no further than our Makeup Training course! This Advanced Diploma in Makeup Artist Training at QLS Level 7 course is endorsed by The Quality Licence Scheme and accredited by CPDQS (with 180 CPD points) to make your skill development & career progression more accessible than ever! Our comprehensive Make-up Training course covers everything you need to know to become a skilled makeup artist. From brushes and kits to colour correction and airbrushing, our curriculum covers a wide range of topics to help you develop your skills and build your confidence. Whether you're a beginner looking to learn the basics or a seasoned pro wanting to expand your skillset, our course has something for everyone. By the end of this course, you will have the skills and knowledge to create a wide range of makeup looks, from natural to glamorous. You will also have a deep understanding of skincare, allowing you to provide your clients with the best possible service. Whether you're looking to start your own business or work for an established beauty company, this course will give you the tools you need to succeed. Sign up for our Makeup Training course today and take the first step towards your dream career in the beauty industry. Our course is designed to be flexible and accessible, with online learning that you can complete at your own pace. Join our community of aspiring make-up artists and learn from the best. Don't miss out on this opportunity to develop your skills and launch your career in the beauty industry. Sign up for our Makeup Training course today and take the first step towards your dream career. Learning Outcomes: Develop skills in applying make-up for various occasions Understand the importance of skincare in makeup artistry Learn how to use different makeup tools and products Develop knowledge of colour correction techniques Learn how to create looks for different skin types and ages Understand the basics of running a make-up business Why Prefer This Make-up Training at QLS Level 7 Course? Opportunity to earn a certificate endorsed by the Quality Licence Scheme & another accredited by CPDQS which is completely free. Get a free student ID card! (£10 postal charge will be applicable for international delivery) Innovative and engaging content. Free assessments 24/7 tutor support. Take a step toward a brighter future! *** Course Curriculum *** Here is the curriculum breakdown of the Make-up Training at QLS Level 7 course: Make Up 1 - Beauty Brushes 2 - Your Makeup Kit 3 - Etiquette On Set 4 - How to Use Color Correctors 5 - Film & Television Make-up Artistry 6 - Tattoo Covering 7 - Tips On Natural Beauty Make-up 8 - Tips On Glamour Make-up 9 - How To Tips for Teenage Makeup 10 - Make-up Tips for Sophisticated Ladies 11 - Airbrush Make-up 12 - Bridal Make-up 13 - Eyes and Lips 14 - Be Camera Ready 15 - Skin Nutrition Detox Your Make-up Bag & Travel Like a Boss 17 - Henna Hair Color 18 - Fast Start Business Training 19 - What Does Bethany do to Stay Fresh Skin Care 1 - Skin Care and Tanning 2 - Facials 3 - Hair Removal Options 4 - Dermaplaning 5 - Esthetician Tools 5 - Know your Toxic ingredients 6 - LED Light Therapy 7 - Microneedling 8 - Natural and Chemical Peels 9 - Skincare Using Spices 10 - Skin Disorder and Diseases 11 - Sugaring 12 - Tinting 13 - How To Be and Get Camera Ready 14 - Why No Microdermabrasion 15 - Food Knowledge 16 - Skincare Using Spices Things To Know As a Beauty Professional 1- Aromatherapy and Essential Oils 2- Detox Your Deodorant 3 - Dry Brushing 4 - Face Masks 5 - Find Your Perfect Color 6 - Go Earthing 7- Good Morning Detox 8- Hot Flashes 9 - Luxury Spa Treatments at Home 10 - How to Conceal and Correct Under Your Eyes 11 - Make-Up Your Health Routine 12- Oil Pulling- Natural Teeth Whitening 13 - Tanning Beds or Spray Tanning 14 - What's in Your Lipstick 15 - What's All the Fuss About LED Light Ther Assessment Process You have to complete the assignment questions given at the end of the course and score a minimum of 60% to pass each exam. Our expert trainers will assess your assignment and give you feedback after you submit the assignment. You will be entitled to claim a certificate endorsed by the Quality Licence Scheme after you have completed all of the Advanced Diploma in Makeup Artist Training at QLS Level 7 exams. CPD 180 CPD hours / points Accredited by CPD Quality Standards Who is this course for? This Make-up Training at QLS Level 7 course is for: Anyone interested in pursuing a career in makeup artistry Beginner and experienced makeup artists wanting to develop their skills Individuals wanting to improve their personal makeup application skills Requirements No prior background or expertise is required. Career path The Make-up Training at QLS Level 7 course will boost your CV and aims to help you get the job or even the long-awaited promotion of your dreams. Like as: Makeup Artist: £16,000 to £40,000 Esthetician: £16,000 to £25,000 Beauty Consultant: £14,000 to £21,000 Cosmetic Counter Manager: £17,000 to £30,000 Beauty Editor: £20,000 to £35,000 Beauty Blogger or Influencer: £15,000 to £25,000 Certificates Advanced Diploma in Makeup Artist Training at QLS Level 7 Hard copy certificate - Included Show off Your New Skills with a Certificate of Completion After successfully completing the Advanced Diploma in Makeup Artist Training at QLS Level 7, you can order an original hardcopy certificate of achievement endorsed by the Quality Licence Scheme and also you can order CPDQSAccredited Certificate that is recognised all over the UK and also internationally. The certificates will be home-delivered, completely free of cost. CPDQS Accredited Certificate Digital certificate - Included

***24 Hour Limited Time Flash Sale*** Complete Agile Scrum Master Fundamentals Course Admission Gifts FREE PDF & Hard Copy Certificate| PDF Transcripts| FREE Student ID| Assessment| Lifetime Access| Enrolment Letter Are you a professional feeling stuck in your career, struggling to keep up with the ever-changing demands of the industry? Or perhaps you're a beginner, unsure of where to start or how to break into your desired field. Whichever stage you're in, our exclusive The Complete Agile Scrum Master Fundamentals Course Bundle provides unique insights and tools that can help you achieve your goals. Designed to cater to the needs of both seasoned professionals and aspiring newcomers, our The Complete Agile Scrum Master Fundamentals Course bundle is a comprehensive program that will equip you with the essential skills and knowledge you need to succeed. Whether you're looking to advance in your current role or embark on a new career journey, this bundle has everything you need to take your professional life to the next level. But that's not all. When you enrol in The Complete Agile Scrum Master Fundamentals Course Online Training, you'll receive 30 CPD-Accredited PDF Certificates, Hard Copy Certificates, and our exclusive student ID card, all absolutely free. Courses Are Included In this The Complete Agile Scrum Master Fundamentals Course Career Bundle: Course 01: Complete Agile Scrum Master Course 02: Complete Scrum Agile Training Course 03: Project Management Training Course 04: Practical Project Management Course 05: Lean Six Sigma White Belt course Course 06: Six Sigma Green Belt Diploma Course 07: Six Sigma Black Belt - Advance Diploma Course 08: Diploma in Lean Process and Six Sigma at QLS Level 5 Course 09: SAP S4HANA Controlling - Cost Center Accounting Course 10: Process Improvement Course 11: Process Mapping: Toolkit Course 12: RCA: Root Cause Analysis Course 13: Quality Management and Strategic Training - ISO 9001 Course 14: Team Management Course 15: Organisational Behaviour, HR and Leadership Course 16: Change Management Course 17: People Management Diploma Course 18: Strategic Business Management - Online Diploma Course Course 19: Financial Management Course 20: CSR Policies & Supply Chain Management Course 21: Introduction to Manufacturing Accounting: Project Costing Course 22: Cost Control & Project Scheduling Course 23: Diploma in Business Analysis Course 24: Business Performance Management Course 25: Basic Business Finance Course 26: Financial Analysis Course 27: Financial Statement Analysis Masterclass Course 28: Industrial and Organisational Psychology Course 29: Dealing with Conflict at Work Course 30: Meeting Management Online With The Complete Agile Scrum Master Fundamentals Course, you'll embark on an immersive learning experience that combines interactive lessons with voice-over audio, ensuring that you can learn from anywhere in the world, at your own pace. And with 24/7 tutor support, you'll never feel alone in your journey, whether you're a seasoned professional or a beginner. Learning Outcomes of Agile Scrum Master Fundamentals Gain a deep understanding of Agile Scrum principles, frameworks, and practices. Master effective project management methodologies to deliver successful projects. Develop strong business analysis skills to understand business needs and gather requirements. Learn strategies for managing organizational change and addressing resistance. Develop your leadership skills to inspire and motivate teams. Apply Lean Six Sigma principles to improve process efficiency and quality. Don't let this opportunity pass you by. Enrol in The Complete Agile Scrum Master Fundamentals Course today and take the first step towards achieving your goals and dreams. Why Prefer this Course? Get a Free CPD Accredited Certificate upon completion of the Complete Agile Scrum Master Fundamentals course Get a Free Student ID Card with this Complete Agile Scrum Master Fundamentals training program (£10 postal charge will be applicable for international delivery) The Complete Agile Scrum Master Fundamentals course is Affordable and Simple to understand Get Lifetime Access to the Complete Agile Scrum Master Fundamentals course materials The Complete Agile Scrum Master Fundamentals training program comes with 24/7 Tutor Support Start your learning journey straight away with our Complete Agile Scrum Master Fundamentals Course Training! The "Complete Agile Scrum Master Fundamentals Course" is designed to thoroughly immerse learners in the core principles of Agile and Scrum methodologies, alongside essential Lean Six Sigma techniques. This foundational knowledge is crucial for anyone looking to streamline project processes and enhance productivity across various industries. By understanding these methodologies, learners will be well-prepared to apply these principles and significantly boosting their efficiency and effectiveness in project management roles. This course also offers extensive training in Project Management and Financial Management, tailored for a diverse range of professional environments. Participants will gain insights that are directly applicable to their daily work, enhancing their capability to manage budgets, resources, and team dynamics effectively. This makes the course an invaluable resource for those aiming to elevate their professional standing and proficiency in high-stakes management tasks. Moreover, by pursuing this comprehensive course, learners can achieve recognised certifications in Agile Scrum and Six Sigma, marking their expertise and commitment to continuous professional development. The Strategic Planning, Change Management, and Leadership Skills developed through this course will empower individuals to lead their teams with confidence and adaptability. Additionally, the focus on Quality Management and Effective Communication will refine their ability to oversee complex projects and resolve workplace conflicts efficiently, making them indispensable assets in their organisations. Curriculum Breakdown of Complete Agile Scrum Master Fundamentals Course Module 01: Objectives and Targets Module 02: From the Traditional Development Model to Agile Module 03: What's New! Module 04: Bonus: Full eBook of the Course! Module 05: Scrum Module 06: The Scrum Team Module 07: Scrum Events Module 08: Scrum Artefacts Module 09: Scaling Scrum Module 10: Scrum in Practice Module 11: Agile Requirements Module 12: Estimation Techniques Module 13: Agile Metrics Module 14: PSM1 Certification Preparation Guidelines, Tips & Tricks Certification You have to complete the assignment given at the end of the Complete Agile Scrum Master Fundamentals Course. After passing the Complete Agile Scrum Master Fundamentals Course exam, You will be entitled to claim a PDF & Hardcopy certificate accredited by CPD Quality standards completely free. How will I get my Certificate? After successfully completing the course, you will be able to order your Certificates as proof of your achievement. PDF Certificate: Free (Previously it was £12.99*30 = £260) CPD Hard Copy Certificate: Free (For The First Course: Previously it was £29.99) CPD 300 CPD hours / points Accredited by CPD Quality Standards Who is this course for? This The Complete Agile Scrum Master Fundamentals Course is ideal for: Students seeking mastery in The Complete Agile Scrum Master Fundamentals Course Professionals seeking to enhance The Complete Agile Scrum Master Fundamentals Course skills Individuals looking for a Complete Agile Scrum Master Fundamentals Course-related career. Anyone passionate about The Complete Agile Scrum Master Fundamentals Course Requirements This Complete Agile Scrum Master Fundamentals Course doesn't require prior experience and is suitable for diverse learners. Career path This Complete Agile Scrum Master Fundamentals Course bundle will allow you to kickstart or take your career in the related sector to the next stage. Agile Coach: $100,000 - $160,000 Scrum Master: $85,000 - $135,000 Six Sigma Consultant: $77,000 - $117,000 Project Manager: $75,000 - $125,000 Financial Analyst: $55,000 - $85,000 Business Analyst: $65,000 - $100,000 Certificates CPD Accredited Digital certificate Digital certificate - Included Upon passing the Course, you need to order a Digital Certificate for each of the courses inside this bundle as proof of your new skills that are accredited by CPD QS for Free. CPD Accredited Hard copy certificate Hard copy certificate - Included If you are an international student, then you have to pay an additional 10 GBP for each certificate as an international delivery charge.