Foundation to Oracle Database in Oracle Cloud Infrastructure

Explore how cloud computing delivers computing resources as services over the internet, including servers, storage, databases, networking, software, analytics, and applications from data centers.

Discover how cloud computing reduces costs, speeds provisioning, and scales resources to boost productivity, performance, and reliability with mirrored data and availability domains.

Explore the three cloud service types - IaaS, PaaS, and SaaS - within a stacked model, from infrastructure to software, with examples like Oracle Cloud and pay-as-you-go resources.

Explore public, private, and hybrid cloud deployments, including how public clouds are provider-managed, cost-efficient, scalable, and reliable, while private clouds offer on-prem exclusivity and security. Discover how hybrid clouds blend both models and use cloud bursting to handle peak demand.

Analyze top cloud vendors using company filings and earnings data, revealing Microsoft as the leader, followed by AWS, IBM, and Oracle, with a focus on Oracle Cloud Infrastructure.

Explore Oracle Cloud’s IaaS, PaaS, SaaS, and DaaS layers, including Oracle databases, application servers, and ERP, HCM, CRM, with the BlueKai data marketplace, and preview the available services.

Discover Oracle cloud subscription models for IaaS and PaaS, including universal credit services and bring your own license. Compare metered and non-metered options and understand pricing for SaaS.

Explore the Oracle cloud cost estimator to compare pay-as-you-go and monthly-flex pricing for database services, adjusting instances and usage to estimate monthly costs.

Learn how to sign in to Oracle Cloud by creating a free account, selecting a data region, and entering email, verification code, and credit card details.

Sign up for Oracle Cloud using the try for free option, complete three simple steps, verify with a mobile code, and start using infrastructure and database services with free credits.

Sign in to the Oracle Cloud dashboard with your cloud account name, email, and password, then customize your my services view to show MySQL or big data compute edition.

Explore the features of Oracle cloud infrastructure, including data regions with availability domains, compartments and vcns, plus bare metal, virtualization, Exadata hardware, and lift and shift from on-prem to OCI.

Explore Oracle's second-gen cloud architecture, from fast connect and public internet to data regions with multiple availability domains. Learn off-box vcN virtualization and governance with compartments and IAM.

Oracle data regions provide disaster recovery and high availability through three availability domains per region, with low latency connections and service availability varying by region.

Explore shapes and ocpus to understand configurations, CPU cores, and RAM, learn how Oracle Compute Unit maps to physical processors with hyper-threading, and compare VM shapes where storage stays constant.

Oracle Cloud Infrastructure compartments provide security and isolation by organizing resources as logical containers, with each resource assigned to one compartment and shareable across compartments and vcns.

Explore how Oracle Cloud Infrastructure's virtual cloud network provides a software-defined network with subnets, routing tables, and gateways, using CIDR ranges across availability domains.

Block storage uses iSCSI volumes with dynamic provisioning and encryption at rest, attachable to running instances; object storage stores data as objects accessible via HTTP or APIs, independently for backups.

Create a demo compartment to organize resources and enforce isolation across cloud networks, compute instances, and block volumes, and avoid placing resources in the root compartment.

Create a virtual cloud network (VCN) in the demo compartment using the OCI dashboard; it auto-creates CIDR, internet gateway, a route table, and three subnets across availability domains.

Explore Oracle Database cloud deployment options—ODCS, Exadata Cloud Service, Exadata at Customer, Exadata Express, and schema cloud service—compare VM vs bare metal, editions, transparent data encryption, and pay-as-you-go vs monthly-flex.

Explore Oracle Exadata cloud service, delivering the full Exadata power in the cloud, with Oracle managing infrastructure while you control the database, RAC, in-memory, and active data guard.

Explore how Oracle Exadata Cloud@Customer brings a private on-premise Exadata cloud to your data center, offering identical Exadata service with low latency and Oracle-managed infrastructure.

Explore the Oracle database schema cloud service managed, a schema-based, non metered dev environment not a database, ideal for Apex web apps with 50 GB storage and fixed monthly pricing.

Deploy a database in Oracle Cloud Infrastructure Classic by creating an instance, configuring DB name and PDB, selecting license type and edition, and enabling SSH access.

Identify the main linux users in Oracle cloud environments, including OPC, Oracle user, grid user, and root, and learn when to use sudo to switch to root for tasks.

Learn how to generate RSA public and private keys on Unix, use ssh-keygen, protect the private key with a passphrase, and deploy the public key to cloud deployments.

Connect to an Oracle Cloud Infrastructure database deployment via a public IP with ssh, access the CDB and PDBs, and perform admin tasks as sysdba.

Learn how to connect to a bare metal Oracle Cloud database using the public IP address, log in as the OPC user, and become root to run admin commands.

Generate public and private keys in Windows using git bash from git for Windows, creating rsa keys with a passphrase in the user’s ssh folder for aws and oracle cloud.

Demonstrates connecting an AWS EC2 Windows instance to an Oracle Cloud VM DB server using Git Bash and SSH keys, adding the public key on OCI and accessing VM ORCL.

Demonstrate connecting from a Windows server to Oracle Cloud using Putty, converting the private key to ppk with Puttygen, and authenticating to a cloud instance.

Open a secure Oracle Cloud Infrastructure connection to the database using SQL Developer. Create an SSH tunnel from your local port to the remote listener when port 1521 is closed.

Continue your journey to the Oracle Cloud after completing foundation to Oracle Database in Oracle Cloud Infrastructure, carrying the excitement and learning you gained.

Explore Oracle autonomous databases, with self provisioning, self securing, self managing, self repairing, self scaling, and self optimizing, automating tasks and connectivity via REST APIs, including ATP and ADW variants.

Explore Oracle autonomous database variants ATP and ADW, with ATP for high performance transactions and real time analytics and ADW as an autonomous data warehouse.

Compare ADW and ATP: ADW uses columnar data for analytics, ATP uses row data for OLTP. Understand how parallelization, automatic indexing, and real-time statistics optimize performance for warehousing versus OLTP.

Learn to connect to an autonomous database using wallets: download the wallet with a password, set cloud wallet in SQL Developer, and test an ATP 18 high mode connection.

Provision an autonomous transaction processing database in Oracle Cloud Infrastructure by selecting ATP, a compartment, a display name, and workload type, then choose shared or dedicated infrastructure.