United States QuickStart! - MySQL 5 Training
CD Contents For This Title
All the chapters and lesson contents of QuickStart! - MySQL 5 are listed below.
To help you evaluate our training, we have made some of the tutorials for QuickStart! - MySQL 5 freely available. Click on any of the linked lesson listings below to preview FREE!
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 VTC Online University members.
Choose your media type:
To view the Free Tutorials listed below, you must have QuickTime installed. Please note that the online free samples have been compressed for quicker downloads. Purchased CDs have higher sound and video quality.Monitor resolution needs to be set to at least 1024 by 768 to view the entire movie.
Hide This|
Introduction
|
||
| Welcome | (02:57) | |
|
Installing MySQL
|
||
| Windows WAMP | (06:59) | |
| Mac MAMP | (05:58) | |
| Linux LAMP | (02:28) | |
| Accessing MySQL | (07:51) | |
| Changing Password WAMP/MAMP | (01:44) | |
|
Naming & Column Types
|
||
| Element Names | (02:58) | |
| Column Types - Text | (04:43) | |
| Column Types - Numbers | (04:49) | |
| Column Types - Dates | (03:18) | |
| Other Column Properties | (04:28) | |
|
Creating & Retrieving Data
|
||
| Create & Select a Database | (07:18) | |
| Create a Table | (07:18) | |
| Inserting Records pt. 1 | (05:29) | |
| Inserting Records pt. 2 | (05:16) | |
| Selecting Data & Conditionals pt. 1 | (05:25) | |
| Selecting Data & Conditionals pt. 2 | (07:18) | |
| Special Conditionals LIKE & NOT LIKE | (07:11) | |
| Sorts & Limiting pt. 1 | (04:14) | |
| Sorts & Limiting pt. 2 | (03:54) | |
| Update a Record | (06:55) | |
| Delete Data | (05:03) | |
|
Functions
|
||
| Using Functions | (06:45) | |
| Text Functions pt. 1 | (04:42) | |
| Text Functions pt. 2 | (03:44) | |
| Numeric Functions | (07:26) | |
| Date & Time Functions | (06:28) | |
| TIME_FORMAT | (07:32) | |
|
Conclusion
|
||
| Wrap Up | (05:47) | |
|
Credits
|
||
| About the Author | (03:43) | |
Email this Page
Send us FeedbackTitle Information / Pricing
| Title: | QuickStart! - MySQL 5 |
| Author: | John Mangino |
| SKU: | 34137 |
| ISBN: | |
| Release Date: | 2010-06-25 |
| Price: | |
| Duration: | 3 hrs / 30 lessons |
| Work Files: |
Yes |
| Captions: | No |
| Compatibility: |
Vista/XP/2000, OS X, Linux QuickTime 7 |
Online University Access all our Training for only 30
The Online University provides unlimited 24/7 access to ALL of VTC's incredible training content for the low fixed price of just $30/month (USD)
SIGNUP NOW
LEARN MORE » Related Titles
Select Bandwidth
Now Shipping
Client Testimonials
Just wanted to tell you that I love your tutorials. They are very informative, easy to follow and a great way to get up-to-speed on the new...
Sylvia