Search for a title:

MySQL Tutorial - Training Videos

MySQL Tutorial CD

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

 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


  256 in Stock

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.

RELATED TUTORIALS


NEW TRAINING TITLES


CLIENT TESTIMONIALS

'I have been using your 'Photoshop CD to demonstrate Photoshop technique to my students. I have been encouraging them to purchase it on their own, as I believe it to be an excellent training instrument, and the best instructional CD on this subject to date. Not only is it well-thought out and presented clearly, but it is also a bargain.
Joe Doyle
Vista Community College, Berkeley, CA ;

Site Map | Free Demos


Apex Web Media ( Hyperteach )
P.O Box 398 Bolton BL7 9YS, United Kingdom.
Tel: +44 (0) 1204 592071
Fax: +44 (0) 1204 592092
Email:


Apex Web Media ( Hyperteach )
600 17th Street, Suite 2800, Denver CO 80202
Tel: Toll free 1866 402 1903 (USA) / 434-878-4158
Fax: 1 207 433 4356
Email: