Oracle DB19c New Features for Developers
+
Introduction
About Oracle Database 19c
Acknowledgements
+
Get Started
-
Lab 1: Generate SSH Key
+
Lab 2: Environment Setup
+
Lab 3: Sample Schema Setup
Introduction
Task: Install Sample Data
Oracle Database Sample Schemas Agreement
Acknowledgements
+
Lab 4: Automatic Indexing
Introduction
Task 1: Verify sample data and drop indexes
Task 2: Logging In and Examining Schema
Task 3: Add Schemas
Task 4: Run a workload
Task 5: View Advisor Tasks
Task 6: Generate Workload
Task 7: Calculate a sales projection
Task 8: Automatic Indexing Results
Conclusion
Acknowledgements
+
Lab 5: Hybrid Partitioning
Introduction
Task 1: Create External Directories
Task 2: Review the current SALES table
Task 3: Rethink Storage Organization
Task 4: Implement Hybrid Partition Tables
Task 5: Compare internal and external partition operations
Task 6: Gathering Statistics
Conclusion
Acknowledgements
+
Lab 6: JSON in the Oracle DB
Introduction
Task 1: Environment Preparation
Task 2: Register for Geonames
Task 3: Generate JSON Data
Task 4: Store Json Documents Into Oracle Database
Task 5: Single Dot Notation
Task 6: Retrieve Sample Data
Acknowledgements
+
Lab 7: JSON in the Oracle DB - Advanced
Introduction
Task 1: Connect to the environment
Task 2: Retrieve Sub-Regions Information In JSON Format
Task 3: Retrieve Castles Information In JSON Format
Task 4: JSON_DATAGUIDE - discover information about the structure and content of JSON documents
Task 5: Syntax simplifications querying JSON Data
Task 6: JSON Query Improvements In Oracle 19C
Task 7: Using Custom Types And Wildcard
Task 8: Updating a JSON Document
Task 9: JSON Materialized View Support
Task 10: JSON-Object Mapping
Acknowledgements
+
Lab 8: Python Programming
Introduction
Task 1: Install Python
Task 2: The Python Interpreter
Task 3: Install Python Oracle module and connect to a database
Task 4: Querying the Oracle database
Task 5: Query a JSON table from PYTHON
Task 6: Load JSON data into a table using PYTHON
Conclusion
Acknowledgements
+
Need Help?
.