270 MySQL courses in London delivered On Demand

“Master SQL programming and database management with MySQL. Learn to create, manage, and analyze data with SQL’s powerful tools in this comprehensive online course.”

Register on the Advanced Diploma in PHP Web Development with MySQL, GitHub & Heroku today and build the experience, skills and knowledge you need to enhance your professional development and work towards your dream job. Study this course through online learning and take the first steps towards a long-term career. The course consists of a number of easy to digest, in-depth modules, designed to provide you with a detailed, expert level of knowledge. Learn through a mixture of instructional video lessons and online study materials. Receive online tutor support as you study the course, to ensure you are supported every step of the way. Get an e-certificate as proof of your course completion. The Advanced Diploma in PHP Web Development with MySQL, GitHub & Heroku is incredibly great value and allows you to study at your own pace. Access the course modules from any internet-enabled device, including computers, tablet, and smartphones. The course is designed to increase your employability and equip you with everything you need to be a success. Enrol on the now and start learning instantly! What You Get With The Advanced Diploma in PHP Web Development with MySQL, GitHub & Heroku Receive a e-certificate upon successful completion of the course Get taught by experienced, professional instructors Study at a time and pace that suits your learning style Get instant feedback on assessments 24/7 help and advice via email or live chat Get full tutor support on weekdays (Monday to Friday) Course Design The course is delivered through our online learning platform, accessible through any internet-connected device. There are no formal deadlines or teaching schedules, meaning you are free to study the course at your own pace. You are taught through a combination of Video lessons Online study materials Certification Upon successful completion of the course, you will be able to obtain your course completion e-certificate free of cost. Print copy by post is also available at an additional cost of £9.99 and PDF Certificate at £4.99. Who Is This Course For: The course is ideal for those who already work in this sector or are an aspiring professional. This course is designed to enhance your expertise and boost your CV. Learn key skills and gain a professional qualification to prove your newly-acquired knowledge. Requirements: The online training is open to all students and has no formal entry requirements. To study the Advanced Diploma in PHP Web Development with MySQL, GitHub & Heroku, all your need is a passion for learning, a good understanding of English, numeracy, and IT skills. You must also be over the age of 16.  Course Content Unit 01: Introduction Introduction 00:06:00 Unit 02: Environment Configuration Module 01: Setup a PHP Environment using XAMPP 00:16:00 Module 02: Install Composer Package Manager 00:03:00 Module 03: Visual Studio Code - Web Development Add ons 00:12:00 Module 04: Create a GitHub Account 00:13:00 Module 05: Create a Heroku Account 00:08:00 Unit 03: PHP Basics and Syntax Module 01: How PHP Works 00:29:00 Module 02: IFELSE Statements 00:19:00 Module 03: Switch Statements 00:09:00 Module 04: FOR Loop 00:10:00 Module 05: WHILE AND DOWHILE Loops 00:14:00 Module 06: PHP Arrays and Manipulation 00:13:00 Module 07: String Manipulation Functions 00:28:00 Module 08: Date and Time Manipulation Functions 00:15:00 Module 09: User Defined Functions 00:22:00 Module 10: PHP Include and Require 00:22:00 Module 11: PHP Website Layout - With Bootstrap 00:23:00 Module 12: Add Project to Github 00:08:00 Module 13: Publish Website to Heroku 00:20:00 Unit 04: PHP Forms and MySQL and User Authentication Module 01: Project and Website Setup 00:21:00 Module 02: Create a Bootstrap 4 Form 00:28:00 Module 03: PHP Form - $_GET Action 00:23:00 Module 04: PHP Form - $_POST Action 00:11:00 Module 05: Design Database with phpMyAdmin 00:19:00 Module 06: Connect to Database using PHP PDO 00:18:00 Module 07: Save Records to Database 00:38:00 Module 08: View Database Records 00:36:00 Module 09: View One Record's Details 00:28:00 Module 10: Update Database Records 00:34:00 Module 11: Delete Database Records 00:11:00 Module 12: Final Touches: Form Validation, Error Messages, Success Messages 00:17:00 Module 13: Create Heroku App and Remote Database 00:21:00 Module 14: Setup Authentication Tables in Database 00:20:00 Module 15: Setup Login and Authentication 00:29:00 Module 16: Control User Access 00:08:00 Module 17: Sending Confirmation Emails 00:31:00 Module 18: Upload Profile Pictures 00:31:00 Module 19: Final Touches 00:14:00 Resources Resources - Modern PHP Web Development w/ MySQL GitHub & Heroku 00:00:00 Frequently Asked Questions Are there any prerequisites for taking the course? There are no specific prerequisites for this course, nor are there any formal entry requirements. All you need is an internet connection, a good understanding of English and a passion for learning for this course. Can I access the course at any time, or is there a set schedule? You have the flexibility to access the course at any time that suits your schedule. Our courses are self-paced, allowing you to study at your own pace and convenience. How long will I have access to the course? For this course, you will have access to the course materials for 1 year only. This means you can review the content as often as you like within the year, even after you've completed the course. However, if you buy Lifetime Access for the course, you will be able to access the course for a lifetime. Is there a certificate of completion provided after completing the course? Yes, upon successfully completing the course, you will receive a certificate of completion. This certificate can be a valuable addition to your professional portfolio and can be shared on your various social networks. Can I switch courses or get a refund if I'm not satisfied with the course? We want you to have a positive learning experience. If you're not satisfied with the course, you can request a course transfer or refund within 14 days of the initial purchase. How do I track my progress in the course? Our platform provides tracking tools and progress indicators for each course. You can monitor your progress, completed lessons, and assessments through your learner dashboard for the course. What if I have technical issues or difficulties with the course? If you encounter technical issues or content-related difficulties with the course, our support team is available to assist you. You can reach out to them for prompt resolution.

