Learning Oracle Database 19c

Focused View

Bob Bryla

2:00:02

48 View

01 - Introduction

01 - Learn Oracle Database Why 19c.mp4

00:56

02 - What you should know.mp4

01:05

thumbs.zip

02 - 1. Oracle Database Architecture

01 - Memory, storage, and processes.mp4

04:47

02 - Startup and shutdown.mp4

03:54

03 - Dynamic performance views (V$).mp4

02:14

03 - 2. Database Setup on Linux

01 - Prepare the OS for installation.mp4

06:23

02 - Run the Oracle 19c installer (Grid Infrastructure).mp4

05:02

03 - Run the Oracle 19c installer (Database).mp4

05:59

04 - 3. Database Navigation

01 - SQLcl command-line tool.mp4

03:57

02 - SQL Developer GUI.mp4

03:56

03 - Database Express.mp4

03:54

05 - 4. The Oracle SQL Language

01 - The ANSI SQL language standard.mp4

02:46

02 - PLSQL.mp4

03:23

06 - 5. SELECT Statements

01 - SELECT statements Capabilities and columns.mp4

03:26

02 - Use the WHERE clause.mp4

04:05

03 - SELECT statement transformations.mp4

05:27

04 - What are NULL values.mp4

03:34

05 - How to use NULL values.mp4

03:41

07 - 6. DML Statements

01 - Add rows to a table.mp4

03:43

02 - Delete rows from a table.mp4

03:15

03 - Update rows in a table.mp4

04:56

08 - 7. DDL Statements

01 - Create a table.mp4

05:56

02 - Drop a table.mp4

05:04

03 - Add or remove columns.mp4

04:30

09 - 8. Managing Tablespaces

01 - Create a tablespace.mp4

07:01

02 - Assign tablespaces to users.mp4

03:22

03 - Drop tablespaces.mp4

03:17

10 - 9. Security

01 - Create a user account.mp4

04:34

02 - Drop a user account.mp4

02:19

03 - Lock a user account.mp4

02:59

11 - Conclusion

01 - Next steps.mp4

00:37

thumbs.zip

Description

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.

More details

User Reviews

Rating

average 0

Total votes0

Focused display

Oracle SQL

Bob Bryla

Instructor's Courses

Linkedin Learning

View courses Linkedin Learning

LinkedIn Learning is an American online learning provider. It provides video courses taught by industry experts in software, creative, and business skills. It is a subsidiary of LinkedIn. All the courses on LinkedIn fall into four categories: Business, Creative, Technology and Certifications. It was founded in 1995 by Lynda Weinman as Lynda.com before being acquired by LinkedIn in 2015. Microsoft acquired LinkedIn in December 2016.