SQL in a nutshell: [behandelt SQL Server, MySQL, Oracle & PostgresSQL]
Gespeichert in:
| Hauptverfasser: | , |
|---|---|
| Format: | Buch |
| Sprache: | German English |
| Veröffentlicht: |
Beijing [u.a.]
O'Reilly
2001
|
| Ausgabe: | Dt. Ausg., 1. Aufl. |
| Schlagworte: | |
| Online-Zugang: | Inhaltsverzeichnis |
| Beschreibung: | IX, 247 S. |
| ISBN: | 3897211971 |
Internformat
MARC
| LEADER | 00000nam a2200000zc 4500 | ||
|---|---|---|---|
| 001 | BV021969181 | ||
| 003 | DE-604 | ||
| 005 | 20040302000000.0 | ||
| 007 | t | ||
| 008 | 030519s2001 |||| 00||| ger d | ||
| 020 | |a 3897211971 |9 3-89721-197-1 | ||
| 035 | |a (OCoLC)76248283 | ||
| 035 | |a (DE-599)BVBBV021969181 | ||
| 040 | |a DE-604 |b ger | ||
| 041 | 1 | |a ger |h eng | |
| 049 | |a DE-706 | ||
| 082 | 0 | |a 005.75/85 | |
| 084 | |a ST 271 |0 (DE-625)143639: |2 rvk | ||
| 100 | 1 | |a Kline, Kevin E. |d 1966- |e Verfasser |0 (DE-588)123235375 |4 aut | |
| 240 | 1 | 0 | |a SQL in a nutshell |
| 245 | 1 | 0 | |a SQL in a nutshell |b [behandelt SQL Server, MySQL, Oracle & PostgresSQL] |
| 250 | |a Dt. Ausg., 1. Aufl. | ||
| 264 | 1 | |a Beijing [u.a.] |b O'Reilly |c 2001 | |
| 300 | |a IX, 247 S. | ||
| 336 | |b txt |2 rdacontent | ||
| 337 | |b n |2 rdamedia | ||
| 338 | |b nc |2 rdacarrier | ||
| 650 | 0 | 7 | |a SQL-2003 |0 (DE-588)4800549-6 |2 gnd |9 rswk-swf |
| 650 | 0 | 7 | |a Befehlsvorrat |0 (DE-588)4129931-0 |2 gnd |9 rswk-swf |
| 650 | 0 | 7 | |a SQL |0 (DE-588)4134010-3 |2 gnd |9 rswk-swf |
| 650 | 0 | 7 | |a SQL-99 |0 (DE-588)4602628-9 |2 gnd |9 rswk-swf |
| 655 | 7 | |8 1\p |0 (DE-588)4188171-0 |a Verzeichnis |2 gnd-content | |
| 689 | 0 | 0 | |a SQL |0 (DE-588)4134010-3 |D s |
| 689 | 0 | 1 | |a Befehlsvorrat |0 (DE-588)4129931-0 |D s |
| 689 | 0 | |8 2\p |5 DE-604 | |
| 689 | 1 | 0 | |a SQL-99 |0 (DE-588)4602628-9 |D s |
| 689 | 1 | 1 | |a Befehlsvorrat |0 (DE-588)4129931-0 |D s |
| 689 | 1 | |8 3\p |5 DE-604 | |
| 689 | 2 | 0 | |a SQL-2003 |0 (DE-588)4800549-6 |D s |
| 689 | 2 | 1 | |a Befehlsvorrat |0 (DE-588)4129931-0 |D s |
| 689 | 2 | |8 4\p |5 DE-604 | |
| 700 | 1 | |a Kline, Daniel |e Verfasser |4 aut | |
| 856 | 4 | 2 | |m HBZ Datenaustausch |q application/pdf |u http://bvbr.bib-bvb.de:8991/F?func=service&doc_library=BVB01&local_base=BVB01&doc_number=015184331&sequence=000001&line_number=0001&func_code=DB_RECORDS&service_type=MEDIA |3 Inhaltsverzeichnis |
| 999 | |a oai:aleph.bib-bvb.de:BVB01-015184331 | ||
| 883 | 1 | |8 1\p |a cgwrk |d 20201028 |q DE-101 |u https://d-nb.info/provenance/plan#cgwrk | |
| 883 | 1 | |8 2\p |a cgwrk |d 20201028 |q DE-101 |u https://d-nb.info/provenance/plan#cgwrk | |
| 883 | 1 | |8 3\p |a cgwrk |d 20201028 |q DE-101 |u https://d-nb.info/provenance/plan#cgwrk | |
| 883 | 1 | |8 4\p |a cgwrk |d 20201028 |q DE-101 |u https://d-nb.info/provenance/plan#cgwrk | |
Datensatz im Suchindex
| _version_ | 1804135939313762304 |
|---|---|
| adam_text | Titel: SQL in a nutshell
Autor: Kline, Kevin E
Jahr: 2001
Inhalt
Vorwort..........................................................................................................vii
Kapitel 1: SQL, verschiedene Implementierungen und etwas Gescbicfote 1
Das relationale Datenbankmodell............................................................1
Die in diesem Buch beschriebenen Datenbanken..................................2
Der SQL-Standard ................................................2
SQL-Dialekte ........................... ...................7
Prinzipien relationaler Datenbanken......................................................8
Kapitel 2: Grundlegende Konzepte............................................................11
Zeilenverarbeitung versus Mengenverarbeitung.......... ..................11
Das Relationenmodell ............................................................................12
SQL99- und herstellerspezifische Datentypen ..........................................14
Mit NULL-Werten arbeiten ....................................................................23
Syntaxkategorien....................................................................................24
SQL benutzen ........................................................................................29
Zusammenfassung............................................................................32
Kapitel J: Befehlsreferenz aller SQL-Anweisungen..................................33
Empfohlene Herangehensweise beim Lesen ............................................33
SQL-Befehlsreferenz................................................................................33
Zusammenfassung..................................................................................178
Inhalt v
Kapitel 4: SQL-Funktionen..................................... 179
Deterministische und nicht-deterministische Funktionen............. 179
Funktionstypen....................... ............... 180
Herstellerspezifische Erweiterungen....... ............... 192
Kapitel 5: Nicht-implementierte SQL99-Befehle....................227
Anhang: SQL99-und herstellerspezifische Schlusselworter ..........231
Index.......................................................239
Kolophon....................................................249
vi Inhalt
|
| adam_txt |
Titel: SQL in a nutshell
Autor: Kline, Kevin E
Jahr: 2001
Inhalt
Vorwort.vii
Kapitel 1: SQL, verschiedene Implementierungen und etwas Gescbicfote 1
Das relationale Datenbankmodell.1
Die in diesem Buch beschriebenen Datenbanken.2
Der SQL-Standard .2
SQL-Dialekte . .7
Prinzipien relationaler Datenbanken.8
Kapitel 2: Grundlegende Konzepte.11
Zeilenverarbeitung versus Mengenverarbeitung. .11
Das Relationenmodell .12
SQL99- und herstellerspezifische Datentypen .14
Mit NULL-Werten arbeiten .23
Syntaxkategorien.24
SQL benutzen .29
Zusammenfassung.32
Kapitel J: Befehlsreferenz aller SQL-Anweisungen.33
Empfohlene Herangehensweise beim Lesen .33
SQL-Befehlsreferenz.33
Zusammenfassung.178
Inhalt v
Kapitel 4: SQL-Funktionen. 179
Deterministische und nicht-deterministische Funktionen. 179
Funktionstypen. . 180
Herstellerspezifische Erweiterungen. . 192
Kapitel 5: Nicht-implementierte SQL99-Befehle.227
Anhang: SQL99-und herstellerspezifische Schlusselworter .231
Index.239
Kolophon.249
vi Inhalt |
| any_adam_object | 1 |
| any_adam_object_boolean | 1 |
| author | Kline, Kevin E. 1966- Kline, Daniel |
| author_GND | (DE-588)123235375 |
| author_facet | Kline, Kevin E. 1966- Kline, Daniel |
| author_role | aut aut |
| author_sort | Kline, Kevin E. 1966- |
| author_variant | k e k ke kek d k dk |
| building | Verbundindex |
| bvnumber | BV021969181 |
| classification_rvk | ST 271 |
| ctrlnum | (OCoLC)76248283 (DE-599)BVBBV021969181 |
| dewey-full | 005.75/85 |
| dewey-hundreds | 000 - Computer science, information, general works |
| dewey-ones | 005 - Computer programming, programs, data, security |
| dewey-raw | 005.75/85 |
| dewey-search | 005.75/85 |
| dewey-sort | 15.75 285 |
| dewey-tens | 000 - Computer science, information, general works |
| discipline | Informatik |
| discipline_str_mv | Informatik |
| edition | Dt. Ausg., 1. Aufl. |
| format | Book |
| fullrecord | <?xml version="1.0" encoding="UTF-8"?><collection xmlns="http://www.loc.gov/MARC21/slim"><record><leader>02182nam a2200541zc 4500</leader><controlfield tag="001">BV021969181</controlfield><controlfield tag="003">DE-604</controlfield><controlfield tag="005">20040302000000.0</controlfield><controlfield tag="007">t</controlfield><controlfield tag="008">030519s2001 |||| 00||| ger d</controlfield><datafield tag="020" ind1=" " ind2=" "><subfield code="a">3897211971</subfield><subfield code="9">3-89721-197-1</subfield></datafield><datafield tag="035" ind1=" " ind2=" "><subfield code="a">(OCoLC)76248283</subfield></datafield><datafield tag="035" ind1=" " ind2=" "><subfield code="a">(DE-599)BVBBV021969181</subfield></datafield><datafield tag="040" ind1=" " ind2=" "><subfield code="a">DE-604</subfield><subfield code="b">ger</subfield></datafield><datafield tag="041" ind1="1" ind2=" "><subfield code="a">ger</subfield><subfield code="h">eng</subfield></datafield><datafield tag="049" ind1=" " ind2=" "><subfield code="a">DE-706</subfield></datafield><datafield tag="082" ind1="0" ind2=" "><subfield code="a">005.75/85</subfield></datafield><datafield tag="084" ind1=" " ind2=" "><subfield code="a">ST 271</subfield><subfield code="0">(DE-625)143639:</subfield><subfield code="2">rvk</subfield></datafield><datafield tag="100" ind1="1" ind2=" "><subfield code="a">Kline, Kevin E.</subfield><subfield code="d">1966-</subfield><subfield code="e">Verfasser</subfield><subfield code="0">(DE-588)123235375</subfield><subfield code="4">aut</subfield></datafield><datafield tag="240" ind1="1" ind2="0"><subfield code="a">SQL in a nutshell</subfield></datafield><datafield tag="245" ind1="1" ind2="0"><subfield code="a">SQL in a nutshell</subfield><subfield code="b">[behandelt SQL Server, MySQL, Oracle & PostgresSQL]</subfield></datafield><datafield tag="250" ind1=" " ind2=" "><subfield code="a">Dt. Ausg., 1. Aufl.</subfield></datafield><datafield tag="264" ind1=" " ind2="1"><subfield code="a">Beijing [u.a.]</subfield><subfield code="b">O'Reilly</subfield><subfield code="c">2001</subfield></datafield><datafield tag="300" ind1=" " ind2=" "><subfield code="a">IX, 247 S.</subfield></datafield><datafield tag="336" ind1=" " ind2=" "><subfield code="b">txt</subfield><subfield code="2">rdacontent</subfield></datafield><datafield tag="337" ind1=" " ind2=" "><subfield code="b">n</subfield><subfield code="2">rdamedia</subfield></datafield><datafield tag="338" ind1=" " ind2=" "><subfield code="b">nc</subfield><subfield code="2">rdacarrier</subfield></datafield><datafield tag="650" ind1="0" ind2="7"><subfield code="a">SQL-2003</subfield><subfield code="0">(DE-588)4800549-6</subfield><subfield code="2">gnd</subfield><subfield code="9">rswk-swf</subfield></datafield><datafield tag="650" ind1="0" ind2="7"><subfield code="a">Befehlsvorrat</subfield><subfield code="0">(DE-588)4129931-0</subfield><subfield code="2">gnd</subfield><subfield code="9">rswk-swf</subfield></datafield><datafield tag="650" ind1="0" ind2="7"><subfield code="a">SQL</subfield><subfield code="0">(DE-588)4134010-3</subfield><subfield code="2">gnd</subfield><subfield code="9">rswk-swf</subfield></datafield><datafield tag="650" ind1="0" ind2="7"><subfield code="a">SQL-99</subfield><subfield code="0">(DE-588)4602628-9</subfield><subfield code="2">gnd</subfield><subfield code="9">rswk-swf</subfield></datafield><datafield tag="655" ind1=" " ind2="7"><subfield code="8">1\p</subfield><subfield code="0">(DE-588)4188171-0</subfield><subfield code="a">Verzeichnis</subfield><subfield code="2">gnd-content</subfield></datafield><datafield tag="689" ind1="0" ind2="0"><subfield code="a">SQL</subfield><subfield code="0">(DE-588)4134010-3</subfield><subfield code="D">s</subfield></datafield><datafield tag="689" ind1="0" ind2="1"><subfield code="a">Befehlsvorrat</subfield><subfield code="0">(DE-588)4129931-0</subfield><subfield code="D">s</subfield></datafield><datafield tag="689" ind1="0" ind2=" "><subfield code="8">2\p</subfield><subfield code="5">DE-604</subfield></datafield><datafield tag="689" ind1="1" ind2="0"><subfield code="a">SQL-99</subfield><subfield code="0">(DE-588)4602628-9</subfield><subfield code="D">s</subfield></datafield><datafield tag="689" ind1="1" ind2="1"><subfield code="a">Befehlsvorrat</subfield><subfield code="0">(DE-588)4129931-0</subfield><subfield code="D">s</subfield></datafield><datafield tag="689" ind1="1" ind2=" "><subfield code="8">3\p</subfield><subfield code="5">DE-604</subfield></datafield><datafield tag="689" ind1="2" ind2="0"><subfield code="a">SQL-2003</subfield><subfield code="0">(DE-588)4800549-6</subfield><subfield code="D">s</subfield></datafield><datafield tag="689" ind1="2" ind2="1"><subfield code="a">Befehlsvorrat</subfield><subfield code="0">(DE-588)4129931-0</subfield><subfield code="D">s</subfield></datafield><datafield tag="689" ind1="2" ind2=" "><subfield code="8">4\p</subfield><subfield code="5">DE-604</subfield></datafield><datafield tag="700" ind1="1" ind2=" "><subfield code="a">Kline, Daniel</subfield><subfield code="e">Verfasser</subfield><subfield code="4">aut</subfield></datafield><datafield tag="856" ind1="4" ind2="2"><subfield code="m">HBZ Datenaustausch</subfield><subfield code="q">application/pdf</subfield><subfield code="u">http://bvbr.bib-bvb.de:8991/F?func=service&doc_library=BVB01&local_base=BVB01&doc_number=015184331&sequence=000001&line_number=0001&func_code=DB_RECORDS&service_type=MEDIA</subfield><subfield code="3">Inhaltsverzeichnis</subfield></datafield><datafield tag="999" ind1=" " ind2=" "><subfield code="a">oai:aleph.bib-bvb.de:BVB01-015184331</subfield></datafield><datafield tag="883" ind1="1" ind2=" "><subfield code="8">1\p</subfield><subfield code="a">cgwrk</subfield><subfield code="d">20201028</subfield><subfield code="q">DE-101</subfield><subfield code="u">https://d-nb.info/provenance/plan#cgwrk</subfield></datafield><datafield tag="883" ind1="1" ind2=" "><subfield code="8">2\p</subfield><subfield code="a">cgwrk</subfield><subfield code="d">20201028</subfield><subfield code="q">DE-101</subfield><subfield code="u">https://d-nb.info/provenance/plan#cgwrk</subfield></datafield><datafield tag="883" ind1="1" ind2=" "><subfield code="8">3\p</subfield><subfield code="a">cgwrk</subfield><subfield code="d">20201028</subfield><subfield code="q">DE-101</subfield><subfield code="u">https://d-nb.info/provenance/plan#cgwrk</subfield></datafield><datafield tag="883" ind1="1" ind2=" "><subfield code="8">4\p</subfield><subfield code="a">cgwrk</subfield><subfield code="d">20201028</subfield><subfield code="q">DE-101</subfield><subfield code="u">https://d-nb.info/provenance/plan#cgwrk</subfield></datafield></record></collection> |
| genre | 1\p (DE-588)4188171-0 Verzeichnis gnd-content |
| genre_facet | Verzeichnis |
| id | DE-604.BV021969181 |
| illustrated | Not Illustrated |
| index_date | 2024-07-02T16:09:09Z |
| indexdate | 2024-07-09T20:48:28Z |
| institution | BVB |
| isbn | 3897211971 |
| language | German English |
| oai_aleph_id | oai:aleph.bib-bvb.de:BVB01-015184331 |
| oclc_num | 76248283 |
| open_access_boolean | |
| owner | DE-706 |
| owner_facet | DE-706 |
| physical | IX, 247 S. |
| publishDate | 2001 |
| publishDateSearch | 2001 |
| publishDateSort | 2001 |
| publisher | O'Reilly |
| record_format | marc |
| spelling | Kline, Kevin E. 1966- Verfasser (DE-588)123235375 aut SQL in a nutshell SQL in a nutshell [behandelt SQL Server, MySQL, Oracle & PostgresSQL] Dt. Ausg., 1. Aufl. Beijing [u.a.] O'Reilly 2001 IX, 247 S. txt rdacontent n rdamedia nc rdacarrier SQL-2003 (DE-588)4800549-6 gnd rswk-swf Befehlsvorrat (DE-588)4129931-0 gnd rswk-swf SQL (DE-588)4134010-3 gnd rswk-swf SQL-99 (DE-588)4602628-9 gnd rswk-swf 1\p (DE-588)4188171-0 Verzeichnis gnd-content SQL (DE-588)4134010-3 s Befehlsvorrat (DE-588)4129931-0 s 2\p DE-604 SQL-99 (DE-588)4602628-9 s 3\p DE-604 SQL-2003 (DE-588)4800549-6 s 4\p DE-604 Kline, Daniel Verfasser aut HBZ Datenaustausch application/pdf http://bvbr.bib-bvb.de:8991/F?func=service&doc_library=BVB01&local_base=BVB01&doc_number=015184331&sequence=000001&line_number=0001&func_code=DB_RECORDS&service_type=MEDIA Inhaltsverzeichnis 1\p cgwrk 20201028 DE-101 https://d-nb.info/provenance/plan#cgwrk 2\p cgwrk 20201028 DE-101 https://d-nb.info/provenance/plan#cgwrk 3\p cgwrk 20201028 DE-101 https://d-nb.info/provenance/plan#cgwrk 4\p cgwrk 20201028 DE-101 https://d-nb.info/provenance/plan#cgwrk |
| spellingShingle | Kline, Kevin E. 1966- Kline, Daniel SQL in a nutshell [behandelt SQL Server, MySQL, Oracle & PostgresSQL] SQL-2003 (DE-588)4800549-6 gnd Befehlsvorrat (DE-588)4129931-0 gnd SQL (DE-588)4134010-3 gnd SQL-99 (DE-588)4602628-9 gnd |
| subject_GND | (DE-588)4800549-6 (DE-588)4129931-0 (DE-588)4134010-3 (DE-588)4602628-9 (DE-588)4188171-0 |
| title | SQL in a nutshell [behandelt SQL Server, MySQL, Oracle & PostgresSQL] |
| title_alt | SQL in a nutshell |
| title_auth | SQL in a nutshell [behandelt SQL Server, MySQL, Oracle & PostgresSQL] |
| title_exact_search | SQL in a nutshell [behandelt SQL Server, MySQL, Oracle & PostgresSQL] |
| title_exact_search_txtP | SQL in a nutshell [behandelt SQL Server, MySQL, Oracle & PostgresSQL] |
| title_full | SQL in a nutshell [behandelt SQL Server, MySQL, Oracle & PostgresSQL] |
| title_fullStr | SQL in a nutshell [behandelt SQL Server, MySQL, Oracle & PostgresSQL] |
| title_full_unstemmed | SQL in a nutshell [behandelt SQL Server, MySQL, Oracle & PostgresSQL] |
| title_short | SQL in a nutshell |
| title_sort | sql in a nutshell behandelt sql server mysql oracle postgressql |
| title_sub | [behandelt SQL Server, MySQL, Oracle & PostgresSQL] |
| topic | SQL-2003 (DE-588)4800549-6 gnd Befehlsvorrat (DE-588)4129931-0 gnd SQL (DE-588)4134010-3 gnd SQL-99 (DE-588)4602628-9 gnd |
| topic_facet | SQL-2003 Befehlsvorrat SQL SQL-99 Verzeichnis |
| url | http://bvbr.bib-bvb.de:8991/F?func=service&doc_library=BVB01&local_base=BVB01&doc_number=015184331&sequence=000001&line_number=0001&func_code=DB_RECORDS&service_type=MEDIA |
| work_keys_str_mv | AT klinekevine sqlinanutshell AT klinedaniel sqlinanutshell AT klinekevine sqlinanutshellbehandeltsqlservermysqloraclepostgressql AT klinedaniel sqlinanutshellbehandeltsqlservermysqloraclepostgressql |