Average customer rating:
- It is real cook book
- MS SQL Server must be 2005
- Mind-expanding
- Too long; get the Sams 10 minute series
- Everything you need
|
SQL Cookbook (Cookbooks (O'Reilly))
Anthony Molinaro
Manufacturer: O'Reilly Media, Inc.
ProductGroup: Book
Binding: Paperback
 General
| SQL
| Databases
| Computers & Internet
| Subjects
| Books
Database Management Systems
| Databases
| Computers & Internet
| Subjects
| Books
MySQL & mSQL
| Specific Databases
| Databases
| Computers & Internet
| Subjects
| Books
General
| Databases
| Computers & Internet
| Subjects
| Books
General
| Languages & Tools
| Programming
| Computers & Internet
| Subjects
| Books
General
| Software
| Computers & Internet
| Subjects
| Books
General
| Programming
| O'Reilly
| By Publisher
| Books
Oracle & Database Programming
| Programming
| O'Reilly
| By Publisher
| Books
Similar Items:
-
Learning SQL (Learning)
-
SQL Tuning
-
The Art of SQL (Art of)
-
SQL Pocket Guide (Pocket References)
-
Sams Teach Yourself SQL in 10 Minutes, Third Edition
ASIN: 0596009763 |
Book Description
You know the rudiments of the SQL query language, yet you feel you aren't taking full advantage of SQL's expressive power. You'd like to learn how to do more work with SQL inside the database before pushing data across the network to your applications. You'd like to take your SQL skills to the next level.
Let's face it, SQL is a deceptively simple language to learn, and many database developers never go far beyond the simple statement: SELECT
FROM
WHERE
. But there is so much more you can do with the language. In the SQL Cookbook, experienced SQL developer Anthony Molinaro shares his favorite SQL techniques and features. You'll learn about:
- Window functions, arguably the most significant enhancement to SQL in the past decade. If you're not using these, you're missing out
- Powerful, database-specific features such as SQL Server's PIVOT and UNPIVOT operators, Oracle's MODEL clause, and PostgreSQL's very useful GENERATE_SERIES function
- Pivoting rows into columns, reverse-pivoting columns into rows, using pivoting to facilitate inter-row calculations, and double-pivoting a result set
- Bucketization, and why you should never use that term in Brooklyn.
- How to create histograms, summarize data into buckets, perform aggregations over a moving range of values, generate running-totals and subtotals, and other advanced, data warehousing techniques
- The technique of walking a string, which allows you to use SQL to parse through the characters, words, or delimited elements of a string
Written in O'Reilly's popular Problem/Solution/Discussion style, the SQL Cookbook is sure to please. Anthony's credo is: "When it comes down to it, we all go to work, we all have bills to pay, and we all want to go home at a reasonable time and enjoy what's still available of our days." The SQL Cookbook moves quickly from problem to solution, saving you time each step of the way.
Customer Reviews:
It is real cook book.......2007-08-03
I am completely satisfied with this book.
Instead of inventing all the time "bicycle" I can use this book in my everyday work and concentrate on more important things in my projects.
MS SQL Server must be 2005.......2007-06-26
This is a great product but some of the advanced features weren't available in SQL Server 2000. I really liked the windowing and hierarchical queries in this book but those features are not available in 2000. For the most part 2000 isn't used that often anymore but if you are one of the unfortunate to have to use it there will be some compatibility problems with the examples in this book.
Mind-expanding.......2007-05-09
It doesn't take long to learn the basics of SQL. Once you start to do multi-table joins and you get to sub-selects and outer joins you can almost convince yourself you are an expert. Trust me. You aren't. I've read at least ten books on using SQL. This is the first one to blow my horizons away and open a completely new landscape.
The "recipies" are well explained and almost entirely practical and useful. This book showed me dozens of things I did not ever think of using SQL for, even though I have the BNF for SQL pretty much in my head after more than 18 years of being a practicing programmer.
Before this book I used to recommend "generic" SQL books to students and newbies because such books apply to virtually all SQL databases and it can be harmful for one to use a specific "dialect" (such as Oracle or SQL Server) that won't port to other SQL databases. I would urge people to learn "generic" SQL. You can always add the features of you specific dialect, but it is hard to give up features you assume will be in all dialects.
This book neatly avoids that problem by providing dialect-specific sections when you can or must code differently for a particular database. Even better, they explain the differences and the pros and cons of those differences. So this book can even be an aid to selecting the "right" database for your application.
I happen to be a fan of Open Source and Free Software and I'm pleased to say that this book covers both MySQL and PostgreSQL. Naturally it provides the "big three" of Oracle, Microsoft SQL Server, and IBM's DB2.
This book really opened my eyes to possibilities in SQL that I really didn't know existed in spite of the fact that I have been using the language (apparently without mastering it) for almost two decades.
I still recommend using a "generic SQL" book to learn the basics, but this should literally be ordered at the same time. It is the best of the "Cookbook" series that I have seen. (And I have used the Java Cookbook, Perl Cookbook, and Python Cookbook).
Too long; get the Sams 10 minute series.......2007-04-13
Too long at 600 pages. Sure you'll understand SQL if you go through all 600 pages and understand them well. Heck that's true for any subject, including the Qu'ran. But who'se got the time? Get the Sams Teach Yourself SQL in 10 Minutes, Third Edition - Ben Forta; and in about a day you'll be half way towards mastery. But if you don't value your time, perhaps you're still a student rather than a professional, then by all means read this book.
Everything you need.......2007-01-09
The Cookbook series has always been a reference for users that had at least some knowledge of the subject.
But even if you are just starting out, you can get started right away with writing commands. And since this book covers the major SQL formats, you won't be left out. I bought this book because an application uses Oracle and I was able to do what I needed to do. The great thing about the cookbook series is that you don't have to go through alot of text to get what you want. You find your problem and apply the solution.
Great book!!!
Book Description
Design and deploy integrated enterprise-class business solutions
Enhance productivity, profitability, and efficiency using IBM DB2 9 and the detailed information in this comprehensive resource. Written by experienced IBM data server professionals, IBM DB2 9 New Features covers the technical details of the major new aspects of DB2 9 alongside real-world business uses, syntax examples, and insider tips. Learn how to manipulate and manage XML data using pureXML, automate maintenance tasks, and seamlessly integrate Java, PHP, and Perl scripts. Plus, you'll get vital coverage of the brand-new DB2 Developer Workbench, enhanced .NET developer support, Ruby on Rails, and database security.
-
Learn about all the auto-configuration features that make getting DB2 up and running faster than ever before
-
Define, share, and validate data using XML and the unique pureXML DB2 Hybrid Storage Engine
-
Improve runtime performance and optimize storage with the new DB2 Compression Technology
-
Automatically handle DB2 memory allocation using the Self Tuning Memory Manager
-
Use Automatic Storage, Autonomic Computing, and a host of other autonomic features that make managing DB2 a snap
-
Create dynamic data server blueprints with Rational Data Architect version 6.1
-
Incorporate Java applications using the IBM WebSphere Application Server and DB2 data server
-
Develop open-source scripts using PHP, Perl, Toad, and Ruby on Rails
-
Utilize the DB2 Developer Workbench or exploit the enhanced .NET developer support
- Deploy the latest DB2 security and high availability features
Customer Reviews:
Very Good Book.......2007-10-17
I prepared for exam 700 using only this guide and I was able to pass it with a score of 92%.. I love this book and looking forward for a similar book for DB2 v9 exam from Roger Sanders.
DB2 8.1 Fundamentals Certification Guide.......2007-09-27
I found this book very helpful in preparing for certification. After reading this book and doing the review questions at the end of each chapter, I was able to pass the review with a score of 92%.
DB2 Version 8 Certification Guide.......2007-06-27
The books if very helpful and insightful. I'd recommend it to intermediate and advanced users.
Perfect for DB2-700 Exam!.......2007-01-09
This is the only reference I used for the DB2 700 Exam and I passed the exam with 94%, you probably won't need anything else. However if you wish to score really high I would recommend some Internet Searches for the first chapter - Planning. The exam is all too simple and some questions were directly taken from this book.
Great book.......2006-11-12
Even for people that thinks that knows everything about DB2, this book is important because it delves into the main subjects that will appear in the exam, but also is useful to give you an overview about what you know, and what you have the opportunity to enhance your skills using other sources.
Average customer rating:
- THE BEST Book on UDB to get INDEPTH!!
- Superb book for learning SQL and database basics
- Best book available for DBAs working with DPF
- Absolutely the best DB2 book!
- Excellent book
|
Advanced DBA Certification Guide and Reference for DB2 UDB v8 for Linux, Unix and Windows
Dwaine R. Snow ,
Thomas Xuan Phan , and
Dwaine Snow
Manufacturer: IBM Press
ProductGroup: Book
Binding: Paperback
General
| Unix
| Operating Systems
| Computers & Internet
| Subjects
| Books
General
| Linux
| Operating Systems
| Computers & Internet
| Subjects
| Books
Relational Databases
| Databases
| Computers & Internet
| Subjects
| Books
IBM DB2
| Specific Databases
| Databases
| Computers & Internet
| Subjects
| Books
dBASE
| Specific Databases
| Databases
| Computers & Internet
| Subjects
| Books
Database Management Systems
| Databases
| Computers & Internet
| Subjects
| Books
General
| Databases
| Computers & Internet
| Subjects
| Books
Information Systems
| Software Engineering
| Computer Science
| Computers & Internet
| Subjects
| Books
Linux
| Certification Central
| Computers & Internet
| Subjects
| Books
General
| Certification Central
| Computers & Internet
| Subjects
| Books
DB2
| Exams
| Certification Central
| Computers & Internet
| Subjects
| Books
General
| Networks, Protocols & APIs
| Networking
| Computers & Internet
| Subjects
| Books
General
| Computers & Internet
| Subjects
| Books
General
| Software
| Computers & Internet
| Subjects
| Books
All Titles
| Qualifying Textbooks - Fall 2007
| Stores
| Books
Computers & Internet
| Qualifying Textbooks - Fall 2007
| Stores
| Books
Similar Items:
-
DB2 Universal Database V8 for Linux, UNIX, and Windows Database Administration Certification Guide (5th Edition)
-
Understanding DB2(R): Learning Visually with Examples
-
DB2 UDB V8.1 Certification Exams 701 and 706 Study Guide
-
DB2 UDB V8.1 Certification Exam 700 Study Guide
-
DB2(R) SQL PL: Essential Guide for DB2(R) UDB on Linux(TM), UNIX(R), Windows(TM), i5/OS(TM), and z/OS(R) (2nd Edition)
ASIN: 0130463884 |
Customer Reviews:
THE BEST Book on UDB to get INDEPTH!!.......2007-08-17
THE BEST Book on UDB to get INDEPTH!! If you want to know indepth, read this -most of the content may be in ibm db2 udb information center also.
Superb book for learning SQL and database basics.......2006-10-24
I was trying to learn SQL and database basic. I have been looking to several different books and I was lacking a book that would systematicaly explain data base and SQL basics. This is the book. Chapters regarding Data Retrival are just right, not to short and not to long. Just right.
I recomend the book to somebody that would like to learn SQL and DB2 basics.
Best book available for DBAs working with DPF .......2006-06-27
I used this book to write Exam 704 (Advance DB2 UDB DBA certification). I cleared the exam with flying colors.
I consider this book as DB2 UDB Bible. This is one of the some good books on DB2 UDB.
Also recommend to DBAs who are not preparing for certification since it covers almost all the aspects of DB2 database.
Regards
Prakash Gautam
Absolutely the best DB2 book!.......2004-05-18
I just found this book, and after reading it wish I had found this years ago. This is the most comprehensive book on DB2 that I have ever seen. This book has already saved me a lot of time. The performance chapter is great and helped me improve the performance of my DB2 server by over 30% in less than a week.
Excellent book.......2004-05-12
This is the book I was waiting for long on DB2UDB. This not only covers topics for certifications but also good (very good) reference material for all UDB DBAs on LUW platform.
Customer Reviews:
The best DB2 book out there.......2007-02-07
If you have to own one DB2 book (Linux,Unix,Windows) , buy this one. Usually I end up buying 2 books. The first being a book being very visual and easy to read but lacking any real detail and practical knowledge. The second book is usually a scary developers guide which is extremely thorough but requires a PHD to read it, or you end up using it as a reference.
This book hits dead on!! Incredibly easy to read with examples and visuals that make understanding difficult concepts easy, but its encompasses every important concept in DB2 with plenty of detail. I love this book and recommend it to anyone looking for the DB2 book to buy. Of course there are times you will need to access DB2 Info Center when you need very specific detail, but this book will provide you on the right track and explain how you got there perfectly. Hats off to the authors of this one.
Excellent Book.......2007-01-11
I would highly recommend this book as both a beginning level resources as well as a shelf reference for the more experienced DBA. I love the format and layout. This makes it easy to find what you need.
Not for Mainframe DB2.......2006-06-23
I should have done my homework before i bought this book. If you are using db2 on the mainframe im not sure you will find this book too helpful as it caters to windows and linux users. Im very new to db2 and did not find this book that helpful as far as laying down the basics.
DB2 Simplified.......2006-06-16
I found this book extremely comprehensive. The use of screen captures in partnership with textual descriptions are so much better. Bravo to those who took the time to create a fantastic learning and reference tool!
The book lives up to its name.......2006-04-18
This book has something for every level of DB2 expertise from beginner to intermediate to expert. The books name implied there would be lots of visual images and the books was loaded with charts, pictures and screenshots. These make learning about DB2 much easier and more fun, than reading plain text.
Every chapter in the book had some nuggets of information that seemed to be hidden in other resources. I did have some favorite chapters, though. I have worked with partitioned databases for some time and it is one of the more complicated features in DB2. I found their section on database partitions to be exceptionally clear. I found the chapter on connectivity scenarios to be especially useful. They covered just about every scenario I could think of and through pictures, made it seem simple. Security in DBMS's is quite complex and DB2 is no exception. The authors did a great job of using pictures, to make it much easier to understand. Their big picture of DB2 security certainly expresses at least 1,000 words worth of knowledge.
Even if you are not studying for a certification test, the questions at the end of each chapter are great for helping cement what you learned in the chapter.
I'm hoping that the authors are busily preparing a new edition of the book to teach about the next version of DB2, code-named Viper.
Average customer rating:
- iF YOU WANT TO GO DEEPER IN SPL
- DB2(R) SQL PL: Essential Guide for DB2(R) UDB on Linux(TM), UNIX(R), Windows(TM), i5/OS(TM), and z/OS(R) (2nd Edition
- A very good book on DB2 SQL PL
- embed yourself in db2
- Excellent book for developers/DBAs new to DB2
|
DB2(R) SQL PL: Essential Guide for DB2(R) UDB on Linux(TM), UNIX(R), Windows(TM), i5/OS(TM), and z/OS(R) (2nd Edition)
Zamil Janmohamed ,
Clara Liu ,
Drew Bradstock ,
Raul F. Chong ,
Michael Gao ,
Fraser McArthur , and
Paul Yip
Manufacturer: IBM Press
ProductGroup: Book
Binding: Hardcover
General
| Unix
| Operating Systems
| Computers & Internet
| Subjects
| Books
General
| Linux
| Operating Systems
| Computers & Internet
| Subjects
| Books
Programming
| Linux
| Operating Systems
| Computers & Internet
| Subjects
| Books
Relational Databases
| Databases
| Computers & Internet
| Subjects
| Books
IBM DB2
| Specific Databases
| Databases
| Computers & Internet
| Subjects
| Books
General
| SQL
| Databases
| Computers & Internet
| Subjects
| Books
Database Management Systems
| Databases
| Computers & Internet
| Subjects
| Books
General
| Databases
| Computers & Internet
| Subjects
| Books
Databases
| Software
| Computers & Internet
| Subjects
| Books
General
| Software
| Computers & Internet
| Subjects
| Books
All Titles
| Qualifying Textbooks - Fall 2007
| Stores
| Books
Computers & Internet
| Qualifying Textbooks - Fall 2007
| Stores
| Books
Similar Items:
-
Understanding DB2(R): Learning Visually with Examples
-
Advanced DBA Certification Guide and Reference for DB2 UDB v8 for Linux, Unix and Windows
-
IBM DB2 9 New Features
-
DB2 Developer's Guide (5th Edition)
-
DB2 9 Fundamentals Certification Study Guide
ASIN: 0131477005 |
Customer Reviews:
iF YOU WANT TO GO DEEPER IN SPL.......2006-11-06
It is really a very good book from IBM about DB2-SPL. In our company we bougth a lot of DB2 book, but this is the very best.
from basics to tricks
DB2(R) SQL PL: Essential Guide for DB2(R) UDB on Linux(TM), UNIX(R), Windows(TM), i5/OS(TM), and z/OS(R) (2nd Edition.......2006-09-16
Has been extremely helpful. Good information
A very good book on DB2 SQL PL.......2006-01-25
I didn't know anything about writing DB2 stored procedures until I bought this book. After reading it I have written several procedures to aid in data migration. It is well laid out and has all the necessary information. The best part is that you don't feel like you are reading a technical book.
embed yourself in db2.......2004-12-27
The book describes IBM's Procedural Language, which runs on their db2 servers. It is not a general purpose language, like C or Java. Rather, it is tied directly to db2 and IBM's implementation of SQL. But within this context, the book explains the expressive power of PL. It shows at length how you can write stored procedures, triggers and functions in PL. The level of detail and the cited examples should reassure you of PL's capability.
But why even write business logic code at the database layer? There have been other books on n-tier application design, which call for the locating of business logic in a middle tier and not at the database. The authors' rejoinder is that while that makes for an elegant design, practical experience shows that often, crucial logic needs to be at the database. This reduces networks traffic and can heavily improve perforance. Hence the need for PL, or something like it.
Be wary of the book's claim that PL lets you write "portable application logic". It is portable only between instances of db2 running under linux, unix, Microsoft Windows or IBM's operating systems. When you write embedded logic in PL, you are also embedding yourself or your company into db2. Which may indeed be fine by you. But just so you know.
Excellent book for developers/DBAs new to DB2.......2004-10-23
If you are a developer or DBA who is new to DB2, I would highly recommend this book to you. Both administration and development topics are covered, helpful best practices and tips are included, and illustrative examples are used.
The fundamental DB2 concepts and the different DB2 tools such as the Control Center are introduced in a very straightforward and easy-to-understand manner. This allows DB2-newbies to get fully up to speed on DB2 terminology and functionality, while serving as a gentle refresher for those who might have prior DB2 experience. The book achieves a good balance of topic selection and level of detail. More advance topics that are covered are explained in a manner that most novices would comprehend and in enough detail to be useful.
The prime focus of the book is on leveraging the ease-of-use and autonomic capabilities of DB2. If you are a developer not wanting to memorize database and/or SQL command syntax, you will particularly appreciate this book. The book shows how most common administrative tasks can be very easily performed using the GUI tools and Wizards provided with DB2. Ease of application development is demonstrated in both Java and Microsoft .net environments. An easy and intuitive introduction to DB2 SQLPL is also provided.
Overall, I think that if you are new to DB2, or need to learn the essential concepts/features needed to develop and/or administer DB2 quickly, you will be very pleased with this book. It is a perfect starting point for introducing the most important concepts, features, and tools. As you gain more experience and familiarity with the product, a more advanced book can be obtained.
Book Description
SQL is the language of databases. It's used to create and maintain database objects, place data into those objects, query the data, modify the data, and, finally, delete data that is no longer needed. Databases lie at the heart of many, if not most business applications. Chances are very good that if you're involved with software development, you're using SQL to some degree. And if you're using SQL, you should own a good reference or two.
Now available in an updated second edition, our very popular SQL Pocket Guide is a major help to programmers, database administrators, and everyone who uses SQL in their day-to-day work. The SQL Pocket Guide is a concise reference to frequently used SQL statements and commonly used SQL functions. Not just an endless collection of syntax diagrams, this portable guide addresses the language's complexity head on and leads by example. The information in this edition has been updated to reflect the latest versions of the most commonly used SQL variants including:
- Oracle Database 10g, Release 2 (including the free Oracle Database 10g Express Edition (XE))
- Microsoft SQL Server 2005
- MySQL 5
- IBM DB2 8.2
- PostreSQL 8.1 database
Customer Reviews:
Very nice for remember details.......2007-05-15
This book is the best form of remember SQLScript by engine details and lexical diference; I'm using Oracle v7, v8, v10 and SQLServer in my job; and mySQL and Oracle v10 in my own SOHO applications.
Excellent Pocket Reference.......2006-08-01
Out of my several books on SQL, this is the one that I use most often. I find it most useful as it is very easy to use and has a good coverage on the subject. The keywords index is invaluable for finding the right information in the book.
The pocket guide covers syntax differences between SQL, MySQL and Oracle and provide comprehensive explanations to various properties.
Highly recommended for anyone working with SQL and/or MySQL.
This one deserves a spot in your bag.......2006-05-08
The SQL Pocket Guide: 2nd Edition "is an attempt to cram the most useful information about SQL into a pocket-size guide." That's the first sentence of the introduction and is the best description I can imagine for this helpful little book. The following platforms are included in this 2nd edition: Oracle Database 10g Release 2 (including Oracle Express Edition,) IBM DB2 Universal Database Release 8.2, Microsoft SQL Server 2005, MySQL 5.0, and PostgreSQL 8.1.
I'm not a full-time DBA. I'm an application developer and I frequently interact with various flavors of relational databases. I confess, I don't have all the syntax memorized. That's why this little book is so helpful. The book has good coverage of DML, common SQL functions and other related topics (e.g. NULLs, CASE expressions, datatype conversions, etc.) And, each topic is covered for each of the platforms mentioned above. It makes for an interesting comparison. The table of contents is organized nicely to allow the reader to quickly locate content by subject and there is also a detailed index in the back.
The 2nd edition of this book was published in April 2006. When you read reviews of the SQL Pocket Guide, make sure you are reading a review of the current edition. The 2nd edition has been updated for more current database releases. And, CREATE TABLE coverage and window functions have been added. Many of the changes were in direct response to feedback from the first edition.
As mentioned in other reviews, this book is not going to teach you SQL. It wasn't intended to. However, if you find that you're frequently (or even occasionally) looking up SQL syntax and if you need to create SQL statements that work with one or more of the platforms covered in this book, I highly recommend that you give this little helper a place in your bag.
SQL Pocket Guide (Paperback).......2006-01-26
I have used this book often since I purchased it. It was worth the money that I paid for it. Very useful book because we can not keep every bit of SQL syntax on our heads. Especially for those of us that deal with different databases. I would recommend this book to my fellow Programmers/Developers. Thank you.
One flaw though.......2005-10-12
I must warn those who plan to get this little book. It doesn't tell you how to create tables but only how to use them. And a list of datatypes would have been nice. But it's ok.
Book Description
This book makes it easy for you to master the essentials of DB2 programming. Written from the programmer's point of view, it focuses right from the start on what you need to know to access and process DB2 data in your application programs using embedded SQL
You'll learn: the basics of how DB2 works so you can program more easily and logically...how to design and code DB2 programs...how to use inner joins, outer joins, and unions to combine data from two or more tables...how to use column functions to extract summary data from a table...how to work with variable-length data and nulls...how to use error handling techniques and ROLLBACK to protect DB2 data...how to use locking and concurrency features so you don't tie up the whole system...how to develop DB2 programs interactively (using DB2I, a TSO facility) or in batch...how to create test data using SPUFI and QMF...and more!
Customer Reviews:
Very helpful reference guide........2007-01-10
I use this book at work all the time for projects where we are adding DB2 to old COBOL programs. I have a little bit of SQL experience, so I generally use this book as a reference. It also helps me use a variety of DB2 features to make the queries simpler and do what I really want.
If you want to learn DB2/SQL this is a MUST HAVE.......2002-03-13
Buy this book!!! ... I wanted
to refresh my basic DB2/COBOL skills, so I ordered a copy of this book.
"DB2 for the COBOL Programmer" is written in a clear and concise fashion
which even a novice programmer can start using immediately. SQL theory and
application are presented in a way that can only be described as inspired.
Curtis Garvin and Steve Eckols have done an outstanding job taking the
reader from zero to competent professional in this book. I only wish that
more 'techie' books were written like this one (and it's companion, Part 2).
All You Need To Learn DB2.......2000-06-01
This is an excellent resource for all those baffled programmers who need to learn DB2 fast. Thos book provides clear-cut examples, syntax, and the results of the various SQL commands that are most likely to be needed by any programmer. All the basics from simple SELECT statements are covered all the way up to ORDER BY clauses, joins and so on. A special chapter on using SPUFI was also a big help. The emphasis here is on the COBOL language and mainframe computers, but it is an excellent learning tool for anyone. The book teaches by example and can be finished easily within a week (The example programs are what make it look so big). A must-read for anyone interested in relationall databases.
Customer Reviews:
Reads like an installation guide........2007-07-18
This book is quite possibly the worst written technical book I have read in my 18 year career. It seems as if the driest and dullest portions of the DB2 manuals have been extracted and collected together and called a book; without any regard to editing or amending with graphics.
The material in the book may well cover the necessary topics for the certification test, but the stamina necessary to read it makes this choice clearly a poor one. You would be much better off reading Craig Mullins' latest DB2 Developer's Guide and portions of the DB2 Administration Guide to in preparation for the exams.
I give this book 2 stars only because the material covered seems to closely match what is on the test. Extracting the information from this book, however, is another matter.
not the one I expected.......2007-02-26
It doesnt give you the indepth details for the 702 certification... All topics are covered as an overview
Best book on the subject.......2005-09-06
Besides getting you ready for the certification examination this book is an excellent reference source and covers some material far better than other similar books on the market. If you only want to buy a few books on this subject, start with this one. You may find you don't need any others.
Excellent.......2005-01-02
This is an excellent book that gives an overall picture of what to expect for the z/OS 702 Examination. The certification portions have all been covered well. Except for a few typos in a few places, this book is an excellent material and is a handy book for a DBA. I certainly recommend it to anyone wishing to pursue DB2 702 certification.
Excellent Material:.......2004-12-23
This is an excellent book that gives an overall picture of what to expect for the z/OS 702 Examination. The certification portions have all been covered well.
Except for a few typos in a few places, this book is an excellent material and is a handy book for a DBA. I certainly recommend it to anyone wishing to pursue DBA certification.
-PK.Ganapathy
Average customer rating:
- DB2 for the COBOL Programmer, Part 2, 2nd Ed.
- Want to advance your DB2/SQL skills? A "MUST HAVE"!
- An excellent choice. You get MORE than your money's worth!
- DB2 for the COBOL Programmer
- Advanced Topics in DB2
|
DB2 for the COBOL Programmer, Part 2, 2nd Ed.
Curtis Garvin ,
Anne Prince , and
Steve Eckols
Manufacturer: Mike Murach & Associates
ProductGroup: Book
Binding: Paperback
Relational Databases
| Databases
| Computers & Internet
| Subjects
| Books
IBM DB2
| Specific Databases
| Databases
| Computers & Internet
| Subjects
| Books
Database Management Systems
| Databases
| Computers & Internet
| Subjects
| Books
General
| Databases
| Computers & Internet
| Subjects
| Books
Cobol
| Languages & Tools
| Programming
| Computers & Internet
| Subjects
| Books
Databases
| Software
| Computers & Internet
| Subjects
| Books
General
| Software
| Computers & Internet
| Subjects
| Books
General
| Programming
| Web Development
| Computers & Internet
| Subjects
| Books
All Titles
| Qualifying Textbooks - Fall 2007
| Stores
| Books
Computers & Internet
| Qualifying Textbooks - Fall 2007
| Stores
| Books
Similar Items:
-
DB2 for the COBOL Programmer, Part 1, 2nd Ed.
-
Murach's CICS for the COBOL Programmer
-
Vsam for the Cobol Programmer: Concepts, Cobol, Jcl, Idcams
-
Murach's Mainframe COBOL
-
Murach's OS/390 and z/OS JCL
ASIN: 1890774030 |
Book Description
This new edition of DB2,Part 2, covers the version 4.1 and 5 enhancements to DB2 so programmers can take advantage of all the new and improved features that help them the most. It presents the advanced skills needed to become a top senior programmer or programmer/analyst.
Specifics covered in the 2nd edition:
How to use stored procedures that move SQL code off of the client and onto the database server to reduce network overhead
How to use dynamic SQL so your programs can generate and execute SQL statements as they run
How data sharing works on the parallel sysplex and other System/390 configurations
How to work with DB2 data, where the data is managed by a DB2 subsystem on a system thats connected over a network
How to process DB2 data in CICS programs
Advanced locking concepts that show how locking and data sharing affect each other and what impact that has on program efficiency
The concepts and practices of DB2 database administration that let the programmer design databases, manage database objectives, and set up a quality assurance environment
Customer Reviews:
DB2 for the COBOL Programmer, Part 2, 2nd Ed........2007-03-15
-excelent part about DB2 working in sysples, locking mechanism
-excelent part about stored procedures
-good introduction to database administration
Want to advance your DB2/SQL skills? A "MUST HAVE"!.......2002-03-13
Buy this book!!! Some computer books are written by computer geeks who know
their technical stuff cold. They can't teach worth a darn, but they are
deep technical wizards who are highly versed in techno-babble. The worst
part of it usually is, they aren't even aware when they are babbling their
techno-nonsense!!! The people who wrote the Murach series are NOT (let me
repeat, the Murach folks are NOT) such people. It was the most amazing
experience to have read this book, and to have had the feeling that either
Curtis Garvin or Anne Prince were looking directly over my shoulder
anticipating the various questions that inevitably arose. This book is
incredibly well structured. It is written clearly, concisely, and with
relevant in-depth examples. The authors take pains to ensure that they
present their programming examples without (WITHOUT!!!) falling into the
trap of disjointed techno-babble so common to such books. Again, you get
more than your money's worth with this book. Buy it, and recommend it to
anyone else who wants to learn, refresh, or EXTEND their DB2/COBOL skills.
An excellent choice. You get MORE than your money's worth!.......2001-04-03
Buy this book!!! Some computer books are written by computer geeks who know their technical stuff cold. They can't teach worth a darn, but they are deep technical wizards highly versed in techno-babble. The people who wrote the Murach series are NOT (let me repeat, the Murach folks are NOT) such people. It was the most amazing experience to have read this book, and to have the feeling that either Curtis Garvin or Anne Prince were looking directly over one's shoulder anticipating the various questions that inevitably arose. This book is incredibly well structured. It is written clearly, concisely, and with relevant in-depth examples. The authors take pains to ensure that they present their programming examples without (WITHOUT!!!) falling into the trap of disjointed techno-babble so common to such books. Again, you get more than your money's worth with this book. Buy it, and recommend it to anyone else who wants to learn or refresh their DB2/COBOL skills.
DB2 for the COBOL Programmer.......2000-12-02
I started a new job and needed to learn DB2 in a hurry. I bought part 1 and part 2. I was coding in no time. But the best part is they make excellent reference books because they are laid out so well. These books are well worth the investment.
Advanced Topics in DB2.......2000-06-14
This readable volume covers DB2 data sharing, stored procedures, DB2/CICS interface, DB2 database objects, and the SQL EXPLAIN. Model programs and JCL can be downloaded from the web. I look forward to an instructor's guide (hint to Murach) as they have for other publications.
Books:
- Star Wars Complete Cross-Sections: The Spacecraft and Vehicles of the Entire Star Wars Saga
- Styles and Motifs Japanese Gardens
- The 50 Greatest Yankee Games
- The Accidental Salesperson: How to Take Control of Your Sales Career and Earn the Respect and Income You Deserve
- The All-New Tenchi Muyo!, Volume 10 (All New Tenchi Muyo)
- The Art Of Trompe L'oeil Murals
- The Artist's Handbook
- The Ballet Companion: A Dancer's Guide to the Technique, Traditions, and Joys of Ballet
- The Blessing of a Skinned Knee: Using Jewish Teachings to Raise Self-Reliant Children
- The Blood Books, Vol. 2 (Blood Lines / Blood Pact)
Books Index
Books Home
Recommended Books
- Phil Gordon's Little Green Book: Lessons and Teachings in No Limit Texas Hold'em
- Force Heretic I: Remnant
- The Rime of the Ancient Mariner
- Zora Neale Hurston : Novels and Stories : Jonah's Gourd Vine / Their Eyes Were Watching God / Moses,
- Associated Press Sports Writing Handbook
- Catastrophe: An Investigation into the Origins of Modern Civilization
- Confessions of a Tax Collector: One Man's Tour of Duty Inside the IRS
- The psychoanalysis of artistic vision and hearing: An introduction to a theory of unconscious percep
- Winter Weed Finder: A Guide to Dry Plants in Winter
- Judge Joe : In the Eye of the Storm
