Learning Oracle Database 19c

Learn the fundamentals of administering Oracle Database 19c. Discover how to install the RDBMS on Linux, efficiently move data in and out of tables, and more.

Introduction

• Learn Oracle Database: Why 19c?
• What you should know

1. Oracle Database Architecture

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

2. Database Setup on Linux

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

3. Database Navigation

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

4. The Oracle SQL Language

• The ANSI SQL language standard
• PL/SQL

5. SELECT Statements

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

6. DML Statements

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

7. DDL Statements

• Create a table
• Drop a table
• Add or remove columns

8. Managing Tablespaces

• Create a tablespace
• Assign tablespaces to users
• Drop tablespaces

9. Security

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

Conclusion

• Next steps