Testbankszip for study guides

A Guide to SQL

A Guide to SQL 9th Edition

By: Philip J. Pratt Mary Z. Last
ISBN-10: 111152727X
/ ISBN-13: 9781337668880
Edition: 9th Edition
Language: English
				
					=> All chapters included .
=> Download zip file into your device
=> Dedicated support
=> Affordable pricing 

				
			
secure-stripe-payment-logo.png

TEST BANK

$29

Contact

Digital product.

Table of Contents

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


Resource Type:

Authors:

Reviews

Create a Free Account

* We don’t share your personal info with anyone. Check out our Privacy Policy for more information