Infinite Skills - Learning MySQL 5 Training Video

English | MP4 | 960x720 | AVC 225 Kbps 15.000 fps | AAC 64.0 Kbps 44.1 khz | 6.5 hours | 859 MB

Genre: Video Training

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.

01. Introducing The Relational Database

02. Installing And Configuring MySQL

03. Connecting To MySQL And Creating Your First Database

04. Introducing MySQL's Data Types

05. Primary And Foreign Keys

06. Introducing phpMyAdmin, MySQL Workbench, SQLyog

07. Creating, Retrieving, Updating And Deleting Data

08. Using String, Numeric, Temporal And Stored Functions

09. Introducing Subqueries

10. Introducing SQL Joins

11. Optimizing MySQL

12. Importing, Exporting And Backing Up MySQL Databases

13. Managing MySQL User Privileges

14.Using PHP And MySQL

15. About The Author