Oracle SQL Revealed, 1st ed. Executing Business Logic in the Database Engine
Auteur : Reprintsev Alex
- Gain competitive advantage from Oracle SQL
- Know when to step up to PL/SQL versus staying in SQL
- Become familiar with query transformations and join mechanics
- Apply the model clause and analytic functions to business intelligence queries
- Make use of features that are specific to Oracle Database, such as row pattern matching
- Understand the pros and cons of different SQL approaches to solving common query tasks
- Traverse hierarchies using CONNECT BY and recursive subquery factoring
Guides you in using analytic functions, the model clause, row pattern matching, and other powerful features in Oracle SQL
Helps you find competitive advantage through built-in features that are commonly overlooked
Assists you in choosing when to take a procedural approach in PL/SQL
Provides examples showing the power of Oracle SQL applied to real-life tasks
Presents in-depth analysis of joins, which is one of the most important SQL features
Date de parution : 04-2018
Ouvrage de 389 p.
15.5x23.5 cm
Disponible chez l'éditeur (délai d'approvisionnement : 15 jours).
Prix indicatif 31,64 €
Ajouter au panier