HomeGroupsTalkMoreZeitgeist
Search Site
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.

Results from Google Books

Click on a thumbnail to go to Google Books.

Loading...

Learning SQL

by Alan Beaulieu

Other authors: See the other authors section.

MembersReviewsPopularityAverage ratingConversations
284194,842 (3.75)None
As data floods into your company, you need to put it to work right away-and SQL is the best tool for the job. With the latest edition of this introductory guide, author Alan Beaulieu helps developers get up to speed with SQL fundamentals for writing database applications, performing administrative tasks, and generating reports. You'll find new chapters on SQL and big data, analytic functions, and working with very large databases. Each chapter presents a self-contained lesson on a key SQL concept or technique using numerous examples. Exercises let you practice the skills you learn. Knowledge of SQL is a must for interacting with data. With Learning SQL, you'll quickly discover how to put the power and flexibility of this language to work. - Move quickly through SQL basics and several advanced features - Use SQL data statements to generate, manipulate, and retrieve data - Create database objects, such as tables, indexes, and constraints with SQL schema statements - Learn how datasets interact with queries; understand the importance of subqueries - Convert and manipulate data with SQL's built-in functions and use conditional logic in data statements.… (more)
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)
 

» Add other authors (3 possible)

Author nameRoleType of authorWork?Status
Alan Beaulieuprimary authorall editionscalculated
Demarest, RebeccaIllustratorsecondary authorsome editionsconfirmed
Futato, DavidDesignersecondary authorsome editionsconfirmed
Montgomery, KarenCover designersecondary authorsome editionsconfirmed
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
Epigraph
Dedication
First words
Quotations
Last words
Disambiguation notice
Publisher's editors
Blurbers
Original language
Canonical DDC/MDS
Canonical LCC

References to this work on external resources.

Wikipedia in English

None

As data floods into your company, you need to put it to work right away-and SQL is the best tool for the job. With the latest edition of this introductory guide, author Alan Beaulieu helps developers get up to speed with SQL fundamentals for writing database applications, performing administrative tasks, and generating reports. You'll find new chapters on SQL and big data, analytic functions, and working with very large databases. Each chapter presents a self-contained lesson on a key SQL concept or technique using numerous examples. Exercises let you practice the skills you learn. Knowledge of SQL is a must for interacting with data. With Learning SQL, you'll quickly discover how to put the power and flexibility of this language to work. - Move quickly through SQL basics and several advanced features - Use SQL data statements to generate, manipulate, and retrieve data - Create database objects, such as tables, indexes, and constraints with SQL schema statements - Learn how datasets interact with queries; understand the importance of subqueries - Convert and manipulate data with SQL's built-in functions and use conditional logic in data statements.

No library descriptions found.

Book description
Haiku summary

Current Discussions

None

Popular covers

Quick Links

Rating

Average: (3.75)
0.5
1
1.5
2 2
2.5
3 8
3.5
4 10
4.5 1
5 5

Is this you?

Become a LibraryThing Author.

 

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