32525 Design courses in Lowestoft delivered On Demand

Boost Your Career with Apex Learning and Get Noticed By Recruiters in this Hiring Season! ★★★ Get Hard Copy + PDF Certificates + Transcript + Student ID Card worth £160 as a Gift - Enrol Now! ★★★ Food hygiene is as important as food consumption to life. Understand TACCP protocols, learn how to ensure food safety, and control food poisoning and contamination from the knowledge of this course. This Food Hygiene course covers everything you need to become a responsible Food hygiene and safety professional. With an understanding of the UK food safety legislation, the Food Hygiene course explains various food hazards and prevention techniques, including maintaining Food hygiene and safety. You'll understand how to ensure safe food storage and prepare food premises, maintaining all the safety protocols. As a food safety professional, you'll also learn the importance of regular safety inspections, microbial disease, and pest control techniques. According to food hygiene control Regulation (EC) No 852/2004, food supply chains and staff must maintain proper safety and implement best practices. Hence, the Food Hygiene course outlines HACCP, TACCP protocols to develop your understanding of Food hygiene and safety control measures. Courses are included in this Food Hygiene Bundle: Course 01: Food Hygiene Level 3 Course 02: Diploma in Food Safety & Pest Management Course 03: Food Allergen Awareness Course 04: HACCP Training Course 05: TACCP Training Course Course 06: Nutrition and Diet Awareness Course 07: Immunity Boosting Food Course 08: Diabetes Care Diploma Course 09: Dysphagia Awareness Course 10: Personal Hygiene Course 11: Coronavirus (COVID-19) Awareness By the time you complete this Food Hygiene course, you'll have a firm grasp of food safety principles and Food hygiene maintenance practices on your way to becoming a responsible food safety professional. So, enrol now in our Food Hygiene training and start learning today! Skills You Will Gain: By the end of this Food Hygiene course, you will be able to - Identify the Food Hygiene causes and risks of poor food hygiene Understand the UK Food Hygiene laws in place for all types of food handling. Prevent the spread of bacteria in food and the possibility of food poisoning Understand the importance of Food Hygiene, personal hygiene and cleanliness. Use HACCP and TACCP as part of their everyday schedules Gain the skills to train your staff effectively in food hygiene & safety compliance Learn how to implement & monitor Food Hygiene and food safety management system at work Why Choose this Food Hygiene Bundle? FREE Food Hygiene CPD-accredited certificate Get a free student ID card with Food Hygiene training (£10 applicable for international delivery) Lifetime access to the Food Hygiene course materials The Food Hygiene program comes with 24/7 tutor support Get instant access to this Food Hygiene course Learn Food Hygiene training from anywhere in the world The Food Hygiene training is affordable and simple to understand The Food Hygiene training is entirely online Enrol now in Food Hygiene and Safety to advance your career, and use the premium study materials from Apex Learning. How will I get my Food Hygiene Certificate? After successfully completing the Food Hygiene course, you will be able to order your CPD Accredited Certificates (PDF + Hard Copy) as proof of your achievement. PDF Certificate: Free (Previously it was £10 * 11 = £110) Hard Copy Certificate: Free (For The Title Course) P.S. The delivery inside the U.K. is Free. International students have to pay a £3.99 postal charge. ★★★ Course Curriculum of Food Hygiene Bundle ★★★ Course 1: Food Hygiene Diploma Module 1: Food Safety Legislation Module 2: Microbiological Hazards Module 3: Physical, Chemical and Allergenic Hazards Module 4: Food storage Module 5: Food Preparation Module 6: Personal Hygiene Module 7: Food Premises Design and Cleaning Schedules Module 8: Further Information Module 9: Reopening and Adapting Your Food Business During COVID-19 =========>>>>> And 10 More Courses <<<<<========= Who is this course for? There is no experience or previous qualifications required for enrolment in this Food Hygiene Diploma. It is available to all students of all academic backgrounds. Requirements This Food Hygiene Training Course has been designed to be fully compatible with tablets and smartphones. Career path This Food Hygiene Diploma is perfect for anybody associated directly with the food sector, such as: Restaurant owners Hygiene Manager Catering Staff Cook Kitchen Assistant Food Hygiene Supervisor

