United States QuickStart! - MySQL 5 Tutorials
Online Contents For This Course
We have made some of the video tutorials for
QuickStart! - MySQL 5
freely available to help you evaluate our training. Click on any of the linked lesson listings below to preview FREE!
Course Description
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:
|
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 FeedbackCourse Information
| Course: | QuickStart! - MySQL 5 |
| Author: | John Mangino |
| SKU: | 34137 |
| ISBN: | |
| Release Date: | 2010-06-25 |
| Duration: | 3 hrs / 30 tutorials |
| Work Files: |
Yes |
| Captions: | No |
Subscription / Purchase Information
Visitors to VTC.com will be able to view all introductory videos for each training course.
Free Trial Members will gain access to first three chapters for each training course.
Sign up for a Free Trial
Full Access Members have full access to VTC.com’s entire library of video tutorials.
If you are already a member, please login here.