Über dieses Produkt

Product Identifiers

PublisherWiley & Sons, Incorporated, John

ISBN-100471412767

ISBN-139780471412762

eBay Product ID (ePID)102793271

Product Key Features

Number of Pages304 Pages

Publication NameVisual Introduction to Sql

LanguageEnglish

SubjectProgramming Languages / Sql, Databases / General

Publication Year2001

FeaturesRevised

TypeTextbook

Subject AreaComputers

AuthorJ. Harvey Trimble Jr., David Chappell

FormatTrade Paperback

Dimensions

Item Height0.7 in

Item Weight18.5 Oz

Item Length9.3 in

Item Width7.5 in

Additional Product Features

Edition Number2

Intended AudienceScholarly & Professional

LCCN2001-046610

TitleLeadingA

Dewey Edition21

IllustratedYes

Dewey Decimal005.75/65

Table Of ContentForeword. 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. Appendix A: The Example Database. Appendix B: List of Examples. Appendix C: The Example Database. Index.

Edition DescriptionRevised edition

SynopsisStructured Query Language (SQL) is a generic relational database programming language. While there are many books on SQL available, none take the unique approach of not assuming that the reader is familiar with databases or the SQL programming language., 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., Learn SQL quickly with this easy-to-use, visual tutorial Every IT professional needs at least a basic understanding of SQL. A Visual Introduction to SQL, Second Edition provides a unique tool for acquiring this knowledge. By diagramming each query, this book resolves the languages apparent complexity into simple clarity using an intuitive visual representation. Rather than focusing on a specific vendors SQL dialect, the book introduces the essential core of the language, making it useful for anyone. For this new edition of their successful, long-selling book, David Chappell and J. Harvey Trimble Jr. have updated the contents to reflect SQL today. The result is a clear, step-by-step explanation of the current language, with the books unique visual approach guiding the way. A Visual Introduction to SQL, Second Edition is useful for all levels: For SQL beginners, the unique graphical approach makes learning this sometimes unfriendly language much easier For those with some SQL experience, the visual approach makes clear the languages underlying structure and helps in creating complex queries For regular SQL users, the wealth of examples in this book provides quick, easy-to-reference answers to frequently asked questions No matter what SQL version you use, A Visual Introduction to SQL, Second Edition allows you to quickly grasp both the basic and more advanced features of this important language. Wiley Computer Publishing Timely. Practical. Reliable. Visit our Web site at www.wiley.com/compbooks/, Learn SQL basics quickly with this visual tutorial featuring over 125 graphics SQL (Structured Query Language) is the tool used to access nearly all databases, which means that most software professionals should understand at least the basics. This hands-on tutorial offers an accessible introduction to SQL using over 125 graphics to illustrate the lessons. The book's unique visual approach makes it much easier for the reader to learn SQL. This Second Edition has been updated with new graphics and covers such subjects as the SELECT statement, joins, subqueries, views, granting and revoking privileges, and creating and destroying tables.

LC Classification NumberQA76.73.S67C477 2002