Tutorials by ONLamp.com
John Paul Ashenfelter looks at how keys are used to construct relationships between tables in a relational database.
December 30,
2008
Today Views:
3 Total Views:
315
SQL databases can be filtered by virtually any set of criteria using a single clause. This week, John Paul Ashenfelter shows us how to use the SELECT command to return subsets of data.
December 29,
2008
Today Views:
4 Total Views:
271
In the last column, John Paul Ashenfelter showed you how to use inner joins and cross joins. This week he tackles outer joins.
December 26,
2008
Today Views:
4 Total Views:
274
How well are your database tables communicating with one another? This week John Paul discusses three key relationships: one to one, one to many, and many to many.
December 22,
2008
Today Views:
1 Total Views:
476
Normalizing data into a database saves you time and trouble representing information, but actually displaying and reporting that information is trickier.
December 19,
2008
Today Views:
1 Total Views:
360
Where are the all-in-one PHP frameworks that make building well-factored and maintainable applications as easy as building simple sites?
December 18,
2008
Today Views:
2 Total Views:
370
Having a successful web site can be a mixed blessing. It's nice to reach more people, but it's painful to run up against hardware limits. Fortunately, LAMP sites have several tuning options, from tweaking parameters to replacing components.
December 16,
2008
Today Views:
1 Total Views:
255
A new MySQL storage engine allows you to use tables in remote servers as if they were local. Unfortunately, the documentation doesn't explain much more than that.
December 15,
2008
Today Views:
2 Total Views:
320
We've spent a fair amount of time discussing how to get data out of MySQL. But can you enter data directly into this database? You can using the INSERT command.
December 10,
2008
Today Views:
1 Total Views:
366
Eww, statistics. Right? Not necessarily--for example, calculating the entropy of your web statistics can help you analyze trends and correlations.
December 9,
2008
Today Views:
3 Total Views:
452
