MySQL 5 Video Tutorial Course

CareerVision Training

£ 70 - (Rs 6,046)
VAT incl.

Important information

  • Training
  • Beginner
  • Distance learning
  • Duration:
  • When:
  • Delivery of study materials

• Format: DVD-ROM
• 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.

Important information

Requirements: This is a DVD Video Tutorial Course which is shipped to you. Work through the video tutorials at your own pace. If you have the software you can practice along with the instructor using the same exercise files as the instructor which are included on the DVD. The narrated training videos demonstrate the key tools and professional techniques helping you to work faster and smarter. All the concepts of each application are explained clearly and precisely. The DVD works on PC and Mac. You can jump to and from lessons and work at your own pace.


Where and when

Starts Location
Distance Learning

What you'll learn on the course

Database Administration
SQL features
Importing Databases

Course programme

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