8237 Insights courses in Sheffield delivered Online

Overview Within the flourishing landscape architecture industry in the UK, opportunities abound for those skilled in transforming outdoor spaces into functional, beautiful, and eco-friendly environments. This comprehensive course offers invaluable insights and knowledge to create harmonious, sustainable landscapes. Gain expertise in green-scaping principles, planting and maintaining trees and shrubs, designing captivating pathways, walls, fences, and water features. Explore the intricate relationship between landscapes and local ecosystems through landscape ecology studies. With a strong emphasis learning and applications, you'll develop the confidence to execute projects that enhance outdoor beauty while contributing to the well-being of natural surroundings. Whether you're an aspiring professional, a homeowner seeking to improve your outdoor space, or an enthusiast passionate about sustainable landscaping, Landscape Architecture Training course provides a solid foundation to succeed in the dynamic landscape architecture field. Enroll today and unlock your potential in this growing industry. In this Landscape Architecture Training course, you will: Sharpen your skills to help you advance your career. Acquire a comprehensive understanding of various related topics and tips from industry experts. Learn in-demand knowledge and skills in high demand among UK employers, which will help to kickstart your career. Enrolling in the Landscape Architecture course can assist you in getting into your desired career faster than you ever imagined. So without further ado, start now! Additional Perks of Buying a Course From Institute of Mental Health Study online - whenever and wherever you want. One-to-one support from a dedicated tutor throughout your course. Certificate immediately upon course completion 100% Money back guarantee Exclusive discounts on your next course purchase from Institute of Mental Health Enrolling in the Landscape Architecture course can assist you in getting into your desired career quicker than you ever imagined. So without further ado, start now. Process of Evaluation After studying the Landscape Architecture course, your skills and knowledge will be tested with a MCQ exam or assignment. You must get a score of 60% to pass the test and get your certificate.  Certificate of Achievement Upon successfully completing the Landscape Architecture course, you will get your CPD accredited digital certificate immediately. And you can also claim the hardcopy certificate completely free of charge. All you have to do is pay a shipping charge of just £3.99. Who Is This Course for? This Landscape Architecture is suitable for anyone aspiring to start a career in Landscape Architecture; even if you are new to this and have no prior knowledge on Landscape Architecture, this course is going to be very easy for you to understand.  And if you are already working in the Landscape Architecture field, this course will be a great source of knowledge for you to improve your existing skills and take them to the next level.  Taking this Landscape Architecture course is a win-win for you in all aspects.  This course has been developed with maximum flexibility and accessibility, making it ideal for people who don't have the time to devote to traditional education. Requirements This Landscape Architecture course has no prerequisite.  You don't need any educational qualification or experience to enrol in the Landscape Architecture course. Do note: you must be at least 16 years old to enrol. Any internet-connected device, such as a computer, tablet, or smartphone, can access this online Landscape Architecture course. Moreover, this course allows you to learn at your own pace while developing transferable and marketable skills. Course Curriculum Module 01: Introduction to Landscape Architecture Introduction to Landscape Architecture 00:22:00 Module 02: Green-scaping Green-scaping 00:18:00 Module 03: Planting Trees and Shrubs Planting Trees and Shrubs 00:20:00 Module 04: Maintenance of Planting Maintenance of Planting 00:19:00 Module 05: Pathways Pathways 00:37:00 Module 06: Walls and Fences Walls and Fences 00:24:00 Module 07: Water Features Water Features 00:21:00 Module 08: Entertainment and Recycling Projects Entertainment and Recycling Projects 00:21:00 Module 09: Landscape Ecology Landscape Ecology 00:17:00 Assignment Assignment - Landscape Architecture 00:00:00

