Home Accessibility Courses Twitter The Mouth Facebook Resources Site Map About Us Contact

MySQL training news
Next Public Course Dates
 fromfor
Learning to program in Python Mon, 19 Jan 15 5 days
Python Programming Tue, 20 Jan 15 4 days
Learning to program in PHP Mon, 2 Mar 15 5 days
PHP Programming Tue, 3 Mar 15 4 days
Learning to program in Perl Mon, 9 Mar 15 5 days
Perl Programming Tue, 10 Mar 15 4 days
Learning to program in Ruby Mon, 20 Apr 15 5 days
Ruby Programming Tue, 21 Apr 15 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. Plain files. Directory structure. Table. Relational database. Relational databases. The structure of a typical RDBMS. Accessing a relational database from the Web. Database access protocols. SQL. MySQL. Distributions and licenses. Component parts of MySQL. Versions of MySQL. Production Version. Development Version. MySQL- Max. When should I choose MySQL?.
 
Use and Design of a MySQL database
SQL Primer as Used in MySQL (module S152) The structure of a database as seen by SQL. SQL introduction. Hello SQL World. Initial administration and error handling. Field types and modifiers in MySQL. Floating point (real) numbers. Whole (Integer) numbers. Text Strings. One or more values from a pre-defined list. Dates and Times. Blobs. Other Modifiers. Example. Indexes. Other matters. A note on reserved words. Commands to enter new rows of data. The INSERT command. The REPLACE command. The LOAD command. Enquiry commands. Conditional Clauses. Returning table report information. Commands to modify existing rows of data. The UPDATE command. The DELETE command. Commands to modify the metadata. The ALTER Command. The DROP command. Other commands. The SHOW command. On limiting selection. Joining tables when selecting rows. Extra use of SELECT. Other commands. Some more advanced SQL. Loading data from file. More on joining. A regular "join". A left join. Joining across databases?.
Designing an SQL Database System (module S154) Interfacing an SQL database to applications. Interfacing to SQL via PHP. Other Clients. Relational database design. Database normalisation. Principles of a relational database. Codd’s Rules for a Truly Relational Database System. Hiding passwords in client programs.
Interfacing Applications to MySQL Databases (module S156) Interfacing MySQL to Perl. The Perl program in detail. A Further Example. Interfacing MySQL to PHP. Interfacing MySQL to Java. Interfacing MySQL to Tcl/Tk. Interfacing MySQL to C. When should I choose MySQL?. Brief comparisons. Limitations of MySQL, and work-arounds. subselects. transactions and commit/rollback. Foreign keys and referential Integrity. Stored procedures and triggers. Views. Record level privileges and locking. Why are the limitations not always limitations?.
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) Overview. A potted installation procedure. For use on our training systems. Installing MySQL onto your laptop. Install the Perl DBD and DBI modules. Testing your Installation. Running the MySQL daemon. Programs for the user and administrator. Using the mysqladmin program. Using the mysql client program. Managing user accounts and privileges. Adding an account. Adding Additional privileges on a per-database basis. Additional access on a per-host, per table and per-column basis. mysqlaccess. Configuring MySQL. Server configuration. Client configuration. Disk structure of data held in a MySQL database. The data directory. Database subdirectories. Table Types. Setting up security and levels of access. O/S level and web-level access. Log in access to MySQL. Four levels of access within MySQL. Backing up your database. Dumping by table. Accessing mysqld from around your network.
Data Access and Security in MySQL (module S161) Introduction to the MySQL security model. MySQL login accounts. Access rights. Privilege types. A straightforward example. A private database for each of a group of users. Operating system security. Ownership of the mysqld process. File ownerships and permissions. MySQL configuration files, command line options. Order of file selection. File format. Command line options. Running multiple servers on one system. Basic first setup - example. mysqld_multi. MySQL GUIs.
 
Accessin a MySQL database from your applications
Using MySQL Databases in PHP Pages (module H113) Database structure. How to create a new table. Adding information to a table. Selecting information from a table and reporting it to a web page. Deleting a table. User input checking and other testing. Example: A PHP script to select and view the data in any table. Downloading all the tables from a database. Uploading tables from a flat text file. Using other relational databases from PHP. Using Oracle 8.x and 9.x. Using the Oracle OCI9 API. Portable database connection.
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) Interfacing MySQL to Java. Using JDBC to access other databases. Using JDBC on the Web. Example: Managing a table of information about a population. Example: A more general table management Servlet. Enhancing our examples.
Using SQL Databases from Perl (module P308) Flat databases. Relational databases through SQL - Setup. Checking that your relational database is available. Installing the database independent module (DBI). Install the Database Dependent drivers for MySQL. Using DBI to access a MySQL database. A further example. Other databases.

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
$1180.00
($1416.00 inc VAT) or
£720.00
(£864.00 inc VAT)
Without room
$1000.00
($1200.00 inc VAT) or
£600.00
(£720.00 inc VAT) 
 With hotel rooms
$2260.00
($2712.00 inc VAT) or
£1340.00
(£1608.00 inc VAT)
Without rooms
$1900.00
($2280.00 inc VAT) or
£1100.00
(£1320.00 inc VAT) 
 With hotel rooms
$3340.00
($4008.00 inc VAT) or
£1960.00
(£2352.00 inc VAT)
Without rooms
$2800.00
($3360.00 inc VAT) or
£1600.00
(£1920.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., 2014: Well House Manor • 48 Spa Road • Melksham, Wiltshire • United Kingdom • SN12 7NY
PH: 01144 1225 708225 • FAX: 01144 1225 899360 • EMAIL: info@wellho.net • WEB: http://www.wellho.net • SKYPE: wellho

PAGE: http://www.wellho.net/course/mqfull.html • PAGE BUILT: Thu Nov 13 11:24:52 2014 • BUILD SYSTEM: WomanWithCat