Free Trial

Safari Books Online is a digital library providing on-demand subscription access to thousands of learning resources.

Overview

In this computer based training course, expert author Jason Gilmore introduces you to MySQL, a popular relational database used most often in the LAMP (Linux, Apache, MySQL, PHP) stack, or development environment. This training video covering MySQL 5 is designed for the beginner, and no previous MySQL experience is necessary. Throughout this tutorial, Jason covers some of the fundamental topics that you will need to use and manage MySQL, such as: installing MySQL, configuring MySQL, connecting to MySQL, securing MySQL, and managing MySQL. You will learn about data types, primary and foreign keys, creating, retrieving and updating data, and using stored functions. You will also learn tricks for optimizing, importing and backing up MySQL databases. By the conclusion of this video tutorial on MySQL 5, you will have an in-depth understanding of how to install, configure, manage and use MySQL 5.

Subscriber Reviews

Average Rating: 4.523809523809524 out of 5 rating Based on 21 Ratings

"Great introduction!" - by Anonymous on 05-MAR-2014
Reviewer Rating: 1 star rating2 star rating3 star rating4 star rating5 star rating
This was a very helpful introduction.
Report as Inappropriate

"Great Tutorial" - by Padmore Tenkorang on 02-JUN-2013
Reviewer Rating: 1 star rating2 star rating3 star rating4 star rating5 star rating
Great tutorials.
Thanks

Report as Inappropriate

"Excellent " - by Anonymous on 05-JUN-2012
Reviewer Rating: 1 star rating2 star rating3 star rating4 star rating5 star rating

Report as Inappropriate

" " - by lotterblad on 21-MAY-2012
Reviewer Rating: 1 star rating2 star rating3 star rating4 star rating5 star rating

Report as Inappropriate

Table of Contents

Chapter/Selection

Time

01. Introducing The Relational Database

Course Introduction

Preview

00:00:43

What Is A Relational Database

Preview

00:01:22

The Database Hierarchy

Preview

00:02:31

Table Relations

Preview

00:02:38

The Structured Query Language

Preview

00:01:24

Conclusion

Preview

00:01:07

02. Installing And Configuring MySQL

Introduction To MySQL

Preview

00:03:21

MySQL Features

Preview

00:09:18

Installing MySQL - Introduction

Preview

00:00:35

Downloading MySQL

Preview

00:01:53

Installing MySQL - Part 1

Preview

00:03:17

Installing MySQL - Part 2

Preview

00:01:54

Configuring MySQL

Preview

00:05:19

Setting The System Path - Part 1

Preview

00:01:04

Setting The System Path - Part 2

Preview

00:02:47

Installing MySQL On The Mac

Preview

00:02:46

The Sakila Database

Preview

00:01:38

Installing The Sakila Database

Preview

00:02:32

03. Connecting To MySQL And Creating Your First Database

Introduction To MySQL Connections

Preview

00:00:48

Role Of The Root User

Preview

00:01:41

Logging In For The First Time

Preview

00:04:39

Change The Root Password

Preview

00:01:25

Creating Your First Database

Preview

00:06:43

Creating Your First User Account

Play Video

00:04:17

Creating Your First Table

Preview

00:03:48

04. Introducing MySQL's Data Types

Intro To Data Types

Preview

00:02:53

String Data Types - Part 1

Preview

00:04:30

String Data Types - Part 2

Preview

00:02:06

Data Attributes

Preview

00:02:14

Customers Table Revised

Preview

00:03:36

Numerical Data Types - Part 1

Preview

00:03:29

Numerical Data Types - Part 2

Preview

00:01:45

Numerical Data Attributes

Preview

00:02:38

Date And Time Types

Preview

00:08:46

Multiple Timestamp Columns In Table

Preview

00:04:20

05. Primary And Foreign Keys

Primary Keys - Part 1

Preview

00:02:41

Primary Keys - Part 2

Play Video

00:06:27

Creating A Primary Key

Preview

00:02:41

Foreign Key Introduction

Preview

00:08:44

Create Foreign Key

Preview

00:04:23

06. Introducing phpMyAdmin, MySQL Workbench, SQLyog

Graphical MySQL Clients

Preview

00:04:53

phpMyAdmin Intro

Preview

00:09:59

MySQL Workbench Intro

Preview

00:02:01

MySQL Workbench SQL Development Intro

Preview

00:08:39

MySQL Workbench Data Modelling Intro

Play Video

00:09:03

MySQL Workbench Server Administration Intro

Play Video

00:02:35

SQLyog Introduction

Preview

00:01:26

SQLyog Creating A Database

Preview

00:05:00

SQLyog Navigating And Modifying Data

Preview

00:03:33

SQLyog Scheduling Backups

Preview

00:05:02

07. Creating, Retrieving, Updating And Deleting Data

Performing CRUD Operations

Preview

00:01:58

Creating Data

Preview

00:06:29

Retrieving Data

Preview

00:05:04

Ordering Results

Preview

00:02:27

Filtering Results

Preview

00:04:51

Grouping Results

Play Video

00:07:06

Removing Duplicate Rows

Preview

00:01:31

The LIKE Clause

Preview

00:03:54

The LIMIT Clause

Preview

00:03:34

Updating Data

Preview

00:05:31

Deleting Data

Preview

00:03:03

08. Using String, Numeric, Temporal And Stored Functions

Introduction To Functions

Preview

00:00:56

String Functions

Play Video

00:09:54

Numeric Functions

Preview

00:05:21

Temporal Functions - Introduction

Preview

00:02:26

Temporal Functions - Example

Play Video

00:11:13

Stored Functions - Part 1

Preview

00:01:18

Stored Functions - Part 2

Preview

00:06:32

Stored Functions - Part 3

Preview

00:06:18

09. Introducing Subqueries

Subqueries Intro

Preview

00:02:40

Subqueries

Play Video

00:10:18

10. Introducing SQL Joins

SQL Joins

Preview

00:01:43

The Inner Join

Play Video

00:11:51

The Left Join

Play Video

00:07:36

11. Optimizing MySQL

Optimizing MySQL

Preview

00:00:49

Column Indexing

Preview

00:01:39

Column Indexing Explained

Preview

00:08:13

Optimizing The MySQL Configuration

Preview

00:07:16

Query Caching

Preview

00:01:17

Query Caching Explained

Preview

00:03:48

Optimizing MySQL Conclusions

Preview

00:00:34

12. Importing, Exporting And Backing Up MySQL Databases

Introduction To MySQL Data Tasks

Preview

00:00:53

Exporting Data With MySQL Workbench

Preview

00:05:38

Importing Data With phpMyAdmin

Preview

00:02:39

Automatically Backing Up Your MySQL Database

Preview

00:01:21

Automating Your Backups With mysqldump And cron

Preview

00:09:05

13. Managing MySQL User Privileges

Managing MySQL Privileges

Preview

00:00:58

MySQL Privilege Management Walkthrough

Preview

00:08:58

14.Using PHP And MySQL

Introduction to PHP and MySQL

Preview

00:05:33

Querying Your MySQL Database With PHP

Preview

00:12:50

15. About The Author

About The Author

Preview

00:01:48

Extras

The publisher has provided additional content related to this title.


Description
Content

These files have been provided by the publisher.

  • Working_Files.zip