Tekijä: James J. Yue; Richard D. Guyer; J. Patrick Johnson; Larry T. Khoo; Stephen H. Hochschuler Kustantaja: Elsevier - Health Sciences Division (2011) Saatavuus: Noin 10-13 arkipäivää
Tekijä: Sam Lipsyte; Yves Marchand; George Saunders; Rivka Galchen; John Wray; Patrick Findeis; Clemens J. Setz; John Ashbery Kustantaja: Luxbooks GmbH (2011) Saatavuus: 01.06.2025
Tekijä: Tony Johnson; David G. Patrick; Christopher W. Stokes; David G. Wildgoose; Duncan J. Wood Kustantaja: John Wiley and Sons Ltd (2015) Saatavuus: Noin 15-18 arkipäivää
Tekijä: Viv Williams; John Sterling; Patrick J McKenna; David H Freeman; Chrissie Lightfoot; Andrew Hedley; Adam Billing; Ro Pay Kustantaja: Globe Law and Business Ltd (2015) Saatavuus: Ei tiedossa
Tekijä: R. Jan Stevenson; Yangdon Pan; J. Patrick Kociolek; John C. Kingston Kustantaja: Springer-Verlag New York Inc. (2006) Saatavuus: Noin 17-20 arkipäivää
Tekijä: J. G. Weisend (ed.); John Barclay (ed.); Susan Breon (ed.); Jonathan Demko (ed.); Michael DiPirro (ed.); J. Patrick Kelley Kustantaja: American Institute of Physics (2008) Saatavuus: Loppuunmyyty.
Tekijä: R. Jan Stevenson (ed.); Yangdon Pan (ed.); J. Patrick Kociolek (ed.); John C. Kingston (ed.) Kustantaja: Springer (2010) Saatavuus: Noin 17-20 arkipäivää
Tekijä: Helen Roy; Patrick De Clercq; Lori-Jayne Lawson Handley; John J. Sloggett; Remy L. Poland; Eric Wajnberg Kustantaja: Springer (2011) Saatavuus: Noin 17-20 arkipäivää
Tekijä: Helen Roy (ed.); Patrick De Clercq (ed.); Lori-Jayne Lawson Handley (ed.); John J. Sloggett (ed.); Remy L. Poland (ed.); Wa Kustantaja: Springer (2013) Saatavuus: Noin 17-20 arkipäivää
Sivumäärä: 832 sivua Asu: Pehmeäkantinen kirja Painos: 3. painos Julkaisuvuosi: 2008, 02.09.2008 (lisätietoa) Kieli: Englanti
SQL for the Real World
Don’t just learn “generic” SQL. Learn SQL to get results with the world’s top database platforms–Oracle for the enterprise and Microsoft Access for the desktop. Based on John Patrick’s hands-on SQL course at the University of California, Berkeley Extension, this book shows exactly how to retrieve the data you want, when you need it, in any application–from ad hoc reports to the data warehouse. Thoroughly updated for the newest versions of Oracle, Access, and the SQL standard, this book contains more exercises, techniques, and solutions than ever before. You’ll learn exactly how to write SQL queries that are easy to understand, verify, modify, and extend–even if you’ve never worked with databases before.
SQL Fundamentals,Third Edition, teaches you how to
Build simple statements to retrieve, store, or modify data
Craft complex queries that draw information from multiple tables
Sort and summarize your data just the way you want it
Create and edit your own tables
Protect the integrity of your data
Create more efficient, high-performance queries
Work with unions, subqueries, self joins, cross joins, inner joins, and outer joins
Use the Oracle Data Dictionary
About the Web Site
The accompanying Web site, https://www.box.com/shared/ylbckg2fn0 , contains all the SQL code and tables from the book, including the full databases for several versions of Access and code for building the corresponding Oracle databases. It also provides solutions to many of the book’s problems and an open area for discussions with the author and other readers.
