SQL Cookbook : Query Solutions and Techniques for Database Developers

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 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. Visa hela texten Passar bra ihop + De som köpt den här boken har ofta också köpt Learning Computer Architecture with Raspberry Pi av Eben Upton, Jeffrey Duntemann, Ralph Roberts, Tim Mamtora, Ben Everard (häftad). Köp båda 2 för 668 kr Kundrecensioner Har du läst boken? Sätt ditt betyg » Övrig information 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. Innehållsförteckning DedicationPrefaceChapter 1: Retrieving RecordsChapter 2: Sorting Query ResultsChapter 3: Working with Multiple TablesChapter 4: Inserting, Updating, DeletingChapter 5: Metadata QueriesChapter 6: Working with StringsChapter 7: Working with NumbersChapter 8: Date ArithmeticChapter 9: Date ManipulationChapter 10: Working with RangesChapter 11: Advanced SearchingChapter 12: Reporting and WarehousingChapter 13: Hierarchical QueriesChapter 14: Odds 'n' EndsAppendix A: Window Function RefresherAppendix B: Rozenshtein RevisitedColophon Frågor & svar Kundservice Vanliga frågor & svar Frakt & leverans Ångra Avancerad sökning In English Företag Bibliotek & Offentlig verksamhet Nyhetsbrev Leverantör Affiliate Jobba hos oss Om Bokus Pressrum Följ oss: © 2020 Bokus AB Org.nr 556493-0492 Sidan använder cookies Behandling av personuppgifter Avtalsvillkor Vi använder cookies för att förbättra din upplevelse av bokus.com. Genom att fortsätta godkänner du vår användning av cookies. Jag förstår show_your_recent_history = 1; var do_load_criteo_script = 1; window.criteo_q=window.criteo_q||[]; window.criteo_q.push( {event:"setAccount",account:6096}, {event:"setSiteType",type:"d"}, {event:"viewItem",item:"9780596009762"} );