Breadcrumb

The short videos in this series teach you how to use Oracle Big Data SQL to perform common tasks for accessing and analyzing a variety of Big Data formats. In addition, you learn how to combine big data and Oracle relational data in your queries. Finally, you learn how to leverage Oracle performance and security features on all of your big data sources.

Note: The videos in this series are designed to be viewed in order.

This video shows you how to create an Oracle external table over JSON format data and query the JSON data via the external table using Oracle Big Data SQL.

This video shows you how to protect sensitive information for your big data sources by using Data Redaction with Oracle Big Data SQL.

This video shows you how to apply row-level security to your big data sources using Oracle Big Data SQL.

This video shows you how to create and query a kafka stream of current bike activity using Oracle Big Data SQL.

This video shows you how to create and use Materialized Views over internal and external tables to further improve performance of Big Data SQL queries.

This video shows you how to create an Oracle external table over HIVE format data and query the HIVE data via the external table using Oracle Big Data SQL.

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.
 

Gain insight into how Big Data works. Learn the step for implementing a big data project.

Watch this playlist on Oracle Big Data SQL. Learn about monitoring and tuning, Enterprise Manager, Cloudera Manager, and analyzing statistics.