Joe Celko's Analytics and OLAP in SQL (The Morgan Kaufmann Series in Data Management Systems)

3.36 avg rating
( 14 ratings by Goodreads )
 
9780123695123: Joe Celko's Analytics and OLAP in SQL (The Morgan Kaufmann Series in Data Management Systems)

Joe Celko's Analytics and OLAP in SQL is the first book that teaches what SQL programmers need in order to successfully make the transition from On-Line Transaction Processing (OLTP) systems into the world of On-Line Analytical Processing (OLAP). This book is not an in-depth look at particular subjects, but an overview of many subjects that will give the working RDBMS programmers a map of the terra incognita they will face - if they want to grow.

It contains expert advice from a noted SQL authority and award-winning columnist, who has given ten years of service to the ANSI SQL standards committee and many more years of dependable help to readers of online forums. It offers real-world insights and lots of practical examples. It covers the OLAP extensions in SQL-99; ETL tools, OLAP features supported in DBMSs, other query tools, simple reports, and statistical software.

This book is ideal for experienced SQL programmers who have worked with OLTP systems who need to learn techniques-and even some tricks-that they can use in an OLAP situation.

  • Expert advice from a noted SQL authority and award-winning columnist, who has given ten years of service to the ANSI SQL standards committee and many more years of dependable help to readers of online forums
  • First book that teaches what SQL programmers need in order to successfully make the transition from transactional systems (OLTP) into the world of data warehouse data and OLAP
  • Offers real-world insights and lots of practical examples
  • Covers the OLAP extensions in SQL-99; ETL tools, OLAP features supported in DBMSs, other query tools, simple reports, and statistical software

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

Product Description:

Before SQL programmers could begin working with OLTP (On-Line Transaction Processing) systems, they had to unlearn procedural, record-oriented programming before moving on to SQL's declarative, set-oriented programming. This book covers the next step in your growth. OLAP (On-Line Analytical Processing), Data Warehousing and Analytics involve seeing data in the aggregate and over time, not as single transactions. Once more it is time to unlearn what you were previously taught.

This book is not an in-depth look at particular subjects, but an overview of many subjects that will give the working RDBMS programmers a map of the terra incognita they will face-if they want to grow.

* Expert advice from a noted SQL authority and award-winning columnist, who has given ten years of service to the ANSI SQL standards committee and many more years of dependable help to readers of online forums.

* First book that teaches what SQL programmers need in order to successfully make the transition from transactional systems (OLTP) into the world of data warehouse data and OLAP.

* Offers real-world insights and lots of practical examples.

* Covers the OLAP extensions in SQL-99; ETL tools, OLAP features supported in DBMSs, other query tools, simple reports, and statistical software.

Book Description:

The First book that teaches what SQL programmers need in order to successfully make the transition from transactional systems (OLTP) into the world of OLAP.

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

Top Search Results from the AbeBooks Marketplace

International Edition
International Edition

1.

Joe Celko
ISBN 10: 0123695120 ISBN 13: 9780123695123
New Paperback Quantity Available: 5
International Edition
Seller
PRIORITY BOOKS
(springfield, VA, U.S.A.)
Rating
[?]

Book Description Paperback. Book Condition: New. Softcover Book, Condition: New. 1st Edition. [Please Read Carefully Before Buying], This Is An International Edition. Printed In Black and White. 208 Pages, Book Cover And ISBN No May Be Different From US Edition. Restricted Sales Disclaimer Wordings Not For Sales In USA And Canada May Be Printed On The Cover Of The Book. Standard Shipping 7-14 Business Days. Expedited Shiping 4-8 Business Days. ***WE DO NOT ENTERTAIN BULK ORDERS.*** The Books May Be Ship From Overseas For Inventory Purpose. Bookseller Inventory # 354465

More Information About This Seller | Ask Bookseller a Question

Buy New
US$ 13.24
Convert Currency

Add to Basket

Shipping: US$ 3.99
Within U.S.A.
Destination, Rates & Speeds
International Edition
International Edition

2.

Joe Celko
ISBN 10: 0123695120 ISBN 13: 9780123695123
New Softcover First Edition Quantity Available: > 20
International Edition
Seller
GREAT BOOKS DEAL
(TALLAHASSEE, FL, U.S.A.)
Rating
[?]

