Structure, Installation, Administration, Database Design and Programming through SQL
This course has been withdrawn
This course introduces you to the world of
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.
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
Getting the most from your Well House Consultants course
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.
|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.
"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.
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.
Left right and straight join.
Inner and outer joins.
Unique and regular indexes.
Multiple field indexes.
Join order and what to index.
Commit and Rollback.
|GUI tools for MySQL (module S158) PHPmyAdmin.
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.
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.
Adding and changing information.
Retrieving information from a table and reporting it to a web page.
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.
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 - firstname.lastname@example.org
] [about Graham
Public courses run at
Well House Manor
- our own
purpose fitted training centre and business hotel / conference centre in
• Download Melksham Map - [pdf file (750k)
] • Google Map - [Link
|| 2 students
|| 3 students
|| For 4 or more students
from the same company,
please consider a private course.
| With hotel room
(£948.00 inc VAT)
(£780.00 inc VAT)
| With hotel rooms
(£1836.00 inc VAT)
(£1500.00 inc VAT)
| With hotel rooms
(£2724.00 inc VAT)
(£2220.00 inc VAT)
• 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.
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
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
Covering topics such as delegate substitution, payment, cancellation policy and other matters.