Klik på en miniature for at gå til Google Books
|
Indlæser... Learning SQL (udgave 2005)af Alan Beaulieu
Work InformationLearning SQL af Alan Beaulieu
   Ingen Der er ingen diskussionstråde på Snak om denne bog. 1   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"  "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)"
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. |
Current DiscussionsIngenPopulære omslag
 Google Books — Indlæser...GenrerMelvil Decimal System (DDC)005.133Information Computing and Information Computer programming, programs, data, security Programming Languages General Programming LanguagesLC-klassificeringVurderingGennemsnit: (3.75)
Er det dig?Bliv LibraryThing-forfatter. |
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
2
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. (