Reputation:

Math needed for Sql Server

I've been working in Sql server jobs since 2 years now. Although I like it, sometimes I get the feeling that at certain times, I stall too much on some tasks, and I seem to be discouraged easily from things that involve relatively simple logic. It's like, at some point I must repeat a logical condition inside my head more than 2 or 3 times in order to understand it completely.

I have the feeling that this might be of my lack of math knowledge. Can anyone please let me know what area of mathematics I can study, that would improve my Sql server coding skills?

Thank you.

Upvotes: 2

Answers (5)

Nicholas Carey

Reputation: 74197

Get a copy of this book. It should prove to be most useful: The Art of SQL, by Stephane Faroult.

Upvotes: 0

Robb

Reputation: 3851

The field of maths most likely to be useful to you is Boolean logic

Set Theory is good for second place however it will often go into more detail that you are likely to need/use in understanding most sql queries.

A quick cheat that you may find useful is if you feed a boolean expression into wolfram alpha it will spit out a truth table for you which some find a much easier way of visualising the expression. http://www.wolframalpha.com/input/?i=a+or+not+b

Upvotes: 2

Bravax

Reputation: 10483

I'd suggest reading up on Set based Math.

See this link: http://weblogs.sqlteam.com/jeffs/archive/2007/04/30/thinking-set-based-or-not.aspx

Upvotes: 1

Philip Kelley

Reputation: 40309

Set theory helped me somewhat. Studied it in college years before I got into SQL, but being able to think of a bunch of numbers as a semi-amorphous blob of data and not as an ordered list of items really helps.

Upvotes: 0

Michael

Reputation: 784

I recommend you study symbolic logic.

Upvotes: 1

Math needed for Sql Server

Answers (5)

Related Questions