Test Bank for A Guide to SQL 9th Edition by Philip Pratt, Mary Last – Ebook PDF Instant Download/Delivery: 111152727X, 978-1111527273
Full download A Guide to SQL 9th edition after payment
Product details:
ISBN 10: 111152727X
ISBN 13: 978-1111527273
Author: Philip Pratt, Mary 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.
A Guide to SQL 9th Table of contents:
Chapter 1. Introduction to TAL Distributors, Colonial Adventure Tours, and Solmaris Condominium Group
What Is a Database?
The TAL Distributors Database
The Colonial Adventure Tours Database
The Solmaris Condominium Group Database
Chapter Summary
Key Term
Exercises
Chapter 2. Database Design Fundamentals
Database Concepts
Relational Databases
Entities, Attributes, and Relationships
Functional Dependence
Primary Keys
Database Design
Design Method
Database Design Requirements
Database Design Process Example
Normalization
First Normal Form
Second Normal Form
Third Normal Form
Diagrams for Database Design
Chapter Summary
Key Terms
Review Questions
Exercises
Chapter 3. Creating Tables
Creating and Running SQL Commands
Using the Oracle Database 11g Express Edition
Entering Commands
Creating a Table
Correcting Errors in SQL Commands
Dropping a Table
Using Data Types
Using Nulls
Adding Rows to a Table
The INSERT Command
Inserting a Row that Contains Nulls
Viewing Table Data
Correcting Errors in a Table
Saving SQL Commands
Creating the Remaining Database Tables
Describing a Table
Chapter Summary
Key Terms
Review Questions
Exercises
Chapter 4. Single-Table Queries
Constructing Simple Queries
Retrieving Certain Columns and All Rows
Retrieving All Columns and All Rows
Using a WHERE Clause
Using Compound Conditions
Using the BETWEEN Operator
Using Computed Columns
Using the LIKE Operator
Using the IN Operator
Sorting
Using the ORDER BY Clause
Additional Sorting Options
Using Functions
Using the COUNT Function
Using the SUM Function
Using the AVG, MAX, and MIN Functions
Using the DISTINCT Operator
Nesting Queries
Subqueries
Grouping
Using the GROUP BY Clause
Using a HAVING Clause
HAVING vs. WHERE
Nulls
Summary of SQL Clauses, Functions, and Operators
Chapter Summary
Key Terms
Review Questions
Exercises
Chapter 5. Multiple-Table Queries
Querying Multiple Tables
Joining Two Tables
Comparing Joins, IN, and EXISTS
Using the IN Operator
Using the EXISTS Operator
Using a Subquery Within a Subquery
A Comprehensive Example
Using an Alias
Joining a Table to Itself
Using a Self-Join on a Primary Key Column
Joining Several Tables
Set Operations
ALL and ANY
Special Operations
Inner Join
Outer Join
Product
Chapter Summary
Key Terms
Review Questions
Exercises
Chapter 6. Updating Data
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
Executing a Rollback
Changing a Value in a Column to Null
Changing a Table’s Structure
Making Complex Changes
Dropping a Table
Chapter Summary
Key Terms
Review Questions
Exercises
Chapter 7. Database Administration
Creating and Using Views
Using a View to Update Data
Updating Row-and-Column Subset Views
Updating Views Involving Joins
Updating Views Involving Statistics
Dropping a View
Security
Indexes
Creating an Index
Dropping an Index
Creating Unique Indexes
System Catalog
Update of the System Catalog
Integrity Constraints in SQL
Chapter Summary
Key Terms
Review Questions
Exercises
Chapter 8. SQL Functions and Procedures
Using SQL in a Programming Environment
Using Functions
Character Functions
Number Functions
Working with Dates
Concatenating Columns
Stored Procedures
Retrieving a Single Row and Column
Error Handling
Using Update Procedures
Changing Data with a Procedure
Deleting Data with a Procedure
Selecting Multiple Rows with a Procedure
Using a Cursor
Opening a Cursor
Fetching Rows from a Cursor
Closing a Cursor
Writing a Complete Procedure Using a Cursor
Using More Complex Cursors
Advantages of Cursors
Using T-SQL in SQL Server
Retrieving a Single Row and Column
Changing Data with a Stored Procedure
Deleting Data with a Stored Procedure
Using a Cursor
Using More Complex Cursors
Using SQL in Microsoft Access
Deleting Data with Visual Basic
Running the Code
Updating Data with Visual Basic
Inserting Data with Visual Basic
Finding Multiple Rows with Visual Basic
Using a Trigger
Chapter Summary
Key Terms
Review Questions
Exercises
Appendix A. SQL Reference
Appendix B. How Do I Reference
People also search for A Guide to SQL 9th:
a guide to sql 9th edition pdf free
a guide to sql 9th edition pdf
a guide to sql 9th edition answers
guide to sql 9th edition pdf
a guide to sql 9th edition 2014 pdf
Tags: Philip Pratt, Mary Last, A Guide