Any and all advice is welcome.

Given someone that has an IT background but no specific database experience, what would you recommend they do to get started?

I'm looking specifically for books to read (if books are even a good idea), websites to check (this one for sure), and any other resources that would be helpful.

If you had it to do over, how would you learn it all over again?

asked 24 Sep '10, 20:14

Siger%20Matt's gravatar image

Siger Matt
3.2k496997
accept rate: 13%

edited 26 Sep '10, 11:06

Daz%20Liquid's gravatar image

Daz Liquid
861182338


Read the Help, especially the tutorials.

Buy the book: http://www.risingroad.com/SQL_Anywhere_Studio_9_Developers_Guide.html

Read the blogs. Start with http://sqlanywhere.blogspot.com/ then follow the links to other blogs (see the blogroll "Focusing on SQL Anywhere...").

Ask questions here... ANY and ALL questions are welcome as long as they have something to do with SQL Anywhere.

permanent link

answered 24 Sep '10, 20:45

Breck%20Carter's gravatar image

Breck Carter
26.9k438609883
accept rate: 21%

edited 25 Sep '10, 06:57

3

I second the book. It was a great help to a new member of our team.

(24 Sep '10, 22:37) Jen
1

I don't think there will be a need for any other answer :)

(25 Sep '10, 00:42) Calvin Allen
3

Note: The book and the blog are authored by Breck himself, so this may sound like an announcement. But by heart, it will be difficult to find anyone who is able to explain better than Breck does, and both with that clear opinion and much humour. This community (and me, too) owe him a lot. Definetely.

(25 Sep '10, 18:39) Volker Barth

Nicely said Volker.

(25 Sep '10, 19:57) Calvin Allen
1

Shocking self advertising by Breck :-) although at least he put the help & tutorials above the three things that belong to him :-) The only other thing you could do is spend some time with someone already using it, even then you won't pick up as much as following Breck's suggestions.

(26 Sep '10, 11:04) Daz Liquid

There are two key things that I think a student has to have to avoid floundering... a project, and a deadline.

It's really tough to sit down and just 'learn a product' I have countless examples of that in my own work. Without a specific project to give one's self some direction, the product is just too big.

And without a deadline, other projects seem to get in the way.

Many years ago (before Breck's awesome book which is already mentioned) I read a book called Joe Celko's SQL for Smarties... the edition I bought came with a CD containing a single user copy of SQL Anywhere. I don't know if the book is still available, but it's worth looking into.

There are really two things to learn for an IT guy with little db experience. One is the syntax of getting data in and out of the database and the associated apps (ISQL and Sybase Central) and admin stuff like backup and recovery.

The other is database design. I think the latter is far more difficult to learn -- or so it would seem based on the databases I've inherited. Proper database design comes easy to some, and for many others it seems to come easy, but they get it wrong, and they often don't discover that for months or years after the mistake was made -- when some new application requirement comes along that reveals the mistake and the requirement can't be made without a wholesale database design change.

Application programmers tend to design databases to make the current appliction project du jour easy to program, rather than long-term database design purity. Typical mistakes include breaking the basic normalization rules. It's something to watch for in code reviews.

permanent link

answered 26 Sep '10, 16:20

Ron%20Hiner's gravatar image

Ron Hiner
880202427
accept rate: 9%

In addition to Breck's suggestions (with which I fully agree):

It might seem superfluous to note that: Practise your SQL:

  • Follow the tutorials by copying the code and make some changes/enhancements, e.g. by variations.
  • Try to set up a simple database schema with a basic set of datatypes, connect tables by foreign keys, try usual query constructions with joins, group by and the like.
  • Over the course of time, try to find out what SQL features are best used in certain situations, i.e. when to use a group by, when to use a join vs. a subselect and the like.

That may sound like a hard way (and it is) but IMHO that's the (best?/real?) way to learn successfully.

The last point I mentioned is particularly important, methinks, because knowing one's set of tools is fine but knowing when to use each tool is the way to mastery... Whereas one would seldom try to use a screwdriver when a hammer is appropriate, I guess it's quite easy (and common) to use one SQL feature when another one would fit much better. In lots of cases the suboptimal feature will work but usually lead to worse performance.


That all being said, don't get me wrong - I'm still on that same journey, too, and hope this site will help me to improve my skills (well, it already does so).

And I feel there's much opportunity to add questions and answers to these topics "What SQL do I use to answer that kind of question?" here. A bunch of them comes to my mind immediately:)

permanent link

answered 26 Sep '10, 13:48

Volker%20Barth's gravatar image

Volker Barth
31.3k312458674
accept rate: 33%

Just to add: There's no need to learn all features at once - lots of (application) developers seem to get along just using SELECT ... FROM ... WHERE ... (i.e. even ommiting ORDER BY and the like). I don't think that's the way to go, but still they obviously get some work done:)

(27 Sep '10, 07:30) Volker Barth
Your answer
toggle preview

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text](http://url.com/ "title")
  • image?![alt text](/path/img.jpg "title")
  • numbered list: 1. Foo 2. Bar
  • to add a line break simply add two spaces to where you would like the new line to be.
  • basic HTML tags are also supported

Question tags:

×4
×3
×2
×1

question asked: 24 Sep '10, 20:14

question was seen: 1,732 times

last updated: 26 Sep '10, 16:20