9780072228854

Here is the foundation upon which you can build your relational database design and programming, then apply those skills to any SQL-based product. Carefully organized for beginners, you'¬"ll learn step-by-step how to create a database, create tables, enforce data integrity, query and modify data, and implement advanced data access techniques.

Robert Sheldon has written or co-written eight books on various network and server technologies. As a consultant, he has designed and implemented various Access and SQL Server databases, as well as a variety of Web-based solutions

Part I: SQL Databases
1: Introduction to Relational Databases and SQL
2: Working with the SQL Environment
3: Creating and Altering Tables
4: Enforcing Data Integrity
5: Creating SQL Views
6: Managing Database Security
Part II: Data Access and Modification
7: Querying SQL Data
8: Modifying SQL Data
9: Using Predicates
10: Working with Functions and Value Expressions
11: Accessing Multiple Tables
12: Using Subqueries to Access and Modify Data
Part III: Advanced Data Access
13: Creating SQL-Invoked Routines
14: Creating SQL Triggers
15: Using SQL Cursors
16: Managing SQL Transactions
17: Accessing SQL Data from Your Host Program
Part IV: Appendixes
A: Answers to Mastery Checks
B: SQL:1999 Keywords
C: SQL Code Used in the Book’s Projects

What is included with this book?

The New copy of this book will include any supplemental materials advertised. Please check the title of the book to determine if it should include any access cards, study guides, lab manuals, CDs, etc.

The Used, Rental and eBook copies of this book are not guaranteed to include any supplemental materials. Typically, only the book itself is included. This is true even if the title states it includes any access cards, study guides, lab manuals, CDs, etc.

Amazon no longer offers textbook rentals. We do!

SQL: A Beginner's Guide, Second Edition

SQL: A Beginner's Guide, Second Edition

0072228857

Summary

Author Biography

Table of Contents

1: Introduction to Relational Databases and SQL

2: Working with the SQL Environment

3: Creating and Altering Tables

4: Enforcing Data Integrity

5: Creating SQL Views

6: Managing Database Security

Part II: Data Access and Modification

7: Querying SQL Data

8: Modifying SQL Data

9: Using Predicates

10: Working with Functions and Value Expressions

11: Accessing Multiple Tables

12: Using Subqueries to Access and Modify Data

Part III: Advanced Data Access

13: Creating SQL-Invoked Routines

14: Creating SQL Triggers

15: Using SQL Cursors

16: Managing SQL Transactions

17: Accessing SQL Data from Your Host Program

Part IV: Appendixes

A: Answers to Mastery Checks

B: SQL:1999 Keywords

C: SQL Code Used in the Book’s Projects

Supplemental Materials