SQL fundamentals:
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 Exten...
Gespeichert in:
| Beteilige Person: | |
|---|---|
| Format: | Elektronisch E-Book |
| Sprache: | Englisch |
| Veröffentlicht: |
Upper Saddle River, N.J.
Prentice Hall
2009
|
| Ausgabe: | 3rd ed. |
| Schlagwörter: | |
| Links: | https://learning.oreilly.com/library/view/-/9780137156146/?ar |
| Zusammenfassung: | 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 |
| Beschreibung: | Print version record |
| Umfang: | 1 Online-Ressource (xxviii, 803 Seiten) illustrations |
| ISBN: | 9780137156146 0137156146 |
Internformat
MARC
| LEADER | 00000cam a22000002 4500 | ||
|---|---|---|---|
| 001 | ZDB-30-ORH-04745539X | ||
| 003 | DE-627-1 | ||
| 005 | 20240228114332.0 | ||
| 007 | cr uuu---uuuuu | ||
| 008 | 191023s2009 xx |||||o 00| ||eng c | ||
| 020 | |a 9780137156146 |9 978-0-13-715614-6 | ||
| 020 | |a 0137156146 |9 0-13-715614-6 | ||
| 035 | |a (DE-627-1)04745539X | ||
| 035 | |a (DE-599)KEP04745539X | ||
| 035 | |a (ORHE)9780137156146 | ||
| 035 | |a (DE-627-1)04745539X | ||
| 040 | |a DE-627 |b ger |c DE-627 |e rda | ||
| 041 | |a eng | ||
| 082 | 0 | |a 005.75/65 |2 22 | |
| 100 | 1 | |a Patrick, John J. |e VerfasserIn |4 aut | |
| 245 | 1 | 0 | |a SQL fundamentals |c John J. Patrick |
| 250 | |a 3rd ed. | ||
| 264 | 1 | |a Upper Saddle River, N.J. |b Prentice Hall |c 2009 | |
| 300 | |a 1 Online-Ressource (xxviii, 803 Seiten) |b illustrations | ||
| 336 | |a Text |b txt |2 rdacontent | ||
| 337 | |a Computermedien |b c |2 rdamedia | ||
| 338 | |a Online-Ressource |b cr |2 rdacarrier | ||
| 500 | |a Print version record | ||
| 520 | |a 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 | ||
| 630 | 2 | 0 | |a Oracle (Computer file) |
| 630 | 2 | 0 | |a Microsoft Access |
| 650 | 0 | |a SQL (Computer program language) | |
| 650 | 4 | |a Oracle | |
| 650 | 4 | |a Microsoft Access | |
| 650 | 4 | |a Microsoft Access | |
| 650 | 4 | |a Oracle (Computer file) | |
| 650 | 4 | |a SQL (Langage de programmation) | |
| 650 | 4 | |a SQL (Computer program language) | |
| 650 | 4 | |a SQL (Computer program language) | |
| 776 | 1 | |z 0137126026 | |
| 776 | 0 | 8 | |i Erscheint auch als |n Druck-Ausgabe |z 0137126026 |
| 966 | 4 | 0 | |l DE-91 |p ZDB-30-ORH |q TUM_PDA_ORH |u https://learning.oreilly.com/library/view/-/9780137156146/?ar |m X:ORHE |x Aggregator |z lizenzpflichtig |3 Volltext |
| 912 | |a ZDB-30-ORH | ||
| 912 | |a ZDB-30-ORH | ||
| 951 | |a BO | ||
| 912 | |a ZDB-30-ORH | ||
| 049 | |a DE-91 | ||
Datensatz im Suchindex
| DE-BY-TUM_katkey | ZDB-30-ORH-04745539X |
|---|---|
| _version_ | 1821494902079356928 |
| adam_text | |
| any_adam_object | |
| author | Patrick, John J. |
| author_facet | Patrick, John J. |
| author_role | aut |
| author_sort | Patrick, John J. |
| author_variant | j j p jj jjp |
| building | Verbundindex |
| bvnumber | localTUM |
| collection | ZDB-30-ORH |
| ctrlnum | (DE-627-1)04745539X (DE-599)KEP04745539X (ORHE)9780137156146 |
| dewey-full | 005.75/65 |
| dewey-hundreds | 000 - Computer science, information, general works |
| dewey-ones | 005 - Computer programming, programs, data, security |
| dewey-raw | 005.75/65 |
| dewey-search | 005.75/65 |
| dewey-sort | 15.75 265 |
| dewey-tens | 000 - Computer science, information, general works |
| discipline | Informatik |
| edition | 3rd ed. |
| format | Electronic eBook |
| fullrecord | <?xml version="1.0" encoding="UTF-8"?><collection xmlns="http://www.loc.gov/MARC21/slim"><record><leader>03191cam a22005052 4500</leader><controlfield tag="001">ZDB-30-ORH-04745539X</controlfield><controlfield tag="003">DE-627-1</controlfield><controlfield tag="005">20240228114332.0</controlfield><controlfield tag="007">cr uuu---uuuuu</controlfield><controlfield tag="008">191023s2009 xx |||||o 00| ||eng c</controlfield><datafield tag="020" ind1=" " ind2=" "><subfield code="a">9780137156146</subfield><subfield code="9">978-0-13-715614-6</subfield></datafield><datafield tag="020" ind1=" " ind2=" "><subfield code="a">0137156146</subfield><subfield code="9">0-13-715614-6</subfield></datafield><datafield tag="035" ind1=" " ind2=" "><subfield code="a">(DE-627-1)04745539X</subfield></datafield><datafield tag="035" ind1=" " ind2=" "><subfield code="a">(DE-599)KEP04745539X</subfield></datafield><datafield tag="035" ind1=" " ind2=" "><subfield code="a">(ORHE)9780137156146</subfield></datafield><datafield tag="035" ind1=" " ind2=" "><subfield code="a">(DE-627-1)04745539X</subfield></datafield><datafield tag="040" ind1=" " ind2=" "><subfield code="a">DE-627</subfield><subfield code="b">ger</subfield><subfield code="c">DE-627</subfield><subfield code="e">rda</subfield></datafield><datafield tag="041" ind1=" " ind2=" "><subfield code="a">eng</subfield></datafield><datafield tag="082" ind1="0" ind2=" "><subfield code="a">005.75/65</subfield><subfield code="2">22</subfield></datafield><datafield tag="100" ind1="1" ind2=" "><subfield code="a">Patrick, John J.</subfield><subfield code="e">VerfasserIn</subfield><subfield code="4">aut</subfield></datafield><datafield tag="245" ind1="1" ind2="0"><subfield code="a">SQL fundamentals</subfield><subfield code="c">John J. Patrick</subfield></datafield><datafield tag="250" ind1=" " ind2=" "><subfield code="a">3rd ed.</subfield></datafield><datafield tag="264" ind1=" " ind2="1"><subfield code="a">Upper Saddle River, N.J.</subfield><subfield code="b">Prentice Hall</subfield><subfield code="c">2009</subfield></datafield><datafield tag="300" ind1=" " ind2=" "><subfield code="a">1 Online-Ressource (xxviii, 803 Seiten)</subfield><subfield code="b">illustrations</subfield></datafield><datafield tag="336" ind1=" " ind2=" "><subfield code="a">Text</subfield><subfield code="b">txt</subfield><subfield code="2">rdacontent</subfield></datafield><datafield tag="337" ind1=" " ind2=" "><subfield code="a">Computermedien</subfield><subfield code="b">c</subfield><subfield code="2">rdamedia</subfield></datafield><datafield tag="338" ind1=" " ind2=" "><subfield code="a">Online-Ressource</subfield><subfield code="b">cr</subfield><subfield code="2">rdacarrier</subfield></datafield><datafield tag="500" ind1=" " ind2=" "><subfield code="a">Print version record</subfield></datafield><datafield tag="520" ind1=" " ind2=" "><subfield code="a">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</subfield></datafield><datafield tag="630" ind1="2" ind2="0"><subfield code="a">Oracle (Computer file)</subfield></datafield><datafield tag="630" ind1="2" ind2="0"><subfield code="a">Microsoft Access</subfield></datafield><datafield tag="650" ind1=" " ind2="0"><subfield code="a">SQL (Computer program language)</subfield></datafield><datafield tag="650" ind1=" " ind2="4"><subfield code="a">Oracle</subfield></datafield><datafield tag="650" ind1=" " ind2="4"><subfield code="a">Microsoft Access</subfield></datafield><datafield tag="650" ind1=" " ind2="4"><subfield code="a">Microsoft Access</subfield></datafield><datafield tag="650" ind1=" " ind2="4"><subfield code="a">Oracle (Computer file)</subfield></datafield><datafield tag="650" ind1=" " ind2="4"><subfield code="a">SQL (Langage de programmation)</subfield></datafield><datafield tag="650" ind1=" " ind2="4"><subfield code="a">SQL (Computer program language)</subfield></datafield><datafield tag="650" ind1=" " ind2="4"><subfield code="a">SQL (Computer program language)</subfield></datafield><datafield tag="776" ind1="1" ind2=" "><subfield code="z">0137126026</subfield></datafield><datafield tag="776" ind1="0" ind2="8"><subfield code="i">Erscheint auch als</subfield><subfield code="n">Druck-Ausgabe</subfield><subfield code="z">0137126026</subfield></datafield><datafield tag="966" ind1="4" ind2="0"><subfield code="l">DE-91</subfield><subfield code="p">ZDB-30-ORH</subfield><subfield code="q">TUM_PDA_ORH</subfield><subfield code="u">https://learning.oreilly.com/library/view/-/9780137156146/?ar</subfield><subfield code="m">X:ORHE</subfield><subfield code="x">Aggregator</subfield><subfield code="z">lizenzpflichtig</subfield><subfield code="3">Volltext</subfield></datafield><datafield tag="912" ind1=" " ind2=" "><subfield code="a">ZDB-30-ORH</subfield></datafield><datafield tag="912" ind1=" " ind2=" "><subfield code="a">ZDB-30-ORH</subfield></datafield><datafield tag="951" ind1=" " ind2=" "><subfield code="a">BO</subfield></datafield><datafield tag="912" ind1=" " ind2=" "><subfield code="a">ZDB-30-ORH</subfield></datafield><datafield tag="049" ind1=" " ind2=" "><subfield code="a">DE-91</subfield></datafield></record></collection> |
| id | ZDB-30-ORH-04745539X |
| illustrated | Illustrated |
| indexdate | 2025-01-17T11:21:45Z |
| institution | BVB |
| isbn | 9780137156146 0137156146 |
| language | English |
| open_access_boolean | |
| owner | DE-91 DE-BY-TUM |
| owner_facet | DE-91 DE-BY-TUM |
| physical | 1 Online-Ressource (xxviii, 803 Seiten) illustrations |
| psigel | ZDB-30-ORH TUM_PDA_ORH ZDB-30-ORH |
| publishDate | 2009 |
| publishDateSearch | 2009 |
| publishDateSort | 2009 |
| publisher | Prentice Hall |
| record_format | marc |
| spelling | Patrick, John J. VerfasserIn aut SQL fundamentals John J. Patrick 3rd ed. Upper Saddle River, N.J. Prentice Hall 2009 1 Online-Ressource (xxviii, 803 Seiten) illustrations Text txt rdacontent Computermedien c rdamedia Online-Ressource cr rdacarrier Print version record 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 Oracle (Computer file) Microsoft Access SQL (Computer program language) Oracle SQL (Langage de programmation) 0137126026 Erscheint auch als Druck-Ausgabe 0137126026 |
| spellingShingle | Patrick, John J. SQL fundamentals Oracle (Computer file) Microsoft Access SQL (Computer program language) Oracle SQL (Langage de programmation) |
| title | SQL fundamentals |
| title_auth | SQL fundamentals |
| title_exact_search | SQL fundamentals |
| title_full | SQL fundamentals John J. Patrick |
| title_fullStr | SQL fundamentals John J. Patrick |
| title_full_unstemmed | SQL fundamentals John J. Patrick |
| title_short | SQL fundamentals |
| title_sort | sql fundamentals |
| topic | Oracle (Computer file) Microsoft Access SQL (Computer program language) Oracle SQL (Langage de programmation) |
| topic_facet | Oracle (Computer file) Microsoft Access SQL (Computer program language) Oracle SQL (Langage de programmation) |
| work_keys_str_mv | AT patrickjohnj sqlfundamentals |