Oracle 19c Database - An Introduction

Learn to download, install, and configure VMware Workstation on Windows or Linux, accept terms, manage licenses, and set up a virtual machine for testing and training.

Download and install Oracle Linux 7.6 in a VM, selecting the installation media and essential packages, configuring disk partitions and network, then complete post-install setup.

Install Oracle 19c software on a Linux machine by downloading and licensing the product, performing pre-configuration, setting network parameters, and creating the database with the proper directory structure and PDB.

Learn how to create an Oracle 19c database, configure storage and network, choose templates and options (single database, pdbs, container), and monitor with enterprise manager.

Learn two methods to drop an Oracle 19c database: use the database configuration system (with cloud control) or start in restricted mode to drop the data files.

Create, drop, and configure Oracle listeners to manage incoming connections and load balance across the database, and learn to start, stop, and register databases with the listener.

Learn how to manage Oracle 19c listeners by checking status, starting and stopping listeners, and registering databases to enable client connections and service availability.

Learn to back up Oracle 19c data by creating database, schema, and table backups, using file system paths, exporting data, and including tables, indexes, procedures, and functions.

Learn how to restore a database from backup, including schema and table level restores, by connecting to the database, selecting target objects, and applying relevant restore options.

Learn to create and drop users in an Oracle 19c database, grant connect and basic privileges, and connect to container and pluggable databases.

Explore dml operations in Oracle 19c by creating and dropping tables, and performing insert, update, delete, and select queries, then commit and backup data.

Explore how to connect and monitor an Oracle 19c database using Enterprise Manager Express, check the listener, ports, PDB status, and basic performance and SQL activity.

Download and install Oracle SQL Developer, connect to the database from a Linux machine, view tables and packages, and perform basic operations like querying users and creating or dropping objects.

Explore Oracle's multitenant architecture: a container database houses multiple pluggable databases under one container, easy plug-ins and plug-outs, and simplified upgrades.

Discover the Oracle data dictionary, a metadata store of database objects exposed via views like tables and indexes; learn to query these views for object details and access scope.

Explore Oracle 19c basics through official Oracle documentation, compare database administration and development paths, and use beginner guides on installation, backups, tuning, and SQL concepts.