30,80 €*
Versandkostenfrei per Post / DHL
Lieferzeit 4-7 Werktage
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
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
Part I: Features and Theory.- .- 1. Joins.- 2. Query Transformations.- 3. Analytic Functions.- 4. Aggregate Functions.- 5. Hierarchical Queries: CONNECT BY.- 6. Recursive Subquery Factoring.- 7. Model.- 8. Row Pattern Matching: match_recognize.- 9. Logical Execution Order of Query Clauses.- 10. Turing Completeness.- .- Part II: PL/SQL and Patterns.- 11. When PL/SQL is Better.- 12. Solving SQL Quizzes.- Appendix A: Useful Oracle Links.
Erscheinungsjahr: | 2018 |
---|---|
Genre: | Informatik |
Rubrik: | Naturwissenschaften & Technik |
Medium: | Taschenbuch |
Seiten: | 404 |
Inhalt: |
x
389 S. 4 s/w Illustr. 389 p. 4 illus. |
ISBN-13: | 9781484233719 |
ISBN-10: | 1484233719 |
Sprache: | Englisch |
Herstellernummer: | 978-1-4842-3371-9 |
Ausstattung / Beilage: | Paperback |
Einband: | Kartoniert / Broschiert |
Autor: | Reprintsev, Alex |
Auflage: | 1st ed. |
Hersteller: |
Apress
Apress L.P. |
Maße: | 235 x 155 x 22 mm |
Von/Mit: | Alex Reprintsev |
Erscheinungsdatum: | 10.04.2018 |
Gewicht: | 0,61 kg |
Part I: Features and Theory.- .- 1. Joins.- 2. Query Transformations.- 3. Analytic Functions.- 4. Aggregate Functions.- 5. Hierarchical Queries: CONNECT BY.- 6. Recursive Subquery Factoring.- 7. Model.- 8. Row Pattern Matching: match_recognize.- 9. Logical Execution Order of Query Clauses.- 10. Turing Completeness.- .- Part II: PL/SQL and Patterns.- 11. When PL/SQL is Better.- 12. Solving SQL Quizzes.- Appendix A: Useful Oracle Links.
Erscheinungsjahr: | 2018 |
---|---|
Genre: | Informatik |
Rubrik: | Naturwissenschaften & Technik |
Medium: | Taschenbuch |
Seiten: | 404 |
Inhalt: |
x
389 S. 4 s/w Illustr. 389 p. 4 illus. |
ISBN-13: | 9781484233719 |
ISBN-10: | 1484233719 |
Sprache: | Englisch |
Herstellernummer: | 978-1-4842-3371-9 |
Ausstattung / Beilage: | Paperback |
Einband: | Kartoniert / Broschiert |
Autor: | Reprintsev, Alex |
Auflage: | 1st ed. |
Hersteller: |
Apress
Apress L.P. |
Maße: | 235 x 155 x 22 mm |
Von/Mit: | Alex Reprintsev |
Erscheinungsdatum: | 10.04.2018 |
Gewicht: | 0,61 kg |