1. Oracle – Sunken Earth (Volume 1) (2011)
Author(s): C.W. Trisef
2. Oracle 12c: SQL (2015)
Author(s): Joan Casteel
Considered the best Oracle PL/SQL programming guide by the Oracle community, this definitive guide is precisely what you need to make the most of Oracle’s powerful procedural language. The sixth edition describes the features and capabilities of PL/SQL up through Oracle Database 12c Release 1.
Hundreds of thousands of PL/SQL developers have benefited from this book over the last twenty years; this edition continues that tradition. With extensive code examples and a lively sense of humor, this book explains language fundamentals, explores advanced coding techniques, and offers best practices to help you solve real-world problems.
- Get PL/SQL programs up and running quickly, with clear instructions for executing, tracing, testing, debugging, and managing code
- Understand new 12.1 features, including the ACCESSIBLE_BY clause, WITH FUNCTION and UDF pragma, BEQUEATH CURRENT_USER for views, and new conditional compilation directives
- Take advantage of extensive code samples, from easy-to-follow examples to reusable packaged utilities
- Optimize PL/SQL performance with features like the function result cache and Oracle utilities such as PL/Scope and the PL/SQL hierarchical profiler
- Build modular, easy-to-maintain PL/SQL applications using packages, procedures, functions, and triggers
Author(s): Steven Feuerstein, Bill Pribyl
4. Oracle Essentials: Oracle Database 12c (2013)
Written by Oracle insiders, this indispensable guide distills an enormous amount of information about the Oracle Database into one compact volume. Ideal for novice and experienced DBAs, developers, managers, and users, Oracle Essentials walks you through technologies and features in Oracle’s product line, including its architecture, data structures, networking, concurrency, and tuning.
Complete with illustrations and helpful hints, this fifth edition provides a valuable one-stop overview of Oracle Database 12c, including an introduction to Oracle and cloud computing. Oracle Essentials provides the conceptual background you need to understand how Oracle truly works.
- A complete overview of Oracle databases and data stores, and Fusion Middleware products and features
- Core concepts and structures in Oracle’s architecture, including pluggable databases
- Oracle objects and the various datatypes Oracle supports
- System and database management, including Oracle Enterprise Manager 12c
- Security options, basic auditing capabilities, and options for meeting compliance needs
- Performance characteristics of disk, memory, and CPU tuning
- Basic principles of multiuser concurrency
- Oracle’s online transaction processing (OLTP)
- Data warehouses, Big Data, and Oracle’s business intelligence tools
- Backup and recovery, and high availability and failover solutions
Author(s): Rick Greenwald, Robert Stackowiak
5. Oracle 12c For Dummies (2013)
Demystifying the power of the Oracle 12c database
The Oracle database is the industry-leading relational database management system (RDMS) used from small companies to the world’s largest enterprises alike for their most critical business and analytical processing. Oracle 12c includes industry leading enhancements to enable cloud computing and empowers users to manage both Big Data and traditional data structures faster and cheaper than ever before. Oracle 12c For Dummies is the perfect guide for a novice database administrator or an Oracle DBA who is new to Oracle 12c. The book covers what you need to know about Oracle 12c architecture, software tools, and how to successfully manage Oracle databases in the real world.
- Highlights the important features of Oracle 12c
- Explains how to create, populate, protect, tune, and troubleshoot a new Oracle database
- Covers advanced Oracle 12c technologies including Oracle Multitenant—the “pluggable database” concept—as well as several other key changes in this release
Make the most of Oracle 12c’s improved efficiency, stronger security, and simplified management capabilities with Oracle 12c For Dummies.
Author(s): Chris Ruel, Michael Wessler
A fully updated, integrated self-study system for the Oracle Database SQL Exam
This thoroughly revised Oracle Press guide offers 100% coverage of all objectives on the latest version of the Oracle Database SQL Exam. Ideal both as a study guide and on-the-job reference, OCA Oracle Database SQL Exam Guide (Exam 1Z0-071) features detailed explanations, examples, practice questions, and chapter summaries. “Certification Objectives,” “Exam Watch,” and “On the Job” sections reinforce salient points throughout. You will gain access to two complete practice exams that match the tone, tenor, and format of the live test.
Get complete coverage every topic on Exam 1Z0-071, including:
• DDL and SQL SELECT statements
• Manipulating, restricting, and sorting data
• Single-row and group functions
• Displaying data from multiple tables
• Schema objects
• Set operators
• Grouping related data
• Report creation
• Data dictionary views
• Large data sets
• Hierarchical retrieval
• Regular expression support
• User access control
The electronic includes:
• Two full practice exams
• Detailed answers and explanations
• Complete PDF copy of the book
Author(s): Steve O’Hearn
If you’re developing applications that access Oracle databases, you can save time and work by having SQL do more of the data handling for you: This new book shows you how. It teaches you how to create effective SQL queries to extract and update the data in an Oracle database. It teaches you how to design and implement a database, giving you insight into performance and security issues. It teaches you how to use PL/SQL to take advantage of powerful features like stored procedures, functions, and triggers. In short, it teaches you to create the kind of efficient database applications that make you a more effective and valuable developer.
Here are 5 of the ways that our book differs from the others
#1: You’ll see how to take advantage of the Oracle SQL Developer tool
SQL Developer is a free tool for working with database objects and SQL statements. Its graphical interface makes it more intuitive and easier to use than older command-line tools like SQL*Plus. I think you’ll find it boosts your productivity as you use it to write and run queries, to work with database objects, or to debug stored procedures.
#2: You’ll start off with how to query a database, not how to design one
This book is written for application developers, and the first thing an application developer needs to know is how to write queries. So that’s what’s covered in the first 8 chapters of this book. It starts with simple queries, then moves on to complex inner and outer joins, summary queries, and subqueries that do more of the database processing so that your applications can do less.
Once you’re comfortable with querying databases, this book shows how to design a database and how to create database tables. Having this background can help you query a database more effectively. And it provides a solid introduction to DBA skills if you’re interested in that career path.
#3: You get 2 books in 1: A SQL book and a PL/SQL book
PL/SQL allows you to write complex scripts, stored procedures, functions, and triggers, all essential skills for most application developers. So along with SQL, this book covers the PL/SQL that you’ll use most of the time; there’s no need to buy a second book to learn PL/SQL.
#4: Complete applications show you how all the pieces interact
One key to mastering SQL is to have plenty of coding examples that show how the features you re learning work and what problems you may run into as you use them on your own. So this book provides dozens of SQL statements and PL/SQL scripts for various jobs that are routine in business applications. Download the examples for free from our website and use them as starting points for your own SQL routines.
#5: The paired-pages format lets you set your own pace
Depending on what you already know about Oracle SQL and how fast you want to go, you can read every page and study each example…skim through the headings for topics you don’t know…scan through the righthand pages for development details you might have missed in the past…or turn to any two-page spread when you need reference information. The paired-pages format makes it easy and fast for you to use the book the way you want to.
(If you aren’t familiar with how the paired pages work, please be sure to download a sample chapter from our website)
Author(s): Joel Murach
8. Oracle – Fire Island (Volume 2) (2012)
Author(s): C.W. Trisef, Giuseppe Lipari
OCA, Oracle Certified Associate Java SE 8 Programmer I Study Guide, Exam 1Z0-808 is a comprehensive study guide for those taking the Oracle Certified Associate Java SE 8 Programmer I exam (1Z0-808). With complete coverage of 100% of the exam objectives, this book provides everything you need to know to confidently take the exam. The release of Java 8 brought the language’s biggest changes to date, and for the first time, candidates are required to learn functional programming to pass the exam. This study guide has you covered, with thorough functional programming explanation and information on all key topic areas Java programmers need to know. You’ll cover Java inside and out, and learn how to apply it efficiently and effectively to create solutions applicable to real-world scenarios.
- Work confidently with operators, conditionals, and loops
- Understand object-oriented design principles and patterns
- Master functional programming fundamentals
Author(s): Jeanne Boyarsky, Scott Selikoff
A century ago, outsiders saw China as a place where nothing ever changes. Today the country has become one of the most dynamic regions on earth. In Oracle Bones, Peter Hessler explores the human side of China’s transformation, viewing modern-day China and its growing links to the Western world through the lives of a handful of ordinary people. In a narrative that gracefully moves between the ancient and the present, the East and the West, Hessler captures the soul of a country that is undergoing a momentous change before our eyes.
Author(s): Peter Hessler
The Tao Oracle is a visual I-Ching- a beautiful and dazzling new tool for self transformation, enlightenment, and personal growth
“Meditation is that hundred and eighty degree turn that strengthens our capacity to trust, as it puts us in touch with a silent, guiding force that is far greater than ourselves in its wisdom, support and sustaining capacity. To relax into the flow of the Tao in its unfoldment is to experience being ‘at home in life.’ This meditation takes us to what has been called the still point, the center of the cyclone, the great silence, the inner Himalayan peaks.” –Ma Padma
The Tao Oracle is a “visual I-Ching.” It features no coins, no sticks, but cards featuring paintings, symbols, colors and key words, along with a clear, simple book to help you interpret the results. The Tao Oracle speaks to the individual through a language of archetypes and symbolism that can expose a deeper truth of the dynamics of change as it impacts our daily lives.
Author(s): Ma Deva Padma
12. Oracle – River of Ore (Volume 3) (2013)
Author(s): C.W. Trisef, Giuseppe Lipari