SQL : a beginner's guide
Author(s)
Bibliographic Information
SQL : a beginner's guide
(Essential skills - made easy!)
McGraw-Hill/Osborne, c2003
2nd ed
Available at / 2 libraries
-
No Libraries matched.
- Remove all filters.
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"