Overview Uplift Your Career & Skill Up to Your Dream Job - Learning Simplified From Home! Kickstart your career & boost your employability by helping you discover your skills, talents, and interests with our special Accounting Essential for Business with Sage 50 Course. You'll create a pathway to your ideal job as this course is designed to uplift your career in the relevant industry. It provides the professional training that employers are looking for in today's workplaces. The Accounting Essential for Business with Sage 50 Course is one of the most prestigious training offered at Skillwise and is highly valued by employers for good reason. This Accounting Essential for Business with Sage 50 Course has been designed by industry experts to provide our learners with the best learning experience possible to increase their understanding of their chosen field. This Accounting Essential for Business with Sage 50 Course, like every one of Skillwise's courses, is meticulously developed and well-researched. Every one of the topics is divided into elementary modules, allowing our students to grasp each lesson quickly. At Skillwise, we don't just offer courses; we also provide a valuable teaching process. When you buy a course from Skillwise, you get unlimited Lifetime access with 24/7 dedicated tutor support. Why buy this Accounting Essential for Business with Sage 50 ? Lifetime access to the course forever Digital Certificate, Transcript, and student ID are all included in the price Absolutely no hidden fees Directly receive CPD Quality Standard-accredited qualifications after course completion Receive one-to-one assistance 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 Accounting Essential for Business with Sage 50 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 free. Original Hard Copy certificates need to be ordered at an additional cost of £8. Who is this course for? This Accounting Essential for Business with Sage 50 course is ideal for Students Recent graduates Job Seekers Anyone interested in this topic People already work in relevant fields and want to polish their knowledge and skills. Prerequisites This Accounting Essential for Business with Sage 50 does not require you to have any prior qualifications or experience. You can just enrol and start learning. This Accounting Essential for Business with Sage 50 was made by professionals and it is compatible with all PCs, Macs, 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 a bonus, you will be able to pursue multiple occupations. This Accounting Essential for Business with Sage 50 is a great way for you to gain multiple skills from the comfort of your home. Accounting Essential for Business with Sage 50 Chris Moore - 1. Introduction 00:03:00 Chris Moore - 2. First Transactions 00:05:00 Chris Moore - 3. T Accounts introduction 00:03:00 TASK 4 Fixed Assets 00:08:00 TASK 5 a and b Bank Payment and Transfer 00:31:00 TASK 5 c and d Supplier and Customer Payments and DD STO 00:18:00 TASK 6 Petty Cash 00:11:00 TASK 7 a Bank Reconnciliation Current Account 00:17:00 TASK 7 b Bank Reconciliation Petty Cash 00:09:00 TASK 7 c Reconciliation of Credit Card Account 00:16:00 TASK 8 Aged Reports 00:14:00 TASK 9 a Payroll 00:07:00 9 b Payroll Journal 00:10:00 TASK 10 Value Added Tax - Vat Return 00:12:00 Task 11 Entering opening balances on Sage 50 00:13:00 TASK 12 a Year end journals - Depre journal 00:05:00 TASK 12 b Prepayment and Deferred Income Journals 00:08:00 TASK 13 a Budget 00:05:00 TASK 13 b Intro to Cash flow and Sage Report Design 00:08:00

