HOME > 상세정보

상세정보

A visual introduction to SQL 2nd ed

A visual introduction to SQL 2nd ed (4회 대출)

자료유형
단행본
개인저자
Chappell, David (David Wayne) Trimble, J. Harvey.
서명 / 저자사항
A visual introduction to SQL / David Chappell, J. Harvey Trimble.
판사항
2nd ed.
발행사항
New York :   Wiley,   2002.  
형태사항
xii, 291 p. : ill. ; 24 cm.
ISBN
0471412767 (pbk. : alk. paper)
일반주기
Trimble's name appears first on the earlier edition.  
Includes index.  
일반주제명
SQL (Computer program language)
000 00878camuu22002774a 4500
001 000000800003
005 20021226113230
008 010821s2002 nyua 001 0 eng
010 ▼a 01046610
020 ▼a 0471412767 (pbk. : alk. paper)
040 ▼a DLC ▼c DLC ▼d 211009
042 ▼a pcc
049 1 ▼l 121068068 ▼f 과학
050 0 0 ▼a QA76.73.S67 ▼b C477 2002
082 0 0 ▼a 005.75/65 ▼2 21
090 ▼a 005.7565 ▼b C467v2
100 1 ▼a Chappell, David ▼q (David Wayne)
245 1 2 ▼a A visual introduction to SQL / ▼c David Chappell, J. Harvey Trimble.
250 ▼a 2nd ed.
260 ▼a New York : ▼b Wiley, ▼c 2002.
300 ▼a xii, 291 p. : ▼b ill. ; ▼c 24 cm.
500 ▼a Trimble's name appears first on the earlier edition.
500 ▼a Includes index.
650 0 ▼a SQL (Computer program language)
700 1 ▼a Trimble, J. Harvey.

소장정보

No. 소장처 청구기호 등록번호 도서상태 반납예정일 예약 서비스
No. 1 소장처 과학도서관/Sci-Info(2층서고)/ 청구기호 005.7565 C467v2 등록번호 121068068 도서상태 대출가능 반납예정일 예약 서비스 B M

컨텐츠정보

목차

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.

Appendix A: The Example Database.

Appendix B: List of Examples.

Appendix C: The Example Database.

Index.


정보제공 : Aladin

관련분야 신착자료

Ramamurthy, Bina (2021)
윤관식 (2020)