Oracle SQL Revealed (eBook)
X, 389 Seiten
Apress (Verlag)
978-1-4842-3372-6 (ISBN)
- 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
?Alex Reprintsev has more than 10 years of experience in database development using various databases, including Oracle, Microsoft SQL Server, MySQL, DB2, and modern SQL engines for Big Data such as Hive and Impala. He has successfully delivered applications for various customers covering different workload types such as OLTP, OLAP, and mixed workloads. During his journey, Alex has faced a number of challenges related to implementing business logic and tuning SQL for performance. He believes details really do matter, and that it is important to know and exploit the full feature set of whatever database engine you choose to build your business around.
Write queries using little-known, but powerful, SQL features implemented in Oracle's database engine. You will be able to take advantage of Oracle's power in implementing business logic, thereby maximizing return from your company's investment in Oracle Database products.Important features and aspects of SQL covered in this book include the model clause, row pattern matching, analytic and aggregate functions, and recursive subquery factoring, just to name a few. The focus is on implementing business logic in pure SQL, with a comparison of different approaches that can be used to write SELECT statements to return results that drive good decision making and competitive action in the marketplace. This book covers features that are often not well known, and sometimes not implemented in competing products. Chapters on query transformation and logical execution order provide a grasp of the big picture in which the individual SQL features described in the other chapters are executed. Also included are a discussion on when to use the procedural capabilities from PL/SQL, and a series of examples showing different mixes of SQL features being applied in common types of queries that you are likely to encounter. What You Will LearnGain competitive advantage from Oracle SQLKnow when to step up to PL/SQL versus staying in SQLBecome familiar with query transformations and join mechanicsApply the model clause and analytic functions to business intelligence queriesMake use of features that are specific to Oracle Database, such as row pattern matchingUnderstand the pros and cons of different SQL approaches to solving common query tasksTraverse hierarchies using CONNECT BY and recursive subquery factoringWho This Book Is ForDatabase programmers with some Oracle Database experience. The book is also for SQL developers who are moving to the Oracle Database platform or want to learn unique features of its query engine. Both audiences will learn to apply the full power of Oracle's own SQL dialect to commonly encountered types of business questions and query challenges.
Alex Reprintsev has more than 10 years of experience in database development using various databases, including Oracle, Microsoft SQL Server, MySQL, DB2, and modern SQL engines for Big Data such as Hive and Impala. He has successfully delivered applications for various customers covering different workload types such as OLTP, OLAP, and mixed workloads. During his journey, Alex has faced a number of challenges related to implementing business logic and tuning SQL for performance. He believes details really do matter, and that it is important to know and exploit the full feature set of whatever database engine you choose to build your business around.
Part I: Features and Theory1. Joins2. Query Transformations3. Analytic Functions4. Aggregate Functions5. Hierarchical Queries: CONNECT BY6. Recursive Subquery Factoring7. Model8. Row Pattern Matching: match_recognize9. Logical Execution Order of Query Clauses10. Turing CompletenessPart II: PL/SQL and Patterns11. When PL/SQL is Better12. Solving SQL Quizzes13. Appendix A: Useful Oracle Links
| Erscheint lt. Verlag | 9.4.2018 |
|---|---|
| Zusatzinfo | X, 389 p. 4 illus. |
| Verlagsort | Berkeley |
| Sprache | englisch |
| Themenwelt | Informatik ► Datenbanken ► Oracle |
| Mathematik / Informatik ► Informatik ► Web / Internet | |
| Schlagworte | Analytic Functions • ANSI joins • CONNECT BY • Hierarchical Queries • MODEL clause • PL/SQL • Query Transformation • Row Pattern Matching • Window functions |
| ISBN-10 | 1-4842-3372-7 / 1484233727 |
| ISBN-13 | 978-1-4842-3372-6 / 9781484233726 |
| Haben Sie eine Frage zum Produkt? |
PDF (Wasserzeichen)Größe: 2,6 MB
DRM: Digitales Wasserzeichen
Dieses eBook enthält ein digitales Wasserzeichen und ist damit für Sie personalisiert. Bei einer missbräuchlichen Weitergabe des eBooks an Dritte ist eine Rückverfolgung an die Quelle möglich.
Dateiformat: PDF (Portable Document Format)
Mit einem festen Seitenlayout eignet sich die PDF besonders für Fachbücher mit Spalten, Tabellen und Abbildungen. Eine PDF kann auf fast allen Geräten angezeigt werden, ist aber für kleine Displays (Smartphone, eReader) nur eingeschränkt geeignet.
Systemvoraussetzungen:
PC/Mac: Mit einem PC oder Mac können Sie dieses eBook lesen. Sie benötigen dafür einen PDF-Viewer - z.B. den Adobe Reader oder Adobe Digital Editions.
eReader: Dieses eBook kann mit (fast) allen eBook-Readern gelesen werden. Mit dem amazon-Kindle ist es aber nicht kompatibel.
Smartphone/Tablet: Egal ob Apple oder Android, dieses eBook können Sie lesen. Sie benötigen dafür einen PDF-Viewer - z.B. die kostenlose Adobe Digital Editions-App.
Buying eBooks from abroad
For tax law reasons we can sell eBooks just within Germany and Switzerland. Regrettably we cannot fulfill eBook-orders from other countries.
aus dem Bereich