Uplift Your Career & Skill Up to Your Dream Job - Learning Simplified From Home! Kickstart your career & boost your employability by helping you discover your skills, talents, and interests with our special Basic PowerPoint Course. You'll create a pathway to your ideal job as this course is designed to uplift your career in the relevant industry. It provides the professional training that employers are looking for in today's workplaces. The Basic PowerPoint Course is one of the most prestigious training offered at Skillwise and is highly valued by employers for good reason. This Basic PowerPoint Course has been designed by industry experts to provide our learners with the best learning experience possible to increase their understanding of their chosen field. This Basic PowerPoint Course, like every one of Skillwise's courses, is meticulously developed and well-researched. Every one of the topics is divided into elementary modules, allowing our students to grasp each lesson quickly. At Skillwise, we don't just offer courses; we also provide a valuable teaching process. When you buy a course from Skillwise, you get unlimited Lifetime access with 24/7 dedicated tutor support. Why buy this Basic PowerPoint? Lifetime access to the course forever Digital Certificate, Transcript, and student ID are all included in the price Absolutely no hidden fees Directly receive CPD QS-accredited qualifications after course completion Receive one-to-one assistance 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 Basic PowerPoint 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 free. Original Hard Copy certificates need to be ordered at an additional cost of £8. Who is this course for? This Basic PowerPoint 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 skills. Prerequisites This Basic PowerPoint does not require you to have any prior qualifications or experience. You can just enroll and start learning. This Basic PowerPoint was made by professionals and it is compatible with all PCs, Macs, 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 a bonus, you will be able to pursue multiple occupations. This Basic PowerPoint is a great way for you to gain multiple skills from the comfort of your home. Basic PowerPoint Module 01: Overview 00:03:00 Module 02: Using the Right Mouse Button 00:03:00 Module 03: The Home Menu - Clipboard Sub Menu - Editing Sub Menu 00:03:00 Module 04: The Home Menu - Slides Sub Menu 00:03:00 Module 05: The Home Menu - Font and Paragraph Sub Menus 00:03:00 Module 06: The Home Menu - Drawing Sub Menu - Dictation Sub Menu 00:06:00 Module 07: The Home Menu - Importing from Keynote and Google Docs 00:02:00 Module 08: The Insert Menu - 3D Models and Add Ins 00:03:00 Module 09: The Insert Menu - The Images Sub Menu 00:05:00 Module 10: The Insert Menu - Media Sub Menu 00:05:00 Module 11: The Design Menu 00:04:00 Module 12: The Transitions Menu 00:04:00 Module 13: The Animations Menu - Part One 00:03:00 Module 14: The Animations Menu - Part Two 00:03:00 Module 15: The Slide Show Menu 00:06:00 Module 16: The Presenter View 00:04:00 Module 17: The Review Menu 00:04:00 Module 18: Sharing and Collaboration 00:01:00 Module 19: The View Menu 00:06:00 Module 20: View and Outline Command 00:03:00 Assignment Assignment - Basic PowerPoint

In this course, you will learn how to author machine learning models in Python without the aid of frameworks or libraries from scratch. Discover the process of loading data, evaluating models, and implementing machine learning algorithms.

If you have a real world, 'bricks and mortar' business that is not represented online, there has never been a really better time to get your business online. So If you want to get an E-commerce website for your business, then this is going to be the course for you. By enrolling in this course, you will learn how to develop a professional e-commerce site without any prior programming knowledge at all and in less than 3 hours. This course shows you the skills and techniques that professional web design companies use to develop websites quickly and efficiently and why they can charge ridiculous amounts of money. Course Highlights Web Developer Course: E-commerce is an award winning and the best selling course that has been given the CPD Certification & IAO accreditation. It is the most suitable course anyone looking to work in this or relevant sector. It is considered one of the perfect courses in the UK that can help students/learners to get familiar with the topic and gain necessary skills to perform well in this field. We have packed Web Developer Course: E-commerce into 10 modules for teaching you everything you need to become successful in this profession. To provide you ease of access, this course is designed for both part-time and full-time students. You can become accredited in just 7 hours, 15 minutes and it is also possible to study at your own pace. We have experienced tutors who will help you throughout the comprehensive syllabus of this course and answer all your queries through email. For further clarification, you will be able to recognize your qualification by checking the validity from our dedicated website. Why You Should Choose Web Developer Course: E-commerce Lifetime access to the course No hidden fees or exam charges CPD Accredited certification on successful completion Full Tutor support on weekdays (Monday - Friday) Efficient exam system, assessment and instant results Download Printable PDF certificate immediately after completion Obtain the original print copy of your certificate, dispatch the next working day for as little as £9. Improve your chance of gaining professional skills and better earning potential. Who is this Course for? Web Developer Course: E-commerce is CPD certified and IAO accredited. This makes it perfect for anyone trying to learn potential professional skills. As there is no experience and qualification required for this course, it is available for all students from any academic backgrounds. Requirements Our Web Developer Course: E-commerce is fully compatible with any kind of device. Whether you are using Windows computer, Mac, smartphones or tablets, you will get the same experience while learning. Besides that, you will be able to access the course with any kind of internet connection from anywhere at any time without any kind of limitation. Career Path You will be ready to enter the relevant job market after completing this course. You will be able to gain necessary knowledge and skills required to succeed in this sector. All our Diplomas' are CPD and IAO accredited so you will be able to stand out in the crowd by adding our qualifications to your CV and Resume. Introduction 00:15:00 Why e-commerce works, and why now more than ever... 00:30:00 What do you need to launch a successful e- commerce site? 00:30:00 Planning and research 01:00:00 Before you start building your site 00:15:00 General e-commerce site guidelines 00:30:00 Site creation 03:00:00 Product sourcing 00:30:00 After this comes marketing 00:30:00 Conclusion 00:15:00 Mock Exam Final Exam

