SQL Quick Review/Reference

classic Classic list List threaded Threaded
18 messages Options
Reply | Threaded
Open this post in threaded view
|

SQL Quick Review/Reference

Amit Uttamchandani
Hey everyone,

Just got back into the world of SQL after being away for 5 years. This time I decided to jump in with SQLite. It really has me excited.

Anyways, I have done a lot database work but I seem to have forgotten a lot of the subtleties of database designs/schema.

I am wondering if any of you have been in a similar situation? Is there a set of documents/notes that you refer to? Something that covers SQL and database design in general?

For example, for Python I refer to "A Byte of Python" and for LaTex there is "The Not So Short Introduction to LaTeX." Something similar for SQL is what I am looking for.

I've googled around but I thought why not ask the SQL veterans here?

Thanks,
Amit
_______________________________________________
sqlite-users mailing list
[hidden email]
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Reply | Threaded
Open this post in threaded view
|

Re: SQL Quick Review/Reference

Neville Franks-3
For SQLite in particular "The Definitive Guide to SQLite" by Micahel
Owens is reasonably good. Unfortunately it has the worst index of any
book I can recall seeing, other than some Cook Books. This makes it
very difficult and frustrating to use as a Reference Book.

I also purchased "Beginning Database Design - from Novice to
Professional" by Clare Churcher, but found it to much of a beginners
book for my needs.


Saturday, April 12, 2008, 3:23:10 PM, you wrote:

AU> Hey everyone,

AU> Just got back into the world of SQL after being away for 5
AU> years. This time I decided to jump in with SQLite. It really has
AU> me excited.

AU> Anyways, I have done a lot database work but I seem to have
AU> forgotten a lot of the subtleties of database designs/schema.

AU> I am wondering if any of you have been in a similar
AU> situation? Is there a set of documents/notes that you refer to?
AU> Something that covers SQL and database design in general?

AU> For example, for Python I refer to "A Byte of Python" and for
AU> LaTex there is "The Not So Short Introduction to LaTeX." Something
AU> similar for SQL is what I am looking for.

AU> I've googled around but I thought why not ask the SQL veterans here?

AU> Thanks,
AU> Amit
AU> _______________________________________________
AU> sqlite-users mailing list
AU> [hidden email]
AU> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users



--
Best regards,
  Neville Franks, http://www.surfulater.com http://blog.surfulater.com
 

_______________________________________________
sqlite-users mailing list
[hidden email]
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Reply | Threaded
Open this post in threaded view
|

Re: SQL Quick Review/Reference

Rich Shepard
In reply to this post by Amit Uttamchandani
On Fri, 11 Apr 2008, Amit Uttamchandani wrote:

> Is there a set of documents/notes that you refer to? Something that covers
> SQL and database design in general?

Amit,

   I second the recommendation of Mike Owens' "The Definitive Guide to
SQLite" for detailed insight on this system. And it does have the worst
index of any technical book. (I wrote to the publisher about it but never
received any reply.)

   Now, for general information, nothing beats Rick F. van der Lans'
"Introduction to SQL, 4th Ed." He includes coverage of time-based database
applications (which applies to most business needs) which is not covered in
other books.

   Also, anything written by Joe Celko is worth reading and owning. The
latest edition of "SQL for Smarties" is very useful, as is his "SQL
Programming Style." He has a couple of other titles out, but they're not
applicable to my needs so I don't have them. Joe's been writing and teaching
about dbms for at least 25 years; I remember reading his columns in the mid-
to late-1980s.

HTH,

Rich

--
Richard B. Shepard, Ph.D.               |  Integrity            Credibility
Applied Ecosystem Services, Inc.        |            Innovation
<http://www.appl-ecosys.com>     Voice: 503-667-4517      Fax: 503-667-8863
_______________________________________________
sqlite-users mailing list
[hidden email]
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Reply | Threaded
Open this post in threaded view
|

Re: SQL Quick Review/Reference