Overview In the realm of public health, Epidemiology in Public Health stands as the sentinel of population wellbeing. The UK's commitment to public health is evident, with the government allocating £3.9 billion to public health services in 2019/20. This Epidemiology in Public Health course unveils the intricate world of disease patterns and health determinants, equipping you with the tools to safeguard communities. As the UK faces evolving health challenges, from emerging infectious diseases to chronic conditions, the demand for skilled epidemiologists continues to rise. The Office for National Statistics reports that life expectancy improvements have slowed since 2011, highlighting the crucial need for epidemiological insights. This course delves into the core principles of Epidemiology in Public Health, from understanding disease occurrence to analysing outbreaks. You'll master the art of study design, measure risk with precision, and grasp the epidemiological concept of population. Join us in the pursuit of public health excellence, where Epidemiology in Public Health becomes your lens to view and transform the health landscape. Whether you're tracking epidemics or preventing diseases, this Epidemiology in Public Health course will be your cornerstone in shaping a healthier future. In this Epidemiology Course, you will: Sharpen your skills to help you advance your career. Acquire a comprehensive understanding of various related topics and tips from industry experts. Learn in-demand knowledge and skills in high demand among UK employers, which will help to kickstart your Epidemiology in Public Health Course career. Enrolling in the Epidemiology in Public Health Course can assist you in getting into your desired career faster than you ever imagined. So, without further ado, start now! Process of Evaluation After studying the Epidemiology course, your skills and knowledge will be tested with a MCQ exam or assignment. You must get a score of 60% to pass the test and get your certificate.  Certificate of Achievement Upon successfully completing the Epidemiology course, you will get your CPD accredited digital certificate immediately. And you can also claim the hardcopy certificate completely free of charge. All you have to do is pay a shipping charge of just £3.99. Who Is This Course for? This Epidemiology is suitable for anyone aspiring to start a career in Epidemiology; even if you are new to this and have no prior knowledge on Epidemiology, this course is going to be very easy for you to understand.  And if you are already working in the Epidemiology field, this course will be a great source of knowledge for you to improve your existing skills and take them to the next level.  Taking this Epidemiology course is a win-win for you in all aspects.  This course has been developed with maximum flexibility and accessibility, making it ideal for people who don't have the time to devote to traditional education. Requirements This Epidemiology course has no prerequisite.  You don't need any educational qualification or experience to enrol in the Epidemiology course. Do note: you must be at least 16 years old to enrol. Any internet-connected device, such as a computer, tablet, or smartphone, can access this online Epidemiology course. Moreover, this course allows you to learn at your own pace while developing transferable and marketable skills. Course Curriculum Module 01: Understanding Epidemiology Understanding Epidemiology 00:18:00 Module 02: Principles of Epidemiology Principles of Epidemiology 00:20:00 Module 03: Study Design Study Design 00:24:00 Module 04: Disease Occurrence Disease Occurrence 00:19:00 Module 05: Variation in Disease by Time, Place, and Person Variation in Disease by Time, Place, and Person 00:15:00 Module 06: Epidemics and Outbreaks Epidemics and Outbreaks 00:26:00 Module 07: Measures of Risk and Disease Prevention Measures of Risk and Disease Prevention 00:23:00 Module 08: Measures of Disease Frequency Measures of Disease Frequency 00:22:00 Module 09: Role of Epidemiology in Public Health Role of Epidemiology in Public Health 00:17:00 Module 10: The Epidemiological Concept of Population The Epidemiological Concept of Population 00:22:00 Assignment Assignment - Epidemiology 00:00:00

Introduction to Applied Accounting Course Overview The Introduction to Applied Accounting course is the perfect starting point for anyone looking to build a strong foundation in the world of accounting. Covering everything from basic accounting principles to financial reporting, management accounting, and cost analysis, this course offers a well-rounded view of real-world accounting practices. You'll explore key topics like the accounting cycle, double-entry bookkeeping, balance sheets, cash flow management, working capital, and even cost accounting techniques. Whether you're aiming to kickstart a new career or sharpen your skills for business success, this course provides essential knowledge delivered in an easy-to-follow and practical way. With businesses increasingly relying on accurate financial data to drive decisions, there's never been a better time to master the fundamentals of accounting and open new career opportunities! Extra Included: Free Course Included: Basic of Accounting Lifetime Access Free Student ID Card Learning Outcome Understand the core concepts and principles of accounting. Master the accounting cycle and double-entry system. Analyse financial statements including balance sheets and income statements. Explore key financial ratios to assess business health. Manage working capital, liquidity, and cash flows. Gain insights into cost accounting, budgeting, and financial reporting. Identify the limitations of accounting systems and recognise intangible assets. Understand internal and external auditing processes. Who is this Introduction to Applied Accounting Course for? This course is ideal for anyone interested in developing a solid foundation in accounting. It's perfect for beginners considering a career in finance, small business owners managing their own accounts, professionals looking to refresh or formalise their knowledge, and students planning to pursue further studies in accounting or business. Entry Requirements There are no formal prerequisites for this course. It is open to anyone with an interest in British Sign Language, particularly those who have completed a basic BSL course or have prior exposure to the language. A foundational understanding of BSL is beneficial to get the most out of the advanced content. Accredited Certification After successfully completing the course, you can get a UK and internationally accepted certificate to share your achievement with potential employers or include it in your CV. For the PDF certificate, you’ll need to pay £9.99. You can get the hard copy for 15.99, which will reach your doorstep by post.

Overview The UK construction industry is a significant contributor to the nation's economy, generating over £110 billion in economic output in 2022, as reported by the Office for National Statistics. Despite challenges, the sector is projected to grow annually by 3.4% from 2023 to 2026. This growth creates a strong demand for skilled professionals in construction cost estimation. Our "Construction Cost Estimation" course is designed to meet this need, offering a thorough curriculum covering key aspects of construction management and cost estimation. The course delves into the fundamentals of construction management, explores the role of cost estimators, and examines the factors influencing cost estimation in the construction industry. Learners will gain insights into cost management techniques and effective material management for construction projects. With the industry's ongoing evolution, staying current with cost estimation methods is essential. This course provides a solid foundation for a career in construction cost estimation, potentially leading to roles such as Construction Cost Estimator, Quantity Surveyor, or Construction Project Manager. By mastering the skills taught in this Construction Cost Estimation course, participants can position themselves for success in the thriving UK construction sector. In This Construction Cost Estimation Diploma Course, You Will: Learn strategies to boost your workplace efficiency. Hone your Construction Cost Estimation Diploma skills to help you advance your career. Acquire a comprehensive understanding of various Construction Cost Estimation Diploma topics and tips from industry experts. Learn in-demand Construction Cost Estimation Diploma skills that are in high demand among UK employers, which will help you to kickstart your career. This Construction Cost Estimation Diploma course covers everything you must know to stand against the tough competition in the Construction Cost Estimation Diploma field.  The future is truly yours to seize with this Construction Cost Estimation Diploma. Enrol today and complete the course to achieve a Construction Cost Estimation Diploma certificate that can change your professional career forever. Additional Perks of Buying a Course From Institute of Mental Health Study online - whenever and wherever you want. One-to-one support from a dedicated tutor throughout your course. Certificate immediately upon course completion 100% Money back guarantee Exclusive discounts on your next course purchase from Institute of Mental Health Enrolling in the Construction Cost Estimation Diploma course can assist you in getting into your desired career quicker than you ever imagined. So without further ado, start now. Process of Evaluation After studying the Construction Cost Estimation Diploma course, your skills and knowledge will be tested with a MCQ exam or assignment. You must get a score of 60% to pass the test and get your certificate.  Certificate of Achievement Upon successfully completing the Construction Cost Estimation Diploma course, you will get your CPD accredited digital certificate immediately. And you can also claim the hardcopy certificate completely free of charge. All you have to do is pay a shipping charge of just £3.99. Who Is This Course for? This Construction Cost Estimation Diploma is suitable for anyone aspiring to start a career in Construction Cost Estimation Diploma; even if you are new to this and have no prior knowledge on Construction Cost Estimation Diploma, this course is going to be very easy for you to understand.  And if you are already working in the Construction Cost Estimation Diploma field, this course will be a great source of knowledge for you to improve your existing skills and take them to the next level.  Taking this Construction Cost Estimation Diploma course is a win-win for you in all aspects.  This course has been developed with maximum flexibility and accessibility, making it ideal for people who don't have the time to devote to traditional education. Requirements This Construction Cost Estimation Diploma course has no prerequisite.  You don't need any educational qualification or experience to enrol in the Construction Cost Estimation Diploma course. Do note: you must be at least 16 years old to enrol. Any internet-connected device, such as a computer, tablet, or smartphone, can access this online Construction Cost Estimation Diploma course. Moreover, this course allows you to learn at your own pace while developing transferable and marketable skills. Course Curriculum Construction Cost Estimation Diploma Module 1- Introduction to Construction Management 00:16:00 Module 2- Cost Estimation 00:34:00 Module 3- Role of Cost Estimator and New Aspects of Cost Estimation 00:10:00 Module 4 - Elements and Factors influencing Cost Estimation 00:16:00 Module 5 -Cost Estimation in Construction Industry 00:38:00 Module 6 - Cost Management 00:19:00 Module 7 - Management of Material for construction 00:20:00 Assignment Assignment - Construction Cost Estimation Diploma 00:00:00

