EXCEPTIONAL TRAINING COURSES FOR IT PROFESSIONALS
LONDON UK | ONSITE | ONLINE


MySQL Developer Training Course


Capita Marks and Spencer Telefonica Cisco BBC Lloyds Sony

MySQL Developer training course (code: MYSQLDEV)

Quickly Build Enterprise Backend Applications Using MySQL - Reduce Development Costs


SEE MORE COURSES IN THIS CATEGORY

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.



DETAILHIGHLIGHTS

  • 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
Receive the latest version of this course into your inbox


See why people choose JBI

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

Garima Aon

Call our Tech Team :  0800 028 6400  request info



PUBLIC COURSES (LONDON, UK)
 

18th Sep 2017 - 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


 

 

 

 

Get in touch
0800 028 6400




 

 

view all case studies

 

 

Our inspiring and up-to-date courses gain exceptional feedback

►"great tips to help reduce build times"
► "we got access to exclusive content"
► "intensive course meant less time off"

►"what an inspiring trainer !"
► "colleagues at 2 sites joined via web"
► "I passed my exam the next day"

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