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?
Return to Top
  • © Oracle
  • About Oracle
  • Contact Us
  • Products A-Z
  • Terms of Use & Privacy
  • Cookie Preferences
  • Ad Choices
  • © Oracle
.