Showing posts with label database design. Show all posts
Showing posts with label database design. Show all posts

Expert Oracle: Signature Edition (Expert One-On-One) Review

Expert Oracle: Signature Edition (Expert One-On-One)
Average Reviews:

(More customer reviews)
Are you looking to buy Expert Oracle: Signature Edition (Expert One-On-One)? Here is the right place to find the great deals. we can offer discounts of up to 90% on Expert Oracle: Signature Edition (Expert One-On-One). Check out the link below:

>> Click Here to See Compare Prices and Get the Best Offers

Expert Oracle: Signature Edition (Expert One-On-One) ReviewThis book belongs on every developer, team leader, or DBAs desk that works with Oracle. Kyte has written a masterpiece in advanced Oracle knowledge. He does three things very well in this book: tells you what is important in Oracle, why it is important, and what happens if you do things the wrong way.
Kyte starts out giving the foundations for Oracle databases, the architecture, locking schemes, and table and index considerations. He gives a good treatment of the types of tables and indexes that Oracle offers including the appropriate times to use them and the trade-offs to weigh.
Another key topic that he covers is redo and rollback. These features are handled in a unique way in Oracle, and a lack of understanding can lead to inefficient and incorrect databases and applications.
Armed with the foundations, Kyte then takes the reader through performance tuning and optimizing databases. The best advice in this section is that performance cannot be thrown in at the end. The design decisions for a database will determine how it performs and scales. As he says, "There is no fast=true setting in the init parameters."
Then the book tackles some more advanced features, such as autonomous transactions, dynamic sql, and C and Java extensions for stored procedures. Kyte again gives good advice for when these are appropriate over standard PL/SQL stored procedures.
The size of the book can be intimidating at first glance, but it is pleasant to read. Kyte uses a conversational style rather than a lecturing delivery. This book has a lot to offer, and you won't find yourself tired after reading it.Expert Oracle: Signature Edition (Expert One-On-One) Overview

Want to learn more information about Expert Oracle: Signature Edition (Expert One-On-One)?

>> Click Here to See All Customer Reviews & Ratings Now
Read More...

Access 2007 VBA Programmer's Reference (Programmer to Programmer) Review

Access 2007 VBA Programmer's Reference (Programmer to Programmer)
Average Reviews:

(More customer reviews)
Are you looking to buy Access 2007 VBA Programmer's Reference (Programmer to Programmer)? Here is the right place to find the great deals. we can offer discounts of up to 90% on Access 2007 VBA Programmer's Reference (Programmer to Programmer). Check out the link below:

>> Click Here to See Compare Prices and Get the Best Offers

Access 2007 VBA Programmer's Reference (Programmer to Programmer) ReviewThis book has extensive coverage of an area vital to Access developers and power users, by a very knowledgeable team, ably led by Teresa Hennig. It includes something more than an overview explaining new features of Access 2007. That is important because: many features are new and changed in Access 2007, much of what we do with VBA is automating and enhancing features we use manually via the user interface, and the new Office 2007 user interface can be overwhelming without a helping "hand up". Then the book covers VBA from the basics to in-depth advanced levels. It is a worthy successor to the Access 2003 VBA Programmer's Reference and, in my opinion, "raises the bar" for VBA books. I'll be using it as a reference in presentations to my Access user groups, as well as a handy reference for my own work. I recommend it to Access power users, as well as aspiring and working Access developers.
Larry Linson
Microsoft Office Access MVP (see http://mvp.support.microsoft.com)
Co-Leader, Access Special Interest Group, North Texas PC User GroupAccess 2007 VBA Programmer's Reference (Programmer to Programmer) Overview

Want to learn more information about Access 2007 VBA Programmer's Reference (Programmer to Programmer)?

>> Click Here to See All Customer Reviews & Ratings Now
Read More...