Learning Oracle Database 19c

2h 8mBeginner2023-12-21

Authors

Bob Bryla

30 years of experience in the database business

Course details

Get up and running with Oracle Database 19c, the latest version of the popular relational database management system (RDBMS), and learn how it can help enhance your database design and deployment process. Throughout this course, instructor Bob Bryla covers the fundamentals of administering Oracle Database 19c. Discover how to install the RDBMS on Linux, manage the database and query tables using the SQLcl command-line tool, and efficiently move data in and out of your database tables using SELECT and DML statements, respectively. Plus, learn how to create, assign, and drop tablespaces, as well as how to create and drop user accounts.

Learning objectives
Oracle database architecture
Setting up the database
Navigating the database with SQLcl and SQL Developer
The Oracle SQL language
Using SELECT statements
Adding, deleting, and updating rows in a table
Creating or dropping a table

Skills covered

Oracle DatabaseDatabase AdministrationOracleDatabase ManagementLearning

Concepts

Introduction

Learn Oracle Database - Why 19c
What you should know

Oracle Database Architecture

Memory, storage, and processes
Startup and shutdown
Dynamic performance views (V$)

Database Setup on Linux

Prepare the OS for installation
Run the Oracle 19c installer (Grid Infrastructure)
Run the Oracle 19c installer (Database)
RPM Install

Database Navigation

SQLcl command-line tool
SQL Developer GUI
Database Express
Cloud Database

The Oracle SQL Language

The ANSI SQL language standard
PL SQL

SELECT Statements

SELECT statements - Capabilities and columns
Use the WHERE clause
SELECT statement transformations
What are NULL values
How to use NULL values

DML Statements

Add rows to a table
Delete rows from a table
Update rows in a table

DDL Statements

Create a table
Drop a table
Add or remove columns

Managing Tablespaces

Create a tablespace
Assign tablespaces to users
Drop tablespaces

Security

Create a user account
Drop a user account
Lock a user account

Conclusion

Next steps