“Master the intricacies of CSS, RESTful APIs, and MySQL with our comprehensive online course. Elevate your web development skills and learn to build and integrate advanced web services.”

In this course, you will learn full-stack web development with React JS for the frontend and Python Django for the backend. You will learn and explore various databases such as Microsoft SQL Server, MySQL, MongoDB, PostgreSQL, and SQLite.

Have you ever wondered how businesses transform raw data into actionable insights or how financial analysts accurately pinpoint market trends? Microsoft Excel stands tall as the fulcrum that balances numerous sectors of the business world. This 8-course Microsoft Excel Mastery: AutoCAD, SQL, Data Analysis, Financial Modelling & Marketing bundle dives deep into the myriad applications of Microsoft Excel, from interfacing with AutoCAD to crafting marketing strategies and comprehensive financial models. In an era defined by data-driven decisions, this 8-course Microsoft Excel Mastery: AutoCAD, SQL, Data Analysis, Financial Modelling & Marketing bundle is tailored to equip learners with the multifaceted applications of Microsoft Excel. Ranging from foundational Excel operations to advanced integrations with tools like AutoCAD and MySQL, the course bundle aims to foster expertise in data management, analysis, and visualisation. Whether you're venturing into financial modelling, HR analytics, or design integration, this bundle serves as a comprehensive guide to mastering Excel in diverse professional realms, ensuring you are well-prepared to leverage its capabilities in the modern workplace. Ready to excel in your career? Embrace the transformative power of data and design by mastering Microsoft Excel with our comprehensive course bundle. Dive in now and shape your future with unparalleled proficiency! The Eight CPD Accredited courses that the bundle includes are: Course 1: Microsoft Excel Course for Everyone - Complete Excel Course Course 2: Excel VBA/Macros Foundations Course 3: Dynamic Excel Gantt Chart and Timelines Course 4: Hands on Programming on AutoCAD to Excel Using VB.NET Course 5: Learn MySQL from Scratch for Data Science and Analytics Course 6: Data Analytics Course 7: Build HR Dashboard using Excel Course 8: Financial Modelling Using Excel Learning Outcomes: Gain comprehensive knowledge and understanding of Microsoft Excel and its vast capabilities. Understand the seamless integration between Excel and tools like AutoCAD and MySQL. Develop proficiency in creating intricate financial models and marketing strategies. Acquire skills to analyse data, forecast trends, and build informative dashboards. Learn the principles of personal finance management using Excel. Master the art of crafting Gantt charts and timelines for effective project management. Microsoft Excel Course for Everyone - Complete Excel Course: Acquaint yourself with the foundational and advanced facets of Microsoft Excel, fostering data management expertise. Excel VBA/Macros Foundations: Dive into the transformative world of VBA, unlocking Excel's programming potentials. Dynamic Excel Gantt Chart and Timelines: Grasp the essentials of project management by designing insightful Gantt charts and timelines in Excel. Hands on Programming on AutoCAD to Excel Using VB.NET: Bridge the realms of design and data by merging AutoCAD functionalities with Microsoft Excel's prowess. Learn MySQL from Scratch for Data Science and Analytics: Understand the confluence of Excel and MySQL, anchoring data science and analytics. Data Analytics: Master the techniques of transforming raw numbers into actionable insights using Microsoft Excel. Build HR Dashboard using Excel: Curate informative HR dashboards, offering a snapshot of organisational metrics, all within Excel. Financial Modelling Using Excel: Unravel the intricacies of financial markets, crafting accurate models in Microsoft Excel. CPD 90 CPD hours / points Accredited by CPD Quality Standards Who is this course for? Individuals keen on enhancing their Microsoft Excel skills for professional or personal reasons. Marketing professionals aiming to refine their strategic planning with Excel. Financial analysts and enthusiasts looking to build and understand models in Excel. Data scientists and analysts desire to integrate Excel with tools like MySQL. Design engineers and architects keen on integrating AutoCAD designs with Excel data. Career path Data Analyst Financial Modeller Marketing Strategist HR Dashboard Specialist Database Administrator (with Excel integration knowledge) Project Manager (familiar with Gantt and timelines in Excel) Design Engineer using Excel with AutoCAD 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 Hardcopy Transcript: £9.99

