Items related to The Language of SQL: How to Access Data in Relational...

The Language of SQL: How to Access Data in Relational Databases - Softcover

  • 4.02 out of 5 stars
    129 ratings by Goodreads
 
Image Not Available

Synopsis

Most SQL texts attempt to serve as an encyclopedic reference on SQL syntax -- an approach that is counterproductive, since this information is readily available in online references published by the major database vendors. For SQL beginners, it's more important for a book to focus on general concepts and offer clear explanations and examples of what the various statements can accomplish. This is that beginner book. A number of features make The LANGUAGE OF SQL unique among introductory SQL books. First, you will not be required to download software or sit with a computer as you read the text. The intent of this book is to provide examples of SQL usage that can be understood simply by reading them. Second, topics are organized in an intuitive and logical sequence. SQL keywords are introduced one at a time, allowing you to build on your prior understanding as you encounter new words and concepts. Finally, this book covers the syntax of three widely used databases: Microsoft SQL Server, MySQL, and Oracle, with special "Database Differences" boxes that will show you any differences in the syntax among those three databases, as well as instructions on how to obtain and install free versions of the databases. This is the only book you'll need to gain a working knowledge of SQL and relational databases.

"synopsis" may belong to another edition of this title.

About the Author

Larry Rockoff has been involved with Business Intelligence and Data Warehouse development for many years. His main area of interest is with using reporting tools to explore, extract, and analyze data in complex databases. He holds an MBA from the University of Chicago, with a specialization in Management Science.

Review

1. Relational Databases and SQL. 2. Basic Data Retrieval. 3. Calculations and Aliases. 4. Using Functions. 5. Sorting Data. 6. Column Based Logic. 7. Row Based Logic. 8. Boolean Logic. 9. Inexact Matches. 10. Summarizing Data. 11. Combining Tables with an Inner Join. 12. Combining Tables with an Outer Join. 13. Self Joins and Views. 14. Subqueries. 15. Set Logic. 16. Stored Procedures and Parameters. 17. Modifying Data. 18. Maintaining Tables. 19. Principles of Database Design. 20. Strategies for Displaying Data. Appendix A. Getting Started with Microsoft SQL Server. Appendix B. Getting Started with MySQL. Appendix C. Getting Started with Oracle Database. Appendix D. Listing of All SQL Statements.

"About this title" may belong to another edition of this title.

  • PublisherCengage Learning PTR
  • Publication date2010
  • ISBN 10 143545751X
  • ISBN 13 9781435457515
  • BindingPaperback
  • LanguageEnglish
  • Edition number1
  • Number of pages256
  • Rating
    • 4.02 out of 5 stars
      129 ratings by Goodreads

Buy Used

Condition: Good
Item in good condition. Textbooks... View this item

Shipping: FREE
Within U.S.A.

Destination, rates & speeds

Add to basket

Buy New

View this item

Shipping: US$ 12.91
From United Kingdom to U.S.A.

Destination, rates & speeds

Add to basket

Search results for The Language of SQL: How to Access Data in Relational...

Stock Image

Rockoff, Larry
Published by Cengage Learning PTR, 2010
ISBN 10: 143545751X ISBN 13: 9781435457515
Used Softcover

Seller: SecondSale, Montgomery, IL, U.S.A.

Seller rating 5 out of 5 stars 5-star rating, Learn more about seller ratings

Condition: Good. Item in good condition. Textbooks may not include supplemental items i.e. CDs, access codes etc. Seller Inventory # 00080427086

Contact seller

Buy Used

US$ 3.98
Convert currency
Shipping: FREE
Within U.S.A.
Destination, rates & speeds

Quantity: 3 available

Add to basket

Stock Image

Rockoff, Larry
Published by Delmar Cengage Learning, 2010
ISBN 10: 143545751X ISBN 13: 9781435457515
Used Softcover

Seller: Better World Books, Mishawaka, IN, U.S.A.

Seller rating 5 out of 5 stars 5-star rating, Learn more about seller ratings

Condition: Good. Former library book; may include library markings. Used book that is in clean, average condition without any missing pages. Seller Inventory # GRP76994396

Contact seller

Buy Used

US$ 4.00
Convert currency
Shipping: FREE
Within U.S.A.
Destination, rates & speeds

Quantity: 1 available

Add to basket

Stock Image

Rockoff, Larry
Published by Cengage Learning PTR, 2010
ISBN 10: 143545751X ISBN 13: 9781435457515
Used Softcover

Seller: Goodwill of Colorado, COLORADO SPRINGS, CO, U.S.A.

Seller rating 5 out of 5 stars 5-star rating, Learn more about seller ratings

Condition: Good. This item is in overall good condition. Covers and dust jackets are intact but may have minor wear including slight curls or bends to corners as well as cosmetic blemishes including stickers. Pages are intact but may have minor highlighting/ writing. Binding is intact; however, spine may have slight wear overall. Minor shelf wear overall. Please note that all items are donated goods and are in used condition. Orders shipped Monday through Friday! Your purchase helps put people to work and learn life skills to reach their full potential. Orders shipped Monday through Friday. Your purchase helps put people to work and learn life skills to reach their full potential. Thank you! Seller Inventory # 466OE3002IJ4

