Learning MySQL 5 Training Video

expand all / collapse all

• 00. 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

• 01. Introducing The Relational Database

  • 0101 Course Introduction
  • 0102 What Is A Relational Database
  • 0103 The Database Hierarchy
  • 0104 Table Relations
  • 0105 The Structured Query Language
  • 0106 Conclusion

• 02. Installing And Configuring MySQL

  • 0201 Introduction To MySQL
  • 0202 MySQL Features
  • 0203 Installing MySQL - Introduction
  • 0204 Downloading MySQL
  • 0205 Installing MySQL - Part 1
  • 0206 Installing MySQL - Part 2
  • 0207 Configuring MySQL
  • 0208 Setting The System Path - Part 1
  • 0209 Setting The System Path - Part 2
  • 0210 Installing MySQL On The Mac
  • 0211 The Sakila Database
  • 0212 Installing The Sakila Database

• 03. Connecting To MySQL And Creating Your First Database

  • 0301 Introduction To MySQL Connections
  • 0302 Role Of The Root User
  • 0303 Logging In For The First Time
  • 0304 Change The Root Password
  • 0305 Creating Your First Database
  • 0306 Creating Your First User Account
  • 0307 Creating Your First Table

• 04. Introducing MySQL's Data Types

  • 0401 Intro To Data Types
  • 0402 String Data Types - Part 1
  • 0403 String Data Types - Part 2
  • 0404 Data Attributes
  • 0405 Customers Table Revised
  • 0406 Numerical Data Types - Part 1
  • 0407 Numerical Data Types - Part 2
  • 0408 Numerical Data Attributes
  • 0409 Date And Time Types
  • 0410 Multiple Timestamp Columns In Table

• 05. Primary And Foreign Keys

  • 0501 Primary Keys - Part 1
  • 0502 Primary Keys - Part 2
  • 0503 Creating A Primary Key
  • 0504 Foreign Key Introduction
  • 0505 Create Foreign Key

• 06. Introducing phpMyAdmin, MySQL Workbench, SQLyog

  • 0601 Graphical MySQL Clients
  • 0602 phpMyAdmin Intro
  • 0603 MySQL Workbench Intro
  • 0604 MySQL Workbench SQL Development Intro
  • 0605 MySQL Workbench Data Modelling Intro
  • 0606 MySQL Workbench Server Administration Intro
  • 0607 SQLyog Introduction
  • 0608 SQLyog Creating A Database
  • 0609 SQLyog Navigating And Modifying Data
  • 0610 SQLyog Scheduling Backups

• 07. Creating, Retrieving, Updating And Deleting Data

  • 0701 Performing CRUD Operations
  • 0702 Creating Data
  • 0703 Retrieving Data
  • 0704 Ordering Results
  • 0705 Filtering Results
  • 0706 Grouping Results
  • 0707 Removing Duplicate Rows
  • 0708 The LIKE Clause
  • 0709 The LIMIT Clause
  • 0710 Updating Data
  • 0711 Deleting Data

• 08. Using String, Numeric, Temporal And Stored Functions

  • 0801 Introduction To Functions
  • 0802 String Functions
  • 0803 Numeric Functions
  • 0804 Temporal Functions - Introduction
  • 0805 Temporal Functions - Example
  • 0806 Stored Functions - Part 1
  • 0807 Stored Functions - Part 2
  • 0808 Stored Functions - Part 3

• 09. Introducing Subqueries

  • 0901 Subqueries Intro
  • 0902 Subqueries

• 10. Introducing SQL Joins

  • 1001 SQL Joins
  • 1002 The Inner Join
  • 1003 The Left Join

• 11. Optimizing MySQL

  • 1101 Optimizing MySQL
  • 1102 Column Indexing
  • 1103 Column Indexing Explained
  • 1104 Optimizing The MySQL Configuration
  • 1105 Query Caching
  • 1106 Query Caching Explained
  • 1107 Optimizing MySQL Conclusions

• 12. Importing, Exporting And Backing Up MySQL Databases

  • 1201 Introduction To MySQL Data Tasks
  • 1202 Exporting Data With MySQL Workbench
  • 1203 Importing Data With phpMyAdmin
  • 1204 Automatically Backing Up Your MySQL Database
  • 1205 Automating Your Backups With mysqldump And cron

• 13. Managing MySQL User Privileges

  • 1301 Managing MySQL Privileges
  • 1302 MySQL Privilege Management Walkthrough

• 14.Using PHP And MySQL

  • 1401 Introduction to PHP and MySQL
  • 1402 Querying Your MySQL Database With PHP

• 15. About The Author

  • 1501 About The Author

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.