Solved

Learn MySQL

Posted on 2014-07-26
6
391 Views
Last Modified: 2014-08-14
Is there a free online tutorial for learning mysql?  I'm not seeing a certification path. Everything is either MS SQL or Oracle.  I would really like to start with mysql since that is something that everyone has.  Assistance in finding a free online tutorial is greatly appreciated.
0
Comment
Question by:frugalmule
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
6 Comments
 
LVL 83

Expert Comment

by:Dave Baldwin
ID: 40221017
Most of us 'learn' MySQL thru the programming language we use, most often PHP.  And many hosting companies provide phpMyAdmin to manage your databases.  While there are desktop interface programs that you can use, you will still have to use the language functions in your web programming.
0
 

Author Comment

by:frugalmule
ID: 40221022
Yes, but I am mostly concerned about learning the syntax used for the database itself, not for styling the front end.  I'd like to find a good online tutorial that had actual lessons where it would let you practice various concepts and tell you when you got something wrong.
0
 
LVL 29

Assisted Solution

by:chilternPC
chilternPC earned 167 total points
ID: 40221030
for the syntax you need to look for tutorials for SQL this is the syntax the MySQL and MSSQL use.

w3schools have such a site where they explain a command , show examples and  then you can type in online your ideas and see the result

http://www.w3schools.com/sql/

down the left hand side are all the commands , click on a command then read the page, and all the examples of that command come with a  'try it yourself' button which lets you try the command and see the result and then once understood, continue to the next command.
0
Will your db performance match your db growth?

In Percona’s white paper “Performance at Scale: Keeping Your Database on Its Toes,” we take a high-level approach to what you need to think about when planning for database scalability.

 
LVL 83

Expert Comment

by:Dave Baldwin
ID: 40221081
That tutorial actually looks pretty good.  It has an SQL editor with the examples that you can experiment with.
0
 
LVL 110

Assisted Solution

by:Ray Paseur
Ray Paseur earned 166 total points
ID: 40221327
0
 
LVL 15

Accepted Solution

by:
Insoftservice earned 167 total points
ID: 40232615
I would suggest lynda.com for any programming tutorial.
0

Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

A company’s centralized system that manages user data, security, and distributed resources is often a focus of criminal attention. Active Directory (AD) is no exception. In truth, it’s even more likely to be targeted due to the number of companies …
Your data is at risk. Probably more today that at any other time in history. There are simply more people with more access to the Web with bad intentions.
This tutorial walks through the best practices in adding a local business to Google Maps including how to properly search for duplicates, marker placement, and inputing business details. Login to your Google Account, then search for "Google Mapmaker…
The viewer will learn how to create and use a small PHP class to apply a watermark to an image. This video shows the viewer the setup for the PHP watermark as well as important coding language. Continue to Part 2 to learn the core code used in creat…

688 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question