• Professional Development
  • Medicine & Nursing
  • Arts & Crafts
  • Health & Wellbeing
  • Personal Development

16704 ESS courses in Bristol delivered On Demand

Ultimate Dot Net Training for Everyone Course

By One Education

Whether you're brushing up or building from scratch, the Ultimate Dot Net Training for Everyone Course is tailored for those who want to get to grips with the .NET framework without the headache. Covering everything from the basics of C# to more structured application development using modern .NET features, this course offers a straight-talking guide through the platform’s essentials—minus the noise, filler, and waffle. You’ll follow a logical progression designed to make sure concepts stick, without needing to decipher cryptic docs or sit through endless theory slides. The content has been crafted with clarity, structure, and a touch of dry wit—because learning doesn’t have to feel like reading a manual from the 90s. Whether you’re interested in developing sleek APIs, building reliable backends, or just understanding how .NET pieces fit together, this course gives you the tools to do just that—digitally, remotely, and at your own pace. It’s a solid, no-frills walkthrough for anyone keen to make sense of Microsoft’s development stack, whether you're exploring it for the first time or picking it back up after a few versions off. Learning Outcomes: Gain a solid understanding of the .NET framework and its capabilities. Learn how to program in C# and create basic software applications. Discover how to handle exceptions, work with databases, and create games and chatbots. Understand the principles of object-oriented programming and their applications in software development. Learn how to create robust and scalable software applications using the .NET framework. The Ultimate Dot Net Training for Everyone course is designed to provide you with the skills and knowledge you need to become a proficient .NET software developer. Starting with the basics of C# programming and moving on to more advanced topics, this course covers everything you need to know to create robust and scalable software applications. You'll learn how to work with databases, handle exceptions, and even create your own games and chatbots. Along the way, you'll gain a solid understanding of the principles of object-oriented programming and its applications in software development. ⊱⊱ Ultimate Dot Net Training for Everyone Course Curriculum Section 01: Installation Section 02: Basics on C# Programming Section 03: Conditional Constructs Section 04: Loops Section 05: Arrays and For loop Section 06: Methods Section 07: OOPS Concepts Section 08: Project - Creating a Login Page Section 09: File Handling Section 10: Exception Handling Section 11: Database Connectivity Section 12: Project - Creating a login Page Using DB Connectivity Section 13: Working with Database Section 14: Project - Flappy Bird Game Section 15: Project - Baneful Game Section 16: Project - Chabot Section 17: Project - Online Examination System How is the course assessed? Upon completing an online module, you will immediately be given access to a specifically crafted MCQ test. For each test, the pass mark will be set to 60%. 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). CPD 10 CPD hours / points Accredited by CPD Quality Standards Who is this course for? Individuals who are new to programming and want to learn about the .NET framework. Experienced programmers who want to expand their skills and knowledge in .NET development. Entrepreneurs who want to develop their own software applications using .NET. Students who want to enhance their skills in software development and prepare for a career in the field. Anyone who wants to develop their skills in the software development industry. Career path Junior .NET Developer: £20,000 - £35,000 .NET Developer: £28,000 - £55,000 Senior .NET Developer: £40,000 - £80,000 Software Engineer: £28,000 - £60,000 Chief Technology Officer: £90,000 - £250,000 Certificates Certificate of completion Digital certificate - £9 You can apply for a CPD Accredited PDF Certificate at the cost of £9. Certificate of completion Hard copy certificate - £15 Hard copy can be sent to you via post at the expense of £15.

Ultimate Dot Net Training for Everyone Course
Delivered Online On Demand10 hours
£12

Learn Machine Learning with R Course

By One Education

