Guide to SQL 9th Edition Pratt Test Bank
You may also like
Guide to SQL 9th Edition Pratt Test Bank
Product details:
- ISBN-10 : 111152727X
- ISBN-13 : 978-1111527273
- Author: Philip J. Pratt, Mary Z. Last
A GUIDE TO SQL, Ninth Edition, provides an effective introduction to SQL programming using straightforward instruction, extensive hands-on exercises, and a strong foundation in real-world business applications. The Ninth Edition builds on the longstanding success of this proven text by presenting basic SQL commands in the context of a running case, in which a business uses SQL to manage orders, items, customers, and sales reps. The authors emphasize that fundamental principles and practices apply regardless of the database environment chosen, and they include examples from the latest versions of Oracle and Microsoft Access, and SQL Server throughout the text.
Table 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
People also search:
Guide to sql 9th edition
A guide to sql 9th edition pdf free download
A guide to sql 9th edition solutions pdf
A guide to sql 9th edition chapter 5 answers
A guide to sql 9th edition pdf
