30% OFF Marked Prices & FREE Shipping!   -   ENDS 5PM FRIDAY!   -   Use Discount Code 303

MySQL 5 Tutorial

A professionally created, self-study video training course
Includes 7 hours of easy to follow MySQL 5 video tutorials presented by an industry expert.
The training is delivered to your desktop allowing you to learn at a time that suits you and at your own pace.
You can start learning online right away. Sample MySQL 5 tutorial videos by clicking a blue link below:
  • Tutor: Jason Gilmore
  • Duration: 7 hours
  • Video lessons: 91
  • Product code: 01685
  • In stock: YES
  • Available on: Digital Download
  • Work files included: YES
  • Works on: MS Windows PC & Mac
  • Also Recommended: PHP & MySQL Tutorial
These beginners MySQL 5 tutorial videos provide an in-depth knowledge of how to install, configure, manage and use MySQL 5.

Presented using step-by-step video training lessons, expert MySQL 5 tutor Jason Gilmore commences with the basics of SQL and databases and then smoothly moves on to the more advanced techniques and concepts.

Through almost seven hours of professionally created training videos, the tuition includes the basics of databases, how to install and configure a MySQL database, learning how to create, retrieve, update and delete data, lessons on SQL joins, optimizing SQL step-by-step, best practices for importing databases, help backing up MySQL databases and so much more.

The complete course contents are listed below and you can sample this highly effective training method right now, click any of the blue linked lessons to sample FREE MySQL 5 video tutorials and discover how effective this teaching guide is...
What Our Customers Are Saying

"By the way I did try one of your sample demos and I really like how the lessons are presented, LOVE the background info provided on the lesson. I am a 'Dinosaur' in this business that needs to retrain, (darn!) and I was able to follow the instructor no problem. Thanks."Mayra Rosas, Indiana
COMPLETE COURSE CONTENTS
We hope you enjoyed the free lessons. To view the complete contents, including all lessons below & above, please purchase the course via Download.
Paid Content
Section

Get all lessons with purchase
Introducing The Relational Database
Course Introduction
What Is A Relational Database
The Database Hierarchy
Table Relations
The Structured Query Language
Conclusion

Installing And Configuring MySQL
Introduction To MySQL
MySQL Features
Installing MySQL - Introduction
Downloading MySQL
Installing MySQL - Lesson 1
Installing MySQL - Lesson 2
Beginners Guide to Configuring MySQL
Setting The System Path - Lesson 1
Setting The System Path - Lesson 2
Installing MySQL On The Mac
The Sakila Database
Installing The Sakila Database

Connecting To MySQL And Creating Your First Database
Introduction To MySQL Connections
Role Of The Root User
Logging In For The First Time
Change The Root Password
Creating Your First Database
Creating Your First User Account
Creating Your First Table

Introducing MySQL's Data Types
Intro To Data Types
String Data Types - Lesson 1
String Data Types - Lesson 2
Data Attributes
Customers Table Revised
Numerical Data Types - Lesson 1
Numerical Data Types - Lesson 2
Numerical Data Attributes
Date And Time Types
Multiple Timestamp Columns In Table

Primary And Foreign Keys
Primary Keys - Lesson 1
Primary Keys - Lesson 2
Creating A Primary Key
Foreign Key Introduction
Create Foreign Key

Introducing phpMyAdmin, MySQL Workbench, SQLyog
Graphical MySQL Clients
phpMyAdmin Intro
MySQL Workbench Intro
MySQL Workbench SQL Development Intro
MySQL Workbench Data Modeling Intro
MySQL Workbench Server Administration Intro
SQLyog Introduction
SQLyog Creating A Database
SQLyog Navigating And Modifying Data
SQLyog Scheduling Backups

Creating, Retrieving, Updating And Deleting Data
Performing CRUD Operations
Creating Data
Retrieving Data
Ordering Results
Filtering Results
Grouping Results
Removing Duplicate Rows
The LIKE Clause
The LIMIT Clause
Updating Data
Deleting Data