R isn’t just for statisticians hiding behind graphs — it’s a powerful tool for machine learning, and this course shows you exactly how to put it to work. Designed for curious minds with an interest in data prediction, modelling, and pattern recognition, this course guides you through the essentials of machine learning using R. You’ll explore key techniques like classification, regression, and clustering, all explained in plain English (with just the right amount of code). If you’ve ever wondered how machines “learn” from data — without trying to make them smarter than your laptop needs to be — this course breaks it down with clear logic and no unnecessary flair. Study entirely online, at your own pace, with structured content focused on helping you understand how algorithms behave, why they do what they do, and how to make them behave a little better. Whether you're dipping your toes or deepening your skills, it’s all here, minus the fluff and drama. Learning Outcomes: Understand the basics of machine learning and its implementation using R. Develop the skills to build simple and multiple linear regression models. Learn how to use R to analyse datasets and develop predictive models. Understand the concept of dummy variables and the backward elimination approach. Learn how to make accurate predictions using machine learning algorithms and extract valuable insights from data. If you're looking to expand your knowledge in data analysis and machine learning, then the "Learn Machine Learning with R" course is perfect for you. This comprehensive course comprises two sections, each designed to help you gain an in-depth understanding of machine learning concepts, starting from the very basics. You'll learn about linear regression, the equation for the algorithm, and how to make simple linear regression models. Additionally, you'll dive into multiple linear regression, dummy variable concepts, and predictions over the year. With the help of this course, you'll be able to analyse datasets, develop predictive models, and extract valuable insights from them, using R. ⊱⊱ Learn Machine Learning with R Course Curriculum Section 01: Linear Regression and Logistic Regression Working on Linear Regression Equation Making the Regression of the Algorithm Basic Types of Algorithms predicting the Salary of the Employee Making of Simple Linear Regression Model Plotting Training Set and Work Section 02: Understanding Dataset Multiple Linear Regression Dummy Variable Concept Predictions Over Year Difference Between Reference Elimination Working of the Model Working on Another Dataset Backward Elimination Approach Making of the Model with Full and Null How is the course assessed? Upon completing an online module, you will immediately be given access to a specifically crafted MCQ test. For each test, the pass mark will be set to 60%. 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). CPD 10 CPD hours / points Accredited by CPD Quality Standards Who is this course for? Students or professionals looking to develop their data analysis and machine learning skills. Individuals interested in pursuing a career in data science or machine learning. Anyone interested in understanding how to extract insights from data. Programmers looking to learn machine learning implementation using R. Beginners interested in learning the basics of machine learning. Career path Data analyst: £30,000 to £50,000 Machine learning engineer: £45,000 to £85,000 Data scientist: £40,000 to £80,000 Business analyst: £30,000 to £55,000 Research analyst: £25,000 to £45,000 Certificates Certificate of completion Digital certificate - £9 You can apply for a CPD Accredited PDF Certificate at the cost of £9. Certificate of completion Hard copy certificate - £15 Hard copy can be sent to you via post at the expense of £15.

Learn Machine Learning with R Course
Delivered Online On Demand3 hours
£12

Dog Training - Feed Your Dog A Raw Diet Course

By One Education

Is your dog more interested in the postman’s trousers than its dinner bowl? You might need a rethink on what’s going into that dish. This raw feeding course is a straight-talking, no-nonsense guide to getting your dog’s diet back to nature—without chasing squirrels. You’ll get a structured understanding of why a raw food diet may benefit your dog’s health, mood and digestive habits, while cutting through the fads and fluff often found online. Whether you’ve got a pedigree showstopper or a mischievous mutt, this course will walk you through the essentials of raw feeding with clarity and confidence. Expect balanced insights on portioning, nutritional needs, common mistakes, and how to transition from kibble without turning mealtime into a standoff. Give your dog a bowl worth barking about, and enjoy a learning experience that’s informative, engaging, and free of overcooked jargon. Learning Outcomes: Understand the benefits and risks of feeding your dog a raw diet Learn about the BARF diet and Raw Meaty Bones (RMB) or Prey Model feeding for dogs Understand how to safely prepare and serve raw meaty bones to your dog Discover how to ensure your dog is getting the right nutrition on a raw diet Learn how to transition your dog to a raw diet and troubleshoot any issues that arise This course is divided into several sections that cover different aspects of feeding your dog a raw diet. The course begins with an introduction to the instructor and his dogs, as well as an overview of what you can expect to learn in the course. The first section focuses on the BARF diet, which is a popular raw feeding approach that emphasises feeding dogs a variety of raw meats, bones, fruits, and vegetables. In this section, you will learn about the benefits of the BARF diet, as well as potential risks and how to mitigate them. The second section covers Raw Meaty Bones (RMB) or Prey Model feeding, which is a more controversial raw feeding approach that involves feeding dogs whole raw animals, including bones and organs. In this section, you will learn about the benefits and risks of this approach, as well as how to safely prepare and serve raw meaty bones to your dog. Throughout the course, you will also learn about the importance of balanced nutrition for dogs and how to ensure your dog is getting the right nutrients on a raw diet. You will also learn how to transition your dog to a raw diet and troubleshoot any issues that arise. How is the course assessed? Upon completing an online module, you will immediately be given access to a specifically crafted MCQ test. For each test, the pass mark will be set to 60%. 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 __ GBP. £9 for PDF Certificate and £15 for the Hardcopy Certificate within the UK ( An additional £10 postal charge will be applicable for international delivery). CPD 10 CPD hours / points Accredited by CPD Quality Standards Who is this course for? The course is ideal for highly motivated individuals or teams who want to enhance their professional skills and efficiently skilled employees. Requirements There are no formal entry requirements for the course, with enrollment open to anyone! Career path Pet store employees: £15,000 - £22,000 per year Dog trainers: £20,000 - £35,000 per year Veterinary assistants: £16,000 - £24,000 per year Dog groomers: £15,000 - £25,000 per year Animal shelter employees: £15,000 - £22,000 per year Please note that these are estimated salaries and can vary depending on factors such as location and level of experience. Certificates Certificate of completion Digital certificate - £9 You can apply for a CPD Accredited PDF Certificate at the cost of £9. Certificate of completion Hard copy certificate - £15 Hard copy can be sent to you via post at the expense of £15.

