{"product_id":"sql-fundamentals-book-john-patrick-9780137126026","title":"SQL Fundamentals","description":"\u003cp\u003e\u003cb\u003eSQL for the Real World\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003e \u003c\/p\u003e \u003cp\u003eDon’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.\u003c\/p\u003e \u003cp\u003e \u003c\/p\u003e \u003cp\u003e\u003cb\u003e\u003ci\u003e\u003cb\u003eSQL Fundamentals,Third Edition,\u003c\/b\u003e\u003c\/i\u003e\u003c\/b\u003e teaches you how to \u003c\/p\u003e \u003cul\u003e\n\u003cli\u003e       Build simple statements to retrieve, store, or modify data    \u003c\/li\u003e\n\u003cli\u003e       Craft complex queries that draw information from multiple tables    \u003c\/li\u003e\n\u003cli\u003e       Sort and summarize your data just the way you want it    \u003c\/li\u003e\n\u003cli\u003e       Create and edit your own tables    \u003c\/li\u003e\n\u003cli\u003e       Protect the integrity of your data    \u003c\/li\u003e\n\u003cli\u003e       Create more efficient, high-performance queries    \u003c\/li\u003e\n\u003cli\u003e       Work with unions, subqueries, self joins, cross joins, inner joins, and outer joins    \u003c\/li\u003e\n\u003cli\u003e       Use the Oracle Data Dictionary   \u003c\/li\u003e\n\u003c\/ul\u003e \u003cp\u003e\u003cb\u003eAbout the Web Site\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003e \u003c\/p\u003e \u003cp\u003eThe 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.\u003c\/p\u003e","brand":"WoB","offers":[{"title":"US \/ WELL_READ \/ SBYB","offer_id":50345223487761,"sku":"CIN0137126026A","price":8.54,"currency_code":"USD","in_stock":false},{"title":"US \/ GOOD \/ SBYB","offer_id":50345239445777,"sku":"CIN0137126026G","price":5.78,"currency_code":"USD","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0784\/4072\/6801\/files\/0137126026.jpg?v=1751069471","url":"https:\/\/www.worldofbooks.com\/products\/sql-fundamentals-book-john-patrick-9780137126026","provider":"World of Books ","version":"1.0","type":"link"}