Computer Science > eBook[PDF] > A Guide to SQL, 9th Edition By Philip Pratt, Mary Last ebook (All)

A Guide to SQL, 9th Edition By Philip Pratt, Mary Last ebook

Document Content and Description Below

eBook for A Guide to SQL, 9th Edition By Philip J. Pratt, Mary Z. Last Get all 8 chapters ebook pdf. Table of Contents Preface Ch 1: Introduction to TAL Distributors, Colonial Adventure Tours, and Solmaris Condominium Group Ch 1: Objectives Ch 1: Introduction What Is a Database? The TAL Distributors Database The Colonial Adventure Tours Database The Solmaris Condominium Group Database Ch 1: Chapter Summary Ch 1: Key Term Ch 1: Exercises Ch 2: Database Design Fundamentals Ch 2: Objectives Ch 2: Introduction Database Concepts Functional Dependence Primary Keys Database Design Normalization Diagrams for Database Design Ch 2: Chapter Summary Ch 2: Key Terms Ch 2: Review Questions Ch 2: Exercises Ch 3: Creating Tables Ch 3: Objectives Ch 3: Introduction Creating and Running SQL Commands Creating a Table Using Data Types Using Nulls Adding Rows to a Table Viewing Table Data Correcting Errors in a Table Saving SQL Commands Creating the Remaining Database Tables Describing a Table Ch 3: Chapter Summary Ch 3: Key Terms Ch 3: Review Questions Ch 3: Exercises Ch 4: Single-Table Queries Ch 4: Objectives Ch 4: Introduction Constructing Simple Queries Sorting Using Functions Nesting Queries Grouping Nulls Summary of SQL Clauses, Functions, and Operators Ch 4: Chapter Summary Ch 4: Key Terms Ch 4: Review Questions Ch 4: Exercises Ch 5: Multiple-Table Queries Ch 5: Objectives Ch 5: Introduction Querying Multiple Tables Comparing Joins, IN, and EXISTS Set Operations ALL and ANY Special Operations Ch 5: Chapter Summary Ch 5: Key Terms Ch 5: Review Questions Ch 5: Exercises Ch 6: Updating Data Ch 6: Objectives Ch 6: Introduction Creating a New Table from an Existing Table Changing Existing Data in a Table Adding New Rows to an Existing Table Autocommit, Commit, and Rollback Transactions Changing and Deleting Existing Rows Changing a Value in a Column to Null Changing a Table’s Structure Dropping a Table Ch 6: Chapter Summary Ch 6: Key Terms Ch 6: Review Questions Ch 6: Exercises Ch 7: Database Administration Ch 7: Objectives Ch 7: Introduction Creating and Using Views Using a View to Update Data Dropping a View Security Indexes System Catalog Integrity Constraints in SQL Ch 7: Chapter Summary Ch 7: Key Terms Ch 7: Review Questions Ch 7: Exercises Ch 8: SQL Functions and Procedures Ch 8: Objectives Ch 8: Introduction Using SQL in a Programming Environment Using Functions Concatenating Columns Stored Procedures Error Handling Using Update Procedures Selecting Multiple Rows with a Procedure Using T-SQL in SQL Server Using SQL in Microsoft Access Using a Trigger Ch 8: Chapter Summary Ch 8: Key Terms Ch 8: Review Questions Ch 8: Exercises Appendix A: SQL Reference Appendix B: How Do I Reference Appendix C: Answers to Odd-Numbered Review Questions Index

[Show More]

Last updated: 2 weeks ago

Preview 1 out of 1160 pages

Buy Now

Instant download