Dog Training - Feed Your Dog A Raw Diet Course
Delivered Online On Demand1 hour
£12

Strategy Planning and Execution Course

By One Education

Success rarely arrives by accident – it’s built on clear strategy and decisive execution. This Strategy Planning and Execution Course is designed for those ready to shape business direction with precision and confidence. Whether you're responsible for driving departmental goals or overseeing entire operations, this course lays out the essential thinking patterns behind smart planning, and the logical steps needed to turn vision into results. You’ll explore the key frameworks that influence strategic decisions, how to assess internal and external environments effectively, and how to align goals with long-term organisational direction. It also guides you through execution techniques that keep plans from gathering dust—transforming ideas into outcomes through accountability, leadership alignment and timely action. If navigating high-level objectives with clarity and purpose is on your radar, this course will give you the tools to do just that—with less waffle, and more results. Meet the Accreditation CPD Quality Standards (CPD QS) accreditation assure the Strategy Planning and Execution course training and learning activities are relevant, reliable, and upto date. 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) This masterclass Strategy Planning and Execution online training course is designed by industry experts and will give you an in-depth understanding of this topic. The Strategy Planning and Execution course features easy-to-digest modules that break down each topic and ensure all our students receive an unrivalled and thorough learning experience. If you want to work in this rapidly growing sector and stand out from the competition, then our Strategy Planning and Execution is the perfect place to kickstart your dream career. On the Strategy Planning and Execution course, we guarantee that you will gain relevant skills and acquire tremendous knowledge on the subject. The certificate you'll achieve after completing the Strategy Planning and Execution course will help you land the job you want in a related field. Enjoy a pleasant and expert 100% online learning experience and enrol in our Strategy Planning and Execution today and take control of your career! Course Curriculum: Here is a curriculum breakdown of the Strategy Planning and Execution course: Unit 01: Introduction Introduction & Course Map Unit 02: Strategy Strategy Development Environmental Scanning Strategy Management Balanced Scorecard Unit 03: Key Performance Indicators KPIs Introduction KPIs Selection KPIs Quality KPIs Forms & Types KPIs Polarity, Status, & Documentation Target Setting Target Setting Methods & Example Unit 04: Alignment Vertical Alignment Horizontal Alignment Employee Alignment OGSM Method Cascading in Public Sector Unit 05: Leading Strategy Execution Kippy.cloud System Review Meeting Leadership & Communication Unit 06: Conclusion Terminology Bonus Book & Conclusion Course Assessment To simplify the procedure of evaluation and accreditation for learners, we provide an automated assessment system. Upon completion of an online module, you will immediately be given access to a specifically crafted MCQ test. The results will be evaluated instantly, and the score will be displayed for your perusal. For each test, the pass mark will be set to 60%. When all tests have been successfully passed, you will be able to order a certificate endorsed by the Quality Licence Scheme. CPD 120 CPD hours / points Accredited by CPD Quality Standards Who is this course for? This Strategy Planning and Execution 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 Strategy Planning and Execution course is open to all, with no formal entry requirements. Career path Upon successful completion of the Strategy Planning and Execution Course, learners will be equipped with many indispensable skills and have the opportunity to grab. Certificates Certificate of completion Digital certificate - £9 Certificate of completion Hard copy certificate - £89 QLS Endorsed Certificate Hardcopy of this certificate of achievement endorsed by the Quality Licence Scheme can be ordered and received straight to your home by post, by paying - Within the UK: £89 International: £89+ £10 (postal charge) = £99 CPD Accredited Certification Hardcopy Certificate (within the UK): £15 Hardcopy Certificate (international): £15 + £10 (postal charge) = £25

