Regular Price: £280 Batch Price: From £280 📅 View Dates & Prices Group Booking Discount: From £160 per person 🧮 Calculate & Book 1-to-1 Training: £280 📋 Booking Request Form Course Overview MySQL is one of the most popular database management system. You will learn how to install MySQL and create a database from scratch from this instructor led, hands-on classroom based training. Our MySQL Database for Beginners course covers all the basics syntax and SQL statements to create, insert, update, delete data and manage tables. This course is also very useful for the Web Developer to build MySQL database driven websites. It is also a prerequisite course to attend our PHP courses. Following topics are included in this course: Introduction of Database Introduction of MySQL SQL: DDL SQL: DML SQL: DCL JOIN SUBQUERY Requirements No existing knowledge of SQL or MySQL is required. You should have basic experience of using computers and web browsers. This includes: able to use keyboard and mouse know how to create, save, move and rename files If you do not have basic computer and Internet skills then we highly recommend you to attend our Computer Basics for Absolute Beginners course before attending this course. Course Content Introduction of Database Data model Relational Model Relational Keys Integrity Constraints Introduction of MySQL Why MySQL? Working with MYSQL Using phpMyAdmin Installation Types of tables Datatypes and attributes Security Users SQL: DDL CREATE ALTER DROP TRUNCATE SQL: DML INSERT UPDATE DELETE SELECT Querying Data with SELECT Basic SELECT statement Using WHERE clause Using IN operator Using BETWEEN clause Using NOT Logical operators Using Wildcards Using Functions ORDER BY GROUP BY HAVING Indexes and Constraints Introduction to Indexes Introduction to Constraints Primary Keys Foreign Keys Unique Constraints Joining Multiple Tables Simple Join Outer Join Inner Join Self Join Subquery Introduction to subqueries Using subqueries Subqueries and joins Views Introduction to Views Creating views Updating views Back Up and Restore Backup MySQL Databases Restoring a MySQL dump Course Dates, Prices & Enrolment All Training Physical Classes Virtual Classes UTC British Time (UK, Ireland, Iceland) Central European Time (France, Germany, Sweden) Eastern European Time (Finland, Cyprus) Eastern Time (New York, Toronto, Montreal) Central Time (Chicago, Houston, Winnipeg) Mountain Time (Calgary, Denver, Edmonton) Mountain Time (Phoenix) Pacific Time (Los Angeles, Seattle, Vancouver) Singapore Time Arabic Standard Time (Qatar, Saudi Arabia) Gulf Standard Time (UAE, Oman) Australian Eastern Time (Sydney, Melbourne) Western Australia Time (Perth) New Zealand Time China Standard Time (China, Taiwan, Hong Kong) Scroll right for more details There is no date for this course at this moment. Please complete the BOOKING REQUEST FORM below or come back to this page again later. Note: Online classes are usually delivered through Zoom video conferencing. Price Calculator & Booking Request Form Calculate prices for Corporate, 1-on-1 or group training and request a booking. Do you have a special training requirement or unable to find any suitable training date? Please complete and submit the booking request form, if you want to: book a course on different dates book for a group of delegates book corporate training book a customised training book a one-on-one training The price person is less when you book a course for more people. You can find the price per person and the total cost by changing the values of the training hours and the number of people below: How many hours? How many people? Total Cost Price per person Preferred Dates and Times Any other information
16 February 2021 Guide to Data Synchronization and Why Is It Important Data Synchronization is important as it provides clean and improved data with no duplications, errors, or other bugs.
26 March 2020 How to Create A Killer Company Website And Improve Your Brand An appealing web page is needed to draw in potential readers and to maximise your brand awareness.
05 May 2020 How to Overcome eCommerce Growing Pains The Internet of things (IoT) has revolutionized traditional business models, throwing the global marketplace into a spin. The point is, eCommerce is the trend going forward, and businesses must innovate to grow with it. Here’s how to overcome eCommerce growing pains.
30 August 2024 How to Set Up and Connect to MySQL on a Windows VPS Server from Python: A Step-by-Step Guide Setting up MySQL on a Windows VPS server and connecting to it from a Python application can seem daunting, especially if you're new to these technologies. This guide will walk you through the entire process, including how to handle common issues like authentication plugin errors.
20 October 2020 How To Understand If You Can Work In IT Technology has really evolved over the last few years, making IT one if the most popular employment industries in current time. In this article we will discuss if working in IT will be the best option for you.
17 September 2025 Why SQL is a Must-Have Skill for Every Modern Employee SQL is a critical business skill that empowers employees to access, analyse, and act on data directly, leading to faster, smarter decisions and a more agile, data-driven company culture. This article explains how SQL knowledge across an organisation, from marketing and sales to finance and operations, unlocks faster, deeper insights directly from source data.