Pro Oracle SQL Development
Best Practices for Writing Advanced Queries
| Price | $27.10 - $35.60
|
| Rating |  |
| Author | Jon Heller |
| Publisher | Apress |
| Published | 2019 |
| Pages | 596 |
| Language | English |
| Format | Paper book / ebook (PDF) |
| ISBN-10 | 1484245164 |
| ISBN-13 | 9781484245163 |
Write SQL statements that are more powerful, simpler, and faster using Oracle SQL and its full range of features. This book provides a clearer way of thinking about SQL by building sets, and provides practical advice for using complex features while avoiding anti-patterns that lead to poor performance and wrong results. Relevant theories, real-world best practices, and style guidelines help you get the most out of Oracle SQL.
Pro Oracle SQL Development is for anyone who already knows Oracle SQL and is ready to take their skills to the next level. Many developers, analysts, testers, and administrators use Oracle databases frequently, but their queries are limited because they do not have the knowledge, experience, or right environment to help them take full advantage of Oracle's advanced features. This book will inspire you to achieve more with your Oracle SQL statements through tips for creating your own style for writing simple, yet powerful, SQL. It teaches you how to think about and solve performance problems in Oracle SQL, and covers advanced topics and shows you how to become an Oracle expert.
Understand the power of Oracle SQL and where to apply it; Create a database development environment that is simple, scalable, and conducive to learning; Solve complex problems that were previously solved in a procedural language; Write large Oracle SQL statements that are powerful, simple, and fast; Apply coding styles to make your SQL statements more readable; Tune large Oracle SQL statements to eliminate and avoid performance problems.
- Jon Heller
5 5 8
Similar Books
by Karen Morton, Kerry Osborne, Robyn Sands, Riyaj Shamsudeen, Jared Still
Pro Oracle SQL unlocks the power of SQL in the Oracle Database - one of the most potent SQL implementations on the market today. To master it requires a three-pronged approach: learn the language features, learn the supporting features that Oracle provides to help use the language effectively, and learn to think and work in sets.You'...
Price: $5.83 | Publisher: Apress | Release: 2010
Oracle SQL Tuning Pocket Reference 
by Mark Gurry
One of the most important challenges faced by Oracle database administrators and Oracle developers is the need to tune SQL statements so that they execute efficiently. In this book, Mark Gurry shares his in-depth knowledge of Oracle's SQL statement optimizers. Mark provides solutions to many common problems that occur with both the r...
Price: $6.76 | Publisher: O'Reilly Media | Release: 2002
Pro REST API Development with Node.js
by Fernando Doglio
Pro REST API Development with Node.js is your guide to managing and understanding the full capabilities of successful REST development. API design is a hot topic in the programming world, but not many resources exist for developers to really understand how you can leverage the advantages.This book will provide a brief background on REST a...
Price: $50.65 | Publisher: Apress | Release: 2015
Progressive Web Application Development by Example
by Chris Love
Are you a developer that wants to create truly cross-platform user experiences with a minimal footprint, free of store restrictions and features customers want? Then you need to get to grips with Progressive Web Applications (PWAs), a perfect amalgamation of web and mobile applications with a blazing-fast response time.Progressive Web App...
Price: $31.02 | Publisher: Packt Publishing | Release: 2018
Professional Oracle 8i Application Programming with Java, PL/SQL and XML
by Michael Awai
This book is for professional Oracle database programmers who need a comprehensive roadmap of the new programming possibilities with Oracle 8i. On the other hand, if you are already developing with Java and XML this book will show you how to exploit PL/SQL and the enterprise features of Oracle 8i in optimally distributing your n-tier appl...
Price: $32.50 | Publisher: Wrox | Release: 2000
Programming Microsoft SQL Server 2012
by Leonard Lobel, Andrew Brust
Take your database programming skills to a new level - and build customized applications using the developer tools introduced with SQL Server 2012. This hands-on reference shows you how to design, test, and deploy SQL Server databases through tutorials, practical examples, and code samples. If you're an experienced SQL Server develop...
Price: $21.95 | Publisher: Microsoft Press | Release: 2012
Professional Microsoft SQL Server 2012 Integration Services
by Brian Knight, Erik Veerman, Jessica M. Moss, Mike Davis, Chris Rock
Microsoft SQL Server 2012 Integration Services (SISS) builds on the revolutionary database product suite first introduced in 2005. With this crucial resource, you will explore how this newest release serves as a powerful tool for performing extraction, transformation, and load operations (ETL). A team of SQL Server experts deciphers this ...
Price: $32.99 | Publisher: Wrox | Release: 2012
by Grant Allen, Bob Bryla, Darl Kuhn
Have you ever been faced with a new type of query to write, or been asked to create an unfamiliar database object? In such situations, you have probably wanted a good, solid example upon which to build, and instead have been forced into the drudgery of parsing railroad-style syntax diagrams in Oracle's manual set. This book frees you...
Price: $39.99 | Publisher: Apress | Release: 2009