Connecting and working with Oracle Cloud DBaaS

Explore cloud computing and its on-demand resources, and learn how Oracle database as a service provides a fully functional Oracle database on a VM with metered pay as you use.

Create an Oracle Cloud account through cloud.oracle.com, claim $300 credit, verify email and phone, enter payment details, and access the cloud services dashboard; upcoming modules cover ssh and database creation.

Learn how SSH provides a secure client–server connection for Oracle Cloud DBaaS, using private and public keys to authenticate and establish a secured tunnel for commands and file transfers.

Learn to generate a 2048-bit private and public ssh key pair on Windows with PuTTYgen, export to OpenSSH format, and prepare the public key for Oracle Cloud DBaaS access.

Generate an ssh key pair on Ubuntu with ssh-keygen (RSA 2048), save keys in a keys directory, and use the private key to connect to Oracle Cloud database.

Sign in to Oracle Cloud, open the database service wizard, and create a database with a DB name and PDB; the module covers 12c multi-tenancy with container and pluggable databases.

connect to an Oracle Cloud DBaaS from a Linux terminal using ssh keys, the public IP and port, then sqlplus to verify 12c enterprise edition.

Connect to an Oracle Cloud database from Windows using SQL Developer, enable access rules, set up SSH, and test a connection to ORCL with demo PDBs.

Learn ssh tunneling to create a secure tunnel to a remote Oracle Cloud database. Use port forwarding to forward local requests to port 1521 through the tunnel.

Learn how to connect to an Oracle Cloud DBaaS instance using Toad for Oracle by creating an SSH tunnel with PuTTY, configuring port forwarding, and testing the connection.

Establish an SSH tunnel with Putty to access the Oracle Cloud database, then connect via a C program to localhost:7777 and insert a region record (7, Hello World) in HR.

Learn Oracle Cloud DBaaS fundamentals, including IaaS, PaaS, SaaS, and how to create and connect to cloud databases using SSH, tunneling, port forwarding, and tools like SQL Developer and Toad.