Visual Introduction to Sql

Informationen zum Autor DAVID CHAPPELL is Principal of David Chappell & Associates (www.davidchappell.com) in San Francisco, California. David's popular keynotes and seminars have been presented in more than two dozen countries, and his books on enterprise software have been translated into ten languages.J. HARVEY TRIMBLE Jr. is Managing Director of eBusiness Product Development at Fannie Mae in Washington, D.C. He is responsible for business and product development for the electronic distribution of Fannie Mae's underwriting guidelines and eMortgage capabilities. Klappentext SQL (Structured Query Language) ist eine Programmiersprache, die bei den meisten relationalen Datenbanken, wie z.B. Oracle, Sybase, Microsoft SQL Server und Access zum Einsatz kommt. Zwar verfügen die meisten über eigene Extensions, doch mit den SQL Standardbefehlen wie "select", "insert", "update", "delete", "create" und "drop" können grundlegende Datenbankaufgaben wie Datenzugriff und -bearbeitung ausgeführt werden. Deshalb sollten Softwareexperten zumindest über SQL-Basiswissen verfügen. "A Visual Introduction to SQL" bietet eine praktische Schritt-für-Schritt Einführung in die Grundlagen von SQL. Verständlich präsentiert und mit über 125 graphischen Abbildungen illustriert: So wird Lernen leicht gemacht. Die begleitende Website enthält Updates zu den neuesten Tools und Techniken sowie Links zu verwandten Sites. Zusammenfassung SQL (Structured Query Language) ist eine Programmiersprache, die bei den meisten relationalen Datenbanken, wie z.B. Oracle, Sybase, Microsoft SQL Server und Access zum Einsatz kommt. Zwar verfügen die meisten über eigene Extensions, doch mit den SQL Standardbefehlen wie "select", "insert", "update", "delete", "create" und "drop" können grundlegende Datenbankaufgaben wie Datenzugriff und -bearbeitung ausgeführt werden. Deshalb sollten Softwareexperten zumindest über SQL-Basiswissen verfügen. "A Visual Introduction to SQL" bietet eine praktische Schritt-für-Schritt Einführung in die Grundlagen von SQL. Verständlich präsentiert und mit über 125 graphischen Abbildungen illustriert: So wird Lernen leicht gemacht. Die begleitende Website enthält Updates zu den neuesten Tools und Techniken sowie Links zu verwandten Sites. Inhaltsverzeichnis Foreword.Preface.Chapter 1: Introducing SQL.Kinds of Database Systems.Relational Concepts.Tables, Rows, and Columns.Keys.An Example Table.The Visual Approach.Chapter 2: Elements of the Language.Ways to Use SQL.Versions of SQL.Defining the Language.Data Types.The Structure of SQL Statements.Keywords.An Example Database.Organization of the Examples.Chapter 3: Retrieving Data from a Table: The SELECT Statement.Selecting Specific Columns in a Table.Selecting All Columns in a Table.Selecting Only Some of a Table's Records: The WHERE Clause.Comparisons in a WHERE Clause.Combining Predicates in a WHERE Clause.Using AND.Using OR.Using NOT.Other Uses of WHERE.BETWEEN and NOT BETWEEN.LIKE and NOT LIKE.IN and NOT IN.IS NULL and IS NOT NULL.Chapter 4: More on SELECT.Ordering Selected Data.Doing Arithmetic with Selected Information.Using Aggregates.Finding Maximum and Minimum Values.Totaling Columns.Finding Averages.Counting Records.Using DISTINCT.Grouping Selected Data.More on Grouping: The HAVING Clause.Chapter 5: Retrieving Data from Several Tables: Joins.Qualified Names.What Is a Join?Restricting the Results of a Join.Query Diagrams for Joins.Joining Tables Using the Join Operator.Manipulating the Results of a Join.Aliases.Joins with Three Tables.The Visual Approach with More Than Two Tables.Joins with More Than Three Tables.Retrieving the Same Information in Different Ways.Using GROUP BY in a Join.Chapter 6: Queries within Queries: Subqueries.What Is a Subquery?Using Comparison Operators with Subqueries.Using ANY and ALL.Existence Tests.Correlated...

List of contents

Foreword.
 
Preface.
 
Chapter 1: Introducing SQL.
 
