Javascript required
Skip to content Skip to sidebar Skip to footer
Home / A Guide to Sql 9th Edition Exercise Answers Chapter 8

A Guide to Sql 9th Edition Exercise Answers Chapter 8

A Guide to SQL, 9th Edition

A Guide to SQL

Published: © 2015

Print ISBN: 9781111527273

Pages: 360

Available

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,… More

For Instructors

For Students

  • Table of Contents

  • New to this edition

  • Features

  • About the author(s)

1. Introduction.
2. Database Design Fundamentals.
3. Creating Tables.
4. Single-Table Queries.
5. Multiple-Table Queries.
6. Updating Data.
7. Database Administration.
8. SQL Functions and Procedures.
Appendix A: A SQL Reference.
Appendix B: How Do I Reference.
Appendix C: Answers to Oddly Numbered Questions.

  • Building on the longstanding success of this proven text, the Ninth Edition introduces basic SQL commands in a real-world context using a running case, which explores how a business might use SQL to manage orders, parts, customers, and sales reps.
  • To illustrate that fundamental principles and practices remain valid regardless of which database environment is used, the authors include numerous examples of the latest versions of Oracle®, Microsoft® Access®, and SQL Server.
  • Critical thinking questions and exercises that challenge students to use problem-solving and analytical skills appear in each case.
  • Review questions, exercises, and hands-on projects conclude each chapter to reinforce learning and provide practice applying key concepts. Critical thinking questions and exercises challenge students to use problem-solving and analytical skills.
  • This invaluable reference introduces SQL programming using straightforward instruction, hands-on exercises, and a strong foundation in real-world business scenarios.

Philip J. Pratt

Philip J. Pratt is Professor Emeritus of Mathematics and Computer Science at Grand Valley State University, where he taught for 33 years. His teaching interests include database management, systems analysis, complex analysis and discrete mathematics. He has authored more than 75 textbooks and has co-authored three levels of Microsoft® Office Access books for the popular Shelly Cashman Series, in addition to the popular A GUIDE TO SQL.

Mary Z. Last

Mary Z. Last has taught computer information systems since 1984. She retired from the University of Mary Hardin-Baylor, Belton, Texas, where she was an associate professor and the Director of the Center for Effectiveness in Learning and Teaching. Ms. Last is actively involved in the Computing Educator's Oral History Project that encourages young women to pursue careers in math and science. She has been a contributing author to the Shelly Cashman Series since 1992. She also authors many instructor resources for leading database texts.

Table of Contents

1. Introduction.
2. Database Design Fundamentals.
3. Creating Tables.
4. Single-Table Queries.
5. Multiple-Table Queries.
6. Updating Data.
7. Database Administration.
8. SQL Functions and Procedures.
Appendix A: A SQL Reference.
Appendix B: How Do I Reference.
Appendix C: Answers to Oddly Numbered Questions.

New to this edition

  • Building on the longstanding success of this proven text, the Ninth Edition introduces basic SQL commands in a real-world context using a running case, which explores how a business might use SQL to manage orders, parts, customers, and sales reps.
  • To illustrate that fundamental principles and practices remain valid regardless of which database environment is used, the authors include numerous examples of the latest versions of Oracle®, Microsoft® Access®, and SQL Server.
  • Critical thinking questions and exercises that challenge students to use problem-solving and analytical skills appear in each case.

Features

  • Review questions, exercises, and hands-on projects conclude each chapter to reinforce learning and provide practice applying key concepts. Critical thinking questions and exercises challenge students to use problem-solving and analytical skills.
  • This invaluable reference introduces SQL programming using straightforward instruction, hands-on exercises, and a strong foundation in real-world business scenarios.

About the author(s)

Philip J. Pratt

Philip J. Pratt is Professor Emeritus of Mathematics and Computer Science at Grand Valley State University, where he taught for 33 years. His teaching interests include database management, systems analysis, complex analysis and discrete mathematics. He has authored more than 75 textbooks and has co-authored three levels of Microsoft® Office Access books for the popular Shelly Cashman Series, in addition to the popular A GUIDE TO SQL.

Mary Z. Last

Mary Z. Last has taught computer information systems since 1984. She retired from the University of Mary Hardin-Baylor, Belton, Texas, where she was an associate professor and the Director of the Center for Effectiveness in Learning and Teaching. Ms. Last is actively involved in the Computing Educator's Oral History Project that encourages young women to pursue careers in math and science. She has been a contributing author to the Shelly Cashman Series since 1992. She also authors many instructor resources for leading database texts.

Related Titles

A Guide to Sql 9th Edition Exercise Answers Chapter 8

Source: https://www.cengage.co.uk/books/9781111527273