Learning Oracle Database 19c

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

Concepts

0. Introduction

01 - Learn Oracle Database - Why 19c
02 - What you should know

1. Oracle Database Architecture

03 - Memory, storage, and processes
04 - Startup and shutdown
05 - Dynamic performance views (V$)

2. Database Setup on Linux

06 - Prepare the OS for installation
07 - Run the Oracle 19c installer (Grid Infrastructure)
08 - Run the Oracle 19c installer (Database)
09 - RPM Install

3. Database Navigation

10 - SQLcl command-line tool
11 - SQL Developer GUI
12 - Database Express
13 - Cloud Database

4. The Oracle SQL Language

14 - The ANSI SQL language standard
15 - PL SQL

5. SELECT Statements

16 - SELECT statements - Capabilities and columns
17 - Use the WHERE clause
18 - SELECT statement transformations
19 - What are NULL values
20 - How to use NULL values

6. DML Statements

21 - Add rows to a table
22 - Delete rows from a table
23 - Update rows in a table

7. DDL Statements

24 - Create a table
25 - Drop a table
26 - Add or remove columns

8. Managing Tablespaces

27 - Create a tablespace
28 - Assign tablespaces to users
29 - Drop tablespaces

9. Security

30 - Create a user account
31 - Drop a user account
32 - Lock a user account

Conclusion

33 - Next steps