Oracle Cloud Infrastructure (OCI) - Essentials

Compare on premises and cloud through a kitchen versus restaurant analogy, and identify infrastructure as a service, platform as a service, and software as a service.

Define cloud computing from a technical perspective as on-demand network access to a shared pool of configurable resources, including infrastructure, platform, and software services, with rapid elasticity.

Examine cloud service models—iaas, paas, and saas—and how vendors like Microsoft and Oracle offer both saas and paas, using compute instances to build and customize platforms.

Compare on-premises and cloud deployment models, highlighting private, public, and hybrid clouds, and explain advantages, costs, and customization limits of cloud versus on-premises ERP systems.

Explore how to sign up for Oracle Cloud free tier, including always free services, autonomous database, and compute virtual machines for building prototypes or learning.

Discover Oracle cloud infrastructure offerings, focusing on compute services, virtual machines and Linux images, plus the integrated database service within IaaS, with hands-on exercises on Linux instances and autonomous database.

Discover how the autonomous database in the cloud is self driving, self securing, and self repairing, eliminating provisioning, monitoring, and backups, while reducing dependency on database administrators.

Explore autonomous database on OCI, manage lifecycle (start, stop, restart, terminate), leverage data analytics and machine learning features, visualize results, and develop apps with Oracle Application Express.

Register with Oracle Cloud and log in using the emailed credentials to access the autonomous database; explore the free trial and always free provisioning steps.

Explore radius tools for the autonomous database, including database actions, SQL query tools, data modeler options, data load from spreadsheets, and Oracle Machine Learning with Oracle Apex for web development.

Explore connecting to Oracle autonomous database via the SQL developer web, loading spreadsheet data, executing statements, and creating visualizations with built-in reporting, Oracle Application Express, and machine learning tools.

Create a table in the autonomous database and load data into it using Oracle Cloud, scripts, and a data file, then verify with a select.

learn how to create a table with the vector data type in oracle 23 i, insert two-dimensional vectors, and query the closest vector using euclidean distance.

Explore similarity search on vector data, compare Euclidean distance and cosine angle, and filter results by size, shape, and color to retrieve nearest vectors.

Create and sign in to an Oracle APEX workspace in OCI, configure the admin user, and explore sample data, SQL querying, and forms-based app building for reporting.

Explore Oracle APEX navigation and core workspaces, including the top menu, builder, object browser, sample dataset, and page designer, and learn to run, import, export, and modify apps.

Load data from a spreadsheet into Oracle APEX and build a reporting application in the cloud. Create charts and reports from loaded tables and run the app to view results.

Install and explore a sample database application in Oracle APEX, view its department and employee pages, tables, and reports, and learn how autonomous database supports building apps with Oracle APEX.