- ホーム
- > 洋書
- > 英文書
- > Computer / Languages
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