Exceptional training for MySQL developers

MySQL Developer Training Course

Quickly Build Enterprise Backend Applications Using MySQL - Reduce Development Costs

NEXT COURSE
5 Aug London
request info

Capita Marks and Spencer Telefonica Cisco BBC Lloyds Sony

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

  • 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



LONDON COURSES
- INCLUDES LUNCH -

5th Aug 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


CONTACT
0800 028 6400



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