Jay Kreibich
In reply to this post by Neville Franks-3
On Sat, Apr 12, 2008 at 05:23:55PM +1000, Neville Franks scratched on the wall:
> For SQLite in particular "The Definitive Guide to SQLite" by Micahel
> Owens is reasonably good. Unfortunately it has the worst index of any
> book I can recall seeing, other than some Cook Books. This makes it
> very difficult and frustrating to use as a Reference Book.

  It is, however, available on the Apress website in PDF format for 30%
  off the cover price.  A good PDF viewer with listed search results is
  almost better than an index.

  I purchased the hardback of this book some months ago only to
  discover the PDF version some weeks later.  In the end, I ended up
  buying them both.

   -j

--
Jay A. Kreibich < J A Y  @  K R E I B I.C H >

"'People who live in bamboo houses should not throw pandas.' Jesus said that."
   - "The Ninja", www.AskANinja.com, "Special Delivery 10: Pop!Tech 2006"
_______________________________________________
sqlite-users mailing list
[hidden email]
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Reply | Threaded
Open this post in threaded view
|

Re: SQL Quick Review/Reference

Puneet Kishor-2
In reply to this post by Amit Uttamchandani
On 4/12/08, Amit Uttamchandani <[hidden email]> wrote:

> Hey everyone,
>
>  Just got back into the world of SQL after being away for 5 years. This time I decided to jump in with SQLite. It really has me excited.
>
>  Anyways, I have done a lot database work but I seem to have forgotten a lot of the subtleties of database designs/schema.
>
>  I am wondering if any of you have been in a similar situation? Is there a set of documents/notes that you refer to? Something that covers SQL and database design in general?
>
>  For example, for Python I refer to "A Byte of Python" and for LaTex there is "The Not So Short Introduction to LaTeX." Something similar for SQL is what I am looking for.
>
>  I've googled around but I thought why not ask the SQL veterans here?
>


nothing against the other suggestions, but have you really Googled?
Lookee what I found

http://www.google.com/search?q=sql+tutorial

Honestly, there must be a bazillion SQL tutorials out there many of
which provide quite a good intro to the basic concepts. Try a few of
them.
_______________________________________________
sqlite-users mailing list
[hidden email]
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Reply | Threaded
Open this post in threaded view
|

Re: SQL Quick Review/Reference

Rich Shepard
In reply to this post by Jay Kreibich
On Sat, 12 Apr 2008, Jay A. Kreibich wrote:

>  I purchased the hardback of this book some months ago only to discover
>  the PDF version some weeks later.  In the end, I ended up buying them
>  both.

Jay,

   I have both, too. Yes, using the find function within xpdf does compensate
for the lack of index and I keep the digital version on my notebook for use
when I'm traveling. I still refer to the paper edition frequently here in
the office.

Rich

--
Richard B. Shepard, Ph.D.               |  Integrity            Credibility
Applied Ecosystem Services, Inc.        |            Innovation
<http://www.appl-ecosys.com>     Voice: 503-667-4517      Fax: 503-667-8863
_______________________________________________
sqlite-users mailing list
[hidden email]
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Reply | Threaded
Open this post in threaded view
|

Re: SQL Quick Review/Reference

Amit Uttamchandani
In reply to this post by Puneet Kishor-2
On Sat, 12 Apr 2008 10:40:43 -0400
"P Kishor" <[hidden email]> wrote:

> On 4/12/08, Amit Uttamchandani <[hidden email]> wrote:
> > Hey everyone,
> >
> >  Just got back into the world of SQL after being away for 5 years. This time I decided to jump in with SQLite. It really has me excited.
> >
> >  Anyways, I have done a lot database work but I seem to have forgotten a lot of the subtleties of database designs/schema.
> >
> >  I am wondering if any of you have been in a similar situation? Is there a set of documents/notes that you refer to? Something that covers SQL and database design in general?
> >
> >  For example, for Python I refer to "A Byte of Python" and for LaTex there is "The Not So Short Introduction to LaTeX." Something similar for SQL is what I am looking for.
> >
> >  I've googled around but I thought why not ask the SQL veterans here?
> >
>
>
> nothing against the other suggestions, but have you really Googled?
> Lookee what I found
>
> http://www.google.com/search?q=sql+tutorial
>
> Honestly, there must be a bazillion SQL tutorials out there many of
> which provide quite a good intro to the basic concepts. Try a few of
> them.

