HomeGroupsTalkMoreZeitgeist
This site uses cookies to deliver our services, improve performance, for analytics, and (if not signed in) for advertising. By using LibraryThing you acknowledge that you have read and understand our Terms of Service and Privacy Policy. Your use of the site and services is subject to these policies and terms.
Hide this

Results from Google Books

Click on a thumbnail to go to Google Books.

Learning SQL by Alan Beaulieu
Loading...

Learning SQL (edition 2009)

by Alan Beaulieu

MembersReviewsPopularityAverage ratingConversations
211193,232 (3.75)None
Updated for the latest database management systems -- including MySQL 6.0, Oracle 11g, and Microsoft's SQL Server 2008 -- this introductory guide will get you up and running with SQL quickly. Whether you need to write database applications, perform administrative tasks, or generate reports, Learning SQL, Second Edition, will help you easily master all the SQL fundamentals. Each chapter presents a self-contained lesson on a key SQL concept or technique, with numerous illustrations and annotated examples. Exercises at the end of each chapter let you practice the skills you learn. With this book, you will: Move quickly through SQL basics and learn several advanced features Use SQL data statements to generate, manipulate, and retrieve data Create database objects, such as tables, indexes, and constraints, using SQL schema statements Learn how data sets interact with queries, and understand the importance of subqueries Convert and manipulate data with SQL's built-in functions, and use conditional logic in data statements Knowledge of SQL is a must for interacting with data. With Learning SQL, you'll quickly learn how to put the power and flexibility of this language to work.… (more)
Member:BobCulley
Title:Learning SQL
Authors:Alan Beaulieu
Info:O'Reilly Media (2009), Edition: 2nd, Paperback, 338 pages
Collections:Your library
Rating:
Tags:None

Work details

Learning SQL by Alan Beaulieu

None.

None
Loading...

Sign up for LibraryThing to find out whether you'll like this book.

No current Talk conversations about this book.

On the whole I was very impressed with this book. It is, in my opinion, a very well paced tutorial introduction to working with SQL. In order to make examples that the reader can try out on their own computer and get the same results as the book, it is based throughout on MySQL (which is freely available), although it sticks as closely as possible to standard SQL and, where the common database managers (MySQL, Oracle, and Microsoft SQL Server, at any rate) diverge it provides notes about the differences and suggests references for further reading. Also, in order to avoid confusing the novice with details of too many different databases it uses a single database (for a bank) in all the examples. A copy of this database is available to download from the publisher's website, making it possible to try out all the examples and exercises in the book.

I have a few minor niggles. Firstly, there are a few places where the data in the version of the DB that I downloaded from the website seems to diverge from the version used in the book (most notably in the employee start dates), so a few of the queries don't produce the same results. Secondly, there are a few topics (such as user-defined variables) that get sneaked into some of the examples and exercise solutions without a proper explanation in the text (at least not one that I could find, having read the entire book fairly carefully and consulted the index). Thirdly, the book talks about MySQL 6.0 as the current version, while in February 2010 (some months after it was published) the most up-to-date version I could find was 5.5 - evidently 6.0 was pulled at the Alpha stage of development and has not yet been reintroduced (this is not a major problem, as everything covered in the book seems to work fine with MySQL 5). Finally, it's slightly Windows-centric as it does a couple of times refer to "your Windows box" and never mentions any other operating systems apart from a couple of references to mainframes. Fortunately I know my way round Linux well enough not to be phased by the lack of installation instructions for MySQL, but it could be an issue for less experienced users of non-Windows OSes. ( )
1 vote magnuscanis | Feb 16, 2010 |
"Learning SQL [second edition] does a good job of keeping things simple and to the point, never obfuscating topics in language likely to dazzle you. ... The best way to learn about SQL, and useful long after you've read it. 10/10"
added by legallypuzzled | editLinux Format, Andrew Hudson (Dec 25, 2009)
 
"Perhaps this book should have been called Get Better at SQL ... because it goes into every nook and cranny of SQL. ... [T]he examples are primarily focused on MySQL. ... Not an easy read, but packed with learning and great value for money. (7/10)"
added by legallypuzzled | editLinux Format, Paul Hudson (Jun 1, 2006)
 
You must log in to edit Common Knowledge data.
For more help see the Common Knowledge help page.
Canonical title
Original title
Alternative titles
Original publication date
People/Characters
Important places
Important events
Related movies
Awards and honors
Epigraph
Dedication
First words
Quotations
Last words
Disambiguation notice
Publisher's editors
Blurbers
Original language
Canonical DDC/MDS

References to this work on external resources.

Wikipedia in English

None

Updated for the latest database management systems -- including MySQL 6.0, Oracle 11g, and Microsoft's SQL Server 2008 -- this introductory guide will get you up and running with SQL quickly. Whether you need to write database applications, perform administrative tasks, or generate reports, Learning SQL, Second Edition, will help you easily master all the SQL fundamentals. Each chapter presents a self-contained lesson on a key SQL concept or technique, with numerous illustrations and annotated examples. Exercises at the end of each chapter let you practice the skills you learn. With this book, you will: Move quickly through SQL basics and learn several advanced features Use SQL data statements to generate, manipulate, and retrieve data Create database objects, such as tables, indexes, and constraints, using SQL schema statements Learn how data sets interact with queries, and understand the importance of subqueries Convert and manipulate data with SQL's built-in functions, and use conditional logic in data statements Knowledge of SQL is a must for interacting with data. With Learning SQL, you'll quickly learn how to put the power and flexibility of this language to work.

No library descriptions found.

Book description
Haiku summary

Quick Links

Popular covers

Rating

Average: (3.75)
0.5
1
1.5
2 2
2.5
3 6
3.5
4 9
4.5 1
5 4

O'Reilly Media

An edition of this book was published by O'Reilly Media.

» Publisher information page

Is this you?

Become a LibraryThing Author.

 

About | Contact | Privacy/Terms | Help/FAQs | Blog | Store | APIs | TinyCat | Legacy Libraries | Early Reviewers | Common Knowledge | 150,802,161 books! | Top bar: Always visible