LinkedIn Google + Facebook YouTube Twitter
Build infinite skills
with project-based training videos
Oracle SQL and JSON Training Video

Oracle SQL and JSON Training Video

A Practical Training Course That Teaches Real World Skills

In this project-based Oracle SQL and JSON video tutorial series, you'll quickly have relevant skills for real-world applications.

Follow along with our expert instructor in this training course to get:

  • Concise, informative and broadcast-quality Oracle SQL and JSON training videos delivered to your desktop
  • The ability to learn at your own pace with our intuitive, easy-to-use interface
  • A quick grasp of even the most complex Oracle SQL and JSON subjects because they're broken into simple, easy to follow tutorial videos

Practical working files further enhance the learning process and provide a degree of retention that is unmatched by any other form of Oracle SQL and JSON tutorial, online or offline... so you'll know the exact steps for your own projects.

Share |
SKU: 02471 | Duration: 3 hours - 65 tutorial videos | Date Released: 2017-03-13
Works on: Windows PC or Mac | Format: Download | Instructor: Darryl Hurley

Table of Contents

expand all / collapse all

Course Description

Introduced as part of Oracle 12, Oracle JSON SQL makes it possible to convert the JSON data world of keys and values into the relational data world of columns and rows. At its core, this course teaches you how to use Oracle JSON SQL.

You'll learn the key JSON SQL functions that tell you: If the JSON data is valid, if a particular element and/or value exists in the JSON data, how to extract a specific scalar value from JSON data, and how to translate JSON keys and values into relational rows and columns. But this is more than a how-to-use JSON SQL course, it's a refresher course for those who need a solid understanding of the distinctions between the relational data world and the JSON data world, and how SQL can act as a bridge between the two.

* Explore the SQL methods that work for relational databases and JSON databases

* Learn about dot notation and how it's used to navigate through JSON elements

* Master the key JSON SQL functions: IS_JSON, JSON_EXISTS, JSON_VALUE, JSON_QUERY, and JSON_TABLE

* See how JSON_Table translates JSON keys and elements into relational rows and columns

* Learn about JSON indexes in comparison to relational indexes

* Understand how Oracle handles bad JSON data with the ERROR clause

* Watch how the Oracle optimizer translates JSON SQL into an effective query plan

Darryl Hurley is a senior level database engineer with Change Healthcare who specializes in Oracle database administration and PL/SQL programming. He has used SQL with Oracle since Oracle version 5, and speaks at Oracle User Group conferences. Darryl blogs at implestrat.com, and is the author of the O'Reilly title "Learning Oracle PL/SQL".

Unlimited Online Access

The O’Reilly Learning Library is now part of Safari

Broad, deep, and trustworthy information—everything from the Learning Library plus much more. 40,000 books, videos, and tutorials from 200+ pro publishers.

Try it Free
  • Learn the way you like to—video, audio, books, tutorials, lessons
  • Available anytime, anywhere—mobile, desktop, even offline
  • Find the exact information you need to solve a problem on the fly, or learn something new from the ground up.

100% Money Back Guarantee

Complete Customer Satisfaction is our goal. All O'Reilly Training DVDs come with a 100% money back guarantee. If you are not happy with your Training DVD just contact our sales department within 30 days of purchase for a refund. View our full terms and conditions


-->