RE: SQL programming fundamentals

From: Harshan Vasudevan Eppurath <>
Date: Fri, 12 Sep 2008 21:26:41 +0530
Message-ID: <>

My understanding is that some mathematical background will help to better under realtional databases especially set theory.  I think it would be more in designing databases rather than writing sqls.
my 2 cents

From: on behalf of Jared Still
Sent: Fri 9/12/2008 8:59 PM
Subject: Re: SQL programming fundamentals

On Fri, Sep 12, 2008 at 7:46 AM, Hemant K Chitale <> wrote:

Some understanding that tables can be viewed as sets and SQL operations work on "sets" of data  instead of the "row-by-row" approach of procedural methods is quite desirable.  I've seen people floundering when they can't differentiate between the two.

That's the reply I was looking for.

It's more fundamental than understanding relational theory.

Getting past the hurtle of thinking in a row-by-row context
( slow-by-slow ala Tom Kyte) is probably the hardest concept
for procedural programmers to master.

Once you can think in terms of sets rather than rows, it all
becomes much clearer.

Jared Still
Certifiable Oracle DBA and Part Time Perl Evangelist

-- Received on Fri Sep 12 2008 - 10:56:41 CDT

Original text of this message