SQL Cookbook (Cookbooks (O'Reilly)) und über 1,5 Millionen weitere Bücher verfügbar für Amazon Kindle. Erfahren Sie mehr

Neu kaufen

oder
Loggen Sie sich ein, um 1-Click® einzuschalten.
oder
Mit kostenloser Probeteilnahme bei Amazon Prime. Melden Sie sich während des Bestellvorgangs an.
Gebraucht kaufen
Gebraucht - Gut Informationen anzeigen
Preis: EUR 18,38

oder
 
   
Jetzt eintauschen
und EUR 6,45 Gutschein erhalten
Eintausch
Alle Angebote
Möchten Sie verkaufen? Hier verkaufen
Der Artikel ist in folgender Variante leider nicht verfügbar
Keine Abbildung vorhanden für
Farbe:
Keine Abbildung vorhanden

 
Beginnen Sie mit dem Lesen von SQL Cookbook (Cookbooks (O'Reilly)) auf Ihrem Kindle in weniger als einer Minute.

Sie haben keinen Kindle? Hier kaufen oder eine gratis Kindle Lese-App herunterladen.

SQL Cookbook (Cookbooks (O'Reilly)) [Englisch] [Taschenbuch]

Anthony Molinaro
4.3 von 5 Sternen  Alle Rezensionen anzeigen (3 Kundenrezensionen)
Preis: EUR 24,95 kostenlose Lieferung. Siehe Details.
  Alle Preisangaben inkl. MwSt.
o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o
Nur noch 6 auf Lager (mehr ist unterwegs).
Verkauf und Versand durch Amazon. Geschenkverpackung verfügbar.
Lieferung bis Montag, 25. August: Wählen Sie an der Kasse Morning-Express. Siehe Details.

Weitere Ausgaben

Amazon-Preis Neu ab Gebraucht ab
Kindle Edition EUR 17,30  
Taschenbuch EUR 24,95  

Kurzbeschreibung

3. Januar 2006 Cookbooks (O'Reilly)
You know the rudiments of the SQL query language, yet you feel you aren't taking full advantage of SQL's expressive power. You'd like to learn how to do more work with SQL inside the database before pushing data across the network to your applications. You'd like to take your SQL skills to the next level. Let's face it, SQL is a deceptively simple language to learn, and many database developers never go far beyond the simple statement: SELECT columns FROM table WHERE conditions. But there is so much more you can do with the language. In the SQL Cookbook, experienced SQL developer Anthony Molinaro shares his favorite SQL techniques and features. You'll learn about: * Window functions, arguably the most significant enhancement to SQL in the past decade. If you're not using these, you're missing out * Powerful, database-specific features such as SQL Server's PIVOT and UNPIVOT operators, Oracle's MODEL clause, and PostgreSQL's very useful GENERATE_SERIES function * Pivoting rows into columns, reverse-pivoting columns into rows, using pivoting to facilitate inter-row calculations, and double-pivoting a result set * Bucketization, and why you should never use that term in Brooklyn. * How to create histograms, summarize data into buckets, perform aggregations over a moving range of values, generate running-totals and subtotals, and other advanced, data warehousing techniques * The technique of walking a string, which allows you to use SQL to parse through the characters, words, or delimited elements of a string Written in O'Reilly's popular Problem/Solution/Discussion style, the SQL Cookbook is sure to please. Anthony's credo is: "When it comes down to it, we all go to work, we all have bills to pay, and we all want to go home at a reasonable time and enjoy what's still available of our days." The SQL Cookbook moves quickly from problem to solution, saving you time each step of the way.

Wird oft zusammen gekauft

SQL Cookbook (Cookbooks (O'Reilly)) + SQL Antipatterns: Avoiding the Pitfalls of Database Programming (Pragmatic Programmers) + Seven Databases in Seven Weeks: A Guide to Modern Databases and the NoSQL Movement
Preis für alle drei: EUR 72,85

Die ausgewählten Artikel zusammen kaufen

Kunden, die diesen Artikel gekauft haben, kauften auch


Produktinformation

  • Taschenbuch: 633 Seiten
  • Verlag: O'Reilly & Associates; Auflage: 1 (3. Januar 2006)
  • Sprache: Englisch
  • ISBN-10: 0596009763
  • ISBN-13: 978-0596009762
  • Größe und/oder Gewicht: 23,1 x 17,5 x 3,6 cm
  • Durchschnittliche Kundenbewertung: 4.3 von 5 Sternen  Alle Rezensionen anzeigen (3 Kundenrezensionen)
  • Amazon Bestseller-Rang: Nr. 26.078 in Fremdsprachige Bücher (Siehe Top 100 in Fremdsprachige Bücher)

Mehr über den Autor

Entdecken Sie Bücher, lesen Sie über Autoren und mehr

Produktbeschreibungen

Synopsis

You know the rudiments of the SQL query language, yet you feel you aren't taking full advantage of SQL's expressive power. You'd like to learn how to do more work with SQL inside the database before pushing data across the network to your applications. You'd like to take your SQL skills to the next level. Let's face it, SQL is a deceptively simple language to learn, and many database developers never go far beyond the simple statement: select from where. But, there is so much more you can do with the language. In the "SQL Cookbook", experienced SQL developer Anthony Molinaro shares his favorite SQL techniques and features.

You'll learn about: Window functions, arguably the most significant enhancement to SQL in the past decade - if you're not using these, you're missing out; powerful, database-specific features, such as SQL Server's PIVOT and UNPIVOT operators, Oracle's MODEL clause, and PostgreSQL's very useful GENERATE_SERIES function; pivoting rows into columns, reverse-pivoting columns into rows, using pivoting to facilitate inter-row calculations, and double-pivoting a result set; bucketization, and why you should never use that term in Brooklyn; how to create histograms, summarize data into buckets, perform aggregations over a moving range of values, generate running-totals and subtotals, and other advanced, data warehousing techniques; and the technique of walking a string, which allows you to use SQL to parse through the characters, words, or delimited elements of a string. Written in O'Reilly's popular Problem/Solution/Discussion style, the "SQL Cookbook" is sure to please. Anthony's credo is: "When it comes down to it, we all go to work, we all have bills to pay, and we all want to go home at a reasonable time and enjoy what's still available of our days."

"The SQL Cookbook" moves quickly from problem to solution, saving you time each step of the way.

Über den Autor und weitere Mitwirkende

Anthony Molinaro is a database developer at Wireless Generation. His interests include databases, databases, and, oh yeah... databases. He currently resides in Baltimore, Maryland with Georgia, his fiancee and favorite periodontist.

Welche anderen Artikel kaufen Kunden, nachdem sie diesen Artikel angesehen haben?


In diesem Buch (Mehr dazu)
Mehr entdecken
Wortanzeiger
Ausgewählte Seiten ansehen
Buchdeckel | Copyright | Inhaltsverzeichnis | Auszug | Stichwortverzeichnis | Rückseite
Hier reinlesen und suchen:

Kundenrezensionen

4 Sterne
0
2 Sterne
0
1 Sterne
0
4.3 von 5 Sternen
4.3 von 5 Sternen
Die hilfreichsten Kundenrezensionen
5 von 5 Kunden fanden die folgende Rezension hilfreich
5.0 von 5 Sternen Hervorragend! 22. Juli 2007
Von U. Peschl
Format:Taschenbuch
Dieses Buch ist ein vollständiges, gut strukturiertes Nachschlagewerk. Es liefert zu jeder erdenklichen Praxis-Aufgabe eine SQL-Lösung für die bekannten Datenbanken SQL-Server, PostgeSQL, Oracle MySQL und DB2. Der Lösungsweg wird anhand von Beispielen Schritt für Schritt mit Teilergebnissen erklärt, so daß jede Datenbank-Anfrage verständlich wird. Ebenfalls werden die neuesten Datenbank SQL-Features der verschiedenen Hersteller beleuchtet. Auch dem Thema Reporting und Warehousing ist ein umfangreiches Kapitel gewidmet. Ein Muß für jeden Datenbankanwendungsentwickler!
War diese Rezension für Sie hilfreich?
2 von 2 Kunden fanden die folgende Rezension hilfreich
5.0 von 5 Sternen Unverzichtbar 18. Juni 2009
Von Myles
Format:Taschenbuch
Im Grunde gibt es zu diesem Buch wenig zu sagen. Drin ist genau das, was drauf steht - und das in Perfektion. Sauber angeordnet, absolut praxisrelevant, fast immer vollständig (oder zumindest alle meine Fragen beantwortend), gut zu lesen und zu verstehen.
Irgendwo ist es erschreckend, wie selten man solche Fachbücher findet, die einfach nur genauso sind, wie sie sein sollten. Aber gerade deshalb: Volle Punktzahl.
War diese Rezension für Sie hilfreich?
3.0 von 5 Sternen Hilfreich 19. April 2013
Von Tigerxxl
Format:Taschenbuch|Verifizierter Kauf
Dieses Buch ist für mich zum Wiederauffrischen meiner SQL-Kenntnisse wertvoll.
Enthält gute Tipps. Ist zwar nicht mehr ganz uptodate aber das merkt man dann als Lerneffekt.
War diese Rezension für Sie hilfreich?
Die hilfreichsten Kundenrezensionen auf Amazon.com (beta)
Amazon.com: 4.6 von 5 Sternen  69 Rezensionen
66 von 68 Kunden fanden die folgende Rezension hilfreich
4.0 von 5 Sternen Excellent book on SQL and the platforms recognized in this book! 19. Januar 2006
Von Rob Wehrli - Veröffentlicht auf Amazon.com
Format:Taschenbuch
This book is just fantastic. One really needs to read the inside cover pages to see what this book doesn't try to do. The relevant elements are:

Non-political (on several SQL-specific fronts)

Non-Pure ANSI (portability versus vendor-specific features)

Non-platform (I couldn't find a mention of a particular platform)

Basically, the book focuses on how to accomplish numerous SQL tasks using SQL and those features found on some of the top RDBMS vendors' products. It is selective in that the focus is constrained to MS SQL (platform obvious, but not mentioned that I could find) Server, DB2, MySQL, PostgresSQL and Oracle. I think that this well represents at least the 80/20 rule of who's running what RDBMS.

The book is a set of recipes for (usually) each of these platforms. Each recipe is a code-demonstrated "how-to" for accomplishing the given task. This is perfect for those who don't want to become DBAs and focus on learning "too" much about SQL, rather, want to use an example in their code to make it do the right thing.

The book is very well written and finished. It is a joy to read.

The one detraction that I can think of is that it would be nice to see all of the examples online at O'Reilly's web site so that we could "play around with them" somewhat without having to enter the database table contents and all of the SQL by hand. It "ain't that hard," but who's got the time to do it? I think that having the code available with the book would make it an excellent training tool for newcomers to SQL and those switching to a different product such as going from Oracle or MS SQL to MySQL or PostgresSQL. However, as it is, the book is a 4.5 stars product. If you're interested solely in MySQL, check out the MySQL Cookbook from O'Reilly.
45 von 45 Kunden fanden die folgende Rezension hilfreich
5.0 von 5 Sternen Mind-expanding 9. Mai 2007
Von M. Schwarz - Veröffentlicht auf Amazon.com
Format:Taschenbuch
It doesn't take long to learn the basics of SQL. Once you start to do multi-table joins and you get to sub-selects and outer joins you can almost convince yourself you are an expert. Trust me. You aren't. I've read at least ten books on using SQL. This is the first one to blow my horizons away and open a completely new landscape.

The "recipies" are well explained and almost entirely practical and useful. This book showed me dozens of things I did not ever think of using SQL for, even though I have the BNF for SQL pretty much in my head after more than 18 years of being a practicing programmer.

Before this book I used to recommend "generic" SQL books to students and newbies because such books apply to virtually all SQL databases and it can be harmful for one to use a specific "dialect" (such as Oracle or SQL Server) that won't port to other SQL databases. I would urge people to learn "generic" SQL. You can always add the features of you specific dialect, but it is hard to give up features you assume will be in all dialects.

This book neatly avoids that problem by providing dialect-specific sections when you can or must code differently for a particular database. Even better, they explain the differences and the pros and cons of those differences. So this book can even be an aid to selecting the "right" database for your application.

I happen to be a fan of Open Source and Free Software and I'm pleased to say that this book covers both MySQL and PostgreSQL. Naturally it provides the "big three" of Oracle, Microsoft SQL Server, and IBM's DB2.

This book really opened my eyes to possibilities in SQL that I really didn't know existed in spite of the fact that I have been using the language (apparently without mastering it) for almost two decades.

I still recommend using a "generic SQL" book to learn the basics, but this should literally be ordered at the same time. It is the best of the "Cookbook" series that I have seen. (And I have used the Java Cookbook, Perl Cookbook, and Python Cookbook).
53 von 54 Kunden fanden die folgende Rezension hilfreich
5.0 von 5 Sternen Good tutorial on and selection of recipes solving problems with SQL 8. Januar 2007
Von calvinnme - Veröffentlicht auf Amazon.com
Format:Taschenbuch
Ultimately, the goal of this book is to give you a glimpse of what can be done using SQL outside of what is considered the typical SQL problem domain. This text is unique in that the target audience is wide, incorporating all levels of SQL programmers as well as those who are completely unfamiliar with SQL.

Both complex and simple solutions are provided, and solutions for five different vendors are available when a common solution does not exist. These five databases are DB2 v.8, Oracle Database 10g (with the exception of a handful of recipes, the solutions will work for Oracle8i Database and Oracle9i Database as well), PostgreSQL 8, SQL Server 2005 and MySQL 5. All of the examples are built around a small set of tables containing employee data. This helps the reader get familiar with the example data, so that, having become familiar with the data, you can focus on the technique that each recipe illustrates.

Chapter 1, Retrieving Records, introduces very simple queries. Examples include how to use a WHERE clause to restrict rows from your result set, providing aliases for columns in your result set, using an inline view to reference aliased columns, using simple conditional logic, limiting the number of rows returned by a query, returning random records, and finding NULL values. Most of the examples are very simple, but some of them appear in later more complex recipes, so it's a good idea to read this chapter if you're relatively new to SQL or aren't familiar with any of the examples listed for this chapter.

Chapter 2, Sorting Query Results, introduces recipes for sorting query results. The ORDER BY clause is introduced and is used to sort query results. Examples increase in complexity ranging from simple, single-column ordering, to ordering by substrings, to ordering based on conditional expressions.

Chapter 3, Working with Multiple Tables, introduces recipes for combining data from multiple tables. If you are new to SQL or are a bit rusty on joins, this is a good chapter to read before going on to Chapter 5 and later. Joining tables is what SQL is all about; you must understand joins to be successful. Examples in this chapter include performing both inner and outer joins, identifying Cartesian productions, basic set operations (set difference, union, intersection), and the effects of joins on aggregate functions.

Chapter 4, Inserting, Updating, Deleting, introduces recipes for inserting, updating, and deleting data, respectively. Most of the examples are very straightforward, perhaps even pedestrian. Nevertheless, operations such as inserting rows into one table from another table, the use of correlated subqueries in updates, an understanding of the effects of NULLs, and knowledge of new features such as multi-table inserts and the MERGE command are extremely useful for your toolbox.

Chapter 5, Metadata Queries, introduces recipes for getting at your database metadata. It's often very useful to find the indexes, constraints, and tables in your schema. The simple recipes here allow you to gain information about your schema. Additionally, "dynamic" SQL examples are shown here as well, i.e., SQL generated by SQL.

Chapter 6, Working with Strings, introduces recipes for manipulating strings. SQL is not known for its string parsing capabilities, but with a little creativity, usually involving Cartesian products, along with the vast array of vendor-specific functions, you can accomplish quite a bit. Some of the more interesting examples include counting the occurrences of a character in a string, creating delimited lists from table rows, converting delimited lists and strings into rows, and separating numeric and character data from a string of alphanumeric characters.

Chapter 7, Working with Numbers, introduces recipes for common number crunching. You'll learn how easily window functions solve problems involving moving calculations and aggregations. Examples include creating running totals; finding mean, median, and mode; calculating percentiles; and accounting for NULL while performing aggregations.

Chapter 8, Date Arithmetic, is the first of two chapters dealing with dates. Being able to perform simple date arithmetic is crucial to everyday tasks. Examples include determining the number of business days between two dates, calculating the difference between two dates in different units of time (day, month, year, etc.), and counting occurrences of days in a month.

Chapter 9, Date Manipulation, is the second of the two chapters dealing with dates. In this chapter you will find recipes for some of the most common date operations you will encounter in a typical work day. Examples include returning all days in a year, finding leap years, finding first and last days of a month, creating a calendar, and filling in missing dates for a range of dates.

Chapter 10, Working with Ranges, introduces recipes for identifying values in ranges, and for creating ranges of values. Examples include automatically generating a sequence of rows, filling in missing numeric values for a range of values, locating the beginning and end of a range of values, and locating consecutive values.

Chapter 11, Advanced Searching, introduces recipes that are crucial for everyday development and yet sometimes slip through the cracks. These recipes are not any more difficult than others, yet many developers make very inefficient attempts at solving the problems these recipes solve. Examples from this chapter include finding knight values, paginating through a result set, skipping rows from a table, finding reciprocals, selecting the top n records, and ranking results.

Chapter 12, Reporting and Warehousing, introduces queries typically used in warehousing or generating complex reports. Examples include converting rows into columns and vice versa (cross-tab reports), creating buckets or groups of data, creating histograms, calculating simple and complete subtotals, performing aggregations over a moving window of rows, and grouping rows based on given units of time.

Chapter 13, Hierarchical Queries, introduces hierarchical recipes. Regardless of how your data is modeled, at some point you will be asked to format data such that it represents a tree or parent-child relationship. This chapter provides recipes accomplishing these tasks. Creating tree-structured result sets can be cumbersome with traditional SQL, so vendor-supplied functions are particularly useful in this chapter. Examples include expressing a parent-child relationship, traversing a hierarchy from root to leaf, and rolling up a hierarchy.

Chapter 14, Odds 'n' Ends, is a collection of miscellaneous recipes that didn't fit into any other problem domain, but that nevertheless are interesting and useful. This chapter is different from the rest in that it focuses on vendor-specific solutions only. This is the only chapter of the book where each recipe highlights only one vendor. In some cases, though, you'll be able to easily tweak a solution provided in this chapter to work for a platform not covered in the recipe.

Appendix A, Window Function Refresher, is a window function refresher along with a solid discussion of groups in SQL. Window functions are new to most, so it is appropriate that this appendix serves as a brief tutorial. Additionally, the use of GROUP BY in queries is a source of confusion for many developers. This chapter defines exactly what a SQL group is, and then proceeds to use various queries as proofs to validate that definition. The chapter then goes into the effects of NULLs on groups, aggregates, and partitions. Lastly, you'll find discussion on the more obscure and yet extremely powerful syntax of the window function's OVER clause (i.e., the "framing" or "windowing" clause).

Appendix B, Rozenshtein Revisited, is a tribute to David Rozenshtein, author of "The Essence of SQL". Appendix B focuses on some of the queries presented in "The Essence of SQL", and provides alternative solutions using window functions (which weren't available when The Essence of SQL was written) for those queries.

I highly recommend this book for anyone working with or interested in working with SQL. However, you should already be familiar with the theory behind database management or you will have trouble with this book.
9 von 9 Kunden fanden die folgende Rezension hilfreich
5.0 von 5 Sternen whoa! this is SQL? 20. Dezember 2005
Von Evan Galois - Veröffentlicht auf Amazon.com
Format:Taschenbuch
When you've been programming for quite sometime rarely

will any books surprise you.

To my surprise molinaro offers solutions i haven't seen before.

There is a heavy focus on "window functions" (which have been available

to other vendors but are brand new to sql server so i was quite

excited to see a deep treatment of that) along with use of vendor

specific functionality which makes for elegant solutions.

While there are things i typically would not do in sql,

for example, building delimited lists from result sets or parsing strings,

very clever and readabable solutions for both are provided.

The window function "refresher" is a welcome chapter and the author provides

a very nice treatment of GROUP BY (if you've ever had trouble with GROUP BY

queries, you'll appreciate this chapter). Molinaro provides an interesting

spin on what groups in SQL are.

Having a background in sybase,access, and sql server, i appreciate

the tribute chapter to David Rozenshtein. While Molinaro's solutions

are very different, he acknowledges the traditional techniques and

in some cases shows old and new, side by side.

all in all, a great book, showing off new and interesting sql techniques.
8 von 8 Kunden fanden die folgende Rezension hilfreich
5.0 von 5 Sternen a great second book on sql 28. Dezember 2005
Von BrianSt.Pierre - Veröffentlicht auf Amazon.com
Format:Taschenbuch
because the focus is on queries (the author states this on the cover and preface) you'll need a more traditional book on learning sql if you are completely new to it.

once you know the basics, this is a great "where to go next" book. there are chapters for complete novices, but being a "cookbook" (q&a format), i would not suggest this text as your only text on sql. instead this would make a good supplement to any of the intro sql books avaialable.

This book does a nice job of showing when and how to use different constructs of sql.

for example, once you learn GROUP BY (there is a window/group by tutorial in the back of the book), you might wonder when exactly do you use it or what queries do you use it for?

the recipes in this book do a nice job of explaining how various sql constructs (aggregates, window functions, pivot queries, etc) work and when to use them by tying verbal descriptions to real queries.

this is a good book for novice or intermediate developers looking to take their sql to the next level or dbas looking to improve their sql skills.
Waren diese Rezensionen hilfreich?   Wir wollen von Ihnen hören.
Kundenrezensionen suchen
Nur in den Rezensionen zu diesem Produkt suchen

Kunden diskutieren

Das Forum zu diesem Produkt
Diskussion Antworten Jüngster Beitrag
Noch keine Diskussionen

Fragen stellen, Meinungen austauschen, Einblicke gewinnen
Neue Diskussion starten
Thema:
Erster Beitrag:
Eingabe des Log-ins
 

Kundendiskussionen durchsuchen
Alle Amazon-Diskussionen durchsuchen
   


Ähnliche Artikel finden


Ihr Kommentar