SQL Textbook

From: Stéphane Faroult <sfaroult_at_roughsea.com>
Date: Mon, 08 Jul 2013 10:33:33 +0200
Message-ID: <51DA795D.6030103_at_roughsea.com>



Somewhat in line with the excellent quote recently found by Hemant in the 12c docs: "However,it is impossible to tune applications or a database without knowing SQL." I'm glad to tell that my SQL book for beginners (I take them rather far) is available on Amazon on schedule, even if the book is ultimately thicker than initially intended:  http://www.amazon.com/SQL-Success-Database-Programming-Proficiency/dp/1909765007/ I have tried to explain SQL the way I wish it had been explained to me when I started, which would have saved me a lot of time, and the way I wish it had been taught to quite a number of developers I have met. Even if this kind of thing isn't always immediately obvious from the table of contents, I believe that my approach is rather different from what I have seen elsewhere. I cover Oracle, of course, but also <smaller>DB2, PostgreSQL, MySQL</smaller>,<tiny>SQL Server</tiny> and <microscopic>SQLite</microscopic> - which was a bit challenging at times (date arithmetic or triggers, anyone?) About 10% of the book (the first five pages of each chapter) are freely available at http://edu.konagora.com, as well as all the code samples from the book. If you teach in a college or university, the full chapters and a lot of additional material are available in the member section (free, registration is to keep students out); I'm trying to help instructors give great courses and show students that databases are far from being as boring (and SQL as easy) as I thought when I graduated. Going to use the material myself to teach at a French school of engineering in September.

Enjoy,

-- 
Stephane Faroult
RoughSea Ltd <http://www.roughsea.com>
Konagora <http://www.konagora.com>
RoughSea Channel on Youtube <http://www.youtube.com/user/roughsealtd>


--
http://www.freelists.org/webpage/oracle-l
Received on Mon Jul 08 2013 - 10:33:33 CEST

Original text of this message