MySQL Tutorial Video

Details

This Beginners MySQL tutorial offers users an cost effective way to master this application it days. Presented using narrated QuickTime videos that work on both PC and Mac platforms. This training CD uses practical examples and easy to follow step by step instructions to convey knowledge and accelerate the learning process, users of this training product will benefit from a degree of clarity and retention that other forms of training fail to match. Most of the tutorials are suitable for beginner to intermediate users.
Close

Beginners MySQL Video Training

Contents

All the topics covered by this Beginners MySQL Training CD are listed below. The blue links are FREE Demos. Suitable for use on PC or MAC.

Try for FREE - NOW

QuicktimeInformation on the free demos.
So you can sample the high quality of this training product we have made available the first free chapters for free. On the purchased product the entire listing below is included. Please note the sound and video quality of the free demos has been compressed for faster internet delivery, the audio and video on the purchased CDs is much higher. In order to play the free demos Apple QuickTime 7 or above is needed if required

Click here to Buy This Video DVD

Getting Started
  Welcome Demo
 What You'll Need Demo

Database Basics
  What Is A Database? Demo
 RDBMSs Demo
 Tables and Data Demo

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


If you purchase the CD all the contents listed below are also included.

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

Beginners MySQL Tutorial Video Information

Product Title: Beginners MySQL
Trainer: Joshua Mostafa
Other Training courses by this author
Movie Details: 71 Lessons- Video run time: 8 Hours
Price North America $99.95
Price for Europen Sales £63.96 ( + Vat )
Delivery: 3 working days ( UK / USA and Canada )
Suitable for: Win 95, 98, 2000, NT, XP, Mac OS, OSX

128 In Stock

BUY THIS VIDEO

Benefits of this training method
  • Unique accelerated learning, master Beginners MySQL in days.
  • All training courses are taught by leading experts
  • Highly informative with an unmatched level of retention
  • Easy to follow step-by-step instructions
  • Ideal for single of multi users,
  • Users control the pace of the training, lessons can be stopped, rewound or fast-forwarded at any time.
  • More cost effective than a classroom training course, learn when it suits you.

Associated Titles:

Dreamweaver CS3 Tutorials | Adobe Flash CS3 Tutorial Video | Beginners PHP Training CD | Perl | Dreamweaver CS4| Beginners FileMaker 10 Tutorial

Unrestricted Access to every training video - $30.00

Not sure which training CD to purchase? Why not have unlimited access to the entire range of training videos featured on this site for an unbelievable price of just $30 per month, that’s a massive 4,500 hours worth.

online people

Over 4000 hours of high quality training videos covering more than 350 of the most sort after software experts, accessible right from your own desk top, and all for just $30 per month.
No minimum sign up period
For Companies and Schools we offer a Multi User version complete with control panel, monitor usage, download reports, grant access and more.

Once signed up access is granted instantly to over 350 different titles with totally no restrictions, you can view as many different titles as you wish, there are no limits on how long you can log in for, you can even access from any computer.

This is without a doubt the most comprehensive source of high quality training on the web, and all at an unbelievable low price.

Learn even the most complex applications without having to read a manual or attend expensive classroom type training, learn when it’s convenient to you.

New titles are added each month, and as a member you will also have unlimited access to these as well.l.

Most of the training titles also have exercise files, these are included at no extra charge.

On completion of each course users can obtain a certification to verify the training.

Free Training Newsletter

Sign up for our free newsletter and get updated on when new titles are realised, and or when special offers are available
Your details are secure we never traded, sell or otherwise exchange your data with any third parties.

Best Selling Titles - Groups:

FileMaker Pro | Excel Tutorials | MySQL Access Tutorials | Microsoft SQL Server 2000 Admin Microsoft SQL Server 2000 Programming | Online Beginners MySQL Training Courses