SQL : a beginner's guide

Author(s)

    • Sheldon, Robert
    • Houlette, Forrest

Bibliographic Information

SQL : a beginner's guide

Robert Sheldon

(Essential skills - made easy!)

McGraw-Hill/Osborne, c2003

2nd ed

Available at  / 2 libraries

Search this Book/Journal

Note

Rev. ed. of: SQL: a beginner's guide / Forrest Houlette. Berkeley, Calif. : Osborne/McGraw-Hill, 2001

Includes index

Description and Table of Contents

Description

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.

Table of Contents

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

by "Nielsen BookData"

Related Books: 1-1 of 1

Details

Page Top