JBI training course London UK
Search image
Exceptional training for MySQL developers

MySQL Developer Training Course

Quickly Build Enterprise Backend Applications Using MySQL - Reduce Development Costs

NEXT COURSE
16 Sep London
Book
request info

Capita Marks and Spencer Telefonica Cisco BBC Lloyds Sony
MySQL Administration
PHP with MySQL
MySQL Developer training course (code: MYSQLDEV)

TRAINING COURSE OVERVIEW

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.

AUDIENCE

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

CONTENT

DETAILHIGHLIGHTS

Show more | Show less
  • 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
  • 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

UPDATES
Receive the latest version of this course into your inbox



FEEDBACK

"At jbi even the sales team are technical so you are able to ask questions before the course"

Garima Aon

Blog (Show All)

JBI training course London UK

Agile & Scrum Training for a major UK Bank

31/07/2018: Example programmes delivered: Professional Scrum Master PSM I Agile and Scrum These are 2 day courses which focus on understanding the agile/scrum...


JBI training course London UK

React Training Course for Experienced Javascript Developers

05/07/2018: This Client asked JBI to run an intensive ReactJS course for Developers who were already familiar with Javascript, CSS and some of whom may have...


JBI training course London UK

Onsite Training Assignment for Agile/Scrum

10/02/2018: A leading Financial institution commissioned JBI to run a series of Agile/Scrum courses for various teams - inhouse. Pre-course consultation...


Case Studies (Show All)

JBI training course London UK

Why Highly Skilled Trainers Are So Important

09/09/2019: p.p1 {margin: 0.0px 0.0px 3.0px 0.0px; font: 26.0px Arial; -webkit-text-stroke: #000000} p.p2 {margin: 0.0px 0.0px 0.0px 0.0px; font: 11.0px...


JBI training course London UK

AI & ML – Hype or reality?

02/09/2019: One of the exciting things about modern technology is that the hype often becomes reality – and that could be the case with Artificial Intelligence....


JBI training course London UK

Our Micro FrontEnds Training Course

02/09/2019: p.p1 {margin: 0.0px 0.0px 0.0px 0.0px; font: 11.0px Arial; -webkit-text-stroke: #000000} p.p2 {margin: 0.0px 0.0px 0.0px 0.0px; font: 11.0px...


LONDON COURSES
- INCLUDES LUNCH -

16th Sep 2019 - 5 days £1995
Book

see all dates


X

Show Discount for this course


PRIVATE COURSES


  Bring a JBI course to your office
  and train a whole team onsite
  0800 028 6400 or request quote


  You can customise this course to
  suit your exact needs here
  0800 028 6400 or request quote

Customise

CONTACT
0800 028 6400



RELATED COURSES

MySQL Administration
PHP with MySQL

Show all related courses
Related courses
View Case Studies    View Insights

Why JBI ?

►"great technology tips"
► "Access to exclusive content"
► "Short course means less time off"

►"Inspiring trainers"
► "Joined via web"
► "Knowledgable sales staff"

NEWSLETTER
Get exclusive news about upcoming programs, technical insights & special offers