Re: Can someone suggest better resources for learning sqlite3? I wanted to use the Python library but I don't know sql.

Path	csiph.com!usenet.pasdenom.info!aioe.org!news.stack.nl!newsfeed.xs4all.nl!newsfeed4.news.xs4all.nl!xs4all!newsgate.cistron.nl!newsgate.news.xs4all.nl!post.news.xs4all.nl!not-for-mail
Return-Path	<skip.montanaro@gmail.com>
X-Original-To	python-list@python.org
Delivered-To	python-list@mail.python.org
X-Spam-Status	OK 0.052
X-Spam-Evidence	'H': 0.90; 'S': 0.00; 'subject:Python': 0.06; 'plenty': 0.07; 'cc:addr:python-list': 0.11; 'suggest': 0.14; 'books': 0.15; 'from:addr:pobox.com': 0.16; 'from:addr:skip': 0.16; 'subject: \n ': 0.16; 'subject:library': 0.16; 'subject:sqlite3': 0.16; 'work.)': 0.16; 'language': 0.16; 'sender:addr:gmail.com': 0.17; 'cc:addr:python.org': 0.22; 'skip': 0.24; "haven't": 0.24; 'cc:2**0': 0.24; 'query': 0.26; 'header:In- Reply-To:1': 0.27; 'especially': 0.30; 'message- id:@mail.gmail.com': 0.30; 'work.': 0.31; 'helpful.': 0.31; 'subject:learning': 0.31; 'award': 0.32; 'subject:the': 0.34; "can't": 0.35; 'received:google.com': 0.35; 'building': 0.35; 'there': 0.35; "i'll": 0.36; 'behind': 0.37; 'changed': 0.39; 'easy': 0.60; 'subject:? ': 0.60; 'subject:Can': 0.60; 'desk': 0.61; 'new': 0.61; 'first': 0.61; 'name': 0.63; 'developed': 0.63; 'refer': 0.63; 'to:addr:gmail.com': 0.65; 'subject.': 0.74; 'badly,': 0.84; 'subject:know': 0.84; 'textbook': 0.84
DKIM-Signature	v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20120113; h=mime-version:sender:in-reply-to:references:date:message-id:subject :from:to:cc:content-type; bh=WOJy6+CNwmv+w/UOvIPK6Wz2R1/p4BajHsWepcbrg3U=; b=kT2FpqRugMYurfd/EUV+3724ZWLZj3DrXlhtqCogvXcLXC63wuUZHl+Lj8LfG77VUQ f4d+MA5lPZft2rdk0IOg05IihUkUSRolEMmhRypdKtzz4AvtsOwZ2x+M4Lt01A5R9rs7 NDNXEN5zUnx9R1c2vxV9iCK/XhE5v5OXM+RPxgKDitMDlBcpTwppgnfLHZkD7QEPiQbJ dxTJMSQYvmkqBpQttfbZ4X9MfeysHNpY5sGV23WcU4EEoIkHlFRVMokTupKrJFUtLlIV Ae17f8d0c2GyyQakMvMEv0+ITZJpdjSG7gNa0ZKpQnW2plPUfAA9qgDqgg1B3USO6nKo gZHQ==
MIME-Version	1.0
X-Received	by 10.43.14.74 with SMTP id pp10mr185702icb.87.1375873185365; Wed, 07 Aug 2013 03:59:45 -0700 (PDT)
Sender	skip.montanaro@gmail.com
In-Reply-To	<2183b50a-b3d7-459f-bc00-5868fba5c7c3@googlegroups.com>
References	<2183b50a-b3d7-459f-bc00-5868fba5c7c3@googlegroups.com>
Date	Wed, 7 Aug 2013 05:59:45 -0500
X-Google-Sender-Auth	sNgg6nfHRwZvqYL1idFFPOcJ_wo
Subject	Re: Can someone suggest better resources for learning sqlite3? I wanted to use the Python library but I don't know sql.
From	Skip Montanaro <skip@pobox.com>
To	Aseem Bansal <asmbansal2@gmail.com>
Content-Type	text/plain; charset=UTF-8
Cc	Python <python-list@python.org>
X-BeenThere	python-list@python.org
X-Mailman-Version	2.1.15
Precedence	list
List-Id	General discussion list for the Python programming language <python-list.python.org>
List-Unsubscribe	<http://mail.python.org/mailman/options/python-list>, <mailto:python-list-request@python.org?subject=unsubscribe>
List-Archive	<http://mail.python.org/pipermail/python-list/>
List-Post	<mailto:python-list@python.org>
List-Help	<mailto:python-list-request@python.org?subject=help>
List-Subscribe	<http://mail.python.org/mailman/listinfo/python-list>, <mailto:python-list-request@python.org?subject=subscribe>
Newsgroups	comp.lang.python
Message-ID	<mailman.313.1375873194.1251.python-list@python.org> (permalink)
Lines	15
NNTP-Posting-Host	2001:888:2000:d::a6
X-Trace	1375873194 news.xs4all.nl 15910 [2001:888:2000:d::a6]:40593
X-Complaints-To	abuse@xs4all.nl
Xref	csiph.com comp.lang.python:52130

Show key headers only | View raw

> Can someone suggest me better resources for learning sql/sqlite3?

The concepts behind the Structured Query Language haven't changed much
since Edgar Codd first developed them in the 1970s.  (He received the
Turing Award in 1981 for this work.)

Building and querying databases is very easy to do very badly,
especially if you are new to its concepts.  This is a case where a
textbook might be helpful. Since these ideas have been around for a
long while, there are plenty of good books on the subject. I have one
on my desk at work whose name I can't remember off the top of my head.
 I still refer to it from time-to-time.  If you'd like a reference,
let me know and I'll check on it at work.

Skip

Thread

csiph-web