Book Now Enquire Our Venue

Course Rating

Out of 18 verified reviews

Recent Feedback

"The trainer's comprehensive coverage of MySQL's fundamentals, from creating databases to writing complex queries, was fantastic."

Susan, Production Assistant

"The trainer explained SQL queries and database optimisation in a clear manner. The course materials were helpful, and I appreciated the emphasis on real-world applications."

Gregory, Account Manager

"The practical exercises and real-world scenarios provided valuable insights. I now feel more confident working with MySQL databases."

Arnold, Operations Analyst

"The trainer's explanations were beginner-friendly, and the course provided a solid foundation for working with MySQL."

Mirko, Logistics Coordinator

Price £195 (no VAT) Duration 1 Day Venue Llynfi Enterprise Centre, Bridgend County, CF34 0BQ

Course Overview - MySQL Coding

MySQL is a powerful, database design and development tool that has become the most significant part of the database market. This course has been designed to teach delegates to quickly learn MySQL. You will learn about developing relational databases through SQL and how to manipulate data and build queries that communicate with more than one table.

This practical introduction to SQL training course is for those who need to be competent extracting data from, and updating data in, relational database servers like Microsoft SQL Server, Oracle, IBM DB2, PostgreSQL and MySQL using ANSI standard Structured Query Language (SQL). In order to master the syntax of the language, the course is highly practical in nature - attendees learn by doing. The focus throughout is on coding SQL by hand. On completion, a comprehensive set of course notes, examples, trainer and attendee scripts are made available online for each attendee.

Available Course Dates 2024/25 - MySQL Coding

December 2024: Fully Booked

January 2025: 6th, 20th, 21st, 27th, 28th

February 2025: 3rd, 4th, 10th, 17th, 18th, 24th, 25th

March 2025: 3rd, 4th, 10th, 11th, 17th, 18th, 24th, 25th, 31st

April 2025: 1st, 7th, 8th, 14th, 15th, 22nd, 28th, 29th

May 2025: 6th, 12th, 13th, 19th, 20th, 27th

June 2025: 2nd, 3rd, 9th, 10th, 16th, 17th, 23rd, 24th, 30th

Course Content - MySQL Coding

Introducing SQL

• Creating and editing SQL
• About statements, batches and scripts
• Executing and parsing SQL scripts
• Using comments
• About keywords, identifiers, operators, whitespace and case
• SQL conventions and good practice
• Working to minimise, trap and find errors

Who is this course for?

We live in a data-driven world: people search through data to find insights to inform strategy, marketing and operations, and a plethora of other categories. Being able to code using SQL a great employable skill for the IT sector.