SQLite Forum

Suggestions for learning SQL(ite)

Suggestions for learning SQL(ite)

(1) By anonymous on 2021-12-01 05:41:46 [link] [source]

Hi, I am looking for suggestions on learning the basics of SQL, preferably in a SQLite-centric manner.

I am an experienced coder so I don't need a beginner's guide to hold my hand, what I need is a book of facts that will help me completely understand the syntax and workings of the language. I have tried several different websites which offer interactive lessons, but so far I am not liking the experience, I prefer doing exercise myself, by using the CLI.

So can anyone recommend me any learning material? Any books or articles which can bring me up to speed?

(2.1) Originally by anonymous with edits by Stephan Beal (stephan) on 2021-12-02 02:39:48 from 2.0 in reply to 1 [link] [source]

you might try SQLite Tutorial

[[Edited by Stephan to remove uncalled-for snideness.]]

(3) By anonymous on 2021-12-08 05:03:37 in reply to 1 [link] [source]


I'm a week late but seeing the request for recommendations I would like to recommend the second edition of The Definitive Guide to SQLite by Grant Allen and Mike Owens. Online tutorials can be helpful but having a physical book is hard to beat. Thanks to these authors wherever they are. (This book is also mentioned on the Books page at https://sqlite.org/books.html.)

In terms of learning SQL more generally, the Internet Archive has a free, on-line lending library with quite a few SQL books to borrow. Here is a link to a search:




(4.1) By Simon Slavin (slavin) on 2021-12-08 16:02:37 edited from 4.0 in reply to 1 [link] [source]

Something which can be useful in these posts is to tell us what your favoured programming language is, and anything else about what you already know. For instance, if you know Python, this is pretty good


A C programmer, on the other hand, might be more comfortable with this


It can also be useful to know if you're familiar with other SQL engines. I've seen pages that explain the differences between MySQL and SQLite, or between SQLServer and SQLite.

(5) By little-brother on 2021-12-08 17:43:06 in reply to 1 [source]

Check sql-ex. This is a site to learn SQL through task solving.