Book Description Softcover. Book Condition: New. 1st edition. Brand New; Paperback; Black & White or Color International Edition. ISBN and Cover page may differ but similar contents as US edition. GET IT FAST in 3-5 business days by DHL/FEDEX with tracking number. Books printed in English. No shipping to PO Box/APO/FPO address. In some instances, the international textbooks may have different end chapter case studies and exercises. International Edition Textbooks may bear a label "Not for sale in the U.S. or Canada" and "Content may different from U.S. Edition" - printed only to discourage U.S. students from obtaining an affordable copy. The U.S. Supreme Court has asserted your right to purchase international editions, and ruled on this issue. Access code or CD is not provided with these editions, unless specified. We may ship the books from multiple warehouses across the globe, including India depending upon the availability of inventory storage. Customer satisfaction guaranteed. Bookseller Inventory # INAB1486677

More Information About This Seller | Ask Bookseller a Question

Buy New
US$ 13.30
Convert Currency

Add to Basket

Shipping: US$ 3.95
Within U.S.A.
Destination, Rates & Speeds
International Edition
International Edition

3.

Joe Celko
ISBN 10: 0123695120 ISBN 13: 9780123695123
New Paperback Quantity Available: 1
International Edition
Seller
Nick Book House
(fresno, CA, U.S.A.)
Rating
[?]

Book Description Paperback. Book Condition: New. New Softcover International Edition, Printed in Black and White, Different ISBN, Same Content As US edition, Book Cover may be Different, in English Language. Bookseller Inventory # 19816

More Information About This Seller | Ask Bookseller a Question

Buy New
US$ 13.27
Convert Currency

Add to Basket

Shipping: US$ 3.99
Within U.S.A.
Destination, Rates & Speeds
International Edition
International Edition

4.

Celko
ISBN 10: 0123695120 ISBN 13: 9780123695123
New Softcover Quantity Available: 10
International Edition
Seller
bookscollection
(Delhi, DELHI, India)
Rating
[?]

Book Description Book Condition: Brand New. PAPERBACK,Book Condition New, Brand New, Softcover, International Edition. We Do not Ship APO FPO AND PO BOX. Cover Image & ISBN may be different from US edition but contents as US Edition. Printing in English language. Quick delivery by USPS/UPS/DHL/FEDEX/ARAMEX ,Customer satisfaction guaranteed. We may ship the books from Asian regions for inventory purpose. Bookseller Inventory # ABESTTND8930

More Information About This Seller | Ask Bookseller a Question

Buy New
US$ 14.81
Convert Currency

Add to Basket

Shipping: US$ 5.17
From India to U.S.A.
Destination, Rates & Speeds
International Edition
International Edition

5.

CELKO'S JOE
ISBN 10: 0123695120 ISBN 13: 9780123695123
New Quantity Available: 5
International Edition
Seller
firstbookstore
(New Delhi, India)
Rating
[?]

Book Description Book Condition: Brand New. Brand New Paperback International Edition, Perfect Condition. Printed in English. Excellent Quality, Service and customer satisfaction guaranteed!. Bookseller Inventory # AIND-42001

More Information About This Seller | Ask Bookseller a Question

Buy New
US$ 22.45
Convert Currency

Add to Basket

Shipping: FREE
From India to U.S.A.
Destination, Rates & Speeds
International Edition
International Edition

6.

CELKO'S JOE
ISBN 10: 0123695120 ISBN 13: 9780123695123
New Softcover Quantity Available: 5
International Edition
Seller
Romtrade Corp.
(STERLING HEIGHTS, MI, U.S.A.)
Rating
[?]

Book Description Book Condition: New. Brand New Paperback International Edition.We Ship to PO BOX Address also. EXPEDITED shipping option also available for faster delivery. Bookseller Inventory # AUSBNEW-42001

More Information About This Seller | Ask Bookseller a Question

Buy New
US$ 24.78
Convert Currency

Add to Basket

Shipping: FREE
Within U.S.A.
Destination, Rates & Speeds

7.