Unlock mental processes & human behaviour insights with our Lvl 4 Adv. Diploma in Psychology. Gain practical skills, theoretical knowledge & career advantage.

Explore the dynamic world of Oil & Gas Industry through our comprehensive course! Gain insights into exploration, production, refining, and global markets.

How can schools build stronger partnerships with parents and better support the wellbeing of multilingual learners? This thought-provoking webinar explores how language learning extends beyond the classroom - and why engaging families is key to pupil success. Featuring insights from leading international educators, the session shares practical strategies to overcome linguistic and cultural barriers, strengthen independent learning, and involve parents, whatever their language background. Real examples from global school settings Proven approaches for engaging EAL parents across cultures Tips for using technology to save time and maximise impact - including how one school saved over 400 hours a year by empowering learners to practise independently Designed for EAL leads, inclusion teams, and senior leaders Watch now and take away proven strategies to create a more inclusive school community. Meet the speakers Mable Newton, Head of ELL at GEMS Founders School, will share how their team supports pupil wellbeing alongside language development. Lewis Foster, Assistant Head at The International School at ParkCity Hanoi, will reflect on how parental engagement shapes EAL learner experiences. Lusine Nalbandyan-Andreke, FlashAcademy® Customer Success Executive, will bring practical insights from schools using independent learning strategies.

Step into the fast-paced field of emergency medical response with our Emergency Medical Technician - Paramedicine Studies Course. Designed to provide a detailed understanding of essential medical procedures and theoretical knowledge, this course explores everything from initial patient assessment and paediatric first aid to managing fluid and electrolyte balance and infection control. Whether it's learning about common injuries or navigating legal responsibilities in healthcare, this course covers a wide range of topics relevant to modern paramedicine. The curriculum follows a logical progression, beginning with an introduction to paramedicine and human anatomy before moving into emergency-specific modules such as ambulance maintenance and medical emergencies. Developed with distance learning in mind, this course is ideal for those looking to explore paramedical concepts in a flexible, accessible format. It's particularly well-suited for individuals pursuing knowledge in healthcare support, first response, or community medical services without the need for attendance-based learning. Key Features: CPD Certified Instant e-certificate and hard copy dispatch by next working day Fully online, interactive course with audio voiceover Developed by qualified professionals in the field Self-paced learning and laptop, tablet, smartphone-friendly 24/7 Learning Assistance Discounts on bulk purchases In "Emergency Medical Technician - Paramedicine Studies," students learn essential skills. They gain knowledge in human anatomy, first aid, pediatric care, injury management, infection control, and initial assessment. Understanding fluid balance, ambulance maintenance, and legal aspects prepares them to handle various medical emergencies competently and ethically. Course Curriculum of this Emergency Medical Technician - Paramedicine Studies Course: Module 01: Introduction to Paramedicine Study Module 02: Basic Human Anatomy Module 03: Basic First Aid Module 04: Paediatric First Aid Module 05: Common Injuries Module 06: Infection Control Module 07: Other Medical Emergency Module 08: Initial Assessment Module 09: Fluid and Electrolyte Balance Module 10: Ambulance Maintenance Module 11: Medical and Legal Issues Learning Outcomes: Understand essential concepts in paramedicine studies. Demonstrate proficiency in basic human anatomy and first aid. Identify and manage common injuries effectively. Apply infection control measures in various medical settings. Perform initial assessments with accuracy and efficiency. Comprehend medical and legal considerations in emergency situations. Accreditation All of our courses are fully accredited, including this Emergency Medical Technician - Paramedicine StudiesCourse, providing you with up-to-date skills and knowledge and helping you to become more competent and effective in Paramedicine Studies. Certification Once you've successfully completed your Emergency Medical Technician - Paramedicine Studies Course, you will immediately be sent a digital certificate. Also, you can have your printed certificate delivered by post (shipping cost £3.99). Our Emergency Medical Technician - Paramedicine Studies Course certification has no expiry dates, although we do recommend that you renew them every 12 months. Assessment At the end of the Emergency Medical Technician - Paramedicine StudiesCourse, there will be an online assessment, which you will need to pass to complete the course. Answers are marked instantly and automatically, allowing you to know straight away whether you have passed. If you haven't, there's no limit on the number of times you can take the final exam. All this is included in the one-time fee you paid for the course itself. CPD 10 CPD hours / points Accredited by CPD Quality Standards Who is this course for? This Emergency Medical Technician - Paramedicine Studies Course can be taken by anyone who wants to understand more about the topic. With the aid of this course, you will be able to grasp the fundamental knowledge and ideas. Additionally, this Emergency Medical Technician - Paramedicine Studies Course is ideal for: Individuals seeking a career in emergency medical services. Healthcare professionals aiming to enhance their skill set. Students interested in paramedicine and emergency care. First responders looking to expand their knowledge base. Requirements Learners do not require any prior qualifications to enrol on this Emergency Medical Technician - Paramedicine Studies Course. You just need to have an interest in Emergency Medical Technician - Paramedicine Studies Course. Career path After completing this Emergency Medical Technician - Paramedicine Studies Course you will have a variety of careers to choose from: Paramedic - £24K to 40K/year. Emergency Medical Technician - £20K to 35K/year. Ambulance Care Assistant - £18K to 25K/year. Emergency Dispatcher - £18K to 30K/year. Healthcare Assistant - £17K to 23K/year. Certificates Digital certificate Digital certificate - Included Once you've successfully completed your course, you will immediately be sent a FREE digital certificate. Hard copy certificate Hard copy certificate - Included Also, you can have your FREE printed certificate delivered by post (shipping cost £3.99 in the UK). For all international addresses outside of the United Kingdom, the delivery fee for a hardcopy certificate will be only £10. Our certifications have no expiry dates, although we do recommend that you renew them every 12 months.

