Installation of Oracle Linux 8 on Oracle VM

Course overview

Uplatz provides this in-depth course on Oracle 21c DBA. It is a self-paced course consisting of video lectures. You will be awarded Course Completion Certificate at the end of the course.

Oracle Database 21c is a converged database that delivers a high performance, highly available, secure and scalable data management platform for cloud as well as on-premises environments.

The database market is branching in many directions as database providers develop platforms for every conceivable use case. Relational, analytics, document, key-value, graph, spatial, in-memory—there’s a special-purpose database for nearly every conceivable data type and workload.

Oracle’s answer to the specialty database trend is Oracle Database 21c, a "converged database" that features improved support for JSON data types, graph models, and other capabilities found in purpose-built databases. Oracle Database 21c is making developers and analysts much more productive to have just one database to manage all of their data, in any workload.

The 21c generation of Oracle's converged database offers customers; best of breed support for all data types (e.g. relational, JSON, XML, spatial, graph, OLAP, etc.), and industry leading performance, scalability, availability and security for all their operational, analytical and other mixed workloads.

Oracle Database 21c is the latest and greatest way to get the latest and greatest technologies out to our customers so as they start considering new applications, they can start now and be ready for the next long term support release. Our current long term support release is Oracle Database 19c.

Oracle Database 21c enables SQL, REST and API transactions across all types of data models. It is being released cloud-first with on-premises following shortly after. Some key innovations are:

• Native JSON binary data type
• Blockchain Tables
• Execute JavaScript code inside the Oracle Database
• Auto machine learning with Python
• Enhancements for sharding, database in-memory and graph analytics.
• APEX updates including automatic faceted search, one-click remote deployment and more.

With Oracle 21c , customers can

• Reduce IT cost and complexity
• Unlock innovation
• Develop powerful, data-driven applications

Why Oracle Database 21c?

• It is ideal for organizations driven by data or those who store and manage data in a converged database, which is a practice known for its efficiency, productivity, and data cocooning. Converged databases leveraging Oracle 21c databases support all data types such as relational, spatial, XML, JSON, graph, and OLAP while delivering swift scalability and unparalleled performance for operational, analytical, and other mixed workloads.
• Oracle Database 21c is a notable product for enterprises leveraging Blockchain, as it fosters the promising technology with the introduction of Blockchain Tables. Explore more here. Along the similar lines, Oracle Database 21c also comes built in with in-database machine learning (ML) algorithms, enabling data scientists rapidly build predictive models.
• Oracle Database 21c includes support for PMEM file systems that can offer significant latency and bandwidth improvements over traditional file systems that use SSD or spinning disks.

Oracle Database 21c for Modern Cloud Applications

Enterprise Application Adoption of 19c and leap forward with data warehouses to 21c

Oracle 21c cloud release for data warehouses

• Upgrade methods
• Upgrade approaches
• Key Features
• Optimizer
• Blockchain Tables
• Native JSON Datatype
  
  • In Oracle Database 21c, JSON support is further enhanced by offering a Native data type, “JSON”. This means that instead of having to parse JSON on read or update operations.
• Executing JavaScript inside Oracle Database
• SQL Macros

As such, Oracle's all-in-one cloud database stands in stark contrast to competitors such as AWS, which offers 16 different standalone databases, and Snowflake, a data warehouse specialist with one single-purpose database. Google, Microsoft, MongoDB and many other vendors also sell purpose-built databases that are optimized for specific use cases.

This abundance of choice in database platforms is valuable, of course, but data management can get complex and unwieldy as disparate systems proliferate in the data center - usually arriving one at a time - to meet each and every business requirement. The challenges of a mixed database environment include data integration, transactions, disaster recovery, and security.