RE: SQL programming fundamentals
From: Harshan Vasudevan Eppurath <harshan.eppurath_at_capgemini.com>
Date: Fri, 12 Sep 2008 21:26:41 +0530
Message-ID: <8735BFE26A439443B4B315C1B37D3153159510@HYDEXC07.kanbay.com>
From: oracle-l-bounce@freelists.org on behalf of Jared Still
Sent: Fri 9/12/2008 8:59 PM
To: hkchital@singnet.com.sg
Cc: peter.robson@gmail.com; oracle-l@freelists.org
Subject: Re: SQL programming fundamentals
--
http://www.freelists.org/webpage/oracle-l
Received on Fri Sep 12 2008 - 10:56:41 CDT
Date: Fri, 12 Sep 2008 21:26:41 +0530
Message-ID: <8735BFE26A439443B4B315C1B37D3153159510@HYDEXC07.kanbay.com>
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@freelists.org on behalf of Jared Still
Sent: Fri 9/12/2008 8:59 PM
To: hkchital@singnet.com.sg
Cc: peter.robson@gmail.com; oracle-l@freelists.org
Subject: Re: SQL programming fundamentals
On Fri, Sep 12, 2008 at 7:46 AM, Hemant K Chitale <hkchital@singnet.com.sg> wrote:
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
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