Complete Guide to Oracle Database 23ai: From Beginner to Advanced

Focused View

Kellyn Gorman

5:17:17

12 View

01 - Introduction

01 - Oracle 23ai Future-proof your tech journey.mp4

00:52

02 - An update about Oracle 23ai.mp4

00:35

03 - What you should know.mp4

02:10

04 - Getting set up for the Capstone project.mp4

02:18

02 - 1. Why Oracle

01 - Why Oracle.mp4

03:59

02 - New in Oracle 23ai.mp4

03:03

03 - New data types.mp4

04:41

04 - Miscellaneous new features.mp4

02:10

03 - 2. Oracle Basics Schema Objects

01 - Schema objects All about tables.mp4

02:43

02 - Indexing in Oracle 23ai.mp4

04:04

03 - Views, object views, JSON views, and materialized views.mp4

02:50

04 - Segment partitioning.mp4

02:18

05 - The data dictionary and dynamic performance views.mp4

03:20

06 - Capstone countdown Schema objects recap.mp4

00:40

04 - 3. Oracle Basics Transactions

01 - What is ACID.mp4

02:07

02 - Data concurrency.mp4

02:59

03 - Data consistency.mp4

03:57

04 - Data integrity.mp4

03:12

05 - SQL language.mp4

03:17

06 - PLSQL.mp4

04:28

07 - Interacting with the database.mp4

06:30

08 - Capstone countdown Transactions recap.mp4

00:31

05 - 4. Oracle Architecture

01 - Oracle physical architecture.mp4

05:11

02 - Oracle logical architecture.mp4

06:02

03 - Database configuration and logging.mp4

07:57

04 - Oracle memory and processes.mp4

10:24

05 - Capstone countdown architecture recap.mp4

00:32

06 - 5. Instance vs. Container Database (CDB)

01 - What is an Oracle instance.mp4

04:08

02 - Container database (CDB).mp4

02:40

03 - Pluggable databases (PDBs).mp4

03:06

04 - Oracle Real Application Clusters (RAC).mp4

04:21

05 - Oracle Data Guard.mp4

03:24

06 - Sharding architecture.mp4

04:35

07 - Oracle Net Services and application architecture.mp4

04:19

08 - Capstone countdown Instance vs. container database recap.mp4

00:38

07 - 6. Database Administration

01 - Role of a database administrator.mp4

04:28

02 - Overview of maximum availability architecture.mp4

03:32

03 - Understanding Oracle high availability.mp4

04:21

04 - Disaster recovery options.mp4

05:00

05 - Backing up and recovering using RMAN.mp4

03:46

06 - Capstone countdown Database administration recap.mp4

00:30

08 - 7. Security

01 - Security basics.mp4

02:29

02 - Authentication.mp4

03:19

03 - Authorization.mp4

03:16

04 - Account management.mp4

04:31

05 - Auditing.mp4

03:10

06 - Data governance in Oracle.mp4

03:13

07 - New security features with 23ai.mp4

02:46

08 - Capstone countdown Security recap.mp4

00:27

09 - 8. Advanced Security

01 - Reversible and irreversible data protection.mp4

02:20

02 - Data obfuscation.mp4

02:57

03 - Data masking.mp4

03:00

04 - Transparent Data Encryption (TDE).mp4

03:35

05 - Network encryption.mp4

03:49

06 - Database Firewall.mp4

02:56

07 - Capstone countdown Advanced security recap.mp4

00:28

10 - 9. Optimizing Performance

01 - Introduction to performance optimization.mp4

02:35

02 - Instance tuning.mp4

05:10

03 - Understanding the AWR report.mp4

04:09

04 - ASH, ADDM, and the rest of AWR.mp4

03:46

05 - SQL tuning.mp4

05:49

06 - SQL tracing.mp4

03:16

07 - Cost-based optimizer.mp4

05:05

08 - Performing an optimization exercise.mp4

04:26

09 - Capstone countdown Optimizing performance recap.mp4

00:36

11 - 10. Oracle 23ai Capstone Getting Prepared

01 - Capstone introduction and prerequisites.mp4

09:27

02 - Assignment Navigating the database hierarchy.mp4

01:46

03 - Walkthrough Navigating the database hierarchy.mp4

08:55

12 - 11. Oracle 23ai Capstone Admin Tasks

01 - Assignment Starting and stopping databases.mp4

00:55

02 - Walkthrough Starting and stopping databases.mp4

04:50

03 - Assignment Configuring and managing space.mp4

01:08

04 - Walkthrough Configuring and managing space.mp4

04:23

05 - Assignment User management.mp4

01:28

06 - Walkthrough User management.mp4

06:06

13 - 12. Oracle 23ai Capstone Cloning a Database

01 - Assignment Cloning a pluggable database.mp4

01:04

02 - Walkthrough Cloning a pluggable database.mp4

05:06

14 - 13. Oracle 23ai Capstone Archiving for Point-in-Time Recovery

01 - Assignment Turning on archiving for point-in-time recovery.mp4

02:44

02 - Walkthrough Turning on archiving for point-in-time recovery.mp4

08:28

15 - 14. Oracle 23ai Capstone Working with Data

01 - Assignment Create a sales summary schema owner user.mp4

01:15

02 - Walkthrough Create a sales summary schema owner user.mp4

06:56

03 - Assignment Create reporting data.mp4

02:13

04 - Walkthrough Create reporting data.mp4

08:53

05 - Assignment Manipulate data.mp4

02:58

06 - Walkthrough Manipulate data.mp4

10:32

16 - 15. Oracle 23ai Capstone Managing the Optimizer

01 - Assignment Create an explain plan.mp4

01:29

02 - Walkthrough Create an explain plan.mp4

06:57

17 - Conclusion

01 - Further learning with Oracle 23ai.mp4

00:58

Description

As open-source technology becomes more standard, this course highlights the importance of robust, mature, and fully-supported relational database systems. Join instructor Kellyn Gorman as she guides you on your journey toward becoming a proficient database administrator, covering the robust features, innovative enhancements, and powerful capabilities of Oracle 23ai. Kellyn helps equip you with the comprehensive knowledge and skills required to effectively manage Oracle Database systems, the most widely used in enterprise environments, and to manage much of the most critical business data. By delving into Oracle's intricacies, you’ll gain a deep understanding of how to design, implement, and maintain robust and high-performing database systems, making them indispensable assets to organizations that rely on Oracle technology.

More details

User Reviews

Rating

average 0

Total votes0

Focused display

Oracle Cloud

Kellyn Gorman

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.