Home Accessibility Courses Twitter The Mouth Facebook Resources Site Map About Us Contact
 
Python, Lua and Tcl - public course schedule [here]
Private courses on your site - see [here]
Please ask about maintenance training for Perl, PHP, Java, C, C++, Ruby, MySQL and Linux / Tomcat systems
 

MySQL training news
Next Public Course Dates
 fromfor
Learning to program in Python Mon, 10 Sep 18 5 days
Python Programming Tue, 11 Sep 18 4 days

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]
SUBJECT BACKGROUND
MySQL is a relational database engine. It lets you enter, store and search tables of information. Those tables can "relate" to each other, allowing a complex data set to be stored, and complex searches made. The database engine does all the hard work of storing and formatting the data for you - all you have to do is program the engine using the SQL language.
COURSE CONTENT
Course Summary: [Link]
Introduction to SQL and MySQL (module S151) Information organisations. What is a relational database? What are the parts of a relational database? What relational databases are there? MySQL, MySQL-Max and MySQL-GUI. What is MySQL? Why choose it?
 
Use and Design of a MySQL database
SQL Primer as Used in MySQL (module S152) The structure of a database as seen by MySQL. SQL introduction. "Hello SQL World". Databases, tables, fields, rows and columns. Field types and modifiers. Initial administration and error handling. Commands to enter and edit rows of data - Insert, replace and load. Enquiry (select) commands. Conditional clauses and writing conditions. Command to modify and delete rows. DROP, SHOW and others.
Designing an SQL Database System (module S154) Interfacing an SQL interface to applications. Relational database design. Data normalisation. First, second and third normal forms. Rules for a truly relational database. Password issues and other security matters.
Interfacing Applications to MySQL Databases (module S156) The DBI and DBD Modules (from Perl). Mysql.pm (from Perl). Using MySQL from PHP. JDBC and access to MySQL from Java. Accessing MySQL from a C Program. Connectivity from Tcl. Comparison of MySQL v other SQL engines.
More MySQL commands (module S157) Revision. Complex joins. Left right and straight join. Aliases. Inner and outer joins. Indexes. Unique and regular indexes. Multiple field indexes. Fulltext indexes. Optimising queries. Join order and what to index. Selection efficiency. Transactions. Locking issues. Commit and Rollback.
GUI tools for MySQL (module S158) PHPmyAdmin. mysql-administrator. mysql-query-browser. More on the mysql command line tool.
 
MySQL database Administration and security
Sourcing, Running and Configuring MySQL (module S153) Sources of SQL. The mysqld daemon process. How MySQL fits into your scheme - stand-alone clients. How MySQL fits into your scheme - Web users. The mysqladmin and mysql client programs. Managing user accounts and priviledges. Backing up your database. Table types MyIsam, Isam, Hash, InnoDb and BDB. Accessing mysqld from around your network.
Data Access and Security in MySQL (module S161) The MySQL Security Model. Login accounts, Access Right, Privilege Types. A Straightforward Example. Operating System level security - Ownerships and Permissions. Worked Example - setting up MySQL as an ISP. Configuraton files and command line options. Running multiple daemons on one system through mysqld_multi. MySQL GUIs.
 
Accessin a MySQL database from your applications
Using MySQL Databases in PHP Pages (module H113) Database Structure. Introduction to SQL and MySQL. Principles of database programming from PHP. Creating tables. Adding and changing information. Retrieving information from a table and reporting it to a web page. Deleting tables. Using an alternative database - example Oracle (OCI) calls. Other databases and interfaces such as ODBC, Oracle, postgreSQL and Sybase.
MySQL 5 and PHP 5 (module S159) An overview. MySQL 3 -> 4 -> 5. PHP 3 -> 4 -> 5. The PHP/MySQL driver issue. OLD_PASSWORD. Recongnising problems. Sample code using mysql and mysqli.
JDBC - Relational Database Access (module J811) The JDBC Interface. Driver managers and drivers. Type 1, 2, 3 and 4 drivers. How odbc, jdbc and SQL relate. Obtaining and installing JDBC drivers. Example - a MySQL jdbc driver class. Connection to a database in Java. Running enquiries against a relational database.
Using SQL Databases from Perl (module P308) Review - flat databases. Relational databases through SQL. Setting up the DBI and DBD modules. Connecting to an SQL server. Issuing an enquiry and reading back the results. Amending information in a database via SQL. Creating new tables. Database support including mySQL, Oracle, Sybase, Infomix. Interfacing Perl to the Access database. Using Tie to access a table as if it was a Perl Hash.

TUTOR and COURSE AUTHOR
Graham Ellis - graham@wellho.net [email]  [about Graham]
VENUE
Melksham, Wiltshire
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
£790.00
(£948.00 inc VAT)
Without room
£650.00
(£780.00 inc VAT) 
 With hotel rooms
£1530.00
(£1836.00 inc VAT)
Without rooms
£1250.00
(£1500.00 inc VAT) 
 With hotel rooms
£2270.00
(£2724.00 inc VAT)
Without rooms
£1850.00
(£2220.00 inc VAT) 
 
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., 2018: 404 The Spa • Melksham, Wiltshire • United Kingdom • SN12 6QL
PH: 01225 708225 • EMAIL: info@wellho.net • WEB: http://www.wellho.net • SKYPE: wellho

PAGE: http://www.wellho.net/course/mqfull.html • PAGE BUILT: Thu Apr 5 17:03:17 2018 • BUILD SYSTEM: WomanWithCat