Comprehensive Video Tutorials

MySQL 5 Training

CareerVision Training

£ 72 - (Rs 5,870)

Important information

  • Course
  • Online
  • Duration:
  • When:

 •  Format: DVD

 •  Duration: 6.5 Hours (91 lessons)

 •  Instructor: Jason Gilmore

 •  Platform: Windows PC or Mac


Important information

Where and when

Starts Location

What you'll learn on the course


Course programme

 •  Format: DVD
 •  Duration: 6.5 Hours (91 lessons)
 •  Instructor: Jason Gilmore
 •  Platform: Windows PC or Mac

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 method is...

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 guide you 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.
 •  Course works on PC and Mac.
 •  Alternative to a boring book or manual and expensive training courses, seminars and amp; 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.

Free Videos From This Course Creating Your First User Account Primary Keys - Part 2 MySQL Workbench Data Modelling Intro MySQL Workbench Server Administration Intro Grouping Results String Functions Temporal Functions - Example Subqueries The Inner Join The Left Join Introducing The Relational Database
Course Introduction
What Is A Relational Database
The Database Hierarchy
Table Relations
The Structured Query Language

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

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