Oracle 21c Database Administration (DBA)

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.

• Oracle 21c DBA - all lectures 4:21:41

  • 1: Installation of Oracle Linux 8 on Oracle VM Preview 21:58
  • 2: Introduction to Oracle 21c Database 01:21
  • 3: Oracle 21c Architecture 17:46
  • 4: Practice 1 - Creating a CDB 43:37
  • 5: Practice 2 - Creating PDBs from the Seed 21:06
  • 6: Practice 3 - Performing Basic CDB Administration Tasks 32:43
  • 7: Practice 4 - Managing Common and Local Users 43:16
  • 8: Practice 5 - Backup and Recovery in CDB and PDBs 38:19
  • 9: Practice 6 - Flashback and Point-in-time Recovery 41:35

Oracle 21c DBA - Course Curriculum

1. Installation Of Oracle Linux 8 on Oracle VM
2. Introduction to Oracle 21c DBA
3. Oracle 21c Architecture
4. Practice 1 - Creating a CDB
5. Practice 2 - Creating PDBs from the Seed
6. Practice 3 - Performing Basic CDB Administration Tasks
7. Practice 4 - Managing Common and Local Users
8. Practice 5 - Backup and Recovery in CDB and PDBs
9. Practice 6 - Flashback and Point-in-time Recovery

Multi-model, multi-workload innovations

Oracle Database 21c is a multi-model database—it supports relational, JSON, XML, graph, spatial, OLAP, time series, blockchain data, and more. It’s also multi-workload, capable of handling transaction processing, analytics, machine learning, streaming, IoT, in-memory, and multi-tenant (i.e. database within a database) workloads.

Oracle refers to 21c as an “innovation release”—it comes with more than 200 new features and improvements. Oracle Database 21c is available today in Oracle Cloud Infrastructure on Always Free Autonomous Database and Database Cloud Service. Later this year, it will be available on-premises (Exadata, Linux) as well as on additional Oracle cloud services (Exadata Cloud Service X8M).

Oracle plans to “backport” some of the new capabilities in 21c to its predecessor, 19c, as a way of bringing that installed base up to par on the latest and greatest. (Oracle did not have a 20c database release due to the COVID-19 pandemic.)

The upgrade to Oracle’s flagship database includes performance and productivity improvements that will appeal to different cross-sections of Oracle’s customer base. For database administrators, that includes persistent memory, multi-tenant, and sharding. And for database users, from LOB analysts to data scientists, the attention-grabbers include automated machine learning, graph analytics, and more.

Oracle Database 21c highlights

• AutoML makes it easier for experts and non-experts alike to leverage machine-learning capabilities within the database and build ML models. New algorithms for anomaly detection, regression, and deep learning analysis have been added to the database’s library of ML algorithms.
• Persistent memory gives a performance boost to IO (input/output) workloads by storing data in local persistent memory. New algorithms prevent partial or inconsistent stores to persistent memory.
• "Sharding"Advisor assesses the database’s schema and workload and provides an optimal design. That’s helpful because sharding—the horizontal partitioning of database tables into smaller components for distribution—can be complex. But it’s also hugely helpful, both for data governance and to hyperscale databases. Backup and recovery across shards have also been automated.
• Graph Models, which are based on relationships in data sets from environments like social networks or IoT, gain higher performance in 21c (courtesy of memory optimization). For some customers, these graph capabilities may be an alternative to standalone graph databases such as Amazon Neptune or Neo4J.
• Native JSON data type, a new binary representation of JSON documents in 21c, results in more favorable comparisons to JSON/document databases from the likes of AWS, MongoDB, and others. In fact, Oracle says its SQL/JSON implementation is two times faster than MongoDB and AWS DocumentDB on the open source YCSB benchmark.
• Native Blockchain Tables provide in-database immutable, insert-only tables, where rows are “chained together” by cryptography. This type of tamper resistance helps protect against hacks and illicit changes. Angelini Pharma, a pharmaceutical company in Italy, is using blockchain tables in experiments with a wearable device integrated with a data-security tool.

Smartphone of Databases

Developers should also see productivity improvements in Oracle 21c. JavaScript has been added to the database, which means developers can now execute JavaScript code inside the database, where the data resides. Separately, Oracle announced that its low-code development platform, APEX, is available as a managed cloud service on Oracle Cloud Infrastructure.

What does the crystal ball tell us about the future of purpose-built databases versus converged databases? Who will win the strategy clash of specialized versus converged?

Mendelsohn compares it to the device proliferation of a generation ago, when many people owned and lugged around specialized devices: cell phones, cameras, video cams, MP3 players, GPS devices and hand-held voice recorders.

Then, people started buying iPhone and Android smartphones, which converged and replaced the one-off devices.

Everyone

Passion to learn and succeed!

• Oracle DBA
• Oracle Database Architect
• Oracle Cloud Database Administrator
• Oracle 21c Database Architect
• Data Engineer
• Data Modeler
• Machine Learning Engineer
• Data Scientist
• Data Analyst
• Oracle Cloud Platform Architect
• Software Developer
• Oracle Cloud Infrastructure Architect

Currently there are no Q&As for this course. Be the first to ask a question.

Reed courses certificate of completion

Digital certificate - Included

Uplatz Certificate of Completion

Digital certificate - Included