PRODUCT INFO
 
Shipping Information
Product Guarantee
Testimonials
 
MAIN LINKS
 
Training Categories
New Titles
In Development
Free Online Demos
Multi User Training CDs
Contact Us
 


This Week's Special Offer

NEW TITLE DISCOUNT!
Adobe Photoshop CS5 Tutorial


Quicktime is required for the movies,
click here to download if needed.

Please Note: The online FREE lessons have been compressed for faster downloads. Purchased CD ROMs/DVDs load almost instantly and have higher sound and video quality.

Please allow a few seconds for the FREE online tutorials to load. If you have any difficulties downloading these FREE online tutorials. Please do not hesitate to contact us for download help.

MySQL Tutorial
 Professionally created, self-study video training.

About this Tutorialshow details
This beginners MySQL tutorial is ideal if you want to design and develop database management systems. Presented using step by step video training movies, expert author Joshua Mustafa commences with the basics of SQL and databases and then smoothly moves on to the more advanced techniques and concepts. You can sample this highly effective training method right now, click any of the blue linked lessons below for FREE MySQL video training movies...
Learn this Software - See below for FREE TUTORIALS
LATER VERSION AVAILABLE
We also have the
PHP & MySQL Tutorial
(released summer 2010)


Each Course on 1 or 2 CDs
For Mac and PC

FREE Shipping on all Orders


MySQL Tutorial Info

CLICK HERE TO BUY THIS CD
Tutor: Joshua Mostafa
Duration: 8 hrs / 71 video lessons
Cost for UK: £79.95 + VAT
Cost for EU: €84.95 + VAT
Cost for US & Canada: $124.95
Product Code: 33364
Delivery: Please allow 2-3 days for UK & Europe, 3-5 days US & rest of world

IN STOCK

- All CDs Shipped Carriage FREE -
Compatibility: MS Windows 7, Vista, XP, 2000, 98, NT, Mac OS X, OS 9
 

Don't take our word for it, see our Customer Testimonials


Benefits of this Software Training
  Tuition by expert tutors.
  Narrated training videos demonstrate the key tools and professional techniques helping you to work faster and smarter.
  Learning is fast as the trainers guide you using simplistic terms and minimal jargon.
  Personal Tutoring - Step-by-step video training from your own desktop. Delivered via DVD/CD training or online tuition.
  The tutor transfers knowledge to you quickly and effectively.
  All the concepts of each application are explained clearly and precisely.
  Every course works on PC and Mac.
  Alternative to a boring book or manual and expensive training courses, seminars & classes.
  Jump to and from lessons - learn at your own pace.
  The visual and practical nature shortens the learning curve compared to standard training manuals.
Customer Testimonials
Associated Training CDs:
Microsoft ASP.NET 3.5 | Complete Range of Advanced Dreamweaver Tutorials | Microsoft SQL Server 2008 Development | PHP | Perl | LAMP | Complete Range of MYSQL & PHP Video Tutorials | Complete Range of Microsoft SQL Server Tutorials | Crystal Reports XI
 
CD CONTENTS & FREE VIDEO TUTORIALS
Click on any linked lesson below for a FREE demo
Purchased CD tutorials load almost instantly and have higher sound & video quality. For tutorial support see left

Getting Started
MySQL Tutorial Overview
What You'll Need

Database Basics
A Database Description
RDBMSs
Tables and Data - basic
Tables and Data - further info

SQL Basics
'Finding Your Feet'
The Creation of a Database
The Creation of a Table
Column Types-String - Lesson 1
Column Types-String - Lesson 2
Column Types-Numeric - Lesson 1
Column Types-Numeric - Lesson 2
How to retrieve Data With Search Criteria
Change Existing Data
How to Alter A Table
Keys & Indexes Explained
Syntax Basics Recap

We hope you enjoyed the FREE lessons above. To view the complete contents, including ALL the lessons below, please purchase the CD.
CLICK HERE TO BUY THIS CD

Operators
Arithmetic Operators
Numeric and string Comparison Operators
Logical and Bitwise Operators
Regular Expressions - Lesson 1
Regular Expressions - Lesson 2
Regular Expressions - Lesson 3
Operators Syntax Recall

Querying Your Data in MySQL
How to Sort Retrieved Data
Specifying Numbers of Results
Joining Tables - Lesson 1
Joining Tables - Lesson 2
Joining Tables - Lesson 3
Data Aggregation Explained
Queries Syntax Recall

More Complex SQL
Using Default Data Overview
Date & Time - Lesson 1
Date & Time - Lesson 2
Date & Time - Lesson 3
ENUM column type
SET column type - Lesson 1
SET column type - Lesson 2
Using Variables Overview
Conditional: IF()
Complex Syntax Recall

Good Practices
Using SQL batch files - Lesson 1
Using SQL batch files - Lesson 2
Data Modeling - Lesson 1
Data Modeling - Lesson 2
Normalization in MySQL - Lesson 1
Normalization in MySQL - Lesson 2
Optimisations Overview

Security
Users and Privileges in MySQL
Further Users And Privileges
MySQL Database - Lesson 1
MySQL Database - Lesson 2
Encryption Explored
Security Syntax Recall

Constructing A Database Application in MySQL
How to Plan The Structure
Designing The Database - Lesson 1
Designing The Database - Lesson 2
The Creation of The Database - Lesson 1
The Creation of The Database - Lesson 2
Logging In And Out
Checking Videos In And Out - Lesson 1
Checking Videos In And Out - Lesson 2
How to Search For A Video
How to Add A New Title
Signing Up A New Customer
Hiring And Firing Employees - Lesson 1
Hiring And Firing Employees - Lesson 2
Listing Debtors

CLICK HERE TO BUY THIS CD


  UK & Europe
Marrutt Software Training
Bellbrook Industrial Estate
Uckfield, East Sussex, TN22 1QL
United Kingdom
UK Tel: +44 (0) 1825 764057
UK Fax: +44 (0) 1825 768841

  US & Canada
Marrutt Software Training
244 5th Ave # 1877
New York, NY 10001
United States
US Tel: 646-736-7932
US Fax: 646-895-7649