12369 Open courses in Liverpool delivered On Demand

Get Hard Copy + PDF Certificates + Transcript + Student ID Card as a Gift - Enrol Data Entry Administrator Now Tired of browsing and searching for a Data Entry Administrator course you are looking for? Can't find the complete package that fulfils all your needs? Then don't worry as you have just found the solution. Take a minute and look through this extensive Data Entry bundle that has everything you need to succeed. After surveying thousands of learners just like you and considering their valuable feedback, this all-in-one Data Entry Administrator bundle has been designed by industry experts. We prioritised what learners were looking for in a complete package and developed this in-demand Data Entry Administrator course that will enhance your skills and prepare you for the competitive job market. Also, our experts are available for answering your queries on Data Entry Administrator and help you along your learning journey. Advanced audio-visual learning modules of these Data Entry Administrator courses are broken down into little chunks so that you can learn at your own pace without being overwhelmed by too much material at once. Furthermore, to help you showcase your expertise in Data Entry Administrator, we have prepared a special gift of 1 hardcopy certificate and 1 PDF certificate for the title course completely free of cost. These Data Entry certificates will enhance your credibility and encourage possible employers to pick you over the rest. This Data Entry Bundle Consists of the following Premium courses: Course 01: Data Entry Administrator Course 02: Touch Typing Essentials Course 03: Electronic Document Management System Step Course 04: Information Management Course 05: Document Control Course 06: Encryption Course 07: Workplace Confidentiality Course 08: GDPR Course 09: Introduction to Data Analysis Course 10: Functional Skills IT Course 11: Decision Making and Critical Thinking Course 12: Freelancing on Upwork Course 13: Decision-Making Course 14: Time Management The Data Entry bundle incorporates basic to advanced level skills to shed some light on your way and boost your career. Hence, you can strengthen your Data Entry Administrator expertise and essential knowledge, which will assist you in reaching your goal. Curriculum: Course 01: Data Entry Administrator Introduction to Data Entry Using the Computer for Data Entry Common Rules and Guidelines for Data Entry Using Excel for Efficient Data Entry Using Excel's Flash Fill and Autofill to Automate Data Entry How to Create a Data Entry Form in Excel? Using Statistics Packages in Data Entry ---------- Other Courses Are --------- Course 02: Touch Typing Essentials Course 03: Electronic Document Management System Step Course 04: Information Management Course 05: Document Control Course 06: Encryption Course 07: Workplace Confidentiality Course 08: GDPR Course 09: Introduction to Data Analysis Course 10: Functional Skills IT Course 11: Decision Making and Critical Thinking Course 12: Freelancing on Upwork Course 13: Decision-Making Course 14: Time Management How will I get my Data Entry Certificate? After successfully completing the Data Entry Administrator course, you will be able to order your CPD Accredited Certificates (PDF + Hard Copy) as proof of your achievement. PDF Certificate: Free (For The Title Course) Hard Copy Certificate: Free (For The Title Course) CPD 140 CPD hours / points Accredited by CPD Quality Standards Who is this course for? Anyone from any background can enrol in this Data Entry Administrator bundle. Requirements Our Data Entry Administrator course is fully compatible with PCs, Macs, laptops, tablets and Smartphone devices. Career path Having this Data Entry Administrator expertise will increase the value of your CV and open you up to multiple job sectors. Certificates Certificate of completion Digital certificate - Included You will get the PDF Certificate for the title course (Data Entry Administrator) absolutely Free! Certificate of completion Hard copy certificate - Included You will get the Hard Copy certificate for the title course (Data Entry Administrator) 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.