Want to learn the strategy that every relevant website owner is funding in to grow their audience and increase their reach?That strategy is Article Marketing. Articles marketing serves a variety of purposes such as online brand marketing and company reputation supervision. Chief among these advantage is increasing company (website) visibility and building credibility within industry circles. With that said, article marketing, also known as 'content marketing', can immediately launch both local and global businesses into profitability! In this course, you will gain the most valuable skills for content marketing. You will understand the key fundamental elements for professional content and learn to design Content Marketing Strategies using the latest schemes and best approaches. Course Highlights Accredited Diploma in Article Marketing is an award-winning and the best-selling course that has been given the CPD Certification & IAO accreditation. It is the most suitable course anyone looking to work in this or relevant sector. It is considered one of the perfect courses in the UK that can help students/learners to get familiar with the topic and gain necessary skills to perform well in this field. We have packed Accredited Diploma in Article Marketing into 9 modules for teaching you everything you need to become successful in this profession. To provide you ease of access, this course is designed for both part-time and full-time students. You can become accredited in just 3 hours hours and it is also possible to study at your own pace. We have experienced tutors who will help you throughout the comprehensive syllabus of this course and answer all your queries through email. For further clarification, you will be able to recognize your qualification by checking the validity from our dedicated website. Why You Should Choose Accredited Diploma in Article Marketing Lifetime access to the course No hidden fees or exam charges CPD Accredited certification on successful completion Full Tutor support on weekdays (Monday - Friday) Efficient exam system, assessment and instant results Download Printable PDF certificate immediately after completion Obtain the original print copy of your certificate, dispatch the next working day for as little as £9. Improve your chance of gaining professional skills and better earning potential. Who is this Course for? Accredited Diploma in Article Marketing is CPD certified and IAO accredited. This makes it perfect for anyone trying to learn potential professional skills. As there is no experience and qualification required for this course, it is available for all students from any academic backgrounds. Requirements Our Accredited Diploma in Article Marketing is fully compatible with any kind of device. Whether you are using Windows computer, Mac, smartphones or tablets, you will get the same experience while learning. Besides that, you will be able to access the course with any kind of internet connection from anywhere at any time without any kind of limitation. Career Path You will be ready to enter the relevant job market after completing this course. You will be able to gain necessary knowledge and skills required to succeed in this sector. All our Diplomas' are CPD and IAO accredited so you will be able to stand out in the crowd by adding our qualifications to your CV and Resume. Article Marketing Explained 00:30:00 The 4 Essential Things ALL Articles Must Have 00:30:00 How to Create an Outline For All of Your Article 00:30:00 5 Easy Ways To Get Your Creative Juices Going 00:30:00 What to Do Before Submitting To Article Directories 00:15:00 Red Hot Tips To Get Your Articles Read 00:15:00 Writing a Resource Box that Makes People Click 00:15:00 If You Hate Writing Articles 00:15:00 Reference Book Article Marketing Secrets 00:00:00 Mock Exam Final Exam

