SQL: A Beginner's Guide, Second Edition

Sheldon, Robert

ISBN 10: 0072228857 / ISBN 13: 9780072228854

Editore: McGraw-Hill Osborne Media, 2003

Riguardo questo articolo

No Stock Photos! We photograph every item. edge wear, some light soiling; 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. Codice articolo 059842

Dati bibliografici

Titolo: SQL: A Beginner's Guide, Second Edition

Casa editrice: McGraw-Hill Osborne Media

Data di pubblicazione: 2003

Legatura: Paperback

Condizione: Very Good

Edizione: seconda edizione

Descrizione articolo

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.

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