Buku A Guide to SQL 9 Edition 9781111527273

A Guide to SQL 9th Edition
by Philip J. Pratt (Author)

Product details
Publisher ‏ : ‎ Cengage (2014)
Paperback ‏ : ‎ 320 pages
ISBN-13 ‏ : ‎ 978-1111527273
Item Weight ‏ : ‎ 1.24 pounds
Dimensions ‏ : ‎ 7.48 x 0.73 x 9.09 inches

Contents:
Ch 1: Introduction to TAL Distributors, Colonial Adventure Tours, and Solmaris Condominium Group
Ch 1: Objectives
Ch 1: Introduction
What Is a Dtabase?
The TAL Distributors Dtabase
The Colonial Adventure Tours Dtabase
The Solmaris Condominium Group Dtabase
Ch 1: Chapter Summary
Ch 1: Key Term
Ch 1: Exercises
Ch 2: Dtabase Design Fundamentals
Ch 2: Objectives
Ch 2: Introduction
Dtabase Concepts
Functional Dependence
Primary Keys
Dtabase Design
Normalization
Diagrams for Dtabase Design
Ch 2: Chapter Summary
Ch 2: Key Terms
Ch 2: Review Questions
Ch 2: Exercises
Ch 3: Creating Tables
Ch 3: Objectives
Ch 3: Introduction
Creating and Running SQL Commands
Creating a Table
Using Data Types
Using Nulls
Adding Rows to a Table
Viewing Table Data
Correcting Errors in a Table
Saving SQL Commands
Creating the Remaining Dtabase Tables
Describing a Table
Ch 3: Chapter Summary
Ch 3: Key Terms
Ch 3: Review Questions
Ch 3: Exercises
Ch 4: Single-Table Queries
Ch 4: Objectives
Ch 4: Introduction
Constructing Simple Queries
Sorting
Using Functions
Nesting Queries
Grouping
Nulls
Summary of SQL Clauses, Functions, and Operators
Ch 4: Chapter Summary
Ch 4: Key Terms
Ch 4: Review Questions
Ch 4: Exercises
Ch 5: Multiple-Table Queries
Ch 5: Objectives
Ch 5: Introduction
Querying Multiple Tables
Comparing Joins, IN, and EXISTS
Set Operations
ALL and ANY
Special Operations
Ch 5: Chapter Summary
Ch 5: Key Terms
Ch 5: Review Questions
Ch 5: Exercises
Ch 6: Updating Data
Ch 6: Objectives
Ch 6: Introduction
Creating a New Table from an Existing Table
Changing Existing Data in a Table
Adding New Rows to an Existing Table
Autocommit, Commit, and Rollback
Transactions
Changing and Deleting Existing Rows
Changing a Value in a Column to Null
Changing a T