VTC - QuickStart! - MySQL 5
Date: 22 October 2013 | Posted by: Soomro
VTC - QuickStart! - MySQL 5 | 244.64 MB
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
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
See full article