296 MySQL courses in London delivered Online

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

Total PHP training course description PHP provides for the creation of dynamic web sites. This hands on training course looks at programming with PHP with an emphasis of building dynamic websites. Forms, state management and database integration are all covered with practicals used throughout the course to reinforce theory sessions. What will you learn Create dynamic web sites using PHP. Write PHP programs. Debug PHP programs. Examine existing code and determine its function. Total PHP training course details Who will benefit: Anyone creating dynamic web sites. Prerequisites: Software development fundamentals Duration 3 days Total PHP training course contents What is PHP? PHP history, dynamic web pages, how PHP works, alternatives to PHP. Downloading and installing PHP. Installing MySQL, installing Apache, platform issues. A first PHP web page A basic PHP script, PHP page structure. PHP comments. Integrating PHP and HTML. PHP forms HTML forms, taking values from forms. PHP and HTML Page inputs, environment inputs. phpinfo(), other form elements, sticky fields, generalised code, tables, forms, form elements, style sheets, JavaScript. Variables operators and expressions Expressions, data types, assignments, scope, constants, HTTP environment variables, getting data from forms using variables. Operators Arithmetic, logical, relational, Boolean, others. Control statements Conditional: if, else, elseif, switch. Loops: while, do while, for, break, continue, exit. Functions Built in functions, declaration, arguments, scope, loading functions from other files, defaulting parameters, call by value/ name. Arrays Indexes, array initialisation, array manipulation, multi dimensional arrays, array functions. String handling What is a string, string functions, matching, extraction, replacement. String operations, cleansing, sprintf, formatting web pages, strops and others, splitting strings, REs. PHP and databases Database structure, Database APIs, MySQL, Creating tables, Editing tables, simple SQL queries using PHP, building HTML tables using SQL queries, SQL injection, security issues, error handling. File I/O Opening, reading, writing files. Permissions, ownership, locking, directories. PHP, cookies and sessions State, Cookie properties, setting cookies, retrieving cookies, expiring/deleting cookies. Sessions, session variables, session IDs. PHP and email Emailing from servers, attachments. Objects OOP, PHP classes, constructors, instances.

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.

Master the art of self-hosting WordPress on Linux with our comprehensive video course, designed to empower technical professionals to fully control their web presence.

Understand how Docker works and learn its core features with this hands-on course. This is 90% practice without any useless demos! Learn how to create different containers such as Node.js, Python, WordPress, MongoDB, MySQL, Redis, Elasticsearch, and much more.

Welcome to this beginner's level course on Microsoft SQL Servers. Understand the concepts of SQL and learn to create a new database and table to perform various operations on it, with live running queries as examples. Work on hands-on exercises and understand database concepts in a real-world scenario.