• Oracle Big Data SQL Overview Tutorial Series

    At the end of this course, you should be able to:

    • Learn how to install and use the Oracle Big Data Lite (BDLite) Virtual Machine (VM).
    • Learn about the Apache Hadoop core and ecosystem components.
    • Identify some of the available and useful resources.
    • Describe how Oracle Big Data SQL enables dynamic and integrated access for all of your big data.
    • Compare the Hadoop, NoSQL, and RDBMS stores in terms of data ingest, disaster recovery, and data access. 
    • Use Oracle Big Data SQL to perform integrated data analysis with data in Oracle Database, Hadoop, and NoSQL.
    • Review Apache Hadoop and Oracle Big Data SQL architectures.
    • Create Oracle external tables over data in HDFS and Hive.
    • Understand the two components involved in deploying Oracle Big Data SQL.
    • Review the Oracle Big Data SQL performance features.
    • Describe how Information Lifecycle Management (ILM) can now be extended to use Hadoop to store raw and archived data.
    • Review the Oracle Big Data SQL security features. 

    Although you may view these lessons in any order, this series is designed in a linear fashion, with each tutorial building upon the previous ones. Therefore, if you are new to Big Data or Oracle Big Data SQL, it is recommended that you view these lessons in order.
     

    Release Date: 24-APR-2018

Content List (5)

  • Introduction to Oracle Big Data SQL

    Learn how to: 

    •    Install and use the Oracle Big Data Lite (BDLite) Virtual Machine (VM)
    •    Identify Apache Hadoop and its ecosystem 
    •    Identify some of the available resources on Oracle Big Data SQL Help Center, Oracle Learning Library (OLL), and Oracle University

    Duration: 24.45 minutes

    Duration: 24.45 minutes

  • Hadoop and Big Data SQL Architectures

    Learn how to: 

    •    Recognize the Apache Hadoop and Oracle Big Data SQL architectures
    •    Store data in HDFS
    •    Organize and describe data in Hive
    •    Deploy Oracle Big Data SQL using the two components:
    o    The enhanced “Big Data Enabled” Oracle Database 12c external tables 
    o    The Oracle Big Data SQL Servers (services) on the Oracle Big Data Appliance or DIY Hadoop Clusters (data local processing)
    •    Create Oracle external tables over data in HDFS and Hive using the following access drivers:
    o    ORACLE_HDFS
    o    ORACLE_HIVE
    •    Identify a list of additional Oracle Big Data SQL and Oracle SQL Developer and Data Modeler recourses

    Duration: 21.06 minutes

    Duration: 21.06 minutes

  • Oracle Big Data SQL Performance Features

    Learn how to: 

    • Review the Oracle Big Data SQL performance features
    • Identify Oracle Big Data SQL key performance features:
      • Hive Partition Pruning
      • Storage indexes
      • Smart Scan
      • Bloom filtering
      • Predicate and column projection pushdown
    • Identify where Oracle Big Data SQL fits in the Hadoop architecture layers
    • Use Oracle Big Data SQL to query data in Hadoop
    • List the Oracle Big Data SQL query processing Describe and Fetch steps 
    • Use Oracle Parquet driver
    • Use the performance features demo
       

    Duration: 20.46 minutes

    Duration: 20.46 minutes

  • Information Lifecycle Management

    Learn how to

    • Describe how ILM can now be extended to use Hadoop to store raw and archived data
    • Use one of the following resources in Oracle Big Data SQL to off-load Oracle Database tables to the HDFS file system on a Hadoop cluster:
      • Move Oracle Tablespace(s) to HDFS
      • Use Copy To Hadoop utility to copy Oracle data to HDFS
    • Identify a list of additional Oracle Big Data SQL recourses

    Duration: 21.52 minutes

    Duration: 21.52 minutes

  • Oracle Big Data SQL Security

    In this video, you will learn about

    • Oracle Big Data SQL security
    • Oracle Big Data SQL multi-user authorization

    Duration: 23.3 minutes

    Duration: 23.3 minutes

Create a Review

Be the first to create a review for this content item!

Buttons