Posts Tagged MySQL

SQL For Beginners Part 2

previewAnother article published on Nettuts

http://net.tutsplus.com/tutorials/other/sql-for-beginners-part-2/

It is important for every web developer to be familiar with database interactions. In part two of the series, we will continue exploring the SQL language and apply what we’ve learned on a MySQL database. We will learn about Indexes, Data Types and more complex query structures.

Read More

Tags: , ,

SQL for Beginners

previewAnother article published on Nettuts

http://net.tutsplus.com/tutorials/other/sql-for-beginners/

Most modern web applications today interact with databases, usually with a language called SQL. Lucky for us, this language is quite easy to learn. In this article, we are going to start with some basic SQL queries and use them to interact with a MySQL database.

Read More

Tags: , ,

Top 20+ MySQL Best Practices

preview Nettuts+ just published my article!

http://net.tutsplus.com/tutorials/other/top-20-mysql-best-practices/

Database operations often tend to be the main bottleneck for most web applications today. It’s not only the DBA’s (database administrators) that have to worry about these performance issues. We as programmers need to do our part by structuring tables properly, writing optimized queries and better code. Here are some MySQL optimization techniques for programmers.

Read more

Tags: