SQL a Beginner's Guide : A Beginner's Guide (Beginner's Guide) (2ND)

SQL a Beginner's Guide : A Beginner's Guide (Beginner's Guide) (2ND)

  • ただいまウェブストアではご注文を受け付けておりません。 ⇒古書を探す
  • 製本 Paperback:紙装版/ペーパーバック版/ページ数 560 p.
  • 言語 ENG
  • 商品コード 9780072228854
  • DDC分類 005.756

Full 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.

Contents

Part IWorking 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 ProjectsNER(01): WOW