Strategy Planning and Execution Course
Delivered Online On Demand3 weeks
£12

Safety Audits

By St. Paul's College

This course delves into the theoretical underpinnings of safety audit practices, from meticulous planning to advanced risk assessment and continuous improvement strategies.

Safety Audits
Delivered Online On Demand2 hours
£11.99

Actuary Online Course

By St. Paul's College

The Actuary Online Course offers a comprehensive exploration of these scientific foundations, delving into deterministic and stochastic models, life insurance, annuities, and the complex interplay between taxation, inflation, and risk.

Actuary Online Course
Delivered Online On Demand3 hours
£11.99

Neuroscience: The Human Brain

By St. Paul's College

The Neuroscience: The Human Brain course begins with a comprehensive introduction to neuroscience, setting the stage for a detailed study of the brain's intricate networks and their role in shaping human behaviour and cognition.

Neuroscience: The Human Brain
Delivered Online On Demand3 hours
£11.99

Build HR Dashboard using Excel Course

By One Education

Numbers tell stories—but only if you know how to read them. This course is designed to guide learners through the fine art of building HR dashboards using Excel, helping you turn columns and cells into clear, strategic insights. Whether you're navigating headcount data, analysing attrition, or tracking recruitment pipelines, you’ll gain the structured knowledge to bring clarity to the chaos of workforce figures. No fluffy jargon or corporate riddles—just solid Excel techniques that speak directly to HR needs. Through well-organised lessons, you'll explore how to compile, format, and visualise essential HR data in a way that even senior leadership won’t scroll past. From pivot tables to conditional formatting and dynamic charts, this course will help you create dashboards that don’t just look good, but actually mean something. If you're in HR and Excel is your daily battleground, this course will teach you how to build dashboards that do the talking for you—neatly, clearly, and without needing a 50-slide presentation. Learning Outcomes: Develop an understanding of the principles and practices of HR dashboard analysis using Excel Learn effective strategies for index and tab designing, MOM headcount, and employee compensation front face Develop analytical skills for departmental and location analysis, tenure wise analysis, and job rating analysis Understand how to utilize Excel to gain insights on complex HR data sets Be able to make informed decisions and navigate the complex and dynamic world of HR analytics using Excel The "Build HR Dashboard using Excel" course is designed to provide a comprehensive understanding of the principles and practices that underpin successful HR dashboard analysis using Excel. Through engaging modules and real-world case studies, learners will gain insights into effective strategies for index and tab designing, MOM headcount, employee compensation frontface, departmental and location analysis, tenure wise analysis, and job rating analysis. By the end of the course, learners will be equipped with the knowledge and skills to make informed decisions and navigate the complex and dynamic world of HR analytics using Excel. Whether you're an HR professional looking to enhance your skills or a beginner looking to enter the world of HR analytics, this course is a must-have for anyone interested in building a comprehensive HR dashboard using Excel. Build HR Dashboard using Excel Course Curriculum Section 01: Introduction Section 02: Data Introduction Section 03: Index Design and Tab Designing Section 04: Employee Frontface Section 05: Pivot Data List Section 06: MOM Headcount Section 07: Departmental and Location Analysis Section 08: Tenure wise Analysis Section 09: Age wise Analysis Section 10: Emp Demo and Quality Circles Section 11: Time Sheet Late Marks Analysis Section 12: Full and Final Analysis Section 13: Training Analysis Section 14: Employee Compensation Frontface Section 15: Job Rating Analysis Section 16: HR Update Section 17: Conclusion How is the course assessed? Upon completing an online module, you will immediately be given access to a specifically crafted MCQ test. For each test, the pass mark will be set to 60%. 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 __ GBP. £9 for PDF Certificate and £15 for the Hardcopy Certificate within the UK ( An additional £10 postal charge will be applicable for international delivery). CPD 10 CPD hours / points Accredited by CPD Quality Standards Who is this course for? HR professionals looking to enhance their data analysis skills using Excel Beginners interested in the world of HR dashboard analysis using Excel Business students interested in the field of HR analytics using Excel Entrepreneurs looking to incorporate data analysis into their HR practices using Excel Anyone interested in gaining a comprehensive understanding of HR analytics using Excel Career path HR Analyst: £25,000 - £50,000 per year HR Manager: £35,000 - £70,000 per year HR Business Partner: £35,000 - £90,000 per year HR Director: £70,000 - £150,000 per year Chief Human Resources Officer (CHRO): £100,000 - £250,000+ per year Certificates Certificate of completion Digital certificate - £9 You can apply for a CPD Accredited PDF Certificate at the cost of £9. Certificate of completion Hard copy certificate - £15 Hard copy can be sent to you via post at the expense of £15.

