Dec 22
Another 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
Dec 16
Another 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.
Nov 25
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.