SQL: A Beginner's Guide, Second Edition - Brossura

Sheldon, Robert

Brossura

ISBN 10: 0072228857 ISBN 13: 9780072228854

Casa editrice: McGraw-Hill Education, 2003

Riassunto

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.

Su questo libro

Contenuti

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

Product Description

Book by Robert Sheldon

Dettagli dell?edizione

• Editore: McGraw-Hill Education
• Data di pubblicazione: 2003
• ISBN 10: 0072228857
• ISBN 13: 9780072228854
• Rilegatura: Copertina flessibile
• Lingua: Inglese
• Numero edizione: 2
• Numero di pagine: 560