This course teaches learners how to make changes to database schemas and stored procedures without interrupting application traffic by utilizing unique Oracle Database features. The course covers online data movement, schema redefinitions, table reorganizations, and integration with DevOps tools for controlling code versioning. The teaching method includes demonstrations and examples of online application upgrades, database cloning, SQL development tools, versioning schema changes, and CI pipeline specifications. The course is designed for software developers, DevOps engineers, and database administrators looking to enhance their skills in managing database applications seamlessly.
How to Evolve Your Database Applications Entirely Online
Overview
Syllabus
Intro
Software Development DevOps concepts
OCI DevOps A complete
Online Application Upgrades with Rolling Deployments Application containers are usually stateless
Online Application Upgrades with Stateful Dependencies Databases are stateful, so what about incompatible schema changes?
Pipelining the Database Cloning An example: using Autonomous Database dones
Use the Right Tool for SQL Development SQLd integrales perfectly with CVCD pipelines
Generate and Apply Consistent and Repeatable Changes Versioning and controlling the schema changes
Build and Test at Every Code Merge in the Feature Branches A Partial Example of CI Pipeline Specification
Edition-Based Redefinition
Non-Editionable Objects Online Operations Optimized for mission-critical application workloads
Online Table Redefinition Where normal online operation cannot go, there is DBMS_REDEFINITION
Taught by
Oracle
