Infinite Skills – Learning MySQL 5 Training Video-0daytown

Infinite Skills – Learning MySQL 5 Training Video

English | MP4 | 960×720 | 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