Joe Celko
Published by ELSEVIER SCIENCE TECHNOLOGY, United States (2011)
ISBN 10: 0123695120 ISBN 13: 9780123695123
New Paperback Quantity Available: 1
Seller
The Book Depository US
(London, United Kingdom)
Rating
[?]

Book Description ELSEVIER SCIENCE TECHNOLOGY, United States, 2011. Paperback. Book Condition: New. 230 x 190 mm. Language: English . Brand New Book. Joe Celko s Analytics and OLAP in SQL is the first book that teaches what SQL programmers need in order to successfully make the transition from On-Line Transaction Processing (OLTP) systems into the world of On-Line Analytical Processing (OLAP). This book is not an in-depth look at particular subjects, but an overview of many subjects that will give the working RDBMS programmers a map of the terra incognita they will face - if they want to grow. It contains expert advice from a noted SQL authority and award-winning columnist, who has given ten years of service to the ANSI SQL standards committee and many more years of dependable help to readers of online forums. It offers real-world insights and lots of practical examples. It covers the OLAP extensions in SQL-99; ETL tools, OLAP features supported in DBMSs, other query tools, simple reports, and statistical software. This book is ideal for experienced SQL programmers who have worked with OLTP systems who need to learn techniques-and even some tricks-that they can use in an OLAP situation. Bookseller Inventory # AA59780123695123

More Information About This Seller | Ask Bookseller a Question

Buy New
US$ 33.88
Convert Currency

Add to Basket

Shipping: FREE
From United Kingdom to U.S.A.
Destination, Rates & Speeds

8.

Joe Celko
Published by ELSEVIER SCIENCE TECHNOLOGY, United States (2011)
ISBN 10: 0123695120 ISBN 13: 9780123695123
New Paperback Quantity Available: 1
Seller
The Book Depository
(London, United Kingdom)
Rating
[?]

Book Description ELSEVIER SCIENCE TECHNOLOGY, United States, 2011. Paperback. Book Condition: New. 230 x 190 mm. Language: English . Brand New Book. Before SQL programmers could begin working with OLTP (On-Line Transaction Processing) systems, they had to unlearn procedural, record-oriented programming before moving on to SQL s declarative, set-oriented programming. This book covers the next step in your growth. OLAP (On-Line Analytical Processing), Data Warehousing and Analytics involve seeing data in the aggregate and over time, not as single transactions. Once more it is time to unlearn what you were previously taught. This book is not an in-depth look at particular subjects, but an overview of many subjects that will give the working RDBMS programmers a map of the terra incognita they will face-if they want to grow. Bookseller Inventory # AA59780123695123

More Information About This Seller | Ask Bookseller a Question

Buy New
US$ 34.87
Convert Currency

Add to Basket

Shipping: FREE
From United Kingdom to U.S.A.
Destination, Rates & Speeds

9.

Joe Celko
Published by Morgan Kaufmann Publishers In 2006-09-12 (2006)
ISBN 10: 0123695120 ISBN 13: 9780123695123
New Paperback Quantity Available: 5
Seller
Chiron Media
(Wallingford, United Kingdom)
Rating
[?]

Book Description Morgan Kaufmann Publishers In 2006-09-12, 2006. Paperback. Book Condition: New. Bookseller Inventory # NU-ELS-00002758

More Information About This Seller | Ask Bookseller a Question

Buy New
US$ 34.07
Convert Currency

Add to Basket

Shipping: US$ 3.88
From United Kingdom to U.S.A.
Destination, Rates & Speeds

10.

Celko, Joe
Published by Morgan Kaufmann Pub (2006)
ISBN 10: 0123695120 ISBN 13: 9780123695123
New Paperback Quantity Available: 1
Seller
Revaluation Books
(Exeter, United Kingdom)
Rating
[?]

Book Description Morgan Kaufmann Pub, 2006. Paperback. Book Condition: Brand New. 1st edition. 181 pages. 9.00x7.25x0.50 inches. In Stock. Bookseller Inventory # __0123695120

More Information About This Seller | Ask Bookseller a Question

Buy New
US$ 43.36
Convert Currency

Add to Basket

Shipping: US$ 7.79
From United Kingdom to U.S.A.
Destination, Rates & Speeds

There are more copies of this book

View all search results for this book