Thanks for the reply.

Yes, I googled using similar search terms that you gave and found a lot of resources. I read up on them but I just wanted an opinion from some of the users here. I never owned a SQL reference material before...so some of the recommendations definitely helped a lot.

Amit
_______________________________________________
sqlite-users mailing list
[hidden email]
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Reply | Threaded
Open this post in threaded view
|

Re: SQL Quick Review/Reference

Amit Uttamchandani
In reply to this post by Neville Franks-3
On Sat, 12 Apr 2008 17:23:55 +1000
Neville Franks <[hidden email]> wrote:

> For SQLite in particular "The Definitive Guide to SQLite" by Micahel
> Owens is reasonably good. Unfortunately it has the worst index of any
> book I can recall seeing, other than some Cook Books. This makes it
> very difficult and frustrating to use as a Reference Book.
>
> I also purchased "Beginning Database Design - from Novice to
> Professional" by Clare Churcher, but found it to much of a beginners
> book for my needs.
>
>

Thanks! This is exactly what I was looking for.

Amit
_______________________________________________
sqlite-users mailing list
[hidden email]
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Reply | Threaded
Open this post in threaded view
|

Re: SQL Quick Review/Reference

Clay Dowling
Amit Uttamchandani wrote:

>> I also purchased "Beginning Database Design - from Novice to
>> Professional" by Clare Churcher, but found it to much of a beginners
>> book for my needs.

Let me recommend SQL For Smarties as an excellent starting point.  The
book is perfectly suitable for beginners, but can take you all the way
to very advanced topics.  Probably one of the best computer books I have
purchased.

This isn't an SQLite specific book, by the way.  It's fairly generic, so
what you learn here will work elsewhere.

Clay Dowling
http://www.lazarusid.com
_______________________________________________
sqlite-users mailing list
[hidden email]
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Reply | Threaded
Open this post in threaded view
|

Re: SQL Quick Review/Reference

drgrep
In reply to this post by Rich Shepard
On Sat, Apr 12, 2008 at 9:36 AM, Rich Shepard <[hidden email]> wrote:
> On Fri, 11 Apr 2008, Amit Uttamchandani wrote:

>    I second the recommendation of Mike Owens' "The Definitive Guide to
>  SQLite" for detailed insight on this system. And it does have the worst
>  index of any technical book. (I wrote to the publisher about it but never
>  received any reply.)

I know I've said this before, but I just want to say it again because
it pains me that the index is so bad: I had absolutely nothing to do
with the index. While I was presented with the index to look over, I
only had about a day to provide any feedback and there were so many
other deadlines looming that I really only had about 30 minutes to
"read" the index.

I've been lobbying Apress to release the book in electronic form for
free. It's currently under consideration, but I've not heard anything
back yet.

-- Mike
_______________________________________________
sqlite-users mailing list
[hidden email]
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
ajm
Reply | Threaded
Open this post in threaded view
|

Re: SQL Quick Review/Reference

ajm
In reply to this post by Amit Uttamchandani
Mike:

As a purchaser of your Book, I think that perhaps you can have a copy of the book in plain text form.
Then, with a little effort can be made a index of words, and (also) perhaps it would be easier that Apress let you publish it.

In respect to the index creation I would help in that.

Adolfo.-----Original Message-----
From: Mike Owens [mailto:[hidden email]]
Sent: Monday, April 14, 2008 08:23 AM
To: 'General Discussion of SQLite Database'
Subject: Re: [sqlite] SQL Quick Review/Reference