Using String, Numeric, Temporal And Stored Functions
Introduction To Functions
String Functions
Numeric Functions
Temporal Functions - Introduction
Temporal Functions - Example
Stored Functions - Lesson 1
Stored Functions - Lesson 2
Stored Functions - Lesson 3

Introducing Subqueries
Subqueries Intro
Subqueries

Introducing SQL Joins
SQL Joins
The Inner Join
The Left Join

Optimizing MySQL
Optimizing MySQL
Column Indexing
Column Indexing Explained
Optimizing The MySQL Configuration
Query Caching
Query Caching Explained
Optimizing MySQL Conclusions

Importing, Exporting And Backing Up MySQL Databases
Introduction To MySQL Data Tasks
Exporting Data With MySQL Workbench
Importing Data With phpMyAdmin
Automatically Backing Up Your MySQL Database
Automating Your Backups With mysqldump And cron

Managing MySQL User Privileges
Managing MySQL Privileges
MySQL Privilege Management Walkthrough

.Using PHP And MySQL
Introduction to PHP and MySQL
Querying Your MySQL Database With PHP

About The Tutor
About The MySQL 5 Tutor
Purchase Info - 30% OFF MARKED PRICE!
This course is available via digital download and is priced as below:
PRICE
CURRENCY
   
 
Item(s):
Once purchased, you will receive 91 MySQL 5 training videos (listed left), lasting a total of 7 hours and the working files.

Worldwide
Shipping
Delivery Details
Download Course downloadable when payment processed (within one hour average)
WE AIM TO PLEASE
All DVD courses have a 100% money back guarantee. If you are not happy with your course contact us within 30 days of purchase for a refund.
View our full product guarantee
|
Need to Train Multiple Users?
This MySQL 5 course is available in multi-user format ideal for corporate users, schools and universities.

The course loads directly onto your server and delivered to multiple users over your network.

An unlimited number of users can access the training with a pre-determined number viewing the tuition at any one time.

Training Multiple Users

Load onto your server
Deliver on your network or existing learning management system


USING THE SAME EXCELLENT CONTENT AS SINGLE USER COURSES
For companies and educational establishments wanting multi user access to training resources, we offer this MySQL 5 course to do just that.
Now you can integrate training or technical support within your own computer network, or allow employees or students to gain access to training and support from home or any other location that they can gain access to your organizations network.

EASILY VIEWED OVER A NETWORK
The courses can be played over a LAN using a standard browser such as Microsoft Internet Explorer, Safari or Firefox.
The movies are viewed using Adobe Flash (same method as YouTube) and are slightly compressed in order to not clog the network.
All advanced and the "for dummies" courses are available via this multi user solution and can be copied directly to a hard disk for faster access and the access page may be customized, if needed, using a html editor.

ADDITIONAL USERS AND TITLES CAN BE ADDED
More than one title can exist on your server and the supplied player will automatically show titles that are available.
Simply purchase more user licences (supplied as files) and drop them into the folder. This will automatically increase the number of users allowed onto the system. All purchases are backed up by excellent after-sales support team and easy to follow instruction manual.
You can order multi user online or speak to our knowledgeable sales team.
Multi users are sold in 10 user licenses. For each 10 user licenses, you can have up to 10 people viewing that training at any one time.
Closely Related Courses
We recommend the Beginners SQL Tutorial
See our complete range of MYSQL and PHP Video Tutorials
Prove Your Capabilities
Once a course is completed you can download a free certificate.

This certifies that you have started from the beginners level, have now viewed all instruction. The certificate advises you now possess essential skills and an in-depth knowledge of MySQL 5. Show your boss or potential employer!
Weekly Special
Promoted Course
View sample videos from the new
AutoCAD 2016
A recent customer speaks out...
"Your Products are the best example of CD and internet computer training I've seen."Christine Maggio Abacus Technology, Inc., NJ