Beginning SQL Queries (eBook)
XX, 240 Seiten
Apress (Verlag)
978-1-4302-0550-0 (ISBN)
Beginning Queries with SQL is a friendly and easily read guide to writing queries with the all-important - in the database world - SQL language. Anyone who does any work at all with databases needs to know something of SQL, and that is evidenced by the strong sales of such books as Learning SQL (O'Reilly) and SQL Queries for Mere Mortals (Pearson). Beginning Queries with SQL is written by the author of Beginning Database Design, an author who is garnering great reviews on Amazon due to the clarity and succinctness of her writing.
Clare Churcher is currently a senior lecturer in the Department of Applied Computing at Lincoln University, New Zealand. She holds a degree in physics with first class honors and completed a Ph.D in physics at the University of Canterbury, New Zealand. She has done postdoctoral research in the Cavendish Laboratory at the University of Cambridge, England. Clare s research interests are in the management and visualization of data especially for scientific research. She has a background in database design, and has taught programming, analysis and design of information systems, and database management at undergraduate level, as well as software engineering and scientific visualization at post graduate level.
Clare Churchers Beginning SQL Queries is your guide to mastering the lingua franca of the database industry: the SQL language. Good knowledge of SQL is crucial to anyone working with databases, because it is with SQL that you retrieve data, manipulate data, and generate business results. Knowing how to write good queries is the foundation for all work done in SQL, and it is a foundation that Clare lays well in her book. Does not bore with syntax! Helps you learn the underlying concepts involved in querying a database, and from there the syntax is easy Provides exceptionally clear examples and explanations Is academically sound while being practical and approachable
Clare Churcher is currently a senior lecturer in the Department of Applied Computing at Lincoln University, New Zealand. She holds a degree in physics with first class honors and completed a Ph.D in physics at the University of Canterbury, New Zealand. She has done postdoctoral research in the Cavendish Laboratory at the University of Cambridge, England. Clare s research interests are in the management and visualization of data especially for scientific research. She has a background in database design, and has taught programming, analysis and design of information systems, and database management at undergraduate level, as well as software engineering and scientific visualization at post graduate level.
Contents at a Glance 5
Contents 6
About the Author 12
About the Technical Reviewer 13
Acknowledgments 14
Introduction 15
Relational Database Overview 17
What Is a Relational Database? 17
Retrieving Information from a Database 26
Summary 31
Simple Queries on One Table 32
Retrieving a Subset of Rows 35
Retrieving a Subset of Columns 37
Using Aliases 38
Combining Subsets of Rows and Columns 39
Saving Queries 40
Specifying Conditions for Selecting Rows 40
Dealing with Nulls 44
Managing Duplicates 47
Ordering Output 50
Performing Simple Counts 50
Avoiding Common Mistakes 51
Summary 54
A First Look at Joins 56
Joins in Relational Algebra 56
Joins in Relational Calculus 60
Extending Join Queries 61
Other Types of Joins 69
Summary 73
Nested Queries 75
IN Keyword 75
Using IN with a Nested Query 76
Being Careful with NOT and < >
EXISTS Keyword 81
Different Types of Nesting 83
Using Nested Queries for Updating 87
Summary 89
Self Joins 90
Self Relationships 90
Questions Involving “ Both” 101
Summary 105
More Than One Relationship Between Tables 107
Representing Multiple Relationships Between Tables 107
Algebra Approach to Two Relationships Between Tables 109
Calculus Approach to Two Relationships Between Tables 113
Business Rules 114
Summary 117
Set Operations 118
Overview of Basic Set Operations 119
Union- Compatible Tables 120
Union 122
Intersection 128
Difference 134
Division 138
Summary 143
Aggregate Operations 144
Simple Aggregates 144
Grouping 150
Nested Queries and Aggregates 158
Summary 161
Efficiency Considerations 163
Indexes 163
Query Optimizer 171
Summary 177
How to Approach a Query 178
Understanding the Data 178
Big Picture Approach 183
Spotting Key Words in Questions 188
No Idea Where to Start? 192
Checking Queries 195
Summary 197
Common Problems 199
Poor Database Design 199
Problems with Data Values 205
Diagnosing Problems 208
Common Symptoms 210
Common Typos and Syntax Problems 215
Summary 216
Sample Database 217
Index 219
Erscheint lt. Verlag | 30.5.2008 |
---|---|
Zusatzinfo | XX, 240 p. |
Verlagsort | Berkeley |
Sprache | englisch |
Themenwelt | Mathematik / Informatik ► Informatik ► Datenbanken |
Mathematik / Informatik ► Informatik ► Software Entwicklung | |
Schlagworte | Database • Database Design • Databases • Design • language • Relational Database • SQL |
ISBN-10 | 1-4302-0550-4 / 1430205504 |
ISBN-13 | 978-1-4302-0550-0 / 9781430205500 |
Haben Sie eine Frage zum Produkt? |
![PDF](/img/icon_pdf_big.jpg)
Größe: 5,3 MB
DRM: Digitales Wasserzeichen
Dieses eBook enthält ein digitales Wasserzeichen und ist damit für Sie personalisiert. Bei einer missbräuchlichen Weitergabe des eBooks an Dritte ist eine Rückverfolgung an die Quelle möglich.
Dateiformat: PDF (Portable Document Format)
Mit einem festen Seitenlayout eignet sich die PDF besonders für Fachbücher mit Spalten, Tabellen und Abbildungen. Eine PDF kann auf fast allen Geräten angezeigt werden, ist aber für kleine Displays (Smartphone, eReader) nur eingeschränkt geeignet.
Systemvoraussetzungen:
PC/Mac: Mit einem PC oder Mac können Sie dieses eBook lesen. Sie benötigen dafür einen PDF-Viewer - z.B. den Adobe Reader oder Adobe Digital Editions.
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 dafür einen PDF-Viewer - z.B. die kostenlose Adobe Digital Editions-App.
Zusätzliches Feature: Online Lesen
Dieses eBook können Sie zusätzlich zum Download auch online im Webbrowser lesen.
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.
aus dem Bereich