Contact seller

Buy Used

US$ 5.13
Convert currency
Shipping: FREE
Within U.S.A.
Destination, rates & speeds

Quantity: 1 available

Add to basket

Stock Image

Rockoff, Larry
Published by Cengage Learning PTR, 2010
ISBN 10: 143545751X ISBN 13: 9781435457515
Used Softcover

Seller: More Than Words, Waltham, MA, U.S.A.

Seller rating 5 out of 5 stars 5-star rating, Learn more about seller ratings

Condition: Very Good. . . All orders guaranteed and ship within 24 hours. Before placing your order for please contact us for confirmation on the book's binding. Check out our other listings to add to your order for discounted shipping. Seller Inventory # WAL-B-0g-002146

Contact seller

Buy Used

US$ 1.26
Convert currency
Shipping: US$ 3.99
Within U.S.A.
Destination, rates & speeds

Quantity: 1 available

Add to basket

Stock Image

Rockoff, Larry
Published by Course Technology, 2010
ISBN 10: 143545751X ISBN 13: 9781435457515
Used Paperback

Seller: ThriftBooks-Dallas, Dallas, TX, U.S.A.

Seller rating 5 out of 5 stars 5-star rating, Learn more about seller ratings

Paperback. Condition: Very Good. No Jacket. May have limited writing in cover pages. Pages are unmarked. ~ ThriftBooks: Read More, Spend Less 1. Seller Inventory # G143545751XI4N00

Contact seller

Buy Used

US$ 6.99
Convert currency
Shipping: FREE
Within U.S.A.
Destination, rates & speeds

Quantity: 1 available

Add to basket

Stock Image

Rockoff, Larry
ISBN 10: 143545751X ISBN 13: 9781435457515
Used Paperback

Seller: BooksRun, Philadelphia, PA, U.S.A.

Seller rating 5 out of 5 stars 5-star rating, Learn more about seller ratings

Paperback. Condition: Good. 1. Ship within 24hrs. Satisfaction 100% guaranteed. APO/FPO addresses supported. Seller Inventory # 143545751X-11-1

Contact seller

Buy Used

US$ 6.99
Convert currency
Shipping: FREE
Within U.S.A.
Destination, rates & speeds

Quantity: 1 available

Add to basket

Stock Image

Rockoff, Larry
Published by Course Technology, 2010
ISBN 10: 143545751X ISBN 13: 9781435457515
Used Paperback

Seller: ThriftBooks-Atlanta, AUSTELL, GA, U.S.A.

Seller rating 5 out of 5 stars 5-star rating, Learn more about seller ratings

Paperback. Condition: Very Good. No Jacket. May have limited writing in cover pages. Pages are unmarked. ~ ThriftBooks: Read More, Spend Less 1. Seller Inventory # G143545751XI4N00

Contact seller

Buy Used

US$ 6.99
Convert currency
Shipping: FREE
Within U.S.A.
Destination, rates & speeds

Quantity: 1 available

Add to basket

Stock Image

Rockoff, Larry
Published by Course Technology, 2010
ISBN 10: 143545751X ISBN 13: 9781435457515
Used Paperback

Seller: ThriftBooks-Reno, Reno, NV, U.S.A.

Seller rating 5 out of 5 stars 5-star rating, Learn more about seller ratings

Paperback. Condition: Very Good. No Jacket. May have limited writing in cover pages. Pages are unmarked. ~ ThriftBooks: Read More, Spend Less 1. Seller Inventory # G143545751XI4N00

Contact seller

Buy Used

US$ 6.99
Convert currency
Shipping: FREE
Within U.S.A.
Destination, rates & speeds

Quantity: 1 available

Add to basket

Stock Image

Rockoff, Larry
Published by Cengage Learning PTR, 2010
ISBN 10: 143545751X ISBN 13: 9781435457515
Used paperback

Seller: Books Liquidation, Sacramento, CA, U.S.A.

Seller rating 5 out of 5 stars 5-star rating, Learn more about seller ratings

paperback. Condition: VeryGood. Very good condition, clean, no writings. Seller Inventory # 53IN3G002793

Contact seller

Buy Used

US$ 3.01
Convert currency
Shipping: US$ 3.99
Within U.S.A.
Destination, rates & speeds

Quantity: 1 available

Add to basket

Stock Image

Rockoff, Larry
Published by Cengage Learning PTR, 2010
ISBN 10: 143545751X ISBN 13: 9781435457515
Used Softcover

Seller: medimops, Berlin, Germany

Seller rating 5 out of 5 stars 5-star rating, Learn more about seller ratings

Condition: very good. Gut/Very good: Buch bzw. Schutzumschlag mit wenigen Gebrauchsspuren an Einband, Schutzumschlag oder Seiten. / Describes a book or dust jacket that does show some signs of wear on either the binding, dust jacket or pages. Seller Inventory # M0143545751X-V

Contact seller

Buy Used

US$ 6.57
Convert currency
Shipping: US$ 9.89
From Germany to U.S.A.
Destination, rates & speeds

Quantity: 1 available

Add to basket

There are 5 more copies of this book

View all search results for this book