| 1 Introduction to Database Management Objectives The Premiere Products Database The Henry Books Database Summary Exercises 2 An Introduction to SQL Objectives Introduction Relational Databases Database Creation SQL Commands Dropping a Table Correcting Errors in the Database Additional Tables Summary Exercises 3 Single-Table Queries Objectives Introduction Simple Queries Sorting Using Functions Nesting Queries Grouping Nulls Summary Exercises 4 Multiple-Table Queries Objectives Introduction Querying Multiple Tables Using an Alias More Complex Joins Set Operations ALL and ANY Summary Exercises 5 Updating Data Objectives Introduction Commit and Rollback Changing Existing Data in a Table Adding New Rows to An Existing Table Deleting Existing Rows From a Table Creating a New Table From an Existing Table Creating a Value in a Column to Null Changing a Table’s Structure Summary Exercises 6 Database Administration Objectives Introduction Vie |
内容加载中，请稍后...
商品评论（0条）