Kinds of Database Systems.
 
Relational Concepts.
 
Tables, Rows, and Columns.
 
Keys.
 
An Example Table.
 
The Visual Approach.
 
Chapter 2: Elements of the Language.
 
Ways to Use SQL.
 
Versions of SQL.
 
Defining the Language.
 
Data Types.
 
The Structure of SQL Statements.
 
Keywords.
 
An Example Database.
 
Organization of the Examples.
 
Chapter 3: Retrieving Data from a Table: The SELECT Statement.
 
Selecting Specific Columns in a Table.
 
Selecting All Columns in a Table.
 
Selecting Only Some of a Table's Records: The WHERE Clause.
 
Comparisons in a WHERE Clause.
 
Combining Predicates in a WHERE Clause.
 
Using AND.
 
Using OR.
 
Using NOT.
 
Other Uses of WHERE.
 
BETWEEN and NOT BETWEEN.
 
LIKE and NOT LIKE.
 
IN and NOT IN.
 
IS NULL and IS NOT NULL.
 
Chapter 4: More on SELECT.
 
Ordering Selected Data.
 
Doing Arithmetic with Selected Information.
 
Using Aggregates.
 
Finding Maximum and Minimum Values.
 
Totaling Columns.
 
Finding Averages.
 
Counting Records.
 
Using DISTINCT.
 
Grouping Selected Data.
 
More on Grouping: The HAVING Clause.
 
Chapter 5: Retrieving Data from Several Tables: Joins.
 
Qualified Names.
 
What Is a Join?
 
Restricting the Results of a Join.
 
Query Diagrams for Joins.
 
Joining Tables Using the Join Operator.
 
Manipulating the Results of a Join.
 
Aliases.
 
Joins with Three Tables.
 
The Visual Approach with More Than Two Tables.
 
Joins with More Than Three Tables.
 
Retrieving the Same Information in Different Ways.
 
Using GROUP BY in a Join.
 
Chapter 6: Queries within Queries: Subqueries.
 
What Is a Subquery?
 
Using Comparison Operators with Subqueries.
 
Using ANY and ALL.
 
Existence Tests.
 
Correlated Subqueries.
 
Using HAVING with Correlated Subqueries.
 
Chapter 7: Creating and Destroying Tables.
 
Creating a Table.
 
Disallowing NULL Values.
 
Requiring Unique Values in a Column.
 
Destroying (Dropping) Tables.
 
Chapter 8: Adding, Modifying, and Deleting Records.
 
Adding Records to a Table.
 
Adding Records with Values Only for Some Columns.
 
Adding Records Using SELECT.
 
Modifying Records in a Table.
 
Deleting Records from a Table.
 
Chapter 9: Views.
 
Creating Views.
 
Creating Views Based on One Table.
 
Creating Views Based on More Than One Table.
 
Queries Using Views.
 
Selecting Records from a View.
 
Adding Records to a View.
 
Modifying Records in a View.
 
Deleting Records from a View.
 
Destroying (Dropping) Views.
 
Chapter 10: Granting and Revoking Privileges.
 
Granting Privileges.
 
Granting Privileges on Views.
 
Passing Privileges On: The GRANT Option.
 
Revoking Privileges.
 
Chapter 11: Advanced Topics.
 
Indexes.
 
Creating Indexes.
 
When to Create Indexes.
 
Destroying Indexes.
 
Using Multiple SQL Statements to Solve a Problem.
 
Outer Joins.
 
Unions.
 
Joining a Table with Itself.
 
Final Thoughts.
 
Append

Product details

• Authors: Chappell, D Chappell, David Chappell, David A. Chappell, David Trimble Chappell, CHAPPELL DAVID TRIMBLE J HARVEY, Trimble, J Harvey Trimble, J. H. Trimble, J. Harvey Trimble
• Publisher: Wiley, John and Sons Ltd
• Languages: English
• Product format: Paperback / Softback
• Released: 05.12.2001
• EAN: 9780471412762
• ISBN: 978-0-471-41276-2
• No. of pages: 304
• Subjects: Natural sciences, medicine, IT, technology > IT, data processing > Data communication, networks; Informatik, sql, computer science, Database & Data Warehousing Technologies, Datenbanken u. Data Warehousing