I've been lobbying Apress to release the book in electronic form forfree.
It's currently under consideration, but I've not heard anythingback yet.
 Mike
_______________________________________________
sqlite-users mailing list
[hidden email]
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Reply | Threaded
Open this post in threaded view
|

Re: SQL Quick Review/Reference

Rich Shepard
In reply to this post by drgrep
On Mon, 14 Apr 2008, Mike Owens wrote:

> I know I've said this before, but I just want to say it again because it
> pains me that the index is so bad: I had absolutely nothing to do with the
> index. While I was presented with the index to look over, I only had about
> a day to provide any feedback and there were so many other deadlines
> looming that I really only had about 30 minutes to "read" the index.

Mike,

   I'm certainly not blaming you!

> I've been lobbying Apress to release the book in electronic form for free.
> It's currently under consideration, but I've not heard anything back yet.

   Well, since I've purchased both the dead tree and digital versions, that
won't help me.

   I wrote my book in LaTeX (using the LyX GUI front end which is highly
productive), and used the indexing feature to create the index. Before doing
so, I researched how to write an index, bought a book on the subject, and
read that before starting. It did take me several iterations before I was
satisfied, and I'm sure there are still deficiencies I did not catch.

   Putting out a supplemental index would be a very useful effort.

Rich

--
Richard B. Shepard, Ph.D.               |  Integrity            Credibility
Applied Ecosystem Services, Inc.        |            Innovation
<http://www.appl-ecosys.com>     Voice: 503-667-4517      Fax: 503-667-8863
_______________________________________________
sqlite-users mailing list
[hidden email]
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Reply | Threaded
Open this post in threaded view
|

Re: SQL Quick Review/Reference

Martin Jenkins-2
In reply to this post by drgrep
Mike Owens wrote:
> I've been lobbying Apress to release the book in electronic form for
> free. It's currently under consideration, but I've not heard anything
> back yet.
>  
That seems a bit extreme - how about a user generated/funded index on
the web somewhere?
Download and print a PDF, stick it in the back of the book and...

Martin
_______________________________________________
sqlite-users mailing list
[hidden email]
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Reply | Threaded
Open this post in threaded view
|

Re: SQL Quick Review/Reference

drgrep
On Mon, Apr 14, 2008 at 8:45 AM, Martin Jenkins <[hidden email]> wrote:
> Mike Owens wrote:
>  > I've been lobbying Apress to release the book in electronic form for
>  > free. It's currently under consideration, but I've not heard anything
>  > back yet.
>  >
>  That seems a bit extreme - how about a user generated/funded index on
>  the web somewhere?
>  Download and print a PDF, stick it in the back of the book and...

I wasn't referring to releasing the book as an exclusive solution to
the index problem, but rather for the community and SQLite in general.
Fixing the index issue would just be a nice dividend. I am indebted to
Apress for picking up the book and putting substantial resources into
making it a good book (they truly made it a much better book than it
ever would have been otherwise), and I would like to see them recoup
their costs and benefit in any way they so desire. But I couldn't care
less for any gain on my part. I wrote the book for SQLite. Don't get
me wrong, I jumped at the chance to write a book when offered to me,
but my main concern is that the book helps people and furthers the
project. As long as I can avoid getting vilified on Amazon, I'm happy.
Ultimately, I would love to see this book turn out like the "Dive Into
Python" book, which is available online, or the
Subversion/Samba/Asterisk books. I think it is in keeping with the
open source philosophy. But the decision in this case is not mine
alone to make. Regardless of their decision, I applaud Apress for
their continued efforts in supporting books on open source software,
and the people who reward their efforts by purchasing them.

-- Mike

On Mon, Apr 14, 2008 at 8:45 AM, Martin Jenkins <[hidden email]> wrote:

> Mike Owens wrote:
>  > I've been lobbying Apress to release the book in electronic form for
>  > free. It's currently under consideration, but I've not heard anything
>  > back yet.
>  >
>  That seems a bit extreme - how about a user generated/funded index on
>  the web somewhere?
>  Download and print a PDF, stick it in the back of the book and...
>
>  Martin
>
>
> _______________________________________________
>  sqlite-users mailing list
>  [hidden email]
>  http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
>
_______________________________________________
sqlite-users mailing list
[hidden email]
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Reply | Threaded
Open this post in threaded view
|

Re: SQL Quick Review/Reference

metro-2
is this what everybody is looking for??
http://booksforpeople.blogspot.com/2008/03/definitive-guide-to-sqlite-free-book.html
there are other sources  for free ebooks

Laurie


Mike Owens wrote:

> On Mon, Apr 14, 2008 at 8:45 AM, Martin Jenkins <[hidden email]> wrote:
>  
>> Mike Owens wrote:
>>  > I've been lobbying Apress to release the book in electronic form for
>>  > free. It's currently under consideration, but I've not heard anything
>>  > back yet.
>>  >
>>  That seems a bit extreme - how about a user generated/funded index on
>>  the web somewhere?
>>  Download and print a PDF, stick it in the back of the book and...
>>    
>
> I wasn't referring to releasing the book as an exclusive solution to
> the index problem, but rather for the community and SQLite in general.
> Fixing the index issue would just be a nice dividend. I am indebted to
> Apress for picking up the book and putting substantial resources into
> making it a good book (they truly made it a much better book than it
> ever would have been otherwise), and I would like to see them recoup
> their costs and benefit in any way they so desire. But I couldn't care
> less for any gain on my part. I wrote the book for SQLite. Don't get
> me wrong, I jumped at the chance to write a book when offered to me,
> but my main concern is that the book helps people and furthers the
> project. As long as I can avoid getting vilified on Amazon, I'm happy.
> Ultimately, I would love to see this book turn out like the "Dive Into
> Python" book, which is available online, or the
> Subversion/Samba/Asterisk books. I think it is in keeping with the
> open source philosophy. But the decision in this case is not mine
> alone to make. Regardless of their decision, I applaud Apress for
> their continued efforts in supporting books on open source software,
> and the people who reward their efforts by purchasing them.
>
> -- Mike
>
> On Mon, Apr 14, 2008 at 8:45 AM, Martin Jenkins <[hidden email]> wrote:
>  
>> Mike Owens wrote:
>>  > I've been lobbying Apress to release the book in electronic form for
>>  > free. It's currently under consideration, but I've not heard anything
>>  > back yet.
>>  >
>>  That seems a bit extreme - how about a user generated/funded index on
>>  the web somewhere?
>>  Download and print a PDF, stick it in the back of the book and...
>>
>>  Martin
>>
>>
>> _______________________________________________
>>  sqlite-users mailing list
>>  [hidden email]
>>  http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
>>
>>    
> _______________________________________________
> sqlite-users mailing list
> [hidden email]
> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
>
>  

_______________________________________________
sqlite-users mailing list
[hidden email]
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Reply | Threaded
Open this post in threaded view
|

Re: SQL Quick Review/Reference

Neville Franks-3
The book is sitting on a server in China and I would have to assume it
is an illegal copy. Not something folks here should be using.


Tuesday, April 15, 2008, 7:58:03 PM, you wrote:

m> is this what everybody is looking for??
m> http://booksforpeople.blogspot.com/2008/03/definitive-guide-to-sqlite-free-book.html
m> there are other sources  for free ebooks

m> Laurie


m> Mike Owens wrote:

