MySQL Developer training course

Quickly Build Enterprise Backend Applications Using MySQL - Reduce Development Costs

"Our tailored course provided a well rounded introduction and also covered some intermediate level topics that we needed to know. Clive gave us some best practice ideas and tips to take away. Fast paced but the instructor never lost any of the delegates"

Brian Leek, Data Analyst, May 2022

Public Courses

23/09/24 - 5 days

£1995 +VAT

Enrol

04/11/24 - 5 days

£1995 +VAT

Enrol

16/12/24 - 5 days

£1995 +VAT

Enrol

Customised Courses

* Train a team
* Tailor content
* Flex dates

From £1200 / day

Highlights Details Audience Feedback Prices/Dates

Public Courses

Highlights

Describe the MySQL client/server architecture
Create tables appropriate for your data
Troubleshoot errors and warnings
We’ll look at creating and editing database
Creating and working with tables
Normalize tables
Connecting to databases using Java / PHP
How to work with data types and expression
Getting meta data (information on data)
Manipulating data
Using Primary, Foreign Keys and Indexes to optimise data
Joins and Subqueries to get data from more than one table
Creating views to help work with your data
Prepared statements and triggers
Programming with stored routines
Optimising data and dealing with errors

Course Details

Describe the MySQL client/server architecture
Create tables appropriate for your data
Troubleshoot errors and warnings
We’ll look at creating and editing database
Creating and working with tables
Normalize tables
Connecting to databases using Java / PHP
How to work with data types and expression
Getting meta data (information on data)
Manipulating data
Using Primary, Foreign Keys and Indexes to optimise data
Joins and Subqueries to get data from more than one table
Creating views to help work with your data
Prepared statements and triggers
Programming with stored routines
Optimising data and dealing with errors

Who should attend

Developers who wish to know how to develop commercial MySQL database applications.

Feedback

4.8 out of 5 average

Brian Leek, Data Analyst, May 2022

“JBI did a great job of customizing their syllabus to suit our business needs and also bringing our team up to speed on the current best practices. Our teams varied widely in terms of experience and the Instructor handled this particularly well - very impressive”

Brian F, Team Lead, RBS, Data Analysis Course, 20 April 2022

MySQL Administration

Top 20 "Pain Points" for Data Analysts

Problem 11 : You have a very complex Excel spreadsheet and you want to reproduce EXACTLY the same spreadsheet in Power BI
Solution: Power BI is not Excel, it works differently and it has different strengths. In order to tackle this issue the best way is going back to the source and try to...

All 20 points are in our latest Newsletter - Delivered directly to your inbox

More about this course

JBI's MySQL training course looks at covering everything a Developer would need to know - from setting up a MySQL server on a host, to extracting data from multiple tables using joins and subqueries. Maybe you’re wondering how to optimise your SQL statements and indexes, we cover this as well.