Do you want to acquire the knowledge that will Help you Understand & Cope with Scaffolding Safety in Construction Environments? Elevate your understanding of construction safety to new heights with our 'Scaffolding Safety in Construction Environments' course. Navigate the intricate lattice of regulations and best practices that ensure a robust foundation for worksite safety. Learn to construct a secure environment, piece by piece, where confidence scales alongside structures. Prevent the most precarious pitfalls through informed awareness and defensive planning. Step up - where every rung on the knowledge ladder leads to a safer tomorrow. Course Highlights Scaffolding Safety in Construction Environments is an award winning and the best selling course that has been given the CPD Certification & IAO accreditation. It is the most suitable course anyone looking to work in this or relevant sector. It is considered one of the perfect courses in the UK that can help students/learners to get familiar with the topic and gain necessary skills to perform well in this field. We have packed Scaffolding Safety in Construction Environments for teaching you everything you need to become successful in this profession. To provide you ease of access, this course is designed for both part-time and full-time students. It is also possible to study at your own pace. We have experienced tutors who will help you throughout the comprehensive syllabus of this course and answer all your queries through email. For further clarification, you will be able to recognize your qualification by checking the validity from our dedicated website. Why You Should Choose Scaffolding Safety in Construction Environments Lifetime access to the course No hidden fees or exam charges CPD Accredited certification on successful completion Full Tutor support on weekdays (Monday - Friday) Efficient exam system, assessment and instant results Download Printable PDF certificate immediately after completion Obtain the original print copy of your certificate, dispatch the next working day for as little as £9. Improve your chance of gaining professional skills and better earning potential. Who is this Course for? Scaffolding Safety in Construction Environments is CPD certified and IAO accredited. This makes it perfect for anyone trying to learn potential professional skills. As there is no experience and qualification required for this course, it is available for all students from any academic backgrounds. Requirements Our Scaffolding Safety in Construction Environments is fully compatible with any kind of device. Whether you are using Windows computer, Mac, smartphones or tablets, you will get the same experience while learning. Besides that, you will be able to access the course with any kind of internet connection from anywhere at any time without any kind of limitation. Career Path You will be ready to enter the relevant job market after completing this course. You will be able to gain necessary knowledge and skills required to succeed in this sector. All our Diplomas' are CPD and IAO accredited so you will be able to stand out in the crowd by adding our qualifications to your CV and Resume. Scaffolding Safety in Construction Environments Module 01: Introduction to Scaffolding Safety 00:16:00 Module 02: Types of Scaffolding Systems 00:19:00 Module 03: Scaffolding Design and Planning 00:19:00 Module 04: Scaffolding Assembly and Dismantling 00:24:00 Module 05: Scaffolding Inspection and Maintenance and Repairs 00:16:00 Module 06: Fall Protection and Prevention Systems for Scaffolding 00:13:00 Module 07: Scaffolding Stability and Structural Integrity 00:15:00 Module 08: Safe Access and Egress on Scaffolding 00:16:00 Module 09: Electrical Safety on Scaffolding 00:13:00 Module 10: Emergency Response and Rescue Procedures 00:16:00

This course bundle is ideal for anyone looking to establish their Cisco networking career. It consists of one Cisco Certified Network Associate (CCNA) certification, and two Cisco Certified Networking Professional (CCNP) certifications. Although there are no formal prerequisites to enrol on the CCNA certification course and sit for the exam, learners should have a good foundation knowledge in networking. The newly retooled CCNA covers a breadth of topics, including: Network fundamentals Network access IP connectivity IP services Security fundamentals Automation and programmability Achieving CCNA certification is the first step in preparing for a career in networking technologies. To earn your CCNA certification, you only need to pass one exam – which covers a broad range of fundamentals for IT careers, based on the latest networking technologies. The CCNP is the next level from the CCNA. As with the CCNA, there are no formal prerequisites to enrol on the CCNP certification course and sit for the exams. Learners taking a CCNP course generally have an in-depth knowledge of networking, as well as a good understanding of Cisco technologies. The typical certification path for most learners would begin with the CCNA, then progress onto the CCNP. Learners need to pass two exams (one core exam and one concentration exam) in order to gain a CCNP certification. This course bundle includes both exams. The core exam’s focus is based around implementing and operating Cisco enterprise network core technologies. The concentration exam’s focus for this particular bundle is around designing Cisco enterprise networks.

