• Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Head First SQL - Relational Algebra & Calculus

 
Mihai Fonoage
Ranch Hand
Posts: 39
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
HI Lynn Beighley,

Do you link in your book SQL to Relational Algebra and/or Relational Calculus? Do you think it is important to understand those 2 topics in order to better grasp SQL?

Also, one of the operators of Relational Algebra, namely 'divideby', has not been implemented in SQL. Do you think it should be?

Thank you,
Mihai Fonoage
[ October 16, 2007: Message edited by: Mihai Fonoage ]
 
Lynn Beighley
author
Ranch Hand
Posts: 82
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Those are not covered. I don't think that they would add anything to this particular book, but rather muddy the SQL water. Perhaps in an advanced book...
 
Jeanne Boyarsky
author & internet detective
Marshal
Posts: 34071
331
Eclipse IDE Java VI Editor
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Originally posted by Mihai Fonoage:
Do you link in your book SQL to Relational Algebra and/or Relational Calculus? Do you think it is important to understand those 2 topics in order to better grasp SQL?

Another opinion on this: Personally, no. I did learn relational algebra and calculus in my db class. I learned SQL before that and find it perfectly possible to master without the theoretical basis.
 
Mihai Fonoage
Ranch Hand
Posts: 39
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Another opinion on this: Personally, no. I did learn relational algebra and calculus in my db class. I learned SQL before that and find it perfectly possible to master without the theoretical basis.

It would be interesting to hear from a person who was introduced to Relational Algebra first, then to SQL. I am not that person since I was exposed to SQL first also. I believe that if one knows Relational Algebra, it would be easier to learn SQL.

Mihai Fonoage
[ October 17, 2007: Message edited by: Mihai Fonoage ]
 
Debdutta Mohanty
Greenhorn
Posts: 5
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
In college we had the couse of RDBMS in one of the semesters and the firt couple of chapters were relational algebra, set theory, that made the concepts a lil easier, but I can't really say becos people without theory also seem to understand and implement really well.
 
Bear Bibeault
Author and ninkuma
Marshal
Pie
Posts: 64620
86
IntelliJ IDE Java jQuery Mac Mac OS X
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Debdutta Mohanty, Please use real words when posting to the forums. Abbreviations such as "becos" in place of "because" only serve to make your posts more difficult to read and less likely to generate useful responses.

Please read this for more information.

thanks,
bear
JavaRanch sheriff
 
Mihai Fonoage
Ranch Hand
Posts: 39
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
In college we had the couse of RDBMS in one of the semesters and the firt couple of chapters were relational algebra, set theory, that made the concepts a lil easier, but I can't really say becos people without theory also seem to understand and implement really well.

I'm not saying you can't learn/understand SQL if you don't know relational algebra, of course, I'm saying that I believe it is easier to learn and understand SQL if you do, since the operators part of the relational model where based on Relational Algebra.

Mihai Fonoage
 
Jeanne Boyarsky
author & internet detective
Marshal
Posts: 34071
331
Eclipse IDE Java VI Editor
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Originally posted by Mihai Fonoage:
I'm saying that I believe it is easier to learn and understand SQL if you do, since the operators part of the relational model where based on Relational Algebra.

That's true. Of course, it is also easier to learn and understand relational algebra if you already know SQL. It's usual for the second similar thing you learn to be easier.
 
Mihai Fonoage
Ranch Hand
Posts: 39
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Originally posted by Jeanne Boyarsky:

That's true. Of course, it is also easier to learn and understand relational algebra if you already know SQL. It's usual for the second similar thing you learn to be easier.

You are right, and it makes sense to be like this. Another example is C++ and Java. I also see this as more of a background problem: what is the necessary background one should have in order to better, and more faster, understand the new 'concepts'.

Mihai Fonoage
 
Jan Cumps
Bartender
Posts: 2584
11
C++ Linux Netbeans IDE
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Originally posted by Mihai Fonoage:

You are right, and it makes sense to be like this. Another example is C++ and Java. I also see this as more of a background problem: what is the necessary background one should have in order to better, and more faster, understand the new 'concepts'.

Mihai Fonoage
Not shure. Does one need to know c++ to be a good Java programmer? I would say no.

It's accademicaly sound to learn the relational theory before learning sql. That's how they teached it to me at school too.
But I think you can learn sql very well without knowing the relational thingies up front. You 'll get the skills on the fly.
I only became good in sql after school, when I had to use it professionaly.

Regards, Jan
 
Mihai Fonoage
Ranch Hand
Posts: 39
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Originally posted by Jan Cumps:
Not shure. Does one need to know c++ to be a good Java programmer? I would say no.

It's accademicaly sound to learn the relational theory before learning sql. That's how they teached it to me at school too.
But I think you can learn sql very well without knowing the relational thingies up front. You 'll get the skills on the fly.
I only became good in sql after school, when I had to use it professionaly.

Regards, Jan

No, but one that knows C++ and Java has an advantage over one that only knows one of them, and this is mainly because you know have an option to choose how to solve a particular problem, in C++ or Java. Is it easier to learn Java if you already know C++? Definitely. Is it impossible to learn Java if you don't know C++? Of course not. And the same goes for SQL and Relational Algebra.

Mihai Fonoage
 
Bear Bibeault
Author and ninkuma
Marshal
Pie
Posts: 64620
86
IntelliJ IDE Java jQuery Mac Mac OS X
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
If there is to be any further discussion regarding C++ and Java, please take it to a new post in another forum. Let's stay on topic in this thread.
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic