Download Safari Books Online apps: Apple iOS | Android

Entire Site

Safari Books Online

    Free Trial

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

    Learning MySQL 5

    Subscriber Reviews • Browse Similar Topics

    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.642857142857143 out of 5 rating Based on 14 Ratings

    "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