A Guide to SQL, 8th Edition

Book Description

A GUIDE TO SQL, 8E, continues to be the essential SQL reference. It builds on the success of previous editions by presenting basic SQL commands in the context of a running case in which a uses SQL to manage orders, parts, customers, and reps. The book covers the fundamentals of SQL using straightforward instruction and extensive hands-on exercises. Continuing with its focus on learning the basics regardless of the database environment chosen, this edition features examples from the latest : Oracle 11g, Access 2007, and . The eighth edition expands on the use of running case studies by adding a third running case to the extensive hands-on pedagogy at the end of every chapter.The author uses an interesting didactic innovation that every textbook writer should consider imitating: Instead of illustrating ideas with microprograms, which are good for almost nothing except illustrating the idea, Pratt develops two examples throughout the entire book. By the time you complete this thin but comprehensive volume, you will have completed two real databases. The book also contains embedded questions so you can check whether or not you've grasped specific concepts before proceeding to the next section. Pratt's extended case studies show how SQL programs can be layered on one another other to slowly build up functionality. As such, it serves both as an SQL language manual as well as an example of how to create relatively large SQL codes. This book does not make specific reference to any particular SQL implementation, so it can be used with any standard SQL engine.

Table of Contents

Chapter 1 Introduction to Premiere Products, Henry Books, and Alexamara Marina Group
Chapter 2 Fundamentals
Chapter 3 Creating Tables
Chapter 4 Single-Table Queries
Chapter 5 Multiple-Table Queries
Chapter 6 Updating Data
Chapter 7 Database Administration
Chapter 8 SQL Functions and Procedures
Appendix A: SQL Reference
Appendix B: How Do I Reference
APPENDIX C: Answers to Odd-Numbered Review Questions

Book Details

  • Title: A Guide to SQL, 8th Edition
  • Author: ,
  • Length: 328 pages
  • Edition: 8
  • Language: English
  • Publisher:
  • Publication Date: 2008-10-02
  • ISBN-10: 0324597681
  • ISBN-13: 9780324597684

Book DownloadDownload Help »

Amazon.com - Read eBooks using the FREE Kindle Reading App on Most Devices.

File HostFree Download LinkFormatSize (MB)ThanksUpload Date
EU(multi) Click to downloadPDF3.4foxebook08/29/2014
FilePi Click to downloadPDF3.4foxebook09/04/2014
UpLoaded Click to downloadPDF3.4foxebook09/16/2014
UpLoaded Click to downloadPDF3.4foxebook09/16/2014
ZippyShare Click to downloadPDF3.4foxebook09/16/2014
ZippyShare Click to downloadPDF3.4foxebook09/16/2014
Buy Me a Coffee Report Dead Links & Get a Copy

Comments

  1. Reginald Mckenzie says

    Thank you for making the SQL e-book available because it’s common knowledge most students are on a budget.

Leave a Reply

Your email address will not be published. Required fields are marked *

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>