| |
 |
 |
|
 MySQL is suitable for new
and established employees, individually or in groups,
at home or in the organization. Meeting the highest e-learning
instructional design standards, MySQL
- is modular
- includes objectives and summaries, topic questions,
web resources, and scored testing
- is graphically illustrated
- is easily navigable
- allows bookmarking within the current session
- is accessible to English first and second-language
speakers
- costs only $49.00 (Single User License)
Table of Contents
|
Module
|
Content
|
Topic
|
|
MySQL foundations
|
Module aim and objectives
|
|
|
|
Database design
|
• Defining databases
• Databases and the Web
|
|
|
Introducing MySQL
|
• The nature of
MySQL
• MySQL and mSQL
• MySQL and SQL
|
|
|
Module summary
|
|
|
|
Module test
|
|
|
Using MySQL
|
Module aim and objectives
|
|
|
|
Installation and configuration
|
• Pre-installation
tasks for a
MySQL installation
• Installing MySQL on a UNIX
computer
• Installing MySQL on a Windows
computer
|
|
|
Database creation
|
• Connecting to
and
disconnecting from a server
using MySQL
• Searching the server for a
database and for information
on a database
• Creating a database
• Creating a table in a database
|
|
|
Creating a database
|
• Creating a database
(exercise)
|
|
|
Module summary
|
|
|
|
Module test
|
|
| Tables |
Module
aim and objectives |
|
|
Organizing tables |
•
Loading, selecting, and sorting
data
• Loading data into a table
• Selecting data from a table
• Sorting information in a table |
|
Calculations
and functions |
• Date
calculations, pattern
matching, and row counting
• Performing simple date
calculations
• Pattern matching
• Row counting
• Using more than one table |
|
Using
tables |
•
Using a table
• Using two tables |
|
Module
summary |
|
|
|
Module test
|
|
PHP
- Contents
PHP and MySQL
on the Web - Contents
|  |
|
 |
| Order
| Back
| Home | Top | Login |
|
|