Fall into Savings. Enjoy the biggest price fall this Autumn! Tired of browsing and searching for a Cake Making course you are looking for? Can't find the complete package that fulfils all your needs? Then don't worry as you have just found the solution. Take a minute and look through this extensive bundle that has everything you need to succeed. After surveying thousands of learners just like you and considering their valuable feedback, this all-in-one Cake Making bundle has been designed by industry experts. We prioritised what learners were looking for in a complete package and developed this in-demand Cake Making course that will enhance your skills and prepare you for the competitive job market. Also, our experts are available for answering your queries on Cake Making and help you along your learning journey. Advanced audio-visual learning modules of these Cake Making courses are broken down into little chunks so that you can learn at your own pace without being overwhelmed by too much material at once. Furthermore, to help you showcase your expertise in Cake Making, we have prepared a special gift of 1 hardcopy certificate and 1 PDF certificate for the title course completely free of cost. These certificates will enhance your credibility and encourage possible employers to pick you over the rest. This Bundle Consists of the following Premium courses: Course 01: Introduction to Baking Course 02: Cookery: Bread Making & Baking Course 03: Bake a Layer Cake Course 04: Artisan Pastry & Desserts Course 05: Mastering the art of Macarons Course 06: Food Safety Supervising in Catering Diploma Course Course 07: New York Cheesecake Course 08: Chocolate Making Course 09: Baking and Cake Decorating Level 2 Course 10: Sourdough Breads & Pastries Mastery Course 11: Nutrition and Diet Awareness Course 12: Food Allergen Awareness Course 13: Food Hygiene Level 2 Diploma Course 14: Basic Food Photography Enrol now in to advance your career, and use the premium study materials from Apex Learning. The bundle incorporates basic to advanced level skills to shed some light on your way and boost your career. Hence, you can strengthen your Cake Making expertise and essential knowledge, which will assist you in reaching your goal. Curriculum: Course 01: Introduction to Baking Welcome to the Course Reading a Recipe Mise en Place Choosing Ingredients Equipment Toolkit Special Notes for High Altitude What is a Butter Cake- History of Butter Cakes Important Considerations for Butter Cakes Creaming Method- Almond Butter Cake Reverse Creaming Method- Vanilla Butter Cake What is an Oil Based Cake- History of Oil Based Cakes Important Considerations for Oil Cakes Blended Method- Chocolate Olive Oil Cake Blended Method- Carrot Cake What is a Sponge Cake- History of Sponge Cakes Sponge Cake Mise en Place American Sponge Cakes American Sponge Method- Classic American Sponge European Sponge Cakes European Sponge Method- Genoise What is Simple Syrup Simple Syrup Method Thank You! CPD 140 CPD hours / points Accredited by CPD Quality Standards Who is this course for? Anyone from any background can enrol in this course bundle. Requirements Our course is fully compatible with PCs, Macs, laptops, tablets and Smartphone devices. Career path Having this Cake Making expertise will increase the value of your CV and open you up to multiple job sectors. Certificates Certificate of completion Digital certificate - Included You will get the PDF Certificate for the title course (Introduction to Baking) absolutely Free! Certificate of completion Hard copy certificate - Included You will get the Hard Copy certificate for the title course (Introduction to Baking) 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.

