cta quote button

Best Books to Help You Learn Oracle

Read More

How Much Does It Cost to Hire Web Developers in Ukraine?

Our pricing is completely transparent: you pay your engineers’ salaries and a flat monthly fee for our services. No hidden charges.

Read More

1. Oracle – Sunken Earth (Volume 1) (2011)

trisefbook.com/

Author(s): C.W. Trisef

2. Oracle 12c: SQL (2015)

Now you can master the latest version of the fundamental SQL language used in all relational databases today with ORACLE 12C: SQL, 3E. Much more than a study guide, this edition helps you transform a basic knowledge of databases into proficiency with the latest SQL and Oracle concepts and techniques. You learn to use Oracle 12c SQL most effectively as you prepare for the first exam in the Oracle Database Administrator or Oracle Developer Certification Exam paths. This edition initially focuses on creating database objects, including tables, constraints, indexes, sequences, manipulating data, and more. The author then explores both basic data query techniques as well as advanced query topics using a proven hands-on approach. ORACLE 12C: SQL, 3E introduces the latest features and enhancements in 12c, from enhanced data types and invisible columns to new CROSS and OUTER APPLY methods for joins. To help you transition to further studies and even more advanced books in this series, appendixes introduce SQL tuning, compare Oracle’s SQL syntax with other databases, and overview Oracle connection interface tools: SQL Developer and SQL Plus. Trust ORACLE 12C: SQL, 3E to provide the knowledge you need for Oracle certification testing and the solid foundation for pursuing a career as a database administrator or developer.

Author(s): Joan Casteel

3. Oracle PL/SQL Programming: Covers Versions Through Oracle Database 12c (2014)

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.

Topics include:

  • 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

6. OCA Oracle Database SQL Exam Guide (Exam 1Z0-071) (Oracle Press) (2017)

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
• Subqueries
• 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

7. Murach’s Oracle SQL and PL/SQL for Developers, 2nd Edition (2014)

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)

The adventure continues! With the first element (earth) painfully collected within the Oracle, Ret Cooper and his friends return home to find that things are only heating up. Thanks to some mischief caused by the peculiar Benjamin Coy, Ret’s second scar makes its explosive debut. But what does it mean, and where will it take them? These questions gnaw at Ret as he begins his sophomore year at Tybee High. With challenging twists, inspired turns, and a few unexpected surprises, our hero once again confronts danger and disaster, while discovering newfound feelings for a certain female companion. Old friends and foes, along with a few new ones, follow Ret as more of our world’s mysteries lead him to Fire Island and the second element (fire). Ancient artifacts, a hot-air balloon, lines in the desert, a city in the mountains, tribal societies, and even the navel of the world all play their parts in Ret’s continued quest to fill the Oracle. This second installment in the Oracle series is a must read, full of fun, adventure, and wholesome purpose. Hang on tight as author C.W. Trisef takes you to places and predicaments you have never seen before or even imagined, and makes you feel like you are a part of Ret’s destiny, to cure the world.

Author(s): C.W. Trisef, Giuseppe Lipari

9. OCA: Oracle Certified Associate Java SE 8 Programmer I Study Guide: Exam 1Z0-808 (2015)

Full coverage of functional programming and all OCA Java Programmer exam objectives

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

10. Oracle Bones: A Journey Through Time in China (2007)

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

11. Tao Oracle: An Illuminated New Approach to the I Ching (2002)

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)

Two elements collected (earth and fire). Will the pain from Sunken Earth ever subside? Will the smoke rising from Fire Island ever disperse? Will Ret, Ana, and Paige ever complete their sophomore year? No, not yet! A third scar has appeared, pointing them to a place where Mr. Coy refuses to go. Fortunately for him, a fourth scar surfaces, one that takes them to the Amazon Rainforest, the Sahara Desert, and ultimately the City of Gold. We follow our heroes across sea and sand—along rivers wet and dry—on a journey that spans multiple continents as they seek out the hiding place of the third element (ore). Organized or vigilante, trouble finds them at every turn in lands where deadly curses abound. Somewhere, between golden arches and ancient ruins, an age-old secret is waiting to be uncovered. But Ret’s enemies are multiplying, a grim reality that will try the hearts of his friends. And even while some romances bloom and others fade, Ret and the gang must stay on guard. The Oracle is wasting no time now, clearly hastening the gathering of its elements. Things are in full motion; Ret feels this. So does Lye; he is ready—and waiting.

Author(s): C.W. Trisef, Giuseppe Lipari