|
|
 More Subcategories Available
| Databases [+] Favor-It | |
| |
 |
| | Sort By:
|
In this article you'll learn how to create database-enabled Ajax requests using PHP and MySQL. We begin by creating the front-end HTML and JavaScript files used to make requests to the server-side. Author: Kris Hadlock Code: PHP 4.0 |
Tableau Software is a provider of visual analysis and reporting tools. With Tableau, you can drill-down database tables, visually and in real time. This article explains how to most efficiently use the software in your database design and analysis. Author: Ben Lorica Code: PHP 4.0 |
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 |
Icon Key >
 - Recently Updated
 - Showcase Listing
|