SQL Demystified
內容描述
Description:
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