Learn to build a complete Internet of Things solution with Arduino, a SQL Database, and a web server

Learn how to combine the three most important tools in data science: Python, SQL, and Tableau

Computer Programming: Where Inspiration Meets Logic And Dreams Become Lines Of Code

Web applications shape the digital world we interact with daily—from the simplest online form to complex platforms driving entire businesses. This course is designed for those who are eager to specialise in building, maintaining, and optimising web-based systems. Whether you're familiar with HTML or curious about frameworks and database logic, this course steadily guides you through the layers of modern web application architecture. You’ll explore front-end and back-end development concepts, delve into programming essentials, and gain insights into how dynamic web environments function behind the scenes. If you're aiming to deepen your understanding and sharpen your development capabilities in a focused, structured format—this is your route. Delivered entirely online, it's tailored for learners who appreciate flexibility without compromising depth. 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: CSS Introduction Introduction How to ask a great questions Introduction CSS Choosing Code Editor Installing Code Editor (Sublime Text) CSS Syntax Creating a first page with CSS Style Section 02: CSS Basic Inline CSS Internal CSS External CSS CSS Classes CSS IDs Colors Backgrounds Floating Positioning Margins Padding Borders Section 03: CSS Intermediate Styling Text Aligning Text Styling Links Font Family Font Styles Applying Google Fonts Box Model Icons Tables Navigation-Menu Dropdowns Section 04: CSS Advanced Advanced Selectors Forms Website Layout Rounded Corners Color Keywords Animations Pseudo Classes Gradients Shadows Calculations Creating Responsive Page Section 05: CSS Expert Button Styles Pagination Multiple Columns Image Reflection UI - UX Design Social Media Icons External CSS Style adding Section 06: PHP Introduction What is PHP Installing XAMPP for PHP, MySQL and Apache Installing Code Editor(Visual Studio Code) Creating PHP Project on XAMPP Hello World Program Section 07: PHP Basic Variables Echo and Print Data Types Numbers Boolean Arrays Multi-Dimensional Array Sorting Arrays Constants Section 08: PHP Strings Strings String Formatting String Methods Coding Exercise Solution for Coding Exercise Section 09: PHP Operators Arithmetic operators Assignment operators Comparison operators Increment - decrement operators Logical operators Ternary operator Section 10: PHP Decision making system If statement If-else statement If-elseif-else statement Switch-case statement Section 11: PHP Control flow statements Flow Chart While loop Do-while loop For loop For each loop Coding Exercise Solution for Coding Exercise Section 12: PHP Functions Creating a Function Function with Arguments Default Argument Function return values Call-by-value Call-by-reference Section 13: PHP Super globals $_POST Method $_GET Method Section 14: PHP Advanced Form Handling Date and Time Include Require Sessions File Reading File Upload Section 15: PHP Object oriented programming[OOPs] What is OOP Class and Objects Constructor Destructor Access Modifiers Inheritance Method overriding Abstract Class Interface Section 16: PHP - MySQL Application [CRUD] MySQL Basic PhpMyAdmin Creating Database and Table Database Connection PHP Form Create records PHP Form Reading records PHP Form Update Data PHP Form Delete records Section 17: PHP Real world code forms Registration Form MD5 Algorithm for Encrypting Sha Algorithm Login Form Section 18: PHP Validations On Submit Validation Input Numeric Validation Login Form Validation Form Server-side all Data Validation Form Server-side Validation Section 19: PHP Error handling Try-throw-catch Try-throw-catch-finally Section 20: MYSQL introduction Overview of Databases MySQL Installation MySQL Workbench Installation Connecting to MySQL using Console Section 21: MySQL basic Overview of Challenges SQL Statement Basic SELECT Statement SELECT DISTINCT Column AS Statement COUNT function Section 22: MySQL filtering data SELECT WHERE Clause - One SELECT WHERE Clause - Two ORDER BY LIMIT BETWEEN IN Operator LIKE and ILIKE Section 23: MySQL functions Overview of GROUP BY Aggregation function SUM() Aggregation MIN() and MAX() GROUP BY - One GROUP BY - Two HAVING Clause Section 24: MySQL joins Overview Assessment Overview of JOINS Introduction to JOINS AS Statement table INNER JOIN FULL Outer Join LEFT Outer JOIN RIGHT JOIN Union Section 25: MySQL advanced commands Advanced SQL Commands Timestamps EXTRACT from timestamp Mathematical Functions String Functions SUBQUERY Section 26: MySQL structure creation Database and Tables Data Types Primary key and Foreign key Create Table in SQL Script Section 27: MySQL data queries Insert Update Delete Section 28: MySQL structure queries Alter Table Drop Table Section 29: MySQL constraints NOT NULL Constraint UNIQUE Constraint Section 30: MySQL backup and restore Overview of Databases and Tables Backup database using phpMyAdmin Restoring a Database 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. 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 Web Applications for Specialisation on Development 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 Web Applications for Specialisation on Development course is open to all, with no formal entry requirements. Career path Upon successful completion of The Web Applications for Specialisation on Development Course, learners will be equipped with many indispensable skills and have the opportunity to grab.

