Home Accessibility Courses Twitter The Mouth Facebook Resources Site Map About Us Contact
 
NEW SERVER - 11.9.2020 ... Retiring, March 2020 - sorry, you have missed our final public course.
The Coronavirus situation has lead us to suspend public training - which was on the cards anyway, with no plans to resume

Please ask about private 'maintenance' training for Python, Tcl, Perl, PHP, Lua, etc
Happily continuing private consultancy / programming work
 

MySQL training news
Next Public Course Dates
 fromfor

Link on individual courses for more details and further dates.

We can also run a private tailored course at our centre or a private course at your office.
Structure, Installation, Administration, Database Design and Programming through SQL

This course has been withdrawn

DESCRIPTION
This course introduces you to the world of SQL database engines, and MySQL in particular - the component parts of the SQL system and how they interact. We study the SQL language (learning the MySQL flavour) and how it's used from PHP, Perl, Python and Java. We study administration of MySQL including user account and security controls, and we study database design so that you'll be putting together well thought-out, maintainable, expandible databases when you've concluded this course.
PREREQUISITES
You can learn about MySQL with just basic computer knowledge, but if you'll be writing programs in Perl, PHP or Java to interface to SQL, you might need to attend an appropriate language course such as Perl Programming, PHP Programming or Java Programming for the Web first.

Getting the most from your Well House Consultants course [Link]
COURSE CONTENT
Detailed description: [Link]
Introduction to SQL and MySQL (module S151)
 
Use and Design of a MySQL database
SQL Primer as Used in MySQL (module S152)
Designing an SQL Database System (module S154)
Interfacing Applications to MySQL Databases (module S156)
More MySQL commands (module S157)
GUI tools for MySQL (module S158)
 
MySQL database Administration and security
Sourcing, Running and Configuring MySQL (module S153)
Data Access and Security in MySQL (module S161)
 
Accessin a MySQL database from your applications
Using MySQL Databases in PHP Pages (module H113)
MySQL 5 and PHP 5 (module S159)
JDBC - Relational Database Access (module J811)
Using SQL Databases from Perl (module P308)

TUTOR and COURSE AUTHOR
Graham Ellis - graham@wellho.net [email]  [about Graham]
VENUE
Melksham, Wiltshire , England. A taxi transfer can be arranged if you'll be arriving by air from United States. Private Courses can be arranged on site in your country.
Public courses run at Well House Manor - our own purpose fitted training centre and business hotel / conference centre in Melksham.
• Download Melksham Map - [pdf file (750k)] • Google Map - [Link]
PRICE
1 student   2 students   3 students   For 4 or more students
from the same company,
please consider a private course.
 With hotel room
$1270.00
($1524.00 inc VAT) or
£790.00 (No VAT from 1.2019)
Without room
$1050.00
($1260.00 inc VAT) or
£650.00 (No VAT from 1.2019) 
 With hotel rooms
$2490.00
($2988.00 inc VAT) or
£1530.00 (No VAT from 1.2019)
Without rooms
$2050.00
($2460.00 inc VAT) or
£1250.00 (No VAT from 1.2019) 
 With hotel rooms
$3710.00
($4452.00 inc VAT) or
£2270.00 (No VAT from 1.2019)
Without rooms
$3050.00
($3660.00 inc VAT) or
£1850.00 (No VAT from 1.2019) 
 
Notes:
• Multiple discount applies to bookings for second and subsequent delegates on the same running of a course, and on same order.
• Hotel rooms are available for arrival the night before the course starts, for departure after the end of the course on the last day.
FOLLOW UPS
Upon completion of your course, you'll have online access to the source code of all the examples from the course, and you'll have access to the "Ask the Tutor" forum where you can raise questions. We also encourage you to email the tutor, and to visit us again to use our library as appropriate.

Certification? - [Link]
FOR FURTHER INFORMATION
Public (scheduled) courses -- http://www.wellho.net/course/ctc.html
For more information about our public courses in general, such as class size, course times, materials provided, special requests, accommodation list, finding our centre, etc.
Terms and Conditions -- http://www.wellho.net/net/terms.html
Covering topics such as delegate substitution, payment, cancellation policy and other matters.

You can Add a comment or ranking to this page

© WELL HOUSE CONSULTANTS LTD., 2021: 48 Spa Road • Melksham, Wiltshire • United Kingdom • SN12 7NY
PH: 01144 1225 708225 • EMAIL: info@wellho.net • WEB: http://www.wellho.net • SKYPE: wellho

PAGE: http://www.wellho.net/course/mqfull.html • PAGE BUILT: Sun Oct 11 13:25:59 2020 • BUILD SYSTEM: JelliaJamb