How To Learn Mysql?

[SilverFox1405241541 0]

I want to learn MYSQL but I don't know where to start.Any suggestions of where to start in learning MYSQL?

[pyost 0]

For some simple/average web sites, the SQL syntax isn't complicated at all. Its advantage is that you can really understand what a query does just by reading it out loud. For example, SELECT * FROM `something` WHERE `i` = 1 would mean "Select everything (all fields) from the table `something` if that field's value for `i` is one."

 

Anyway, the resource I have used the most is http://www.tizag.com/. They have absolutely great starting tutorials for several languages, so you couldn't make the the number resource for many other things, too.

[yordan 10]

I would also suggest that you install some apps from your Xisto cpanel Fantastico installer. For instalnce, install the phpbb forum or the 4image gallery, and then look at the .php programs to have examples on how to use, insert/query a mysql database. Learning by examples could be agood approach. RegardsYordan

[WeaponX 0]

For beginners, I usually ask them to go to W3Schools as they have a bunch of great tutorials for those who are new:

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

Examples are basically clear cut to understand, but as pointed out earlier, you should try to play with some live code yourself to see how it works exactly.

[SilverFox1405241541 0]

Thanks for all the pointers. I'll look at all of them.yordon's is esp. useful due to the fact that his method is one of the main ways I learn.Thanks. When I'm all done with my project I'll let you all see it

[TavoxPeru 0]

Well, some way is to first download and install the server on your machine and then download the reference help file from the MySql Website, this file contains a very basic tutorial which is a good start point. After that you can also download some good example databases from the same site.

Best regards,

[Quatrux 4]

Furthermore, learning mysql is not the main thing, firstly he needs to understand databases, how they work, what is a primary key, how to store data and how to use relationships between tables, how to normalize them to be useful how to control the auto increment and id's of rows, but of course, as it was said, for a simple site, sometimes one table with one field is enough, but with time the project grows and he needs more stuff..Learn to use PhpMyAdmin or whatever software, I guess you'll be using PHP as the scripting/programming language for your project and after those tutorials, you can always browse the mysql documentation/manual, even though it is complicated for beginners, at least it was for me, but now when I browsed it and read and know how to use it, it isn't as complicated as I thought it is..

[pyost 0]

I don't think looking at other apps' source code is useful when starting with a new language. Sure, there might be some good examples, but the queries in such scripts tend to be rather complicated, therefore making it hard to understand. Only when you acquire an average level of SQL knowledge should you look at various pieces of code.

[SilverFox1405241541 0]

Thanks all.I already had a good understanding of databases in general from working with MSAccess and I'm already making progress on my project.phpMyAdmin that comes with Xisto is simply great.As for looking at other php code...that just is too much #### for me to filter. But I am looking at existing mysql dbs.

[develCuy 0]

Hi SilverFox!

 

MsAccess is very good to understand databases and their purpose. But please don't think that MySQL is similar only because is another "DB engine". MySQL is a multiplatform, multipurpose, fast and reliable DBMS. SQL queries have some important differences, then you have to study carefully the MySQL's SQL syntax, data types, relations, triggers and its essence. Put special attention on: GROUP and LIMIT.

 

My suggestion for a good start point is to study PostgreSQL or SQL Server, they respect the solid concepts that will help you to have a clear view of the what, how, why, where and for of DBMS.

 

Have a lot of fun on Database Modeling!!

[xiangqin 0]

i would also suggest http://www.mysql.com/.. this site is really a nice one.. it just doesn't give you the commands you need to know but also has interactivity, whereas you can answer the exercises given and practice what you have learned. This is where i learned how to use sql, better than school, reading and just writing...

[vizskywalker 0]

As mentioned above, go to the source. One of the best thing about widely used open source projects such as MySQL and PHP is that they are extremely well documented. The online documentation for MySQL is very well done and even includes a pretty good tutorial. I'm not great at making quieries, but I'm along the lines of an intermediate user. Everything I've done I've learned either indirectly from the forums here or online from the documentation.~Viz