SQL :Practical Guide for Developers ( The Practical Guides )

Publication subTitle :Practical Guide for Developers

Publication series :The Practical Guides

Author: Donahoo   Michael J.;Speegle   Gregory D.  

Publisher: Elsevier Science‎

Publication year: 2010

E-ISBN: 9780080489742

P-ISBN(Paperback): 9780122205316

P-ISBN(Hardback):  9780122205316

Subject: TP312 程序语言、算法语言

Language: ENG

Access to resources Favorite

Disclaimer: Any content in publications that violate the sovereignty, the constitution or regulations of the PRC is not accepted or approved by CNPIEC.

Description

SQL is a solid guide and reference to the key elements of SQL and how to use it effectively. Developed by authors who needed a good resource for students in their database class, this is an ideal supplement for database courses — no matter what main text you use or what flavor of SQL is required.

It features a short and inexpensive introduction to SQL for students who have some programming experience and need to learn the main features of SQL; and suggested shortcuts for learning and practice, depending on the experience of the user.

This book is recommended for novice developers, programmers, and database administrators as well as students in database courses, business courses, and IT-related courses.

  • Provides tutorial-based instruction for the main features of SQL for programmers and other technical professionals in need of a brief but really good introduction to SQL.
  • The approach is vendor-neutral—so very adaptable and flexible
  • The focus is on teaching concepts by walking through concrete examples and explanations, and self-review exercises are included at the end of each chapter.
  • Coverage is on the key features of the language that are required to understand SQL and begin using it effectively.
  • SQL 2003-compliant.

Chapter

Front Cover

pp.:  1 – 6

Copyright Page

pp.:  7 – 8

Table of Contents

pp.:  8 – 14

Preface

pp.:  14 – 18

Chapter 1. Databasics

pp.:  18 – 44

Chapter 2. Retrieval: Basic SELECTion

pp.:  44 – 64

Chapter 3. Reshaping Results

pp.:  64 – 92

Chapter 4. Aggregating Results

pp.:  92 – 108

Chapter 5. Joins

pp.:  108 – 134

Chapter 6. Set Queries: UNION, INTERSECT, and EXCEPT

pp.:  134 – 144

Chapter 7. Subqueries

pp.:  144 – 182

Chapter 8. Modifying Data

pp.:  182 – 196

Chapter 9. Creating, Deleting, and Altering Tables

pp.:  196 – 222

Chapter 10. Views

pp.:  222 – 232

Chapter 11. Transactions

pp.:  232 – 244

Chapter 12. Database Privileges

pp.:  244 – 254

Chapter 13. Introduction to Cursors, Embedded SQL, Stored Procedures, and Triggers

pp.:  254 – 266

Index

pp.:  266 – 274

The users who browse this book also browse


No browse record.