Back end MySQL tutorials and training courses on CD or via the online university. Learn all about using, designing and building a full scale robust database, watch these online MySQL tutorials and the PHP training course and find out all you need to know.

PHP MySQL tutorials and training courses

Please select your country

Online Adobe Photoshop CS Tutorials
Macromedia Dreamweaver Training and Tutorials

			PHP MySQL tutorials

MySQL Tutorials

MySQL Tutorials
Author Name		Jonathan Kagi
Total Movies		122
ISBN		1930519664
Duration		9.5 Hours

Try before you buy

Click on any movie link in the first 3 chapters, to watch a free demo

To allow faster streaming over the web the sound and video quality has been reduced, this ensures faster download

The quality of the movies on the CDs is much better.

Please ensure that you have downloaded and installed the Apple QuickTime Plugin if needed, this is required to play the tutorial movies. If you are experiencing any problems please contact tech support . All our CD Tutorials and Online Moives are produced by expert authors and trainers, we try to design the content to represents problems that you would encounter in a real work environment. As a customer we value your comments and depend on your feed back to improve our products

In this MySQL tutorial you will learn all about designing and developing database management systems using this open source software, when combined with PHP it can preform very fast data searches. Learn all the standard commands like Drop, Select, like, use, and many more. This backend solution can hold large amounts of data, using these MySQL tutorials you will soon understand how to go about designing and building a full scale backend data mangement system. You may also like to view the PHP training course

This training course is designed for fast learning and covers all the fundamental points of the application, all cds work on a mac or pc and no application is needed.

The links below are free MySQL tutorials. The entire contents may be purchased either on CD or watched via the Online University

Getting Started
Welcome
What You'll Need

Database Basics
What Is A Database?
RDBMSs
Tables and Data

SQL Basics
Finding Your Way About
Creating a Database
Creating a Table
Column Types-String
Column Types-Numeric
Retrieving Data With Search Criteria
Changing Existing Data
Altering A Table
Keys And Indexes
Basics Syntax Recap

Operators in MySQL
Arithmetic Operators
Numeric Comparison Operators
String Comparison Operators
Logical Operators
Bitwise Operators
Regular Expressions 1
Regular Expressions 2
Operators Syntax Recap

Querying Your Data
Sorting Retrieved Data
Specifying Numbers of Results
Joining Tables
More On Joining Tables
Data Aggregation
Queries Syntax Recap

More Complex SQL
Using Default Data
Date And Time 1
Date And Time 2
ENUM column type
SET column type
Using Variables
Conditional: IF()
Complex Syntax Recap

Good Practises
Using SQL batch files
Data Modeling
Normalization
Optimizations

Security
Users And Privileges
More About Users And Privileges
The 'mysql' Database
Encryption
Security Syntax Recap

Building A Database Application
Planning The Structure
Designing The Database
Creating The Database
Logging In And Out
Checking Videos In And Out
Searching For A Video
Adding A New Title
Signing Up A New Customer
Hiring And Firing Employees
Listing Debtors

Dreamweaver Tutorials Photoshop Tutorials Adobe Indesign Tutorials Illustrator Tutorials Emagic Logic Audio 6 Tutorials Adobe After Effects 5.5 tutorials Macromedia Flash Tutorials Filemaker Tutorials 3D Studio Max Oracle SQL PL/SQL Adobe Acrobat Final Cut Pro QuarkXpress Microsoft Frontpage PageMaker Macromedia Freehand Painter Tutorials

Internet and Web Design

All our titles play on PC or Mac, the application does not need to be installed on the system for our program to be used. Our products are being used in distance learning applications by large companies, Banks, Schools, Colleges and Universites. To get the best out of our product you may wish to down load the movie / video player, Apple QuickTime is also required. Online Tutorials and training courses