Are you ready to embark on an enlightening journey of wisdom with the Web Analytics bundle, and pave your way to an enriched personal and professional future? If so, then Step into a world of knowledge with our course bundle - Web Analytics Training. Delve into eight immersive CPD Accredited courses, each a standalone course: Course 01: Google Analytics for Everyone Course 02: Diploma in Data Analytics with Tableau Course 03: HTML Web Development Crash Course Course 04: Learn MySQL from Scratch for Data Science and Analytics Course 05: Big Data Analytics with PySpark Power BI and MongoDB Course 06: Big Data Analytics with PySpark Tableau Desktop and MongoDB Course 07: Learn Financial Analytics and Statistical Tools Course 08: Customer Analytics Training Traverse the vast landscapes of theory, unlocking new dimensions of understanding at every turn. Let the Web Analytics Training bundle illuminate your path to wisdom. The Web Analytics Training bundle offers a comprehensive exploration into a rich tapestry of vast knowledge across eight carefully curated courses. The journey is designed to enhance your understanding and critical thinking skills. Each course within the bundle provides a deep-dive into complex theories, principles, and frameworks, allowing you to delve into the nuances of the subject matter at your own pace. In the framework of the Web Analytics Training package, you are bestowed with complimentary PDF certificates for all the courses included in this bundle, all without any additional charge. Adorn yourself with the Web Analytics bundle, empowering you to traverse your career trajectory or personal growth journey with self-assurance. Register today and ignite the spark of your professional advancement! So, don't wait further and join the Web Analytics Training community today and let your voyage of discovery begin! Learning Outcomes: Attain a holistic understanding in the designated areas of study with the Web Analytics bundle. Establish robust bases across each course nestled within the Web Analytics bundle. Decipher intricate concepts through the articulate content of the Web Analytics bundle. Amplify your prowess in interpreting, scrutinising, and implementing theories. Procure the capacity to engage with the course material on an intellectual and profound level. Become proficient in the art of problem-solving across various disciplines. Stepping into the Web Analytics bundle is akin to entering a world overflowing with deep theoretical wisdom. Each course within this distinctive bundle is an individual journey, meticulously crafted to untangle the complex web of theories, principles, and frameworks. Learners are inspired to explore, question, and absorb, thus enhancing their understanding and honing their critical thinking skills. Each course invites a personal and profoundly enlightening interaction with knowledge. The Web Analytics bundle shines in its capacity to cater to a wide range of learning needs and lifestyles. It gives learners the freedom to learn at their own pace, forging a unique path of discovery. More than just an educational journey, the Web Analytics bundle fosters personal growth, enabling learners to skillfully navigate the complexities of the world. The Web Analytics bundle also illuminates the route to a rewarding career. The theoretical insight acquired through this bundle forms a strong foundation for various career opportunities, from academia and research to consultancy and programme management. The profound understanding fostered by the Web Analytics bundle allows learners to make meaningful contributions to their chosen fields. Embark on the Web Analytics journey and let knowledge guide you towards a brighter future. CPD 80 CPD hours / points Accredited by CPD Quality Standards Who is this course for? Individuals keen on deepening their firm understanding in the respective fields. Students pursuing higher education looking for comprehensive theory modules. Professionals seeking to refresh or enhance their knowledge. Anyone with a thirst for knowledge and a passion for continuous learning. Career path Armed with the Web Analytics bundle, your professional journey can reach new heights. The comprehensive theoretical knowledge from this bundle can unlock diverse career opportunities across several fields. Whether it's academic research, consultancy, or programme management, the Web Analytics bundle lays a solid groundwork. Certificates CPD Certificate Of Completion Digital certificate - Included 8 Digital Certificates Are Included With This Bundle CPD Quality Standard Hardcopy Certificate (FREE UK Delivery) Hard copy certificate - £9.99 Hard copy Transcript - £9.99

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