VTC.com QuickStart MySQL 5 Tutorials

VTC.com QuickStart MySQL 5 Tutorials | 116 MB
Genre: eLearning

MySQL is one of the mst popular database systems in the world. As a free and open alternative to proprietary database systems it has been used by sites and applications all over the web including Flickr, Wikipedia and even Google. In this VTC QuickStart author John Mangino will help the beginner dive into MySQl and provide a solid foundation for building and developing your own MySQL databases and ultimately incorporating them into your own sites and applications.

Course Contents

Introduction
Welcome

Installing MySQL
Windows WAMP
Mac MAMP
Linux LAMP
Accessing MySQL
Changing Password WAMP/MAMP

Naming & Column Types
Element Names
Column Types - Text
Column Types - Numbers
Column Types - Dates
Other Column Properties

Creating & Retrieving Data
Create & Select a Database
Create a Table
Inserting Records pt. 1
Inserting Records pt. 2
Selecting Data & Conditionals pt. 1
Selecting Data & Conditionals pt. 2
Special Conditionals LIKE & NOT LIKE
Sorts & Limiting pt. 1
Sorts & Limiting pt. 2
Update a Record
Delete Data

Functions
Using Functions
Text Functions pt. 1
Text Functions pt. 2
Numeric Functions
Date & Time Functions
TIME_FORMAT

Conclusion
Wrap Up

Credits
About the Author

Download
Hotfile

Mirror 1
FileServe

Mirror 2
Rapidshare