How to Join Two Tables in a Relational Database
The power of a relational database such as Oracle, SQL Server, MySQL and Access is the ability to relate two or more tables based on common fields. Here is how you can join two tables on a common field. I am using MS Access's Northwind database ... [... more]
eHow |
How to Get the Maximum Value of a Field for Records in a ...
All relational databases offer the ability to return the maximum value of records being returned. For example, lets say you have a table that saves total sales for every day during the year. You can write a single SQL statement that will return ... [... more]
eHow |
How to Create and Design Multiple Relational Tables in ...
This quick and easy tutorial (Part 2) will teach you how to create multiple related tables as part of a relational database design in Microsoft Access. It will provide you with simple step-by-step instructions, including screenshots, for even a ... [... more]
eHow |
How to Become a SQL Programmer
An SQL programmer uses Structured Query Language to construct relational databases to assist companies in storing, tracking and interfacing different types of information. Of course, the role of the SQL programmer has expanded in recent years and ... [... more]
eHow |
How to Use Perl's Database Integration Interface
Whenever you are writing a large computer program, connecting to a relational database is a necessity. You can take advantage of Perl's predefined modules for connecting to a relational database if you're writing in Perl. Download Perl DBI module ... [... more]
eHow |
How to Use an If Statement in XML
XML has become one of the primary ways to store structured data for use on the Internet. Relational databases are another widely used data store. When using relational data, you can pick and choose what table records to extract by using the ... [... more]
eHow |
Foundation for Object / Relational Databases: The Third ...
 A serious, rigorous book about what a RDBMS should be.: Mr. Data and Mr. Darwen have much to say in this book. The question is will community of "database" people read it, assimilate it, and get to sufficient mass to discuss the merits of the [... more]
$44.95
Amazon.com |
How to Use Java JDBC With a Database
The relational database is the most commonly used data source in current technology. Powerful capabilities can be achieved by writing custom applications in Java, and connecting these applications to a data source such as a database. The ... [... more]
eHow |
Designing Relational Database Systems (Dv-Mps Designing)
Amazon.com Review: Because they're so complicated, many books on relational databases are either burdensomely academic (Database Management Systems is the classic example of this mode--it's superb, but one practically needs a professor to help you decode [... more]
$39.99
Amazon.com |
The Relational Database Dictionary
A serious treatment of database terminology...: I don't care how long you've been in IT... If you get into a conversation with a hard-core data modeler, they will have you lost in language in a matter of 10 minutes or less. If you want to understand the [... more]
$14.99
Amazon.com |
Introduction to SQL: Mastering the Relational Database ...
Outstanding: I ordered this book through amazon.com when there where no reviews-- took a chance and did it ever pay off. So now i'm writing a review for the next guy who is looking for a good book to get HANDS-ON sql experience with. You should have some [... more]
$49.99
Amazon.com |
Relational Database Design Clearly Explained, Second ...
Clearly mixed reviews: I have to give this book a very mixed review. As many reviewers pointed out, there were some errors at key points, which muddied things up for someone new to databases. There were a few places where pages were added with little [... more]
$54.95
Amazon.com |
