Hansen, Kim Berg
Practical Oracle SQL: Mastering the Full Power of Oracle Database
- ISBN 13:
- 9781484256169
- author:
- Hansen, Kim Berg
- format:
- Paperback
- publisher:
- APress
- language:
- English
- Publication Year:
- 2020
- Pages:
- 300
- Dimensions:
- 178 mm X 254 mm
- Genre:
- Computers, Server & Database, General Database,
- Condition:
- New
- Availability:
- Item usually sent within 20 working days
Description
Mastering the full power of Oracle Database requires more than just basic SQL skills. This comprehensive guide helps you unlock advanced features and build powerful queries that can transform your applications.
From pivoting rows to columns, using recursion with MODEL and WITH clauses, and applying set-based thinking to process more data in fewer queries, this book provides a step-by-step approach to building complex SQL statements. You'll learn how to recognize when modern SQL constructs can help create better applications and improve your query building skills.
Whether you're an Oracle Database developer looking to take your skills to the next level or simply want to optimize your existing queries, this book is for you. With practical examples and recipes, you'll be able to break complex calculations into smaller steps with subquery factoring and search for patterns across multiple rows using row pattern matching.
Related Products
Related Products
Mastering Oracle SQL
Mishra, Sanjay
Modern Oracle Database Programming: Level Up Your Skill Set to Oracle's Latest and Most Powerful Features in Sql, Pl/Sql, and Json
Nuijten, Alex
Learning Oracle PL/SQL
Pribyl, Bill
Study Guide for 1z0-146: Oracle Database 11g: Advanced PL/SQL
Morris, Matthew
Oracle PL/SQL Language Pocket Reference
Steven Feuerstein , Bill Pribyl , Chip Dawes