What is MySQL? A Visual Definition
"I tried to learn .NET by taking boot camp classes that cost me $6,000. After taking the classes, I discovered tons of free (and very cheap) videos on the internet created by experts in the field. I found the videos to be much better than the classrooms. The videos were presented by Microsoft presenters that knew the material backwards and forwards, and they were much cheaper and better than the classroom teachers. I have spent the last three years organizing and hunting down the videos for my own use and decided that all could benefit by sharing what I found." - Wade Harvey
Click Here for Free 24 hour pass to lynda.com.
I AM VERY EXCITED ABOUT THIS AMAZING NEW DISCOVERY
Over 40,000 Top-Notch Video Tutorials (or 3,452 hours) on Lynda.com
I had stumbled across Lynda.com many times before, but never stopped to try it out. I recently took the plunge and started using Lynda.com to help me improve my javascript skills (See Javascript Essential Training 2007 by Dori Smith). It has revolutionized my understanding of the language! I love the fact that the exercise files allow you to follow along in real time with what the instructor is saying. Learning by doing is an extremely powerful technique. I have to give the site an A+ for both quality and content.
I am planning on using Lynda Videos to help me improve in:
Looking for premium .NET Training Videos? The best premium .NET Videos that I have found are at Learn Visual Studio. Those videos are only about 50 cents per hour, as compared to $25 per hour that other sites charge!
LearnVisualStudio is currently having a 25% off sale ($50 savings) and giving away a free membership to TrainingSpot ($60 value) when LVS Lifetime Membership is purchased.
Limited Time Offer: Free Lifetime Membership to Progress Monitor ($24.95 value) when you purchase any membership at Learn Visual Studio, Lynda Videos or any hosting account at DiscountASP - just forward order confirmation to harvey007@sbcglobal.net
I had stumbled across Lynda.com many times before, but never stopped to try it out. I recently took the plunge and started using Lynda.com to help me improve my javascript skills (See Javascript Essential Training 2007 by Dori Smith). It has revolutionized my understanding of the language! I love the fact that the exercise files allow you to follow along in real time with what the instructor is saying. Learning by doing is an extremely powerful technique. I have to give the site an A+ for both quality and content.
I am planning on using Lynda Videos to help me improve in:
- HTML
- CSS
- Classic ASP
- .NET (included in ASP section)
- AJAX
- Silverlight (in Microsoft Section)
- SharePoint (in Microsoft Section)
- Web Design
- Blogging
- SEO
- and much more
Looking for premium .NET Training Videos? The best premium .NET Videos that I have found are at Learn Visual Studio. Those videos are only about 50 cents per hour, as compared to $25 per hour that other sites charge!
LearnVisualStudio is currently having a 25% off sale ($50 savings) and giving away a free membership to TrainingSpot ($60 value) when LVS Lifetime Membership is purchased.
Limited Time Offer: Free Lifetime Membership to Progress Monitor ($24.95 value) when you purchase any membership at Learn Visual Studio, Lynda Videos or any hosting account at DiscountASP - just forward order confirmation to harvey007@sbcglobal.net
By: Wade Harvey
MySQL (pronounced "My Ess Que Ell") is an RDBMS (relational database) that is used in many web applications today. MySQL was originally developed in 1994 by a Swedish consulting firm named TeX. The principal developer was Michael Widenius. He was seeking a database that could be fast, even at the expense of omitting many features that are included in other relational databases. The name of the company is now called MySQL AB, and their website is www.mysql.com
The MySQL software consists of:
- MySQL Server (MySQLd) – this is the component that does the work of executing commands against MySQL databases
- Administration Utility Programs
- Supporting Software
MySQL Server carries out the instructions that you write. For example, if you say CREATE DATABASE, MySQL Server is what carries out those commands. You can send instructions to MySQL Server in many ways, but PHP language is primary way used on most web sites. You talk to the relational database thru Structured Query Language (SQL). MySQL server understands SQL, but PHP does not. PHP is used to create a connection to MySQL server and to send the SQL statements to the server so that they can be executed.
Advantages of MySQL:
- It is fast
- It is inexpensive (free in most cases)
- Easy to use
- Tech support is widely available – for example, see www.mysql.com
- It can run on a wide variety of operating systems – Windows, Linux, Mac OS, most varieties of Unix(including AIX, DEC Unix, and Solaris), FreeBSD, Irix, OS/2 and more.
- It supports large databases (up to a theoretical limit of 8 million terabytes).
- It has it's own security system for users and groups of users.
MySQL AB licenses the software in two ways:
-
Open Source Software – MySQL is available thru the GNU General Public License (GPL) for no charge. If you are using MySQL as a database for a website, it is okay even if you are making money on the web site.
-
Commercial License – If a developer wants to create a product that uses MySQL and desires to sell that product rather than release it under GPL, the developer needs a commercial license.
You can learn more about MySQL by viewing the following introductory videos:
- Meet the MySQL Database – (27 min) – This talk was given at the Hampshire Linux User Group (HantsLUG) meeting on 1st April 2006 at Southampton University.
- MySQL Basics -(1 hr.) – California Central Valley Developer and Database Professional Chad Godfirnon gives a demonstration on the basic usage of the popular open source Database application MySQL.
- Make the most of MySQL with phpMyAdmin – (Feb. 3/2006 – 70 min) – PhpMyAdmin, the leading web interface to the MySQL database system, is covered in detail by one of its key developers, Marc Delisle.
Related posts:
- What is Oracle? A Visual Definition Describes historical origins and major components of Oracle. Also, reviews...
- What is Java? A Visual Definition Article discusses Java's historical origins and key features. Java is...
- What is .NET Framework? A Visual Definition The .NET applications and services operate within the .NET Framework...
- Programming Languages News Are Relational Databases Obsolete? – Slashdot 7 Sep 2007...
- What is SQL? What is SQL? SQL stands for Structured Query Language and...
Related posts brought to you by Yet Another Related Posts Plugin.
You made it seem possible to understand MySQL (and why I would want to).
Thanks,
Brennan
Great Post! Full of useful resources…I guess now I no longer have an excuse not to learn how to set up a database!
Very impressive. It's not always easy to make techie stuff easy to understand, but you have done a great job!