Course Overview Master MySQL by learning all the web development skills for creating complex, high-quality web databases.   The Effective LinkedIn Ads Online Course course covers the complete fundamentals of MySQL for relational database management, e-commerce and logging applications. It is designed to equip learners with in-demand industry skills, taking them through the basics such as installation, for those who are new to the field.    This practical training course will explore all the core features of MySQL, as well as best practices for cross platform development, taught by an experienced professional in the field. If you are looking to establish a career in programming or computer science, then this in-depth training will ensure you gain a competitive edge in the job market. This best selling Effective LinkedIn Ads Online Course has been developed by industry professionals and has already been completed by hundreds of satisfied students. This in-depth Effective LinkedIn Ads Online Course is suitable for anyone who wants to build their professional skill set and improve their expert knowledge. The Effective LinkedIn Ads Online Course is CPD-accredited, so you can be confident you're completing a quality training course will boost your CV and enhance your career potential. The Effective LinkedIn Ads Online Course is made up of several information-packed modules which break down each topic into bite-sized chunks to ensure you understand and retain everything you learn. After successfully completing the Effective LinkedIn Ads Online Course, you will be awarded a certificate of completion as proof of your new skills. If you are looking to pursue a new career and want to build your professional skills to excel in your chosen field, the certificate of completion from the Effective LinkedIn Ads Online Course will help you stand out from the crowd. You can also validate your certification on our website. We know that you are busy and that time is precious, so we have designed the Effective LinkedIn Ads Online Course to be completed at your own pace, whether that's part-time or full-time. Get full course access upon registration and access the course materials from anywhere in the world, at any time, from any internet-enabled device.  Our experienced tutors are here to support you through the entire learning process and answer any queries you may have via email.