|
|
 More Subcategories Available
| Databases [+] Favor-It | |
| |
 |
| | Sort By:
|
Conventional wisdom claims that it's difficult to model hierarchical relationships in relationally minded SQL. In this article, Joe Celko explains how easy it can be to do just this using one method of representing trees in SQL. Author: Joe Celko Code: PHP 4.0 |
Crosstabs (or pivot tables) make it easier to normalize data into a database. This article explains how to use crosstab queries to display information and executing reporting tasks. Author: Giuseppe Maxia Code: PHP 4.0 |
Your database-backed application is too slow. Panic, upgrade, or rewrite? Steven Hauser suggests a more thoughtful approach: step back and consider the whole system. Then, do the simplest thing with the greatest potential payoff to make the most of tuning Author: Steven Hauser Code: PHP 4.0 |
| | |
Tips for Building Web Database Applications with PHP and MySQL by Hugh E. Williams contains eight tips for enhancing Web database applications by using the PHP scripting language and MySQL. Author: Hugh Williams Code: PHP 4.0 |
GUI-based database management tools are great, but it's also important to understand the broad strokes of directly manipulating database structure. John Paul Ashenfelter describes how to use SQL to define the database, its component tables, and more. Author: John Ashenfelter Code: PHP 4.0 |
SQL is based on relational algebra, and should come as no surprise that the standard contains several set-oriented operators. John Ashenfelter covers the topic in taking a look at the UNION operator. Author: John Ashenfelter Code: PHP 4.0 |
Subqueries are extremely useful in web-based database applications where you need to combine two queries and manually put them together to achieve a desired result. Subqueries allow SQL to do all of the heavy lifting to achieve the task. Author: John Ashenfelter Code: PHP 4.0 |
| | |
John Paul Ashenfelter looks at the "self-join," a tool that is particularly useful for certain situations, such as when you have a normalized database table that needs to be flattened. Author: John Ashenfelter Code: PHP 4.0 |
John Paul Ashenfelter covers the basics of using outer joins in SQL database programming. The SQL join effectively multiplies the row in one table by the rows in the other table that is participating in the join. Author: John Ashenfelter Code: PHP 4.0 |
Icon Key >
 - Recently Updated
 - Showcase Listing
|