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.
The structure of a typical RDBMS.
Accessing a relational database from the Web.
Database access protocols.
Distributions and licenses.
Component parts of MySQL.
Versions of MySQL.
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.
Hello SQL World.
Initial administration and error handling.
Field types and modifiers in MySQL.
Floating point (real) numbers.
Whole (Integer) numbers.
One or more values from a pre-defined list.
Dates and Times.
A note on reserved words.
Commands to enter new rows of data.
The INSERT command.
The REPLACE command.
The LOAD command.
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.
The SHOW command.
On limiting selection.
Joining tables when selecting rows.
Extra use of SELECT.
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.
Relational database design.
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?.
Limitations of MySQL, and work-arounds.
transactions and commit/rollback.
Foreign keys and referential Integrity.
Stored procedures and triggers.
Record level privileges and locking.
Why are the limitations not always limitations?.
|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) 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.
Disk structure of data held in a MySQL database.
The data directory.
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.
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.
Command line options.
Running multiple servers on one system.
Basic first setup - example.
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.
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.
TUTOR and COURSE AUTHOR
Graham Ellis - firstname.lastname@example.org
] [about Graham
, England. A taxi transfer can be arranged if you'll be arriving by air
from United States.
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
• 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
($1464.00 inc VAT) or
(£888.00 inc VAT)
($1200.00 inc VAT) or
(£720.00 inc VAT)
| With hotel rooms
($2808.00 inc VAT) or
(£1656.00 inc VAT)
($2280.00 inc VAT) or
(£1320.00 inc VAT)
| With hotel rooms
($4152.00 inc VAT) or
(£2424.00 inc VAT)
($3360.00 inc VAT) or
(£1920.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.