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. A hands on and project focused course for people who want to begin building their own databases. To begin learning today, simply click on the movie links.
* VTC QuickStart! courses are available only to registered Online University members.
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