SQL Clearly Explained -  Jan L. Harrington

SQL Clearly Explained (eBook)

eBook Download: PDF
2003 | 2. Auflage
352 Seiten
Elsevier Science (Verlag)
978-0-08-051758-2 (ISBN)
Systemvoraussetzungen
58,83 inkl. MwSt
  • Download sofort lieferbar
  • Zahlungsarten anzeigen
"This is the second edition of the popular practitioner's guide to SQL, the industry-standard database query language. Like most computer languages, SQL can be overwhelming when you first see it, but for years readers have relied on this book to clear the confusion and explain how SQL works and how to use it effectively. Packed with tips, tricks, and good information, SQL Clearly Explained, Second Edition teaches database users and programmers everything they need to know to get their job done including
?formulating SQL queries,
?understanding how queries are processed by the DBMS,
?maximizing performance,
?using SQL to enter, modify, or delete data,
?creating and maintaining database structural elements, and
?embedding SQL in applications.


Features
?Updated and expanded to include changes in the SQL standard (SQL:1999) as well as recently implemented aspects of SQL-92.
?Includes CD with examples from the book as well as MySQL, a popular open-source DBMS, on which the examples are based.
?Web enhanced with extra features available online at www.mkp.com.

* Second edition of classic SQL handbook
* Updated to cover changes in the SQL language standard (SQL:1999)
* Includes CD with MySQL software"
This is the second edition of the popular practitioner's guide to SQL, the industry-standard database query language. Like most computer languages, SQL can be overwhelming when you first see it, but for years readers have relied on this book to clear the confusion and explain how SQL works and how to use it effectively. Packed with tips, tricks, and good information, SQL Clearly Explained, Second Edition teaches database users and programmers everything they need to know to get their job done including *formulating SQL queries, *understanding how queries are processed by the DBMS,*maximizing performance,*using SQL to enter, modify, or delete data,*creating and maintaining database structural elements, and*embedding SQL in applications.Features*Updated and expanded to include changes in the SQL standard (SQL:1999) as well as recently implemented aspects of SQL-92.*Includes CD with examples from the book as well as MySQL, a popular open-source DBMS, on which the examples are based.*Web enhanced with extra features available online at www.mkp.com.* Second edition of classic SQL handbook* Updated to cover changes in the SQL language standard (SQL:1999)* Includes CD with MySQL software

Front Cover 1
SQL Clearly Explained 4
Copyright Page 5
Contents 6
Preface to the Second Edition 14
The Organization of This Book 15
The CD and the Sample Database 16
Acknowledgments 16
Part 1: Getting Started 18
Chapter 1: Installing and Running MySQL 20
Linux 21
Windows 23
Mac OS X 24
Chapter 2: Creating and Loading Databases 26
Creating a New Database 27
Creating the Tables 31
Populating the Tables 32
Chapter 3: Introduction to SQL 34
A Bit of SQL History 35
Conformance Levels 37
Relational Database Terminology and the Sample Database 38
Manipulating Relations 43
SQL Environments 44
Part 2: Performing Interactive Data Manipulation 50
Chapter 4: Simple SQL Retrieval 52
Choosing Columns 53
Ordering the Result Table 58
Choosing Rows 59
Nulls and Retrieval: Three-Valued Logic 79
Chapter 5: Retrieving Data from More Than One Table: Joins 82
The Relational Algebra Join Operation 83
SQL Syntax for Inner Joins 88
Finding Multiple Rows in One Table: Joining a Table to Itself 98
Outer Joins 102
Valid versus Invalid Joins 107
Avoiding Joins with Uncorrelated Subqueries 111
Chapter 6: Advanced Retrieval Operations 118
Union 118
Negative Queries 125
The EXISTS Operator 132
CASE Expressions 134
Chapter 7: Calculations and Grouping Queries 136
Performing Arithmetic 137
String Manipulations 140
Date and Time Manipulation 144
Set Functions 147
Changing Data Types: Using CAST 153
Grouping Queries 156
Chapter 8: Data Modification 164
Inserting Rows 165
Updating Data 168
Deleting Rows 169
Part 3: Managing Database Structure 172
Chapter 9: Schemas and Tables 174
Database Object Hierarchy 175
Schemas 177
Domains 180
Tables 181
Chapter 10: Views, Temporary Tables, and Indexes 196
Views 196
Temporary Tables 201
Indexes 204
Modifying Database Elements 207
Deleting Database Elements 212
Granting and Revoking Access Rights 213
Part 4: Program-Based Data Manipulation 218
Chapter 11: Users, Sessions, and Transaction Control 220
The Concurrent Use Data Environment 221
Database User IDs 225
Database Sessions and Connections 227
Transaction Control 229
Chapter 12: Embedded SQL 234
The Embedded SQL Environment 234
DBMS Return Codes 237
Retrieving a Single Row 238
Retrieving Multiple Rows: Cursors 241
Embedded SQL Data Modification 248
Chapter 13: Dynamic SQL 252
Immediate Execution 253
Dynamic SQL with Dynamic Parameters 255
Part 5: Additional Language Features 266
Chapter 14: Unimplemented SQL-92 Features 268
Additional Relational Algebra Operations 268
Additional Predicate Operators 273
Table Constructors in Queries 276
Additional Foreign Key Options 277
Assertions 278
Determining When Constraints Are Checked 278
Chapter 15: Object-Oriented Features of the SQL:1999 Standard 282
The Basics of Object Orientation 283
SQL:1999 versus Pure Object-Orientation 303
Object-Relational Support 305
Typed Tables 306
Creating Classes 307
Querying with Classes 312
Modifying Data for Classes as Domains 314
Part 6: Appendices 316
Appendix A: The Online Bookstore Database 318
Appendix B: SQLSTATE Return Codes 326
Appendix C: SQL Syntax Summary 332
Appendix D: SQL:1999 Core Features 340
Glossary 350
Index 360