Tired of browsing and searching for a Veterinary Medicine course you are looking for? Can't find the complete package that fulfils all your needs? Then don't worry as you have just found the solution. Take a minute and look through this extensive bundle that has everything you need to succeed. After surveying thousands of learners just like you and considering their valuable feedback, this all-in-one Veterinary Medicine bundle has been designed by industry experts. We prioritised what learners were looking for in a complete package and developed this in-demand course that will enhance your skills and prepare you for the competitive job market. Also, our experts are available for answering your queries on Veterinary Medicine and help you along your learning journey. Advanced audio-visual learning modules of these Veterinary Medicine courses are broken down into little chunks so that you can learn at your own pace without being overwhelmed by too much material at once. Furthermore, to help you showcase your expertise, we have prepared a special gift of 1 hardcopy certificate and 1 PDF certificate for the title course completely free of cost. These certificates will enhance your credibility and encourage possible employers to pick you over the rest. This Veterinary Medicine Bundle Consists of the following Premium courses: Course 01: Online Veterinary Medicine Course Course 02: Veterinary Nursing Diploma Course 03: Veterinary Assistant Diploma Course 04: Animal Behaviour and Psychology Course 05: Veterinary Physiology & Psychotherapy Course 06: Animal Nutrition & Diet Course 07: Animal Science Course 08: Exotic Animal Care Course 09: Dog Groomer Training Course 10: Equine Psychology Course 11: Pet Sitting and Dog Walking Training Diploma Course Course 12: Pet Business Course Course 13: Wildlife Rescue and Rehabilitation Course Course 14: Mastering Pet First Aid Enrol now in Veterinary Medicine to advance your career, and use the premium study materials from Apex Learning. The bundle incorporates basic to advanced level skills to shed some light on your way and boost your career. Hence, you can strengthen your expertise and essential knowledge, which will assist you in reaching your goal. Curriculum: Course 01: Online Veterinary Medicine Course Module 01: Introduction to Veterinary Medicine Module 02: Making a Diagnosis Module 03: The Physical Examination Module 04: The Medical History Module 05: Biosecurity and Infection Control Module 06: Practical Antimicrobial Therapeutics Module 07: Diseases of the Alimentary Tract Module 08: Diseases of the Liver and Pancreas Module 09: Diseases of the Cardiovascular System Module 10: Diseases of the Haemolymphatic and Immune Systems Module 11: Diseases of the Respiratory System Module 12: Diseases of the Urinary System Module 13: Diseases of the Nervous System Module 14: Diseases of the Musculoskeletal System Module 15: Diseases of the Skin, Eye, Conjunctiva, and External Ear Module 16: Diseases of the Mammary Gland Module 17: Decision Making in Veterinary Emergency Medicine Module 18: Veterinary Herbal Medicine Module 19: Clinical Procedures Module 20: Diagnostic Procedures Module 21: Veterinary Medicine for Exotic Pets, Zoo and Wildlife Species CPD 155 CPD hours / points Accredited by CPD Quality Standards Who is this course for? Anyone from any background can enrol in this bundle. Requirements Our course is fully compatible with PCs, Macs, laptops, tablets and Smartphone devices. Career path Having this expertise will increase the value of your CV and open you up to multiple job sectors. Certificates Certificate of completion Digital certificate - Included You will get the PDF Certificate for the title course (Online Veterinary Medicine Course) absolutely Free! Certificate of completion Hard copy certificate - Included You will get the Hard Copy certificate for the title course (Online Veterinary Medicine 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.

14 in 1 "Level 2 Health and Safety" Bundle only at £79 Get Hard Copy + PDF Certificates + Transcript + Student ID Card + e-Learning App as a Gift - Enrol Now Tired of browsing and searching for a Level 2 Health and Safety course you are looking for? Can't find the complete package that fulfils all your needs? Then don't worry as you have just found the solution. Take a minute and look through this 14-in-1 extensive bundle that has everything you need to succeed in relevant fields! After surveying thousands of learners just like you and considering their valuable feedback, this all-in-one bundle has been designed by industry experts. We prioritised what learners were looking for in a complete package and developed this in-demand course that will enhance your skills and prepare you for the competitive job market. Furthermore, to help you showcase your expertise, we have prepared a special gift of 1 hardcopy certificate and 1 PDF certificate for the title course completely free of cost. These certificates will enhance your credibility and encourage possible employers to pick you over the rest. This Level 2 Health and Safety Bundle Consists of the following Premium courses: Course 01: Health and Safety Executive Course 02: Occupational Health and Safety Level 3 Course 03: Emergency First Aid and Incident Management at Work Course 04: Oxygen First Aid Training Course 05: Wound Care Level 2 Course 06: Manual Handling Level 2 Course 07: RIDDOR Training Course 08: COSHH Training and Safety - Level 2 Course 09: LOLER Training Course 10: Advanced Electrical Safety Course 11: Fire Safety | Online Course Course 12: Ladder Safety Course 13: Noise and Hearing Protection Training Course 14: HAVS (Hand-Arm Vibration Syndrome) Training Course Enrol now in Level 2 Health and Safety to advance your career, and use the premium study materials from Apex Learning. Benefits you'll get from choosing Apex Learning for this training: Pay once and get lifetime access to 14 CPD courses Free e-Learning App for engaging reading materials & helpful assistance Certificates, student ID included in a one-time fee Free up your time - don't waste time and money travelling for classes Accessible, informative modules designed by expert instructors Learn anytime, from anywhere Study from your computer, tablet or mobile device CPD accredited course - improve the chance of gaining professional skills Curriculum Course 01: Health and Safety Executive Module 01 : Health and Safety at Work and the Laws Module 02 : Managing for Health and Safety Module 03 : Risk Assessment and Common Risks Module 04 : Workplace Health, Safety and Welfare Module 05 : Accidents and Ill Health at Work Module 06 : Electrical, Fire and Gas Safety Module 07 : Safety in Different Work Settings Module 08 : Work Equipment Hazards and Risk Control Module 09 : Other Health and Safety Hazards at Work CPD 140 CPD hours / points Accredited by CPD Quality Standards Who is this course for? Anyone from any background can enrol in this bundle. Requirements This training is fully compatible with PCs, Macs, laptops, tablets and Smartphone devices. There is no time limit for completing this course; it can be studied in your own time at your own pace. Career path Having this expertise will increase the value of your CV and open you up to multiple job sectors. Certificates Certificate of completion Digital certificate - Included You will get the PDF Certificate for the title course (Health and Safety Executive) absolutely Free! Certificate of completion Hard copy certificate - Included You will get the Hard Copy certificate for the title course (Health and Safety Executive) 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.

Fall into Savings. Enjoy the biggest price fall this Autumn! 14 in 1 "Recruitment Advisor Training" Bundle only at £79 Get Hard Copy + PDF Certificates + Transcript + Student ID Card + e-Learning App as a Gift - Enrol Now! Tired of browsing and searching for a Recruitment Advisor Training course you are looking for? Can't find the complete Recruitment Advisor Training package that fulfils all your needs? Then don't worry as you have just found the solution. Take a minute and look through this 14-in-1 extensive Training bundle that has everything you need to succeed in Recruitment Advisor Training and other relevant fields! After surveying thousands of learners just like you and considering their valuable feedback, this all-in-one Training bundle has been designed by industry experts. We prioritised what learners were looking for in a complete Training package and developed this in-demand training course that will enhance your skills and prepare you for the competitive job market. Furthermore, to help you showcase your expertise in this Training, we have prepared a special gift of 1 hardcopy certificate and 1 PDF certificate for the title course completely free of cost. These Recruitment Advisor Training certificates will enhance your credibility and encourage possible employers to pick you over the rest. This Training Bundle Consists of the following Premium courses: Course 01: Recruitment Officer Diploma Course 02: Strategies & Skills for Recruitment Course 03: Employee Hiring and Termination Training Course 04: Motivational Interviewing Course 05: Employment Law Level 3 Course 06: HR Management Level 3 Course 07: Human Resources (HR) Audit Course 08: Payroll Management Course Course 09: Delegation Skills Course 10: People Management Skills Level 3 Course 11: Personal and Networking Skills Course 12: Project Management Skills Level 3 Course 13: Conflict Management Course 14: Youth Work & Leadership Enrol now to advance your career, and use the premium study materials from Apex Learning. Benefits you'll get from choosing Apex Learning for this training: Pay once and get lifetime access to 14 CPD courses Free e-Learning App for engaging reading materials & helpful assistance Certificates, student ID included in a one-time fee Free up your time - don't waste time and money travelling for classes Accessible, informative modules designed by expert instructors Learn anytime, from anywhere Study from your computer, tablet or mobile device CPD accredited course - improve the chance of gaining professional skills Curriculum Course 01: Recruitment Officer Diploma Module 1: Introduction to Recruitment: Importance and Implications Module 2: An Overview of the Recruitment Industry Module 3: The UK Recruitment Legislation Module 4: Basics of Employment Law Module 5: Candidate Management Module 6: Candidate Interview Processes Module 7: Legal Recruitment Process Module 8: Key Performance Indicators for the Recruitment Industry CPD 140 CPD hours / points Accredited by CPD Quality Standards Who is this course for? Anyone from any background can enrol in this Recruitment Advisor Training bundle. Requirements Our Training course is fully compatible with PCs, Macs, laptops, tablets and Smartphone devices. There is no time limit for completing this Training course; it can be studied in your own time at your own pace. Career path Having this Training expertise will increase the value of your CV and open you up to multiple job sectors. Certificates Certificate of completion Digital certificate - Included You will get the PDF Certificate for the title course (Recruitment Officer Diploma) absolutely Free! Certificate of completion Hard copy certificate - Included You will get the Hard Copy certificate for the title course (Recruitment Officer Diploma) 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.

Colour Therapy Certificate The shading treatment course offers understudies all the fundamental data needed to perform shading treatment. This instructional class furnishes understudies with guidance that will put you on the way to starting a vocation in this field. This course is ideal for understudies keen on studying elective treatments. Shading treatment is an all encompassing methodology that utilizes the utilization of tones to treat disease and equilibrium energies in the body. This all encompassing methodology is a technique known to treat a horde of general medical issue. As you work through this course you will acquire a thorough outline of the historical backdrop of shading treatment and how the interaction functions. Prologue to the Color Therapy Course As this is an internet instructional class, understudies can contemplate material at whatever point and any place it's advantageous for them. Most selected understudies are as yet ready to work all day and keep a way of life while seeking after their degrees. Our investigation material is open from any gadget with a web association and online help is accessible while you train. Whenever you have finished the course, you will be needed to breeze through a various decision test. After effective finishing of the test, you will be granted your declaration, which can be printed or posted for you at an extra expense. What You Will Learn The shading treatment course furnishes understudies with an outline of the shading treatment strategy, which sets you up for a profession in this field. This course will cover: The sources and history of shading mending An outline of shading brain research How shading mending functions An outline of chakras An investigate how tone is applied An outline into shading in our current circumstance An outline of tones and their mending properties Advantages of the Color Therapy Certificate Understudies who pursue acquiring their shading treatment testament online will see a few advantages. These include: The accommodation of concentrating anyplace with a legitimate web association. Study at your own speed, there is no time limit for this course, so you can finish it regardless of what amount of time it requires for you. Course material that is accessible across any gadget including PCs, cell phones or tablets. The comfort to effectively oversee modules and see course structure. Online help accessible to help you keep on track. An exhaustive prospectus that will quick track in the process to turning into a shading treatment master. The chance to improve possibilities while applying for work or volunteer freedoms. A moderate valuing structure. An ensured authentication in the business upon effective finishing.

Learn Node.js by building real-world applications with Node, Express, MongoDB, Mocha, and more!

Description Arboriculture Diploma  Arboriculture is a discipline that deals with the care and management of trees. The Arboriculture Diploma course includes both and everything else consisting of tree culture. The Arboriculture Diploma course is designed to be studied from your home online by Elearncollege. Through this course, you will develop a deep understanding of and the skills required to diagnose and treat disorders in trees, whether they are pest-induced, caused by diseases due to malnutrition and the water source, or if there is some other reason. The Arboriculture Diploma course will also teach you the standard tree surgeries and essential pruning techniques like crown thinning, cleaning, reduction, lifting, renewal, and general branch removal. The diploma course covers all vital elements of tree work that you would require as a professional arborist at the introductory level. The Arboriculture Diploma course aims at individuals employed in the tree work industry who want to add to their knowledge and other activities in their workplace. It is also suitable for people who are looking to enter this industry. It provides a way to higher education in the field. A well-designed, well-thought-out arboriculture education is supposed to cover a broad range of topics. You are learning the basics of the field that are necessary skills to work in the industry first. A solid foundation for knowledge regarding these skills leads to a better comprehension of more advanced skills and concepts and helps learn them. The Arboriculture Diploma course does not deal with just how to cut down trees. In addition, it discusses diseases and pests that threaten the health of trees and how to remove them properly if necessary. An introductory course covering a wide range of topics allows the learners to further specialise in different sub-disciplines within Arboriculture and other related professions. If, for instance, you want to switch from being an arborist to a public garden caretaker, our diploma course in Arboriculture would allow you to do so. Tree removal costs a lot of time and money and is a huge decision. Besides time and financial commitment, it significantly changes the tree's environment. Cool shades are taken away, leading to exposure to hot sunlight. There may be animals who made their tree the home and are rendered homeless, and protection is taken away from flora and fauna of the surroundings, exposing them to frost, strong winds, and other possible hazards. Some species of trees are more hazardous than others. Some drop branches due to badly rotted branches and trunks. This may result in severe damage, mainly if the trees are located near children's playgrounds, buildings, or outdoor living accommodations. These and other risks that trees may bring often validate the removal of parts of a tree or the whole tree. The shadow cast by trees may deprive other plants growing on the same lawn of sunlight, hindering their growth. Tree branches growing over houses shed leaves, block the gutters, and rub on the walls as the wind blows, causing noises and distractions. Wet leaves piling up on the ground can become slippery or smother tinier plants and require raking. Some trees must be removed because their roots damage building foundations, block pipelines, and damage the walls of pavements and other structures. To sustain a career in Arboriculture or to open and keep a business running in the industry, you need to have the skills to perform the job. This industry does not require high qualifications or advanced degrees, but it requires experience and expert knowledge. You need the skills to identify and differentiate hundreds of tree species and can manage and care for them, depending on their kind and where they are growing. What you will learn  1: Introduction  2: All about Trees  3: Leaves and Tree Crowns  4: Roots  5: Growing Trees: New Generation Practices  6: Water and Trees  7: Carbon and Trees  8: Nutrition for trees  9: Trees and other organisms  10: Environmental Challenges  Course Outcomes After completing the course, you will receive a diploma certificate and an academic transcript from Elearn college. Assessment Each unit concludes with a multiple-choice examination. This exercise will help you recall the major aspects covered in the unit and help you ensure that you have not missed anything important in the unit. The results are readily available, which will help you see your mistakes and look at the topic once again. If the result is satisfactory, it is a green light for you to proceed to the next chapter. Accreditation Elearn College is a registered Ed-tech company under the UK Register of Learning( Ref No:10062668). After completing a course, you will be able to download the certificate and the transcript of the course from the website. For the learners who require a hard copy of the certificate and transcript, we will post it for them for an additional charge.

Give a compliment to your career and take it to the next level. This Paediatrics and Child Health 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 Paediatrics and Child Health Bundle will help you stay ahead of the pack. Throughout the Paediatrics and Child Health 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 Paediatrics and Child Health Course, you will get 11 premium courses, an original Hardcopy, 11 PDF Certificates (Main Course + Additional Courses) Student ID card as gifts. This Paediatrics and Child Health Bundle Consists of the following Premium courses: Courses are included in this Paediatrics and Child Health Bundle? Course 01: Paediatrician Course 02: Paediatric Care Course Course 03: Understanding Autism Awareness and Diagnosis Course 04: Child Language Disorder (CLD) Course 05: Safeguarding Children Level 3 Course 06: Counselling Children & Supporting Their Wellbeing Course 07: Care Planning and Record-Keeping Course 08: Medical Terminology Training Course 09: Infection Prevention Training Course 10: Understanding Nutrition and Health Level 4 Course 11: Medical Law Enrol now in Paediatrics and Child Health To advance your career, and use the premium study materials from Apex Learning. The Paediatrics and Child Health bundle incorporates basic to advanced level skills to shed some light on your way and boost your career. Hence, you can strengthen your Paediatrics and Child Health Expertise and essential knowledge, which will assist you in reaching your goal. Certificate: PDF Certificate: Free (Previously it was £6*11 = £66) Hard Copy Certificate: Free (For The Title Course: Previously it was £10) CPD 115 CPD hours / points Accredited by CPD Quality Standards Who is this course for? Anyone from any background can enrol in this Paediatrics and Child Health Bundle. Requirements Our Paediatrics and Child Health is fully compatible with PCs, Macs, laptops, tablets, and Smartphone devices. There is no time limit for completing this Paediatrics and Child Health course; it can be studied in your own time at your own pace. Career path Having this Paediatrics and Child Health expertise will increase the value of your CV and open you up to multiple job sectors. Certificates Certificate of completion Digital certificate - Included Certificate of completion Hard copy certificate - Included

Business and Data Analysis with SQL is a comprehensive training in the theoretical and practical study of Data analysis and SQ language. This module is open to the people who want to elevate their business growth. Secure your position as an asset to the organization by learning SQL. Make your professional skill more productive by learning data analysis and SQL communication. The course exposes to you the details on computational and data investigational methods. It also highlights the basics of extracting data from the database storage. On completion of this online course, you will have an extensive understanding of how the database works and ways to function them properly, and thus be able to make critical decisions like a professional. What you'll learn At the end of this course, you will have the ability to run your own data projects, work with databases and manage large datasets and provide meaningful business intelligence reports to your team. Requirements Be familiar with reports and data-based projects. Who this course is for: This course is aimed at business professionals who work with data of all sizes. You will learn the fundamentals of business intelligence and basic data warehouse development. Introduction Business and Data Analysis with SQL FREE 00:06:00 Database and Datawarehouse Design Introduction to Databases- A History 00:04:00 SQL Statement Categories 00:02:00 Capture data requirements 00:09:00 Physical Vs Logical Data Representations 00:03:00 Normalise data 00:07:00 Fact Tables 00:04:00 Aggregate data 00:07:00 Entity Relationship Diagrams (ERD's) 00:07:00 Extract, Transform and Load (ETL) 00:13:00 Structured Query Language (SQL) - Fundamentals MySQL Server Setup 00:05:00 MySQL Server Start and stop Service 00:02:00 Connect to database 00:07:00 Comments in SQL 00:05:00 Select data from a table 00:16:00 Table Indexes 00:08:00 Table and Column Aliases 00:05:00 Inner Join Tables 00:02:00 Left and Right Outer Table Joins 00:04:00 Union (all) Results 00:04:00 Project Management Project Management (Agile Methodology) 00:11:00 Kanban boards 00:09:00 Prioritise Requirements using MoSCoW 00:04:00 Sales Project Sales Project - Introduction 00:05:00 Create and Drop Database 00:05:00 Query Workflow 00:09:00 Sales Project - Part 1 - Data Capture 00:15:00 Sales Project - Part 2 - Data Analysis 00:08:00 Sales Project - Part 3 - Data Summary 00:12:00 Sales Project - Part 4 - Send to production 00:09:00 MySQL Query Explain Plan 00:07:00 Common Table Expressions (WITH) 00:14:00 Data Control Language (DCL) User Administration 00:13:00 MySQL Programs MySQL Set Windows Environment Variable 00:05:00 MySQL Command Line 00:17:00 Visualising Data Export results to Excel 00:06:00 Setup MySQL ODBC (Open Database Connector) 00:11:00 Creating a report in Microsoft Excel 00:21:00 Course Certification