RE: SQL programming fundamentals

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: oracle-l-bounce@xxxxxxxxxxxxx on behalf of Jared Still
Sent: Fri 9/12/2008 8:59 PM
To: hkchital@xxxxxxxxxxxxxx
Cc: peter.robson@xxxxxxxxx; oracle-l@xxxxxxxxxxxxx
Subject: Re: SQL programming fundamentals

On Fri, Sep 12, 2008 at 7:46 AM, Hemant K Chitale <hkchital@xxxxxxxxxxxxxx> 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

-- http://www.freelists.org/webpage/oracle-l

Other related posts: