Turing Programming Series Database (1 results)

paperback. Condition: New. Ship out in 2 business day, And Fast shipping, Free Tracking number will be provided after the shipment.Paperback. Pub Date :2012-11-01 Pages: 435 Publisher: People's Posts and Telecom Press the book edge kc11.21 Basic information title: Oracle PL \ SQL combat the database series Turing programming Books List Price: 89.00 yuan: John Beresniewicz published Social: People's Posts and Telecommunications Press Publication Date: November 1. 2012 ISBN: 9787115294852 words: Pages: 435 Edition: 1 Binding: Paperback: Weight: 880 g Editors' Choice Billington ed Oracle PL \ SQL combat by 15 well-known technical experts together to create each author of a chapter PLSQL topic describes what they do best. Covers the development of all aspects of the PLSQL. The author of this book is either the Oracle community stalwarts. is either famous OakTable members. and are often active in the first line of the Oracle technical training. PLSQL are to have a thorough understanding of a simple and unique way to explain complex issues. One hand. many PLSQL cattle insights panoramic view. What are you waiting for? PLSQL book highlights the latest. most practical features. what to do and what not to do. how to do it right. and how to do more. better three parts to fully explain the various topics related to the PLSQL. Each chapter with very apt example code. bearing in mind that the output tracking chart. supplemented explain in simple terms. it can not help but lovely dawned after. Each chapter covers the the PLSQL actual development of best practices. And reflect accumulated over the years of experience teaching. training. Its value is unusual. The book is suitable for readers with some PLSQL experience learning reference. Executive summary Billington Turing programming books. database series: Oracle PLSQL combat a total of 15 chapters written by 15 top experts in the industry featuring. A SQL statement misuse may lead to the increase in the running time of the job hundreds of times. Riyaj Shamsudeen cleverly answered when use PLSQL; Michael Rosenblum if only to the final run-time. before we know you want to run SQL statements in the end what is it how to write code; Dominic Delmolino parallel processing using PLSQL. and this will get the benefits and the additional burden. Oracle PLSQL combat. there are many more exciting content to wait for the readers to take a closer look. The Turing Programming Series Database: Oracle PLSQL combat Fit readers have some PLSQL based learning. Contents Chapter 1 to avoid misuse of the 1.1 Progressive Processing 1.2 nested Progressive Processing 1.3 the Find Query 1.4 DUAL excessive access to 1.4.1 Date arithmetic 1.4.2 Access Sequence 1.4.3 fills the main - over from the line 1.5 1.5.1 unnecessary multi-function call function call function call 1.5.2 costly 1.6 database link to call 1.7 excessive use trigger 1.8 overcommitted 1.9 excessive parsing 1.10 Summary Chapter 2 Dynamic SQL: dealing with the unknown 2.1 Dynamic SQL ways 2.1.1 local dynamic SQL 2.1.2 Dynamic Cursor 2.1.3 DBMS_SQL 2.2 Dynamic thinking sample 2.3 security issues 2.4 performance and resource utilization 2.4.1 Anti-mode 2.4.2 dynamic SQL to achieve 2.5 object dependencies 3.4 Parallel and Distributed Processing of 3.5 parallel hardware architecture 3.6 2.5.1 negative impact 2.5.2 positive impact on the rise of 3.3 data 2.6 Summary Chapter 3 PLSQL and parallel processing 3.1 Why do we need parallel processing 3.2 The impact of parallel processing is the law to determine the target 3.6 .1 acceleration 3.6.2 expanded proportionally 3.6.3 degree of parallelism 3.7 candidates for parallel processing workload 3.7.1 parallel and OLTP 3.7.2 parallel and non-OLTP workload 3.8 MapReduce programming model 3.9 3.10 can be used before using PLSQL process of parallel activities 3.11 the MapReduce parallel execution server 3.11.1 pipeline table function 3.11.2 guidance 3.11.3 parallel pipeline table function Summary 3.12 Summary Chapter 4 4.1 PLSQL warnings and co.