Build HR Dashboard using Excel Course
Delivered Online On Demand6 hours
£12

Python Intermediate Training Course

By One Education

Step beyond the basics and dive deeper into Python with our Intermediate Training Course, designed for those who have already dipped their toes into coding and are ready to advance their skills. This course carefully guides you through more intricate concepts such as object-oriented programming, data manipulation, and working with modules and libraries—all essential tools in the modern Python programmer’s toolkit. Whether you want to enhance your coding fluency or prepare for more specialised projects, this course offers the perfect balance of theory and thoughtful explanation, ensuring clarity without drowning you in jargon. Crafted for learners who appreciate precision and clarity, the course content balances informative detail with a touch of wit to keep you engaged without ever feeling like you’re slogging through a manual. Ideal for self-paced study, it fits neatly around your schedule and learning preferences. By the end, you’ll be confidently handling Python’s intermediate-level challenges and writing code that’s not only functional but a little bit clever too. Ready to level up your programming skills? This course is your next smart step. Learning Outcomes: Gain a deeper understanding of intermediate-level Python concepts. Learn how to work with matrices and manipulate lists and dictionaries. Discover how to use Python to solve complex problems and write efficient and elegant code. Understand how to manipulate data structures and perform advanced data analysis tasks. Learn how to use Python to build real-world projects and applications. The Python Intermediate Training course is designed to provide you with the skills and knowledge you need to become a proficient Python developer. Whether you're a beginner or an experienced programmer looking to enhance your Python skills, this course is perfect for you. Starting with the basics of matrices and lists and moving on to more advanced topics, such as dictionaries and data analysis, this course covers everything you need to know to become a proficient Python developer. You'll learn how to manipulate data structures, perform advanced data analysis tasks, and use Python to build real-world projects and applications. ⊱⊱ Python Intermediate Training Course Curriculum Section 01: Introduction Course Introduction Section 02: Matrix in Python Working on Matrix in Python Working on Matrix in Python Continued Performing Sort Section 03: Working on List in Python Merging to Dictionaries Concatenation of List Example Excepting Values in List and Adding those Using for Loop Excepting Values in List and Adding Those Using While Loop Performing Arithmetic Operation on List Data Structure in Python Data Structure in Python Continued Section 04: Lists & Dictionaries in Python List and Dictionary in Python List and Dictionary in Python Continued Various Sorting Methods in Python Part 1 Various Sorting Methods in Python Part 2 Binary Search Example Reversing a String Dictionary Examples More on List and Dictionary Examples String Examples How is the course assessed? Upon completing an online module, you will immediately be given access to a specifically crafted MCQ test. For each test, the pass mark will be set to 60%. 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 __ GBP. £9 for PDF Certificate and £15 for the Hardcopy Certificate within the UK ( An additional £10 postal charge will be applicable for international delivery). CPD 10 CPD hours / points Accredited by CPD Quality Standards Who is this course for? Python beginners who want to take their skills to the next level. Experienced programmers who want to expand their Python skills and knowledge. Data analysts who want to use Python for advanced data analysis tasks. Entrepreneurs who want to develop their own Python-based applications. Students who want to enhance their Python skills and prepare for a career in programming. Requirements There are no formal entry requirements for the course, with enrollment open to anyone! Career path Python Developer: £28,000 - £55,000 Data Analyst: £24,000 - £45,000 Software Engineer: £28,000 - £60,000 Technical Lead: £40,000 - £90,000 Chief Technology Officer: £90,000 - £250,000 Certificates Certificate of completion Digital certificate - £9 You can apply for a CPD Accredited PDF Certificate at the cost of £9. Certificate of completion Hard copy certificate - £15 Hard copy can be sent to you via post at the expense of £15.

Python Intermediate Training Course
Delivered Online On Demand3 hours
£12

Learn MySQL from Scratch for Data Science and Analytics Course

By One Education

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.

Learn MySQL from Scratch for Data Science and Analytics Course
Delivered Online On Demand6 hours
£12