Pro Oracle SQL unlock the power of SQL in an Oracle database? One of the SQL implementation of the most powerful on the market today. To master it requires a three-pronged approach: study the features of language, learning support features that Oracle provides to help use the language effectively, and learn to think and work on the set. Karen Morton and his team help you master the strong aspects of the Oracle SQL database is not found in competing. Pro Oracle SQL also help you minimize the overhead parsing, reading the execution plan, test for the right result, and exert control over the execution of SQL in your database. Pro Oracle SQL helps you work at a level that truly professional in Oracle's SQL dialect. What you will learn? Master SQL advanced features are implemented only in Oracle Database Reading and interpreting the SQL execution plans quickly diagnose and fix the bad conduct SQL execution plan to Controlling through guidance, profiles, and baseline plan Optimize query in the packaged application without touching the code Knowing when not to waste time on the SQL that perform optimal Who this book is to Oracle SQL Pro is intended for developers and database administrators who submit the SQL to be executed by the Oracle database. Table of Contents Core SQL SQL Implementation of Access and SQL Merge Method Sets This About? S Questions About SQL Execution Plan Analytic Functions Advanced Grouping these Subquery Factoring Clause Model Semi-join and anti-outer join SELECT Index Transaction Processing Testing and Quality Assurance Plan for Stability and Control
- ISBN-10: 1430232285
- ISBN-13: 9781430232285
- Publisher: Apress
- Pages: 600
- Date: December 2010
- Series: Expert's Voice in Oracle
No comments:
Post a Comment