PRODUCT INFO

Product Guarantee

Testimonials

MAIN LINKS

Multi User Training CDs

	This Week's Special Offer NEW TITLE DISCOUNT!
Adobe Photoshop Elements 10 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.

Beginners MySQL 5 Tutorial

Professionally created, self-study video training.

About this Tutorial

show details

This beginners MySQL 5 tutorial is ideal if you want to design and develop database management systems. Presented using step-by-step video training movies, expert tutor David Swain commences with the basics of SQL and databases and then smoothly moves on to the more advanced techniques and concepts. In over eleven hours of professionally created video training movies, the tuition includes the basics of databases, lessons on MySQL configuration, how to query SQL data, exporting data step-by-step, server information and so much more. You can sample this highly effective training method right now, click any of the blue linked lessons below for FREE MySQL video training movies and see just how effective this teaching method really is...

hide details

Learn this Software - See below for FREE TUTORIALS

LATER VERSION AVAILABLE

We also have the
PHP & MySQL Tutorial

Each Course on 1 or 2 CDs
For Mac and PC

FREE Shipping on ALL Orders

MySQL 5 Tutorial Info
	CLICK HERE TO BUY THIS CD
Tutor: David Swain
Duration: 11 hrs / 129 video lessons
Cost for UK: £79.95 + VAT
Cost for EU: €84.95 + VAT
Cost for US & Canada: $124.95
Product Code: 34225
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 provide a beginners guide 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, workshops & 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 and for dummies books.
Customer Testimonials

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

Introduction

Welcome

What This Course Will Cover

System Requirements

A Brief History of MySQL

Help on the MySQL Web Site

Online Manual Demonstration - Lesson 1

Online Manual Demonstration - Lesson 2

Database Basics

Definitions

Client/Server Systems

Tables/Columns/Rows

Database Design in a Nutshell

Indexes

Databases in MySQL

Installation

Installation Basics

Windows

Mac OS X

Linux

What We Installed

Starting and Stopping MySQL

We hope you enjoyed the FREE lessons above. To view the complete contents, including ALL the lessons below and above, please purchase the CD.

CLICK HERE TO BUY THIS CD

Configuration
MySQL Server Configuration
Server Startup Options
MySQL Configuration File
Important Configuration Options

Client Programs
Command Line Operations
Using a Command Line Client
Command Line Client Help File
MySQL Client Batch Mode
MySQL Client Interactive Mode - Lesson 1
MySQL Client Interactive Mode - Lesson 2
MySQL Client Interactive Mode - Lesson 3
Executing Scripts
Exploring Databases and Tables

SELECT Statement Basics
SELECT Arithmetic
Selecting More Than One Column
Operators and Functions
Column Aliases
NULL
Data Type Basics

Variables
What is a Variable?
User Variables
Assignment Operator
SET Statement
System Variables
Variable Scope

Calculations and Expressions
New Values From Old
Operators and Operands
Arithmetic Operators
String Operators
Comparison Operators
Logical Operators
Order of Precedence
Functions and Parameters
Useful Numeric Functions
Useful Character String Functions
Temporal Operations
Useful Temporal Functions
Decision-Making Functions
NULL-Related Functions
Useful System Functions

Querying SQL Data
Using a Database
Selecting FROM a Table
Targeting Rows Using WHERE
Complex WHERE Criteria
Sorting Results Using ORDER BY
Going to Extremes Using LIMIT
Avoiding Duplicates Using DISTINCT
Aggregation Queries
Subtotals Using GROUP BY
Filter Derived Columns with HAVING
Multilevel Sums Using WITH ROLLUP
Summarizing SELECT Clauses
Some Clauses Cannot Coexist

Databases and Tables
Databases in MySQL
Creating a Database
Aspects of a Table
Creating a Table
Table Options
Column Options
Auto-Incrementation
Altering a Table
Adding and Dropping Columns
Altering a Column
MySQL Lessons - Dropping a Table
MySQL Lessons - Dropping a Database

Data Type Details
Data Type Categories
Integer Numbers
Floating Point Numbers
Fixed Decimal Numbers
BIT Data Type
Strings
Basic Character Strings
ENUM Character Strings
SET Character Strings
Character Sets
Collations
Fonts and Keystroke Mapping
Binary Strings
Temporal Data
Timestamp and Time Types

Storage Engines
Storage Engine Basics
Discovering Storage Engines
MyISAM
InnoDB
Memory
Example
CSV
Archive
Federated
Blackhole
Third Party Engines

Exporting Data
Basic Export Concepts
Exporting Using SQL Commands - Lesson 1
Exporting Using SQL Commands - Lesson 2
Exporting on the Shell Command Line
Using MySQLDUMP for Scripts
Using MySQLDUMP for Exporting

Prepared Statements
Prepared Statement Basics
Prepared Statement Demonstration
Commands That Can Be Prepared
When to Use Them

Server Information
Metadata
SHOW Commands
DESCRIBE Command
MySQLSHOW Command Line Client
Information_Schema Database - Lesson 1
Information_Schema Database - Lesson 2

Beginners MySQL 5 Tutorial Conclusion
What We Covered in this Course
Where to Go from Here

Credits
About the MySQL Tutor


[ Home \| Video Training CDs/DVD \| Site Map \| Resources \| Specialist Categories \| Specialist Categories 2 \| Specialist Categories 3 ]
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