>> On Mon, Apr 14, 2008 at 8:45 AM, Martin Jenkins <[hidden email]> wrote:
>>  
>>> Mike Owens wrote:
>>>  > I've been lobbying Apress to release the book in electronic form for
>>>  > free. It's currently under consideration, but I've not heard anything
>>>  > back yet.
>>>  >
>>>  That seems a bit extreme - how about a user generated/funded index on
>>>  the web somewhere?
>>>  Download and print a PDF, stick it in the back of the book and...
>>>    
>>
>> I wasn't referring to releasing the book as an exclusive solution to
>> the index problem, but rather for the community and SQLite in general.
>> Fixing the index issue would just be a nice dividend. I am indebted to
>> Apress for picking up the book and putting substantial resources into
>> making it a good book (they truly made it a much better book than it
>> ever would have been otherwise), and I would like to see them recoup
>> their costs and benefit in any way they so desire. But I couldn't care
>> less for any gain on my part. I wrote the book for SQLite. Don't get
>> me wrong, I jumped at the chance to write a book when offered to me,
>> but my main concern is that the book helps people and furthers the
>> project. As long as I can avoid getting vilified on Amazon, I'm happy.
>> Ultimately, I would love to see this book turn out like the "Dive Into
>> Python" book, which is available online, or the
>> Subversion/Samba/Asterisk books. I think it is in keeping with the
>> open source philosophy. But the decision in this case is not mine
>> alone to make. Regardless of their decision, I applaud Apress for
>> their continued efforts in supporting books on open source software,
>> and the people who reward their efforts by purchasing them.
>>
>> -- Mike
>>
>> On Mon, Apr 14, 2008 at 8:45 AM, Martin Jenkins <[hidden email]> wrote:
>>  
>>> Mike Owens wrote:
>>>  > I've been lobbying Apress to release the book in electronic form for
>>>  > free. It's currently under consideration, but I've not heard anything
>>>  > back yet.
>>>  >
>>>  That seems a bit extreme - how about a user generated/funded index on
>>>  the web somewhere?
>>>  Download and print a PDF, stick it in the back of the book and...
>>>
>>>  Martin
>>>
>>>
>>> _______________________________________________
>>>  sqlite-users mailing list
>>>  [hidden email]
>>>  http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
>>>
>>>    
>> _______________________________________________
>> sqlite-users mailing list
>> [hidden email]
>> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
>>
>>  

m> _______________________________________________
m> sqlite-users mailing list
m> [hidden email]
m> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users



--
Best regards,
  Neville Franks, http://www.surfulater.com http://blog.surfulater.com
 

_______________________________________________
sqlite-users mailing list
[hidden email]
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Reply | Threaded
Open this post in threaded view
|

Re: SQL Quick Review/Reference

Martin Jenkins-2
In reply to this post by drgrep
Mike Owens wrote:
>> Mike Owens wrote:
>>  > I've been lobbying Apress to release the book in electronic form for
>>  > free.
>>  That seems a bit extreme
> I wasn't referring to releasing the book as an exclusive solution to
> the index problem, but rather for the community and SQLite in general.
>  
That's fair enough - sorry for the misunderstanding on my part.
> Fixing the index issue would just be a nice dividend.
Indeed. I've not had any issues with it but I tend to remember roughly
where things are in books.
I read quickly so I don't mind reading a few extra pages - useful as a
refresher.
> making it a good book
I think it's a fine book. I know one or two "occasional" posters on this
list made some negative
comments (index issues apart) but I think they made a mistake and bought
the wrong book... ;)

Martin

_______________________________________________
sqlite-users mailing list
[hidden email]
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Reply | Threaded
Open this post in threaded view
|

Re: SQL Quick Review/Reference

Martin Jenkins-2
In reply to this post by metro-2
metro wrote:
> is this what everybody is looking for??
> http://booksforpeople.blogspot.com/2008/03/definitive-guide-to-sqlite-free-book.html
> there are other sources  for free ebooks
>
> Laurie
>  
It did the rounds on alt.binaries.e-book.technical last year. The
buyer's email address had been removed from
the page footers but otherwise it looked like my legit copy, ie it
wasn't a scan.

Martin
_______________________________________________
sqlite-users mailing list
[hidden email]
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users