Want hands-on experience?Master Accounting & Finance : Xero, Sage 50, Quickbooks Bookkeeping for a Brighter Financial Future! Imagine a world where the complexities of Accounting & Finance : Xero, Sage 50, Quickbooks Bookkeeping seamlessly blend with technology, transforming the way businesses manage their finances. With a soaring demand for proficient accountants, this Accounting & Finance : Xero, Sage 50, Quickbooks Bookkeeping course equips you with the theoretical knowledge to excel in a thriving job market, where salaries for skilled professionals reach impressive heights. Picture that: you’re ready to navigate the intricacies of financial management with confidence. By enrolling in Accounting & Finance : Xero, Sage 50, Quickbooks Bookkeeping, you position yourself for success in a competitive landscape. This Accounting & Finance : Xero, Sage 50, Quickbooks Bookkeeping course not only enhances your understanding of essential accounting principles but also prepares you to leverage modern software effectively, setting you apart from the crowd. Main Course: Course 01: Diploma in Accounting & Finance at QLS Level 4: A comprehensive foundation in Accounting & Finance : Xero, Sage 50, Quickbooks Bookkeeping, equipping students with essential theoretical knowledge. Gift Courses: Course 02: Advanced Diploma in Xero Accounting & Bookkeeping at QLS Level 7: Gain in-depth insights into Xero software for higher-level financial management roles. Course 03: Advanced Diploma in Sage 50 Accounts at QLS Level 6: Master Sage 50 through theoretical study of financial reporting and accounting processes. Course 04: Certificate in Quickbooks Online Bookkeeping at QLS Level 3: Learn the fundamentals of Quickbooks Online to enhance your bookkeeping skills and career prospects. Curriculum Breakdown of the Accounting & Finance : Xero, Sage 50, Quickbooks Course Course 01: Diploma in Accounting & Finance at QLS Level 4 Introduction to Accounting & Finance The Role of an Accountant Accounting & Finance Concepts and Standards Double-Entry Bookkeeping Balance Sheet Income statement Financial statements Cash Flow Statements Understanding Profit and Loss Statement Financial Budgeting and Planning Auditing Why would you choose the Accounting & Finance: Lifetime access to Accounting & Finance course materials Full tutor support is available from Monday to Friday with the Accounting & Finance course Learn Accounting & Finance skills at your own pace from the comfort of your home Gain a complete understanding of Accounting & Finance Accessible, informative Accounting & Finance modules designed by experts Get 24/7 help or advice from our email and live chat teams with the Accounting & Finance course Study in your own time through your computer, tablet or mobile device A 100% learning satisfaction guarantee with your course Quality Licence Scheme Endorsed Certificate of Achievement: Upon successful completion of the Accounting & Finance: Xero, Sage 50, Quickbooks Bookkeeping course, you will be eligible to order an original hardcopy certificate of achievement. This prestigious certificate, endorsed by the Quality Licence Scheme, will be titled 'Diploma in Accounting & Finance at QLS Level 4'. Your certificate will be delivered directly to your home. The pricing scheme for the certificate is as follows: £89 GBP for addresses within the UK. Please note that delivery within the UK is free of charge. 4 CPD Accredited PDF CertificateDigital certificate - Included CPD Accredited PDF CertificateEach CPD Accredited Hard Copy CertificateHard copy certificate - £10.79 Disclaimer This Accounting & Finance: Xero, Sage 50, Quickbooks Bookkeeping course will teach you about Xero accounting software and help you improve your skills using it. It's created by an independent company, & not affiliated with Xero Limited. Upon completion, you will earn a CPD accredited certificate, it's not an official Xero certification. CPD 150 CPD hours / points Accredited by CPD Quality Standards Who is this course for? This Accounting & Finance course is designed for: Aspiring Accountants: Individuals looking to build a strong theoretical foundation in Accounting & Finance : Xero, Sage 50, Quickbooks Bookkeeping. Business Owners : Entrepreneurs seeking to manage their financial records more effectively using modern Accounting & Finance software. Finance Students: Students who want to enhance their understanding of Accounting & Finance principles and software applications. Professionals Seeking Career Advancement: Those looking to improve their credentials and knowledge in Accounting & Finance software. Individuals Transitioning to Finance: Anyone interested in shifting to a finance-related career and wanting to understand key Accounting & Finance software. This Accounting & Finance course is your gateway to mastering Accounting & Finance : Xero, Sage 50, Quickbooks Bookkeeping and elevating your understanding of the financial landscape! Requirements To enrol in this Accounting & Finance: Xero, Sage 50, Quickbooks course, all you need is a basic understanding of the English Language and an internet connection. Career path The Accounting & Finance: Xero, Sage 50, Quickbooks course will enhance your knowledge and improve your confidence in exploring opportunities in various sectors related to Accounting & Finance: Xero, Sage 50, Quickbooks. Accountant: £18K to £35K per year. Bookkeeper: £18K to £28K per year. Payroll Clerk: £18K to £30K per year. Administrative Assistant: £18K to £32K per year. Certificates 4 CPD Accredited PDF Certificate Digital certificate - Included CPD Accredited PDF Certificate

