Jump to content
xisto Community
SilverFox1405241541

How To Learn Mysql?

Recommended Posts

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.

Share this post


Link to post
Share on other sites

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. B) RegardsYordan

Share this post


Link to post
Share on other sites

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,

Share this post


Link to post
Share on other sites

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..

Share this post


Link to post
Share on other sites

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.

Share this post


Link to post
Share on other sites

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.

Share this post


Link to post
Share on other sites

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!!

Share this post


Link to post
Share on other sites

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... ^_^

Share this post


Link to post
Share on other sites

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

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

×
×
  • Create New...

Important Information

Terms of Use | Privacy Policy | Guidelines | We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.