O'Reilly logo

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

MySQL 5

Video Description

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.

Table of Contents

  1. Introducing The Relational Database
    1. Course Introduction 00:00:43
    2. What Is A Relational Database 00:01:23
    3. The Database Hierarchy 00:02:32
    4. Table Relations 00:02:38
    5. The Structured Query Language 00:01:25
    6. Conclusion 00:01:08
  2. Installing And Configuring MySQL
    1. Introduction To MySQL 00:03:21
    2. MySQL Features 00:09:19
    3. Installing MySQL - Introduction 00:00:36
    4. Downloading MySQL 00:01:54
    5. Installing MySQL - Part 1 00:03:17
    6. Installing MySQL - Part 2 00:01:55
    7. Configuring MySQL 00:05:20
    8. Setting The System Path - Part 1 00:01:04
    9. Setting The System Path - Part 2 00:02:48
    10. Installing MySQL On The Mac 00:02:47
    11. The Sakila Database 00:01:38
    12. Installing The Sakila Database 00:02:33
  3. Connecting To MySQL And Creating Your First Database
    1. Introduction To MySQL Connections 00:00:48
    2. Role Of The Root User 00:01:42
    3. Logging In For The First Time 00:04:40
    4. Change The Root Password 00:01:26
    5. Creating Your First Database 00:06:43
    6. Creating Your First User Account 00:04:18
    7. Creating Your First Table 00:03:48
  4. Introducing MySQL's Data Types
    1. Intro To Data Types 00:02:53
    2. String Data Types - Part 1 00:04:31
    3. String Data Types - Part 2 00:02:07
    4. Data Attributes 00:02:15
    5. Customers Table Revised 00:03:36
    6. Numerical Data Types - Part 1 00:03:30
    7. Numerical Data Types - Part 2 00:01:45
    8. Numerical Data Attributes 00:02:38
    9. Date And Time Types 00:08:46
    10. Multiple Timestamp Columns In Table 00:04:20
  5. Primary And Foreign Keys
    1. Primary Keys - Part 1 00:02:42
    2. Primary Keys - Part 2 00:06:27
    3. Creating A Primary Key 00:02:42
    4. Foreign Key Introduction 00:08:45
    5. Create Foreign Key 00:04:24
  6. Introducing phpMyAdmin, MySQL Workbench, SQLyog
    1. Graphical MySQL Clients 00:04:54
    2. phpMyAdmin Intro 00:09:59
    3. MySQL Workbench Intro 00:02:01
    4. MySQL Workbench SQL Development Intro 00:08:39
    5. MySQL Workbench Data Modelling Intro 00:09:03
    6. MySQL Workbench Server Administration Intro 00:02:35
    7. SQLyog Introduction 00:01:26
    8. SQLyog Creating A Database 00:05:00
    9. SQLyog Navigating And Modifying Data 00:03:33
    10. SQLyog Scheduling Backups 00:05:03
  7. Creating, Retrieving, Updating And Deleting Data
    1. Performing CRUD Operations 00:01:58
    2. Creating Data 00:06:29
    3. Retrieving Data 00:05:05
    4. Ordering Results 00:02:28
    5. Filtering Results 00:04:52
    6. Grouping Results 00:07:06
    7. Removing Duplicate Rows 00:01:31
    8. The LIKE Clause 00:03:54
    9. The LIMIT Clause 00:03:35
    10. Updating Data 00:05:31
    11. Deleting Data 00:03:04
  8. Using String, Numeric, Temporal And Stored Functions
    1. Introduction To Functions 00:00:57
    2. String Functions 00:09:55
    3. Numeric Functions 00:05:21
    4. Temporal Functions - Introduction 00:02:26
    5. Temporal Functions - Example 00:11:13
    6. Stored Functions - Part 1 00:01:18
    7. Stored Functions - Part 2 00:06:33
    8. Stored Functions - Part 3 00:06:18
  9. Introducing Subqueries
    1. Subqueries Intro 00:02:40
    2. Subqueries 00:10:18
  10. Introducing SQL Joins
    1. SQL Joins 00:01:43
    2. The Inner Join 00:11:52
    3. The Left Join 00:07:37
  11. Optimizing MySQL
    1. Optimizing MySQL 00:00:49
    2. Column Indexing 00:01:39
    3. Column Indexing Explained 00:08:14
    4. Optimizing The MySQL Configuration 00:07:17
    5. Query Caching 00:01:17
    6. Query Caching Explained 00:03:49
    7. Optimizing MySQL Conclusions 00:00:35
  12. Importing, Exporting And Backing Up MySQL Databases
    1. Introduction To MySQL Data Tasks 00:00:54
    2. Exporting Data With MySQL Workbench 00:05:38
    3. Importing Data With phpMyAdmin 00:02:39
    4. Automatically Backing Up Your MySQL Database 00:01:22
    5. Automating Your Backups With mysqldump And cron 00:09:05
  13. Managing MySQL User Privileges
    1. Managing MySQL Privileges 00:00:59
    2. MySQL Privilege Management Walkthrough 00:08:58
  14. Using PHP And MySQL
    1. Introduction to PHP and MySQL 00:05:33
    2. Querying Your MySQL Database With PHP 00:12:50
  15. About The Author
    1. About The Author 00:01:48