Getting Started with MySQL: Advice for Beginners

[Chromium]

hey everyone,

I'm about to take an introductory course in databases in the fall, but I figured I could start learning about them now. I downloaded & installed MySQL Server 5.1, but I'm not exactly sure what to do at this point. I'll migrate to the bin folder and type in the following:

mysql -u root -p

This will bring me to some sort of main menu. But anyways, can anyone give me some advice or direct me to a really good tutorial? I've been doing some searching on Google and I've found some stuff. I've learned that you can distinguish between the entity that actually stores data (i.e. storage engine) from the management system (which allows you to manipulate the structure that holds data via commands like SQL commands), but I figured asking on here wouldn't hurt either.

thanks,

--Jonathan

 

[jtbell]

This tutorial on mysql.com looks promising:

http://dev.mysql.com/doc/refman/5.0/en/tutorial.html

It's the first hit I got when I did a Google search for "mysql tutorial." Some of the other hits look like they might be useful also.

 

[rootX]

You can just go to a nearby library and grab some books on MySQL/database management.

For knowing why you are doing what you will be doing in the course, you should use language you know and make one application that stores information in the db. Maybe you would want to get some books on how to access/update/insert/delete data with your favorite language.

One application suggestion: A user interface (either command prompt/html) that let you post comments, see all comments posted in the past.

 

[waht]

youtube has some tutorials

http://www.youtube.com/watch?v=ls-GGzDkQzc&feature=PlayList&p=F4846A176A698936&index=0