Data speaks volumes—if you know how to listen. This course offers a clever route into the world of MySQL, showing you how structured data can turn into smart decisions. Whether you're sifting through figures, building dashboards, or deciphering patterns, understanding SQL isn’t just helpful—it’s essential. You’ll be guided through the foundations of MySQL with clarity and precision, making sense of tables, queries, joins, and more—all without the fluff or confusion. Designed with the analytical mind in focus, this course shines a light on how MySQL powers insights behind the scenes in data science and analytics. It's tailored for learners who prefer clarity over jargon and structure over noise. If you're curious about how databases work and how data fuels smart outcomes, this course is your ideal stepping stone—organised, engaging and purposefully built for those who appreciate logic and clean learning paths. Expert Support Dedicated tutor support and 24/7 customer support are available to all students with this premium quality course. Key Benefits Learning materials of the Design course contain engaging voiceover and visual elements for your comfort. Get 24/7 access to all content for a full year. Each of our students gets full tutor support on weekdays (Monday to Friday) Course Curriculum: Section 01: Getting Started Introduction How to get course requirements Getting started on Windows, Linux or Mac How to ask great questions FAQ's What is Source Code? Section 02: SQL Server setting up Section Introduction MySQL Server Installation Connect MySQL Server Instance MySQL Workbench overview Download and Restore Sample Database Section 03: SQL Database basics Section Introduction Overview of Databases Creating Database SQL Data Types Column Data Types on Workbench Creating Table Overview of Primary and Foreign Key Primary Key Foreign Key Creating Temporary tables EER - Enhanced Entity Relationship Diagrams Section 04: SQL DML (Data Manipulation Language) Section Introduction Insert statement Update statement Delete statement Section 05: SQL DDL (Data Definition Language) Section Introduction CREATE table statement DROP statement ALTER statement TRUNCATE statement COMMENT in query RENAME table Section 06: SQL DCL (Data Control Language) Create Database user GRANT permissions REVOKE permissions Section 07: SQL Statement Basic Section Introduction SQL Statement basic SELECT Statement SELECT DISTINCT SELECT with column headings Column AS statement DASHBOARD Analytics Section 08: Filtering Data rows SELECT WHERE Clause - theory SELECT WHERE Clause - practical Section 09: Aggregate functions for Data Analysis Sum() Min()-Max() Section 10: SQL Data Analyticstatements Order By statement SELECT TOP 3 records BETWEEN command IN operator Search Data usingLIKE cards Section 11: SQL Group by statement Section Introduction Group by - theory Data Analytics with Group By HAVING statement Section 12: JOINS Overview of Joins What are Joins Inner join Left outer join Right outer join Union CERTESIAN Product or Cross Join Query Exercise Solution for Query Exercise Section 13: SQL Constraints Section introduction Check constraint NOT NULL constraint UNIQUE constraint Section 14: Views Creating Views Data Analytic Viewsfrom multiple tables Section 15: Advanced SQL Functions Section Introduction Timestamp Extract from timestamp Mathematical scalar functions String functions Advanced functions Sub Queries SELECT with calculations Section 16: SQL Stored procedures Create stored procedure Stored procedure with parameter Drop Procedure Section 17: Import & Export data Section Introduction Import .csv file Export Data to .csv file Section 18: Backup and Restore Database Section Introduction Creating Database backup Restoring Database backup Exam & Retakes: It is to inform our learners that the initial exam for this online course is provided at no additional cost. In the event of needing a retake, a nominal fee of £9.99 will be applicable. Certification Upon successful completion of the assessment procedure, learners can obtain their certification by placing an order and remitting a fee of £9 for PDF Certificate and £15 for the Hardcopy Certificate within the UK ( An additional £10 postal charge will be applicable for international delivery). Who is this course for? This Learn MySQL from Scratch for Data Science and Analytics course is designed to enhance your expertise and boost your CV. Learn key skills and gain a certificate of achievement to prove your newly-acquired knowledge. Requirements This Learn MySQL from Scratch for Data Science and Analytics course is open to all, with no formal entry requirements. Career path Upon successful completion of The Learn MySQL from Scratch for Data Science and Analytics Course, learners will be equipped with many indispensable skills and have the opportunity to grab.