Download PDF Expert PL/SQL Practices: for Oracle Developers and DBAs, by Michael Rosenblum, Dominic Delmolino, Lewis Cunningham, Riyaj Shamsudeen, Conn
This publication Expert PL/SQL Practices: For Oracle Developers And DBAs, By Michael Rosenblum, Dominic Delmolino, Lewis Cunningham, Riyaj Shamsudeen, Conn offers you better of life that can produce the high quality of the life better. This Expert PL/SQL Practices: For Oracle Developers And DBAs, By Michael Rosenblum, Dominic Delmolino, Lewis Cunningham, Riyaj Shamsudeen, Conn is just what the people now need. You are below and you could be specific as well as sure to get this publication Expert PL/SQL Practices: For Oracle Developers And DBAs, By Michael Rosenblum, Dominic Delmolino, Lewis Cunningham, Riyaj Shamsudeen, Conn Never ever doubt to get it also this is simply a book. You could get this publication Expert PL/SQL Practices: For Oracle Developers And DBAs, By Michael Rosenblum, Dominic Delmolino, Lewis Cunningham, Riyaj Shamsudeen, Conn as one of your collections. But, not the compilation to display in your shelfs. This is a valuable publication to be reading collection.
Expert PL/SQL Practices: for Oracle Developers and DBAs, by Michael Rosenblum, Dominic Delmolino, Lewis Cunningham, Riyaj Shamsudeen, Conn
Download PDF Expert PL/SQL Practices: for Oracle Developers and DBAs, by Michael Rosenblum, Dominic Delmolino, Lewis Cunningham, Riyaj Shamsudeen, Conn
Expert PL/SQL Practices: For Oracle Developers And DBAs, By Michael Rosenblum, Dominic Delmolino, Lewis Cunningham, Riyaj Shamsudeen, Conn. Discovering how to have reading behavior is like discovering how to attempt for eating something that you actually do not desire. It will need more times to assist. Additionally, it will likewise bit force to serve the food to your mouth and ingest it. Well, as reviewing a book Expert PL/SQL Practices: For Oracle Developers And DBAs, By Michael Rosenblum, Dominic Delmolino, Lewis Cunningham, Riyaj Shamsudeen, Conn, occasionally, if you ought to check out something for your brand-new works, you will certainly feel so woozy of it. Even it is a book like Expert PL/SQL Practices: For Oracle Developers And DBAs, By Michael Rosenblum, Dominic Delmolino, Lewis Cunningham, Riyaj Shamsudeen, Conn; it will certainly make you feel so bad.
To get rid of the issue, we now supply you the technology to download the book Expert PL/SQL Practices: For Oracle Developers And DBAs, By Michael Rosenblum, Dominic Delmolino, Lewis Cunningham, Riyaj Shamsudeen, Conn not in a thick printed documents. Yeah, checking out Expert PL/SQL Practices: For Oracle Developers And DBAs, By Michael Rosenblum, Dominic Delmolino, Lewis Cunningham, Riyaj Shamsudeen, Conn by online or getting the soft-file simply to check out could be among the ways to do. You could not really feel that reading a book Expert PL/SQL Practices: For Oracle Developers And DBAs, By Michael Rosenblum, Dominic Delmolino, Lewis Cunningham, Riyaj Shamsudeen, Conn will certainly work for you. Yet, in some terms, May individuals successful are those who have reading habit, included this type of this Expert PL/SQL Practices: For Oracle Developers And DBAs, By Michael Rosenblum, Dominic Delmolino, Lewis Cunningham, Riyaj Shamsudeen, Conn
By soft data of guide Expert PL/SQL Practices: For Oracle Developers And DBAs, By Michael Rosenblum, Dominic Delmolino, Lewis Cunningham, Riyaj Shamsudeen, Conn to check out, you could not have to bring the thick prints anywhere you go. Whenever you have ready to check out Expert PL/SQL Practices: For Oracle Developers And DBAs, By Michael Rosenblum, Dominic Delmolino, Lewis Cunningham, Riyaj Shamsudeen, Conn, you can open your gizmo to read this book Expert PL/SQL Practices: For Oracle Developers And DBAs, By Michael Rosenblum, Dominic Delmolino, Lewis Cunningham, Riyaj Shamsudeen, Conn in soft data system. So simple and quick! Checking out the soft documents book Expert PL/SQL Practices: For Oracle Developers And DBAs, By Michael Rosenblum, Dominic Delmolino, Lewis Cunningham, Riyaj Shamsudeen, Conn will give you simple means to check out. It can also be quicker due to the fact that you could read your book Expert PL/SQL Practices: For Oracle Developers And DBAs, By Michael Rosenblum, Dominic Delmolino, Lewis Cunningham, Riyaj Shamsudeen, Conn everywhere you desire. This on the internet Expert PL/SQL Practices: For Oracle Developers And DBAs, By Michael Rosenblum, Dominic Delmolino, Lewis Cunningham, Riyaj Shamsudeen, Conn could be a referred book that you can enjoy the option of life.
Due to the fact that publication Expert PL/SQL Practices: For Oracle Developers And DBAs, By Michael Rosenblum, Dominic Delmolino, Lewis Cunningham, Riyaj Shamsudeen, Conn has fantastic perks to review, lots of people now expand to have reading habit. Supported by the established modern technology, nowadays, it is simple to download the publication Expert PL/SQL Practices: For Oracle Developers And DBAs, By Michael Rosenblum, Dominic Delmolino, Lewis Cunningham, Riyaj Shamsudeen, Conn Also guide is not existed yet out there, you to look for in this internet site. As exactly what you can find of this Expert PL/SQL Practices: For Oracle Developers And DBAs, By Michael Rosenblum, Dominic Delmolino, Lewis Cunningham, Riyaj Shamsudeen, Conn It will truly alleviate you to be the very first one reading this e-book Expert PL/SQL Practices: For Oracle Developers And DBAs, By Michael Rosenblum, Dominic Delmolino, Lewis Cunningham, Riyaj Shamsudeen, Conn as well as obtain the benefits.
Expert PL/SQL Practices is a book of collected wisdom on PL/SQL programming from some of the best and the brightest in the field. Each chapter is a deep-dive into a specific problem, technology, or feature set that you’ll face as a PL/SQL programmer. Each author has chosen their topic out of the strong belief that what they share can make a positive difference in the quality and scalability of code that you write.
The path to mastery begins with syntax and the mechanics of writing statements to make things happen. If you’ve reached that point with PL/SQL, then let the authors of Expert PL/SQL Practices show you how to combine syntax and mechanics with features and techniques to really make the language sing. You’ll learn to do more with less effort, to write code that scales and performs well, and to eliminate and avoid defects.
These authors are passionate about PL/SQL and the power it places at your disposal. They want you to succeed, to know all that PL/SQL can offer. Let Expert PL/SQL Practices open your eyes to the full power of Oracle’s world-class language for the database engine.
- Goes beyond the manual to cover good techniques and best practices
- Delivers knowledge usually gained only by hard experience
- Covers the functionality that distinguishes PL/SQL as a powerful and scalable programming language for deploying logic inside the database engine
- Sales Rank: #410436 in Books
- Brand: Brand: Apress
- Published on: 2011-07-25
- Released on: 2011-07-26
- Original language: English
- Number of items: 1
- Dimensions: 9.25" h x 1.16" w x 7.50" l, 1.93 pounds
- Binding: Paperback
- 512 pages
- Used Book in Good Condition
About the Author
Michael Rosenblum is a Software Architect/Development DBA at Dulcian, Inc. where he is responsible for system tuning and application architecture. Michael supports Dulcian developers by writing complex PL/SQL routines and researching new features. He is the co-author of PL/SQL for Dummies (Wiley Press, 2006) and author of a number of database-related articles (IOUG Select Journal, ODTUG Tech Journal). Michael is an Oracle ACE, a frequent presenter at various regional and national Oracle user group conferences (Oracle OpenWorld, ODTUG, IOUG Collaborate, RMOUG, NYOUG, etc), and winner of the ODTUG Kaleidoscope 2009 Best Speaker Award. In his native Ukraine, he received the scholarship of the President of Ukraine, a Master of Science degree in Information Systems, and a diploma with honors from the Kiev National University of Economics.
Most helpful customer reviews
8 of 8 people found the following review helpful.
Learning PL/SQL from Experts
By Yan Li
I was a little bit puzzled when I got this book: who is the author? There are 15 of them! After reading it, I now believe it is a very good idea to combine knowledge from multiple experts into a single book, especially for a technical book. I would like to see more of these kinds of books coming.
The writers of this book are all very active in the Oracle community, most are authors, Oracle ACE, members of the OakTable network, etc. I actually met a few of them at seminars and user group activities. One of them, Arup Nanda, was once my RAC class instructor, and I've always been impressed by his ability to explain complicated issues in a simple and interesting way. In this book, he discussed dependencies and invalidations with the same clear logic.
The book has 15 chapters, with each author contributing one. Every chapter has a brief summary. Almost all of them go deeply into the topic using very good sample codes, traces, and tkprof output to prove their points.
You may read it as a book focusing on the newest and most powerful PL/SQL features, or you can treat it as 15 top level technical articles - each concentrates on a specific PL/SQL field and digs deeply into it. You'll learn the best practices from their expertise; real experiences and lessons. You can also gain lots of TTTs: Tips, Tricks and Traps to avoid. Many new data dictionary views mentioned by the authors are also very useful.
Based on the needs of my current work, I went through some chapters in close detail, and browsed others for future reference. The book touches the most recent Oracle version, including many new features of 11gR2.
This book is not for beginners. You will need some PL/SQL background to start with. I've been working with PL/SQL since version 6, but in the past few years, I've used more SQL than PL/SQL. By reading this book, I've realized how much more powerful PL/SQL is now than in the past. As new features come, we will have to keep learning. Often difficult tasks can become much easier if you learn the new ways rather than stick with what's familiar.
The order of the chapters does not matter. You can pick up any topic and start reading. Some similar issues are addressed by multiple authors, with each expert offering a different perspective on the problem.
I'd group the chapters into 3 main topics:
PART 1: What To Do And What Not To Do (Chapters 1, 2, 9,10, 12)
These chapters discuss when and when not to use PL/SQL from functional and performance points of view. They also discuss the differences between SQL and PL/SQL engines, the dynamic PL/SQL programming and its pros and cons, the different types of cursors and their usage, etc. Data modeling is not only important at the design stage but is also an evolutionary process.
PART 2: How To Do It Right (Chapters 5,7,8.11,14)
These chapters discuss coding standards and conventions, unit testing, best practices, etc. These are critical factors for successful application development, especially when you have a large group of developers working on a very complex application. Like Chapter 7 says, good developers need to `know your code' and to make your code simple, well organized, well documented, effective and efficient.
PART 3: How to Do More and Better (chapters 3, 4, 6, 13,15)
These chapters discuss more specific topics, including parallel processing, conditional compilations, bulk operations, methods to identify and measure performance issues as well as methods to shorten dependency chains and reducing cascading invalidations.
Chapter 6 is one of my favorate topics. Bulk operation is a very useful but underused feature. This chapter demonstrates the huge performance benefit you can get using bulk processing. The author also provides methods and solutions to find and handle the pitfalls of using bulk processing. The examples are interesting and the results are persuasive.
My coworker saw this book and agreed it is very good. I strongly recommend it to Oracle developers and DBAs.
I received a hard copy of this book. To me the line spacing is rather small for text, but the sample codes look fine.
5 of 5 people found the following review helpful.
Practical advice for PL/SQL coding
By Doug Duncan
This is a book written by 15 of the top PL/SQL experts and each of them gets to take you deep into their chosen subject matter. Books like this are great in the fact that you get in-depth coverage of the material being presented by someone who is passionate about the subject.
The authors show you what you can do to help make your code better for not only your benefit, but for the benefit of those that will come later and have to maintain your code.
Here is a brief description of some of my favorite chapters:
Chapter 1 shows why using PL/SQL might not be the best choice in a given situation. If you can get the job done strictly with SQL, then PL/SQL just adds unnecessary complexity and resource use. If you're coming from a programming background and haven't done much database work, this chapter would be a great reference for you.
Chapter 2 covers dynamic SQL and the pros and cons of working with it. In my experience this technique is underused, and too many people try to make a single general purpose (static) query that is hard to tune and work with. When done right, dynamic SQL can offer significant performance benefits without introducing complexity or security issues.
Chapter 7 talks about knowing your code. This is not only the code you write, but the code you must maintain. When your manager comes and asks you to make a change to some code, you need to know how that data is being used, what calls that code, and how the change will affect anything using it downstream. By putting the practices mentioned here into use, you will make it easier on yourself when making those changes and will have the confidence to know where and how to test your changes to verify nothing broke with the changes made.
Chapter 14 talks about why using standards are important. Many might just gloss over this chapter, but I feel that it's one of the most important things to learn. Whether you're working in a really small group of people or working on a team of 50+ developers, having standards is critical. I've worked in shops where nobody would code to a standard, and that was made much worse when you get a call at 2AM and you had to troubleshoot someones code. I've also worked in shops where there was a documented standard and those late night calls with critical issues were handled quickly because of it. While the company's given standard might not be your preferred coding style, adhering to it will make your life much easier when you have to make changes to someone else's code that followed that same standard.
Each of the chapters made me think about my coding style and how I write and test code. There are a lot of ideas to be gleaned from this book. While a couple of the authors will readily admit that their standards might not be right or make sense to be implemented in your shop, they all agree that using some type of standards is critical to saving time in both writing and maintaining code. Interestingly, there is some advice that I will take and use in other programming languages as it's that universal in scope.
This is definitely a book that's worth reading if you work with PL/SQL as a developer or DBA, and is one that I will recommend to my coworkers.
4 of 4 people found the following review helpful.
MUST READ - DBAs & Developers
By S. PANDIT
This is a MUST READ book for all DBAs & Developers. This is like having 30min 1-on-1 session with 15 subject matter experts.
As a DBA I always face challenges when explaining to developers the DOs & DONTs in SQL & PL/SQL.
The reasons being -
1. PL/SQL & SQL (oracle) has evolved a lot in last few years sometimes we don't keep track of new features.
2. Most of the developers practice either Java & or C++,C# religion, hence they look at PL/SQL with prejudiced view.
Even DBAs also get away with their jobs using their ancient knowledge about PL/SQL from 7.3 era.
Some of us do try to keep our knowledge up-to-date with white papers/articles, and try to make use of it but not effectively.
This book explains developers how/when to use SQL vs PL/SQL effectively. It explains the coding styles/standards & their use. It not only explains DOs, but it explains DONTs as well.
DBAs - One of the biggest challenge we normally have to deal with is code review...... making sure that it is not violating standards, compliance guideline and that we get it right when it is ready for implementation.... This book has tips to develop automated scripts/queries... just by running these we will be able to catch most of the violations.
Developers - Even though most of them have knowledge about the PL/SQL objects & standard SQLs, but one tend to loose the touch as
- They get pressured by deadlines
- Busy gaining business knowledge
- Keeping up with new features of their native programming languages.
This book will provide you in-depth knowledge on using SQL and or PL/SQL "effectively".....Please note this book is not for beginners as it assumes you know the syntax & feature.
Expert PL/SQL Practices: for Oracle Developers and DBAs, by Michael Rosenblum, Dominic Delmolino, Lewis Cunningham, Riyaj Shamsudeen, Conn PDF
Expert PL/SQL Practices: for Oracle Developers and DBAs, by Michael Rosenblum, Dominic Delmolino, Lewis Cunningham, Riyaj Shamsudeen, Conn EPub
Expert PL/SQL Practices: for Oracle Developers and DBAs, by Michael Rosenblum, Dominic Delmolino, Lewis Cunningham, Riyaj Shamsudeen, Conn Doc
Expert PL/SQL Practices: for Oracle Developers and DBAs, by Michael Rosenblum, Dominic Delmolino, Lewis Cunningham, Riyaj Shamsudeen, Conn iBooks
Expert PL/SQL Practices: for Oracle Developers and DBAs, by Michael Rosenblum, Dominic Delmolino, Lewis Cunningham, Riyaj Shamsudeen, Conn rtf
Expert PL/SQL Practices: for Oracle Developers and DBAs, by Michael Rosenblum, Dominic Delmolino, Lewis Cunningham, Riyaj Shamsudeen, Conn Mobipocket
Expert PL/SQL Practices: for Oracle Developers and DBAs, by Michael Rosenblum, Dominic Delmolino, Lewis Cunningham, Riyaj Shamsudeen, Conn Kindle
0 komentar:
Posting Komentar