Solved

Learn MySQL

Posted on 2014-07-26
6
383 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
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 28

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
Master Your Team's Linux and Cloud Stack!

The average business loses $13.5M per year to ineffective training (per 1,000 employees). Keep ahead of the competition and combine in-person quality with online cost and flexibility by training with Linux Academy.

 
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 109

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

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

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

These days, all we hear about hacktivists took down so and so websites and retrieved thousands of user’s data. One of the techniques to get unauthorized access to database is by performing SQL injection. This article is quite lengthy which gives bas…
As technology users and professionals, we’re always learning. Our universal interest in advancing our knowledge of the trade is unmatched by most industries. It’s a curiosity that makes sense, given the climate of change. Within that, there lies a…
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…
Video by: Mark
This lesson goes over how to construct ordered and unordered lists and how to create hyperlinks.

809 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