Erscheint lt. Verlag 28.5.2003
Sprache englisch
Themenwelt Sachbuch/Ratgeber
Mathematik / Informatik Informatik Datenbanken
Mathematik / Informatik Informatik Programmiersprachen / -werkzeuge
Informatik Theorie / Studium Kryptologie
Sozialwissenschaften Kommunikation / Medien Buchhandel / Bibliothekswesen
ISBN-10 0-08-051758-7 / 0080517587
ISBN-13 978-0-08-051758-2 / 9780080517582
Haben Sie eine Frage zum Produkt?
PDFPDF (Adobe DRM)

Kopierschutz: Adobe-DRM
Adobe-DRM ist ein Kopierschutz, der das eBook vor Mißbrauch schützen soll. Dabei wird das eBook bereits beim Download auf Ihre persönliche Adobe-ID autorisiert. Lesen können Sie das eBook dann nur auf den Geräten, welche ebenfalls auf Ihre Adobe-ID registriert sind.
Details zum Adobe-DRM

Dateiformat: PDF (Portable Document Format)
Mit einem festen Seiten­layout eignet sich die PDF besonders für Fach­bücher mit Spalten, Tabellen und Abbild­ungen. Eine PDF kann auf fast allen Geräten ange­zeigt werden, ist aber für kleine Displays (Smart­phone, eReader) nur einge­schränkt geeignet.

Systemvoraussetzungen:
PC/Mac: Mit einem PC oder Mac können Sie dieses eBook lesen. Sie benötigen eine Adobe-ID und die Software Adobe Digital Editions (kostenlos). Von der Benutzung der OverDrive Media Console raten wir Ihnen ab. Erfahrungsgemäß treten hier gehäuft Probleme mit dem Adobe DRM auf.
eReader: Dieses eBook kann mit (fast) allen eBook-Readern gelesen werden. Mit dem amazon-Kindle ist es aber nicht kompatibel.
Smartphone/Tablet: Egal ob Apple oder Android, dieses eBook können Sie lesen. Sie benötigen eine Adobe-ID sowie eine kostenlose App.
Geräteliste und zusätzliche Hinweise

Buying eBooks from abroad
For tax law reasons we can sell eBooks just within Germany and Switzerland. Regrettably we cannot fulfill eBook-orders from other countries.

Mehr entdecken
aus dem Bereich
Kryptographie und Geschichte

von Wolfgang Killmann; Winfried Stephan

eBook Download (2024)
Springer Berlin Heidelberg (Verlag)
39,99