MySQL Tutorial - Training Videos

Training CDs > Databases Tutorial Videos > MYSQL

Affordable Training you can depend on
This MySQL video tutorial utilizes an easy to follow training format that is both engaging and informative. Created to assist the beginners to intermediate users, the author uses a unique training method that brings a high degree of visual clarity to even the most complex applications. Being over 8 hours long these MySQL tutorials are extremely comprehensive and easy to follow. Video Training by Experts - Low Cost.

Not sure which Training CDs to buy?
The Online University allows unlimited access to the entire range of training titles for one low fee of only $30 per month. There is no fixed term, no limits, and you can cancel at any time. For corporate users and schools we also offer multi user accounts.
Find out more about the online video tutorials »

About the Free Video Online Training Course Demos
To allow you to evaluate the quality of the MySQL training course we have made the first 3 chapters of this tutorial available for free viewing online, the purchased version of this training course contains all the topics listed below. The free demos below have been compressed for faster playback over the internet, the audio and video quality of the purchased CD / DVD is far greater. To play the free demo videos you will need QuickTime,

THIS TUTORIAL COVERS THE FOLLOWING SUBJECTS

Description

This MySQL tutorial video on DVD / CD is ideal for the beginner who wishes to create dynamic database driven websites. This video based MySQL training CD - DVD skips database theory and relational design, subjects that often fill up the pages of text books, and moves right into the practicalities of creating and administrating a MySQL database. The tutorial is of a practical hands-on nature and the narrated video format makes learning easy, forget trying to learn from a book, sit back and let an expert guide you through using MySQL in the real world.

Topics covered by these tutorial videos include: Introduction to MySQL, Creating a Basic Database, Tables, Data Types, Operators, Primary Keys, Indexes, Regular Expressions in MySQL, Creating Joins, Variables, If statement, ENUM Type, Users and Privileges, Encryption and much more. You may also be intrested in the PHP for Beginners Training CD

MySQL Related Groups

Hide Description

The Blue Links below are free demos, when you purchase the video training CD / DVD the enitre content listings below are included , not just the free demo videos.

Getting Started

Database Basics

SQL Basics

Operators in MySQL

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

Querying Your Data

Sorting Retrieved Data
Specifying Numbers of Results
Joining Tables Pt 1
Joining Tables Pt 2
More On Joining Tables
Data Aggregation
Queries Syntax Recap

More Complex SQL

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

Good Practices

Using SQL batch files Pt 1
Using SQL batch files Pt 2
Data Modeling Pt 1
Data Modeling Pt 2
Normalization Pt 1
Normalization Pt 2
Optimizations

Security

Users And Privileges
More About Users And Privileges
The mysql Database Pt 1
The mysql Database Pt 2
Encryption
Security Syntax Recap

Building A Database Application

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

MySQL Tutorials - VIDEO INFO

» Studio quality audio and video
» Works on Pc or Mac
» Ideal for people that learn quicker by being shown
» Master complex application in days

Title	:	MySQL
Instructor	:	Joshua Mostafa
Price	:	US$ 99.95
Duration	:	8 hours - 71 Movies
OS	:	Win Vista XP 98,2000,ME. Mac OS 9, OS X
Delivery Options	:	Ground / 2 day / Next Day
Product Code	:	33364

BENEFITS OF THIS TRAINING COURSE

Master MySQL in the shortest time possible
Self paced tutorial, training on video, at your own pace
Just sit back and watch, no books to read, just easy to follow lessons
Training can be viewed from any location, on PC or Mac
All training is self-contained; you don’t even need the application you are learning loaded on your machine
The most affordable way to learn, benefit from a world-leading expert
High quality content for a fraction of the cost of a classroom training course
The Tutorials can be rewound, fast forwarded or stopped at any time
Learn from the comfort of your own desk.