Free Programming Tutorials

One-to-manyThe one-to-many relationship is the workhorse of relational databases as well as being th

We’ve been focused on the data manipulation aspect of SQL for the past few months, which I hope ha

the WHERE clauseThe SQL WHERE clause accepts a number of comparison operators (Table 1) and Boolean

Fortunately, there is another possibility, and once again we will use techniques that are not availa

If you’ve read previous installments of this column, you’ve learned the basics of SQL for finding da

Your first relationshipThere is nothing magical, complex, or inherently hard about data relationship

PHP’s popularity stems from its power and flexibility: it is easy to includePHP scripts in HTML docu

Have you ever wanted to search text stored in your database, butcouldn’t figure out how to do it eff

Simple SELECTWe’ll be using the simple database we started with last week as a starting point for ou

Oracle introduced these functions early (with version 8.1.6, back in 1999 or about) and still offers