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.
Overview
Syllabus
Introduction
- Learn Oracle Database: Why 19c?
- What you should know
- Memory, storage, and processes
- Startup and shutdown
- Dynamic performance views (V$)
- Prepare the OS for installation
- Run the Oracle 19c installer (Grid Infrastructure)
- Run the Oracle 19c installer (Database)
- RPM Install
- SQLcl command-line tool
- SQL Developer GUI
- Database Express
- Cloud Database
- The ANSI SQL language standard
- PL/SQL
- SELECT statements: Capabilities and columns
- Use the WHERE clause
- SELECT statement transformations
- What are NULL values?
- How to use NULL values
- Add rows to a table
- Delete rows from a table
- Update rows in a table
- Create a table
- Drop a table
- Add or remove columns
- Create a tablespace
- Assign tablespaces to users
- Drop tablespaces
- Create a user account
- Drop a user account
- Lock a user account
- Next steps
Taught by
Bob Bryla