SQL Demystified

Andrew Oppel

  • 出版商: McGraw-Hill Education
  • 出版日期: 2005-11-01
  • 定價: $700
  • 售價: 4.3$299
  • 語言: 英文
  • 頁數: 312
  • 裝訂: Paperback
  • ISBN: 0072262249
  • ISBN-13: 9780072262247
  • 相關分類: SQL
  • 立即出貨 (庫存 < 3)





There’s no easier, faster, or more practical way to learn the really tough subjects

SQL Demystified explains how to use SQL (Structured Query Language)--the ubiquitous programming language for databases. Readers will learn to create database objects, add and retrieve data from a database, and modify existing data. This self-teaching guide comes complete with key points, background information, quizzes at the end of each chapter, and even a final exam. Simple enough for beginners but challenging enough for advanced students, this is a lively and entertaining brush-up, introductory text, or classroom supplement.


Table of Contents:

Chapter 1: Relational Database Concepts
Chapter 2: SQL Concepts
Chapter 3: Defining Database Objects Using SQL
Chapter 4: Retrieving Data Using Data Query Language (DQL)
Chapter 5: Combining Data From Multiple Tables
Chapter 6: Advanced Query Writing
Chapter 7: Maintaining Data Using Data Manipulation Language (DML)
Chapter 8: Applying Security Controls Using Data Control Language (DCL)
Chapter 9: Preserving Database Integrity Using Transactions
Chapter 10: Integrating SQL into Applications
Chapter 11: SQL Performance Tuning Considerations
Appendix A: CREATE TABLE Statements for Book Examples
Appendix B: INSERT Statements for Data in Book Examples
Appendix C: Final Exam
Appendix D: Answers to Quizzes and Final Exam